On Tue, 2009-07-21 at 19:13 +0100, Ivan Kalik wrote: > > So, why are there multiple records for the same session being created in > > radacct at all? We obviously have something misconfigured, but I can't > > put my finger on it. > > Hard to say. Are those queries running on the server or has your mailer or > editor cut off parts of them? Those in the debug shouldn't run at all.
It was a straight copy and paste from the debug. Evolution can be a pain, but I'm fairly certain it didn't cut anything off (apart from the ugly wrapping). > I can see that updates and stop packets run both update and insert (alt) > queries. That would mean that update didn't match any records. There might > be issues with mysql safe characters in your acct id: > > > Acct-Session-Id = "erx atm 2/0.42:100.412:0001049285" > > Have a look and see what is actually in the database. The DB shows the exact same Acct-Session-Id that is in the packets themselves. Below are the three rows that get entered into radacct when the AAA test is run from the E120. Is it the "=" in the callingstationid field that's throwing things off? erx atm 2/0.42:100.416:000104929 58eb6e48d17d83d4 te...@blah.ca blah.ca 1.2.3.4 543424928 xDSL 2009-07-21 14:39:47 NULL 0 RADIUS speed:UBR:12000 0 0 =23company-E120-1=23this is a description=23100= Framed-User PPP 4.5.6.7 0 0 erx atm 2/0.42:100.416:000104929 58eb6e48d17d83d4 te...@blah.ca blah.ca 1.2.3.4 543424928 xDSL 2009-07-21 14:39:47 NULL 0 RADIUS NULL 0 0 =23company-E120-1=23this is a description=23100= Framed-User PPP 4.5.6.7 0 NULL erx atm 2/0.42:100.416:000104929 58eb6e48d17d83d4 te...@blah.ca blah.ca 1.2.3.4 543424928 xDSL 2009-07-21 14:39:55 2009-07-21 14:40:05 10 RADIUS speed:UBR:12000 4600387192 4619473478 =23company-E120-1=23this is a description=23100= Admin-Reset Framed-User PPP 4.5.6.7 0 0 NULL Regards, Ranbir -- Kanwar Ranbir Sandhu Linux 2.6.27.25-170.2.72.fc10.x86_64 x86_64 GNU/Linux 14:32:20 up 3 days, 21:03, 3 users, load average: 1.52, 1.59, 1.60 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
