Upgradeded to mysql4.1 breaks mysql client

Discussion in 'Installation/Configuration' started by PoleCat, Apr 17, 2008.

  1. PoleCat

    PoleCat New Member

    Heya,

    I have upgraded mysql 4.0 to 4.1 on Debian Sarge. I upgraded to the latest mysql4.1dev client aswell.

    ISPConfig works fine in creating new databases and mysqladmin can authenticate and enter the database fine.

    Problem comes in when I load oscommerce or similar programs. I am constantly getting: "Client does not support authentication method, please upgrade the mysql client".

    I have the latest client installed:
    Code:
    spirit:/usr/lib/php4/20020429# dpkg --list | grep mysql
    ii  libdbd-mysql-p 2.9006-1       A Perl5 database interface to the MySQL data
    ri  libmysqlclient 4.0.24-10sarge mysql database client library
    ii  libmysqlclient 4.1.11a-4sarge mysql database client library
    ii  libmysqlclient 4.1.11a-4sarge mysql database development files
    ii  mysql-client-4 4.1.11a-4sarge mysql database client binaries
    rc  mysql-common   4.0.24-10sarge mysql database common files (e.g. /etc/mysql
    ii  mysql-common-4 4.1.11a-4sarge mysql database common files (e.g. /etc/mysql
    rc  mysql-server   4.0.24-10sarge mysql database server binaries
    ii  mysql-server-4 4.1.11a-4sarge mysql database server binaries
    ii  php4-mysql     4.3.10-22      MySQL module for php4
    
    It seems that the php4 on the apache2 webserver I have, the mysql.so is linked to the old mysqlclient.12 and not the mysqlclient.14
    Code:
    spirit:/usr/lib/php4/20020429# ldd mysql.so
            libmysqlclient.so.12 => /usr/lib/libmysqlclient.so.12 (0x0000002a9566a000)
            libc.so.6 => /lib/libc.so.6 (0x0000002a957b2000)
            libz.so.1 => /usr/lib/libz.so.1 (0x0000002a959f1000)
            libcrypt.so.1 => /lib/libcrypt.so.1 (0x0000002a95b05000)
            libnsl.so.1 => /lib/libnsl.so.1 (0x0000002a95c39000)
            libm.so.6 => /lib/libm.so.6 (0x0000002a95d4f000)
            /lib/ld-linux-x86-64.so.2 => /lib/ld-linux-x86-64.so.2 (0x000000552aaaa000)
    
    I need the mysql.so to point to "libmysqlclient.so.14 => /usr/lib/libmysqlclient.so.14 "

    How the heck do I make this change? I have clients freeking out as they cant install anything that needs a mysql/php system.
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    You could create a backup of /usr/lib/libmysqlclient.so.12 and then make a symlink from /usr/lib/libmysqlclient.so.12 to /usr/lib/libmysqlclient.so.14. But I don't know if this works.
     
  3. PoleCat

    PoleCat New Member

    Nope,

    That breaks DB:mysql hashes or something.

    Any other ideas?

    What if I upgrade the server to version 4.0? Will ISPC run fine still ?

    Is there a upgrade process for Debian 3.1 to 4.0 to make sure ISPC works fine?

    I have over 140 live websites with loads of emails on the server for client. The upgrade process must be as smooth as possible.
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Please run
    Code:
    apt-get update
    and then
    Code:
    apt-get install php4-mysql
    Maybe there's a newer version of that package available now.
     
  5. PoleCat

    PoleCat New Member

    Code:
    spirit:~# apt-get update
    Hit http://security.debian.org sarge/updates/main Packages
    Get:1 http://security.debian.org sarge/updates/main Release [114B]
    Hit http://security.debian.org sarge/updates/contrib Packages
    Get:2 http://security.debian.org sarge/updates/contrib Release [117B]
    Hit http://security.debian.org sarge/updates/non-free Packages
    Get:3 http://security.debian.org sarge/updates/non-free Release [118B]
    Hit http://ftp.de.debian.org sarge/main Packages
    Hit http://ftp.de.debian.org sarge/main Release
    Hit http://ftp.de.debian.org sarge/non-free Packages
    Hit http://ftp.de.debian.org sarge/non-free Release
    Hit http://ftp.de.debian.org sarge/contrib Packages
    Hit http://ftp.de.debian.org sarge/contrib Release
    Hit http://ftp.de.debian.org sarge/main Sources
    Hit http://ftp.de.debian.org sarge/main Release
    Hit http://ftp.de.debian.org sarge/non-free Sources
    Hit http://ftp.de.debian.org sarge/non-free Release
    Hit http://ftp.de.debian.org sarge/contrib Sources
    Hit http://ftp.de.debian.org sarge/contrib Release
    Fetched 349B in 0s (1513B/s)
    Reading Package Lists... Done
    spirit:~# apt-get upgrade
    Reading Package Lists... Done
    Building Dependency Tree... Done
    0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
    spirit:~# apt-get install php4-mysql
    Reading Package Lists... Done
    Building Dependency Tree... Done
    php4-mysql is already the newest version.
    0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
    spirit:~#
    

    Nope it's the latest.

    Any other suggestions?
     
  6. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

Share This Page