On Thu, 2009-08-20 at 08:55 +0200, Alan DeKok wrote:
. ... So, effectively, freeradius shows TWO live sessions for the same user. When we check the NASes, we see two sessions for the same user there as well.
Then the user has logged in twice. There really ARE two sessions.
Ok, fair enough. But, I've set up freeradius to not allow more than one session. How is a new row being added to radacct when the first one for the same user still has "acctstoptime" as NULL? I thought the sql queries were designed to stop that when using simultaneous checks, which I have set to 1. At worst, I expected the user to be denied access if, for example, the DB wasn't cleaned up after a NAS power loss, or after some event at the customer end.
Except for those people who log in twice.
If the NAS shows that they have two sessions, then they have two sessions.
I still don't understand how two live records for the same user can exist in radacct. The first live row should result in an access reject being generated by freeradius. I think something is wrong with my sql setup. I just don't know what it could be after pouring over everything. What could I be missing? Regards, Ranbir -- Kanwar Ranbir Sandhu Linux 2.6.27.29-170.2.78.fc10.x86_64 x86_64 GNU/Linux 11:45:32 up 4 days, 12:42, 5 users, load average: 1.21, 1.18, 0.91