I'm experiencing a weird problem here. My authentication works
fine up until when I try to supply a "Simultaneous-Use". Here's the
error msg. radiusd gives me in Debug mode when I try to authenticate
with a "Simultaneous-Use". It works fine if I take the Simultaneous-Use
out. I checked and there's definitely no other users connected with that
same account.
=========================================================
The error Radiusd gave me Running in Debug mode
=========================================================
Sending Access-Reject of id 100 to 196.25.219.71:1424
rad_recv: Access-Request packet from host 196.25.219.71:1452, id=101,
length=45
User-Name = "test2"
Password = "5\030\362\347\004\342\371\245\0232\004\3040/\235&"
rlm_sql: Reserving sql socket id: 4
SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'test2'
ORDER BY id
Password = "test"
SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value FROM radgroupcheck,usergroup WHERE usergroup.Username = 'test2' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
Password = "test"
Simultaneous-Use = 1
SELECT id,UserName,Attribute,Value FROM radreply WHERE Username = 'test2'
ORDER BY id
SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value FROM radgroupreply,usergroup WHERE usergroup.Username = 'test2' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
Service-Type = Framed-User
Service-Type = Framed-User
Framed-Protocol = PPP
rlm_sql: Released sql socket id: 4
rlm_sql: Pairs do not match [test2]
Sending Access-Reject of id 101 to 196.25.219.71:145
=========================================================
This is what my SQL tables look like.
=========================================================
Talble config.
==============
mysql> select * from radcheck;
+----+----------+-----------+-------+
| id | UserName | Attribute | Value |
+----+----------+-----------+-------+
| 1 | test1 | Password | test |
+----+----------+-----------+-------+
mysql> select * from radgroupreply;
+----+-----------+-----------------+-------------+
| id | GroupName | Attribute | Value |
+----+-----------+-----------------+-------------+
| 1 | norm | Service-Type | Framed-user |
| 2 | norm | Framed-Protocol | PPP |
+----+-----------+-----------------+-------------+
2 rows in set (0.00 sec)
mysql> select * from usergroup;
+----+----------+-----------+
| id | UserName | GroupName |
+----+----------+-----------+
| 1 | test1 | norm |
+----+----------+-----------+
2 rows in set (0.00 sec)
mysql> select * from radgroupcheck;
+----+-----------+------------------+-------+
| id | GroupName | Attribute | Value |
+----+-----------+------------------+-------+
| 1 | norm | Simultaneous-Use | 1 |
+----+-----------+------------------+-------+
1 row in set (0.00 sec)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
