Closed TelDragon closed 2 years ago
Unexpected behaviour (obvious or verified by project member)
When the user goes online for about 1 minute, framedipaddress cannot obtain the real IP
FreeRADIUS Version 3.0.25 Copyright (C) 1999-2021 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file /usr/share/freeradius/dictionary including dictionary file /usr/share/freeradius/dictionary.dhcp including dictionary file /usr/share/freeradius/dictionary.vqp including dictionary file /etc/raddb/dictionary including configuration file /etc/raddb/radiusd.conf including configuration file /etc/raddb/clients.conf including configuration file /etc/raddb/mods-enabled/sql including configuration file /etc/raddb/mods-config/sql/main/mysql/queries.conf including files in directory /etc/raddb/mods-enabled/ including configuration file /etc/raddb/mods-enabled/always including configuration file /etc/raddb/mods-enabled/attr_filter including configuration file /etc/raddb/mods-enabled/cache_eap including configuration file /etc/raddb/mods-enabled/chap including configuration file /etc/raddb/mods-enabled/date including configuration file /etc/raddb/mods-enabled/detail including configuration file /etc/raddb/mods-enabled/detail.log including configuration file /etc/raddb/mods-enabled/digest including configuration file /etc/raddb/mods-enabled/dynamic_clients including configuration file /etc/raddb/mods-enabled/eap including configuration file /etc/raddb/mods-enabled/echo including configuration file /etc/raddb/mods-enabled/exec including configuration file /etc/raddb/mods-enabled/expiration including configuration file /etc/raddb/mods-enabled/expr including configuration file /etc/raddb/mods-enabled/files including configuration file /etc/raddb/mods-enabled/linelog including configuration file /etc/raddb/mods-enabled/logintime including configuration file /etc/raddb/mods-enabled/mschap including configuration file /etc/raddb/mods-enabled/ntlm_auth including configuration file /etc/raddb/mods-enabled/pap including configuration file /etc/raddb/mods-enabled/passwd including configuration file /etc/raddb/mods-enabled/preprocess including configuration file /etc/raddb/mods-enabled/radutmp including configuration file /etc/raddb/mods-enabled/realm including configuration file /etc/raddb/mods-enabled/replicate including configuration file /etc/raddb/mods-enabled/soh including configuration file /etc/raddb/mods-enabled/sradutmp including configuration file /etc/raddb/mods-enabled/totp including configuration file /etc/raddb/mods-enabled/unix including configuration file /etc/raddb/mods-enabled/unpack including configuration file /etc/raddb/mods-enabled/utf8 including files in directory /etc/raddb/policy.d/ including configuration file /etc/raddb/policy.d/abfab-tr including configuration file /etc/raddb/policy.d/accounting including configuration file /etc/raddb/policy.d/canonicalization including configuration file /etc/raddb/policy.d/control including configuration file /etc/raddb/policy.d/cui including configuration file /etc/raddb/policy.d/debug including configuration file /etc/raddb/policy.d/dhcp including configuration file /etc/raddb/policy.d/eap including configuration file /etc/raddb/policy.d/filter including configuration file /etc/raddb/policy.d/moonshot-targeted-ids including configuration file /etc/raddb/policy.d/operator-name including configuration file /etc/raddb/policy.d/rfc7542 including files in directory /etc/raddb/sites-enabled/ including configuration file /etc/raddb/sites-enabled/default including configuration file /etc/raddb/sites-enabled/inner-tunnel main { security { allow_core_dumps = no } name = "radiusd" prefix = "/usr" localstatedir = "/var" logdir = "/var/log/radius" run_dir = "/var/run/radiusd" } main { name = "radiusd" prefix = "/usr" localstatedir = "/var" sbindir = "/usr/sbin" logdir = "/var/log/radius" run_dir = "/var/run/radiusd" libdir = "/usr/lib64/freeradius" radacctdir = "/var/log/radius/radacct" hostname_lookups = yes max_request_time = 30 cleanup_delay = 5 max_requests = 16384 postauth_client_lost = no pidfile = "/var/run/radiusd/radiusd.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = no log { stripped_names = yes auth = yes auth_accept = yes auth_reject = yes auth_badpass = yes auth_goodpass = yes colourise = yes msg_denied = "You are already logged in - access denied" suppress_secrets = yes } resources { } security { max_attributes = 200 reject_delay = 1.000000 status_server = yes allow_vulnerable_openssl = "no" } } radiusd: #### Loading Realms and Home Servers #### radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = <<< secret >>> nas_type = "other" proto = "*" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client localhost_ipv6 { ipv6addr = ::1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Debugger not attached systemd watchdog is disabled # Creating Auth-Type = mschap # Creating Auth-Type = digest # Creating Auth-Type = eap # Creating Auth-Type = PAP # Creating Auth-Type = CHAP # Creating Auth-Type = MS-CHAP # Creating Autz-Type = New-TLS-Connection radiusd: #### Instantiating modules #### modules { # Loaded module rlm_sql # Loading module "sql" from file /etc/raddb/mods-enabled/sql sql { driver = "rlm_sql_mysql" server = "127.0.0.1" port = 3306 login = "radius" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = yes delete_stale_sessions = yes sql_user_name = "%{User-Name}" logfile = "/var/log/radius/sqllog.sql" default_user_profile = "" client_query = "SELECT id, nasname, shortname, type, secret, server FROM nas" authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = "%{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query}" logfile = "/var/log/radius/accounting.sql" type { accounting-on { query = "UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctsessiontime = '%{%{integer:Event-Timestamp}:-%l}' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l})" } accounting-off { query = "UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctsessiontime = '%{%{integer:Event-Timestamp}:-%l}' - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l})" } start { query = "INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime,acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, framedipv6address, framedipv6prefix, framedinterfaceid, delegatedipv6prefix ) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Framed-IPv6-Address}', '%{Framed-IPv6-Prefix}', '%{Framed-Interface-Id}', '%{Delegated-IPv6-Prefix}' )" } interim-update { query = "UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } stop { query = "UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } } } post-auth { reference = ".query" logfile = "/var/log/radius/post-auth.sql" query = "INSERT INTO radpostauth (username, pass, reply, authdate, nasipaddress, mac ) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S.%M', '%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}}', '%{Calling-Station-Id}' )" } } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Creating attribute SQL-Group # Loaded module rlm_always # Loading module "reject" from file /etc/raddb/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/raddb/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/raddb/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/raddb/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/raddb/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/raddb/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/raddb/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/raddb/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/raddb/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Loaded module rlm_attr_filter # Loading module "attr_filter.post-proxy" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/raddb/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.pre-proxy" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/raddb/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.access_reject" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/raddb/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.access_challenge" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/raddb/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.accounting_response" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/raddb/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.coa" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.coa { filename = "/etc/raddb/mods-config/attr_filter/coa" key = "%{User-Name}" relaxed = no } # Loaded module rlm_cache # Loading module "cache_eap" from file /etc/raddb/mods-enabled/cache_eap cache cache_eap { driver = "rlm_cache_rbtree" key = "%{%{control:State}:-%{%{reply:State}:-%{State}}}" ttl = 15 max_entries = 0 epoch = 0 add_stats = no } # Loaded module rlm_chap # Loading module "chap" from file /etc/raddb/mods-enabled/chap # Loaded module rlm_date # Loading module "date" from file /etc/raddb/mods-enabled/date date { format = "%b %e %Y %H:%M:%S %Z" utc = no } # Loading module "wispr2date" from file /etc/raddb/mods-enabled/date date wispr2date { format = "%Y-%m-%dT%H:%M:%S" utc = no } # Loaded module rlm_detail # Loading module "detail" from file /etc/raddb/mods-enabled/detail detail { filename = "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "auth_log" from file /etc/raddb/mods-enabled/detail.log detail auth_log { filename = "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "reply_log" from file /etc/raddb/mods-enabled/detail.log detail reply_log { filename = "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/reply-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "pre_proxy_log" from file /etc/raddb/mods-enabled/detail.log detail pre_proxy_log { filename = "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/pre-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "post_proxy_log" from file /etc/raddb/mods-enabled/detail.log detail post_proxy_log { filename = "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/post-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_digest # Loading module "digest" from file /etc/raddb/mods-enabled/digest # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/raddb/mods-enabled/dynamic_clients # Loaded module rlm_eap # Loading module "eap" from file /etc/raddb/mods-enabled/eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loaded module rlm_exec # Loading module "echo" from file /etc/raddb/mods-enabled/echo exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = yes } # Loading module "exec" from file /etc/raddb/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_expiration # Loading module "expiration" from file /etc/raddb/mods-enabled/expiration # Loaded module rlm_expr # Loading module "expr" from file /etc/raddb/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_files # Loading module "files" from file /etc/raddb/mods-enabled/files files { filename = "/etc/raddb/mods-config/files/authorize" acctusersfile = "/etc/raddb/mods-config/files/accounting" preproxy_usersfile = "/etc/raddb/mods-config/files/pre-proxy" } # Loaded module rlm_linelog # Loading module "linelog" from file /etc/raddb/mods-enabled/linelog linelog { filename = "/var/log/radius/linelog" escape_filenames = no syslog_severity = "info" permissions = 384 format = "This is a log message for %{User-Name}" reference = "messages.%{%{reply:Packet-Type}:-default}" } # Loading module "log_accounting" from file /etc/raddb/mods-enabled/linelog linelog log_accounting { filename = "/var/log/radius/linelog-accounting" escape_filenames = no syslog_severity = "info" permissions = 384 format = "" reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}" } # Loaded module rlm_logintime # Loading module "logintime" from file /etc/raddb/mods-enabled/logintime logintime { minimum_timeout = 60 } # Loaded module rlm_mschap # Loading module "mschap" from file /etc/raddb/mods-enabled/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = yes passchange { } allow_retry = yes winbind_retry_with_normalised_username = no } # Loading module "ntlm_auth" from file /etc/raddb/mods-enabled/ntlm_auth exec ntlm_auth { wait = yes program = "/path/to/ntlm_auth --request-nt-key --domain=MYDOMAIN --username=%{mschap:User-Name} --password=%{User-Password}" shell_escape = yes } # Loaded module rlm_pap # Loading module "pap" from file /etc/raddb/mods-enabled/pap pap { normalise = yes } # Loaded module rlm_passwd # Loading module "etc_passwd" from file /etc/raddb/mods-enabled/passwd passwd etc_passwd { filename = "/etc/passwd" format = "*User-Name:Crypt-Password:" delimiter = ":" ignore_nislike = no ignore_empty = yes allow_multiple_keys = no hash_size = 100 } # Loaded module rlm_preprocess # Loading module "preprocess" from file /etc/raddb/mods-enabled/preprocess preprocess { huntgroups = "/etc/raddb/mods-config/preprocess/huntgroups" hints = "/etc/raddb/mods-config/preprocess/hints" with_ascend_hack = no ascend_channels_per_line = 23 with_ntdomain_hack = no with_specialix_jetstream_hack = no with_cisco_vsa_hack = no with_alvarion_vsa_hack = no } # Loaded module rlm_radutmp # Loading module "radutmp" from file /etc/raddb/mods-enabled/radutmp radutmp { filename = "/var/log/radius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 384 caller_id = yes } # Loaded module rlm_realm # Loading module "IPASS" from file /etc/raddb/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/raddb/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "bangpath" from file /etc/raddb/mods-enabled/realm realm bangpath { format = "prefix" delimiter = "!" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/raddb/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/raddb/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loaded module rlm_replicate # Loading module "replicate" from file /etc/raddb/mods-enabled/replicate # Loaded module rlm_soh # Loading module "soh" from file /etc/raddb/mods-enabled/soh soh { dhcp = yes } # Loading module "sradutmp" from file /etc/raddb/mods-enabled/sradutmp radutmp sradutmp { filename = "/var/log/radius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loaded module rlm_totp # Loading module "totp" from file /etc/raddb/mods-enabled/totp # Loaded module rlm_unix # Loading module "unix" from file /etc/raddb/mods-enabled/unix unix { radwtmp = "/var/log/radius/radwtmp" } Creating attribute Unix-Group # Loaded module rlm_unpack # Loading module "unpack" from file /etc/raddb/mods-enabled/unpack # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/raddb/mods-enabled/utf8 instantiate { } # Instantiating module "sql" from file /etc/raddb/mods-enabled/sql rlm_sql_mysql: libmysql version: 5.6.50 mysql { tls { tls_required = no } warnings = "auto" } rlm_sql (sql): Attempting to connect to database "radius" rlm_sql (sql): Initialising connection pool pool { start = 5 min = 3 max = 32 spare = 10 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 30 spread = no } rlm_sql (sql): Opening additional connection (0), 1 of 32 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Opening additional connection (1), 1 of 31 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Opening additional connection (2), 1 of 30 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Opening additional connection (3), 1 of 29 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Opening additional connection (4), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Processing generate_sql_clients rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas rlm_sql (sql): Reserved connection (0) rlm_sql (sql): Executing select query: SELECT id, nasname, shortname, type, secret, server FROM nas rlm_sql (sql): Adding client 192.168.1.250 (华为交换机) to global clients list rlm_sql (192.168.1.250): Client "华为交换机" (sql) added rlm_sql (sql): Adding client 192.168.1.3 (wifi) to global clients list rlm_sql (192.168.1.3): Client "wifi" (sql) added rlm_sql (sql): Adding client 192.168.1.248 (192.168.1.248) to global clients list rlm_sql (192.168.1.248): Client "192.168.1.248" (sql) added rlm_sql (sql): Released connection (0) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 # Instantiating module "reject" from file /etc/raddb/mods-enabled/always # Instantiating module "fail" from file /etc/raddb/mods-enabled/always # Instantiating module "ok" from file /etc/raddb/mods-enabled/always # Instantiating module "handled" from file /etc/raddb/mods-enabled/always # Instantiating module "invalid" from file /etc/raddb/mods-enabled/always # Instantiating module "userlock" from file /etc/raddb/mods-enabled/always # Instantiating module "notfound" from file /etc/raddb/mods-enabled/always # Instantiating module "noop" from file /etc/raddb/mods-enabled/always # Instantiating module "updated" from file /etc/raddb/mods-enabled/always # Instantiating module "attr_filter.post-proxy" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/post-proxy # Instantiating module "attr_filter.pre-proxy" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/pre-proxy # Instantiating module "attr_filter.access_reject" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/access_reject # Instantiating module "attr_filter.access_challenge" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/access_challenge # Instantiating module "attr_filter.accounting_response" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/accounting_response # Instantiating module "attr_filter.coa" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/coa # Instantiating module "cache_eap" from file /etc/raddb/mods-enabled/cache_eap rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked # Instantiating module "detail" from file /etc/raddb/mods-enabled/detail # Instantiating module "auth_log" from file /etc/raddb/mods-enabled/detail.log rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output # Instantiating module "reply_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "pre_proxy_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "post_proxy_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "eap" from file /etc/raddb/mods-enabled/eap # Linked to sub-module rlm_eap_md5 # Linked to sub-module rlm_eap_gtc gtc { challenge = "Password: " auth_type = "PAP" } # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" } tls-config tls-common { verify_depth = 0 ca_path = "/etc/raddb/certs" pem_file_type = yes private_key_file = "/etc/raddb/certs/server.pem" certificate_file = "/etc/raddb/certs/server.pem" ca_file = "/etc/raddb/certs/ca.pem" private_key_password = <<< secret >>> dh_file = "/etc/raddb/certs/dh" fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no ca_path_reload_interval = 0 cipher_list = "DEFAULT" cipher_server_preference = no ecdh_curve = "prime256v1" tls_max_version = "1.2" tls_min_version = "1.2" cache { enable = no lifetime = 24 max_entries = 255 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "expiration" from file /etc/raddb/mods-enabled/expiration # Instantiating module "files" from file /etc/raddb/mods-enabled/files reading pairlist file /etc/raddb/mods-config/files/authorize reading pairlist file /etc/raddb/mods-config/files/accounting reading pairlist file /etc/raddb/mods-config/files/pre-proxy # Instantiating module "linelog" from file /etc/raddb/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/raddb/mods-enabled/linelog # Instantiating module "logintime" from file /etc/raddb/mods-enabled/logintime # Instantiating module "mschap" from file /etc/raddb/mods-enabled/mschap rlm_mschap (mschap): using internal authentication # Instantiating module "pap" from file /etc/raddb/mods-enabled/pap # Instantiating module "etc_passwd" from file /etc/raddb/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # Instantiating module "preprocess" from file /etc/raddb/mods-enabled/preprocess reading pairlist file /etc/raddb/mods-config/preprocess/huntgroups reading pairlist file /etc/raddb/mods-config/preprocess/hints # Instantiating module "IPASS" from file /etc/raddb/mods-enabled/realm # Instantiating module "suffix" from file /etc/raddb/mods-enabled/realm # Instantiating module "bangpath" from file /etc/raddb/mods-enabled/realm # Instantiating module "realmpercent" from file /etc/raddb/mods-enabled/realm # Instantiating module "ntdomain" from file /etc/raddb/mods-enabled/realm } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/raddb/radiusd.conf } # server server default { # from file /etc/raddb/sites-enabled/default # Loading authenticate {...} Compiling Auth-Type PAP for attr Auth-Type Compiling Auth-Type CHAP for attr Auth-Type Compiling Auth-Type MS-CHAP for attr Auth-Type # Loading authorize {...} Compiling Autz-Type New-TLS-Connection for attr Autz-Type # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-auth {...} Compiling Post-Auth-Type REJECT for attr Post-Auth-Type Compiling Post-Auth-Type Challenge for attr Post-Auth-Type Compiling Post-Auth-Type Client-Lost for attr Post-Auth-Type } # server default server inner-tunnel { # from file /etc/raddb/sites-enabled/inner-tunnel # Loading authenticate {...} Compiling Auth-Type PAP for attr Auth-Type Compiling Auth-Type CHAP for attr Auth-Type Compiling Auth-Type MS-CHAP for attr Auth-Type # Loading authorize {...} # Loading session {...} # Loading post-auth {...} # Skipping contents of 'if' as it is always 'false' -- /etc/raddb/sites-enabled/inner-tunnel:78 Compiling Post-Auth-Type REJECT for attr Post-Auth-Type } # server inner-tunnel radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipv4addr = * port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipaddr = * port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Ready to process requests (0) Received Accounting-Request Id 42 from 192.168.1.250:1812 to 192.168.1.8:1813 length 320 (0) User-Name = "test" (0) NAS-Port = 32769 (0) Framed-IP-Address = 192.168.1.7 (0) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (0) NAS-Identifier = "Quidway" (0) Acct-Status-Type = Interim-Update (0) Acct-Delay-Time = 20 (0) Acct-Input-Octets = 0 (0) Acct-Output-Octets = 0 (0) Acct-Session-Id = "Quidway000080000000018095e0000018" (0) Acct-Authentic = RADIUS (0) Acct-Session-Time = 180 (0) Acct-Input-Packets = 0 (0) Acct-Output-Packets = 0 (0) Acct-Input-Gigawords = 0 (0) Acct-Output-Gigawords = 0 (0) Event-Timestamp = "Jan 1 2008 08:37:59 CST" (0) NAS-Port-Type = Ethernet (0) Calling-Station-Id = "2CFD-A140-5663" (0) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (0) Huawei-IPHost-Addr = "192.168.1.7 2c:fd:a1:40:56:63" (0) Huawei-Input-Burst-Size = 0 (0) Huawei-Input-Average-Rate = 0 (0) Huawei-Output-Burst-Size = 0 (0) Huawei-Output-Average-Rate = 0 (0) Huawei-Priority = 4294901760 (0) Huawei-Connect-ID = 18 (0) NAS-IP-Address = 192.168.1.250 (0) # Executing section preacct from file /etc/raddb/sites-enabled/default (0) preacct { (0) [preprocess] = ok (0) policy acct_unique { (0) update request { (0) &Tmp-String-9 := "ai:" (0) } # update request = noop (0) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (0) EXPAND %{hex:&Class} (0) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (0) EXPAND ^%{hex:&Tmp-String-9} (0) --> ^61693a (0) EXPAND %{string:&Class} (0) --> ai:eeb48447d7fc651841de71cbc345e430 (0) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (0) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (0) update request { (0) EXPAND %{md5:%{1},%{Acct-Session-ID}} (0) --> 4724459955b82bd4ca68cd4ecae82464 (0) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (0) } # update request = noop (0) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (0) ... skipping else: Preceding "if" was taken (0) } # policy acct_unique = noop (0) suffix: Checking for suffix after "@" (0) suffix: No '@' in User-Name = "test", looking up realm NULL (0) suffix: No such realm "NULL" (0) [suffix] = noop (0) } # preacct = ok (0) # Executing section accounting from file /etc/raddb/sites-enabled/default (0) accounting { (0) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (0) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (0) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (0) detail: EXPAND %t (0) detail: --> Mon Jan 24 17:20:38 2022 (0) [detail] = ok (0) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (0) sql: --> type.interim-update.query (0) sql: Using query template 'query' rlm_sql (sql): Reserved connection (1) (0) sql: EXPAND %{User-Name} (0) sql: --> test (0) sql: SQL-User-Name set to 'test' (0) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (0) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199147879), acctinterval = 1199147879 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 180, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (0) sql: EXPAND /var/log/radius/accounting.sql (0) sql: --> /var/log/radius/accounting.sql (0) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199147879), acctinterval = 1199147879 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 180, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (0) sql: SQL query returned: success (0) sql: 1 record(s) updated rlm_sql (sql): Released connection (1) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (6), 1 of 26 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 (0) [sql] = ok (0) [exec] = noop (0) attr_filter.accounting_response: EXPAND %{User-Name} (0) attr_filter.accounting_response: --> test (0) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (0) [attr_filter.accounting_response] = updated (0) } # accounting = updated (0) Sent Accounting-Response Id 42 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (0) Finished request (0) Cleaning up request packet ID 42 with timestamp +3 Ready to process requests (1) Received Accounting-Request Id 43 from 192.168.1.250:1812 to 192.168.1.8:1813 length 320 (1) User-Name = "test" (1) NAS-Port = 32769 (1) Framed-IP-Address = 192.168.1.7 (1) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (1) NAS-Identifier = "Quidway" (1) Acct-Status-Type = Interim-Update (1) Acct-Delay-Time = 0 (1) Acct-Input-Octets = 0 (1) Acct-Output-Octets = 0 (1) Acct-Session-Id = "Quidway000080000000018095e0000018" (1) Acct-Authentic = RADIUS (1) Acct-Session-Time = 240 (1) Acct-Input-Packets = 0 (1) Acct-Output-Packets = 0 (1) Acct-Input-Gigawords = 0 (1) Acct-Output-Gigawords = 0 (1) Event-Timestamp = "Jan 1 2008 08:38:59 CST" (1) NAS-Port-Type = Ethernet (1) Calling-Station-Id = "2CFD-A140-5663" (1) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (1) Huawei-IPHost-Addr = "192.168.1.7 2c:fd:a1:40:56:63" (1) Huawei-Input-Burst-Size = 0 (1) Huawei-Input-Average-Rate = 0 (1) Huawei-Output-Burst-Size = 0 (1) Huawei-Output-Average-Rate = 0 (1) Huawei-Priority = 4294901760 (1) Huawei-Connect-ID = 18 (1) NAS-IP-Address = 192.168.1.250 (1) # Executing section preacct from file /etc/raddb/sites-enabled/default (1) preacct { (1) [preprocess] = ok (1) policy acct_unique { (1) update request { (1) &Tmp-String-9 := "ai:" (1) } # update request = noop (1) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (1) EXPAND %{hex:&Class} (1) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (1) EXPAND ^%{hex:&Tmp-String-9} (1) --> ^61693a (1) EXPAND %{string:&Class} (1) --> ai:eeb48447d7fc651841de71cbc345e430 (1) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (1) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (1) update request { (1) EXPAND %{md5:%{1},%{Acct-Session-ID}} (1) --> 4724459955b82bd4ca68cd4ecae82464 (1) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (1) } # update request = noop (1) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (1) ... skipping else: Preceding "if" was taken (1) } # policy acct_unique = noop (1) suffix: Checking for suffix after "@" (1) suffix: No '@' in User-Name = "test", looking up realm NULL (1) suffix: No such realm "NULL" (1) [suffix] = noop (1) } # preacct = ok (1) # Executing section accounting from file /etc/raddb/sites-enabled/default (1) accounting { (1) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (1) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (1) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (1) detail: EXPAND %t (1) detail: --> Mon Jan 24 17:21:17 2022 (1) [detail] = ok (1) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (1) sql: --> type.interim-update.query (1) sql: Using query template 'query' rlm_sql (sql): Reserved connection (2) (1) sql: EXPAND %{User-Name} (1) sql: --> test (1) sql: SQL-User-Name set to 'test' (1) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (1) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199147939), acctinterval = 1199147939 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 240, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (1) sql: EXPAND /var/log/radius/accounting.sql (1) sql: --> /var/log/radius/accounting.sql (1) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199147939), acctinterval = 1199147939 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 240, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (1) sql: SQL query returned: success (1) sql: 1 record(s) updated rlm_sql (sql): Released connection (2) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (7), 1 of 25 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 (1) [sql] = ok (1) [exec] = noop (1) attr_filter.accounting_response: EXPAND %{User-Name} (1) attr_filter.accounting_response: --> test (1) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (1) [attr_filter.accounting_response] = updated (1) } # accounting = updated (1) Sent Accounting-Response Id 43 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (1) Finished request (1) Cleaning up request packet ID 43 with timestamp +42 Ready to process requests (2) Received Accounting-Request Id 44 from 192.168.1.250:1812 to 192.168.1.8:1813 length 320 (2) User-Name = "test" (2) NAS-Port = 32769 (2) Framed-IP-Address = 192.168.1.7 (2) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (2) NAS-Identifier = "Quidway" (2) Acct-Status-Type = Interim-Update (2) Acct-Delay-Time = 0 (2) Acct-Input-Octets = 0 (2) Acct-Output-Octets = 0 (2) Acct-Session-Id = "Quidway000080000000018095e0000018" (2) Acct-Authentic = RADIUS (2) Acct-Session-Time = 300 (2) Acct-Input-Packets = 0 (2) Acct-Output-Packets = 0 (2) Acct-Input-Gigawords = 0 (2) Acct-Output-Gigawords = 0 (2) Event-Timestamp = "Jan 1 2008 08:39:59 CST" (2) NAS-Port-Type = Ethernet (2) Calling-Station-Id = "2CFD-A140-5663" (2) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (2) Huawei-IPHost-Addr = "192.168.1.7 2c:fd:a1:40:56:63" (2) Huawei-Input-Burst-Size = 0 (2) Huawei-Input-Average-Rate = 0 (2) Huawei-Output-Burst-Size = 0 (2) Huawei-Output-Average-Rate = 0 (2) Huawei-Priority = 4294901760 (2) Huawei-Connect-ID = 18 (2) NAS-IP-Address = 192.168.1.250 (2) # Executing section preacct from file /etc/raddb/sites-enabled/default (2) preacct { (2) [preprocess] = ok (2) policy acct_unique { (2) update request { (2) &Tmp-String-9 := "ai:" (2) } # update request = noop (2) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (2) EXPAND %{hex:&Class} (2) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (2) EXPAND ^%{hex:&Tmp-String-9} (2) --> ^61693a (2) EXPAND %{string:&Class} (2) --> ai:eeb48447d7fc651841de71cbc345e430 (2) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (2) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (2) update request { (2) EXPAND %{md5:%{1},%{Acct-Session-ID}} (2) --> 4724459955b82bd4ca68cd4ecae82464 (2) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (2) } # update request = noop (2) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (2) ... skipping else: Preceding "if" was taken (2) } # policy acct_unique = noop (2) suffix: Checking for suffix after "@" (2) suffix: No '@' in User-Name = "test", looking up realm NULL (2) suffix: No such realm "NULL" (2) [suffix] = noop (2) } # preacct = ok (2) # Executing section accounting from file /etc/raddb/sites-enabled/default (2) accounting { (2) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (2) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (2) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (2) detail: EXPAND %t (2) detail: --> Mon Jan 24 17:22:17 2022 (2) [detail] = ok (2) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (2) sql: --> type.interim-update.query (2) sql: Using query template 'query' rlm_sql (sql): Reserved connection (3) (2) sql: EXPAND %{User-Name} (2) sql: --> test (2) sql: SQL-User-Name set to 'test' (2) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (2) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199147999), acctinterval = 1199147999 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 300, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (2) sql: EXPAND /var/log/radius/accounting.sql (2) sql: --> /var/log/radius/accounting.sql (2) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199147999), acctinterval = 1199147999 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 300, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (2) sql: SQL query returned: success (2) sql: 1 record(s) updated rlm_sql (sql): Released connection (3) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (8), 1 of 24 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Closing expired connection (6) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing expired connection (5) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing expired connection (4) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing expired connection (1) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing expired connection (0) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket (2) [sql] = ok (2) [exec] = noop (2) attr_filter.accounting_response: EXPAND %{User-Name} (2) attr_filter.accounting_response: --> test (2) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (2) [attr_filter.accounting_response] = updated (2) } # accounting = updated (2) Sent Accounting-Response Id 44 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (2) Finished request (2) Cleaning up request packet ID 44 with timestamp +102 Ready to process requests (3) Received Accounting-Request Id 45 from 192.168.1.250:1812 to 192.168.1.8:1813 length 320 (3) User-Name = "test" (3) NAS-Port = 32769 (3) Framed-IP-Address = 192.168.1.7 (3) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (3) NAS-Identifier = "Quidway" (3) Acct-Status-Type = Interim-Update (3) Acct-Delay-Time = 0 (3) Acct-Input-Octets = 0 (3) Acct-Output-Octets = 0 (3) Acct-Session-Id = "Quidway000080000000018095e0000018" (3) Acct-Authentic = RADIUS (3) Acct-Session-Time = 360 (3) Acct-Input-Packets = 0 (3) Acct-Output-Packets = 0 (3) Acct-Input-Gigawords = 0 (3) Acct-Output-Gigawords = 0 (3) Event-Timestamp = "Jan 1 2008 08:40:59 CST" (3) NAS-Port-Type = Ethernet (3) Calling-Station-Id = "2CFD-A140-5663" (3) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (3) Huawei-IPHost-Addr = "192.168.1.7 2c:fd:a1:40:56:63" (3) Huawei-Input-Burst-Size = 0 (3) Huawei-Input-Average-Rate = 0 (3) Huawei-Output-Burst-Size = 0 (3) Huawei-Output-Average-Rate = 0 (3) Huawei-Priority = 4294901760 (3) Huawei-Connect-ID = 18 (3) NAS-IP-Address = 192.168.1.250 (3) # Executing section preacct from file /etc/raddb/sites-enabled/default (3) preacct { (3) [preprocess] = ok (3) policy acct_unique { (3) update request { (3) &Tmp-String-9 := "ai:" (3) } # update request = noop (3) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (3) EXPAND %{hex:&Class} (3) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (3) EXPAND ^%{hex:&Tmp-String-9} (3) --> ^61693a (3) EXPAND %{string:&Class} (3) --> ai:eeb48447d7fc651841de71cbc345e430 (3) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (3) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (3) update request { (3) EXPAND %{md5:%{1},%{Acct-Session-ID}} (3) --> 4724459955b82bd4ca68cd4ecae82464 (3) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (3) } # update request = noop (3) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (3) ... skipping else: Preceding "if" was taken (3) } # policy acct_unique = noop (3) suffix: Checking for suffix after "@" (3) suffix: No '@' in User-Name = "test", looking up realm NULL (3) suffix: No such realm "NULL" (3) [suffix] = noop (3) } # preacct = ok (3) # Executing section accounting from file /etc/raddb/sites-enabled/default (3) accounting { (3) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (3) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (3) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (3) detail: EXPAND %t (3) detail: --> Mon Jan 24 17:23:17 2022 (3) [detail] = ok (3) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (3) sql: --> type.interim-update.query (3) sql: Using query template 'query' rlm_sql (sql): Reserved connection (2) (3) sql: EXPAND %{User-Name} (3) sql: --> test (3) sql: SQL-User-Name set to 'test' (3) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (3) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148059), acctinterval = 1199148059 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 360, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (3) sql: EXPAND /var/log/radius/accounting.sql (3) sql: --> /var/log/radius/accounting.sql (3) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148059), acctinterval = 1199148059 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 360, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (3) sql: SQL query returned: success (3) sql: 1 record(s) updated rlm_sql (sql): Released connection (2) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (9), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Closing expired connection (7) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket (3) [sql] = ok (3) [exec] = noop (3) attr_filter.accounting_response: EXPAND %{User-Name} (3) attr_filter.accounting_response: --> test (3) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (3) [attr_filter.accounting_response] = updated (3) } # accounting = updated (3) Sent Accounting-Response Id 45 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (3) Finished request (3) Cleaning up request packet ID 45 with timestamp +162 Ready to process requests (4) Received Accounting-Request Id 46 from 192.168.1.250:1812 to 192.168.1.8:1813 length 320 (4) User-Name = "test" (4) NAS-Port = 32769 (4) Framed-IP-Address = 192.168.1.7 (4) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (4) NAS-Identifier = "Quidway" (4) Acct-Status-Type = Interim-Update (4) Acct-Delay-Time = 0 (4) Acct-Input-Octets = 0 (4) Acct-Output-Octets = 0 (4) Acct-Session-Id = "Quidway000080000000018095e0000018" (4) Acct-Authentic = RADIUS (4) Acct-Session-Time = 420 (4) Acct-Input-Packets = 0 (4) Acct-Output-Packets = 0 (4) Acct-Input-Gigawords = 0 (4) Acct-Output-Gigawords = 0 (4) Event-Timestamp = "Jan 1 2008 08:41:59 CST" (4) NAS-Port-Type = Ethernet (4) Calling-Station-Id = "2CFD-A140-5663" (4) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (4) Huawei-IPHost-Addr = "192.168.1.7 2c:fd:a1:40:56:63" (4) Huawei-Input-Burst-Size = 0 (4) Huawei-Input-Average-Rate = 0 (4) Huawei-Output-Burst-Size = 0 (4) Huawei-Output-Average-Rate = 0 (4) Huawei-Priority = 4294901760 (4) Huawei-Connect-ID = 18 (4) NAS-IP-Address = 192.168.1.250 (4) # Executing section preacct from file /etc/raddb/sites-enabled/default (4) preacct { (4) [preprocess] = ok (4) policy acct_unique { (4) update request { (4) &Tmp-String-9 := "ai:" (4) } # update request = noop (4) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (4) EXPAND %{hex:&Class} (4) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (4) EXPAND ^%{hex:&Tmp-String-9} (4) --> ^61693a (4) EXPAND %{string:&Class} (4) --> ai:eeb48447d7fc651841de71cbc345e430 (4) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (4) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (4) update request { (4) EXPAND %{md5:%{1},%{Acct-Session-ID}} (4) --> 4724459955b82bd4ca68cd4ecae82464 (4) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (4) } # update request = noop (4) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (4) ... skipping else: Preceding "if" was taken (4) } # policy acct_unique = noop (4) suffix: Checking for suffix after "@" (4) suffix: No '@' in User-Name = "test", looking up realm NULL (4) suffix: No such realm "NULL" (4) [suffix] = noop (4) } # preacct = ok (4) # Executing section accounting from file /etc/raddb/sites-enabled/default (4) accounting { (4) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (4) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (4) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (4) detail: EXPAND %t (4) detail: --> Mon Jan 24 17:24:16 2022 (4) [detail] = ok (4) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (4) sql: --> type.interim-update.query (4) sql: Using query template 'query' rlm_sql (sql): Reserved connection (3) (4) sql: EXPAND %{User-Name} (4) sql: --> test (4) sql: SQL-User-Name set to 'test' (4) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (4) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148119), acctinterval = 1199148119 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 420, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (4) sql: EXPAND /var/log/radius/accounting.sql (4) sql: --> /var/log/radius/accounting.sql (4) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148119), acctinterval = 1199148119 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '192.168.1.7', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 420, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (4) sql: SQL query returned: success (4) sql: 1 record(s) updated rlm_sql (sql): Released connection (3) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (10), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Closing expired connection (8) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket (4) [sql] = ok (4) [exec] = noop (4) attr_filter.accounting_response: EXPAND %{User-Name} (4) attr_filter.accounting_response: --> test (4) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (4) [attr_filter.accounting_response] = updated (4) } # accounting = updated (4) Sent Accounting-Response Id 46 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (4) Finished request (4) Cleaning up request packet ID 46 with timestamp +221 Ready to process requests (5) Received Accounting-Request Id 47 from 192.168.1.250:1812 to 192.168.1.8:1813 length 316 (5) User-Name = "test" (5) NAS-Port = 32769 (5) Framed-IP-Address = 0.0.0.0 (5) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (5) NAS-Identifier = "Quidway" (5) Acct-Status-Type = Interim-Update (5) Acct-Delay-Time = 0 (5) Acct-Input-Octets = 0 (5) Acct-Output-Octets = 0 (5) Acct-Session-Id = "Quidway000080000000018095e0000018" (5) Acct-Authentic = RADIUS (5) Acct-Session-Time = 450 (5) Acct-Input-Packets = 0 (5) Acct-Output-Packets = 0 (5) Acct-Input-Gigawords = 0 (5) Acct-Output-Gigawords = 0 (5) Event-Timestamp = "Jan 1 2008 08:42:29 CST" (5) NAS-Port-Type = Ethernet (5) Calling-Station-Id = "2CFD-A140-5663" (5) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (5) Huawei-IPHost-Addr = "0.0.0.0 2c:fd:a1:40:56:63" (5) Huawei-Input-Burst-Size = 0 (5) Huawei-Input-Average-Rate = 0 (5) Huawei-Output-Burst-Size = 0 (5) Huawei-Output-Average-Rate = 0 (5) Huawei-Priority = 4294901760 (5) Huawei-Connect-ID = 18 (5) NAS-IP-Address = 192.168.1.250 (5) # Executing section preacct from file /etc/raddb/sites-enabled/default (5) preacct { (5) [preprocess] = ok (5) policy acct_unique { (5) update request { (5) &Tmp-String-9 := "ai:" (5) } # update request = noop (5) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (5) EXPAND %{hex:&Class} (5) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (5) EXPAND ^%{hex:&Tmp-String-9} (5) --> ^61693a (5) EXPAND %{string:&Class} (5) --> ai:eeb48447d7fc651841de71cbc345e430 (5) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (5) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (5) update request { (5) EXPAND %{md5:%{1},%{Acct-Session-ID}} (5) --> 4724459955b82bd4ca68cd4ecae82464 (5) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (5) } # update request = noop (5) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (5) ... skipping else: Preceding "if" was taken (5) } # policy acct_unique = noop (5) suffix: Checking for suffix after "@" (5) suffix: No '@' in User-Name = "test", looking up realm NULL (5) suffix: No such realm "NULL" (5) [suffix] = noop (5) } # preacct = ok (5) # Executing section accounting from file /etc/raddb/sites-enabled/default (5) accounting { (5) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (5) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (5) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (5) detail: EXPAND %t (5) detail: --> Mon Jan 24 17:24:47 2022 (5) [detail] = ok (5) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (5) sql: --> type.interim-update.query (5) sql: Using query template 'query' rlm_sql (sql): Reserved connection (2) (5) sql: EXPAND %{User-Name} (5) sql: --> test (5) sql: SQL-User-Name set to 'test' (5) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (5) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148149), acctinterval = 1199148149 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 450, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (5) sql: EXPAND /var/log/radius/accounting.sql (5) sql: --> /var/log/radius/accounting.sql (5) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148149), acctinterval = 1199148149 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 450, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (5) sql: SQL query returned: success (5) sql: 1 record(s) updated rlm_sql (sql): Released connection (2) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (11), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Closing expired connection (9) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket (5) [sql] = ok (5) [exec] = noop (5) attr_filter.accounting_response: EXPAND %{User-Name} (5) attr_filter.accounting_response: --> test (5) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (5) [attr_filter.accounting_response] = updated (5) } # accounting = updated (5) Sent Accounting-Response Id 47 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (5) Finished request (5) Cleaning up request packet ID 47 with timestamp +252 Ready to process requests (6) Received Accounting-Request Id 48 from 192.168.1.250:1812 to 192.168.1.8:1813 length 316 (6) User-Name = "test" (6) NAS-Port = 32769 (6) Framed-IP-Address = 0.0.0.0 (6) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (6) NAS-Identifier = "Quidway" (6) Acct-Status-Type = Interim-Update (6) Acct-Delay-Time = 0 (6) Acct-Input-Octets = 0 (6) Acct-Output-Octets = 0 (6) Acct-Session-Id = "Quidway000080000000018095e0000018" (6) Acct-Authentic = RADIUS (6) Acct-Session-Time = 480 (6) Acct-Input-Packets = 0 (6) Acct-Output-Packets = 0 (6) Acct-Input-Gigawords = 0 (6) Acct-Output-Gigawords = 0 (6) Event-Timestamp = "Jan 1 2008 08:42:59 CST" (6) NAS-Port-Type = Ethernet (6) Calling-Station-Id = "2CFD-A140-5663" (6) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (6) Huawei-IPHost-Addr = "0.0.0.0 2c:fd:a1:40:56:63" (6) Huawei-Input-Burst-Size = 0 (6) Huawei-Input-Average-Rate = 0 (6) Huawei-Output-Burst-Size = 0 (6) Huawei-Output-Average-Rate = 0 (6) Huawei-Priority = 4294901760 (6) Huawei-Connect-ID = 18 (6) NAS-IP-Address = 192.168.1.250 (6) # Executing section preacct from file /etc/raddb/sites-enabled/default (6) preacct { (6) [preprocess] = ok (6) policy acct_unique { (6) update request { (6) &Tmp-String-9 := "ai:" (6) } # update request = noop (6) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (6) EXPAND %{hex:&Class} (6) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (6) EXPAND ^%{hex:&Tmp-String-9} (6) --> ^61693a (6) EXPAND %{string:&Class} (6) --> ai:eeb48447d7fc651841de71cbc345e430 (6) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (6) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (6) update request { (6) EXPAND %{md5:%{1},%{Acct-Session-ID}} (6) --> 4724459955b82bd4ca68cd4ecae82464 (6) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (6) } # update request = noop (6) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (6) ... skipping else: Preceding "if" was taken (6) } # policy acct_unique = noop (6) suffix: Checking for suffix after "@" (6) suffix: No '@' in User-Name = "test", looking up realm NULL (6) suffix: No such realm "NULL" (6) [suffix] = noop (6) } # preacct = ok (6) # Executing section accounting from file /etc/raddb/sites-enabled/default (6) accounting { (6) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (6) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (6) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (6) detail: EXPAND %t (6) detail: --> Mon Jan 24 17:25:16 2022 (6) [detail] = ok (6) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (6) sql: --> type.interim-update.query (6) sql: Using query template 'query' rlm_sql (sql): Reserved connection (3) (6) sql: EXPAND %{User-Name} (6) sql: --> test (6) sql: SQL-User-Name set to 'test' (6) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (6) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148179), acctinterval = 1199148179 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 480, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (6) sql: EXPAND /var/log/radius/accounting.sql (6) sql: --> /var/log/radius/accounting.sql (6) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148179), acctinterval = 1199148179 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 480, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (6) sql: SQL query returned: success (6) sql: 1 record(s) updated rlm_sql (sql): Released connection (3) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (12), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 (6) [sql] = ok (6) [exec] = noop (6) attr_filter.accounting_response: EXPAND %{User-Name} (6) attr_filter.accounting_response: --> test (6) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (6) [attr_filter.accounting_response] = updated (6) } # accounting = updated (6) Sent Accounting-Response Id 48 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (6) Finished request (6) Cleaning up request packet ID 48 with timestamp +281 Ready to process requests (7) Received Accounting-Request Id 49 from 192.168.1.250:1812 to 192.168.1.8:1813 length 316 (7) User-Name = "test" (7) NAS-Port = 32769 (7) Framed-IP-Address = 0.0.0.0 (7) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (7) NAS-Identifier = "Quidway" (7) Acct-Status-Type = Interim-Update (7) Acct-Delay-Time = 0 (7) Acct-Input-Octets = 0 (7) Acct-Output-Octets = 0 (7) Acct-Session-Id = "Quidway000080000000018095e0000018" (7) Acct-Authentic = RADIUS (7) Acct-Session-Time = 540 (7) Acct-Input-Packets = 0 (7) Acct-Output-Packets = 0 (7) Acct-Input-Gigawords = 0 (7) Acct-Output-Gigawords = 0 (7) Event-Timestamp = "Jan 1 2008 08:43:59 CST" (7) NAS-Port-Type = Ethernet (7) Calling-Station-Id = "2CFD-A140-5663" (7) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (7) Huawei-IPHost-Addr = "0.0.0.0 2c:fd:a1:40:56:63" (7) Huawei-Input-Burst-Size = 0 (7) Huawei-Input-Average-Rate = 0 (7) Huawei-Output-Burst-Size = 0 (7) Huawei-Output-Average-Rate = 0 (7) Huawei-Priority = 4294901760 (7) Huawei-Connect-ID = 18 (7) NAS-IP-Address = 192.168.1.250 (7) # Executing section preacct from file /etc/raddb/sites-enabled/default (7) preacct { (7) [preprocess] = ok (7) policy acct_unique { (7) update request { (7) &Tmp-String-9 := "ai:" (7) } # update request = noop (7) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (7) EXPAND %{hex:&Class} (7) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (7) EXPAND ^%{hex:&Tmp-String-9} (7) --> ^61693a (7) EXPAND %{string:&Class} (7) --> ai:eeb48447d7fc651841de71cbc345e430 (7) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (7) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (7) update request { (7) EXPAND %{md5:%{1},%{Acct-Session-ID}} (7) --> 4724459955b82bd4ca68cd4ecae82464 (7) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (7) } # update request = noop (7) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (7) ... skipping else: Preceding "if" was taken (7) } # policy acct_unique = noop (7) suffix: Checking for suffix after "@" (7) suffix: No '@' in User-Name = "test", looking up realm NULL (7) suffix: No such realm "NULL" (7) [suffix] = noop (7) } # preacct = ok (7) # Executing section accounting from file /etc/raddb/sites-enabled/default (7) accounting { (7) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (7) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (7) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (7) detail: EXPAND %t (7) detail: --> Mon Jan 24 17:26:15 2022 (7) [detail] = ok (7) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (7) sql: --> type.interim-update.query (7) sql: Using query template 'query' rlm_sql (sql): Reserved connection (10) (7) sql: EXPAND %{User-Name} (7) sql: --> test (7) sql: SQL-User-Name set to 'test' (7) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (7) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148239), acctinterval = 1199148239 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 540, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (7) sql: EXPAND /var/log/radius/accounting.sql (7) sql: --> /var/log/radius/accounting.sql (7) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148239), acctinterval = 1199148239 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 540, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (7) sql: SQL query returned: success (7) sql: 1 record(s) updated rlm_sql (sql): Released connection (10) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (13), 1 of 27 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Closing expired connection (11) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing expired connection (2) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket (7) [sql] = ok (7) [exec] = noop (7) attr_filter.accounting_response: EXPAND %{User-Name} (7) attr_filter.accounting_response: --> test (7) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (7) [attr_filter.accounting_response] = updated (7) } # accounting = updated (7) Sent Accounting-Response Id 49 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (7) Finished request (7) Cleaning up request packet ID 49 with timestamp +340 Ready to process requests (8) Received Accounting-Request Id 50 from 192.168.1.250:1812 to 192.168.1.8:1813 length 316 (8) User-Name = "test" (8) NAS-Port = 32769 (8) Framed-IP-Address = 0.0.0.0 (8) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (8) NAS-Identifier = "Quidway" (8) Acct-Status-Type = Interim-Update (8) Acct-Delay-Time = 0 (8) Acct-Input-Octets = 0 (8) Acct-Output-Octets = 0 (8) Acct-Session-Id = "Quidway000080000000018095e0000018" (8) Acct-Authentic = RADIUS (8) Acct-Session-Time = 566 (8) Acct-Input-Packets = 0 (8) Acct-Output-Packets = 0 (8) Acct-Input-Gigawords = 0 (8) Acct-Output-Gigawords = 0 (8) Event-Timestamp = "Jan 1 2008 08:44:25 CST" (8) NAS-Port-Type = Ethernet (8) Calling-Station-Id = "2CFD-A140-5663" (8) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (8) Huawei-IPHost-Addr = "0.0.0.0 2c:fd:a1:40:56:63" (8) Huawei-Input-Burst-Size = 0 (8) Huawei-Input-Average-Rate = 0 (8) Huawei-Output-Burst-Size = 0 (8) Huawei-Output-Average-Rate = 0 (8) Huawei-Priority = 4294901760 (8) Huawei-Connect-ID = 18 (8) NAS-IP-Address = 192.168.1.250 (8) # Executing section preacct from file /etc/raddb/sites-enabled/default (8) preacct { (8) [preprocess] = ok (8) policy acct_unique { (8) update request { (8) &Tmp-String-9 := "ai:" (8) } # update request = noop (8) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (8) EXPAND %{hex:&Class} (8) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (8) EXPAND ^%{hex:&Tmp-String-9} (8) --> ^61693a (8) EXPAND %{string:&Class} (8) --> ai:eeb48447d7fc651841de71cbc345e430 (8) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (8) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (8) update request { (8) EXPAND %{md5:%{1},%{Acct-Session-ID}} (8) --> 4724459955b82bd4ca68cd4ecae82464 (8) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (8) } # update request = noop (8) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (8) ... skipping else: Preceding "if" was taken (8) } # policy acct_unique = noop (8) suffix: Checking for suffix after "@" (8) suffix: No '@' in User-Name = "test", looking up realm NULL (8) suffix: No such realm "NULL" (8) [suffix] = noop (8) } # preacct = ok (8) # Executing section accounting from file /etc/raddb/sites-enabled/default (8) accounting { (8) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (8) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (8) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (8) detail: EXPAND %t (8) detail: --> Mon Jan 24 17:26:42 2022 (8) [detail] = ok (8) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (8) sql: --> type.interim-update.query (8) sql: Using query template 'query' rlm_sql (sql): Reserved connection (3) (8) sql: EXPAND %{User-Name} (8) sql: --> test (8) sql: SQL-User-Name set to 'test' (8) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (8) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148265), acctinterval = 1199148265 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 566, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (8) sql: EXPAND /var/log/radius/accounting.sql (8) sql: --> /var/log/radius/accounting.sql (8) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148265), acctinterval = 1199148265 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 566, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (8) sql: SQL query returned: success (8) sql: 1 record(s) updated rlm_sql (sql): Released connection (3) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (14), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 rlm_sql (sql): Closing expired connection (12) - Hit idle_timeout limit rlm_sql_mysql: Socket destructor called, closing socket (8) [sql] = ok (8) [exec] = noop (8) attr_filter.accounting_response: EXPAND %{User-Name} (8) attr_filter.accounting_response: --> test (8) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (8) [attr_filter.accounting_response] = updated (8) } # accounting = updated (8) Sent Accounting-Response Id 50 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (8) Finished request (8) Cleaning up request packet ID 50 with timestamp +367 Ready to process requests (9) Received Accounting-Request Id 51 from 192.168.1.250:1812 to 192.168.1.8:1813 length 316 (9) User-Name = "test" (9) NAS-Port = 32769 (9) Framed-IP-Address = 0.0.0.0 (9) Class = 0x61693a6565623438343437643766633635313834316465373163626333343565343330 (9) NAS-Identifier = "Quidway" (9) Acct-Status-Type = Interim-Update (9) Acct-Delay-Time = 0 (9) Acct-Input-Octets = 0 (9) Acct-Output-Octets = 0 (9) Acct-Session-Id = "Quidway000080000000018095e0000018" (9) Acct-Authentic = RADIUS (9) Acct-Session-Time = 600 (9) Acct-Input-Packets = 0 (9) Acct-Output-Packets = 0 (9) Acct-Input-Gigawords = 0 (9) Acct-Output-Gigawords = 0 (9) Event-Timestamp = "Jan 1 2008 08:44:59 CST" (9) NAS-Port-Type = Ethernet (9) Calling-Station-Id = "2CFD-A140-5663" (9) NAS-Port-Id = "slot=0;subslot=0;port=8;vlanid=1" (9) Huawei-IPHost-Addr = "0.0.0.0 2c:fd:a1:40:56:63" (9) Huawei-Input-Burst-Size = 0 (9) Huawei-Input-Average-Rate = 0 (9) Huawei-Output-Burst-Size = 0 (9) Huawei-Output-Average-Rate = 0 (9) Huawei-Priority = 4294901760 (9) Huawei-Connect-ID = 18 (9) NAS-IP-Address = 192.168.1.250 (9) # Executing section preacct from file /etc/raddb/sites-enabled/default (9) preacct { (9) [preprocess] = ok (9) policy acct_unique { (9) update request { (9) &Tmp-String-9 := "ai:" (9) } # update request = noop (9) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (9) EXPAND %{hex:&Class} (9) --> 61693a6565623438343437643766633635313834316465373163626333343565343330 (9) EXPAND ^%{hex:&Tmp-String-9} (9) --> ^61693a (9) EXPAND %{string:&Class} (9) --> ai:eeb48447d7fc651841de71cbc345e430 (9) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> TRUE (9) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (9) update request { (9) EXPAND %{md5:%{1},%{Acct-Session-ID}} (9) --> 4724459955b82bd4ca68cd4ecae82464 (9) &Acct-Unique-Session-Id := 4724459955b82bd4ca68cd4ecae82464 (9) } # update request = noop (9) } # if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) = noop (9) ... skipping else: Preceding "if" was taken (9) } # policy acct_unique = noop (9) suffix: Checking for suffix after "@" (9) suffix: No '@' in User-Name = "test", looking up realm NULL (9) suffix: No such realm "NULL" (9) [suffix] = noop (9) } # preacct = ok (9) # Executing section accounting from file /etc/raddb/sites-enabled/default (9) accounting { (9) detail: EXPAND /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (9) detail: --> /var/log/radius/radacct/192.168.1.250/detail-20220124 (9) detail: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.250/detail-20220124 (9) detail: EXPAND %t (9) detail: --> Mon Jan 24 17:27:15 2022 (9) [detail] = ok (9) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (9) sql: --> type.interim-update.query (9) sql: Using query template 'query' rlm_sql (sql): Reserved connection (10) (9) sql: EXPAND %{User-Name} (9) sql: --> test (9) sql: SQL-User-Name set to 'test' (9) sql: EXPAND UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval = %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (9) sql: --> UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148299), acctinterval = 1199148299 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 600, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' (9) sql: EXPAND /var/log/radius/accounting.sql (9) sql: --> /var/log/radius/accounting.sql (9) sql: Executing query: UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = FROM_UNIXTIME(1199148299), acctinterval = 1199148299 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '0.0.0.0', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 600, acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE AcctUniqueId = '4724459955b82bd4ca68cd4ecae82464' rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 (9) sql: SQL query returned: success (9) sql: 1 record(s) updated rlm_sql (sql): Released connection (10) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (15), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 127.0.0.1 via TCP/IP, server version 5.6.50-log, protocol version 10 (9) [sql] = ok (9) [exec] = noop (9) attr_filter.accounting_response: EXPAND %{User-Name} (9) attr_filter.accounting_response: --> test (9) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (9) [attr_filter.accounting_response] = updated (9) } # accounting = updated (9) Sent Accounting-Response Id 51 from 192.168.1.8:1813 to 192.168.1.250:1812 length 20 (9) Finished request (9) Cleaning up request packet ID 51 with timestamp +400
No response
Your NAS is broken.
mcnewton
commented
2 years ago mcnewton
commented
2 years ago
What type of defect/bug is this?
Unexpected behaviour (obvious or verified by project member)
How can the issue be reproduced?
When the user goes online for about 1 minute, framedipaddress cannot obtain the real IP
Log output from the FreeRADIUS daemon
Relevant log output from client utilities
No response
Backtrace from LLDB or GDB
No response