[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: freeradius2.1.6| buffered-sql | acctstoptime problems
From:       "Ivan Kalik" <tnt () kalik ! net>
Date:       2009-08-31 14:27:19
Message-ID: 63299.87.194.16.13.1251728839.squirrel () webmail ! kalik ! net
[Download RAW message or body]

> I'm using freeradius2.1.6 with buffered-sql , detail files for accounting.
> In accounting queries i observed acctstoptime = %S.
> my db some how freezed and radius stopped updating packets from
> detail.wotk
> file. When restarted it started updating but updating the packets with new
> timestamps instead of old timestmaps whatever in detail.work file. How to
> overcome this? please suggest.

Timestamps for Accounting-Start-Time and Accounting-Stop-Time will be
"wrong" but you should have delay times logged on the same radacct line.
If your billing application can't calculate the correct time from the
timestamp and the delayyou can run a sql query in order to "correct" the
times in Accounting-Start-Time and Accounting-Stop-Time fields.

Ivan Kalik
Kalik Informatika ISP

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]