#1  
Old 28th May 2007, 12:13
Dy0nisus Dy0nisus is offline
Member
 
Join Date: Jan 2007
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 28th May 2007, 14:45
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 28th May 2007, 19:05
Dy0nisus Dy0nisus is offline
Member
 
Join Date: Jan 2007
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 28th May 2007, 19:17
Dy0nisus Dy0nisus is offline
Member
 
Join Date: Jan 2007
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

so still the ispconfig issue ...
Reply With Quote
  #5  
Old 28th May 2007, 19:23
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 28th May 2007, 19:34
Dy0nisus Dy0nisus is offline
Member
 
Join Date: Jan 2007
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i only see

Code:
-rw-------  1 admispconfig admispconfig    25 2007-05-28 16:36 sess_53e52f60e47d3815946398a84bc032ed
in /tmp/ ?
Reply With Quote
  #7  
Old 28th May 2007, 19:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

Please post the output of:

df -h

ls -la /root/ispconfig/
ls -la /home/admispconfig/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 28th May 2007, 19:39
Dy0nisus Dy0nisus is offline
Member
 
Join Date: Jan 2007
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Code:
h740154:~# df -h
Dateisystem          Gre Benut  Verf Ben% Eingehngt 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
Reply With Quote
  #9  
Old 29th May 2007, 10:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 29th May 2007, 12:03
Dy0nisus Dy0nisus is offline
Member
 
Join Date: Jan 2007
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

now it works ... thanks till
Reply With Quote
Reply

Bookmarks

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig Update and SSL disasm Installation/Configuration 3 12th October 2008 15:55
ISPConfig 2.2.13 released till General 35 23rd July 2007 17:28
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
ISPConfig: Install: mysql: unknown variable 'db-name=default' dreger Installation/Configuration 3 30th July 2006 23:23
ISPConfig 2.2.4 released till General 25 18th July 2006 14:04


All times are GMT +2. The time now is 17:22.


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