Menu
▾
▴
[phpesp-dev] [ phpesp-Feature Requests-1480092 ] mySQL and md5??
|
From: SourceForge.net <no...@so...> - 2009-04-21 12:24:19
|
Feature Requests item #1480092, was opened at 2006-05-01 19:33 Message generated for change (Comment added) made by bishopb 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: bishop (bishopb) Date: 2009-04-21 08:24 Message: Most password-related functionality comes from the db_crypt() function in phpESP/admin/include/lib/espdatalib.inc I would start by changing that function to return MD5, like the Oracle case does. There are two other references to PASSWORD() in that file, and those may need to be updated, too. As for the PASSWORD v. OLD_PASSWORD issue, that should probably also be handled in the db_crypt() function. ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2009-04-21 03: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 03: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 04: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 |
