Need help in double logins in radacct

[tnt at kalik.co.yu]

It look like the accounting update query that should update the entry is
failing and an alternative one which inserts a new row is executed.
First check that the update query in sql.conf is not broken and then run
the server in debug mode and see why is that query failing.

Ivan Kalik
Kalik Informatika ISP


Dana 10/8/2007, "Nelson Serafica" <ntserafica at yahoo.com> piše:

>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 at globtel.ro>
>To: FreeRadius users mailing list <freeradius-users at 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 at globtel.ro
>Http://www.globtel.ro
>T:+40344880100
>F:+40344880113
>
>
>
>- 
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>
>
>
>
>
>
>      
>____________________________________________________ 
>Tired of spam? Yahoo! Mail has the best spam protection around 
>http://ph.mail.yahoo.com
>