Multiple Accounting in Radacct

[Gunther]

Hi, from what I see in the log files ... A start packet from the NAS 
has reached the FreeRadius server, but the ACK packet has
not reached the NAS, therefore the NAS is sending the packet again, and 
the ACK packet again did not reach ... a few times.
The last packet reached the NAS and accounting starts. But since there 
are now 3 identical accounting records in the db
  (with identical Unique IDs), all db records are updated at the same 
time. To avoid this I made the UniqueSessionID column
in the radacct table UNIQUE within MySQL. This avoids the creation of a 
duplicate records in the db.

On Mar 28, 2006, at 3:09 AM, zack musa wrote:
> Hi all.
>  Thanks for your reply gunther. Can you explain a bit of what might 
> happen when radius start duplicating/recording/receiving the same user 
> information 3 times in a row and some cases might be more, maximum i 
> got is 7 times in mysql database. what brings u to that solution?  Or 
> is there anyone else who got similar problems  before? user get 
> connection but recorded until 7 times within 40 seconds! Is this come 
> from NAS or radius server conifguration or MySQL?
>  Thanks to all.
>
>
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great 
> rates starting at 1¢/min.-
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1381 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060328/b5672fcb/attachment.bin>