On Fri, 19 Nov 2004, Joyce Choong wrote:
Hi All,
I am currently using freeradius version 0.8.1. I have been getting this strange record in my radacct table. I am using a Wireless Subscriber Gateway.
Kindly refer to the sample log below. ----------------+ | AcctSessionId | UserName | AcctStartTime | AcctStopTime | AcctSessionTime | +----------------------+----------+---------------------+------------------- --+-----------------+ | 00904b538dda0c000003 | zainal | 2004-10-18 16:29:25 | 2004-10-18 16:48:35 | 1140 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-10-19 12:52:56 | 16779 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-10-20 08:29:08 | 16779 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-10-21 08:23:18 | 16779 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-10-26 11:39:54 | 16779 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-11-03 09:32:03 | 16778 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-11-04 17:47:06 | 16779 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-11-10 09:38:39 | 16779 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-11-10 14:13:53 | 16779 | | 00904b538dda0c000003 | zainal | 0000-00-00 00:00:00 | 2004-11-19 08:24:13 | 16779 | +----------------------+----------+---------------------+------------------- --+-----------------+
This user 'zainal' actually has his final login session on 2004-10-18 16:29:25. His account expired on the following day. However, the later records were found added to my radacct table.
I am surprised to see the same AcctSessionId for all the logs.
Anyone has similar problem or have any idea on why this situation occurs ?
What does your accounting_stop_query look like? I 'll bet you have a 'AND AcctStopTime = 0' at the end. If that is the case, then the Gateway sent an accounting record, that got recorded in the database but the reply timed out. The Gateway kept sending the same request, accounting_stop_query failed since AcctStopTime != 0 and freeradius fell back to the accounting_stop_query_alt which is an INSERT. The replies for some reason didn't reach the Gateway so it sent the requests for a number of times (the number you 've probably configured it to do). Hope this clears things up.
Would appreciate help.
Thanks a lot !
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
