Mark Hennessy wrote:
Do you have a line containing:Auth-Type System in your users file?
No, my user file is the default that came with freeradius
Default users file alreayd have this
You may want to try changing that to
Auth-Type := System
I just don't know what to do.
I have put "sql" in the authorize section like I read into a doc at frontios.com
What else should I do?
heres the complete log of what I get
rad_recv: Access-Request packet from host xxxxx:1645, id=95, length=147
User-Name = "servico"
User-Password = "1234"
NAS-IP-Address = xxxxxxxx
NAS-Port = 1539
Acct-Session-Id = "144"
USR-Interface-Index = 2795
Service-Type = Login-User
USR-Chassis-Call-Slot = 7
USR-Chassis-Call-Span = 1
USR-Chassis-Call-Channel = 3
Calling-Station-Id = "6218297"
Called-Station-Id = "8600"
NAS-Port-Type = Async
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
rlm_chap: Could not find proper Chap-Password attribute in request
modcall[authorize]: module "chap" returns noop
modcall[authorize]: module "mschap" returns notfound
rlm_realm: No '@' in User-Name = "servico", looking up realm NULL
rlm_realm: No such realm NULL
modcall[authorize]: module "suffix" returns noop
radius_xlat: 'servico'
rlm_sql (sql): sql_set_user escaped user --> 'servico'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE UserName = 'servico' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.UserName = 'servico' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE UserName = 'servico' ORDER BY id'
radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.UserName = 'servico' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns ok
users: Matched DEFAULT at 152
users: Matched DEFAULT at 226
modcall[authorize]: module "files" returns ok
modcall: group authorize returns ok
rad_check_password: Found Auth-Type System
auth: type "System"
auth: Failed to validate the user.
Delaying request 1 for 1 seconds
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
