MySQL version different from library

[bswinnerton]

I'm getting new mail messages in Linux saying that "1 client is using or hasn't closed the table properly" for most of my tables in MySQL (including ISPconfig). I recently updated both Ubuntu to 9.10, and ISPconfig to the latest version.

I think that something may be wrong with my MySQL & PHP setup, when logging into phpmyadmin I get a warning on the bottom of the page that says:

"Your PHP MySQL library version 5.0.83 differs from your MySQL server version 5.1.37. This may cause unpredictable behavior."

How can I make it so that the library version and the server version are the same? And will this fix my errors in the mail that I'm receiving?

[falko]

Do you use ISPConfig 2 or 3? If it's version 2, do you get the warning in ISPConfig's phpMyAdmin or in another phpMyAdmin?

[bswinnerton]

I'm using ISPConfig 2, and I get it when I browse to www.mysite.com:81/phpmyadmin. I installed it through ISPConfig, however it says that error on the main page after you log into phpmyadmin.

[falko]

Ok, I guess you need to rebuild ISPConfig. Just download the latest version (2.2.34) and install it.

[bswinnerton]

It's odd that you say that, I just upgraded to 2.2.34 two days ago.

Could it of missed the MySQL part? Should I just try reinstalling?

[falko]

Make sure that the newest version of libmysqlclient15-dev is installed...

aptitude install libmysqlclient15-dev

and then install 2.2.34 again.

[bswinnerton]

apt-get install libmysqlclient15-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
libmysqlclient15-dev is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

[falko]

Originally Posted by bswinnerton

It's odd that you say that, I just upgraded to 2.2.34 two days ago.

And you got the PHP MySQL library warning already before the upgrade, or only since then?

[bswinnerton]

Hmm, to be honest it could of been there before.. but I never noticed it.

[falko]

I'd try to install 2.2.34 again. I hope it solves the problem.