Hi Alan.<br><br>Thanks for pointing that out. I have gotten rid of most of the error by installing the Net::Telnet 3.00+ CPAN module. I am however still getting the <br><br>rlm_sql (sql): Released sql socket id: 0<br>[sql] Failed to check the terminal server for user '92263842'.<br>
++[sql] returns fail<br><br>error. What could cause this to fail?<br><br>Ready to process requests.<br>rad_recv: Access-Request packet from host 192.168.4.28 port 50944, id=137, 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 = "92263842"<br> NAS-Port = 2154823735<br> Acct-Session-Id = "80700037"<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 = "92263842", 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} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<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 = '92263842' 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 = '92263842' ORDER BY id<br>
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '92263842' 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='92263842' ORDER BY acctstarttime LIMIT 1;<br>
sqlcounter_expand: '%{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='92263842' ORDER BY acctstarttime LIMIT 1;}'<br>[expire_on_login] sql_xlat<br>
[expire_on_login] expand: %{User-Name} -> 92263842<br>[expire_on_login] sql_set_user escaped user --> '92263842'<br>[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='92263842' ORDER BY acctstarttime LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='92263842' 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='92263842' ORDER BY acctstarttime LIMIT 1;} -> 4519<br>
rlm_sqlcounter: Check item is greater than query result<br>rlm_sqlcounter: Authorized user 92263842, check_item=864000, counter=4519<br>rlm_sqlcounter: Sent Reply-Item for user 92263842, Type=Session-Timeout, value=859481<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='92263842'<br>
sqlcounter_expand: '%{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='92263842'}'<br>[noresetcounter] sql_xlat<br>[noresetcounter] expand: %{User-Name} -> 92263842<br>[noresetcounter] sql_set_user escaped user --> '92263842'<br>
[noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='92263842' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='92263842'<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='92263842'} -> 3368<br>rlm_sqlcounter: Check item is greater than query result<br>
rlm_sqlcounter: Authorized user 92263842, check_item=3600, counter=3368<br>rlm_sqlcounter: Sent Reply-Item for user 92263842, Type=Session-Timeout, value=232<br>++[noresetcounter] returns ok<br>Found Auth-Type = Perl<br>+- entering group Perl {...}<br>
GOT CLONE -1208333616 0x9f349b0<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 = 80700037<br>
rlm_perl: Added pair SQL-User-Name = 92263842<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 = 92263842<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 = 2154823735<br>rlm_perl: Added pair NAS-Port-Id = Guest<br>rlm_perl: Added pair Idle-Timeout = 300<br>rlm_perl: Added pair Acct-Interim-Interval = 60<br>rlm_perl: Added pair Session-Timeout = 232<br>
rlm_perl: Added pair Mikrotik-Xmit-Limit = 102796327<br>rlm_perl: Added pair Cleartext-Password = password<br>rlm_perl: Added pair Expire-After = 864000<br>rlm_perl: Added pair Simultaneous-Use = 1<br>rlm_perl: Added pair Auth-Type = Perl<br>
rlm_perl: Added pair Idle-Timeout = 300<br>rlm_perl: Added pair Acct-Interim-Interval = 60<br>rlm_perl: Added pair Max-All-Session = 3600<br>rlm_perl: Added pair databank = 102796327<br>++[perl] returns ok<br>+- entering group session {...}<br>
[sql] expand: %{User-Name} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<br>[sql] expand: SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL -> SELECT COUNT(*) FROM radacct WHERE username = '92263842' AND acctstoptime IS NULL<br>
rlm_sql (sql): Reserving sql socket id: 0<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 = '92263842' AND acctstoptime IS NULL<br>
rlm_sql (sql): Released sql socket id: 0<br>[sql] Failed to check the terminal server for user '92263842'.<br>++[sql] returns fail<br>Login OK: [92263842/password] (from client TEST2 port 2154823735 cli 00:1E:64:8E:1F:8E)<br>
+- entering group post-auth {...}<br>[sql] expand: %{User-Name} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<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 ( '92263842', 'password', 'Access-Accept', '2010-08-13 14:42:19')<br>
rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '92263842', 'password', 'Access-Accept', '2010-08-13 14:42:19')<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 137 to 192.168.4.28 port 50944<br> Idle-Timeout = 300<br>
Acct-Interim-Interval = 60<br> Session-Timeout = 232<br> Mikrotik-Xmit-Limit = 102796327<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 57753, id=138, 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 = "92263842"<br>
NAS-Port = 2154823735<br> Acct-Session-Id = "80700037"<br> Framed-IP-Address = 10.20.30.253<br> Mikrotik-Host-IP = 10.20.30.253<br> Event-Timestamp = "Jan 2 1970 05:01:20 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 = 2154823735,Client-IP-Address = 192.168.4.28,NAS-IP-Address = 192.168.4.28,Acct-Session-Id = "80700037",User-Name = "92263842"'<br>
[acct_unique] Acct-Unique-Session-ID = "8abdfdb94645d80c".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "92263842", 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} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<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} -> 92263842<br> attr_filter: Matched entry DEFAULT at line 12<br>
++[attr_filter.accounting_response] returns updated<br>Sending Accounting-Response of id 138 to 192.168.4.28 port 57753<br>Finished request 1.<br>Cleaning up request 1 ID 138 with timestamp +10<br>Going to the next request<br>
Waking up in 4.9 seconds.<br>Cleaning up request 0 ID 137 with timestamp +10<br>Ready to process requests.<br>rad_recv: Access-Request packet from host 192.168.4.251 port 1025, id=4, length=192<br> User-Name = "92263842"<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 = "EB000083"<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 = "92263842", 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} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<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 = '92263842' 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 = '92263842' ORDER BY id<br>
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '92263842' 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='92263842' ORDER BY acctstarttime LIMIT 1;<br>
sqlcounter_expand: '%{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='92263842' ORDER BY acctstarttime LIMIT 1;}'<br>[expire_on_login] sql_xlat<br>
[expire_on_login] expand: %{User-Name} -> 92263842<br>[expire_on_login] sql_set_user escaped user --> '92263842'<br>[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='92263842' ORDER BY acctstarttime LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) FROM radacct WHERE UserName='92263842' 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='92263842' ORDER BY acctstarttime LIMIT 1;} -> 4527<br>
rlm_sqlcounter: Check item is greater than query result<br>rlm_sqlcounter: Authorized user 92263842, check_item=864000, counter=4527<br>rlm_sqlcounter: Sent Reply-Item for user 92263842, Type=Session-Timeout, value=859473<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='92263842'<br>
sqlcounter_expand: '%{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='92263842'}'<br>[noresetcounter] sql_xlat<br>[noresetcounter] expand: %{User-Name} -> 92263842<br>[noresetcounter] sql_set_user escaped user --> '92263842'<br>
[noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='92263842' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='92263842'<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='92263842'} -> 3368<br>rlm_sqlcounter: Check item is greater than query result<br>
rlm_sqlcounter: Authorized user 92263842, check_item=3600, counter=3368<br>rlm_sqlcounter: Sent Reply-Item for user 92263842, Type=Session-Timeout, value=232<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 = EB000083<br>rlm_perl: Added pair SQL-User-Name = 92263842<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 = 92263842<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 Idle-Timeout = 300<br>rlm_perl: Added pair Acct-Interim-Interval = 60<br>rlm_perl: Added pair Session-Timeout = 232<br>rlm_perl: Added pair Nomadix-MaxBytesDown = 102796327<br>rlm_perl: Added pair Cleartext-Password = password<br>
rlm_perl: Added pair Expire-After = 864000<br>rlm_perl: Added pair Simultaneous-Use = 1<br>rlm_perl: Added pair Auth-Type = Perl<br>rlm_perl: Added pair Idle-Timeout = 300<br>rlm_perl: Added pair Acct-Interim-Interval = 60<br>
rlm_perl: Added pair Max-All-Session = 3600<br>rlm_perl: Added pair databank = 102796327<br>++[perl] returns ok<br>+- entering group session {...}<br>[sql] expand: %{User-Name} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<br>
[sql] expand: SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL -> SELECT COUNT(*) FROM radacct WHERE username = '92263842' 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 = '92263842' AND acctstoptime IS NULL<br>
rlm_sql (sql): Released sql socket id: 4<br>[sql] Failed to check the terminal server for user '92263842'.<br>++[sql] returns fail<br>Login OK: [92263842/password] (from client JonnyLAW port 0 cli 00-1D-E0-43-D5-8F)<br>
+- entering group post-auth {...}<br>[sql] expand: %{User-Name} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<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 ( '92263842', 'password', 'Access-Accept', '2010-08-13 14:42:27')<br>
rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '92263842', 'password', 'Access-Accept', '2010-08-13 14:42:27')<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 4 to 192.168.4.251 port 1025<br> Idle-Timeout = 300<br>
Acct-Interim-Interval = 60<br> Session-Timeout = 232<br> Nomadix-MaxBytesDown = 102796327<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=158, length=190<br>
User-Name = "92263842"<br> NAS-IP-Address = 192.168.4.251<br> NAS-Port = 0<br> Acct-Status-Type = Start<br> Acct-Session-Id = "EB000083"<br> Idle-Timeout = 300<br> Event-Timestamp = "Aug 13 2010 14:45:51 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 = "EB000083",User-Name = "92263842"'<br>
[acct_unique] Acct-Unique-Session-ID = "5aed8c02743f3776".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "92263842", 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} -> 92263842<br>[sql] sql_set_user escaped user --> '92263842'<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} -> 92263842<br> attr_filter: Matched entry DEFAULT at line 12<br>
++[attr_filter.accounting_response] returns updated<br>Sending Accounting-Response of id 158 to 192.168.4.251 port 1026<br>Finished request 3.<br>Cleaning up request 3 ID 158 with timestamp +20<br>Going to the next request<br>
Waking up in 3.2 seconds.<br>Cleaning up request 2 ID 4 with timestamp +18<br>Ready to process requests.<br><br><br><div class="gmail_quote">On Fri, Aug 13, 2010 at 1:53 PM, 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">Tyller D wrote:<br>
> 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>
</div> Yes. Look for words like "fail" or "reject" or "error".<br>
<div class="im"><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>
<br>
</div> It shouldn't be that difficult.<br>
<div><div></div><div class="h5"><br>
Alan DeKok.<br>
-<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>