Questions about v2.2.32, email accounts and others

Discussion in 'Installation/Configuration' started by electronico_nc, Oct 3, 2012.

  1. electronico_nc

    electronico_nc Member

    Hi all,

    Story in short :

    ISPConfig 2.2.32 installed on a VDS running Debian Lenny (5.0.10) with no updates since 2009.
    Customer complained that a whole site has been deleted.

    Main things done :
    Updated /etc/apt/sources.list to debian archives to get updates
    Updated Lenny to Squeeze
    Installed fail2ban and logwatch
    Started bastille-firewall

    As the customer's webmaster has left the company, ISP admin email has to be changed.
    Basically a user email has been created (through ISPConfig) : [email protected]
    with a password.

    But I can't access to the created user email account (via an email client), neither via telnet from localhost.
    I noticed [email protected] has a user_passwort field filled in isp_isp_user table (other email users don't have user_passwort filled) and status was set to 'n' (other email users don't have status filled).
    Decided to delete [email protected] email -> now status=d in isp_isp_user table.
    I can't create it again -> I'm told user exists

    Question1 : Can I safely delete the isp_isp_user entry for [email protected] to create this user again ?

    I had a look at /etc/shadow and there is no entry for [email protected]

    Question2 : Did I broke something in ISPConfig by upgrading OS from Lenny to Squeeze ?
    Question3 : What is the email password encryption in isp_isp_user table ? (doesn't look like SHA1, MD5 or crypt)
    Question4 : Can I safely update ISPConfig to 2.2.40 ?

    Thanks in advance for your help.
    Regards.

    Edition :
    php --version
    PHP 5.3.3-7+squeeze14 with Suhosin-Patch (cli) (built: Aug 6 2012 14:18:06)
    Copyright (c) 1997-2009 The PHP Group
    Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
    with XCache v1.3.0, Copyright (c) 2005-2009, by mOo
    with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH

    apache2 -v
    Server version: Apache/2.2.16 (Debian)
    Server built: Sep 13 2012 02:54:14

    mysql> SHOW VARIABLES LIKE "%version%";
    +-------------------------+-------------------+
    | Variable_name | Value |
    +-------------------------+-------------------+
    | protocol_version | 10 |
    | version | 5.1.63-0+squeeze1 |
    | version_comment | (Debian) |
    | version_compile_machine | x86_64 |
    | version_compile_os | debian-linux-gnu |
    +-------------------------+-------------------+


    mysql --version
    mysql Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (x86_64) using readline 6.1
     
    Last edited: Oct 3, 2012
    electronico_nc, Oct 3, 2012
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    1) No. You just missed to empty the recycle bin.
    2) Thats possible. After a dist upgrade you should go trogh the perfect setup guide for the new dist version and ispconfig version that you sue and install missing packages and ispconfig might have to be updated afterwards.
    3) the default one from linux, crypt with salt.
    4) take a look at the perfect setup guide for debian squeeze, it might be nescessary to patch a line in libc.
     
    till, Oct 3, 2012
    #2
  3. electronico_nc

    electronico_nc Member

    Hello Till,
    Thanks for the reply !

    1) I can't empty recycle bin , when I select it :
    2) looking/following the perfect setup for Squeeze/ISPConfig2
    libdb4.8-dev replaced libdb4.6-dev
    libmysqlclient-dev replaced libmysqlclient15-dev

    Problem at mysql restart :
    Code:
    ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
ERROR 1558 (HY000) at line 1: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50051, now running 50163. Please use mysql_upgrade to fix this error.
    ran:
    Code:
    mysql_upgrade -u root -h localhost -p --verbose --force
    answer:
    Code:
    mysqlcheck: Got error: 1049: Unknown database 'nul' when selecting the database
FATAL ERROR: Upgrade failed
    There is a database called 'nul' (which is not used by them from customer answer). I can see it via phpmyadmin and MySQL command line, but I can't delete it :
    Code:
    mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ispconfig          |
| mysql              |
| nul                |
| web13db1           |
| web13db2           |
| web16db1           |
| web17db1           |
| web19db1           |
| web1db1            |
| web1db2            |
| web1db3            |
| web1db4            |
| web20db1           |
| web21db1           |
| web22db1           |
| web23db1           |
| web29db1           |
+--------------------+
34 rows in set (0.00 sec)
    (customer's names have been manually removed from the SHOW DATABASES output)
    Code:
    mysql> DROP DATABASE nul;
ERROR 1008 (HY000): Can't drop database 'nul'; database doesn't exist
    Thanks again for any track.

    Edition:
    Code:
    rm -R /var/lib/mysql/nul
    fixed the problem.
    I'll let you know if something goes wrong following the perfect setup
     
    Last edited: Oct 3, 2012
    electronico_nc, Oct 3, 2012
    #3

Share This Page