Re: Need help in double logins in radacct

Hi Claudiu,

Thanks for the reply. With regards to your questions:

1. I'm sure there is only one request as I see in the logs. It has only one request and authentication. When I check the livingston portmaster using snmp, it shows the login users and there is no duplicate or simultaneous users login.

However, i will try to research how can I decrease database response time and increase radius timeout. I will check it out in the radius conf. Could you tell me what config file where i can increase/decrease those timeout?

2. AcctStopTime is different. The difference is not more than 4 mins. Sometime seconds or 2 mins. Here is the sample.

+-----------+---------------+----------+---------------------+---------------------+
| RadAcctId | AcctSessionId | UserName | AcctStartTime       | AcctStopTime        |
+-----------+---------------+----------+---------------------+---------------------+
|    517544 | E10007F4      | foo            | 2007-08-09 23:33:44 | 2007-08-10 00:13:25 |
|    517561 | E10007F4      | foo        | 2007-08-09 23:33:44 | 2007-08-10 00:14:25 |

----- Original Message ----
From: Claudiu Filip <claudiu@globtel.ro>
To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>
Sent: Thursday, August 9, 2007 5:51:54 PM
Subject: Re: Need help in double logins in radacct

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@globtel.ro
Http://www.globtel.ro
T:+40344880100
F:+40344880113

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html