At 15:41 -0400 10/21/04, [EMAIL PROTECTED] wrote:
Dear list:
I have a short database with id,username and
password for authenticate my users with
freeradius. The passwords are encrypted through
ENCRYPT() function. I´d like to know why
ENCRYPT() function doesn´t give the same
encrypted string for a clear text string?.
e.g. In the first time ENCRYPT('cisco123') gives HynlnFeaQzLzU
In the second time ENCRYPT('cisco123') gives IydYEKE4Pk85s
In the third time ENCRYPT('cisco123') gives KyJV8FPCwndcc
If you don't supply the second (salt) argument, the result can vary over
time for a given first argument. To get the same value each time, supply
a constant salt argument.
I´m writing a script with php+mysql for change
these passwords, for that the user have to type
its actual password, so the php script must to
match with the password stores into DB. Before
the match this password, my script encrypts it
with the same function, but it never will be the
same, so it won´t match.
I have to use ENCRYT() because freeradius only works with it.
Do you know other method for it?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]