PoleCat
17th April 2008, 12: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:
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
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.
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:
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
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.