On Wed, 2008-11-12 at 17:44 +0100, Giulio Ferro wrote:
>
> select concat('$1$', 'cHk47Kk0' , '$', encrypt('hello','cHk47Kk0'));
>
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)
--
Jesse Norell
Kentec Communications, Inc.
[EMAIL PROTECTED]
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail