Questions about v2.2.32, email accounts and others

[electronico_nc]

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) : server@domain.tld
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 server@domain.tld 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 server@domain.tld 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 admin@domain.tld to create this user again ?

I had a look at /etc/shadow and there is no entry for admin@domain.tld

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

[till]

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.

[electronico_nc]

Hello Till,
Thanks for the reply !

1) I can't empty recycle bin , when I select it :

The system is currently updating the configuration files.

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 :

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:

mysql_upgrade -u root -h localhost -p --verbose --force

answer:

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 :

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)

mysql> DROP DATABASE nul;
ERROR 1008 (HY000): Can't drop database 'nul'; database doesn't exist

Thanks again for any track.

Edition:

rm -R /var/lib/mysql/nul

fixed the problem.
I'll let you know if something goes wrong following the perfect setup