delayed update on sql logging

Ivan Kalik tnt at kalik.net
Wed Sep 30 12:50:16 CEST 2009


>>> I am checking simultaneous-use information, logged users etc on sql
>>> server.
>>> The problem is, if a user logges in, nearly after a minute later i can
>>> see
>>> the logged on user on mysql tables. But i can see the same user with
>>> radlast command in the same second the user logs in.
>>> So it seems like there is a delay between updating the data on sql.
>>> And with this, user can log in mutliple times with same username even i
>>> set sim-use to 1.
>>>
>>> Is there any parameter for that???
>>> Or what else can cause that problem.
>>
>> Are you using buffered-sql accounting?
>>
> How can i check if i use buffered or not?? I didnt change much in default
> settings..

That would mean you don't.

Do a debug radiusd -Xx of login and see how much time passes between login
and accounting Start packet and is there a delay in inserting data into
sql on processing Start packet.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list