Accounting Start Queries getting lost

Ivan Kalik tnt at kalik.net
Mon Jun 29 18:44:32 CEST 2009


>> We are having an issue where, in some sessions, an Authentication
>> Request is sent successfully (and inserted into RADPOSTAUTH table), but
>> the Accounting Start Query is never run/received.
>>
>> Subsequently, Accounting Update Queries come through, but fail due to
>> the fact that a relevant RADACCT session has not been inserted to begin
>> with.
>>
>> It only happens in a small amount of cases, < 1% of sessions, but
>> nonetheless opens us to loss of data that is not being billed for
>> properly.
>>
>> Is this a known issue? Is there a workaround? We're looking at changing
>> the Acct Update Query to insert a new session if it cannot find an
>> existing one.

Default dialup.conf has alternative queries to deal with this. If UPDATE
fails it will do an INSERT. But if you have made custom queries ...

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list