Here is the debug log. Please let me know what configuration info is needed and I'll send along. Bill [root@ip-192-168-168-54 sbin]# ./radiusd -X FreeRADIUS Version 3.0.13 Copyright (C) 1999-2017 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/local/billmax/freeradius/share/freeradius/dictionary including dictionary file /usr/local/billmax/freeradius/share/freeradius/dictionary.dhcp including dictionary file /usr/local/billmax/freeradius/share/freeradius/dictionary.vqp including dictionary file /usr/local/billmax/freeradius/etc/raddb/dictionary including configuration file /usr/local/billmax/freeradius/etc/raddb/radiusd.conf including configuration file /usr/local/billmax/freeradius/etc/raddb/proxy.conf including configuration file /usr/local/billmax/freeradius/etc/raddb/clients.conf including files in directory /usr/local/billmax/freeradius/etc/raddb/mods-enabled/ including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/utf8 including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/logintime including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/cache_eap including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/linelog including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/soh including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/ntlm_auth including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/sradutmp including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/passwd including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/files including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/dynamic_clients including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/eap including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/replicate including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/mschap including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/chap including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/radutmp including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/date including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/dhcp including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/echo including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/expr including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/digest including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/pap including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/unpack including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/expiration including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/unix including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/exec including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/preprocess including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/sql including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-config/sql/main/mysql/queries.conf including configuration file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/perl including files in directory /usr/local/billmax/freeradius/etc/raddb/policy.d/ including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/abfab-tr including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/dhcp including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/control including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/cui including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/moonshot-targeted-ids including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/canonicalization including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/eap including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/filter including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/debug including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/operator-name including configuration file /usr/local/billmax/freeradius/etc/raddb/policy.d/accounting including files in directory /usr/local/billmax/freeradius/etc/raddb/sites-enabled/ including configuration file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/inner-tunnel including configuration file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default main {  security {         user = "billmax"         group = "billmax"         allow_core_dumps = no  }         name = "radiusd"         prefix = "/usr/local/billmax/freeradius"         localstatedir = "/usr/local/billmax/freeradius/var"         logdir = "/usr/local/billmax/freeradius/var/log/radius"         run_dir = "/usr/local/billmax/freeradius/var/run/radiusd" } main {         name = "radiusd"         prefix = "/usr/local/billmax/freeradius"         localstatedir = "/usr/local/billmax/freeradius/var"         sbindir = "/usr/local/billmax/freeradius/sbin"         logdir = "/usr/local/billmax/freeradius/var/log/radius"         run_dir = "/usr/local/billmax/freeradius/var/run/radiusd"         libdir = "/usr/local/billmax/freeradius/lib"         radacctdir = "/usr/local/billmax/freeradius/var/log/radius/radacct"         hostname_lookups = no         max_request_time = 30         cleanup_delay = 5         max_requests = 16384         pidfile = "/usr/local/billmax/freeradius/var/run/radiusd/radiusd.pid"         checkrad = "/usr/local/billmax/freeradius/sbin/checkrad"         debug_level = 0         proxy_requests = yes  log {         stripped_names = no         auth = yes         auth_badpass = no         auth_goodpass = no         colourise = yes         msg_denied = "You are already logged in - access denied"  }  resources {  }  security {         max_attributes = 200         reject_delay = 1.000000         status_server = yes         allow_vulnerable_openssl = "yes"  } } radiusd: #### Loading Realms and Home Servers ####  proxy server {         retry_delay = 5         retry_count = 3         default_fallback = no         dead_time = 120         wake_all_if_all_dead = no  }  home_server localhost {         ipaddr = 127.0.0.1         port = 1812         type = "auth"         secret = <<< secret >>>         response_window = 20.000000         response_timeouts = 1         max_outstanding = 65536         zombie_period = 40         status_check = "status-server"         ping_interval = 30         check_interval = 30         check_timeout = 4         num_answers_to_alive = 3         revive_interval = 120   limit {         max_connections = 16         max_requests = 0         lifetime = 0         idle_timeout = 0   }   coa {         irt = 2         mrt = 16         mrc = 5         mrd = 30   }  }  home_server_pool my_auth_failover {         type = fail-over         home_server = localhost  }  realm example.com {         auth_pool = my_auth_failover  }  realm LOCAL {  } 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  # Creating Auth-Type = mschap  # Creating Auth-Type = eap  # Creating Auth-Type = PAP  # Creating Auth-Type = CHAP  # Creating Auth-Type = MS-CHAP  # Creating Auth-Type = digest radiusd: #### Instantiating modules ####  modules {   # Loaded module rlm_utf8   # Loading module "utf8" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/utf8   # Loaded module rlm_logintime   # Loading module "logintime" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/logintime   logintime {         minimum_timeout = 60   }   # Loaded module rlm_cache   # Loading module "cache_eap" from file /usr/local/billmax/freeradius/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_linelog   # Loading module "linelog" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/linelog   linelog {         filename = "/usr/local/billmax/freeradius/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 /usr/local/billmax/freeradius/etc/raddb/mods-enabled/linelog   linelog log_accounting {         filename = "/usr/local/billmax/freeradius/var/log/radius/linelog-accounting"         escape_filenames = no         syslog_severity = "info"         permissions = 384         format = ""         reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}"   }   # Loaded module rlm_soh   # Loading module "soh" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/soh   soh {         dhcp = yes   }   # Loaded module rlm_exec   # Loading module "ntlm_auth" from file /usr/local/billmax/freeradius/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_radutmp   # Loading module "sradutmp" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/sradutmp   radutmp sradutmp {         filename = "/usr/local/billmax/freeradius/var/log/radius/sradutmp"         username = "%{User-Name}"         case_sensitive = yes         check_with_nas = yes         permissions = 420         caller_id = no   }   # Loaded module rlm_realm   # Loading module "IPASS" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   realm IPASS {         format = "prefix"         delimiter = "/"         ignore_default = no         ignore_null = no   }   # Loading module "suffix" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   realm suffix {         format = "suffix"         delimiter = "@"         ignore_default = no         ignore_null = no   }   # Loading module "realmpercent" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   realm realmpercent {         format = "suffix"         delimiter = "%"         ignore_default = no         ignore_null = no   }   # Loading module "ntdomain" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   realm ntdomain {         format = "prefix"         delimiter = "\\"         ignore_default = no         ignore_null = no   }   # Loaded module rlm_always   # Loading module "reject" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always reject {         rcode = "reject"         simulcount = 0         mpp = no   }   # Loading module "fail" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always fail {         rcode = "fail"         simulcount = 0         mpp = no   }   # Loading module "ok" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always ok {         rcode = "ok"         simulcount = 0         mpp = no   }   # Loading module "handled" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always handled {         rcode = "handled"         simulcount = 0         mpp = no   }   # Loading module "invalid" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always invalid {         rcode = "invalid"         simulcount = 0         mpp = no   }   # Loading module "userlock" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always userlock {         rcode = "userlock"         simulcount = 0         mpp = no   }   # Loading module "notfound" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always notfound {         rcode = "notfound"         simulcount = 0         mpp = no   }   # Loading module "noop" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always noop {         rcode = "noop"         simulcount = 0         mpp = no   }   # Loading module "updated" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   always updated {         rcode = "updated"         simulcount = 0         mpp = no   }   # Loaded module rlm_passwd   # Loading module "etc_passwd" from file /usr/local/billmax/freeradius/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_detail   # Loading module "detail" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail   detail {         filename = "/usr/local/billmax/freeradius/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   }   # Loaded module rlm_files   # Loading module "files" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/files   files {         filename = "/usr/local/billmax/freeradius/etc/raddb/mods-config/files/authorize"         acctusersfile = "/usr/local/billmax/freeradius/etc/raddb/mods-config/files/accounting"         preproxy_usersfile = "/usr/local/billmax/freeradius/etc/raddb/mods-config/files/pre-proxy"   }   # Loaded module rlm_dynamic_clients   # Loading module "dynamic_clients" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/dynamic_clients   # Loaded module rlm_eap   # Loading module "eap" from file /usr/local/billmax/freeradius/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_replicate   # Loading module "replicate" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/replicate   # Loaded module rlm_mschap   # Loading module "mschap" from file /usr/local/billmax/freeradius/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   }   # Loaded module rlm_chap   # Loading module "chap" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/chap   # Loading module "radutmp" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/radutmp   radutmp {         filename = "/usr/local/billmax/freeradius/var/log/radius/radutmp"         username = "%{User-Name}"         case_sensitive = yes         check_with_nas = yes         permissions = 384         caller_id = yes   }   # Loaded module rlm_date   # Loading module "date" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/date   date {         format = "%b %e %Y %H:%M:%S %Z"   }   # Loaded module rlm_dhcp   # Loading module "dhcp" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/dhcp   # Loading module "echo" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/echo   exec echo {         wait = yes         program = "/bin/echo %{User-Name}"         input_pairs = "request"         output_pairs = "reply"         shell_escape = yes   }   # Loaded module rlm_expr   # Loading module "expr" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/expr   expr {         safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôÅùûüaÿà ÃÃÃÃÃÃÃÃÃÃÃÃÃÃÃÅÃß"   }   # Loaded module rlm_digest   # Loading module "digest" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/digest   # Loaded module rlm_attr_filter   # Loading module "attr_filter.post-proxy" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter   attr_filter attr_filter.post-proxy {         filename = "/usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/post-proxy"         key = "%{Realm}"         relaxed = no   }   # Loading module "attr_filter.pre-proxy" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter   attr_filter attr_filter.pre-proxy {         filename = "/usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/pre-proxy"         key = "%{Realm}"         relaxed = no   }   # Loading module "attr_filter.access_reject" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter   attr_filter attr_filter.access_reject {         filename = "/usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/access_reject"         key = "%{User-Name}"         relaxed = no   }   # Loading module "attr_filter.access_challenge" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter   attr_filter attr_filter.access_challenge {         filename = "/usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/access_challenge"         key = "%{User-Name}"         relaxed = no   }   # Loading module "attr_filter.accounting_response" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter   attr_filter attr_filter.accounting_response {         filename = "/usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/accounting_response"         key = "%{User-Name}"         relaxed = no   }   # Loaded module rlm_pap   # Loading module "pap" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/pap   pap {         normalise = yes   }   # Loaded module rlm_unpack   # Loading module "unpack" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/unpack   # Loaded module rlm_expiration   # Loading module "expiration" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/expiration   # Loading module "auth_log" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log   detail auth_log {         filename = "/usr/local/billmax/freeradius/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 /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log   detail reply_log {         filename = "/usr/local/billmax/freeradius/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 /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log   detail pre_proxy_log {         filename = "/usr/local/billmax/freeradius/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 /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log   detail post_proxy_log {         filename = "/usr/local/billmax/freeradius/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_unix   # Loading module "unix" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/unix   unix {         radwtmp = "/usr/local/billmax/freeradius/var/log/radius/radwtmp"   } Creating attribute Unix-Group   # Loading module "exec" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/exec   exec {         wait = no         input_pairs = "request"         shell_escape = yes         timeout = 10   }   # Loaded module rlm_preprocess   # Loading module "preprocess" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/preprocess   preprocess {         huntgroups = "/usr/local/billmax/freeradius/etc/raddb/mods-config/preprocess/huntgroups"         hints = "/usr/local/billmax/freeradius/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_sql   # Loading module "sql" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/sql   sql {         driver = "rlm_sql_mysql"         server = "localhost"         port = 3306         login = "billmax"         password = <<< secret >>>         radius_db = "billmax"         read_groups = yes         read_profiles = yes         read_clients = yes         delete_stale_sessions = yes         sql_user_name = "%{User-Name}"         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.-_: /"    accounting {         reference = "%{tolower:type.%{Acct-Status-Type}.query}"     type {      accounting-on {         query = "UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime   = '%{integer:Event-Timestamp}' - 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})"      }      accounting-off {         query = "UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime   = '%{integer:Event-Timestamp}' - 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})"      }      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) 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}), FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')"      }      interim-update {         query = "UPDATE radacct SET acctupdatetime  = (@acctupdatetime_old:=acctupdatetime), acctupdatetime  = FROM_UNIXTIME(%{integer:Event-Timestamp}), acctinterval    = %{integer:Event-Timestamp} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', 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}), 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"         query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')"    }   } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Creating attribute SQL-Group   # Loaded module rlm_perl   # Loading module "perl" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/perl   perl {         filename = "/usr/local/billmax/freeradius/etc/raddb/mods-config/perl/freeradius.pl"         func_authorize = "authorize"         func_authenticate = "authenticate"         func_post_auth = "post_auth"         func_accounting = "accounting"         func_preacct = "preacct"         func_checksimul = "checksimul"         func_detach = "detach"         func_xlat = "xlat"         func_pre_proxy = "pre_proxy"         func_post_proxy = "post_proxy"         func_recv_coa = "recv_coa"         func_send_coa = "send_coa"   }   instantiate {   }   # Instantiating module "logintime" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/logintime   # Instantiating module "cache_eap" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/cache_eap rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked   # Instantiating module "linelog" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/linelog   # Instantiating module "log_accounting" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/linelog   # Instantiating module "IPASS" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   # Instantiating module "suffix" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   # Instantiating module "realmpercent" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   # Instantiating module "ntdomain" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/realm   # Instantiating module "reject" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "fail" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "ok" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "handled" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "invalid" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "userlock" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "notfound" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "noop" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "updated" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/always   # Instantiating module "etc_passwd" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no   # Instantiating module "detail" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail   # Instantiating module "files" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/files reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/files/authorize reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/files/accounting reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/files/pre-proxy   # Instantiating module "eap" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/eap    # Linked to sub-module rlm_eap_md5    # Linked to sub-module rlm_eap_leap    # 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 = "/usr/local/billmax/freeradius/etc/raddb/certs"         pem_file_type = yes         private_key_file = "/usr/local/billmax/freeradius/etc/raddb/certs/server.pem"         certificate_file = "/usr/local/billmax/freeradius/etc/raddb/certs/server.pem"         ca_file = "/usr/local/billmax/freeradius/etc/raddb/certs/ca.pem"         private_key_password = <<< secret >>>         dh_file = "/usr/local/billmax/freeradius/etc/raddb/certs/dh"         fragment_size = 1024         include_length = yes         auto_chain = yes         check_crl = no         check_all_crl = no         cipher_list = "DEFAULT"         cipher_server_preference = no         ecdh_curve = "prime256v1"     cache {         enable = yes         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 "mschap" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/mschap rlm_mschap (mschap): using internal authentication   # Instantiating module "attr_filter.post-proxy" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/post-proxy   # Instantiating module "attr_filter.pre-proxy" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/pre-proxy   # Instantiating module "attr_filter.access_reject" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/access_reject [/usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay"       found in filter list for realm "DEFAULT". [/usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay-USec"  found in filter list for realm "DEFAULT".   # Instantiating module "attr_filter.access_challenge" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/access_challenge   # Instantiating module "attr_filter.accounting_response" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/attr_filter reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/attr_filter/accounting_response   # Instantiating module "pap" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/pap   # Instantiating module "expiration" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/expiration   # Instantiating module "auth_log" from file /usr/local/billmax/freeradius/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 /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log   # Instantiating module "pre_proxy_log" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log   # Instantiating module "post_proxy_log" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/detail.log   # Instantiating module "preprocess" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/preprocess reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/preprocess/huntgroups reading pairlist file /usr/local/billmax/freeradius/etc/raddb/mods-config/preprocess/hints   # Instantiating module "sql" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/sql rlm_sql_mysql: libmysql version: 5.5.60-MariaDB    mysql {     tls {     }         warnings = "auto"    } rlm_sql (sql): Attempting to connect to database "billmax" 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 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, 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 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, 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 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, 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 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, 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 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, 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 10.23.43.3 (10.23.43.3) to global clients list rlm_sql (10.23.43.3): Client "10.23.43.3" (sql) added rlm_sql (sql): Adding client 10.23.40.4 (10.23.40.4) to global clients list rlm_sql (10.23.40.4): Client "10.23.40.4" (sql) added rlm_sql (sql): Adding client 10.23.35.7 (10.23.35.7) to global clients list rlm_sql (10.23.35.7): Client "10.23.35.7" (sql) added rlm_sql (sql): Adding client 10.23.38.16 (10.23.38.16) to global clients list rlm_sql (10.23.38.16): Client "10.23.38.16" (sql) added rlm_sql (sql): Adding client 10.23.43.9 (10.23.43.9) to global clients list rlm_sql (10.23.43.9): Client "10.23.43.9" (sql) added rlm_sql (sql): Adding client 10.23.37.3 (10.23.37.3) to global clients list rlm_sql (10.23.37.3): Client "10.23.37.3" (sql) added rlm_sql (sql): Adding client 10.23.42.6 (10.23.42.6) to global clients list rlm_sql (10.23.42.6): Client "10.23.42.6" (sql) added rlm_sql (sql): Adding client 10.23.38.8 (10.23.38.8) to global clients list rlm_sql (10.23.38.8): Client "10.23.38.8" (sql) added rlm_sql (sql): Adding client 10.23.38.15 (10.23.38.15) to global clients list rlm_sql (10.23.38.15): Client "10.23.38.15" (sql) added rlm_sql (sql): Adding client 10.23.35.8 (10.23.35.8) to global clients list rlm_sql (10.23.35.8): Client "10.23.35.8" (sql) added rlm_sql (sql): Adding client 10.23.42.10 (10.23.42.10) to global clients list rlm_sql (10.23.42.10): Client "10.23.42.10" (sql) added rlm_sql (sql): Adding client 10.23.38.4 (10.23.38.4) to global clients list rlm_sql (10.23.38.4): Client "10.23.38.4" (sql) added rlm_sql (sql): Adding client 10.23.38.7 (10.23.38.7) to global clients list rlm_sql (10.23.38.7): Client "10.23.38.7" (sql) added rlm_sql (sql): Adding client 10.23.35.13 (10.23.35.13) to global clients list rlm_sql (10.23.35.13): Client "10.23.35.13" (sql) added rlm_sql (sql): Adding client 10.23.34.3 (10.23.34.3) to global clients list rlm_sql (10.23.34.3): Client "10.23.34.3" (sql) added rlm_sql (sql): Adding client 10.23.45.7 (10.23.45.7) to global clients list rlm_sql (10.23.45.7): Client "10.23.45.7" (sql) added rlm_sql (sql): Adding client 10.23.35.9 (10.23.35.9) to global clients list rlm_sql (10.23.35.9): Client "10.23.35.9" (sql) added rlm_sql (sql): Adding client 10.23.36.4 (10.23.36.4) to global clients list rlm_sql (10.23.36.4): Client "10.23.36.4" (sql) added rlm_sql (sql): Adding client 10.23.36.5 (10.23.36.5) to global clients list rlm_sql (10.23.36.5): Client "10.23.36.5" (sql) added rlm_sql (sql): Adding client 10.23.43.7 (10.23.43.7) to global clients list rlm_sql (10.23.43.7): Client "10.23.43.7" (sql) added rlm_sql (sql): Adding client 10.23.38.14 (10.23.38.14) to global clients list rlm_sql (10.23.38.14): Client "10.23.38.14" (sql) added rlm_sql (sql): Adding client 10.23.36.12 (10.23.36.12) to global clients list rlm_sql (10.23.36.12): Client "10.23.36.12" (sql) added rlm_sql (sql): Adding client 10.23.38.10 (10.23.38.10) to global clients list rlm_sql (10.23.38.10): Client "10.23.38.10" (sql) added rlm_sql (sql): Adding client 10.23.45.6 (10.23.45.6) to global clients list rlm_sql (10.23.45.6): Client "10.23.45.6" (sql) added rlm_sql (sql): Adding client 10.23.43.8 (10.23.43.8) to global clients list rlm_sql (10.23.43.8): Client "10.23.43.8" (sql) added rlm_sql (sql): Adding client 10.23.40.6 (10.23.40.6) to global clients list rlm_sql (10.23.40.6): Client "10.23.40.6" (sql) added rlm_sql (sql): Adding client 10.23.38.3 (10.23.38.3) to global clients list rlm_sql (10.23.38.3): Client "10.23.38.3" (sql) added rlm_sql (sql): Adding client 10.23.38.5 (10.23.38.5) to global clients list rlm_sql (10.23.38.5): Client "10.23.38.5" (sql) added rlm_sql (sql): Adding client 10.23.39.5 (10.23.39.5) to global clients list rlm_sql (10.23.39.5): Client "10.23.39.5" (sql) added rlm_sql (sql): Adding client 10.23.36.3 (10.23.36.3) to global clients list rlm_sql (10.23.36.3): Client "10.23.36.3" (sql) added rlm_sql (sql): Adding client 10.23.41.3 (10.23.41.3) to global clients list rlm_sql (10.23.41.3): Client "10.23.41.3" (sql) added rlm_sql (sql): Adding client 10.23.40.5 (10.23.40.5) to global clients list rlm_sql (10.23.40.5): Client "10.23.40.5" (sql) added rlm_sql (sql): Adding client 10.23.42.11 (10.23.42.11) to global clients list rlm_sql (10.23.42.11): Client "10.23.42.11" (sql) added rlm_sql (sql): Adding client 10.23.35.6 (10.23.35.6) to global clients list rlm_sql (10.23.35.6): Client "10.23.35.6" (sql) added rlm_sql (sql): Adding client 10.23.42.4 (10.23.42.4) to global clients list rlm_sql (10.23.42.4): Client "10.23.42.4" (sql) added rlm_sql (sql): Adding client 10.23.45.5 (10.23.45.5) to global clients list rlm_sql (10.23.45.5): Client "10.23.45.5" (sql) added rlm_sql (sql): Adding client 10.23.35.5 (10.23.35.5) to global clients list rlm_sql (10.23.35.5): Client "10.23.35.5" (sql) added rlm_sql (sql): Adding client 10.23.42.5 (10.23.42.5) to global clients list rlm_sql (10.23.42.5): Client "10.23.42.5" (sql) added rlm_sql (sql): Adding client 10.23.37.4 (10.23.37.4) to global clients list rlm_sql (10.23.37.4): Client "10.23.37.4" (sql) added rlm_sql (sql): Adding client 10.23.45.4 (10.23.45.4) to global clients list rlm_sql (10.23.45.4): Client "10.23.45.4" (sql) added rlm_sql (sql): Adding client 10.23.40.3 (10.23.40.3) to global clients list rlm_sql (10.23.40.3): Client "10.23.40.3" (sql) added rlm_sql (sql): Adding client 10.23.35.12 (10.23.35.12) to global clients list rlm_sql (10.23.35.12): Client "10.23.35.12" (sql) added rlm_sql (sql): Adding client 10.23.38.11 (10.23.38 .11) to global clients list rlm_sql (10.23.38.11): Client "10.23.38 .11" (sql) added rlm_sql (sql): Adding client 10.23.39.4 (10.23.39.4) to global clients list rlm_sql (10.23.39.4): Client "10.23.39.4" (sql) added rlm_sql (sql): Adding client 10.23.35.11 (10.23.35.11) to global clients list rlm_sql (10.23.35.11): Client "10.23.35.11" (sql) added rlm_sql (sql): Adding client 10.23.38.6 (10.23.38.6) to global clients list rlm_sql (10.23.38.6): Client "10.23.38.6" (sql) added rlm_sql (sql): Adding client 10.23.38.9 (10.23.38.9) to global clients list rlm_sql (10.23.38.9): Client "10.23.38.9" (sql) added rlm_sql (sql): Adding client 10.23.37.5 (10.23.37.5) to global clients list rlm_sql (10.23.37.5): Client "10.23.37.5" (sql) added rlm_sql (sql): Adding client 10.23.37.6 (10.23.37.6) to global clients list rlm_sql (10.23.37.6): Client "10.23.37.6" (sql) added rlm_sql (sql): Adding client 10.23.46.4 (10.23.46.4) to global clients list rlm_sql (10.23.46.4): Client "10.23.46.4" (sql) added rlm_sql (sql): Adding client 10.23.46.5 (10.23.46.5) to global clients list rlm_sql (10.23.46.5): Client "10.23.46.5" (sql) added rlm_sql (sql): Adding client 10.23.46.6 (10.23.46.6) to global clients list rlm_sql (10.23.46.6): Client "10.23.46.6" (sql) added rlm_sql (sql): Adding client 10.23.46.7 (10.23.46.7) to global clients list rlm_sql (10.23.46.7): Client "10.23.46.7" (sql) added rlm_sql (sql): Adding client 10.23.42.7 (10.23.42.7) to global clients list rlm_sql (10.23.42.7): Client "10.23.42.7" (sql) added rlm_sql (sql): Adding client 10.23.42.8 (10.23.42.8) to global clients list rlm_sql (10.23.42.8): Client "10.23.42.8" (sql) added rlm_sql (sql): Adding client 10.23.47.4 (10.23.47.4) to global clients list rlm_sql (10.23.47.4): Client "10.23.47.4" (sql) added rlm_sql (sql): Adding client 10.23.47.5 (10.23.47.5) to global clients list rlm_sql (10.23.47.5): Client "10.23.47.5" (sql) added rlm_sql (sql): Adding client 10.23.47.8 (10.23.47.8) to global clients list rlm_sql (10.23.47.8): Client "10.23.47.8" (sql) added rlm_sql (sql): Adding client 10.23.47.9 (10.23.47.9) to global clients list rlm_sql (10.23.47.9): Client "10.23.47.9" (sql) added rlm_sql (sql): Adding client 10.23.35.14 (10.23.35.14) to global clients list rlm_sql (10.23.35.14): Client "10.23.35.14" (sql) added rlm_sql (sql): Adding client 10.23.46.8 (10.23.46.8) to global clients list rlm_sql (10.23.46.8): Client "10.23.46.8" (sql) added rlm_sql (sql): Adding client 10.23.37.9 (10.23.37.9) to global clients list rlm_sql (10.23.37.9): Client "10.23.37.9" (sql) added rlm_sql (sql): Adding client 10.23.37.10 (10.23.37.10) to global clients list rlm_sql (10.23.37.10): Client "10.23.37.10" (sql) added rlm_sql (sql): Adding client 10.23.36.14 (10.23.36.14) to global clients list rlm_sql (10.23.36.14): Client "10.23.36.14" (sql) added rlm_sql (sql): Adding client 10.23.48.4 (10.23.48.4) to global clients list rlm_sql (10.23.48.4): Client "10.23.48.4" (sql) added rlm_sql (sql): Adding client 10.23.48.5 (10.23.48.5) to global clients list rlm_sql (10.23.48.5): Client "10.23.48.5" (sql) added rlm_sql (sql): Adding client 10.23.48.6 (10.23.48.6) to global clients list rlm_sql (10.23.48.6): Client "10.23.48.6" (sql) added rlm_sql (sql): Adding client 10.23.48.7 (10.23.48.7) to global clients list rlm_sql (10.23.48.7): Client "10.23.48.7" (sql) added rlm_sql (sql): Adding client 10.23.39.7 (10.23.39.7) to global clients list rlm_sql (10.23.39.7): Client "10.23.39.7" (sql) added rlm_sql (sql): Adding client 10.23.39.8 (10.23.39.8) to global clients list rlm_sql (10.23.39.8): Client "10.23.39.8" (sql) added rlm_sql (sql): Adding client 10.23.39.9 (10.23.39.9) to global clients list rlm_sql (10.23.39.9): Client "10.23.39.9" (sql) added rlm_sql (sql): Adding client 10.23.50.4 (10.23.50.4) to global clients list rlm_sql (10.23.50.4): Client "10.23.50.4" (sql) added rlm_sql (sql): Adding client 10.23.50.5 (10.23.50.5) to global clients list rlm_sql (10.23.50.5): Client "10.23.50.5" (sql) added rlm_sql (sql): Adding client 10.23.50.6 (10.23.50.6) to global clients list rlm_sql (10.23.50.6): Client "10.23.50.6" (sql) added rlm_sql (sql): Adding client 10.23.50.7 (10.23.50.7) to global clients list rlm_sql (10.23.50.7): Client "10.23.50.7" (sql) added rlm_sql (sql): Adding client 10.23.51.8 (10.23.51.8) to global clients list rlm_sql (10.23.51.8): Client "10.23.51.8" (sql) added rlm_sql (sql): Adding client 10.23.51.6 (10.23.51.6) to global clients list rlm_sql (10.23.51.6): Client "10.23.51.6" (sql) added rlm_sql (sql): Adding client 10.23.51.7 (10.23.51.7) to global clients list rlm_sql (10.23.51.7): Client "10.23.51.7" (sql) added rlm_sql (sql): Adding client 10.23.51.9 (10.23.51.9) to global clients list rlm_sql (10.23.51.9): Client "10.23.51.9" (sql) added rlm_sql (sql): Adding client 10.23.36.13 (10.23.36.13) to global clients list rlm_sql (10.23.36.13): Client "10.23.36.13" (sql) added rlm_sql (sql): Adding client 10.23.39.13 (10.23.39.13) to global clients list rlm_sql (10.23.39.13): Client "10.23.39.13" (sql) added rlm_sql (sql): Adding client 10.23.39.11 (10.23.39.11) to global clients list rlm_sql (10.23.39.11): Client "10.23.39.11" (sql) added rlm_sql (sql): Adding client 10.23.36.8 (10.23.36.8) to global clients list rlm_sql (10.23.36.8): Client "10.23.36.8" (sql) added rlm_sql (sql): Adding client 10.23.39.12 (10.23.39.12) to global clients list rlm_sql (10.23.39.12): Client "10.23.39.12" (sql) added rlm_sql (sql): Adding client 10.23.49.10 (10.23.49.10) to global clients list rlm_sql (10.23.49.10): Client "10.23.49.10" (sql) added rlm_sql (sql): Adding client 10.23.49.11 (10.23.49.11) to global clients list rlm_sql (10.23.49.11): Client "10.23.49.11" (sql) added rlm_sql (sql): Adding client 10.23.38.22 (10.23.38.22) to global clients list rlm_sql (10.23.38.22): Client "10.23.38.22" (sql) added rlm_sql (sql): Adding client 10.23.36.6 (10.23.36.6) to global clients list rlm_sql (10.23.36.6): Client "10.23.36.6" (sql) added rlm_sql (sql): Adding client 10.23.49.9 (10.23.49.9) to global clients list rlm_sql (10.23.49.9): Client "10.23.49.9" (sql) added rlm_sql (sql): Adding client 10.23.34.4 (10.23.34.4) to global clients list rlm_sql (10.23.34.4): Client "10.23.34.4" (sql) added rlm_sql (sql): Adding client 10.23.43.4 (10.23.43.4) to global clients list rlm_sql (10.23.43.4): Client "10.23.43.4" (sql) added rlm_sql (sql): Adding client 10.23.42.14 (10.23.42.14) to global clients list rlm_sql (10.23.42.14): Client "10.23.42.14" (sql) added rlm_sql (sql): Adding client 10.23.38.19 (10.23.38.19) to global clients list rlm_sql (10.23.38.19): Client "10.23.38.19" (sql) added rlm_sql (sql): Adding client 10.23.38.20 (10.23.38.20) to global clients list rlm_sql (10.23.38.20): Client "10.23.38.20" (sql) added rlm_sql (sql): Adding client 10.23.38.21 (10.23.38.21) to global clients list rlm_sql (10.23.38.21): Client "10.23.38.21" (sql) added rlm_sql (sql): Adding client 10.23.35.15 (10.23.35.15) to global clients list rlm_sql (10.23.35.15): Client "10.23.35.15" (sql) added rlm_sql (sql): Adding client 10.23.36.7 (10.23.36.7) to global clients list rlm_sql (10.23.36.7): Client "10.23.36.7" (sql) added rlm_sql (sql): Adding client 10.23.46.9 (10.23.46.9) to global clients list rlm_sql (10.23.46.9): Client "10.23.46.9" (sql) added rlm_sql (sql): Adding client 10.23.46.10 (10.23.46.10) to global clients list rlm_sql (10.23.46.10): Client "10.23.46.10" (sql) added rlm_sql (sql): Adding client 10.23.49.8 (10.23.49.8) to global clients list rlm_sql (10.23.49.8): Client "10.23.49.8" (sql) added rlm_sql (sql): Adding client 10.23.43.6 (10.23.43.6) to global clients list rlm_sql (10.23.43.6): Client "10.23.43.6" (sql) added rlm_sql (sql): Adding client 10.23.37.7 (10.23.37.7) to global clients list rlm_sql (10.23.37.7): Client "10.23.37.7" (sql) added rlm_sql (sql): Adding client 10.23.37.8 (10.23.37.8) to global clients list rlm_sql (10.23.37.8): Client "10.23.37.8" (sql) added rlm_sql (sql): Adding client 10.23.45.8 (10.23.45.8) to global clients list rlm_sql (10.23.45.8): Client "10.23.45.8" (sql) added rlm_sql (sql): Adding client 10.23.42.15 (10.23.42.15) to global clients list rlm_sql (10.23.42.15): Client "10.23.42.15" (sql) added rlm_sql (sql): Adding client 10.23.47.6 (10.23.47.6) to global clients list rlm_sql (10.23.47.6): Client "10.23.47.6" (sql) added rlm_sql (sql): Adding client 10.23.47.7 (10.23.47.7) to global clients list rlm_sql (10.23.47.7): Client "10.23.47.7" (sql) added rlm_sql (sql): Adding client 10.23.36.15 (10.23.35.15) to global clients list rlm_sql (10.23.36.15): Client "10.23.35.15" (sql) added rlm_sql (sql): Adding client 10.23.40.7 (10.23.40.7) to global clients list rlm_sql (10.23.40.7): Client "10.23.40.7" (sql) added rlm_sql (sql): Adding client 10.23.34.5 (10.23.34.5) to global clients list rlm_sql (10.23.34.5): Client "10.23.34.5" (sql) added rlm_sql (sql): Adding client 10.23.43.13 (10.23.43.13) to global clients list rlm_sql (10.23.43.13): Client "10.23.43.13" (sql) added rlm_sql (sql): Adding client 10.23.43.10 (10.23.43.10) to global clients list rlm_sql (10.23.43.10): Client "10.23.43.10" (sql) added rlm_sql (sql): Adding client 10.23.43.11 (10.23.43.11) to global clients list rlm_sql (10.23.43.11): Client "10.23.43.11" (sql) added rlm_sql (sql): Adding client 10.23.43.12 (10.23.43.12) to global clients list rlm_sql (10.23.43.12): Client "10.23.43.12" (sql) added rlm_sql (sql): Adding client 10.23.45.9 (10.23.45.9) to global clients list rlm_sql (10.23.45.9): Client "10.23.45.9" (sql) added rlm_sql (sql): Adding client 10.23.45.10 (10.23.45.10) to global clients list rlm_sql (10.23.45.10): Client "10.23.45.10" (sql) added rlm_sql (sql): Adding client 10.23.46.11 (10.23.46.11) to global clients list rlm_sql (10.23.46.11): Client "10.23.46.11" (sql) added rlm_sql (sql): Adding client 10.23.46.12 (10.23.46.12) to global clients list rlm_sql (10.23.46.12): Client "10.23.46.12" (sql) added rlm_sql (sql): Adding client 10.23.46.13 (10.23.46.13) to global clients list rlm_sql (10.23.46.13): Client "10.23.46.13" (sql) added rlm_sql (sql): Adding client 10.23.37.11 (10.23. 37.11) to global clients list rlm_sql (10.23.37.11): Client "10.23. 37.11" (sql) added rlm_sql (sql): Adding client 10.23.37.12 (10.23.37.12) to global clients list rlm_sql (10.23.37.12): Client "10.23.37.12" (sql) added rlm_sql (sql): Adding client 10.23.52.4 (10.23.52.4) to global clients list rlm_sql (10.23.52.4): Client "10.23.52.4" (sql) added rlm_sql (sql): Adding client 10.23.52.5 (10.23.52.5) to global clients list rlm_sql (10.23.52.5): Client "10.23.52.5" (sql) added rlm_sql (sql): Adding client 10.23.52.6 (10.23.52.6) to global clients list rlm_sql (10.23.52.6): Client "10.23.52.6" (sql) added rlm_sql (sql): Adding client 10.23.52.7 (10.23.52.7) to global clients list rlm_sql (10.23.52.7): Client "10.23.52.7" (sql) added rlm_sql (sql): Adding client 10.23.52.8 (10.23.52.8) to global clients list rlm_sql (10.23.52.8): Client "10.23.52.8" (sql) added rlm_sql (sql): Adding client 10.23.52.9 (10.23.52.9) to global clients list rlm_sql (10.23.52.9): Client "10.23.52.9" (sql) added rlm_sql (sql): Adding client 10.24.220.4 (10.24.220.4) to global clients list rlm_sql (10.24.220.4): Client "10.24.220.4" (sql) added rlm_sql (sql): Adding client 10.24.220.5 (10.24.220.5) to global clients list rlm_sql (10.24.220.5): Client "10.24.220.5" (sql) added rlm_sql (sql): Adding client 10.24.220.6 (10.24.220.6) to global clients list rlm_sql (10.24.220.6): Client "10.24.220.6" (sql) added rlm_sql (sql): Adding client 10.24.220.7 ( 10.24.220.7) to global clients list rlm_sql (10.24.220.7): Client " 10.24.220.7" (sql) added rlm_sql (sql): Adding client 10.24.221.4 (10.24.221.4) to global clients list rlm_sql (10.24.221.4): Client "10.24.221.4" (sql) added rlm_sql (sql): Adding client 10.24.221.5 (10.24.221.5) to global clients list rlm_sql (10.24.221.5): Client "10.24.221.5" (sql) added rlm_sql (sql): Adding client 10.24.221.6 (10.24.221.6) to global clients list rlm_sql (10.24.221.6): Client "10.24.221.6" (sql) added rlm_sql (sql): Adding client 10.24.221.7 (10.24.221.7) to global clients list rlm_sql (10.24.221.7): Client "10.24.221.7" (sql) added rlm_sql (sql): Adding client 10.24.222.4 (10.24.222.4) to global clients list rlm_sql (10.24.222.4): Client "10.24.222.4" (sql) added rlm_sql (sql): Adding client 10.24.222.5 (10.24.222.5) to global clients list rlm_sql (10.24.222.5): Client "10.24.222.5" (sql) added rlm_sql (sql): Adding client 10.24.222.6 (10.24.222.6) to global clients list rlm_sql (10.24.222.6): Client "10.24.222.6" (sql) added rlm_sql (sql): Adding client 10.24.222.7 (10.24.222.7) to global clients list rlm_sql (10.24.222.7): Client "10.24.222.7" (sql) added rlm_sql (sql): Adding client 10.23.41.4 (10.23.41.4) to global clients list rlm_sql (10.23.41.4): Client "10.23.41.4" (sql) added rlm_sql (sql): Adding client 10.23.41.5 (10.23.41.5) to global clients list rlm_sql (10.23.41.5): Client "10.23.41.5" (sql) added rlm_sql (sql): Adding client 198.186.8.20 (198.186.8.20) to global clients list rlm_sql (198.186.8.20): Client "198.186.8.20" (sql) added rlm_sql (sql): Adding client 10.23.39.3 (10.23.39.3) to global clients list rlm_sql (10.23.39.3): Client "10.23.39.3" (sql) added rlm_sql (sql): Adding client 10.23.39.6 (10.23.39.6) to global clients list rlm_sql (10.23.39.6): Client "10.23.39.6" (sql) added rlm_sql (sql): Adding client 10.24.230.4 (10.24.230.4) to global clients list rlm_sql (10.24.230.4): Client "10.24.230.4" (sql) added rlm_sql (sql): Adding client 10.24.230.5 (10.24.230.5) to global clients list rlm_sql (10.24.230.5): Client "10.24.230.5" (sql) added rlm_sql (sql): Adding client 10.24.230.6 (10.24.230.6) to global clients list rlm_sql (10.24.230.6): Client "10.24.230.6" (sql) added rlm_sql (sql): Adding client 10.24.230.7 (10.24.230.7) to global clients list rlm_sql (10.24.230.7): Client "10.24.230.7" (sql) added rlm_sql (sql): Adding client 10.24.221.8 (10.24.221.8) to global clients list rlm_sql (10.24.221.8): Client "10.24.221.8" (sql) added rlm_sql (sql): Adding client 10.24.221.9 (10.24.221.9) to global clients list rlm_sql (10.24.221.9): Client "10.24.221.9" (sql) added rlm_sql (sql): Adding client 10.24.221.10 (10.24.221.10) to global clients list rlm_sql (10.24.221.10): Client "10.24.221.10" (sql) added rlm_sql (sql): Released connection (0) Need 5 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 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, protocol version 10   # Instantiating module "perl" from file /usr/local/billmax/freeradius/etc/raddb/mods-enabled/perl     config {         DATACALL {             STATUS = on             EDGEURL = https://localhost:1800             APPSESSIONID = 6D293C4B72708129040DC586EF9A88C3             CUTDOMAIN = 0             RADIUSMASK = 0             CAFILE = /usr/local/billmax/local/edge.pem         }         HOTSPOT {             STATUS = on             DBHOST = localhost             SCHEMA = datacall             DATABASE = billmax             USERNAME = billmax             PASSWORD = Ns3B@#d         }     }  } # modules radiusd: #### Loading Virtual Servers #### server { # from file /usr/local/billmax/freeradius/etc/raddb/radiusd.conf } # server server inner-tunnel { # from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/inner-tunnel  # Loading authenticate {...}  # Loading authorize {...} Ignoring "ldap" (see raddb/mods-available/README.rst)  # Loading session {...}  # Loading post-proxy {...}  # Loading post-auth {...}  # Skipping contents of 'if' as it is always 'false' -- /usr/local/billmax/freeradius/etc/raddb/sites-enabled/inner-tunnel:330 } # server inner-tunnel server default { # from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default  # Loading authenticate {...}  # Loading authorize {...}  # Loading preacct {...}  # Loading accounting {...}  # Loading session {...}  # Loading post-proxy {...}  # Loading post-auth {...} } # server default radiusd: #### Opening IP addresses and Ports #### listen {         type = "auth"         ipaddr = 127.0.0.1         port = 18120 } listen {         type = "auth"         ipaddr = *         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"         ipv6addr = ::         port = 0    limit {         max_connections = 16         lifetime = 0         idle_timeout = 30    } } listen {         type = "acct"         ipv6addr = ::         port = 0    limit {         max_connections = 16         lifetime = 0         idle_timeout = 30    } } Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on proxy address * port 58707 Listening on proxy address :: port 51036 Ready to process requests (0) Received Access-Request Id 0 from 10.23.41.5:1229 to 192.168.168.54:1812 length 109 (0)   Calling-Station-Id = "0A-00-3E-46-88-97" (0)   User-Name = "anonymous" (0)   NAS-IP-Address = 10.23.41.5 (0)   NAS-Port = 5 (0)   NAS-Port-Type = Wireless-Other (0)   Framed-MTU = 1020 (0)   EAP-Message = 0x0201000f01616e6f6e796d6f757300 (0)   Message-Authenticator = 0xa222b7ca1235c3aafc78f0d2a948d560 (0) # Executing section authorize from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (0)   authorize { (0)     policy filter_username { (0)       if (&User-Name) { (0)       if (&User-Name)  -> TRUE (0)       if (&User-Name)  { (0)         if (&User-Name =~ / /) { (0)         if (&User-Name =~ / /)  -> FALSE (0)         if (&User-Name =~ /@[^@]*@/ ) { (0)         if (&User-Name =~ /@[^@]*@/ )  -> FALSE (0)         if (&User-Name =~ /\.\./ ) { (0)         if (&User-Name =~ /\.\./ )  -> FALSE (0)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))  { (0)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))   -> FALSE (0)         if (&User-Name =~ /\.$/)  { (0)         if (&User-Name =~ /\.$/)   -> FALSE (0)         if (&User-Name =~ /@\./)  { (0)         if (&User-Name =~ /@\./)   -> FALSE (0)       } # if (&User-Name)  = notfound (0)     } # policy filter_username = notfound (0)     [preprocess] = ok (0)     [chap] = noop (0)     [mschap] = noop (0)     [digest] = noop (0) suffix: Checking for suffix after "@" (0) suffix: No '@' in User-Name = "anonymous", looking up realm NULL (0) suffix: No such realm "NULL" (0)     [suffix] = noop (0) eap: Peer sent EAP Response (code 2) ID 1 length 15 (0) eap: EAP-Identity reply, returning 'ok' so we can short-circuit the rest of authorize (0)     [eap] = ok (0)   } # authorize = ok (0) Found Auth-Type = eap (0) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (0)   authenticate { (0) eap: Peer sent packet with method EAP Identity (1) (0) eap: Calling submodule eap_md5 to process data (0) eap_md5: Issuing MD5 Challenge (0) eap: Sending EAP Request (code 1) ID 2 length 22 (0) eap: EAP session adding &reply:State = 0x7b4fbfd07b4dbbd3 (0)     [eap] = handled (0)   } # authenticate = handled (0) Using Post-Auth-Type Challenge (0) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (0)   Challenge { ... } # empty sub-section is ignored (0) Sent Access-Challenge Id 0 from 192.168.168.54:1812 to 10.23.41.5:1229 length 0 (0)   EAP-Message = 0x010200160410169d940c576faa19bc90259f5669de89 (0)   Message-Authenticator = 0x00000000000000000000000000000000 (0)   State = 0x7b4fbfd07b4dbbd3ebe3f38a2d992241 (0) Finished request Waking up in 4.9 seconds. (0) Cleaning up request packet ID 0 with timestamp +377 (1) Received Access-Request Id 0 from 10.23.41.5:1229 to 192.168.168.54:1812 length 118 (1)   Calling-Station-Id = "0A-00-3E-46-88-97" (1)   User-Name = "anonymous" (1)   State = 0x7b4fbfd07b4dbbd3ebe3f38a2d992241 (1)   NAS-IP-Address = 10.23.41.5 (1)   NAS-Port = 5 (1)   NAS-Port-Type = Wireless-Other (1)   Framed-MTU = 1020 (1)   EAP-Message = 0x020200060315 (1)   Message-Authenticator = 0xeeb9642678158fe0c9e9eb171a935637 (1) session-state: No cached attributes (1) # Executing section authorize from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (1)   authorize { (1)     policy filter_username { (1)       if (&User-Name) { (1)       if (&User-Name)  -> TRUE (1)       if (&User-Name)  { (1)         if (&User-Name =~ / /) { (1)         if (&User-Name =~ / /)  -> FALSE (1)         if (&User-Name =~ /@[^@]*@/ ) { (1)         if (&User-Name =~ /@[^@]*@/ )  -> FALSE (1)         if (&User-Name =~ /\.\./ ) { (1)         if (&User-Name =~ /\.\./ )  -> FALSE (1)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))  { (1)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))   -> FALSE (1)         if (&User-Name =~ /\.$/)  { (1)         if (&User-Name =~ /\.$/)   -> FALSE (1)         if (&User-Name =~ /@\./)  { (1)         if (&User-Name =~ /@\./)   -> FALSE (1)       } # if (&User-Name)  = notfound (1)     } # policy filter_username = notfound (1)     [preprocess] = ok (1)     [chap] = noop (1)     [mschap] = noop (1)     [digest] = noop (1) suffix: Checking for suffix after "@" (1) suffix: No '@' in User-Name = "anonymous", looking up realm NULL (1) suffix: No such realm "NULL" (1)     [suffix] = noop (1) eap: Peer sent EAP Response (code 2) ID 2 length 6 (1) eap: No EAP Start, assuming it's an on-going EAP conversation (1)     [eap] = updated (1)     [files] = noop (1) sql: EXPAND %{User-Name} (1) sql:    --> anonymous (1) sql: SQL-User-Name set to 'anonymous' rlm_sql (sql): Closing connection (1): Hit idle_timeout, was idle for 377 seconds rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing connection (2): Hit idle_timeout, was idle for 377 seconds rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing connection (3): Hit idle_timeout, was idle for 377 seconds rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing connection (4): Hit idle_timeout, was idle for 377 seconds rlm_sql (sql): You probably need to lower "min" rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing connection (0): Hit idle_timeout, was idle for 377 seconds rlm_sql (sql): You probably need to lower "min" rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): Closing connection (5): Hit idle_timeout, was idle for 377 seconds rlm_sql (sql): You probably need to lower "min" rlm_sql_mysql: Socket destructor called, closing socket rlm_sql (sql): 0 of 0 connections in use.  You  may need to increase "spare" rlm_sql (sql): Opening additional connection (6), 1 of 32 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, protocol version 10 rlm_sql (sql): Reserved connection (6) (1) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (1) sql:    --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'anonymous' ORDER BY id (1) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'anonymous' ORDER BY id (1) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (1) sql:    --> SELECT groupname FROM radusergroup WHERE username = 'anonymous' ORDER BY priority (1) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'anonymous' ORDER BY priority (1) sql: User not found in any groups rlm_sql (sql): Released connection (6) Need 2 more connections to reach min connections (3) rlm_sql (sql): Opening additional connection (7), 1 of 31 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'billmax' on Localhost via UNIX socket, server version 5.5.60-MariaDB, protocol version 10 (1)     [sql] = notfound (1)     [expiration] = noop (1)     [logintime] = noop (1) pap: WARNING: No "known good" password found for the user. Not setting Auth-Type (1) pap: WARNING: Authentication will fail unless a "known good" password is available (1)     [pap] = noop (1)   } # authorize = updated (1) Found Auth-Type = eap (1) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (1)   authenticate { (1) eap: Expiring EAP session with state 0x7b4fbfd07b4dbbd3 (1) eap: Finished EAP session with state 0x7b4fbfd07b4dbbd3 (1) eap: Previous EAP request found for state 0x7b4fbfd07b4dbbd3, released from the list (1) eap: Peer sent packet with method EAP NAK (3) (1) eap: Found mutually acceptable type TTLS (21) (1) eap: Calling submodule eap_ttls to process data (1) eap_ttls: Initiating new EAP-TLS session (1) eap_ttls: Flushing SSL sessions (of #0) (1) eap_ttls: [eaptls start] = request (1) eap: Sending EAP Request (code 1) ID 3 length 6 (1) eap: EAP session adding &reply:State = 0x7b4fbfd07a4caad3 (1)     [eap] = handled (1)   } # authenticate = handled (1) Using Post-Auth-Type Challenge (1) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (1)   Challenge { ... } # empty sub-section is ignored (1) Sent Access-Challenge Id 0 from 192.168.168.54:1812 to 10.23.41.5:1229 length 0 (1)   EAP-Message = 0x010300061520 (1)   Message-Authenticator = 0x00000000000000000000000000000000 (1)   State = 0x7b4fbfd07a4caad3ebe3f38a2d992241 (1) Finished request Waking up in 4.9 seconds. (1) Cleaning up request packet ID 0 with timestamp +377 (2) Received Access-Request Id 0 from 10.23.41.5:1229 to 192.168.168.54:1812 length 180 (2)   Calling-Station-Id = "0A-00-3E-46-88-97" (2)   User-Name = "anonymous" (2)   State = 0x7b4fbfd07a4caad3ebe3f38a2d992241 (2)   NAS-IP-Address = 10.23.41.5 (2)   NAS-Port = 5 (2)   NAS-Port-Type = Wireless-Other (2)   Framed-MTU = 1020 (2)   EAP-Message = 0x0203004415800000003a160301003501000031030152868bc2173ed9c5078807500f25fc266daea69a64e124993f810654577f185f00000a0035002f00040005000a0100 (2)   Message-Authenticator = 0x2ed1d3f07836fd779851b6d77832ab41 (2) session-state: No cached attributes (2) # Executing section authorize from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (2)   authorize { (2)     policy filter_username { (2)       if (&User-Name) { (2)       if (&User-Name)  -> TRUE (2)       if (&User-Name)  { (2)         if (&User-Name =~ / /) { (2)         if (&User-Name =~ / /)  -> FALSE (2)         if (&User-Name =~ /@[^@]*@/ ) { (2)         if (&User-Name =~ /@[^@]*@/ )  -> FALSE (2)         if (&User-Name =~ /\.\./ ) { (2)         if (&User-Name =~ /\.\./ )  -> FALSE (2)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))  { (2)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))   -> FALSE (2)         if (&User-Name =~ /\.$/)  { (2)         if (&User-Name =~ /\.$/)   -> FALSE (2)         if (&User-Name =~ /@\./)  { (2)         if (&User-Name =~ /@\./)   -> FALSE (2)       } # if (&User-Name)  = notfound (2)     } # policy filter_username = notfound (2)     [preprocess] = ok (2)     [chap] = noop (2)     [mschap] = noop (2)     [digest] = noop (2) suffix: Checking for suffix after "@" (2) suffix: No '@' in User-Name = "anonymous", looking up realm NULL (2) suffix: No such realm "NULL" (2)     [suffix] = noop (2) eap: Peer sent EAP Response (code 2) ID 3 length 68 (2) eap: Continuing tunnel setup (2)     [eap] = ok (2)   } # authorize = ok (2) Found Auth-Type = eap (2) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (2)   authenticate { (2) eap: Expiring EAP session with state 0x7b4fbfd07a4caad3 (2) eap: Finished EAP session with state 0x7b4fbfd07a4caad3 (2) eap: Previous EAP request found for state 0x7b4fbfd07a4caad3, released from the list (2) eap: Peer sent packet with method EAP TTLS (21) (2) eap: Calling submodule eap_ttls to process data (2) eap_ttls: Authenticate (2) eap_ttls: Continuing EAP-TLS (2) eap_ttls: Peer indicated complete TLS record size will be 58 bytes (2) eap_ttls: Got complete TLS record (58 bytes) (2) eap_ttls: [eaptls verify] = length included (2) eap_ttls: (other): before/accept initialization (2) eap_ttls: TLS_accept: before/accept initialization (2) eap_ttls: <<< recv TLS 1.0 Handshake [length 0035], ClientHello (2) eap_ttls: TLS_accept: SSLv3 read client hello A (2) eap_ttls: >>> send TLS 1.0 Handshake [length 004a], ServerHello (2) eap_ttls: TLS_accept: SSLv3 write server hello A (2) eap_ttls: >>> send TLS 1.0 Handshake [length 08d3], Certificate (2) eap_ttls: TLS_accept: SSLv3 write certificate A (2) eap_ttls: >>> send TLS 1.0 Handshake [length 0004], ServerHelloDone (2) eap_ttls: TLS_accept: SSLv3 write server done A (2) eap_ttls: TLS_accept: SSLv3 flush data (2) eap_ttls: TLS_accept: SSLv3 read client certificate A (2) eap_ttls: TLS_accept: Need to read more data: SSLv3 read client key exchange A (2) eap_ttls: TLS_accept: Need to read more data: SSLv3 read client key exchange A (2) eap_ttls: In SSL Handshake Phase (2) eap_ttls: In SSL Accept mode (2) eap_ttls: [eaptls process] = handled (2) eap: Sending EAP Request (code 1) ID 4 length 1004 (2) eap: EAP session adding &reply:State = 0x7b4fbfd0794baad3 (2)     [eap] = handled (2)   } # authenticate = handled (2) Using Post-Auth-Type Challenge (2) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (2)   Challenge { ... } # empty sub-section is ignored (2) Sent Access-Challenge Id 0 from 192.168.168.54:1812 to 10.23.41.5:1229 length 0 (2)   EAP-Message = 0x010403ec15c000000930160301004a0200004603017f19aeaa14db509af9e653fe53d5357b995fbc6b398a48bd77e4c53f582c4188205f1fc14b60daceb7e25e784306a766aed538cdfb1e221bf6d00fabde15a81d6700350016030108d30b0008cf0008cc0003de308203da308202c2a0030201020201 (2)   Message-Authenticator = 0x00000000000000000000000000000000 (2)   State = 0x7b4fbfd0794baad3ebe3f38a2d992241 (2) Finished request Waking up in 4.9 seconds. (2) Cleaning up request packet ID 0 with timestamp +377 (3) Received Access-Request Id 0 from 10.23.41.5:1229 to 192.168.168.54:1812 length 118 (3)   Calling-Station-Id = "0A-00-3E-46-88-97" (3)   User-Name = "anonymous" (3)   State = 0x7b4fbfd0794baad3ebe3f38a2d992241 (3)   NAS-IP-Address = 10.23.41.5 (3)   NAS-Port = 5 (3)   NAS-Port-Type = Wireless-Other (3)   Framed-MTU = 1020 (3)   EAP-Message = 0x020400061500 (3)   Message-Authenticator = 0x2dfb057dcd638012e60e9282716e1dbd (3) session-state: No cached attributes (3) # Executing section authorize from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (3)   authorize { (3)     policy filter_username { (3)       if (&User-Name) { (3)       if (&User-Name)  -> TRUE (3)       if (&User-Name)  { (3)         if (&User-Name =~ / /) { (3)         if (&User-Name =~ / /)  -> FALSE (3)         if (&User-Name =~ /@[^@]*@/ ) { (3)         if (&User-Name =~ /@[^@]*@/ )  -> FALSE (3)         if (&User-Name =~ /\.\./ ) { (3)         if (&User-Name =~ /\.\./ )  -> FALSE (3)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))  { (3)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))   -> FALSE (3)         if (&User-Name =~ /\.$/)  { (3)         if (&User-Name =~ /\.$/)   -> FALSE (3)         if (&User-Name =~ /@\./)  { (3)         if (&User-Name =~ /@\./)   -> FALSE (3)       } # if (&User-Name)  = notfound (3)     } # policy filter_username = notfound (3)     [preprocess] = ok (3)     [chap] = noop (3)     [mschap] = noop (3)     [digest] = noop (3) suffix: Checking for suffix after "@" (3) suffix: No '@' in User-Name = "anonymous", looking up realm NULL (3) suffix: No such realm "NULL" (3)     [suffix] = noop (3) eap: Peer sent EAP Response (code 2) ID 4 length 6 (3) eap: Continuing tunnel setup (3)     [eap] = ok (3)   } # authorize = ok (3) Found Auth-Type = eap (3) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (3)   authenticate { (3) eap: Expiring EAP session with state 0x7b4fbfd0794baad3 (3) eap: Finished EAP session with state 0x7b4fbfd0794baad3 (3) eap: Previous EAP request found for state 0x7b4fbfd0794baad3, released from the list (3) eap: Peer sent packet with method EAP TTLS (21) (3) eap: Calling submodule eap_ttls to process data (3) eap_ttls: Authenticate (3) eap_ttls: Continuing EAP-TLS (3) eap_ttls: Peer ACKed our handshake fragment (3) eap_ttls: [eaptls verify] = request (3) eap_ttls: [eaptls process] = handled (3) eap: Sending EAP Request (code 1) ID 5 length 1004 (3) eap: EAP session adding &reply:State = 0x7b4fbfd0784aaad3 (3)     [eap] = handled (3)   } # authenticate = handled (3) Using Post-Auth-Type Challenge (3) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (3)   Challenge { ... } # empty sub-section is ignored (3) Sent Access-Challenge Id 0 from 192.168.168.54:1812 to 10.23.41.5:1229 length 0 (3)   EAP-Message = 0x010503ec15c000000930777b1db6b158b012e3b74701c05f2a04dacb11fc921c975033090ec2dffda16a412617d302134359fa690a666e0c939d83ebe06fa9c1983e28e4fa050f391fb298a6d33a45bc3ebeb0bb03926fff9d1449733007f964bfef34180004e8308204e4308203cca003020102020900 (3)   Message-Authenticator = 0x00000000000000000000000000000000 (3)   State = 0x7b4fbfd0784aaad3ebe3f38a2d992241 (3) Finished request Waking up in 4.9 seconds. (3) Cleaning up request packet ID 0 with timestamp +377 (4) Received Access-Request Id 0 from 10.23.41.5:1229 to 192.168.168.54:1812 length 118 (4)   Calling-Station-Id = "0A-00-3E-46-88-97" (4)   User-Name = "anonymous" (4)   State = 0x7b4fbfd0784aaad3ebe3f38a2d992241 (4)   NAS-IP-Address = 10.23.41.5 (4)   NAS-Port = 5 (4)   NAS-Port-Type = Wireless-Other (4)   Framed-MTU = 1020 (4)   EAP-Message = 0x020500061500 (4)   Message-Authenticator = 0xf7016deaf0711e1e4e70371170027e6c (4) session-state: No cached attributes (4) # Executing section authorize from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (4)   authorize { (4)     policy filter_username { (4)       if (&User-Name) { (4)       if (&User-Name)  -> TRUE (4)       if (&User-Name)  { (4)         if (&User-Name =~ / /) { (4)         if (&User-Name =~ / /)  -> FALSE (4)         if (&User-Name =~ /@[^@]*@/ ) { (4)         if (&User-Name =~ /@[^@]*@/ )  -> FALSE (4)         if (&User-Name =~ /\.\./ ) { (4)         if (&User-Name =~ /\.\./ )  -> FALSE (4)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))  { (4)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))   -> FALSE (4)         if (&User-Name =~ /\.$/)  { (4)         if (&User-Name =~ /\.$/)   -> FALSE (4)         if (&User-Name =~ /@\./)  { (4)         if (&User-Name =~ /@\./)   -> FALSE (4)       } # if (&User-Name)  = notfound (4)     } # policy filter_username = notfound (4)     [preprocess] = ok (4)     [chap] = noop (4)     [mschap] = noop (4)     [digest] = noop (4) suffix: Checking for suffix after "@" (4) suffix: No '@' in User-Name = "anonymous", looking up realm NULL (4) suffix: No such realm "NULL" (4)     [suffix] = noop (4) eap: Peer sent EAP Response (code 2) ID 5 length 6 (4) eap: Continuing tunnel setup (4)     [eap] = ok (4)   } # authorize = ok (4) Found Auth-Type = eap (4) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (4)   authenticate { (4) eap: Expiring EAP session with state 0x7b4fbfd0784aaad3 (4) eap: Finished EAP session with state 0x7b4fbfd0784aaad3 (4) eap: Previous EAP request found for state 0x7b4fbfd0784aaad3, released from the list (4) eap: Peer sent packet with method EAP TTLS (21) (4) eap: Calling submodule eap_ttls to process data (4) eap_ttls: Authenticate (4) eap_ttls: Continuing EAP-TLS (4) eap_ttls: Peer ACKed our handshake fragment (4) eap_ttls: [eaptls verify] = request (4) eap_ttls: [eaptls process] = handled (4) eap: Sending EAP Request (code 1) ID 6 length 374 (4) eap: EAP session adding &reply:State = 0x7b4fbfd07f49aad3 (4)     [eap] = handled (4)   } # authenticate = handled (4) Using Post-Auth-Type Challenge (4) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (4)   Challenge { ... } # empty sub-section is ignored (4) Sent Access-Challenge Id 0 from 192.168.168.54:1812 to 10.23.41.5:1229 length 0 (4)   EAP-Message = 0x01060176158000000930368e33ec2eb7300f0603551d130101ff040530030101ff30360603551d1f042f302d302ba029a0278625687474703a2f2f7777772e6578616d706c652e6f72672f6578616d706c655f63612e63726c300d06092a864886f70d01010505000382010100418cd9ac4e4ca726957b (4)   Message-Authenticator = 0x00000000000000000000000000000000 (4)   State = 0x7b4fbfd07f49aad3ebe3f38a2d992241 (4) Finished request Waking up in 4.9 seconds. (4) Cleaning up request packet ID 0 with timestamp +377 Ready to process requests (5) Received Access-Request Id 0 from 10.23.41.5:1229 to 192.168.168.54:1812 length 117 (5)   Calling-Station-Id = "0A-00-3E-46-88-97" (5)   User-Name = "anonymous" (5)   State = 0x7b4fbfd07f49aad3ebe3f38a2d992241 (5)   NAS-IP-Address = 10.23.41.5 (5)   NAS-Port = 5 (5)   NAS-Port-Type = Wireless-Other (5)   Framed-MTU = 1020 (5)   EAP-Message = 0x0206000515 (5)   Message-Authenticator = 0xbef01c6492205d08dd6ac963059196fa (5) session-state: No cached attributes (5) # Executing section authorize from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (5)   authorize { (5)     policy filter_username { (5)       if (&User-Name) { (5)       if (&User-Name)  -> TRUE (5)       if (&User-Name)  { (5)         if (&User-Name =~ / /) { (5)         if (&User-Name =~ / /)  -> FALSE (5)         if (&User-Name =~ /@[^@]*@/ ) { (5)         if (&User-Name =~ /@[^@]*@/ )  -> FALSE (5)         if (&User-Name =~ /\.\./ ) { (5)         if (&User-Name =~ /\.\./ )  -> FALSE (5)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))  { (5)         if ((&User-Name =~ /@/) && (&User-Name !~ /@(.+)\.(.+)$/))   -> FALSE (5)         if (&User-Name =~ /\.$/)  { (5)         if (&User-Name =~ /\.$/)   -> FALSE (5)         if (&User-Name =~ /@\./)  { (5)         if (&User-Name =~ /@\./)   -> FALSE (5)       } # if (&User-Name)  = notfound (5)     } # policy filter_username = notfound (5)     [preprocess] = ok (5)     [chap] = noop (5)     [mschap] = noop (5)     [digest] = noop (5) suffix: Checking for suffix after "@" (5) suffix: No '@' in User-Name = "anonymous", looking up realm NULL (5) suffix: No such realm "NULL" (5)     [suffix] = noop (5) eap: Peer sent EAP Response (code 2) ID 6 length 5 (5) eap: Continuing tunnel setup (5)     [eap] = ok (5)   } # authorize = ok (5) Found Auth-Type = eap (5) # Executing group from file /usr/local/billmax/freeradius/etc/raddb/sites-enabled/default (5)   authenticate { (5) eap: Expiring EAP session with state 0x7b4fbfd07f49aad3 (5) eap: Finished EAP session with state 0x7b4fbfd07f49aad3 (5) eap: Previous EAP request found for state 0x7b4fbfd07f49aad3, released from the list (5) eap: Peer sent packet with method EAP TTLS (21) (5) eap: Calling submodule eap_ttls to process data (5) eap_ttls: Authenticate (5) eap_ttls: Continuing EAP-TLS Segmentation fault