Hi. Am Samstag, 31. März 2007 schrieb James Homuth: > >I get a successful, error-free query (snip below), and the response > >from mysql that I expect (also below). But I still can't log in. Now, > >I think it might be an encription problem with the password, but the > >only thing I get told on various web sources is make sure mysql's > >using the OS level crypt function and not its own. And, so far as I'm > >aware, it is. >| [EMAIL PROTECTED] | 67fada7e716dd205 | | 5000 | 5000 |
This seems to be hexadecimal encoded (did you use PASSWORD() from a rather old mysql version?). You should use Salted-MD5 as used by the UNIX-Shadow-Passwords (looking like $1$foobar$...). One way to get them is to use "userdbpw -md5" on the command line. Personally, I would discourage using any mysql-function for this (I don't know if there is any). I suggest building this step into the frontend/library for changing passwords/creating users. Either by calling userdbpw from your frontend or use your programming language's method for generating unix MD5 hashes. cu, Bernd -- Hilf einem Freund in der Not, und er wird sich an dich erinnern, wenn er wieder in Not ist!
pgpRStC3dNiIb.pgp
Description: PGP signature
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
