Menu
▾
▴
phpesp-devel
|
From: SourceForge.net <no...@so...> - 2006-05-01 23:33:47
|
Bugs item #1480092, was opened at 2006-05-01 23:33 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&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: SQL Group: v1.8 Status: Open Resolution: None Priority: 5 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 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1480092&group_id=8956 |
|
From: SourceForge.net <no...@so...> - 2009-04-20 08:17:34
|
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-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 |
|
From: SourceForge.net <no...@so...> - 2009-04-21 07:02:30
|
Feature Requests item #1480092, was opened at 2006-05-01 16:33 Message generated for change (Comment added) made by kswartz 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: kswartz (kswartz) Date: 2009-04-21 00: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 01: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 |
|
From: SourceForge.net <no...@so...> - 2009-04-21 07:27:33
|
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 |
|
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 |
|
From: SourceForge.net <no...@so...> - 2009-04-21 12:25:51
|
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:25 Message: I would also recommend updating phpESP to the latest version. And MySQL 3... I personally don't support any more. ---------------------------------------------------------------------- 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 |
|
From: SourceForge.net <no...@so...> - 2009-04-21 12:54:03
|
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 14:53 Message: True, on all points. Even then, maybe md5 is better than using mysql password function ... then we can eliminate some database specific code and use md5 everywhere, no? But on the other hand, updating from PASSWORD to MD5 will be a real pain ita ... Franky ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 14:25 Message: I would also recommend updating phpESP to the latest version. And MySQL 3... I personally don't support any more. ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 14: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 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 |
|
From: SourceForge.net <no...@so...> - 2009-04-21 13:07:56
|
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 09:07 Message: The less database specific code, the better, IMO. Of course, we should have the flexibility to utilize db-specific code, when needed for performance or other technical reasons. I'd vote to put this in the roadmap for discussion in v3. ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2009-04-21 08:53 Message: True, on all points. Even then, maybe md5 is better than using mysql password function ... then we can eliminate some database specific code and use md5 everywhere, no? But on the other hand, updating from PASSWORD to MD5 will be a real pain ita ... Franky ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 08:25 Message: I would also recommend updating phpESP to the latest version. And MySQL 3... I personally don't support any more. ---------------------------------------------------------------------- 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 |
|
From: SourceForge.net <no...@so...> - 2009-04-21 18:56:56
|
Feature Requests item #1480092, was opened at 2006-05-01 16:33 Message generated for change (Comment added) made by kswartz 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: kswartz (kswartz) Date: 2009-04-21 11:56 Message: My apologies on the OLD_PASSWORD comment - I misread the problem description. And, actually, the use of OLD_PASSWORD isn't as simple as I laid it out to be. It is required not when you are using a pre-4.1 version of MySQL, but when you are using /client libraries/ from MySQL 4.0 or earlier to connect to a MySQL server running 4.1 or later. (I hit this problem on my own installation, as I only had limited control over updating the system libraries on my machine.) So it's not as simple as checking the version of the database server to know which one to use. Using md5, however, gets rid of this problem altogether, since it's behavior is consistent regardless of the database client or server version. So I like the enhancement for that reason, in addition to bishop's observation that it can be applied to multiple databases, and less database-specific code has many advantages. Of course, after recent events, one has to also assume that MySQL and Oracle will, in fact, remain separate in the long run. ;-) ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 06:07 Message: The less database specific code, the better, IMO. Of course, we should have the flexibility to utilize db-specific code, when needed for performance or other technical reasons. I'd vote to put this in the roadmap for discussion in v3. ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2009-04-21 05:53 Message: True, on all points. Even then, maybe md5 is better than using mysql password function ... then we can eliminate some database specific code and use md5 everywhere, no? But on the other hand, updating from PASSWORD to MD5 will be a real pain ita ... Franky ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 05:25 Message: I would also recommend updating phpESP to the latest version. And MySQL 3... I personally don't support any more. ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 05: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 00: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 00: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 01: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 |
|
From: SourceForge.net <no...@so...> - 2009-07-25 23:00:09
|
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: Closed 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-07-26 01:00 Message: sorry, but this is not a feature request ... and probably out of date already as well Franky ---------------------------------------------------------------------- Comment By: kswartz (kswartz) Date: 2009-04-21 20:56 Message: My apologies on the OLD_PASSWORD comment - I misread the problem description. And, actually, the use of OLD_PASSWORD isn't as simple as I laid it out to be. It is required not when you are using a pre-4.1 version of MySQL, but when you are using /client libraries/ from MySQL 4.0 or earlier to connect to a MySQL server running 4.1 or later. (I hit this problem on my own installation, as I only had limited control over updating the system libraries on my machine.) So it's not as simple as checking the version of the database server to know which one to use. Using md5, however, gets rid of this problem altogether, since it's behavior is consistent regardless of the database client or server version. So I like the enhancement for that reason, in addition to bishop's observation that it can be applied to multiple databases, and less database-specific code has many advantages. Of course, after recent events, one has to also assume that MySQL and Oracle will, in fact, remain separate in the long run. ;-) ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 15:07 Message: The less database specific code, the better, IMO. Of course, we should have the flexibility to utilize db-specific code, when needed for performance or other technical reasons. I'd vote to put this in the roadmap for discussion in v3. ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2009-04-21 14:53 Message: True, on all points. Even then, maybe md5 is better than using mysql password function ... then we can eliminate some database specific code and use md5 everywhere, no? But on the other hand, updating from PASSWORD to MD5 will be a real pain ita ... Franky ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 14:25 Message: I would also recommend updating phpESP to the latest version. And MySQL 3... I personally don't support any more. ---------------------------------------------------------------------- Comment By: bishop (bishopb) Date: 2009-04-21 14: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 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X