R: Common error on sql_counter on Ver 2.1.5

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

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