Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th April 2008, 12:23
PoleCat PoleCat is offline
Member
 
Join Date: Mar 2007
Posts: 57
Thanks: 6
Thanked 3 Times in 3 Posts
Exclamation Upgradeded to mysql4.1 breaks mysql client

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.
Reply With Quote
Sponsored Links
  #2  
Old 17th April 2008, 21:58
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 18th April 2008, 10:14
PoleCat PoleCat is offline
Member
 
Join Date: Mar 2007
Posts: 57
Thanks: 6
Thanked 3 Times in 3 Posts
Default

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.
Reply With Quote
  #4  
Old 20th April 2008, 00:26
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 21st April 2008, 11:00
PoleCat PoleCat is offline
Member
 
Join Date: Mar 2007
Posts: 57
Thanks: 6
Thanked 3 Times in 3 Posts
Default

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?
Reply With Quote
  #6  
Old 22nd April 2008, 18:38
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

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
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 19:40
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 20:13
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 22:24.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.