ISPConfig vs mysql 5 update

Discussion in 'Installation/Configuration' started by Dy0nisus, May 28, 2007.

  1. Dy0nisus

    Dy0nisus New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. Dy0nisus

    Dy0nisus New Member

    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 :(
     
  4. Dy0nisus

    Dy0nisus New Member

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

    so still the ispconfig issue ...
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  6. Dy0nisus

    Dy0nisus New Member

    i only see

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

    till Super Moderator Staff Member ISPConfig Developer

    Please post the output of:

    df -h

    ls -la /root/ispconfig/
    ls -la /home/admispconfig/
     
  8. Dy0nisus

    Dy0nisus New Member

    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
    
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  10. Dy0nisus

    Dy0nisus New Member

    now it works ... thanks till :)
     

Share This Page