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