#1  
Old 3rd May 2006, 11:37
montezuma montezuma is offline
Junior Member
 
Join Date: May 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default phpmyadmin password hash

I've installed ISPConfig onto FC4 after upgrading MySQL and mysql-devel to 4.1.16 using a yum update. I appreciate that 4.1 uses a different password hash and therefore phpmyadmin won't set passwords correctly. Obviously I can set them correctly from the mysql prompt and by looking at the users table I can see that this does indeed change the password hash.

In another post, Till says:

Quote:
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.
How do I remove the old mysql-devel - do I need to? How exactly do I run the ISPConfig update?

I suspect that this is going to become an increasing problem!
Reply With Quote
Sponsored Links
  #2  
Old 3rd May 2006, 15:03
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 montezuma
How do I remove the old mysql-devel - do I need to?
Simply install the new mysql-devel, and the old one will be removed automatically.

Quote:
Originally Posted by montezuma
How exactly do I run the ISPConfig update?
I don't think you have to update ISPConfig.
__________________
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 3rd May 2006, 18:38
montezuma montezuma is offline
Junior Member
 
Join Date: May 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Many thanks for the reply, Falko. I installed mysql and mysql-devel 4v1 before installing ISPConfig. I couldn't understand why it would be necessary to delete the old libraries; thanks for the confirmation.

phpmyadmin does not correctly derive the password hash, but the mysql command "set password for ...@... = password(pw)" issued from the mysql prompt does work correctly. What this suggests is that phpmyadmin is using a different hash generator to mysql 4v1, probably from an earlier version of mysql. How can I get it to use the right one?
Reply With Quote
  #4  
Old 3rd May 2006, 22:25
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

Maybe you can specify it in the phpMyAdmin configuration?
Otherwise I'd try to install a newer phpMyAdmin version.
__________________
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 6th May 2006, 22:31
montezuma montezuma is offline
Junior Member
 
Join Date: May 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, I now have an answer to this.

1. It's necessary to recompile PHP with mysql and mysqli support - in fact, I used also the opportunity to install 5.1.4 since 5.1.3 (which is part of ISPConfig 2.2.2) is flawed.

2. I didn't verify whether phpmyadmin 2.6.4 would support mysql 4v1 passwords via mysqli, but I did notice that full compatibility with PHP >5.1.2 required phpmyadmin >2.8.x therefore I upgraded to phpmyadmin 2.8.0.3, which works correctly.

This was not easy, partly because from 2.8 phpmyadmin has a setup script which fails on Fedora! In the next installation script for ISPConfig I believe that support for mysql >4.1 should be considered (IE mysqli). As part of this, the downloadable package for phpmyadmin should be upgraded from the present 2.6.4.

If there is general interest in documenting how to do the above in more detail, please let me know.
Reply With Quote
  #6  
Old 14th June 2006, 13:57
evilyves evilyves is offline
Junior Member
 
Join Date: Jun 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default password hash mysql

or only try this:

grep old /etc/mysql/my.cnf

when nothing comes up, write this in /etc/mysql/my.cnf

under:

[mysqld]

old-passwords


/etc/init.d/mysql restart

;-)
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 to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40
phpMyAdmin question? ctroyp Installation/Configuration 1 20th March 2006 23:19
Changing mysql password gfts Installation/Configuration 1 16th March 2006 17:39
Password Hash nok Installation/Configuration 4 27th February 2006 20:22
phpMyAdmin string error IntnsRed General 2 7th November 2005 10:48


All times are GMT +2. The time now is 11:49.


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