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/ ?