HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   ISPConfig vs mysql 5 update (http://www.howtoforge.com/forums/showthread.php?t=12979)

Dy0nisus 28th May 2007 11:13

ISPConfig vs mysql 5 update
 
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:

Code:

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 28th May 2007 13:45

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 28th May 2007 18:05

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

Code:

[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:

Code:

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 28th May 2007 18:17

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

so still the ispconfig issue ...

till 28th May 2007 18:23

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 28th May 2007 18:34

i only see

Code:

-rw-------  1 admispconfig admispconfig    25 2007-05-28 16:36 sess_53e52f60e47d3815946398a84bc032ed
in /tmp/ ?

till 28th May 2007 18:37

Please post the output of:

df -h

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

Dy0nisus 28th May 2007 18:39

Code:

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

Code:

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

Code:

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 29th May 2007 09:47

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 29th May 2007 11:03

now it works ... thanks till :)


All times are GMT +2. The time now is 09:04.

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