<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:8pt"><font size="3">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.</font><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 8pt;"><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Nelson Serafica <ntserafica@yahoo.com><br>To: freeradius-users@lists.freeradius.org<br>Sent: Wednesday, September 12, 2007 1:33:30 PM<br>Subject: sometimes double records in radacct<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt;">I notice in my radacct that there are double records.
See sample below:<br><font size="1"><br>+-----------+---------------+------------------+----------+---------------------+---------------------+-------------------+----------------+<br>| RadAcctId | AcctSessionId | AcctUniqueId | UserName | AcctStartTime | AcctStopTime | ConnectInfo_start | AcctStartDelay |<br>+-----------+---------------+------------------+----------+---------------------+---------------------+-------------------+----------------+<br>| 531828 | 41002919 | a8003a3450fdcddc | glastec | 2007-09-12 11:18:32
| 2007-09-12 11:20:14 | | 0 |<br>| 531826 | 41002919 | a8003a3450fdcddc | glastec | 2007-09-12 11:18:33 | 2007-09-12 11:19:14 | 33333 LAPM/V42BIS | 0 |<br>+-----------+---------------+------------------+----------+---------------------+---------------------+-------------------+----------------+<br><br></font>I noticed that the difference (AcctStartTime,AcctStartDelay,ConnectInfo_start) are indicated in the accounting_start_query_alt parameters. <br><br>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. <br><br>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? </div></div><br>
<hr size="1"><font face="Arial" size="-1">
Tired of spam? Yahoo! Mail has the best spam protection around<br>
<a rel="nofollow" target="_blank" href="http://sg.rd.yahoo.com/mail/ph/footer/def/*http://ph.mail.yahoo.com%20">http://ph.mail.yahoo.com</a></font></div><br></div></div><br>
<hr size="1"><FONT face=Arial size=-1>
Tired of spam? Yahoo! Mail has the best spam protection around<BR>
<a href="http://sg.rd.yahoo.com/mail/ph/footer/def/*http://ph.mail.yahoo.com ">http://ph.mail.yahoo.com</a></FONT></body></html>