[phpesp-dev] [ phpesp-Feature Requests-1480092 ] mySQL and md5??

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

Feature Requests item #1480092, was opened at 2006-05-02 01:33
Message generated for change (Comment added) made by liedekef
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=1480092&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: None
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: J Peterson (jpeter1491)
Assigned to: Nobody/Anonymous (nobody)
Summary: mySQL and md5??

Initial Comment:
Hello, first I have to say this is a great program.  
Thank you!

Here is my problem...  I manage a website that users 
have already registered for, and their passwords are 
md5 encrypted.  How can I change phpESP to read the 
md5 hash that I copied over from another table?  I've 
tried changing all 'PASSWORD($password)' to 'md5
($password)' to no avail.  I've looked all over the 
README files, FAQs, and searched the mail archives.  
Any other suggestions??  I really appreciate your 
help.

phpESP ver: 1.8.1
mySQL ver: 3.23.58

john [at] johnpetersonpictures [dot] com

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

>Comment By: Franky Van Liedekerke (liedekef)
Date: 2009-04-21 09:27

Message:
Well, the original ticket owner wants to replace PASSWORD by md5 calls, so
wether or not it is OLD_PASSWORD or PASSWORD, it doesn't matter :-)

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

Comment By: kswartz (kswartz)
Date: 2009-04-21 09:02

Message:
If you're running with a version of MySQL older than 5.0, you need to
change the references of PASSWORD() to OLD_PASSWORD(). See
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_old-password
.

If the documentation doesn't state that MySQL 5.x or later is required,
then technically this is a bug (but could arguably be a doc bug).

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

Comment By: Franky Van Liedekerke (liedekef)
Date: 2009-04-20 10:17

Message:
This is not a bug, so moving to feature request.

Franky

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

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