[thelist] md5 hashed password problem

Anthony Baratta anthony at baratta.com
Wed Aug 15 12:57:45 CDT 2007


Hassan - package this as a "tip" so the search engines can get it!!

-----Original message-----
From: "Hassan Schroeder" hassan.schroeder at gmail.com
Date: Wed, 15 Aug 2007 10:46:31 -0700
To: bobm at dottedi.biz,  "thelist at lists.evolt.org" thelist at lists.evolt.org
Subject: Re: [thelist] md5 hashed password problem

> So, out of curiousity --
> 
> > > | old_passwords |  ON     |
> /
> > I don't know if that variable is global or can be changed on, say, a
> > per-connection basis;
> 
> I tried a quick experiment, and it appears that you /can/ set this on a
> per-connection basis. So all you have to do is flag the moved-over
> users as 'uses_old_passwords', and then when one of them logs in,
> do a SET OLD_PASSWORDS="OFF" before the password comparison.
> 
> Yes, ugly and annoying, and why the heck anyone'd have MySQL set
> up with the old password format at this point is beyond me, but there
> is at least a workaround...
> 
> HTH!
> -- 
> Hassan Schroeder ------------------------ hassan.schroeder at gmail.com
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 



More information about the thelist mailing list