Navigation

PoleCat · #1 17th April 2008, 11:23

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.

falko · #2 17th April 2008, 20:58

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.

PoleCat · #3 18th April 2008, 09:14

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.

falko · #4 19th April 2008, 23:26

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.

PoleCat · #5 21st April 2008, 10:00

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?