#1  
Old 7th March 2006, 18:10
DiOmega DiOmega is offline
Junior Member
 
Join Date: Feb 2006
Posts: 23
Thanks: 3
Thanked 0 Times in 0 Posts
Default MySQL Problems after Upgrade

Hi,

I upgraded my Server to MySQL 4.1.11 and after everything looks fine i updatet to ISPConfig 2.2.0.

Everythin looks fine but now i figured out that every new DB-User can't log in.
I looked at the PHP-Info of the PHPMyAdmin in ISPConfig an noticed:

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 1
Client API version 4.0.24
MYSQL_MODULE_TYPE external

Is the 4.0.24 Client my Problem and how can i update this?
Reply With Quote
Sponsored Links
  #2  
Old 7th March 2006, 20:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

The problem is related to your mysql upgrade. Mysql 4.1 uses an incompatible password hash. Please install the latest mysql devel librarys from your linux distribution and remove the old ones. Then you will have to run the ISPConfig update again.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 14th November 2006, 07:08
Nap Nap is offline
Senior Member
 
Join Date: Oct 2006
Posts: 150
Thanks: 10
Thanked 2 Times in 2 Posts
Default

Till,

I have the same problem as DiOmega, but I didn't understand, in a practical sense, the advice you gave above.

I was under the impression that aptitude etc manage dependancies.

Thus, I have no idea what mysql devel librarys need to be updated.
My libmysqlclient14 & libmysqlclient14-dev are at the newest versions.

Anything else?

Cheers,
Nap
Reply With Quote
  #4  
Old 14th November 2006, 10:31
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

Quote:
Originally Posted by Nap
Till,

I have the same problem as DiOmega, but I didn't understand, in a practical sense, the advice you gave above.

I was under the impression that aptitude etc manage dependancies.
aptitude manages the dependencies for mysql, but it does not update the PHP that is used to run ISPConfig.

Quote:
Thus, I have no idea what mysql devel librarys need to be updated.
My libmysqlclient14 & libmysqlclient14-dev are at the newest versions.
1) You will have to install the mysql-devel library that is compatible with your database.
2) You will have to reinstall / update ISPConfig when the ISPConfig PHP is not able to connect to your database anymore.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 14th November 2006, 11:08
Nap Nap is offline
Senior Member
 
Join Date: Oct 2006
Posts: 150
Thanks: 10
Thanked 2 Times in 2 Posts
Default

Till,

I was asking if you could elaborate on the advice you gave to DiOmega. Somehow he was able to fix the problem (as he hasn't continued with the thread) but I don't understand what he did.


Quote:
aptitude manages the dependencies for mysql, but it does not update the PHP that is used to run ISPConfig.
I didn't change anything relating to my PHP. All I did was upgrade from MySQL 4.0.24 to 4.1.11.

Quote:
1) You will have to install the mysql-devel library that is compatible with your database.
libmysqlclient14 and libmysqlclient14-dev are the libraries required, and both are installed.
This is the apt-get command I used:
Code:
apt-get install mysql-server-4.1 mysql-client-4.1 libmysqlclient14-dev
Quote:
2) You will have to reinstall / update ISPConfig when the ISPConfig PHP is not able to connect to your database anymore.
Whilst I can uninstall ISPConfig and reinstall it, the compiling takes an enormously long time on my machine, so if updating is an option, I would like to use it. How would I do that?
(I have used the update option in ISPConfig and updated the phpMyAdmin package to version 2.9.1, but that's it.)

Cheers,
Nap

Last edited by Nap; 14th November 2006 at 11:11.
Reply With Quote
  #6  
Old 14th November 2006, 11:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

Updating means running the ISPConfig installer, it detects your existing installation and performs an update. Compileing is needed for this update to update your PHP.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 14th November 2006, 11:19
Nap Nap is offline
Senior Member
 
Join Date: Oct 2006
Posts: 150
Thanks: 10
Thanked 2 Times in 2 Posts
Default

Thnx Till,

I am already doing that.

I unpacked the ISPConfig*.tar.gz,
am running the ./setup now.

Cheers,
Nap
Reply With Quote
  #8  
Old 17th November 2006, 15:40
Mikymike Mikymike is offline
Junior Member
 
Join Date: Nov 2006
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default

It worked for me anyway too even after upgrading MySQL 4.1 to MySQL 5 on a Debian 3.1 Sarge box

I had only to update ISPConfig install and all worked fine afterwards

Thx for your help till

ps: a note about it in a FAQ could be a good idea :-)
Reply With Quote
  #9  
Old 17th November 2006, 22:35
Nap Nap is offline
Senior Member
 
Join Date: Oct 2006
Posts: 150
Thanks: 10
Thanked 2 Times in 2 Posts
 
Default

Till,

thnx. Got it.
Used the ISPConfig install procedure (from the start) and everything is now working fine.

Cheers,
Nap
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
How would I upgrade php, mysql, and apache for debian phantomk Installation/Configuration 10 4th June 2007 19:01
problems mysql rayit General 15 1st April 2006 05:57
Mysql password problems lerra Installation/Configuration 25 24th February 2006 13:33
MySQL Upgrade?? toyito Installation/Configuration 3 10th February 2006 18:56
Removed PostFix, Now MySql Problems!!! sapient Installation/Configuration 10 24th October 2005 08:11


All times are GMT +2. The time now is 03:28.


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