Need help in double logins in radacct
Need help! I maintained a dial-up ISP. I'm new to this company and I'm not the one who setup the server. With all 4 freeradius server, one has a problem. It has double logs in mysql (radacct). Meaning two different RadAcctId but with the same AcctSessionId. Is there anyone could help me distinguish why it has double record in mysql. But when in radius logs,it has one request only. Here is the sample: | RadAcctId | AcctSessionId | UserName | | 517069 | 3C001FC0 | foo | | 517071 | 3C001FC0 | foo | | 517075 | 3C001FC0 | foo | Server has 192MB memory and running in 300Mhz processor with kernel version 2.4. I already upgrade to the latest freeradius version but still no luck. Anyone already experienced this kind of problem? Please show me the link or at least the possible solution. ____________________________________________________ Tired of spam? Yahoo! Mail has the best spam protection around http://ph.mail.yahoo.com
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
participants (2)
-
Claudiu Filip -
Nelson Serafica