Hi Alan,<br><br>Thank you for the response.<br><br>Below you can see my user in the table as well as the radius -X.<br><br>I don't really see any problems, can you?<br><br><br>Thanks,<br>T<br><br>mysql> select * from radcheck where username="71485392";<br>
+--------+----------+--------------------+----+-----------+<br>| id | username | attribute | op | value |<br>+--------+----------+--------------------+----+-----------+<br>| 810890 | 71485392 | Auth-Type | := | Perl | <br>
| 810891 | 71485392 | databank | := | 104305655 | <br>| 810892 | 71485392 | Cleartext-Password | := | password | <br>| 810893 | 71485392 | Max-All-Session | := | 3600 | <br>| 810894 | 71485392 | Expire-After | := | 864000 | <br>
| 810895 | 71485392 | Simultaneous-Use | := | 1 | <br>| 810896 | 71485392 | Idle-Timeout | := | 300 | <br>| 810897 | 71485392 | Cleartext-Password | := | password | <br>+--------+----------+--------------------+----+-----------+<br>
<br><br><br><br>Listening on proxy address * port 1814<br>Ready to process requests.<br>rad_recv: Access-Request packet from host 192.168.4.28 port 46819, id=100, length=175<br> NAS-Port-Type = Wireless-802.11<br> Calling-Station-Id = "00:1E:64:8E:1F:8E"<br>
Called-Station-Id = "hotspot1"<br> NAS-Port-Id = "Guest"<br> User-Name = "71485392"<br> NAS-Port = 2154823729<br> Acct-Session-Id = "80700031"<br> Framed-IP-Address = 10.20.30.253<br>
Mikrotik-Host-IP = 10.20.30.253<br> User-Password = "password"<br> Service-Type = Login-User<br> WISPr-Logoff-URL = "<a href="http://10.20.30.1/logout">http://10.20.30.1/logout</a>"<br> NAS-Identifier = "TEST2"<br>
NAS-IP-Address = 192.168.4.28<br>+- entering group authorize {...}<br>++[preprocess] returns ok<br>++[chap] returns noop<br>++[mschap] returns noop<br>[suffix] No '@' in User-Name = "71485392", looking up realm NULL<br>
[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>[eap] No EAP-Message, not doing EAP<br>++[eap] returns noop<br>++[unix] returns notfound<br>[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>
rlm_sql (sql): Reserving sql socket id: 3<br>[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '71485392' ORDER BY id<br>
[sql] User found in radcheck table<br>[sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = '71485392' ORDER BY id<br>
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '71485392' ORDER BY priority<br>
rlm_sql (sql): Released sql socket id: 3<br>++[sql] returns ok<br>rlm_sqlcounter: Entering module authorize code<br>rlm_sqlcounter: Could not find Check item value pair<br>++[monthyoctets] returns noop<br>++[expiration] returns noop<br>
++[logintime] returns noop<br>[pap] Found existing Auth-Type, not changing it.<br>++[pap] returns noop<br>rlm_sqlcounter: Entering module authorize code<br>sqlcounter_expand: 'SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='%{User-Name}' ORDER BY acctstarttime LIMIT 1;'<br>
[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='%{User-Name}' ORDER BY acctstarttime LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;<br>
sqlcounter_expand: '%{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;}'<br>[expire_on_login] sql_xlat<br>
[expire_on_login] expand: %{User-Name} -> 71485392<br>[expire_on_login] sql_set_user escaped user --> '71485392'<br>[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;<br>
rlm_sql (sql): Reserving sql socket id: 2<br>[expire_on_login] sql_xlat finished<br>rlm_sql (sql): Released sql socket id: 2<br>[expire_on_login] expand: %{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;} -> 6161<br>
rlm_sqlcounter: Check item is greater than query result<br>rlm_sqlcounter: Authorized user 71485392, check_item=864000, counter=6161<br>rlm_sqlcounter: Sent Reply-Item for user 71485392, Type=Session-Timeout, value=857839<br>
++[expire_on_login] returns ok<br>rlm_sqlcounter: Entering module authorize code<br>sqlcounter_expand: 'SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}''<br>[noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'<br>
sqlcounter_expand: '%{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'}'<br>[noresetcounter] sql_xlat<br>[noresetcounter] expand: %{User-Name} -> 71485392<br>[noresetcounter] sql_set_user escaped user --> '71485392'<br>
[noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'<br>rlm_sql (sql): Reserving sql socket id: 1<br>
[noresetcounter] sql_xlat finished<br>rlm_sql (sql): Released sql socket id: 1<br>[noresetcounter] expand: %{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'} -> 205<br>rlm_sqlcounter: Check item is greater than query result<br>
rlm_sqlcounter: Authorized user 71485392, check_item=3600, counter=205<br>rlm_sqlcounter: Sent Reply-Item for user 71485392, Type=Session-Timeout, value=3395<br>++[noresetcounter] returns ok<br>Found Auth-Type = Perl<br>+- entering group Perl {...}<br>
GOT CLONE -1208038704 0x93f53d8<br>rlm_perl: Added pair NAS-Port-Type = Wireless-802.11<br>rlm_perl: Added pair WISPr-Logoff-URL = <a href="http://10.20.30.1/logout">http://10.20.30.1/logout</a><br>rlm_perl: Added pair Acct-Session-Id = 80700031<br>
rlm_perl: Added pair SQL-User-Name = 71485392<br>rlm_perl: Added pair Service-Type = Login-User<br>rlm_perl: Added pair Called-Station-Id = hotspot1<br>rlm_perl: Added pair Calling-Station-Id = 00:1E:64:8E:1F:8E<br>rlm_perl: Added pair User-Name = 71485392<br>
rlm_perl: Added pair NAS-Identifier = TEST2<br>rlm_perl: Added pair User-Password = password<br>rlm_perl: Added pair Mikrotik-Host-IP = 10.20.30.253<br>rlm_perl: Added pair Framed-IP-Address = 10.20.30.253<br>rlm_perl: Added pair NAS-IP-Address = 192.168.4.28<br>
rlm_perl: Added pair NAS-Port = 2154823729<br>rlm_perl: Added pair NAS-Port-Id = Guest<br>rlm_perl: Added pair Session-Timeout = 3395<br>rlm_perl: Added pair Mikrotik-Xmit-Limit = 104305655<br>rlm_perl: Added pair Idle-Timeout = 300<br>
rlm_perl: Added pair Cleartext-Password = password<br>rlm_perl: Added pair Expire-After = 864000<br>rlm_perl: Added pair Max-All-Session = 3600<br>rlm_perl: Added pair Simultaneous-Use = 1<br>rlm_perl: Added pair databank = 104305655<br>
rlm_perl: Added pair Auth-Type = Perl<br>++[perl] returns ok<br>+- entering group session {...}<br>[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>[sql] expand: SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL -> SELECT COUNT(*) FROM radacct WHERE username = '71485392' AND acctstoptime IS NULL<br>
rlm_sql (sql): Reserving sql socket id: 0<br>rlm_sql (sql): Released sql socket id: 0<br>++[sql] returns ok<br>Login OK: [71485392/password] (from client TEST2 port 2154823729 cli 00:1E:64:8E:1F:8E)<br>+- entering group post-auth {...}<br>
[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>[sql] expand: %{User-Password} -> password<br>[sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '71485392', 'password', 'Access-Accept', '2010-08-13 11:57:42')<br>
rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '71485392', 'password', 'Access-Accept', '2010-08-13 11:57:42')<br>
rlm_sql (sql): Reserving sql socket id: 4<br>rlm_sql (sql): Released sql socket id: 4<br>++[sql] returns ok<br>++[exec] returns noop<br>Sending Access-Accept of id 100 to 192.168.4.28 port 46819<br> Session-Timeout = 3395<br>
Mikrotik-Xmit-Limit = 104305655<br>Finished request 0.<br>Going to the next request<br>Waking up in 4.9 seconds.<br>rad_recv: Accounting-Request packet from host 192.168.4.28 port 32987, id=101, length=137<br> Acct-Status-Type = Start<br>
NAS-Port-Type = Wireless-802.11<br> Calling-Station-Id = "00:1E:64:8E:1F:8E"<br> Called-Station-Id = "hotspot1"<br> NAS-Port-Id = "Guest"<br> User-Name = "71485392"<br>
NAS-Port = 2154823729<br> Acct-Session-Id = "80700031"<br> Framed-IP-Address = 10.20.30.253<br> Mikrotik-Host-IP = 10.20.30.253<br> Event-Timestamp = "Jan 2 1970 02:16:43 SAST"<br> NAS-Identifier = "TEST2"<br>
NAS-IP-Address = 192.168.4.28<br> Acct-Delay-Time = 0<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 2154823729,Client-IP-Address = 192.168.4.28,NAS-IP-Address = 192.168.4.28,Acct-Session-Id = "80700031",User-Name = "71485392"'<br>
[acct_unique] Acct-Unique-Session-ID = "ff0a9b7762ab9e6f".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "71485392", looking up realm NULL<br>[suffix] No such realm "NULL"<br>
++[suffix] returns noop<br>++[files] returns noop<br>+- entering group accounting {...}<br>[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>[sql] expand: %{Acct-Delay-Time} -> 0<br>
[sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, NASIdentifier, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '<br>
rlm_sql (sql): Reserving sql socket id: 3<br>rlm_sql (sql): Released sql socket id: 3<br>++[sql] returns ok<br>[attr_filter.accounting_response] expand: %{User-Name} -> 71485392<br> attr_filter: Matched entry DEFAULT at line 12<br>
++[attr_filter.accounting_response] returns updated<br>Sending Accounting-Response of id 101 to 192.168.4.28 port 32987<br>Finished request 1.<br>Cleaning up request 1 ID 101 with timestamp +36<br>Going to the next request<br>
Waking up in 4.9 seconds.<br>Cleaning up request 0 ID 100 with timestamp +36<br>Ready to process requests.<br>rad_recv: Access-Request packet from host 192.168.4.251 port 1025, id=196, length=192<br> User-Name = "71485392"<br>
User-Password = "password"<br> NAS-IP-Address = 192.168.4.251<br> NAS-Port = 0<br> Service-Type = Login-User<br> Acct-Session-Id = "EB000063"<br> Called-Station-Id = "00-50-E8-02-53-90"<br>
Calling-Station-Id = "00-1D-E0-43-D5-8F"<br> Nomadix-Logoff-URL = "<a href="http://1.1.1.1">http://1.1.1.1</a>"<br> WISPr-Location-ID = "isocc=,cc=,ac=,network=Firedigit"<br> NAS-Identifier = "JonnyLAW"<br>
NAS-Port-Type = ISDN<br>+- entering group authorize {...}<br>++[preprocess] returns ok<br>++[chap] returns noop<br>++[mschap] returns noop<br>[suffix] No '@' in User-Name = "71485392", looking up realm NULL<br>
[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>[eap] No EAP-Message, not doing EAP<br>++[eap] returns noop<br>++[unix] returns notfound<br>[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>
rlm_sql (sql): Reserving sql socket id: 2<br>[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '71485392' ORDER BY id<br>
[sql] User found in radcheck table<br>[sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = '71485392' ORDER BY id<br>
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '71485392' ORDER BY priority<br>
rlm_sql (sql): Released sql socket id: 2<br>++[sql] returns ok<br>rlm_sqlcounter: Entering module authorize code<br>rlm_sqlcounter: Could not find Check item value pair<br>++[monthyoctets] returns noop<br>++[expiration] returns noop<br>
++[logintime] returns noop<br>[pap] Found existing Auth-Type, not changing it.<br>++[pap] returns noop<br>rlm_sqlcounter: Entering module authorize code<br>sqlcounter_expand: 'SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='%{User-Name}' ORDER BY acctstarttime LIMIT 1;'<br>
[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='%{User-Name}' ORDER BY acctstarttime LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;<br>
sqlcounter_expand: '%{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;}'<br>[expire_on_login] sql_xlat<br>
[expire_on_login] expand: %{User-Name} -> 71485392<br>[expire_on_login] sql_set_user escaped user --> '71485392'<br>[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;<br>
rlm_sql (sql): Reserving sql socket id: 1<br>[expire_on_login] sql_xlat finished<br>rlm_sql (sql): Released sql socket id: 1<br>[expire_on_login] expand: %{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='71485392' ORDER BY acctstarttime LIMIT 1;} -> 6186<br>
rlm_sqlcounter: Check item is greater than query result<br>rlm_sqlcounter: Authorized user 71485392, check_item=864000, counter=6186<br>rlm_sqlcounter: Sent Reply-Item for user 71485392, Type=Session-Timeout, value=857814<br>
++[expire_on_login] returns ok<br>rlm_sqlcounter: Entering module authorize code<br>sqlcounter_expand: 'SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}''<br>[noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'<br>
sqlcounter_expand: '%{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'}'<br>[noresetcounter] sql_xlat<br>[noresetcounter] expand: %{User-Name} -> 71485392<br>[noresetcounter] sql_set_user escaped user --> '71485392'<br>
[noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'<br>rlm_sql (sql): Reserving sql socket id: 0<br>
[noresetcounter] sql_xlat finished<br>rlm_sql (sql): Released sql socket id: 0<br>[noresetcounter] expand: %{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='71485392'} -> 205<br>rlm_sqlcounter: Check item is greater than query result<br>
rlm_sqlcounter: Authorized user 71485392, check_item=3600, counter=205<br>rlm_sqlcounter: Sent Reply-Item for user 71485392, Type=Session-Timeout, value=3395<br>++[noresetcounter] returns ok<br>Found Auth-Type = Perl<br>+- entering group Perl {...}<br>
rlm_perl: Added pair NAS-Port-Type = ISDN<br>rlm_perl: Added pair Acct-Session-Id = EB000063<br>rlm_perl: Added pair SQL-User-Name = 71485392<br>rlm_perl: Added pair Service-Type = Login-User<br>rlm_perl: Added pair Calling-Station-Id = 00-1D-E0-43-D5-8F<br>
rlm_perl: Added pair Called-Station-Id = 00-50-E8-02-53-90<br>rlm_perl: Added pair WISPr-Location-ID = isocc=,cc=,ac=,network=Firedigit<br>rlm_perl: Added pair User-Name = 71485392<br>rlm_perl: Added pair NAS-Identifier = JonnyLAW<br>
rlm_perl: Added pair User-Password = password<br>rlm_perl: Added pair Nomadix-Logoff-URL = <a href="http://1.1.1.1">http://1.1.1.1</a><br>rlm_perl: Added pair NAS-IP-Address = 192.168.4.251<br>rlm_perl: Added pair NAS-Port = 0<br>
rlm_perl: Added pair Session-Timeout = 3395<br>rlm_perl: Added pair Nomadix-MaxBytesDown = 104305655<br>rlm_perl: Added pair Idle-Timeout = 300<br>rlm_perl: Added pair Cleartext-Password = password<br>rlm_perl: Added pair Expire-After = 864000<br>
rlm_perl: Added pair Max-All-Session = 3600<br>rlm_perl: Added pair Simultaneous-Use = 1<br>rlm_perl: Added pair databank = 104305655<br>rlm_perl: Added pair Auth-Type = Perl<br>++[perl] returns ok<br>+- entering group session {...}<br>
[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>[sql] expand: SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL -> SELECT COUNT(*) FROM radacct WHERE username = '71485392' AND acctstoptime IS NULL<br>
rlm_sql (sql): Reserving sql socket id: 4<br>[sql] expand: SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL -> SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '71485392' AND acctstoptime IS NULL<br>
checkrad: Net::Telnet 3.00+ CPAN module not installed<br>rlm_sql (sql): Released sql socket id: 4<br>[sql] Failed to check the terminal server for user '71485392'.<br>++[sql] returns fail<br>Login OK: [71485392/password] (from client JonnyLAW port 0 cli 00-1D-E0-43-D5-8F)<br>
+- entering group post-auth {...}<br>[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>[sql] expand: %{User-Password} -> password<br>[sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '71485392', 'password', 'Access-Accept', '2010-08-13 11:58:07')<br>
rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '71485392', 'password', 'Access-Accept', '2010-08-13 11:58:07')<br>
rlm_sql (sql): Reserving sql socket id: 3<br>rlm_sql (sql): Released sql socket id: 3<br>++[sql] returns ok<br>++[exec] returns noop<br>Sending Access-Accept of id 196 to 192.168.4.251 port 1025<br> Session-Timeout = 3395<br>
Nomadix-MaxBytesDown = 104305655<br>Finished request 2.<br>Going to the next request<br>Waking up in 4.9 seconds.<br>rad_recv: Accounting-Request packet from host 192.168.4.251 port 1026, id=24, length=184<br> User-Name = "71485392"<br>
NAS-IP-Address = 192.168.4.251<br> NAS-Port = 0<br> Acct-Status-Type = Start<br> Acct-Session-Id = "EB000063"<br> Event-Timestamp = "Aug 13 2010 12:01:31 SAST"<br> Called-Station-Id = "00-50-E8-02-53-90"<br>
Calling-Station-Id = "00-1D-E0-43-D5-8F"<br> NAS-Identifier = "JonnyLAW"<br> NAS-Port-Type = ISDN<br> Nomadix-Attr-17 = 0x00000001<br> WISPr-Location-ID = "isocc=,cc=,ac=,network=Firedigit"<br>
Acct-Delay-Time = 1<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 0,Client-IP-Address = 192.168.4.251,NAS-IP-Address = 192.168.4.251,Acct-Session-Id = "EB000063",User-Name = "71485392"'<br>
[acct_unique] Acct-Unique-Session-ID = "58d5aa42e3403008".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "71485392", looking up realm NULL<br>[suffix] No such realm "NULL"<br>
++[suffix] returns noop<br>++[files] returns noop<br>+- entering group accounting {...}<br>[sql] expand: %{User-Name} -> 71485392<br>[sql] sql_set_user escaped user --> '71485392'<br>[sql] expand: %{Acct-Delay-Time} -> 1<br>
[sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, NASIdentifier, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '<br>
rlm_sql (sql): Reserving sql socket id: 2<br>rlm_sql (sql): Released sql socket id: 2<br>++[sql] returns ok<br>[attr_filter.accounting_response] expand: %{User-Name} -> 71485392<br> attr_filter: Matched entry DEFAULT at line 12<br>
++[attr_filter.accounting_response] returns updated<br>Sending Accounting-Response of id 24 to 192.168.4.251 port 1026<br>Finished request 3.<br>Cleaning up request 3 ID 24 with timestamp +63<br>Going to the next request<br>
Waking up in 3.8 seconds.<br>Cleaning up request 2 ID 196 with timestamp +61<br>Ready to process requests.<br><br><br><div class="gmail_quote">On Fri, Aug 13, 2010 at 11:54 AM, Alan DeKok <span dir="ltr"><<a href="mailto:aland@deployingradius.com">aland@deployingradius.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">tyllerd wrote:<br>
> Then I try login from one NAS and then again from another NAS and it works.<br>
<br>
</div> And what does "radiusd -X" say?<br>
<div class="im"><br>
> So does simultaneous-use only tell the NAS to let user X login once or is<br>
> supposed to be server side? Do I need to right a script to do it server<br>
> side?<br>
<br>
</div> The simultaneous-use checking applies to *all* NASes. So it *should*<br>
enforce only one login, even if you try to login on two different NASes.<br>
<font color="#888888"><br>
Alan DeKok.<br>
</font><div><div></div><div class="h5">-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br>