user defined in mysql table radcheck fails wtih "No "known good password", and radpostauth updated successfully but still empty

[Dustin S]

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 at quarantainenet.nl>
 To: Dustin S <dsoodak at yahoo.com>; FreeRadius users mailing list <freeradius-users at 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