Jesse Norell wrote:
The salt is the full 12 chars, $1$cHk47Kk0$, and it looks like
encrypt() already prepends it for you:
mysql> select encrypt('hello','$1$cHk47Kk0$');
+------------------------------------+
| encrypt('hello','$1$cHk47Kk0$') |
+------------------------------------+
| $1$cHk47Kk0$TjUIVx0j9o/sZ0kn/IIzD. |
+------------------------------------+
1 row in set (0.02 sec)
Thanks, you saved me!
As you showed, the mysql crypt functions already build the complete
string, so
it's not necessary to concat the parts:
select encrypt('password to verify', 'string in passwd from the first $
to the last $ included')
This results, if the check is successful, with the whole passwd field in
the dbmail_users table.
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail