Re: Duplicate accounting log entries

2007-04-04 Thread Patric
Hi again, Thanks a stack for your responses, I have a much better understanding of how it works now! Yes I do have the acct_unique_id setup as below, and have managed to weed out a lot of the duplication now. Dennis Skinner wrote: No. Look in the radius.conf for a section that looks like

Re: Duplicate accounting log entries

2007-04-04 Thread Dennis Skinner
Patric wrote: I am getting duplicate update's for that user from the NAS, where everything is identical including the input and output octets, which leads me to believe that the traffic is being combined and I actually only need 1 of the records. If I then make my unique_id column unique

Re: Duplicate accounting log entries

2007-04-04 Thread Patric
Hi guys, The NAS maintainer was nice enough to get back to me, and problem has been sorted out. This is what was happening: Their proxy servers are behind a load sharing device, which is why the retransmission of one of the records had a different client_ip_address, but both entries came from

Re: Duplicate accounting log entries

2007-04-04 Thread Dennis Skinner
Patric wrote: made the unique_id column unique in my database Careful with that last bit. Some NAS's can and do reuse their unique_id's. Especially if they are reloaded. Making sure the port is part of the key will help some, but I was still getting dupes in my db after several months of

Duplicate accounting log entries

2007-04-03 Thread Patric
Hi guys, Hope someone can help, as this has me banging my head on the wall :] I am getting duplicate updates from my NAS, and Im trying to figure out how to prevent them from being written to my accounting logs table. I unfortunately have absolutely no control over the NAS, so thats not even

Re: Duplicate accounting log entries

2007-04-03 Thread Patric
My apologies, a piece of my explanation is not right... please see below. Sorry, bit of a complex explanation... :] Hi guys, Hope someone can help, as this has me banging my head on the wall :] I am getting duplicate updates from my NAS, and Im trying to figure out how to prevent them from

Re: Duplicate accounting log entries

2007-04-03 Thread Alan DeKok
Patric wrote: I have 3 records for 3 different users all with the same acct_session_id. Your NAS is broken. Knowing that doesn't help much, but your NAS is definitely broken. 2 of these records have the same acct_unique_id, How? The default configuration of the server includes

Re: Duplicate accounting log entries

2007-04-03 Thread Patric
Alan DeKok wrote: Your NAS is broken. Knowing that doesn't help much, but your NAS is definitely broken. I suspected as much. Unfortunately it is a huge company whose NAS it is, and it is doubtful that the would notice my little squeek from down here... :] 2 of these records have the

Re: Duplicate accounting log entries

2007-04-03 Thread Dennis Skinner
Patric wrote: Post the key for the acct_unique module. Explain how two different User-Names can result in the same key. I couldnt begin to explain if I tried! lol I guess Im going to HAVE to try get some results from the people that control the NAS. No. Look in the radius.conf for a

Re: Duplicate accounting log entries

2007-04-03 Thread Alan DeKok
Patric wrote: I suspected as much. Unfortunately it is a huge company whose NAS it is, and it is doubtful that the would notice my little squeek from down here... :] They may listen to me. After doing this for nearly a decade, I have contacts at all of the big companies that matter. The