Hello All, 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' My acct_unique sesssion is: acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } I think if I put additional clause like timestamp or something like this, I can solve my problem. Any suggestion? Aurelio
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.
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
On Sep 19, 2016, at 2:00 PM, Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> wrote:
What's the difference between Client-IP-Address and NAS-IP-Address? I have the same IP in both.
Client-IP-Address is the address that the packet came from. NAS-IP-Address is the address that the NAS thinks it has. They may be the same. If the packet came from the NAS. If the packet came from a proxy, they may be different. Alan DeKok.
Hi,
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'
My acct_unique sesssion is:
acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" }
NAS-IP-Address will be the same....same for NAS-Port - you will need to run in debug to see what is coming your way that you can key a better unique value from - eg Calling-Station-Id. certainly do NOT use the timestamp! :/ alan
Hi, Thanks for your answer! Calling-Station ID for me allways be the same for my users too. I will try debug mode Thanks Aurelio Em 19/09/2016 10:32, A.L.M.Buxey@lboro.ac.uk escreveu:
Hi,
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'
My acct_unique sesssion is:
acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" }
NAS-IP-Address will be the same....same for NAS-Port - you will need to run in debug to see what is coming your way that you can key a better unique value from - eg Calling-Station-Id.
certainly do NOT use the timestamp! :/
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Aurélio de Souza Ribeiro Neto