> > PS. You have either disabled group checking or removed group membership > query. > > Ivan Kalik > Kalik Informatika ISP > >
None of them. Group checking is enabled (read_groups = yes) and the query (authorize_group_check_query = "SELECT ... ") is defined in sql module. But simply the query isn't executed. Any Ideas? Now the attribute is Cleartext-Password and the op is := in radcheck ... The output now is shorter (without any warnings) but still no counter. Here it is: -------------------------- Ready to process requests. rad_recv: Access-Request packet from host 192.168.4.203 port 37145, id=67, lengt h=76 User-Name = "mauro" User-Password = "flower" 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: 4 [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() [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: 4 ++[sql] returns ok rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[sessioncounter] returns noop 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 67 to 192.168.4.203 port 37145 Finished request 0. Going to the next request Waking up in 4.9 seconds. Cleaning up request 0 ID 67 with timestamp +134 Ready to process requests. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html