It is what I thought:  Accounting Stop packet should be the only thing that 
inserts dates.
Thanks.> To: freeradius-users@lists.freeradius.org> Subject: Re: accounting bug 
in Mikrotik> Date: Thu, 11 Dec 2008 10:59:26 +0100> From: [EMAIL PROTECTED]> > 
> I am working with freeradius and mikrotik gateway for a long time, but 
recently I detect in my PostgreSQL database, in radacct table some 
inconsistencies. First af all, I say that I have the standard configuration 
file (postgres.sql) for accounting queries.> > My problem is sometimes the 
field acctstoptime is full when the user is connected. I can see the user in my 
hotspot as alive session. What is my problem? the issue is all interim update 
queries are rejected because the SQL update query does not find the folloing 
SQL WHERE:> > AcctSessionId = '%{Acct-Session-Id}' AND UserName = 
'%{SQL-User-Name}' AND FramedIPAddress= '%{Framed-IP-Address}' AND AcctStopTime 
IS NULL> >because AcctStopTime = '<date>'> >> > If you are using default 
configuration you should have detail file logs> as well. That log is created 
for each NAS daily by default (NAS> IP/detail-date). Check the detail file to 
see if accounting Stop packet> was received while the session was still alive. 
Accounting Stop packet> should be the only thing that inserts dates there.> > 
Ivan Kalik> Kalik Informatika ISP> > -> List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html
_________________________________________________________________
Descarga el nuevo Messenger, más divertido que nunca.
http://download.live.com/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to