Use freeradius ans MySQL

[CHAPUIS Alexandre]

Hi,

 

 Actually, i used freeradius 0.3 and files password,and it's work fine; but I try to use Freeradius 0.4 and Mysql database.

First, i read the documentation on http://www.frontios.com/freeradius.html... that's seem to be easy, but when  

i try to use radius for the telnet access on a cisco router, the authentication failed.

 

I started radiusd with -X option,and the log is :

 

Tel : +33 3 88 14 81 76rad_recv: Access-Request packet from host 10.56.9.126:1645, id=46, length=77
        NAS-IP-Address = 10.56.9.126
        NAS-Port = 6
        NAS-Port-Type = Virtual
        User-Name = "alexsql"
        Calling-Station-Id = "10.46.7.31"
        Password = "\360T\237>:H\351\236\321A\027v\006\234U\324"
modcall: entering group authorize
  modcall[authorize]: module "preprocess" returns ok
  modcall[authorize]: module "suffix" returns ok
rlm_sql: Reserving sql socket id: 4
radius_xlat:  'alexsql'
sql_escape in:  'alexsql'
sql_escape out:  'alexsql'
sql_set_user:  escaped user --> 'alexsql'
radius_xlat:  'SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'alexsql' ORDER BY id'
SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'alexsql' ORDER BY id
radius_xlat:  'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value FROM radgroupcheck,usergroup WHERE usergroup.Username = 'alexsql' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value FROM radgroupcheck,usergroup WHERE usergroup.Username = 'alexsql' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id,UserName,Attribute,Value FROM radreply WHERE Username = 'alexsql' ORDER BY id'
SELECT id,UserName,Attribute,Value FROM radreply WHERE Username = 'alexsql' ORDER BY id
radius_xlat:  'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value FROM radgroupreply,usergroup WHERE usergroup.Username = 'alexsql' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value FROM radgroupreply,usergroup WHERE usergroup.Username = 'alexsql' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: Released sql socket id: 4
rlm_sql: Pairs do not match [alexsql]
  modcall[authorize]: module "sql" returns notfound
  modcall[authorize]: module "files" returns notfound
modcall: group authorize returns ok
auth: No Auth-Type configuration for the request, rejecting the user
auth: Failed to validate the user.
Login incorrect: [alexsql] (from nas A3LVJ-routeur port 6 cli 10.46.7.31)
  WARNING: Unprintable characters in the password. ?  Double-check the shared secret on the server and the NAS!
Sending Access-Reject of id 46 to 10.56.9.126:1645
Finished request 0

 

If you have some documentation on freeradius and mysql, i will be very happy to read it !

 

 

Rgds

Alex