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
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to