Need help in double logins in radacct

[Claudiu Filip]

Thursday, August 9, 2007, 10:38:27 AM, you wrote:
> could help me distinguish why it has double record in mysql. But
> when in radius logs,it has one request only.
> | RadAcctId | AcctSessionId | UserName   |
> |    517069 | 3C001FC0      | foo        | 
> |    517071 | 3C001FC0      | foo        | 
> |    517075 | 3C001FC0      | foo        | 

Hi Nelson,

RadAcctId is an autoincrement field, so it will be different for sure.
There is no reason to have those dups unless the INSERT query is run
multiple times.

1) Are you sure that you have only one request coming to fr?
   If no, the duplicates can be generated by the radius client if it
   doesnt get a reply quick enough. Decreasing database response time
   and increasing radius timeout on client can help.
   
2) AcctStopTime is different?
   If no, check 1) again :D
   If yes, maybe the radius client sends a weak AcctSessionId (you can
   create one using the acct_unique)

Best regards,

Claudiu Filip
@: claudiu at globtel.ro
Http://www.globtel.ro
T:+40344880100
F:+40344880113