Tough time getting FreeRADIUS 3.0.9 to work with mysql

[Song Zou]

please don’t send email

On Jul 16, 2015, at 18:28, Kwesi Yankson via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:

> HI,I finally got it working.  As I thought I was doing something wrong. Maybe sharing it will help others who have the problem.When configuring the sql module, I couldn't get FreeRADIUS to start with "rlm_sql_mysql"  so I chose "rlm_sql_null".After searching the mailing list, I found out that this issue had been addressed on countless occasions.During mysql installation, I did not install MySql client libraries and the MySQL development library.I did this and reinstalled freeRADIUS (./configure then installed the libraries needed to work with "rlm_slq_mysql") and everything works well now.
> Thanks 
> 
> 
>     On Tuesday, July 14, 2015 7:18 AM, Kwesi Yankson via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:
> 
> 
> Thanks, I probably did something wrong in configuring the mysql module.  I'll double check my configuration then.
> 
> 
> 
>     On Tuesday, July 14, 2015 12:23 AM, Alan DeKok <aland at deployingradius.com> wrote:
>   
> 
> On Jul 13, 2015, at 5:54 PM, Kwesi Yankson via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:
> 
> Thank you Alan.When I run the query in mysql this is what I get:mysql> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'me' ORDER BY id;
> +----+----------+--------------------+-------+----+
> | id | username | attribute          | value | op |
> +----+----------+--------------------+-------+----+
> |  9 | me      | Cleartext-Password | pass  | := |
> +----+----------+--------------------+-------+----+
> 
>   Well, then the server should work.  There's really no magic in it.
> 
>   Alan DeKok.
> 
> 
> 
>   
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html