Need help in double logins in radacct

[Sarkis Gabriel]

Hi All, 

I have seen this on one of my servers and now i am seeing it on another server, 
UniqueID is in place but that is not helping the system, when my accounting package is 
working out the hours loged in basicaly it is doubling the hours for the user.

3111972    81c153fe 	  dd510bfa724ddcdc 	14607   	XX.XX.XXX.10    
94025    Ethernet 2007-08-10 10:31:57 0000-00-00 00:00:00 0 RADIUS     0 0 PPPoE 
00:15:E9:BA:09:B5   Framed-User PPP 10.10.12.52 0 0 

3111973    81c153fe       dd510bfa724ddcdc 	14607  		XX.XX.XXX.10    
94025    Ethernet 2007-08-10 10:31:58 0000-00-00 00:00:00 0 RADIUS     0 0 PPPoE 
00:15:E9:BA:09:B5   Framed-User PPP 10.10.12.52 1 0 


>From what i notice that when a user Logs on, they create 2 sessions in the database, 
with 2nd session being +1second as can see above.
When the user logs off there AcctStopTime is the same for both sessions.

Hope that helps and hope to hear some more solutions on this issue.

Sarky
---------- Original Message -----------
From: <tnt at kalik.co.yu>
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Sent: Fri, 10 Aug 2007 09:30:58 +0100
Subject: Re: Need help in double logins in radacct

> 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
> >
> 
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------- End of Original Message -------