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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th November 2009, 18:01
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 16 Times in 13 Posts
Default MySQL version different from library

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?
Reply With Quote
Sponsored Links
  #2  
Old 18th November 2009, 14:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

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?
__________________
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 19th November 2009, 14:06
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 16 Times in 13 Posts
Default

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.
Reply With Quote
  #4  
Old 20th November 2009, 13:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Ok, I guess you need to rebuild ISPConfig. Just download the latest version (2.2.34) and install it.
__________________
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 20th November 2009, 14:08
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 16 Times in 13 Posts
Default

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?
Reply With Quote
  #6  
Old 21st November 2009, 18:14
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Make sure that the newest version of libmysqlclient15-dev is installed...
Code:
aptitude install libmysqlclient15-dev
and then install 2.2.34 again.
__________________
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
  #7  
Old 21st November 2009, 20:41
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 16 Times in 13 Posts
Default

Code:
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.
Reply With Quote
  #8  
Old 22nd November 2009, 16:55
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by bswinnerton View Post
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?
__________________
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
  #9  
Old 22nd November 2009, 18:00
bswinnerton bswinnerton is offline
Senior Member
 
Join Date: Jul 2007
Location: Connecticut, US
Posts: 502
Thanks: 51
Thanked 16 Times in 13 Posts
Default

Hmm, to be honest it could of been there before.. but I never noticed it.
Reply With Quote
  #10  
Old 23rd November 2009, 14:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
 
Default

I'd try to install 2.2.34 again. I hope it solves the problem.
__________________
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
ffmpeg Video support for ubuntu 7.10 [suphp-ispconfig] amaurib Installation/Configuration 13 16th February 2010 17:26
server Installation Configuration deco5003 Installation/Configuration 12 5th August 2009 12:00
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19
KErnel not showing all my memory Jorem Kernel Questions 8 13th April 2006 12:59


All times are GMT +2. The time now is 13:15.


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