Hi,
I am new to freeradius. I need some help in using simultaneous-use for detecting double logins using mysql only. Here is my current set up:
> select * from radgroup check
+----+--------------- +---------------------------+----+-------+
| id | GroupName | Attribute | op | Value |
+----+----------------+----------------------------+----+-------+
| id | GroupName | Attribute | op | Value |
+----+----------------+----------------------------+----+-------+
| 2 | static | Auth-Type | == | Local |
+----+----------------+----------------------------+----+-------+
| 4 | static | Simultaneous-Use | := | 1 |
+----+----------------+----------------------------+-----+--------+
+----+----------------+----------------------------+----+-------+
| 4 | static | Simultaneous-Use | := | 1 |
+----+----------------+----------------------------+-----+--------+
> select * from usergroup
+----+-----------------+-----------------+
| id | UserName | GroupName |
+----+-----------------+-----------------+
| 33 | PW0000006 | static |
+----+------------------+----------------+
| id | UserName | GroupName |
+----+-----------------+-----------------+
| 33 | PW0000006 | static |
+----+------------------+----------------+
> select * from radcheck
+----+-------------------+----------------+----+--------------+
| id | UserName | Attribute | op | Value |
+----+-------------------+----------------+----+--------------+
| 18 | PW0000006 | Password | == | abcd |
+----+-------------------+----------------+-----+-------------+
| id | UserName | Attribute | op | Value |
+----+-------------------+----------------+----+--------------+
| 18 | PW0000006 | Password | == | abcd |
+----+-------------------+----------------+-----+-------------+
In my radius.conf I have a set up like this:
session {
sql
}
sql
}
In sql.conf, the "Simultaneous Use Checking Queries" are uncommented
I am using NTRadping to test for simultaneous-use and am failing to do so!
I am doing an accounting start using NTRadPing for the same user with a different NAS-IP-Address (Additional RADIUS attributes) and a different port NAS-Port (additional RADIUS attribute). Though simultaneous-use is setup the user is not stopped for double login at all. It creates two entries in the radaact table and when I run accounting stop it updates the relevant radacct records with the AcctStopTime.
Can anyone tell me where I am going wrong? This is urgent and I am clueless as to what else needs to be done. The sqltrace.log does not show that the uncommented statements in sql.conf are executed. How do I make sure that they get executed. Also please let me know if this is a correct procedure for testing the same.
Thanks in advance,
Soujanya
.
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
