I have solved this issue. Thanks to those who read and offered advice.
Thanks again,
Darren
On Wed, Aug 26, 2009 at 1:39 PM, Michael Dalymichael.daly@kayakwiki.org wrote:
Darren Kemp wrote:
Unfortunately the original system was setup using mysql password encryption. (password=password('password')) Since there is no way (that i have found) to decrypt a mysql password in php or encrypt a password in php using mysql encryption I have been having some struggles getting this to work. (as is we are comparing a cleartext password to an encrypted password in the code).
I don't know MySQL Select statements in gory detail, but doesn't it support something like
SELECT password('cleartextPsw') as encUserPsw
Then just compare the encrypted versions for a match.
Mike
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l