[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
PS. You have either disabled group checking or removed group membership query. Ivan Kalik Kalik Informatika ISP