Paul J Stevens wrote:
That means that the passwords are in CRYPT format.
No, crypt passwords don't begin with "$", just tried...
You are wrong, Jorge is correct. md5 passwords that begin with $1$ are
indeed crypt. The format is:
"$1$<salt>$<encoded>"
so try:
select concat('$1$', <salt> , '$', encrypt(<somepassword>,<salt>));
Ok, sorry if I don't get everything right but this is the first time I
try this...
I want to set the password to 'hello' for my account. I set it with
dbmail-users:
dbmail-users -u <myuserid> -p md5-digest -w hello
in dbmail_users I get this password:
5d41402abc4b2a76b9719d911017c592
I can match it with md5('hello') --> no problem
Now I set the password with md5-hash:
dbmail-users -u <myuserid> -p md5-digest -w hello
In the db I get:
$1$cHk47Kk0$TjUIVx0j9o/sZ0kn/IIzD.
which changes every time I set the password to the same value ('hello').
Now let's try to match it...
select concat('$1$', 'cHk47Kk0' , '$', encrypt('hello','cHk47Kk0'));
this results in:
$1$cHk47Kk0$cHKokhNHbWpO2
which is not the same as the password stored.
What am I doing wrong?
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
