R: R: Common error on sql_counter on Ver 2.1.5

[Mauro Iorio - Smart Soft s.r.l.]

> 
> 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.