phpmyadmin password hash

[montezuma]

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:

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!

[falko]

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.

Originally Posted by montezuma

How exactly do I run the ISPConfig update?

I don't think you have to update ISPConfig.

[montezuma]

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?

[falko]

Maybe you can specify it in the phpMyAdmin configuration?
Otherwise I'd try to install a newer phpMyAdmin version.

[montezuma]

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.

[evilyves]

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

;-)