Dailycounter not working

[Matej Žerovnik]

On 28.10.2014 21:26, Matej Žerovnik wrote:
>
> On 20.10.2014 23:40, Alan DeKok wrote:
>> Matej Žerovnik wrote:
>>>   Hello!
>>>
>>> I'm trying to use dailycounter on a LDAP authenticated user and it
>>> doesn't seem to work. I think I did all steps correctly, but then 
>>> again,
>>> i have been wrong before:)
>> ...
>>> rlm_sql (sql): Released sql socket id: 2
>>> [sql] User testuser not found
>>> ++[sql] returns notfound
>>    The "testuser" isn't found.  So the sqlcounter module can't do it's
>> job, because it doesn't know what value to use for the session limit. 
I posted this a while ago, but I'm trying my luck one more time if 
anyone can point me to the right direction:

This is the part that is giving me troubles...
My users exists in LDAP to which I don't have access, but I can 
authenticate with UserDN.
I added entry
testuser Max-Daily-Session := 600
to mysql radcheck table hoping radius will pick it up and use it in 
'dailycounter'.

Access-request packet looks like this:
rad_recv: Access-Request packet from host 10.10.10.10 port 33651, id=75, 
length=202
         NAS-Port-Type = Wireless-802.11
         Calling-Station-Id = "00:24:D7:47:1C:XX"
         Called-Station-Id = "hs-kit-testing"
         NAS-Port-Id = "bridge-bralci"
         User-Name = "testuser"
         NAS-Port = 2151677975
         Acct-Session-Id = "80400017"
         Framed-IP-Address = 192.168.81.198
         Mikrotik-Host-IP = 192.168.81.198
         User-Password = "password"
         Service-Type = Login-User
         WISPr-Logoff-URL = "http://192.168.81.1"
         NAS-Identifier = "kit-testing"
         NAS-IP-Address = 192.168.1.116

Can RADIUS use the username provided in access-request for the 
sqldailycounter?
Is that even suppose to work?
Can I use 'dailycounter' on LDAP  authenticated users or does that only 
work on local users, who are in sql database?

Matej

-- 
---
Matej Zerovnik