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 test1@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 test1@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 test1@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