Configuring Freeradius to authenticate with MySQL

[andremail82-radius]

Hello folks I'm trying to configure freeradius to authenticate with MySQL.

I made tests without MySQL and works fine.

 

But With MySQL I'm having problems.

I create the database radius and create the tables with the mysql file that come in the tgz of the sources using the command mysql -root radius < db_mysql.sql

 

I have edited the file sql.conf ajusting it to connect in my mysql server, in the file radiusd.conf the entry sql in the authenticate field is uncommented.

 

When I start freeradius in debug mode I show the following

 

rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4

I don't know if this mean that the freeradius is connected to the MySQL server or this is an error...

 

And when I try to authenticate it show the following:

This test was maded with radtest.

 

rad_recv: Access-Request packet from host 127.0.0.1:1024, id=229, length=70
        User-Name = "00045700A43B"
        User-Password = "\373\346\367\211*Xw\362fSeb\023s\224\001"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
        Framed-Protocol = PPP
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '00045700A43B' ORDER BY id
rlm_sql_mysql: query:  SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = '00045700A43B' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '00045700A43B' ORDER BY id
rlm_sql_mysql: query:  SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = '00045700A43B' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: unknown attribute
rlm_sql (sql): Error getting data from database
rlm_sql (sql): No matching entry in the database for request from user [00045700A43B]
rlm_sql (sql): Released sql socket id: 4
rad_recv: Access-Request packet from host 127.0.0.1:1024, id=229, length=70
Sending Access-Reject of id 229 to 127.0.0.1:1024

Please if some one could help me with this issue I will be very grateful.

Probably I'm forget something.

 

Thanks very much,

 

André Zenun

 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com