Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 3rd October 2012, 09:13
electronico_nc electronico_nc is offline
Join Date: Oct 2012
Posts: 68
Thanks: 13
Thanked 5 Times in 5 Posts
Default Questions about v2.2.32, email accounts and others

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.

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 by electronico_nc; 3rd October 2012 at 09:33. Reason: added infos about versions
Reply With Quote
Sponsored Links
Old 3rd October 2012, 13:56
till till is online now
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,012
Thanks: 840
Thanked 5,651 Times in 4,461 Posts

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 Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Old 3rd October 2012, 22:24
electronico_nc electronico_nc is offline
Join Date: Oct 2012
Posts: 68
Thanks: 13
Thanked 5 Times in 5 Posts

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.
mysql_upgrade -u root -h localhost -p --verbose --force
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.

rm -R /var/lib/mysql/nul
fixed the problem.
I'll let you know if something goes wrong following the perfect setup

Last edited by electronico_nc; 3rd October 2012 at 22:41. Reason: added answer to this particular temporary question
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT +2. The time now is 18:00.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.