Mysql, dialup_admin and Freeradius Problem.

[Jamil Buchalla Neto]

I have all of then installed and running and added an user with dialup_admin but when I try to connect to my tc nas that user doesn't pass.

here is what I get:

rad_recv: Access-Request packet from host xxxxxxxx:1645, id=55, length=146
User-Name = "servico"
User-Password = "J{\234W\375\n\374\212'\314\262\367\340\372\0274"
NAS-IP-Address = xxxxxxxxxx
NAS-Port = 1538
Acct-Session-Id = "88"
USR-Interface-Index = 2794
Service-Type = Login-User
USR-Chassis-Call-Slot = 7
USR-Chassis-Call-Span = 1
USR-Chassis-Call-Channel = 2
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 FROM radcheck WHERE Username = 'servico' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql: The 'op' field for attribute 'User-Password = $1$C.zZID82$kp/ZF6uwfT3dIHwtLd1B70' is NULL, or non-existent.
rlm_sql: You MUST FIX THIS if you want the configuration to behave as you expect.
radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value FROM radgroupcheck,usergroup WHERE usergroup.Username = 'servico' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radreply WHERE Username = 'servico' ORDER BY id'
radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value FROM radgroupreply,usergroup WHERE usergroup.Username = 'servico' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Pairs do not match for user [servico]
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns notfound
users: Matched DEFAULT at 152
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.
WARNING: Unprintable characters in the password. ? Double-check the shared secret on the server and the NAS!
Delaying request 5 for 1 seconds
Finished request 5
Going to the next request



- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html