User entry didn't match. Post the debug (radiusd -X) and the user entry. You wouldn't be using User-Password as the password attribute?
From radcheck table Id Username Attribute Value op 7216 mauro Password flower ==
From usergroup table Id Username GroupName 14194 mauro 60
From radgroupcheck table ID GroupName Attribute Value op 2 60 Max-All-Session 3600 :=
radreply table is empty as it was with 1.1.x Command line user for testing radclient 192.168.4.203:1812 auth abcdefgh -f radius.packet -t 5000 radius.packet file User-Name = "mauro" User-Password = "mauropwd" NAS-IP-Address = 127.0.0.1 NAS-Port = 1 Called-Station-ID = "00-03-9D-4A-0A-0A" Below there is the debug (radiusd -X) output: Thanks, Mauro. --------------------------------------------- debug (radiusd -X) output: Ready to process requests. rad_recv: Access-Request packet from host 192.168.4.203 port 47750, id=224, length=76 User-Name = "mauro" User-Password = "mauropwd" NAS-IP-Address = 127.0.0.1 NAS-Port = 1 Called-Station-Id = "00-03-9D-4A-0A-0A" +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop [sql] expand: %{User-Name} -> mauro [sql] sql_set_user escaped user --> 'mauro' rlm_sql (sql): Reserving sql socket id: 0 [sql] expand: SELECT id, UserName, Attribute, Value, op FROM UtentiAutorizzati WHERE UserName = '%{SQL-User-Name}' AND MACADDWAN = '%{Called-Station-Id}' AND (CheckOnLine - UtentiConnessi) > 0 AND DataScadenza > GetDate() -> SELECT id, Us erName, Attribute, Value, op FROM UtentiAutorizzati WHERE UserName = 'mauro' AND MACADDWAN = '00-03-9D-4A-0A-0A' AND (CheckOnLine - UtentiConnessi) > 0 AND Data Scadenza > GetDate() query: SELECT id, UserName, Attribute, Value, op FROM UtentiAutorizzati WHERE U serName = 'mauro' AND MACADDWAN = '00-03-9D-4A-0A-0A' AND (CheckOnLine - UtentiC onnessi) > 0 AND DataScadenza > GetDate() WARNING: Found User-Password == "...". WARNING: Are you sure you don't mean Cleartext-Password? WARNING: See "man rlm_pap" for more information. [sql] User found in radcheck table [sql] expand: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Userna me = '%{SQL-User-Name}' ORDER BY id -> SELECT id,UserName,Attribute,Value,op FRO M radreply WHERE Username = 'mauro' ORDER BY id query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'ma uro' ORDER BY id rlm_sql (sql): Released sql socket id: 0 ++[sql] returns ok rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[sessioncounter] returns noop !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! !!! Replacing User-Password in config items with Cleartext-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! !!! Please update your configuration so that the "known good" !!! !!! clear text password is in Cleartext-Password, and not in User-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! WARNING: Please update your configuration, and remove 'Auth-Type = Local' WARNING: Use the PAP or CHAP modules instead. User-Password in the request is correct. +- entering group post-auth {...} ++[exec] returns noop Sending Access-Accept of id 224 to 192.168.4.203 port 47750 Finished request 9. Going to the next request Waking up in 4.9 seconds. Cleaning up request 9 ID 224 with timestamp +194 Ready to process requests.