My guess is that the query is ok. It's used for cleaning up all open
accouting records (started, but not stopped) whenever your nas reboots.
It works fine for me.
Chris
On Tue, 2003-05-20 at 10:57, Sepp Rudel wrote:
> When looking at sql.conf and postgresql.conf I'm
> confused. In sql.conf accounting_onoff_query looks
> like:
>
> accounting_onoff_query = "UPDATE ${acct_table1} SET
> AcctStopTime='%S',
> AcctSessionTime=unix_timestamp('%S') -
> unix_timestamp(AcctStartTime),
> AcctTerminateCause='%{Acct-Terminate-Cause}',
> AcctStopDelay = %{Acct-Delay-Time} WHERE
> AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress=
> '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
>
> There's check for AcctStopTime=0, but it is also set
> (AcctStopTime='%S') which means that this on/off query
> can be used only once. When I read RFC 2866 I get the
> impression that Accounting-On and Accounting-Off are
> meant for mark a 'pause' in the accounting, e.g.,
> during reboot. Have I completely misunderstood this?
> Is the query really ok?
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
