delayed update on sql logging

Marinko Tarlac mangia81 at gmail.com
Wed Sep 30 17:18:39 CEST 2009


two options
1. allow null for AcctStopTime field (Alter table radacct ....)
2. change queries in dialup.conf file for accounting (start query) and 
replace NULL with '0' for AcctStopTime

Keep in mind that second option is much harder then the first one 
because you need to change all accounting queries (where ever you see)
WHERE AcctStopTime = NULL
in
WHERE AcctStopTime = 0

Oguzhan Kayhan wrote:
> At the first try of sql i see the error
> rlm_sql (sql_lojnet): Couldn't insert SQL accounting START record - Column
> 'AcctStopTime' cannot be null
>
> Maybe that might be causing this...
> So how can i fix that???
>
>
>
>
>
>
>
>   
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>>     
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>   




More information about the Freeradius-Users mailing list