already changed the user file entry to "hello1", and the radtest works fine with bob/hello1. It just stops working when I change to using sql. From: Herwin Weststrate <herwin@quarantainenet.nl> To: Dustin S <dsoodak@yahoo.com>; FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Sent: Wednesday, April 20, 2016 12:28 AM Subject: Re: user defined in mysql table radcheck fails wtih "No "known good password", and radpostauth updated successfully but still empty On 19-04-16 22:16, Dustin S via Freeradius-Users wrote:
I entered a user "bob" into the "freeradius/users" file and radtest bob hello1 localhost 1812 testing1 works fine.
I then entered "bobsql" into the database (after adding "sql" to all the places in freeradius/sites-available/default and adding the new mysql user login & database info to freeradius/mods-available/sql)
| id | username | attribute | value | op | +----+----------+-----------+----------+----+ | 4 | bobsql | Password | hello1 | := |
Well, the line from the users file reads like this: bob Cleartext-Password := "hello" Finding the difference here is left as an excercise to the reader ;) -- Herwin Weststrate