sometimes double records in radacct

Thu Sep 13 10:40:29 CEST 2007

I’ve seen this happening too,
We have some nases that are not on local network and they are sending packets on sometimes unstable networks(VPN,Internet)...
I think what happens is that since the nas doesn't get the reply in the given time, it will resend the last packet...
Sometimes interim packet and stop packets are sent almost at the same time, but stop packet gets to the radius server first and then the interim packet ...

Parham

From: freeradius-users-bounces at lists.freeradius.org [mailto:freeradius-users-bounces at lists.freeradius.org] On Behalf Of Nelson Serafica
Sent: Wednesday, September 12, 2007 9:20 AM
To: freeradius-users at lists.freeradius.org
Subject: Re: sometimes double records in radacct

Is it advisable that I uncomment the accounting_start_query_alt? Would there be conflict to other query commands like accounting_stop_query_alt, accounting_stop_query, etc.

----- Original Message ----
From: Nelson Serafica <ntserafica at yahoo.com>
To: freeradius-users at lists.freeradius.org
Sent: Wednesday, September 12, 2007 1:33:30 PM
Subject: sometimes double records in radacct
I notice in my radacct that there are double records. See sample below:

+-----------+---------------+------------------+----------+---------------------+---------------------+-------------------+----------------+
| RadAcctId | AcctSessionId | AcctUniqueId     | UserName | AcctStartTime       | AcctStopTime        | ConnectInfo_start | AcctStartDelay |
+-----------+---------------+------------------+----------+---------------------+---------------------+-------------------+----------------+
|    531828 | 41002919      | a8003a3450fdcddc | glastec  | 2007-09-12 11:18:32 | 2007-09-12 11:20:14 |                   |              0 |
|    531826 | 41002919      | a8003a3450fdcddc | glastec  | 2007-09-12 11:18:33 | 2007-09-12 11:19:14 | 33333 LAPM/V42BIS |              0 |
+-----------+---------------+------------------+----------+---------------------+---------------------+-------------------+----------------+

I noticed that the difference (AcctStartTime,AcctStartDelay,ConnectInfo_start) are indicated in the accounting_start_query_alt parameters. 

If you will noticed, there are identical AcctSessionId which was supposed to be none and the difference between them is the one that is updated by accounting_start_query_alt. It must not be identical. The problem is there are identical AcctSessionId. 

Would it be possible that the culprit is in the accounting_start_query_alt parameters?  Is the accounting_start_query failing that's why accounting_start_query_alt take over? accounting_start_query is not broken and one line only. Is there a way to increase time before  accounting_start_query_alt takes over? 

________________________________________
Tired of spam? Yahoo! Mail has the best spam protection around
http://ph.mail.yahoo.com