[phpesp-dev] [ phpesp-Bugs-1727902 ] No Logon when mysql > 4.1 (hash lenght problem)

[SourceForge.net <no...@so...>]

Bugs item #1727902, was opened at 2007-05-29 15:38
Message generated for change (Comment added) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1727902&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL
Group: v1.8
Status: Open
>Resolution: Wont Fix
Priority: 5
Private: No
Submitted By: Miguel (miguel2)
Assigned to: Nobody/Anonymous (nobody)
Summary: No Logon when mysql > 4.1 (hash lenght problem)

Initial Comment:
Today i could not login to phpESP even if i created a new user via phpmyadmin. I didnt login since a year. in the meantime the hoster upgraded to mysql 5.

I investigated a bit and found that the lenght of the password hash created by the mysql function PASSWORD() has changed from 16bit to 41bit. (http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html)

You have to change the lenght of the password field in table designer to 41

 ALTER TABLE `designer` CHANGE `password` `password` CHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

----------------------------------------------------------------------

>Comment By: Matthew Gregg (greggmc)
Date: 2007-05-29 15:54

Message:
Logged In: YES 
user_id=14116
Originator: NO

I guess this belongs in the documentation somewhere.  Not really a bug
with ESP.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1727902&group_id=8956