ISPConfig vs mysql 5 update

[Dy0nisus]

Hello!

I made a big mistake this night ...

connected to the wrong server i made a "apt-get dist-upgrade" so mysql was updated from version 4 to version 5 on my productive ISPConfig - Server. After a few other minor problems i checked the function of ISPConfig Interface. It doesn't work anymore.

This ist the error message after login:


Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php:77) in /home/admispconfig/ispconfig/web/login/login.php on line 60


I need some odeas how to fix it :)

greetz

[till]

Please download the latest ISPConfig version and run setup, so ISPConfig will be recompiled and upadted for mysql5. Make sure that you have the mysql client development files installed from your linux distribution.

[Dy0nisus]

hm ... i did qhat u said ... result is that apache2 won't start anymore

[Mon May 28 17:57:07 2007] [notice] SIGHUP received. Attempting to restart
unable to start piped log program '/root/ispconfig/cronolog --symlink=/var/log/httpd/ispconfig_access_log /var/log/httpd/ispconfig_access_log_%Y_%m_%d': No such file or directory
Unable to open logs
unable to start piped log program '/root/ispconfig/cronolog --symlink=/var/log/httpd/ispconfig_access_log /var/log/httpd/ispconfig_access_log_%Y_%m_%d': No such file or directory
Unable to open logs
unable to start piped log program '/root/ispconfig/cronolog --symlink=/var/log/httpd/ispconfig_access_log /var/log/httpd/ispconfig_access_log_%Y_%m_%d': No such file or directory
Unable to open logs


ISPConfig - Apache won't start, too:

Alle Voraussetzungen erfuellt.
Here we go...


Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /install/install_ispconfig/install.php on line 685
Could not connect to db db_ispconfig
Neustart einiger Dienste...
./setup2: line 1135: [: ==: unary operator expected
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running
ISPConfig system stopped!
Starting ISPConfig system...
fopen: No such file or directory
ispconfig_httpd: could not open document config file /root/ispconfig/httpd/conf/httpd.conf
/root/ispconfig/httpd/bin/apachectl startssl: httpd could not be started
Could not open input file: /root/ispconfig/scripts/shell/firewall.php
ISPConfig system is now up and running!
Herzlichen Glueckwunsch! Ihr ISPConfig-System ist jetzt installiert. Falls Sie Quota nachinstalliert haben, fuehren Sie noch die in der Installationsanleitung beschriebenen Schritte durch. Ansonsten ist Ihr System jetzt ohne Reboot einsatzbereit.


not good :(

[Dy0nisus]

after commenting out the log parameters of ISPConfig in /etc/apache2/apache2.conf apache works again ...

so still the ispconfig issue ...

[till]

The above errors mean that ISPConfig is not installed completely on your server. It looks as you did not install the mysql client development files for mysql 5 before you updated ISPConfig.

Please make sure that you do not delete the 3 backup files created by the ispconfig installer in your /tmp directoyr. Copy them to a safe location in case we need them to restore your system.

Then install the mysql5 client development files and the mysql5 client pacakge from your linux distribution. The run:

mkdir /root/ispconfig

and unpack and run the ISPConfig setup again. Also make sure that you add the log parameters in apache2.conf again that you commented out after ISPConfig jas been installed again.

[Dy0nisus]

i only see

-rw------- 1 admispconfig admispconfig 25 2007-05-28 16:36 sess_53e52f60e47d3815946398a84bc032ed


in /tmp/ ?

[till]

Please post the output of:

df -h

ls -la /root/ispconfig/
ls -la /home/admispconfig/

[Dy0nisus]

h740154:~# df -h
Dateisystem Größe Benut Verf Ben% Eingehängt auf
/dev/md1 150G 15G 128G 11% /
tmpfs 507M 0 507M 0% /lib/init/rw
tmpfs 507M 4,0K 507M 1% /dev/shm
/dev/md0 54M 18M 33M 36% /boot


h740154:~# ls -la /root/ispconfig/
insgesamt 28
drwxr-xr-x 6 root root 4096 2007-05-28 17:57 .
drwxr-xr-x 9 root root 4096 2007-05-28 18:15 ..
-rw-r--r-- 1 root root 1685 2007-05-28 17:57 dist.inc.php
drwxr-xr-x 12 root root 4096 2007-05-28 17:47 httpd
drwxr-xr-x 3 root root 4096 2007-05-28 17:57 isp
drwxr-xr-x 6 root root 4096 2007-05-28 17:46 openssl
drwxr-xr-x 6 root root 4096 2007-05-28 17:57 php


h740154:~# ls -la /home/admispconfig/
insgesamt 24
drwxr-xr-x 4 admispconfig admispconfig 4096 2007-01-12 01:23 .
drwxrwsr-x 12 root staff 4096 2007-02-21 18:16 ..
-rwxr-xr-x 1 admispconfig admispconfig 24 2007-01-12 01:49 .forward
drwxr-xr-x 8 admispconfig admispconfig 4096 2007-05-24 01:29 ispconfig
drwxr-xr-x 2 admispconfig admispconfig 4096 2007-05-28 11:30 mailstats
-rwxr-xr-x 1 admispconfig admispconfig 176 2007-01-12 01:49 .procmailrc

[till]

That looks ok so far. Please try to update ISPConfig again. When you install ISPConfig, please download it to e.g. /usr/src/ and unpack it there and not to /tmp as it might be that your /tmp dir has run full during update.

[Dy0nisus]

now it works ... thanks till :)