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