Re: [Help-gnu-radius] Problem with SQL Auth

[Sergey Poznyakoff]

> I have installed gnu-radius-0.95 with mysql auth ... all seems to be working 
> fine except it appears that it 
> sees the user_name in the sql but not the password I added a user to sql 
> table "passwd" with the 

Please note, that passwords in the SQL database should be stored as
DES or MD5 hashes. Radius 0.95 does not permit plaintext passwords in
SQL database. You can use MySQL function ENCRYPT() to create an
appropriate hash. It takes two arguments, a string to encrypt and
a `salt' to use. For example, the following statement will insert
a properly generated DES password along with the username:

  INSERT INTO pass VALUES ('test', ENCRYPT('12345',now()));

Here, the return from now() is used as a salt, which is not the best
usage possible, but still produces good results.

Regards,
Sergey