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@kalik.co.yu> To: "FreeRadius users mailing list" <freeradius-users@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@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@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
____________________________________________________ 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 -------