Hello Alan, Thanks for your reply. What's the difference between Client-IP-Address and NAS-IP-Address? I have the same IP in both. Thanks Aurelio Em 19/09/2016 10:23, Alan DeKok escreveu:
On Sep 19, 2016, at 8:29 AM, Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> wrote:
I'm using FreeRadius 2.2.9.
I'm experiencing some problems with acctuniqueid.
My users allways come from the same NAS, and I have this errors:
Error: [sql] Couldn't insert SQL accounting START record - Duplicate entry '8805551441c487d8' for key 'acctuniqueid'
Your NAS is garbage.
My acct_unique sesssion is:
acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" }
If all of those are identical, then the error message can be ignored.
Your NAS is garbage, and is sending two accounting "start" packets. It's not supposed to do that,
I think if I put additional clause like timestamp or something like this, I can solve my problem.
No. Do NOT put a timestamp into acct_unique. If it was a good idea, we would already have done it. It's not a good idea. It will create new acct_unique values for every single packet, even different packets for the same session.
It's a terrible idea. Leave everything alone, and ignore the message. Or, buy a NAS that works, and the message will go away,
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html