Duplicate accounting packets
Why would I see more than one start entry in the radacct table for a user all with the same session id? +-----------------+-----------+---------------------+---------------------+ | UserName | AccStatus | AcctStartTime | AcctStopTime | +-----------------+-----------+---------------------+---------------------+ | rpascoe@online | Start | 2006-10-13 12:39:08 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:15 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:22 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:30 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:37 | 0000-00-00 00:00:00 | Normally I wouldn't worry about it but I'm trying to script something that will show each users stats, time online, octets in/out etc. But having more than one start entry without a stop time for each is going to be a problem. Thanks John -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.0.408 / Virus Database: 268.13.3/473 - Release Date: 12/10/2006
On Fri, Oct 13, 2006 at 12:49:48PM +0100, John Williams wrote:
Why would I see more than one start entry in the radacct table for a user all with the same session id?
+-----------------+-----------+---------------------+---------------------+ | UserName | AccStatus | AcctStartTime | AcctStopTime | +-----------------+-----------+---------------------+---------------------+ | rpascoe@online | Start | 2006-10-13 12:39:08 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:15 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:22 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:30 | 0000-00-00 00:00:00 | | rpascoe@online | Start | 2006-10-13 12:39:37 | 0000-00-00 00:00:00 |
It seems you have some issues with your SQL queries. Stop Queries are probably not matching the already open record... ciao Luca
participants (2)
-
John Williams -
Luca Corti