----- Original Message ----- From: "Edgars" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 8:31 AM Subject: postgresql new column
> i have added one column named 'status' in the 'radacct' table. Then > changed a little bit 'accounting_start_qurey' (setting this variable to > TRUE) and 'acocunting_stop_query' (setting this variable to FALSE). You can determine an active session based on other database columns. For example if the Terminate-Cause is empty. > But > sometimes when users are disconnecting in unusual situation (not by them > own) the Status is TRUE all the time. Where is the mistake? Maybe i > should add also something to 'accounting_start_query_alt' and > 'accounting_stop_query_alt'? This is because the NAS was not able to send the Stop packets or any other reason why the Stop packet didn't reach the radius server. If you know the Acct-Interim-Interval, you could check for stale sessions and update the database accordingly. Thor. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
