NAS-IP-Address = 192.168.182.1 Framed-IP-Address = 192.168.182.2 WISPr-Logoff-URL = "http://192.168.182.1:3990/logoff" rlm_perl: Added pair WISPr-Logoff-URL = http://192.168.182.1:3990/logoff rlm_perl: Added pair NAS-IP-Address = 192.168.182.1 rlm_perl: Added pair Framed-IP-Address = 192.168.182.2 rlm_perl: Added pair WISPr-Logoff-URL = http://192.168.182.1:3990/logoff rlm_perl: Added pair Framed-IP-Address = 192.168.182.2 rlm_perl: Added pair NAS-IP-Address = 192.168.182.1 Framed-IP-Address = 192.168.182.2 NAS-IP-Address = 192.168.182.1 rlm_acct_unique: Hashing 'NAS-Port = 1,Client-IP-Address = 139.179.14.250,NAS-IP-Address = 192.168.182.1,Acct-Session-Id = "4906fb3400000001",User-Name = "7798-1"' expand: UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' -> UPDATE radacct SET framedipaddress = '192.168.182.2', acctsessiontime = '63', acctinputoctets = '0' << 32 | '139766', acctoutputoctets = '0' << 32 | '8364' WHERE acctsessionid = '4906fb3400000001' AND username = '7798-1' AND nasipaddress = '192.168.182.1' expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}') -> INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('4906fb3400000001', 'c320313e703e73c5', '7798-1', '', '192.168.182.1', '1', 'Wireless-802.11', DATE_SUB('2008-10-28 13:45:47', INTERVAL (63 + 0) SECOND), '63', '', '', '0' << 32 | '139766', '0' << 32 | '8364', '00-0E-0C-6E-6E-7C', '00-14-22-A1-BB-AB', '', '', '192.168.182.2', '0', '') Framed-IP-Address = 192.168.182.2 NAS-IP-Address = 192.168.182.1 rlm_acct_unique: Hashing 'NAS-Port = 1,Client-IP-Address = 139.179.14.250,NAS-IP-Address = 192.168.182.1,Acct-Session-Id = "4906fb3400000001",User-Name = "7798-1"' expand: UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' -> UPDATE radacct SET framedipaddress = '192.168.182.2', acctsessiontime = '63', acctinputoctets = '0' << 32 | '139766', acctoutputoctets = '0' << 32 | '8364' WHERE acctsessionid = '4906fb3400000001' AND username = '7798-1' AND nasipaddress = '192.168.182.1' expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}') -> INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('4906fb3400000001', 'c320313e703e73c5', '7798-1', '', '192.168.182.1', '1', 'Wireless-802.11', DATE_SUB('2008-10-28 13:45:54', INTERVAL (63 + 0) SECOND), '63', '', '', '0' << 32 | '139766', '0' << 32 | '8364', '00-0E-0C-6E-6E-7C', '00-14-22-A1-BB-AB', '', '', '192.168.182.2', '0', '') Framed-IP-Address = 192.168.182.2 NAS-IP-Address = 192.168.182.1 rlm_acct_unique: Hashing 'NAS-Port = 1,Client-IP-Address = 139.179.14.250,NAS-IP-Address = 192.168.182.1,Acct-Session-Id = "4906fb3400000001",User-Name = "7798-1"' expand: UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' -> UPDATE radacct SET framedipaddress = '192.168.182.2', acctsessiontime = '63', acctinputoctets = '0' << 32 | '139766', acctoutputoctets = '0' << 32 | '8364' WHERE acctsessionid = '4906fb3400000001' AND username = '7798-1' AND nasipaddress = '192.168.182.1' expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}') -> INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('4906fb3400000001', 'c320313e703e73c5', '7798-1', '', '192.168.182.1', '1', 'Wireless-802.11', DATE_SUB('2008-10-28 13:46:01', INTERVAL (63 + 0) SECOND), '63', '', '', '0' << 32 | '139766', '0' << 32 | '8364', '00-0E-0C-6E-6E-7C', '00-14-22-A1-BB-AB', '', '', '192.168.182.2', '0', '') Framed-IP-Address = 192.168.182.2 NAS-IP-Address = 192.168.182.1 rlm_acct_unique: Hashing 'NAS-Port = 1,Client-IP-Address = 139.179.14.250,NAS-IP-Address = 192.168.182.1,Acct-Session-Id = "4906fb3400000001",User-Name = "7798-1"' expand: UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' -> UPDATE