Where can i get that Acct-Interim-Interval?
Thanx!
Edgars
Thor Spruyt wrote:
----- 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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
