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.
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.
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.
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.
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?
Please add Code: old-passwords to the [mysqld] section in the my.cnf and restart MySQL. http://dev.mysql.com/doc/refman/5.0/en/old-client.html
