January 2024 - Freeradius-Users - lists.freeradius.org

unsubscribe
by Stefan Kania 10 Jan '24

10 Jan '24

unsubscribe

2 1

Users in SQL not accepted, AD works.
by it＠wehle.dev 09 Jan '24

09 Jan '24

Hi *, we have a (working) FreeRadius 3.2.3 instance which is connected to our AD through ntlm_auth (but also fetches some additional fields from LDAP). Not sure if this is intended the way we built it, but it worked so far. We now wanted to add SQL (to allow temporary users). For that, we followed the official guide (SQL-HOWTO-for-freeradius-3.x-on-Debian-Ubuntu). This works well when testing with NTRadPing but fails when connecting a device (in this case, a Windows 10 PC). If we correctly understood the guide, this should work pretty much out of the box; still, we neitzer can get it to work nor do we fully understand what is actually causing this behaviour. Is this an issue with MSCHAP? If so, how do we fix it? We attached both, our sites-enabled/default file and the debug output of the server while connecting a client with credentials stored in SQL. I can also provide the log of a client connecting with credentials stored in the AD if that helps. Thank you very much. Best Regards Sebastian # *** sites-enabled/default *** client school_8021x { ipaddr = 0.0.0.0/0 secret = <<< secret >>> virtual_server = school_8021x } server school_8021x { listen { ipaddr = 0.0.0.0 port = 1812 type = auth } authorize { filter_username preprocess digest suffix chap sql mschap eap { ok = return } ldap if (&LDAP-Group[*] == "CN=student,OU=Groups,OU=GLOBAL,DC=etc,DC=etc") { if (&LDAP-Group[*] == "CN=staff,OU=staff,OU=Students,OU=etc,DC=etc,DC=etc") { } else { update control { Login-Time = 'Wk0700-1900' } } } #daily expiration logintime pap } authenticate { Auth-Type PAP { pap } Auth-Type CHAP { chap } Auth-Type MS-CHAP { mschap } Auth-Type ntlm_auth { ntlm_auth } digest # Auth-Type LDAP { # ldap # } eap } preacct { preprocess acct_unique suffix # ntdomain # files } accounting { #detail #daily unix radutmp sradutmp sql exec attr_filter.accounting_response } post-auth { #{ update { User-Name := &session-state:User-Name } get_user_role if (&session-state:User-Name == "cisco-wlan-ap") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 5 Tunnel-Type:= VLAN Egress-VLANID += "%{expr: 0x31000000 + 10}" Egress-VLANID += "%{expr: 0x31000000 + 11}" Egress-VLANID += "%{expr: 0x31000000 + 12}" Egress-VLANID += "%{expr: 0x31000000 + 24}" Egress-VLANID += "%{expr: 0x31000000 + 31}" Egress-VLANID += "%{expr: 0x31000000 + 33}" } } else { if (UserRole == "staff") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 13 Tunnel-Type:= VLAN } } elsif (&reply:UserRole == "staff") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 13 Tunnel-Type:= VLAN } } elsif (UserRole == "ipad") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 13 Tunnel-Type:= VLAN } } elsif (&reply:UserRole == "ipad") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 13 Tunnel-Type:= VLAN } } elsif (&reply:UserRole == "student") { if (&reply:UserCustomRole == "staff") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 13 Tunnel-Type:= VLAN } } elsif (&reply:UserCustomRole == "ipad") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 13 Tunnel-Type:= VLAN } } else { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 12 Tunnel-Type:= VLAN } } } elsif (&reply:UserRole == "teacher" || UserRole == "teacher") { update reply { Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-ID:= 10 Tunnel-Type:= VLAN } } } update reply { &UserRole !* ANY } if (session-state:User-Name && reply:User-Name && request:User-Name && (reply:User-Name == request:User-Name)) { update reply { &User-Name !* ANY } } update { &reply: += &session-state: } #} exec remove_reply_message_if_eap Post-Auth-Type REJECT { attr_filter.access_reject eap remove_reply_message_if_eap } Post-Auth-Type Challenge { } } post-proxy { eap } session { radutmp } } # *** Full debug output *** FreeRADIUS Version 3.2.3 Copyright (C) 1999-2022 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/freeradius/dictionary including configuration file /etc/freeradius/radiusd.conf including configuration file /etc/freeradius/proxy.conf including configuration file /etc/freeradius/clients.conf including files in directory /etc/freeradius/mods-enabled/ including configuration file /etc/freeradius/mods-enabled/logintime including configuration file /etc/freeradius/mods-enabled/chap including configuration file /etc/freeradius/mods-enabled/realm including configuration file /etc/freeradius/mods-enabled/dynamic_clients including configuration file /etc/freeradius/mods-enabled/expr including configuration file /etc/freeradius/mods-enabled/unpack including configuration file /etc/freeradius/mods-enabled/cache_eap including configuration file /etc/freeradius/mods-enabled/always including configuration file /etc/freeradius/mods-enabled/linelog including configuration file /etc/freeradius/mods-enabled/totp including configuration file /etc/freeradius/mods-enabled/exec including configuration file /etc/freeradius/mods-enabled/preprocess including configuration file /etc/freeradius/mods-enabled/date including configuration file /etc/freeradius/mods-enabled/files including configuration file /etc/freeradius/mods-enabled/sql including configuration file /etc/freeradius/mods-config/sql/main/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/pap including configuration file /etc/freeradius/mods-enabled/unix including configuration file /etc/freeradius/mods-enabled/radutmp including configuration file /etc/freeradius/mods-enabled/digest including configuration file /etc/freeradius/mods-enabled/eap including configuration file /etc/freeradius/mods-enabled/replicate including configuration file /etc/freeradius/mods-enabled/ldap including configuration file /etc/freeradius/mods-enabled/passwd including configuration file /etc/freeradius/mods-enabled/ntlm_auth including configuration file /etc/freeradius/mods-enabled/expiration including configuration file /etc/freeradius/mods-enabled/counter including configuration file /etc/freeradius/mods-enabled/attr_filter including configuration file /etc/freeradius/mods-enabled/sradutmp including configuration file /etc/freeradius/mods-enabled/mschap including configuration file /etc/freeradius/mods-enabled/detail including configuration file /etc/freeradius/mods-enabled/utf8 including configuration file /etc/freeradius/mods-enabled/echo including configuration file /etc/freeradius/mods-enabled/detail.log including configuration file /etc/freeradius/mods-enabled/soh including files in directory /etc/freeradius/policy.d/ including configuration file /etc/freeradius/policy.d/dhcp including configuration file /etc/freeradius/policy.d/canonicalization including configuration file /etc/freeradius/policy.d/control including configuration file /etc/freeradius/policy.d/filter including configuration file /etc/freeradius/policy.d/cui including configuration file /etc/freeradius/policy.d/eap including configuration file /etc/freeradius/policy.d/rfc7542 including configuration file /etc/freeradius/policy.d/moonshot-targeted-ids including configuration file /etc/freeradius/policy.d/abfab-tr including configuration file /etc/freeradius/policy.d/operator-name including configuration file /etc/freeradius/policy.d/group_check including configuration file /etc/freeradius/policy.d/debug including configuration file /etc/freeradius/policy.d/accounting including files in directory /etc/freeradius/sites-enabled/ including configuration file /etc/freeradius/sites-enabled/status including configuration file /etc/freeradius/sites-enabled/school_8021x including configuration file /etc/freeradius/sites-enabled/inner-tunnel main { security { user = "freerad" group = "freerad" allow_core_dumps = no } name = "freeradius" prefix = "/usr" localstatedir = "/var" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" } main { name = "freeradius" prefix = "/usr" localstatedir = "/var" sbindir = "/usr/sbin" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/freeradius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 16384 postauth_client_lost = no pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = yes auth_badpass = no auth_goodpass = no msg_badpass = " (%{Calling-Station-ID})" msg_goodpass = " (%{Calling-Station-ID})" colourise = yes msg_denied = "You are already logged in - access denied" } resources { } security { max_attributes = 200 reject_delay = 1.000000 status_server = 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 { nonblock = no 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 } recv_coa { } } realm NULL { } realm LOCAL { } realm domain.tld { } realm DEFAULT { nostrip } home_server_pool my_auth_failover { type = fail-over home_server = localhost } 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 } } client school_8021x { ipaddr = 0.0.0.0/0 require_message_authenticator = no secret = <<< secret >>> virtual_server = "school_8021x" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Debugger not attached systemd watchdog is disabled # Creating Autz-Type = Status-Server # Creating Auth-Type = digest # Creating Auth-Type = eap # Creating Auth-Type = PAP # Creating Auth-Type = CHAP # Creating Auth-Type = MS-CHAP # Creating Auth-Type = ntlm_auth # Creating Auth-Type = linelog # Creating Auth-Type = mschap /etc/freeradius/sites-enabled/inner-tunnel[205]: Duplicate module 'linelog' radiusd: #### Instantiating modules #### modules { # Loaded module rlm_logintime # Loading module "logintime" from file /etc/freeradius/mods-enabled/logintime logintime { minimum_timeout = 60 } # Loaded module rlm_chap # Loading module "chap" from file /etc/freeradius/mods-enabled/chap # Loaded module rlm_realm # Loading module "IPASS" from file /etc/freeradius/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/freeradius/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "bangpath" from file /etc/freeradius/mods-enabled/realm realm bangpath { format = "prefix" delimiter = "!" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/freeradius/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/freeradius/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/freeradius/mods-enabled/dynamic_clients # Loaded module rlm_expr # Loading module "expr" from file /etc/freeradius/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_unpack # Loading module "unpack" from file /etc/freeradius/mods-enabled/unpack # Loaded module rlm_cache # Loading module "cache_eap" from file /etc/freeradius/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_always # Loading module "reject" from file /etc/freeradius/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/freeradius/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/freeradius/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/freeradius/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/freeradius/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/freeradius/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/freeradius/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/freeradius/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/freeradius/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Loaded module rlm_linelog # Loading module "linelog" from file /etc/freeradius/mods-enabled/linelog linelog { filename = "/var/log/freeradius/linelog" escape_filenames = no syslog_severity = "info" permissions = 384 format = "Login attempt for %{User-Name}" reference = "messages.%{%{Packet-Type}:-default}" } # Loading module "log_accounting" from file /etc/freeradius/mods-enabled/linelog linelog log_accounting { filename = "/var/log/freeradius/linelog-accounting" escape_filenames = no syslog_severity = "info" permissions = 384 format = "" reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}" } # Loaded module rlm_totp # Loading module "totp" from file /etc/freeradius/mods-enabled/totp # Loaded module rlm_exec # Loading module "exec" from file /etc/freeradius/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_preprocess # Loading module "preprocess" from file /etc/freeradius/mods-enabled/preprocess preprocess { huntgroups = "/etc/freeradius/mods-config/preprocess/huntgroups" hints = "/etc/freeradius/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_date # Loading module "date" from file /etc/freeradius/mods-enabled/date date { format = "%b %e %Y %H:%M:%S %Z" utc = no } # Loading module "wispr2date" from file /etc/freeradius/mods-enabled/date date wispr2date { format = "%Y-%m-%dT%H:%M:%S" utc = no } # Loaded module rlm_files # Loading module "files" from file /etc/freeradius/mods-enabled/files files { filename = "/etc/freeradius/mods-config/files/authorize" acctusersfile = "/etc/freeradius/mods-config/files/accounting" preproxy_usersfile = "/etc/freeradius/mods-config/files/pre-proxy" } # Loaded module rlm_sql # Loading module "sql" from file /etc/freeradius/mods-enabled/sql sql { driver = "rlm_sql_mysql" server = "localhost" port = 3306 login = "radius" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}" 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 a LEFT OUTER JOIN nasreload n USING (nasipaddress) WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL AND (a.acctstarttime > n.reloadtime OR n.reloadtime IS NULL)" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct a LEFT OUTER JOIN nasreload n USING (nasipaddress) WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL AND (a.acctstarttime > n.reloadtime OR n.reloadtime IS NULL)" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = "%{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query}" 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" query = "INSERT INTO radpostauth (username, pass, reply, authdate ) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S.%M' )" } } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Creating attribute SQL-Group # Loaded module rlm_pap # Loading module "pap" from file /etc/freeradius/mods-enabled/pap pap { normalise = yes } # Loaded module rlm_unix # Loading module "unix" from file /etc/freeradius/mods-enabled/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Creating attribute Unix-Group # Loaded module rlm_radutmp # Loading module "radutmp" from file /etc/freeradius/mods-enabled/radutmp radutmp { filename = "/var/lib/freeradius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 384 caller_id = yes } # Loaded module rlm_digest # Loading module "digest" from file /etc/freeradius/mods-enabled/digest # Loaded module rlm_eap # Loading module "eap" from file /etc/freeradius/mods-enabled/eap eap { default_eap_type = "peap" timer_expire = 60 max_eap_type = 52 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loaded module rlm_replicate # Loading module "replicate" from file /etc/freeradius/mods-enabled/replicate # Loaded module rlm_ldap # Loading module "ldap" from file /etc/freeradius/mods-enabled/ldap ldap { server = "ldaps://172.16.8.200:636/" identity = "CN=radius-binduser,OU=Management,OU=etc,DC=etc" password = <<< secret >>> sasl { } user_dn = "LDAP-UserDn" user { scope = "sub" access_positive = yes sasl { } } group { filter = "(objectClass=group)" scope = "sub" name_attribute = "cn" membership_attribute = "memberOf" membership_filter = "(member=%{control:LDAP-UserDn})" cacheable_name = no cacheable_dn = no allow_dangling_group_ref = no } client { filter = "(objectClass=radiusClient)" scope = "sub" base_dn = "DC=etc" } profile { } options { ldap_debug = 40 chase_referrals = yes rebind = yes net_timeout = 1 res_timeout = 10 srv_timelimit = 3 idle = 60 probes = 3 interval = 3 } tls { check_crl = no start_tls = no } } Creating attribute LDAP-Group # Loaded module rlm_passwd # Loading module "etc_passwd" from file /etc/freeradius/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 } # Loading module "ntlm_auth" from file /etc/freeradius/mods-enabled/ntlm_auth exec ntlm_auth { wait = yes program = "/usr/bin/ntlm_auth --allow-mschapv2 --request-nt-key --domain=lmn --require-membership-of=lmn\wifi --username=%{mschap:User-Name} --password=%{User-Password}" shell_escape = yes } # Loaded module rlm_expiration # Loading module "expiration" from file /etc/freeradius/mods-enabled/expiration # Loaded module rlm_counter # Loading module "daily" from file /etc/freeradius/mods-enabled/counter counter daily { filename = "/var/lib/freeradius/db.daily" key = "User-Name" reset = "daily" count_attribute = "Acct-Session-Time" counter_name = "Daily-Session-Time" check_name = "Max-Daily-Session" reply_name = "Session-Timeout" allowed_service_type = "Framed-User" cache_size = 5000 } # Loaded module rlm_attr_filter # Loading module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/freeradius/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.pre-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/freeradius/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.access_reject" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/freeradius/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.access_challenge" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/freeradius/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.accounting_response" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/freeradius/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.coa" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.coa { filename = "/etc/freeradius/mods-config/attr_filter/coa" key = "%{User-Name}" relaxed = no } # Loading module "sradutmp" from file /etc/freeradius/mods-enabled/sradutmp radutmp sradutmp { filename = "/var/log/freeradius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loaded module rlm_mschap # Loading module "mschap" from file /etc/freeradius/mods-enabled/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = yes ntlm_auth = "/usr/bin/ntlm_auth --allow-mschapv2 --request-nt-key --domain=lmn --require-membership-of=lmn\wifi --username=%{%{Stripped-User-Name}:-%{%{User-Name}:-None}} --challenge=%{%{mschap:Challenge}:-00} --nt-response=%{%{mschap:NT-Response}:-00}" passchange { } allow_retry = yes winbind_retry_with_normalised_username = no } # Loaded module rlm_detail # Loading module "detail" from file /etc/freeradius/mods-enabled/detail detail { filename = "/var/log/freeradius/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_utf8 # Loading module "utf8" from file /etc/freeradius/mods-enabled/utf8 # Loading module "echo" from file /etc/freeradius/mods-enabled/echo exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = yes } # Loading module "auth_log" from file /etc/freeradius/mods-enabled/detail.log detail auth_log { filename = "/var/log/freeradius/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/freeradius/mods-enabled/detail.log detail reply_log { filename = "/var/log/freeradius/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/freeradius/mods-enabled/detail.log detail pre_proxy_log { filename = "/var/log/freeradius/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/freeradius/mods-enabled/detail.log detail post_proxy_log { filename = "/var/log/freeradius/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_soh # Loading module "soh" from file /etc/freeradius/mods-enabled/soh soh { dhcp = yes } instantiate { } # Instantiating module "logintime" from file /etc/freeradius/mods-enabled/logintime # Instantiating module "IPASS" from file /etc/freeradius/mods-enabled/realm # Instantiating module "suffix" from file /etc/freeradius/mods-enabled/realm # Instantiating module "bangpath" from file /etc/freeradius/mods-enabled/realm # Instantiating module "realmpercent" from file /etc/freeradius/mods-enabled/realm # Instantiating module "ntdomain" from file /etc/freeradius/mods-enabled/realm # Instantiating module "cache_eap" from file /etc/freeradius/mods-enabled/cache_eap rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked # Instantiating module "reject" from file /etc/freeradius/mods-enabled/always # Instantiating module "fail" from file /etc/freeradius/mods-enabled/always # Instantiating module "ok" from file /etc/freeradius/mods-enabled/always # Instantiating module "handled" from file /etc/freeradius/mods-enabled/always # Instantiating module "invalid" from file /etc/freeradius/mods-enabled/always # Instantiating module "userlock" from file /etc/freeradius/mods-enabled/always # Instantiating module "notfound" from file /etc/freeradius/mods-enabled/always # Instantiating module "noop" from file /etc/freeradius/mods-enabled/always # Instantiating module "updated" from file /etc/freeradius/mods-enabled/always # Instantiating module "linelog" from file /etc/freeradius/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/freeradius/mods-enabled/linelog # Instantiating module "preprocess" from file /etc/freeradius/mods-enabled/preprocess reading pairlist file /etc/freeradius/mods-config/preprocess/huntgroups reading pairlist file /etc/freeradius/mods-config/preprocess/hints # Instantiating module "files" from file /etc/freeradius/mods-enabled/files reading pairlist file /etc/freeradius/mods-config/files/authorize reading pairlist file /etc/freeradius/mods-config/files/accounting reading pairlist file /etc/freeradius/mods-config/files/pre-proxy # Instantiating module "sql" from file /etc/freeradius/mods-enabled/sql rlm_sql_mysql: libmysql version: 3.3.5 mysql { tls { tls_required = no check_cert = no check_cert_cn = 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 max_retries = 5 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 Localhost via UNIX socket, server version 10.11.4-MariaDB-1~deb12u1, 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 Localhost via UNIX socket, server version 10.11.4-MariaDB-1~deb12u1, 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 Localhost via UNIX socket, server version 10.11.4-MariaDB-1~deb12u1, 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 Localhost via UNIX socket, server version 10.11.4-MariaDB-1~deb12u1, 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 Localhost via UNIX socket, server version 10.11.4-MariaDB-1~deb12u1, protocol version 10 # Instantiating module "pap" from file /etc/freeradius/mods-enabled/pap # Instantiating module "eap" from file /etc/freeradius/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-eap-tls" virtual_server = "check-eap-tls" } tls-config tls-eap-tls { verify_depth = 0 ca_path = "/etc/freeradius/certs" pem_file_type = yes private_key_file = "/etc/freeradius/certs/server_local.pem" certificate_file = "/etc/freeradius/certs/server_local.pem" ca_file = "/etc/freeradius/certs/ca.pem" private_key_password = <<< secret >>> fragment_size = 1000 include_length = yes auto_chain = yes check_crl = no check_all_crl = no ca_path_reload_interval = 0 cipher_list = "DEFAULT@SECLEVEL=1:TLSv1@SECLEVEL=0" cipher_server_preference = no reject_unknown_intermediate_ca = no ecdh_curve = "prime256v1" tls_max_version = "1.3" tls_min_version = "1.0" cache { enable = no lifetime = 12 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 } } !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !! Most supplicants do not support EAP-TLS with TLS 1.3 !! Please set tls_max_version = "1.2" !! FreeRADIUS only supports TLS 1.3 for special builds of wpa_supplicant and Windows !! This limitation is likely to change in late 2021. !! If you are using this version of FreeRADIUS after 2021, you will probably need to upgrade !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-eap-tls" default_eap_type = "md5" copy_request_to_tunnel = yes 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-eap-peap" default_eap_type = "mschapv2" copy_request_to_tunnel = yes use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls-config tls-eap-peap { verify_depth = 0 ca_path = "/etc/freeradius/certs" pem_file_type = yes private_key_file = "/etc/freeradius/certs/privkey.pem" certificate_file = "/etc/freeradius/certs/fullchain.pem" fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no ca_path_reload_interval = 0 cipher_list = "DEFAULT@SECLEVEL=1" cipher_server_preference = no reject_unknown_intermediate_ca = no ecdh_curve = "prime256v1" tls_max_version = "1.3" tls_min_version = "1.0" cache { enable = no lifetime = 12 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 } } tls: In order to use TLS 1.0 and/or TLS 1.1, you likely need to set: cipher_list = "DEFAULT@SECLEVEL=0" # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = yes identity = "RADIUS" } # Linked to sub-module rlm_eap_fast fast { tls = "tls-eap-peap" default_eap_type = "mschapv2" virtual_server = "inner-tunnel" cipher_list = "ALL:!EXPORT:!eNULL:!SSLv2@SECLEVEL=0" require_client_cert = no pac_lifetime = 604800 authority_identity = "domain.tld" pac_opaque_key = "4f971fe7d4f45bbda3a518eef331156a" copy_request_to_tunnel = no use_tunneled_reply = no } tls: Using cached TLS configuration from previous invocation !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !! There is no standard for using EAP-FAST with TLS 1.3 !! Please set tls_max_version = "1.2" !! FreeRADIUS only supports TLS 1.3 for special builds of wpa_supplicant and Windows !! This limitation is likely to change in late 2021. !! If you are using this version of FreeRADIUS after 2021, you will probably need to upgrade !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! # Instantiating module "ldap" from file /etc/freeradius/mods-enabled/ldap rlm_ldap: libldap vendor: OpenLDAP, version: 20513 accounting { reference = "%{tolower:type.%{Acct-Status-Type}}" } post-auth { reference = "." } !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !! libldap is using GnuTLS, while FreeRADIUS is using OpenSSL !! There may be random issues with TLS connections due to this conflict. !! The server may also crash. !! See https://wiki.freeradius.org/modules/Rlm_ldap for more information. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! rlm_ldap (ldap): 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 max_retries = 5 spread = no } rlm_ldap (ldap): Opening additional connection (0), 1 of 32 pending slots used rlm_ldap (ldap): Connecting to ldaps://172.16.8.200:636 rlm_ldap (ldap): Waiting for bind result... rlm_ldap (ldap): Bind successful rlm_ldap (ldap): Opening additional connection (1), 1 of 31 pending slots used rlm_ldap (ldap): Connecting to ldaps://172.16.8.200:636 rlm_ldap (ldap): Waiting for bind result... rlm_ldap (ldap): Bind successful rlm_ldap (ldap): Opening additional connection (2), 1 of 30 pending slots used rlm_ldap (ldap): Connecting to ldaps://172.16.8.200:636 rlm_ldap (ldap): Waiting for bind result... rlm_ldap (ldap): Bind successful rlm_ldap (ldap): Opening additional connection (3), 1 of 29 pending slots used rlm_ldap (ldap): Connecting to ldaps://172.16.8.200:636 rlm_ldap (ldap): Waiting for bind result... rlm_ldap (ldap): Bind successful rlm_ldap (ldap): Opening additional connection (4), 1 of 28 pending slots used rlm_ldap (ldap): Connecting to ldaps://172.16.8.200:636 rlm_ldap (ldap): Waiting for bind result... rlm_ldap (ldap): Bind successful # Instantiating module "etc_passwd" from file /etc/freeradius/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # Instantiating module "expiration" from file /etc/freeradius/mods-enabled/expiration # Instantiating module "daily" from file /etc/freeradius/mods-enabled/counter rlm_counter: Current Time: 1704759193 [2024-01-09 01:13:13], Next reset 1704841200 [2024-01-10 00:00:00] rlm_counter: add_defaults: Start rlm_counter: DEFAULT1 set to 1704841200 rlm_counter: DEFAULT2 set to 1704759193 rlm_counter: add_defaults: End # Instantiating module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/post-proxy # Instantiating module "attr_filter.pre-proxy" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/pre-proxy # Instantiating module "attr_filter.access_reject" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/access_reject # Instantiating module "attr_filter.access_challenge" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/access_challenge # Instantiating module "attr_filter.accounting_response" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/accounting_response # Instantiating module "attr_filter.coa" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/coa # Instantiating module "mschap" from file /etc/freeradius/mods-enabled/mschap rlm_mschap (mschap): authenticating by calling 'ntlm_auth' # Instantiating module "detail" from file /etc/freeradius/mods-enabled/detail # Instantiating module "auth_log" from file /etc/freeradius/mods-enabled/detail.log rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output # Instantiating module "reply_log" from file /etc/freeradius/mods-enabled/detail.log # Instantiating module "pre_proxy_log" from file /etc/freeradius/mods-enabled/detail.log # Instantiating module "post_proxy_log" from file /etc/freeradius/mods-enabled/detail.log } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/radiusd.conf } # server server status { # from file /etc/freeradius/sites-enabled/status # Loading authorize {...} Compiling Autz-Type Status-Server for attr Autz-Type } # server status server school_8021x { # from file /etc/freeradius/sites-enabled/school_8021x # 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 Compiling Auth-Type ntlm_auth for attr Auth-Type # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} Compiling Post-Auth-Type REJECT for attr Post-Auth-Type Compiling Post-Auth-Type Challenge for attr Post-Auth-Type } # server school_8021x server inner-tunnel { # from file /etc/freeradius/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 Compiling Auth-Type ntlm_auth for attr Auth-Type # Loading authorize {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} Compiling Post-Auth-Type REJECT for attr Post-Auth-Type } # server inner-tunnel radiusd: #### Opening IP addresses and Ports #### listen { type = "status" ipaddr = 127.0.0.1 port = 18121 client admin { ipaddr = 127.0.0.1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } } listen { type = "auth" ipaddr = 0.0.0.0 port = 1812 } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } Listening on status address 127.0.0.1 port 18121 bound to server status Listening on auth address * port 1812 bound to server school_8021x Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Listening on proxy address * port 40678 Ready to process requests (0) Received Access-Request Id 87 from 172.16.5.252:60626 to 172.16.8.2:1812 length 397 (0) User-Name = "guest-1234" (0) Service-Type = Framed-User (0) Cisco-AVPair = "service-type=Framed" (0) Framed-MTU = 1485 (0) EAP-Message = 0x0201000e01676173742d31323334 (0) Message-Authenticator = 0x4466e1b4bd76ecf6867eda8fdf53b8e3 (0) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (0) Cisco-AVPair = "method=dot1x" (0) Cisco-AVPair = "client-iif-id=1593968167" (0) Cisco-AVPair = "vlan-id=10" (0) NAS-IP-Address = 172.16.5.252 (0) NAS-Port-Type = Wireless-802.11 (0) NAS-Port = 518 (0) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (0) Cisco-AVPair = "wlan-profile-name=MySSID" (0) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (0) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (0) Airespace-Wlan-Id = 3 (0) NAS-Identifier = "wlc-rz" (0) WLAN-Group-Cipher = 1027076 (0) WLAN-Pairwise-Cipher = 1027076 (0) WLAN-AKM-Suite = 1027073 (0) WLAN-Group-Mgmt-Cipher = 1027078 (0) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (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 !~ /(a)(.+)\.(.+)$/)) { (0) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (0) if (&User-Name =~ /\.$/) { (0) if (&User-Name =~ /\.$/) -> FALSE (0) if (&User-Name =~ /(a)\./) { (0) if (&User-Name =~ /(a)\./) -> FALSE (0) } # if (&User-Name) = notfound (0) } # policy filter_username = notfound (0) [preprocess] = ok (0) [digest] = noop (0) suffix: Checking for suffix after "@" (0) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (0) suffix: Found realm "NULL" (0) suffix: Adding Stripped-User-Name = "guest-1234" (0) suffix: Adding Realm = "NULL" (0) suffix: Authentication realm is LOCAL (0) [suffix] = ok (0) [chap] = noop (0) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (0) sql: --> guest-1234 (0) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (0) (0) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (0) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (0) sql: User found in radcheck table (0) sql: Conditional check items matched, merging assignment check items (0) sql: Cleartext-Password := "guest-1324" (0) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (0) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (0) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (0) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (0) sql: User found in the group table (0) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (0) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (0) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (0) sql: Group "wlanguest": Conditional check items matched (0) sql: Group "wlanguest": Merging assignment check items (0) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (0) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (0) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (0) sql: Group "wlanguest": Merging reply items 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 Localhost via UNIX socket, server version 10.11.4-MariaDB-1~deb12u1, protocol version 10 (0) [sql] = ok (0) [mschap] = noop (0) eap: Peer sent EAP Response (code 2) ID 1 length 14 (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 /etc/freeradius/sites-enabled/school_8021x (0) authenticate { (0) eap: Peer sent packet with method EAP Identity (1) (0) eap: Calling submodule eap_peap to process data (0) eap_peap: (TLS) Initiating new session (0) eap: Sending EAP Request (code 1) ID 2 length 6 (0) eap: EAP session adding &reply:State = 0xbddf205cbddd39b6 (0) [eap] = handled (0) } # authenticate = handled (0) Using Post-Auth-Type Challenge (0) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (0) Challenge { ... } # empty sub-section is ignored (0) session-state: Saving cached attributes (0) Framed-MTU = 1004 (0) Sent Access-Challenge Id 87 from 172.16.8.2:1812 to 172.16.5.252:60626 length 64 (0) EAP-Message = 0x010200061920 (0) Message-Authenticator = 0x00000000000000000000000000000000 (0) State = 0xbddf205cbddd39b6f7c918f7a32a79be (0) Finished request Waking up in 4.9 seconds. (1) Received Access-Request Id 95 from 172.16.5.252:60626 to 172.16.8.2:1812 length 573 (1) User-Name = "guest-1234" (1) Service-Type = Framed-User (1) Cisco-AVPair = "service-type=Framed" (1) Framed-MTU = 1485 (1) EAP-Message = 0x020200ac1980000000a2160303009d010000990303659c8f9c119c0817cc9e9923fc0e519d618ee5f655d2a758b320083d93b3294f00002ac02cc02bc030c02f009f009ec024c023c028c027c00ac009c014c013009d009c003d003c0035002f000a01000046000500050100000000000a00080006001d00170018000b00020100000d001a00180804080508060401050102010403050302030202060106030023000000170000ff01000100 (1) Message-Authenticator = 0x2db8d62b4d43c55b76075c769689fc3b (1) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (1) Cisco-AVPair = "method=dot1x" (1) Cisco-AVPair = "client-iif-id=1593968167" (1) Cisco-AVPair = "vlan-id=10" (1) NAS-IP-Address = 172.16.5.252 (1) NAS-Port-Type = Wireless-802.11 (1) NAS-Port = 518 (1) State = 0xbddf205cbddd39b6f7c918f7a32a79be (1) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (1) Cisco-AVPair = "wlan-profile-name=MySSID" (1) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (1) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (1) Airespace-Wlan-Id = 3 (1) NAS-Identifier = "wlc-rz" (1) WLAN-Group-Cipher = 1027076 (1) WLAN-Pairwise-Cipher = 1027076 (1) WLAN-AKM-Suite = 1027073 (1) WLAN-Group-Mgmt-Cipher = 1027078 (1) Restoring &session-state (1) &session-state:Framed-MTU = 1004 (1) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (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 !~ /(a)(.+)\.(.+)$/)) { (1) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (1) if (&User-Name =~ /\.$/) { (1) if (&User-Name =~ /\.$/) -> FALSE (1) if (&User-Name =~ /(a)\./) { (1) if (&User-Name =~ /(a)\./) -> FALSE (1) } # if (&User-Name) = notfound (1) } # policy filter_username = notfound (1) [preprocess] = ok (1) [digest] = noop (1) suffix: Checking for suffix after "@" (1) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (1) suffix: Found realm "NULL" (1) suffix: Adding Stripped-User-Name = "guest-1234" (1) suffix: Adding Realm = "NULL" (1) suffix: Authentication realm is LOCAL (1) [suffix] = ok (1) [chap] = noop (1) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (1) sql: --> guest-1234 (1) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (1) (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 = 'guest-1234' ORDER BY id (1) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (1) sql: User found in radcheck table (1) sql: Conditional check items matched, merging assignment check items (1) sql: Cleartext-Password := "guest-1324" (1) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (1) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (1) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' 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 = 'guest-1234' ORDER BY priority (1) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (1) sql: User found in the group table (1) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (1) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (1) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (1) sql: Group "wlanguest": Conditional check items matched (1) sql: Group "wlanguest": Merging assignment check items (1) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (1) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (1) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (1) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (1) (1) [sql] = ok (1) [mschap] = noop (1) eap: Peer sent EAP Response (code 2) ID 2 length 172 (1) eap: Continuing tunnel setup (1) [eap] = ok (1) } # authorize = ok (1) Found Auth-Type = eap (1) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (1) authenticate { (1) eap: Expiring EAP session with state 0xbddf205cbddd39b6 (1) eap: Finished EAP session with state 0xbddf205cbddd39b6 (1) eap: Previous EAP request found for state 0xbddf205cbddd39b6, released from the list (1) eap: Peer sent packet with method EAP PEAP (25) (1) eap: Calling submodule eap_peap to process data (1) eap_peap: (TLS) EAP Peer says that the final record size will be 162 bytes (1) eap_peap: (TLS) EAP Got all data (162 bytes) (1) eap_peap: (TLS) Handshake state - before SSL initialization (1) eap_peap: (TLS) Handshake state - Server before SSL initialization (1) eap_peap: (TLS) Handshake state - Server before SSL initialization (1) eap_peap: (TLS) recv TLS 1.3 Handshake, ClientHello (1) eap_peap: (TLS) Handshake state - Server SSLv3/TLS read client hello (1) eap_peap: (TLS) send TLS 1.2 Handshake, ServerHello (1) eap_peap: (TLS) Handshake state - Server SSLv3/TLS write server hello (1) eap_peap: (TLS) send TLS 1.2 Handshake, Certificate (1) eap_peap: (TLS) Handshake state - Server SSLv3/TLS write certificate (1) eap_peap: (TLS) send TLS 1.2 Handshake, ServerKeyExchange (1) eap_peap: (TLS) Handshake state - Server SSLv3/TLS write key exchange (1) eap_peap: (TLS) send TLS 1.2 Handshake, ServerHelloDone (1) eap_peap: (TLS) Handshake state - Server SSLv3/TLS write server done (1) eap_peap: (TLS) Server : Need to read more data: SSLv3/TLS write server done (1) eap_peap: (TLS) In Handshake Phase (1) eap: Sending EAP Request (code 1) ID 3 length 1014 (1) eap: EAP session adding &reply:State = 0xbddf205cbcdc39b6 (1) [eap] = handled (1) } # authenticate = handled (1) Using Post-Auth-Type Challenge (1) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (1) Challenge { ... } # empty sub-section is ignored (1) session-state: Saving cached attributes (1) Framed-MTU = 1004 (1) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (1) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (1) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (1) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (1) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (1) Sent Access-Challenge Id 95 from 172.16.8.2:1812 to 172.16.5.252:60626 length 1080 (1) EAP-Message = 0x010303f619c000001e0d160303003d0200003903037edcca5398bd639702dea323467d6669136e692397918eda444f574e4752440100c030000011ff01000100000b000403000102001700001603031c6b0b001c67001c640004f9308204f5308203dda0030201020212042926c418ea01b0d1f5c2840ddfd29795e1300d06092a864886f70d01010b05003032310b300906035504061302555331163014060355040a130d4c6574277320456e6372797074310b3009060355040313025233301e170d3233313131323032333434395a170d3234303231303032333434385a301f311d301b060355040313147261646975732e6c656e6465722e736368756c6530820122300d06092a864886f70d01010105000382010f003082010a0282010100cfb3dce5f106298287ab2ded73bdcd2ab2da13f02234bd1cf8f250f0b9e10ef5b6ffcccc57e4c136f30313160897175c8ce15a1ea450a4cf403c057e1771360ed2e668ab906e240cc020bb426441c63470b261e55f38 (1) Message-Authenticator = 0x00000000000000000000000000000000 (1) State = 0xbddf205cbcdc39b6f7c918f7a32a79be (1) Finished request Waking up in 4.9 seconds. (2) Received Access-Request Id 103 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (2) User-Name = "guest-1234" (2) Service-Type = Framed-User (2) Cisco-AVPair = "service-type=Framed" (2) Framed-MTU = 1485 (2) EAP-Message = 0x020300061900 (2) Message-Authenticator = 0xd1601b20f13c3aa6a452b1528953697d (2) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (2) Cisco-AVPair = "method=dot1x" (2) Cisco-AVPair = "client-iif-id=1593968167" (2) Cisco-AVPair = "vlan-id=10" (2) NAS-IP-Address = 172.16.5.252 (2) NAS-Port-Type = Wireless-802.11 (2) NAS-Port = 518 (2) State = 0xbddf205cbcdc39b6f7c918f7a32a79be (2) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (2) Cisco-AVPair = "wlan-profile-name=MySSID" (2) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (2) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (2) Airespace-Wlan-Id = 3 (2) NAS-Identifier = "wlc-rz" (2) WLAN-Group-Cipher = 1027076 (2) WLAN-Pairwise-Cipher = 1027076 (2) WLAN-AKM-Suite = 1027073 (2) WLAN-Group-Mgmt-Cipher = 1027078 (2) Restoring &session-state (2) &session-state:Framed-MTU = 1004 (2) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (2) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (2) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (2) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (2) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (2) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (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 !~ /(a)(.+)\.(.+)$/)) { (2) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (2) if (&User-Name =~ /\.$/) { (2) if (&User-Name =~ /\.$/) -> FALSE (2) if (&User-Name =~ /(a)\./) { (2) if (&User-Name =~ /(a)\./) -> FALSE (2) } # if (&User-Name) = notfound (2) } # policy filter_username = notfound (2) [preprocess] = ok (2) [digest] = noop (2) suffix: Checking for suffix after "@" (2) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (2) suffix: Found realm "NULL" (2) suffix: Adding Stripped-User-Name = "guest-1234" (2) suffix: Adding Realm = "NULL" (2) suffix: Authentication realm is LOCAL (2) [suffix] = ok (2) [chap] = noop (2) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (2) sql: --> guest-1234 (2) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (2) (2) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (2) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (2) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (2) sql: User found in radcheck table (2) sql: Conditional check items matched, merging assignment check items (2) sql: Cleartext-Password := "guest-1324" (2) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (2) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (2) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (2) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (2) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (2) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (2) sql: User found in the group table (2) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (2) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (2) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (2) sql: Group "wlanguest": Conditional check items matched (2) sql: Group "wlanguest": Merging assignment check items (2) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (2) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (2) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (2) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (2) (2) [sql] = ok (2) [mschap] = noop (2) eap: Peer sent EAP Response (code 2) ID 3 length 6 (2) eap: Continuing tunnel setup (2) [eap] = ok (2) } # authorize = ok (2) Found Auth-Type = eap (2) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (2) authenticate { (2) eap: Expiring EAP session with state 0xbddf205cbcdc39b6 (2) eap: Finished EAP session with state 0xbddf205cbcdc39b6 (2) eap: Previous EAP request found for state 0xbddf205cbcdc39b6, released from the list (2) eap: Peer sent packet with method EAP PEAP (25) (2) eap: Calling submodule eap_peap to process data (2) eap_peap: (TLS) Peer ACKed our handshake fragment (2) eap: Sending EAP Request (code 1) ID 4 length 1010 (2) eap: EAP session adding &reply:State = 0xbddf205cbfdb39b6 (2) [eap] = handled (2) } # authenticate = handled (2) Using Post-Auth-Type Challenge (2) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (2) Challenge { ... } # empty sub-section is ignored (2) session-state: Saving cached attributes (2) Framed-MTU = 1004 (2) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (2) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (2) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (2) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (2) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (2) Sent Access-Challenge Id 103 from 172.16.8.2:1812 to 172.16.5.252:60626 length 1074 (2) EAP-Message = 0x010403f219400300473045022021d86d99c514e86ea5d3a44852f734ac4f925072d0aaf7a337d6f92e614d6eec022100e912879e5f209fa42e24cd76df09f98c3ef2bb5265d1c205d5e5ae2226f9314a300d06092a864886f70d01010b050003820101009922dd5305695329c64db33f8f5667c95c4cddd0b78bd509b208bfb9f60b5f7da92b8e9df0f08bc0f217e8a3f2c2325c598de59708d1ab23e1e0bbac6ccca9ee0dc5d7d6b615bd222dd7e4cec69758ba7ca279b864a3afac2839be1cdb8d4e3ef438b8d9dc856d261b52da679870f84306cb9caf54f533c4090b372c033d5b808f42e195bd992048ca9a0fb199f1f24ea9f6d26b0a08726996c70a41f57e2009b99728be07bce33f2b789d271eea5bff132dc7f4b260603b559fdb1955cf410003428e50f493e8183bfbe030a0711d89d71427f996db7bddb06e56ad33ca9f7c93b603dab8e6e2fa915d554746f2a7baff627112a3bafdbaed08d22d7acdce5f00056f3082056b30820353a003020102021100 (2) Message-Authenticator = 0x00000000000000000000000000000000 (2) State = 0xbddf205cbfdb39b6f7c918f7a32a79be (2) Finished request Waking up in 4.9 seconds. (3) Received Access-Request Id 111 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (3) User-Name = "guest-1234" (3) Service-Type = Framed-User (3) Cisco-AVPair = "service-type=Framed" (3) Framed-MTU = 1485 (3) EAP-Message = 0x020400061900 (3) Message-Authenticator = 0x71fd4bb9a078d7475981559a9ba8ea80 (3) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (3) Cisco-AVPair = "method=dot1x" (3) Cisco-AVPair = "client-iif-id=1593968167" (3) Cisco-AVPair = "vlan-id=10" (3) NAS-IP-Address = 172.16.5.252 (3) NAS-Port-Type = Wireless-802.11 (3) NAS-Port = 518 (3) State = 0xbddf205cbfdb39b6f7c918f7a32a79be (3) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (3) Cisco-AVPair = "wlan-profile-name=MySSID" (3) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (3) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (3) Airespace-Wlan-Id = 3 (3) NAS-Identifier = "wlc-rz" (3) WLAN-Group-Cipher = 1027076 (3) WLAN-Pairwise-Cipher = 1027076 (3) WLAN-AKM-Suite = 1027073 (3) WLAN-Group-Mgmt-Cipher = 1027078 (3) Restoring &session-state (3) &session-state:Framed-MTU = 1004 (3) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (3) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (3) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (3) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (3) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (3) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (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 !~ /(a)(.+)\.(.+)$/)) { (3) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (3) if (&User-Name =~ /\.$/) { (3) if (&User-Name =~ /\.$/) -> FALSE (3) if (&User-Name =~ /(a)\./) { (3) if (&User-Name =~ /(a)\./) -> FALSE (3) } # if (&User-Name) = notfound (3) } # policy filter_username = notfound (3) [preprocess] = ok (3) [digest] = noop (3) suffix: Checking for suffix after "@" (3) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (3) suffix: Found realm "NULL" (3) suffix: Adding Stripped-User-Name = "guest-1234" (3) suffix: Adding Realm = "NULL" (3) suffix: Authentication realm is LOCAL (3) [suffix] = ok (3) [chap] = noop (3) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (3) sql: --> guest-1234 (3) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (3) (3) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (3) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (3) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (3) sql: User found in radcheck table (3) sql: Conditional check items matched, merging assignment check items (3) sql: Cleartext-Password := "guest-1324" (3) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (3) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (3) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (3) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (3) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (3) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (3) sql: User found in the group table (3) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (3) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (3) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (3) sql: Group "wlanguest": Conditional check items matched (3) sql: Group "wlanguest": Merging assignment check items (3) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (3) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (3) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (3) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (3) (3) [sql] = ok (3) [mschap] = 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 /etc/freeradius/sites-enabled/school_8021x (3) authenticate { (3) eap: Expiring EAP session with state 0xbddf205cbfdb39b6 (3) eap: Finished EAP session with state 0xbddf205cbfdb39b6 (3) eap: Previous EAP request found for state 0xbddf205cbfdb39b6, released from the list (3) eap: Peer sent packet with method EAP PEAP (25) (3) eap: Calling submodule eap_peap to process data (3) eap_peap: (TLS) Peer ACKed our handshake fragment (3) eap: Sending EAP Request (code 1) ID 5 length 1010 (3) eap: EAP session adding &reply:State = 0xbddf205cbeda39b6 (3) [eap] = handled (3) } # authenticate = handled (3) Using Post-Auth-Type Challenge (3) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (3) Challenge { ... } # empty sub-section is ignored (3) session-state: Saving cached attributes (3) Framed-MTU = 1004 (3) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (3) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (3) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (3) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (3) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (3) Sent Access-Challenge Id 111 from 172.16.8.2:1812 to 172.16.5.252:60626 length 1074 (3) EAP-Message = 0x010503f219407b4a1c4b730512fcc6eae050137c439374b3ca74e78e1f0108d030d45b7136b407bac130305c48b7823b98a67d608aa2a32982ccbabd83041ba2830341a1d605f11bc2b6f0a87c863b46a8482a88dc769a76bf1f6aa53d198feb38f364dec82b0d0a28fff7dbe21542d422d0275de179fe18e77088ad4ee6d98b3ac6dd27516effbc64f533434f0203010001a3423040300e0603551d0f0101ff040403020106300f0603551d130101ff040530030101ff301d0603551d0e0416041479b459e67bb6e5e40173800888c81a58f6e99b6e300d06092a864886f70d01010b05000382020100551f58a9bcb2a850d00cb1d81a6920272908ac61755c8a6ef882e5692fd5f6564bb9b8731059d321977ee74c71fbb2d260ad39a80bea17215685f1500e59ebcee059e9bac915ef869d8f8480f6e4e99190dc179b621b45f06695d27c6fc2ea3bef1fcfcbd6ae27f1a9b0c8aefd7d7e9afa2204ebffd97fea912b22b1170e8ff28a345b58d8fc01c954b9b826cc (3) Message-Authenticator = 0x00000000000000000000000000000000 (3) State = 0xbddf205cbeda39b6f7c918f7a32a79be (3) Finished request Waking up in 4.9 seconds. (4) Received Access-Request Id 119 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (4) User-Name = "guest-1234" (4) Service-Type = Framed-User (4) Cisco-AVPair = "service-type=Framed" (4) Framed-MTU = 1485 (4) EAP-Message = 0x020500061900 (4) Message-Authenticator = 0x51d1d2e263ff4a905543ce67e7bbfda8 (4) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (4) Cisco-AVPair = "method=dot1x" (4) Cisco-AVPair = "client-iif-id=1593968167" (4) Cisco-AVPair = "vlan-id=10" (4) NAS-IP-Address = 172.16.5.252 (4) NAS-Port-Type = Wireless-802.11 (4) NAS-Port = 518 (4) State = 0xbddf205cbeda39b6f7c918f7a32a79be (4) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (4) Cisco-AVPair = "wlan-profile-name=MySSID" (4) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (4) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (4) Airespace-Wlan-Id = 3 (4) NAS-Identifier = "wlc-rz" (4) WLAN-Group-Cipher = 1027076 (4) WLAN-Pairwise-Cipher = 1027076 (4) WLAN-AKM-Suite = 1027073 (4) WLAN-Group-Mgmt-Cipher = 1027078 (4) Restoring &session-state (4) &session-state:Framed-MTU = 1004 (4) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (4) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (4) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (4) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (4) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (4) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (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 !~ /(a)(.+)\.(.+)$/)) { (4) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (4) if (&User-Name =~ /\.$/) { (4) if (&User-Name =~ /\.$/) -> FALSE (4) if (&User-Name =~ /(a)\./) { (4) if (&User-Name =~ /(a)\./) -> FALSE (4) } # if (&User-Name) = notfound (4) } # policy filter_username = notfound (4) [preprocess] = ok (4) [digest] = noop (4) suffix: Checking for suffix after "@" (4) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (4) suffix: Found realm "NULL" (4) suffix: Adding Stripped-User-Name = "guest-1234" (4) suffix: Adding Realm = "NULL" (4) suffix: Authentication realm is LOCAL (4) [suffix] = ok (4) [chap] = noop (4) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (4) sql: --> guest-1234 (4) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (4) (4) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (4) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (4) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (4) sql: User found in radcheck table (4) sql: Conditional check items matched, merging assignment check items (4) sql: Cleartext-Password := "guest-1324" (4) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (4) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (4) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (4) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (4) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (4) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (4) sql: User found in the group table (4) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (4) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (4) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (4) sql: Group "wlanguest": Conditional check items matched (4) sql: Group "wlanguest": Merging assignment check items (4) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (4) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (4) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (4) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (4) (4) [sql] = ok (4) [mschap] = 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 /etc/freeradius/sites-enabled/school_8021x (4) authenticate { (4) eap: Expiring EAP session with state 0xbddf205cbeda39b6 (4) eap: Finished EAP session with state 0xbddf205cbeda39b6 (4) eap: Previous EAP request found for state 0xbddf205cbeda39b6, released from the list (4) eap: Peer sent packet with method EAP PEAP (25) (4) eap: Calling submodule eap_peap to process data (4) eap_peap: (TLS) Peer ACKed our handshake fragment (4) eap: Sending EAP Request (code 1) ID 6 length 1010 (4) eap: EAP session adding &reply:State = 0xbddf205cb9d939b6 (4) [eap] = handled (4) } # authenticate = handled (4) Using Post-Auth-Type Challenge (4) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (4) Challenge { ... } # empty sub-section is ignored (4) session-state: Saving cached attributes (4) Framed-MTU = 1004 (4) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (4) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (4) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (4) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (4) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (4) Sent Access-Challenge Id 119 from 172.16.8.2:1812 to 172.16.5.252:60626 length 1074 (4) EAP-Message = 0x010603f21940cd9bd59f80830aec094af3164a3e5ccf77acde67050d1d07b6dc16fb5a8b14dbe27160c4ba459511898eea06dff72a161ca4b9c5c532e003e01e8218388bd745d80a6a6ee60077fb02517d22d80a6e9a5b77dff0fa41ec39dc75ca68070c1feaa3423040300e0603551d0f0101ff040403020106300f0603551d130101ff040530030101ff301d0603551d0e041604147c4296aede4b483bfa92f89e8ccf6d8ba9723795300a06082a8648ce3d040303036800306502307b794e465084c24487461b4570ff5899def4fda4d255a6202d74d634bc41a3505f012756b4be277506af122e75988dfc0231008bf5776cd4c865aae00b2cee149d2737a4f953a551e42983d7f890315b429f0af5feae0068e78c490fb66f5b5b15f2e70002ca308202c63082024da003020102021100b3bddff8a7845bbce903a04135b34a45300a06082a8648ce3d040303304f310b300906035504061302555331293027060355040a1320496e7465726e6574205365637572 (4) Message-Authenticator = 0x00000000000000000000000000000000 (4) State = 0xbddf205cb9d939b6f7c918f7a32a79be (4) Finished request Waking up in 4.9 seconds. (5) Received Access-Request Id 127 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (5) User-Name = "guest-1234" (5) Service-Type = Framed-User (5) Cisco-AVPair = "service-type=Framed" (5) Framed-MTU = 1485 (5) EAP-Message = 0x020600061900 (5) Message-Authenticator = 0xb24568b3cfebd56ddb9592ad0340126d (5) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (5) Cisco-AVPair = "method=dot1x" (5) Cisco-AVPair = "client-iif-id=1593968167" (5) Cisco-AVPair = "vlan-id=10" (5) NAS-IP-Address = 172.16.5.252 (5) NAS-Port-Type = Wireless-802.11 (5) NAS-Port = 518 (5) State = 0xbddf205cb9d939b6f7c918f7a32a79be (5) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (5) Cisco-AVPair = "wlan-profile-name=MySSID" (5) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (5) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (5) Airespace-Wlan-Id = 3 (5) NAS-Identifier = "wlc-rz" (5) WLAN-Group-Cipher = 1027076 (5) WLAN-Pairwise-Cipher = 1027076 (5) WLAN-AKM-Suite = 1027073 (5) WLAN-Group-Mgmt-Cipher = 1027078 (5) Restoring &session-state (5) &session-state:Framed-MTU = 1004 (5) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (5) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (5) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (5) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (5) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (5) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (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 !~ /(a)(.+)\.(.+)$/)) { (5) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (5) if (&User-Name =~ /\.$/) { (5) if (&User-Name =~ /\.$/) -> FALSE (5) if (&User-Name =~ /(a)\./) { (5) if (&User-Name =~ /(a)\./) -> FALSE (5) } # if (&User-Name) = notfound (5) } # policy filter_username = notfound (5) [preprocess] = ok (5) [digest] = noop (5) suffix: Checking for suffix after "@" (5) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (5) suffix: Found realm "NULL" (5) suffix: Adding Stripped-User-Name = "guest-1234" (5) suffix: Adding Realm = "NULL" (5) suffix: Authentication realm is LOCAL (5) [suffix] = ok (5) [chap] = noop (5) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (5) sql: --> guest-1234 (5) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (0) (5) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (5) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (5) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (5) sql: User found in radcheck table (5) sql: Conditional check items matched, merging assignment check items (5) sql: Cleartext-Password := "guest-1324" (5) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (5) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (5) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (5) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (5) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (5) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (5) sql: User found in the group table (5) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (5) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (5) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (5) sql: Group "wlanguest": Conditional check items matched (5) sql: Group "wlanguest": Merging assignment check items (5) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (5) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (5) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (5) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (0) (5) [sql] = ok (5) [mschap] = noop (5) eap: Peer sent EAP Response (code 2) ID 6 length 6 (5) eap: Continuing tunnel setup (5) [eap] = ok (5) } # authorize = ok (5) Found Auth-Type = eap (5) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (5) authenticate { (5) eap: Expiring EAP session with state 0xbddf205cb9d939b6 (5) eap: Finished EAP session with state 0xbddf205cb9d939b6 (5) eap: Previous EAP request found for state 0xbddf205cb9d939b6, released from the list (5) eap: Peer sent packet with method EAP PEAP (25) (5) eap: Calling submodule eap_peap to process data (5) eap_peap: (TLS) Peer ACKed our handshake fragment (5) eap: Sending EAP Request (code 1) ID 7 length 1010 (5) eap: EAP session adding &reply:State = 0xbddf205cb8d839b6 (5) [eap] = handled (5) } # authenticate = handled (5) Using Post-Auth-Type Challenge (5) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (5) Challenge { ... } # empty sub-section is ignored (5) session-state: Saving cached attributes (5) Framed-MTU = 1004 (5) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (5) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (5) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (5) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (5) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (5) Sent Access-Challenge Id 127 from 172.16.8.2:1812 to 172.16.5.252:60626 length 1074 (5) EAP-Message = 0x010703f2194002c63082024ca00302010202104ed23df6af7ec7f9b0c4726ff9512a77300a06082a8648ce3d040303304f310b300906035504061302555331293027060355040a1320496e7465726e65742053656375726974792052657365617263682047726f7570311530130603550403130c4953524720526f6f74205832301e170d3230303930343030303030305a170d3235303931353136303030305a3032310b300906035504061302555331163014060355040a130d4c6574277320456e6372797074310b30090603550403130245323076301006072a8648ce3d020106052b8104002203620004239a2cede58b198d61559ec7e65560e8932e08b44a0356b54e21b9f939d15538669fcb6c1543c42b27b08eefb9fe31a780aef844cd820184c81a89de3f225307b962dfea7d2ad17f5fc3e51e7c76e689f88bcb457780491a842fe5640d7ad6dea382010830820104300e0603551d0f0101ff040403020186301d0603551d250416301406082b0601050507 (5) Message-Authenticator = 0x00000000000000000000000000000000 (5) State = 0xbddf205cb8d839b6f7c918f7a32a79be (5) Finished request Waking up in 4.9 seconds. (6) Received Access-Request Id 135 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (6) User-Name = "guest-1234" (6) Service-Type = Framed-User (6) Cisco-AVPair = "service-type=Framed" (6) Framed-MTU = 1485 (6) EAP-Message = 0x020700061900 (6) Message-Authenticator = 0xcebe8d28fc6e9b5053a80c0aefe76d4f (6) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (6) Cisco-AVPair = "method=dot1x" (6) Cisco-AVPair = "client-iif-id=1593968167" (6) Cisco-AVPair = "vlan-id=10" (6) NAS-IP-Address = 172.16.5.252 (6) NAS-Port-Type = Wireless-802.11 (6) NAS-Port = 518 (6) State = 0xbddf205cb8d839b6f7c918f7a32a79be (6) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (6) Cisco-AVPair = "wlan-profile-name=MySSID" (6) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (6) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (6) Airespace-Wlan-Id = 3 (6) NAS-Identifier = "wlc-rz" (6) WLAN-Group-Cipher = 1027076 (6) WLAN-Pairwise-Cipher = 1027076 (6) WLAN-AKM-Suite = 1027073 (6) WLAN-Group-Mgmt-Cipher = 1027078 (6) Restoring &session-state (6) &session-state:Framed-MTU = 1004 (6) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (6) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (6) authorize { (6) policy filter_username { (6) if (&User-Name) { (6) if (&User-Name) -> TRUE (6) if (&User-Name) { (6) if (&User-Name =~ / /) { (6) if (&User-Name =~ / /) -> FALSE (6) if (&User-Name =~ /@[^@]*@/ ) { (6) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (6) if (&User-Name =~ /\.\./ ) { (6) if (&User-Name =~ /\.\./ ) -> FALSE (6) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (6) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (6) if (&User-Name =~ /\.$/) { (6) if (&User-Name =~ /\.$/) -> FALSE (6) if (&User-Name =~ /(a)\./) { (6) if (&User-Name =~ /(a)\./) -> FALSE (6) } # if (&User-Name) = notfound (6) } # policy filter_username = notfound (6) [preprocess] = ok (6) [digest] = noop (6) suffix: Checking for suffix after "@" (6) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (6) suffix: Found realm "NULL" (6) suffix: Adding Stripped-User-Name = "guest-1234" (6) suffix: Adding Realm = "NULL" (6) suffix: Authentication realm is LOCAL (6) [suffix] = ok (6) [chap] = noop (6) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (6) sql: --> guest-1234 (6) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (5) (6) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (6) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (6) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (6) sql: User found in radcheck table (6) sql: Conditional check items matched, merging assignment check items (6) sql: Cleartext-Password := "guest-1324" (6) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (6) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (6) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (6) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (6) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (6) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (6) sql: User found in the group table (6) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (6) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (6) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (6) sql: Group "wlanguest": Conditional check items matched (6) sql: Group "wlanguest": Merging assignment check items (6) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (6) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (6) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (6) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (5) (6) [sql] = ok (6) [mschap] = noop (6) eap: Peer sent EAP Response (code 2) ID 7 length 6 (6) eap: Continuing tunnel setup (6) [eap] = ok (6) } # authorize = ok (6) Found Auth-Type = eap (6) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (6) authenticate { (6) eap: Expiring EAP session with state 0xbddf205cb8d839b6 (6) eap: Finished EAP session with state 0xbddf205cb8d839b6 (6) eap: Previous EAP request found for state 0xbddf205cb8d839b6, released from the list (6) eap: Peer sent packet with method EAP PEAP (25) (6) eap: Calling submodule eap_peap to process data (6) eap_peap: (TLS) Peer ACKed our handshake fragment (6) eap: Sending EAP Request (code 1) ID 8 length 1010 (6) eap: EAP session adding &reply:State = 0xbddf205cbbd739b6 (6) [eap] = handled (6) } # authenticate = handled (6) Using Post-Auth-Type Challenge (6) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (6) Challenge { ... } # empty sub-section is ignored (6) session-state: Saving cached attributes (6) Framed-MTU = 1004 (6) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (6) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (6) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (6) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (6) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (6) Sent Access-Challenge Id 135 from 172.16.8.2:1812 to 172.16.5.252:60626 length 1074 (6) EAP-Message = 0x010803f2194094145535578c9ea8a23919f5823c42a94e6ef53bc32edb8dc0b05cf35938e7edcf69f05a0b1bbec094242587fa3771b313e71cace19befdbe43b45524596a9c153ce34c852eeb5aeed8fde6070e2a554abb66d0e97a540346b2bd3bc66eb66347cfa6b8b8f572999f830175dba726ffb81c5add286583d17c7e709bbf12bf786dcc1da715dd446e3ccad25c188bc60677566b3f118f7a25ce653ff3a88b647a5ff1318ea9809773f9d53f9cf01e5f5a6701714af63a4ff99b3939ddc53a706fe48851da169ae2575bb13cc5203f5ed51a18bdb150203010001a382010830820104300e0603551d0f0101ff040403020186301d0603551d250416301406082b0601050507030206082b0601050507030130120603551d130101ff040830060101ff020100301d0603551d0e04160414142eb317b75856cbae500940e61faf9d8b14c2c6301f0603551d2304183016801479b459e67bb6e5e40173800888c81a58f6e99b6e303206082b0601050507010104 (6) Message-Authenticator = 0x00000000000000000000000000000000 (6) State = 0xbddf205cbbd739b6f7c918f7a32a79be (6) Finished request Waking up in 4.9 seconds. (7) Received Access-Request Id 143 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (7) User-Name = "guest-1234" (7) Service-Type = Framed-User (7) Cisco-AVPair = "service-type=Framed" (7) Framed-MTU = 1485 (7) EAP-Message = 0x020800061900 (7) Message-Authenticator = 0x6621eaff730e4a2a3f4f9273aba9fa52 (7) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (7) Cisco-AVPair = "method=dot1x" (7) Cisco-AVPair = "client-iif-id=1593968167" (7) Cisco-AVPair = "vlan-id=10" (7) NAS-IP-Address = 172.16.5.252 (7) NAS-Port-Type = Wireless-802.11 (7) NAS-Port = 518 (7) State = 0xbddf205cbbd739b6f7c918f7a32a79be (7) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (7) Cisco-AVPair = "wlan-profile-name=MySSID" (7) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (7) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (7) Airespace-Wlan-Id = 3 (7) NAS-Identifier = "wlc-rz" (7) WLAN-Group-Cipher = 1027076 (7) WLAN-Pairwise-Cipher = 1027076 (7) WLAN-AKM-Suite = 1027073 (7) WLAN-Group-Mgmt-Cipher = 1027078 (7) Restoring &session-state (7) &session-state:Framed-MTU = 1004 (7) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (7) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (7) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (7) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (7) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (7) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (7) authorize { (7) policy filter_username { (7) if (&User-Name) { (7) if (&User-Name) -> TRUE (7) if (&User-Name) { (7) if (&User-Name =~ / /) { (7) if (&User-Name =~ / /) -> FALSE (7) if (&User-Name =~ /@[^@]*@/ ) { (7) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (7) if (&User-Name =~ /\.\./ ) { (7) if (&User-Name =~ /\.\./ ) -> FALSE (7) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (7) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (7) if (&User-Name =~ /\.$/) { (7) if (&User-Name =~ /\.$/) -> FALSE (7) if (&User-Name =~ /(a)\./) { (7) if (&User-Name =~ /(a)\./) -> FALSE (7) } # if (&User-Name) = notfound (7) } # policy filter_username = notfound (7) [preprocess] = ok (7) [digest] = noop (7) suffix: Checking for suffix after "@" (7) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (7) suffix: Found realm "NULL" (7) suffix: Adding Stripped-User-Name = "guest-1234" (7) suffix: Adding Realm = "NULL" (7) suffix: Authentication realm is LOCAL (7) [suffix] = ok (7) [chap] = noop (7) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (7) sql: --> guest-1234 (7) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (1) (7) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (7) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (7) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (7) sql: User found in radcheck table (7) sql: Conditional check items matched, merging assignment check items (7) sql: Cleartext-Password := "guest-1324" (7) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (7) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (7) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (7) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (7) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (7) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (7) sql: User found in the group table (7) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (7) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (7) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (7) sql: Group "wlanguest": Conditional check items matched (7) sql: Group "wlanguest": Merging assignment check items (7) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (7) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (7) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (7) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (1) (7) [sql] = ok (7) [mschap] = noop (7) eap: Peer sent EAP Response (code 2) ID 8 length 6 (7) eap: Continuing tunnel setup (7) [eap] = ok (7) } # authorize = ok (7) Found Auth-Type = eap (7) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (7) authenticate { (7) eap: Expiring EAP session with state 0xbddf205cbbd739b6 (7) eap: Finished EAP session with state 0xbddf205cbbd739b6 (7) eap: Previous EAP request found for state 0xbddf205cbbd739b6, released from the list (7) eap: Peer sent packet with method EAP PEAP (25) (7) eap: Calling submodule eap_peap to process data (7) eap_peap: (TLS) Peer ACKed our handshake fragment (7) eap: Sending EAP Request (code 1) ID 9 length 1010 (7) eap: EAP session adding &reply:State = 0xbddf205cbad639b6 (7) [eap] = handled (7) } # authenticate = handled (7) Using Post-Auth-Type Challenge (7) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (7) Challenge { ... } # empty sub-section is ignored (7) session-state: Saving cached attributes (7) Framed-MTU = 1004 (7) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (7) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (7) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (7) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (7) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (7) Sent Access-Challenge Id 143 from 172.16.8.2:1812 to 172.16.5.252:60626 length 1074 (7) EAP-Message = 0x010903f219404eca979cb45bc073a8abb847c200051a30820516308202fea0030201020211008a792250abe52c526ceecf7fc942dd62300d06092a864886f70d01010b0500304f310b300906035504061302555331293027060355040a1320496e7465726e65742053656375726974792052657365617263682047726f7570311530130603550403130c4953524720526f6f74205831301e170d3230303930343030303030305a170d3235303931353136303030305a3032310b300906035504061302555331163014060355040a130d4c6574277320456e6372797074310b300906035504031302523430820122300d06092a864886f70d01010105000382010f003082010a0282010100b328dc7729d3e791bef3b70a00c7fbf2550b2522635336afe90820df0daf283ecdc6ab57b69da42519a5d2326d49a608b9c72fa19b93c520406b843120a28e30602560efd91a893f1f6971b2daea3f7341c4906f66fd7d9e58d877cfcd597544c9a10a7b9f3f1b0e3a666fb6 (7) Message-Authenticator = 0x00000000000000000000000000000000 (7) State = 0xbddf205cbad639b6f7c918f7a32a79be (7) Finished request Waking up in 4.9 seconds. (8) Received Access-Request Id 151 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (8) User-Name = "guest-1234" (8) Service-Type = Framed-User (8) Cisco-AVPair = "service-type=Framed" (8) Framed-MTU = 1485 (8) EAP-Message = 0x020900061900 (8) Message-Authenticator = 0x467362e4909ba6b2bcb1f814f90a8e17 (8) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (8) Cisco-AVPair = "method=dot1x" (8) Cisco-AVPair = "client-iif-id=1593968167" (8) Cisco-AVPair = "vlan-id=10" (8) NAS-IP-Address = 172.16.5.252 (8) NAS-Port-Type = Wireless-802.11 (8) NAS-Port = 518 (8) State = 0xbddf205cbad639b6f7c918f7a32a79be (8) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (8) Cisco-AVPair = "wlan-profile-name=MySSID" (8) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (8) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (8) Airespace-Wlan-Id = 3 (8) NAS-Identifier = "wlc-rz" (8) WLAN-Group-Cipher = 1027076 (8) WLAN-Pairwise-Cipher = 1027076 (8) WLAN-AKM-Suite = 1027073 (8) WLAN-Group-Mgmt-Cipher = 1027078 (8) Restoring &session-state (8) &session-state:Framed-MTU = 1004 (8) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (8) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (8) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (8) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (8) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (8) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (8) authorize { (8) policy filter_username { (8) if (&User-Name) { (8) if (&User-Name) -> TRUE (8) if (&User-Name) { (8) if (&User-Name =~ / /) { (8) if (&User-Name =~ / /) -> FALSE (8) if (&User-Name =~ /@[^@]*@/ ) { (8) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (8) if (&User-Name =~ /\.\./ ) { (8) if (&User-Name =~ /\.\./ ) -> FALSE (8) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (8) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (8) if (&User-Name =~ /\.$/) { (8) if (&User-Name =~ /\.$/) -> FALSE (8) if (&User-Name =~ /(a)\./) { (8) if (&User-Name =~ /(a)\./) -> FALSE (8) } # if (&User-Name) = notfound (8) } # policy filter_username = notfound (8) [preprocess] = ok (8) [digest] = noop (8) suffix: Checking for suffix after "@" (8) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (8) suffix: Found realm "NULL" (8) suffix: Adding Stripped-User-Name = "guest-1234" (8) suffix: Adding Realm = "NULL" (8) suffix: Authentication realm is LOCAL (8) [suffix] = ok (8) [chap] = noop (8) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (8) sql: --> guest-1234 (8) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (2) (8) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (8) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (8) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (8) sql: User found in radcheck table (8) sql: Conditional check items matched, merging assignment check items (8) sql: Cleartext-Password := "guest-1324" (8) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (8) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (8) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (8) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (8) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (8) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (8) sql: User found in the group table (8) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (8) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (8) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (8) sql: Group "wlanguest": Conditional check items matched (8) sql: Group "wlanguest": Merging assignment check items (8) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (8) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (8) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (8) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (2) (8) [sql] = ok (8) [mschap] = noop (8) eap: Peer sent EAP Response (code 2) ID 9 length 6 (8) eap: Continuing tunnel setup (8) [eap] = ok (8) } # authorize = ok (8) Found Auth-Type = eap (8) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (8) authenticate { (8) eap: Expiring EAP session with state 0xbddf205cbad639b6 (8) eap: Finished EAP session with state 0xbddf205cbad639b6 (8) eap: Previous EAP request found for state 0xbddf205cbad639b6, released from the list (8) eap: Peer sent packet with method EAP PEAP (25) (8) eap: Calling submodule eap_peap to process data (8) eap_peap: (TLS) Peer ACKed our handshake fragment (8) eap: Sending EAP Request (code 1) ID 10 length 671 (8) eap: EAP session adding &reply:State = 0xbddf205cb5d539b6 (8) [eap] = handled (8) } # authenticate = handled (8) Using Post-Auth-Type Challenge (8) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (8) Challenge { ... } # empty sub-section is ignored (8) session-state: Saving cached attributes (8) Framed-MTU = 1004 (8) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (8) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (8) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (8) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (8) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (8) Sent Access-Challenge Id 151 from 172.16.8.2:1812 to 172.16.5.252:60626 length 733 (8) EAP-Message = 0x010a029f1900a23c4b2ebe6fce241cfecfb4ef92e0893c47693b65e325135266c418bf3d953ceb4625c13f3fa8e613a021d5c838e1bfcaaeb5b7f6427525dd257cead876235410135e2cd32ec27401dc1e4c37b0011e606930080ef830ef9516d9d86dff41d8904e872c966f9d3ceeb1b38adbb9313016e355fd0f04de5c483e6b6e2d01e86df98d4c8a89c75306b88fb141fedacddc59dbfebf74fb83fae9911354811c8ec79448c1cec3acaabf5d3f1ff770ffcaf61035229dc0415f7a3d0cbdd269daab6a090acbde87b4c88b72a30c1803e6d20b62d5be9f6e7bce76bd26ac8548297e67cce78664e45a60ba120f80bcaaf153ed4f949ba0cca37e9c54336c3e6905e7be7fb370b60b11a208f42a5713e07cd4a1fb608f7765efd3894d7aec3a806f3d0e53a11eea052919663e7a26fa0c2a873dd95cc7f34df9af8eb06893308808160303014d0c0001490300174104312109a7ee5acf73dcd694bcb917f4a955ff78841f3906deb7c0f1d1c4948782b04d33b377 (8) Message-Authenticator = 0x00000000000000000000000000000000 (8) State = 0xbddf205cb5d539b6f7c918f7a32a79be (8) Finished request Waking up in 4.9 seconds. (9) Received Access-Request Id 159 from 172.16.5.252:60626 to 172.16.8.2:1812 length 537 (9) User-Name = "guest-1234" (9) Service-Type = Framed-User (9) Cisco-AVPair = "service-type=Framed" (9) Framed-MTU = 1485 (9) EAP-Message = 0x020a008819800000007e16030300461000004241044ce093fd4dfeeebd048e2ce8fb8efc34ca8d1fdc77bcdbe0ad9d93e617ea9b8541f29a2343ea685e7be70b4167f00b6805c09dadd8d9bd79da804a8535224e7114030300010116030300280000000000000000e416f188650d8fbf07d236130928761047142b4b03f1731ea2da32fa16f45740 (9) Message-Authenticator = 0xe4be2aca02e2e44d955c442a5196f794 (9) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (9) Cisco-AVPair = "method=dot1x" (9) Cisco-AVPair = "client-iif-id=1593968167" (9) Cisco-AVPair = "vlan-id=10" (9) NAS-IP-Address = 172.16.5.252 (9) NAS-Port-Type = Wireless-802.11 (9) NAS-Port = 518 (9) State = 0xbddf205cb5d539b6f7c918f7a32a79be (9) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (9) Cisco-AVPair = "wlan-profile-name=MySSID" (9) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (9) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (9) Airespace-Wlan-Id = 3 (9) NAS-Identifier = "wlc-rz" (9) WLAN-Group-Cipher = 1027076 (9) WLAN-Pairwise-Cipher = 1027076 (9) WLAN-AKM-Suite = 1027073 (9) WLAN-Group-Mgmt-Cipher = 1027078 (9) Restoring &session-state (9) &session-state:Framed-MTU = 1004 (9) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (9) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (9) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (9) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (9) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (9) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (9) authorize { (9) policy filter_username { (9) if (&User-Name) { (9) if (&User-Name) -> TRUE (9) if (&User-Name) { (9) if (&User-Name =~ / /) { (9) if (&User-Name =~ / /) -> FALSE (9) if (&User-Name =~ /@[^@]*@/ ) { (9) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (9) if (&User-Name =~ /\.\./ ) { (9) if (&User-Name =~ /\.\./ ) -> FALSE (9) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (9) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (9) if (&User-Name =~ /\.$/) { (9) if (&User-Name =~ /\.$/) -> FALSE (9) if (&User-Name =~ /(a)\./) { (9) if (&User-Name =~ /(a)\./) -> FALSE (9) } # if (&User-Name) = notfound (9) } # policy filter_username = notfound (9) [preprocess] = ok (9) [digest] = noop (9) suffix: Checking for suffix after "@" (9) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (9) suffix: Found realm "NULL" (9) suffix: Adding Stripped-User-Name = "guest-1234" (9) suffix: Adding Realm = "NULL" (9) suffix: Authentication realm is LOCAL (9) [suffix] = ok (9) [chap] = noop (9) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (9) sql: --> guest-1234 (9) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (3) (9) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (9) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (9) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (9) sql: User found in radcheck table (9) sql: Conditional check items matched, merging assignment check items (9) sql: Cleartext-Password := "guest-1324" (9) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (9) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (9) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (9) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (9) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (9) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (9) sql: User found in the group table (9) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (9) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (9) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (9) sql: Group "wlanguest": Conditional check items matched (9) sql: Group "wlanguest": Merging assignment check items (9) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (9) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (9) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (9) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (3) (9) [sql] = ok (9) [mschap] = noop (9) eap: Peer sent EAP Response (code 2) ID 10 length 136 (9) eap: Continuing tunnel setup (9) [eap] = ok (9) } # authorize = ok (9) Found Auth-Type = eap (9) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (9) authenticate { (9) eap: Expiring EAP session with state 0xbddf205cb5d539b6 (9) eap: Finished EAP session with state 0xbddf205cb5d539b6 (9) eap: Previous EAP request found for state 0xbddf205cb5d539b6, released from the list (9) eap: Peer sent packet with method EAP PEAP (25) (9) eap: Calling submodule eap_peap to process data (9) eap_peap: (TLS) EAP Peer says that the final record size will be 126 bytes (9) eap_peap: (TLS) EAP Got all data (126 bytes) (9) eap_peap: (TLS) Handshake state - Server SSLv3/TLS write server done (9) eap_peap: (TLS) recv TLS 1.2 Handshake, ClientKeyExchange (9) eap_peap: (TLS) Handshake state - Server SSLv3/TLS read client key exchange (9) eap_peap: (TLS) Handshake state - Server SSLv3/TLS read change cipher spec (9) eap_peap: (TLS) recv TLS 1.2 Handshake, Finished (9) eap_peap: (TLS) Handshake state - Server SSLv3/TLS read finished (9) eap_peap: (TLS) send TLS 1.2 ChangeCipherSpec (9) eap_peap: (TLS) Handshake state - Server SSLv3/TLS write change cipher spec (9) eap_peap: (TLS) send TLS 1.2 Handshake, Finished (9) eap_peap: (TLS) Handshake state - Server SSLv3/TLS write finished (9) eap_peap: (TLS) Handshake state - SSL negotiation finished successfully (9) eap_peap: (TLS) Connection Established (9) eap_peap: TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (9) eap_peap: TLS-Session-Version = "TLS 1.2" (9) eap: Sending EAP Request (code 1) ID 11 length 57 (9) eap: EAP session adding &reply:State = 0xbddf205cb4d439b6 (9) [eap] = handled (9) } # authenticate = handled (9) Using Post-Auth-Type Challenge (9) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (9) Challenge { ... } # empty sub-section is ignored (9) session-state: Saving cached attributes (9) Framed-MTU = 1004 (9) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (9) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (9) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (9) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (9) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (9) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, ClientKeyExchange" (9) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, Finished" (9) TLS-Session-Information = "(TLS) send TLS 1.2 ChangeCipherSpec" (9) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Finished" (9) TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (9) TLS-Session-Version = "TLS 1.2" (9) Sent Access-Challenge Id 159 from 172.16.8.2:1812 to 172.16.5.252:60626 length 115 (9) EAP-Message = 0x010b003919001403030001011603030028acbcc879c7f01494484b9261f7f457c80e65f4bed701a0ff79b54352d4338be4c7c32c94c4bc06f8 (9) Message-Authenticator = 0x00000000000000000000000000000000 (9) State = 0xbddf205cb4d439b6f7c918f7a32a79be (9) Finished request Waking up in 4.9 seconds. (10) Received Access-Request Id 167 from 172.16.5.252:60626 to 172.16.8.2:1812 length 407 (10) User-Name = "guest-1234" (10) Service-Type = Framed-User (10) Cisco-AVPair = "service-type=Framed" (10) Framed-MTU = 1485 (10) EAP-Message = 0x020b00061900 (10) Message-Authenticator = 0x5376d53e0f9f4db731480524f5fa7d4e (10) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (10) Cisco-AVPair = "method=dot1x" (10) Cisco-AVPair = "client-iif-id=1593968167" (10) Cisco-AVPair = "vlan-id=10" (10) NAS-IP-Address = 172.16.5.252 (10) NAS-Port-Type = Wireless-802.11 (10) NAS-Port = 518 (10) State = 0xbddf205cb4d439b6f7c918f7a32a79be (10) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (10) Cisco-AVPair = "wlan-profile-name=MySSID" (10) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (10) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (10) Airespace-Wlan-Id = 3 (10) NAS-Identifier = "wlc-rz" (10) WLAN-Group-Cipher = 1027076 (10) WLAN-Pairwise-Cipher = 1027076 (10) WLAN-AKM-Suite = 1027073 (10) WLAN-Group-Mgmt-Cipher = 1027078 (10) Restoring &session-state (10) &session-state:Framed-MTU = 1004 (10) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (10) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (10) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (10) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (10) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (10) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, ClientKeyExchange" (10) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, Finished" (10) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 ChangeCipherSpec" (10) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Finished" (10) &session-state:TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (10) &session-state:TLS-Session-Version = "TLS 1.2" (10) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (10) authorize { (10) policy filter_username { (10) if (&User-Name) { (10) if (&User-Name) -> TRUE (10) if (&User-Name) { (10) if (&User-Name =~ / /) { (10) if (&User-Name =~ / /) -> FALSE (10) if (&User-Name =~ /@[^@]*@/ ) { (10) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (10) if (&User-Name =~ /\.\./ ) { (10) if (&User-Name =~ /\.\./ ) -> FALSE (10) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (10) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (10) if (&User-Name =~ /\.$/) { (10) if (&User-Name =~ /\.$/) -> FALSE (10) if (&User-Name =~ /(a)\./) { (10) if (&User-Name =~ /(a)\./) -> FALSE (10) } # if (&User-Name) = notfound (10) } # policy filter_username = notfound (10) [preprocess] = ok (10) [digest] = noop (10) suffix: Checking for suffix after "@" (10) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (10) suffix: Found realm "NULL" (10) suffix: Adding Stripped-User-Name = "guest-1234" (10) suffix: Adding Realm = "NULL" (10) suffix: Authentication realm is LOCAL (10) [suffix] = ok (10) [chap] = noop (10) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (10) sql: --> guest-1234 (10) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (4) (10) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (10) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (10) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (10) sql: User found in radcheck table (10) sql: Conditional check items matched, merging assignment check items (10) sql: Cleartext-Password := "guest-1324" (10) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (10) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (10) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (10) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (10) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (10) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (10) sql: User found in the group table (10) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (10) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (10) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (10) sql: Group "wlanguest": Conditional check items matched (10) sql: Group "wlanguest": Merging assignment check items (10) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (10) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (10) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (10) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (4) 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 Localhost via UNIX socket, server version 10.11.4-MariaDB-1~deb12u1, protocol version 10 (10) [sql] = ok (10) [mschap] = noop (10) eap: Peer sent EAP Response (code 2) ID 11 length 6 (10) eap: Continuing tunnel setup (10) [eap] = ok (10) } # authorize = ok (10) Found Auth-Type = eap (10) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (10) authenticate { (10) eap: Expiring EAP session with state 0xbddf205cb4d439b6 (10) eap: Finished EAP session with state 0xbddf205cb4d439b6 (10) eap: Previous EAP request found for state 0xbddf205cb4d439b6, released from the list (10) eap: Peer sent packet with method EAP PEAP (25) (10) eap: Calling submodule eap_peap to process data (10) eap_peap: (TLS) Peer ACKed our handshake fragment. handshake is finished (10) eap_peap: Session established. Decoding tunneled attributes (10) eap_peap: PEAP state TUNNEL ESTABLISHED (10) eap: Sending EAP Request (code 1) ID 12 length 40 (10) eap: EAP session adding &reply:State = 0xbddf205cb7d339b6 (10) [eap] = handled (10) } # authenticate = handled (10) Using Post-Auth-Type Challenge (10) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (10) Challenge { ... } # empty sub-section is ignored (10) session-state: Saving cached attributes (10) Framed-MTU = 1004 (10) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (10) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (10) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (10) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (10) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (10) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, ClientKeyExchange" (10) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, Finished" (10) TLS-Session-Information = "(TLS) send TLS 1.2 ChangeCipherSpec" (10) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Finished" (10) TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (10) TLS-Session-Version = "TLS 1.2" (10) Sent Access-Challenge Id 167 from 172.16.8.2:1812 to 172.16.5.252:60626 length 98 (10) EAP-Message = 0x010c00281900170303001dacbcc879c7f0149565e13d561af9207a91d4f9a4c9067c2d7fdfa2c2de (10) Message-Authenticator = 0x00000000000000000000000000000000 (10) State = 0xbddf205cb7d339b6f7c918f7a32a79be (10) Finished request Waking up in 3.7 seconds. (11) Received Access-Request Id 175 from 172.16.5.252:60626 to 172.16.8.2:1812 length 446 (11) User-Name = "guest-1234" (11) Service-Type = Framed-User (11) Cisco-AVPair = "service-type=Framed" (11) Framed-MTU = 1485 (11) EAP-Message = 0x020c002d19001703030022000000000000000129b564137b7d16e50847019ca8952d0b6a4c159e5b92a7c2a544 (11) Message-Authenticator = 0x94664175f87944c1f636db5f2ccc12f1 (11) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (11) Cisco-AVPair = "method=dot1x" (11) Cisco-AVPair = "client-iif-id=1593968167" (11) Cisco-AVPair = "vlan-id=10" (11) NAS-IP-Address = 172.16.5.252 (11) NAS-Port-Type = Wireless-802.11 (11) NAS-Port = 518 (11) State = 0xbddf205cb7d339b6f7c918f7a32a79be (11) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (11) Cisco-AVPair = "wlan-profile-name=MySSID" (11) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (11) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (11) Airespace-Wlan-Id = 3 (11) NAS-Identifier = "wlc-rz" (11) WLAN-Group-Cipher = 1027076 (11) WLAN-Pairwise-Cipher = 1027076 (11) WLAN-AKM-Suite = 1027073 (11) WLAN-Group-Mgmt-Cipher = 1027078 (11) Restoring &session-state (11) &session-state:Framed-MTU = 1004 (11) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (11) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (11) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (11) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (11) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (11) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, ClientKeyExchange" (11) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, Finished" (11) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 ChangeCipherSpec" (11) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Finished" (11) &session-state:TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (11) &session-state:TLS-Session-Version = "TLS 1.2" (11) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (11) authorize { (11) policy filter_username { (11) if (&User-Name) { (11) if (&User-Name) -> TRUE (11) if (&User-Name) { (11) if (&User-Name =~ / /) { (11) if (&User-Name =~ / /) -> FALSE (11) if (&User-Name =~ /@[^@]*@/ ) { (11) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (11) if (&User-Name =~ /\.\./ ) { (11) if (&User-Name =~ /\.\./ ) -> FALSE (11) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (11) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (11) if (&User-Name =~ /\.$/) { (11) if (&User-Name =~ /\.$/) -> FALSE (11) if (&User-Name =~ /(a)\./) { (11) if (&User-Name =~ /(a)\./) -> FALSE (11) } # if (&User-Name) = notfound (11) } # policy filter_username = notfound (11) [preprocess] = ok (11) [digest] = noop (11) suffix: Checking for suffix after "@" (11) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (11) suffix: Found realm "NULL" (11) suffix: Adding Stripped-User-Name = "guest-1234" (11) suffix: Adding Realm = "NULL" (11) suffix: Authentication realm is LOCAL (11) [suffix] = ok (11) [chap] = noop (11) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (11) sql: --> guest-1234 (11) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (0) (11) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (11) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (11) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (11) sql: User found in radcheck table (11) sql: Conditional check items matched, merging assignment check items (11) sql: Cleartext-Password := "guest-1324" (11) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (11) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (11) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (11) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (11) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (11) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (11) sql: User found in the group table (11) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (11) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (11) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (11) sql: Group "wlanguest": Conditional check items matched (11) sql: Group "wlanguest": Merging assignment check items (11) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (11) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (11) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (11) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (0) (11) [sql] = ok (11) [mschap] = noop (11) eap: Peer sent EAP Response (code 2) ID 12 length 45 (11) eap: Continuing tunnel setup (11) [eap] = ok (11) } # authorize = ok (11) Found Auth-Type = eap (11) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (11) authenticate { (11) eap: Expiring EAP session with state 0xbddf205cb7d339b6 (11) eap: Finished EAP session with state 0xbddf205cb7d339b6 (11) eap: Previous EAP request found for state 0xbddf205cb7d339b6, released from the list (11) eap: Peer sent packet with method EAP PEAP (25) (11) eap: Calling submodule eap_peap to process data (11) eap_peap: (TLS) EAP Done initial handshake (11) eap_peap: Session established. Decoding tunneled attributes (11) eap_peap: PEAP state WAITING FOR INNER IDENTITY (11) eap_peap: Identity - guest-1234 (11) eap_peap: Got inner identity 'guest-1234' (11) eap_peap: Setting default EAP type for tunneled EAP session (11) eap_peap: Got tunneled request (11) eap_peap: EAP-Message = 0x020c000e01676173742d31323334 (11) eap_peap: Setting User-Name to guest-1234 (11) eap_peap: Sending tunneled request to inner-tunnel (11) eap_peap: EAP-Message = 0x020c000e01676173742d31323334 (11) eap_peap: FreeRADIUS-Proxied-To = 127.0.0.1 (11) eap_peap: User-Name = "guest-1234" (11) eap_peap: Service-Type = Framed-User (11) eap_peap: Cisco-AVPair = "service-type=Framed" (11) eap_peap: Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (11) eap_peap: Cisco-AVPair = "method=dot1x" (11) eap_peap: Cisco-AVPair = "client-iif-id=1593968167" (11) eap_peap: Cisco-AVPair = "vlan-id=10" (11) eap_peap: Cisco-AVPair = "cisco-wlan-ssid=MySSID" (11) eap_peap: Cisco-AVPair = "wlan-profile-name=MySSID" (11) eap_peap: Framed-MTU = 1485 (11) eap_peap: NAS-IP-Address = 172.16.5.252 (11) eap_peap: NAS-Port-Type = Wireless-802.11 (11) eap_peap: NAS-Port = 518 (11) eap_peap: Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (11) eap_peap: Calling-Station-Id = "dc-39-6f-9e-dc-d1" (11) eap_peap: Airespace-Wlan-Id = 3 (11) eap_peap: NAS-Identifier = "wlc-rz" (11) eap_peap: WLAN-Group-Cipher = 1027076 (11) eap_peap: WLAN-Pairwise-Cipher = 1027076 (11) eap_peap: WLAN-AKM-Suite = 1027073 (11) eap_peap: WLAN-Group-Mgmt-Cipher = 1027078 (11) eap_peap: Event-Timestamp = "Jan 9 2024 01:13:19 CET" (11) Virtual server inner-tunnel received request (11) EAP-Message = 0x020c000e01676173742d31323334 (11) FreeRADIUS-Proxied-To = 127.0.0.1 (11) User-Name = "guest-1234" (11) Service-Type = Framed-User (11) Cisco-AVPair = "service-type=Framed" (11) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (11) Cisco-AVPair = "method=dot1x" (11) Cisco-AVPair = "client-iif-id=1593968167" (11) Cisco-AVPair = "vlan-id=10" (11) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (11) Cisco-AVPair = "wlan-profile-name=MySSID" (11) Framed-MTU = 1485 (11) NAS-IP-Address = 172.16.5.252 (11) NAS-Port-Type = Wireless-802.11 (11) NAS-Port = 518 (11) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (11) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (11) Airespace-Wlan-Id = 3 (11) NAS-Identifier = "wlc-rz" (11) WLAN-Group-Cipher = 1027076 (11) WLAN-Pairwise-Cipher = 1027076 (11) WLAN-AKM-Suite = 1027073 (11) WLAN-Group-Mgmt-Cipher = 1027078 (11) Event-Timestamp = "Jan 9 2024 01:13:19 CET" (11) WARNING: Outer and inner identities are the same. User privacy is compromised. (11) server inner-tunnel { (11) # Executing section authorize from file /etc/freeradius/sites-enabled/inner-tunnel (11) authorize { (11) policy filter_username { (11) if (&User-Name) { (11) if (&User-Name) -> TRUE (11) if (&User-Name) { (11) if (&User-Name =~ / /) { (11) if (&User-Name =~ / /) -> FALSE (11) if (&User-Name =~ /@[^@]*@/ ) { (11) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (11) if (&User-Name =~ /\.\./ ) { (11) if (&User-Name =~ /\.\./ ) -> FALSE (11) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (11) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (11) if (&User-Name =~ /\.$/) { (11) if (&User-Name =~ /\.$/) -> FALSE (11) if (&User-Name =~ /(a)\./) { (11) if (&User-Name =~ /(a)\./) -> FALSE (11) } # if (&User-Name) = notfound (11) } # policy filter_username = notfound (11) [chap] = noop (11) [mschap] = noop (11) suffix: Checking for suffix after "@" (11) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (11) suffix: Found realm "NULL" (11) suffix: Adding Stripped-User-Name = "guest-1234" (11) suffix: Adding Realm = "NULL" (11) suffix: Authentication realm is LOCAL (11) [suffix] = ok (11) update control { (11) &Proxy-To-Realm := LOCAL (11) } # update control = noop (11) eap: Peer sent EAP Response (code 2) ID 12 length 14 (11) eap: EAP-Identity reply, returning 'ok' so we can short-circuit the rest of authorize (11) [eap] = ok (11) } # authorize = ok (11) Found Auth-Type = eap (11) # Executing group from file /etc/freeradius/sites-enabled/inner-tunnel (11) authenticate { (11) eap: Peer sent packet with method EAP Identity (1) (11) eap: Calling submodule eap_mschapv2 to process data (11) eap_mschapv2: Issuing Challenge (11) eap: Sending EAP Request (code 1) ID 13 length 50 (11) eap: EAP session adding &reply:State = 0xf6a31d9cf6ae0731 (11) [eap] = handled (11) } # authenticate = handled (11) } # server inner-tunnel (11) Virtual server sending reply (11) EAP-Message = 0x010d00321a010d002d10df54118f49d309058e83865fb4e9dee8524144495553204865696d736368756c65204c656e646572 (11) Message-Authenticator = 0x00000000000000000000000000000000 (11) State = 0xf6a31d9cf6ae073144da8e489e4d5069 (11) eap_peap: Got tunneled reply code 11 (11) eap_peap: EAP-Message = 0x010d00321a010d002d10df54118f49d309058e83865fb4e9dee8524144495553204865696d736368756c65204c656e646572 (11) eap_peap: Message-Authenticator = 0x00000000000000000000000000000000 (11) eap_peap: State = 0xf6a31d9cf6ae073144da8e489e4d5069 (11) eap_peap: Got tunneled reply RADIUS code 11 (11) eap_peap: EAP-Message = 0x010d00321a010d002d10df54118f49d309058e83865fb4e9dee8524144495553204865696d736368756c65204c656e646572 (11) eap_peap: Message-Authenticator = 0x00000000000000000000000000000000 (11) eap_peap: State = 0xf6a31d9cf6ae073144da8e489e4d5069 (11) eap_peap: Got tunneled Access-Challenge (11) eap: Sending EAP Request (code 1) ID 13 length 81 (11) eap: EAP session adding &reply:State = 0xbddf205cb6d239b6 (11) [eap] = handled (11) } # authenticate = handled (11) Using Post-Auth-Type Challenge (11) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (11) Challenge { ... } # empty sub-section is ignored (11) session-state: Saving cached attributes (11) Framed-MTU = 1004 (11) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (11) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (11) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (11) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (11) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (11) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, ClientKeyExchange" (11) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, Finished" (11) TLS-Session-Information = "(TLS) send TLS 1.2 ChangeCipherSpec" (11) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Finished" (11) TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (11) TLS-Session-Version = "TLS 1.2" (11) Sent Access-Challenge Id 175 from 172.16.8.2:1812 to 172.16.5.252:60626 length 139 (11) EAP-Message = 0x010d005119001703030046acbcc879c7f01496915ff1bb179e2de85508378c1f59039a13e8c663902ce01b95fcedbdfd88ca2a9401fd151dc22744e8d4f13a61f301099723ddfd9fc5730807e8b510b260 (11) Message-Authenticator = 0x00000000000000000000000000000000 (11) State = 0xbddf205cb6d239b6f7c918f7a32a79be (11) Finished request Waking up in 3.7 seconds. (12) Received Access-Request Id 183 from 172.16.5.252:60626 to 172.16.8.2:1812 length 500 (12) User-Name = "guest-1234" (12) Service-Type = Framed-User (12) Cisco-AVPair = "service-type=Framed" (12) Framed-MTU = 1485 (12) EAP-Message = 0x020d0063190017030300580000000000000002612b3b662edcc2d102d59a32e1da0324568db3f23139beedfb08ea348935c36a4d7de5b4d6c134fd649cb3a063354f09578043e8833902ed44908e51b55ca18c7e218bce31b6664a8f5dded8db52b53d (12) Message-Authenticator = 0x07b495cf70d56a8710de467bf1137e41 (12) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (12) Cisco-AVPair = "method=dot1x" (12) Cisco-AVPair = "client-iif-id=1593968167" (12) Cisco-AVPair = "vlan-id=10" (12) NAS-IP-Address = 172.16.5.252 (12) NAS-Port-Type = Wireless-802.11 (12) NAS-Port = 518 (12) State = 0xbddf205cb6d239b6f7c918f7a32a79be (12) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (12) Cisco-AVPair = "wlan-profile-name=MySSID" (12) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (12) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (12) Airespace-Wlan-Id = 3 (12) NAS-Identifier = "wlc-rz" (12) WLAN-Group-Cipher = 1027076 (12) WLAN-Pairwise-Cipher = 1027076 (12) WLAN-AKM-Suite = 1027073 (12) WLAN-Group-Mgmt-Cipher = 1027078 (12) Restoring &session-state (12) &session-state:Framed-MTU = 1004 (12) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (12) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (12) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (12) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (12) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (12) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, ClientKeyExchange" (12) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, Finished" (12) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 ChangeCipherSpec" (12) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Finished" (12) &session-state:TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (12) &session-state:TLS-Session-Version = "TLS 1.2" (12) # Executing section authorize from file /etc/freeradius/sites-enabled/school_8021x (12) authorize { (12) policy filter_username { (12) if (&User-Name) { (12) if (&User-Name) -> TRUE (12) if (&User-Name) { (12) if (&User-Name =~ / /) { (12) if (&User-Name =~ / /) -> FALSE (12) if (&User-Name =~ /@[^@]*@/ ) { (12) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (12) if (&User-Name =~ /\.\./ ) { (12) if (&User-Name =~ /\.\./ ) -> FALSE (12) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (12) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (12) if (&User-Name =~ /\.$/) { (12) if (&User-Name =~ /\.$/) -> FALSE (12) if (&User-Name =~ /(a)\./) { (12) if (&User-Name =~ /(a)\./) -> FALSE (12) } # if (&User-Name) = notfound (12) } # policy filter_username = notfound (12) [preprocess] = ok (12) [digest] = noop (12) suffix: Checking for suffix after "@" (12) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (12) suffix: Found realm "NULL" (12) suffix: Adding Stripped-User-Name = "guest-1234" (12) suffix: Adding Realm = "NULL" (12) suffix: Authentication realm is LOCAL (12) [suffix] = ok (12) [chap] = noop (12) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (12) sql: --> guest-1234 (12) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (5) (12) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (12) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (12) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (12) sql: User found in radcheck table (12) sql: Conditional check items matched, merging assignment check items (12) sql: Cleartext-Password := "guest-1324" (12) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (12) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (12) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (12) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (12) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (12) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (12) sql: User found in the group table (12) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (12) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Group "wlanguest": Conditional check items matched (12) sql: Group "wlanguest": Merging assignment check items (12) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (12) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (5) (12) [sql] = ok (12) [mschap] = noop (12) eap: Peer sent EAP Response (code 2) ID 13 length 99 (12) eap: Continuing tunnel setup (12) [eap] = ok (12) } # authorize = ok (12) Found Auth-Type = eap (12) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (12) authenticate { (12) eap: Expiring EAP session with state 0xf6a31d9cf6ae0731 (12) eap: Finished EAP session with state 0xbddf205cb6d239b6 (12) eap: Previous EAP request found for state 0xbddf205cb6d239b6, released from the list (12) eap: Peer sent packet with method EAP PEAP (25) (12) eap: Calling submodule eap_peap to process data (12) eap_peap: (TLS) EAP Done initial handshake (12) eap_peap: Session established. Decoding tunneled attributes (12) eap_peap: PEAP state phase2 (12) eap_peap: EAP method MSCHAPv2 (26) (12) eap_peap: Got tunneled request (12) eap_peap: EAP-Message = 0x020d00441a020d003f31ce8588fb9bc59713c659b8516d1d241800000000000000000ba37e97f4871912a867e5827faff92a8c0913cc041d553c00676173742d31323334 (12) eap_peap: Setting User-Name to guest-1234 (12) eap_peap: Sending tunneled request to inner-tunnel (12) eap_peap: EAP-Message = 0x020d00441a020d003f31ce8588fb9bc59713c659b8516d1d241800000000000000000ba37e97f4871912a867e5827faff92a8c0913cc041d553c00676173742d31323334 (12) eap_peap: FreeRADIUS-Proxied-To = 127.0.0.1 (12) eap_peap: User-Name = "guest-1234" (12) eap_peap: State = 0xf6a31d9cf6ae073144da8e489e4d5069 (12) eap_peap: Service-Type = Framed-User (12) eap_peap: Cisco-AVPair = "service-type=Framed" (12) eap_peap: Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (12) eap_peap: Cisco-AVPair = "method=dot1x" (12) eap_peap: Cisco-AVPair = "client-iif-id=1593968167" (12) eap_peap: Cisco-AVPair = "vlan-id=10" (12) eap_peap: Cisco-AVPair = "cisco-wlan-ssid=MySSID" (12) eap_peap: Cisco-AVPair = "wlan-profile-name=MySSID" (12) eap_peap: Framed-MTU = 1485 (12) eap_peap: NAS-IP-Address = 172.16.5.252 (12) eap_peap: NAS-Port-Type = Wireless-802.11 (12) eap_peap: NAS-Port = 518 (12) eap_peap: Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (12) eap_peap: Calling-Station-Id = "dc-39-6f-9e-dc-d1" (12) eap_peap: Airespace-Wlan-Id = 3 (12) eap_peap: NAS-Identifier = "wlc-rz" (12) eap_peap: WLAN-Group-Cipher = 1027076 (12) eap_peap: WLAN-Pairwise-Cipher = 1027076 (12) eap_peap: WLAN-AKM-Suite = 1027073 (12) eap_peap: WLAN-Group-Mgmt-Cipher = 1027078 (12) eap_peap: Event-Timestamp = "Jan 9 2024 01:13:19 CET" (12) Virtual server inner-tunnel received request (12) EAP-Message = 0x020d00441a020d003f31ce8588fb9bc59713c659b8516d1d241800000000000000000ba37e97f4871912a867e5827faff92a8c0913cc041d553c00676173742d31323334 (12) FreeRADIUS-Proxied-To = 127.0.0.1 (12) User-Name = "guest-1234" (12) State = 0xf6a31d9cf6ae073144da8e489e4d5069 (12) Service-Type = Framed-User (12) Cisco-AVPair = "service-type=Framed" (12) Cisco-AVPair = "audit-session-id=FC0510AC00087FE1EB90E75D" (12) Cisco-AVPair = "method=dot1x" (12) Cisco-AVPair = "client-iif-id=1593968167" (12) Cisco-AVPair = "vlan-id=10" (12) Cisco-AVPair = "cisco-wlan-ssid=MySSID" (12) Cisco-AVPair = "wlan-profile-name=MySSID" (12) Framed-MTU = 1485 (12) NAS-IP-Address = 172.16.5.252 (12) NAS-Port-Type = Wireless-802.11 (12) NAS-Port = 518 (12) Called-Station-Id = "50-2f-a8-ce-da-20:MySSID" (12) Calling-Station-Id = "dc-39-6f-9e-dc-d1" (12) Airespace-Wlan-Id = 3 (12) NAS-Identifier = "wlc-rz" (12) WLAN-Group-Cipher = 1027076 (12) WLAN-Pairwise-Cipher = 1027076 (12) WLAN-AKM-Suite = 1027073 (12) WLAN-Group-Mgmt-Cipher = 1027078 (12) Event-Timestamp = "Jan 9 2024 01:13:19 CET" (12) WARNING: Outer and inner identities are the same. User privacy is compromised. (12) server inner-tunnel { (12) session-state: No cached attributes (12) # Executing section authorize from file /etc/freeradius/sites-enabled/inner-tunnel (12) authorize { (12) policy filter_username { (12) if (&User-Name) { (12) if (&User-Name) -> TRUE (12) if (&User-Name) { (12) if (&User-Name =~ / /) { (12) if (&User-Name =~ / /) -> FALSE (12) if (&User-Name =~ /@[^@]*@/ ) { (12) if (&User-Name =~ /@[^@]*@/ ) -> FALSE (12) if (&User-Name =~ /\.\./ ) { (12) if (&User-Name =~ /\.\./ ) -> FALSE (12) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) { (12) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (12) if (&User-Name =~ /\.$/) { (12) if (&User-Name =~ /\.$/) -> FALSE (12) if (&User-Name =~ /(a)\./) { (12) if (&User-Name =~ /(a)\./) -> FALSE (12) } # if (&User-Name) = notfound (12) } # policy filter_username = notfound (12) [chap] = noop (12) [mschap] = noop (12) suffix: Checking for suffix after "@" (12) suffix: No '@' in User-Name = "guest-1234", looking up realm NULL (12) suffix: Found realm "NULL" (12) suffix: Adding Stripped-User-Name = "guest-1234" (12) suffix: Adding Realm = "NULL" (12) suffix: Authentication realm is LOCAL (12) [suffix] = ok (12) update control { (12) &Proxy-To-Realm := LOCAL (12) } # update control = noop (12) eap: Peer sent EAP Response (code 2) ID 13 length 68 (12) eap: No EAP Start, assuming it's an on-going EAP conversation (12) [eap] = updated (12) [files] = noop (12) sql: EXPAND %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} (12) sql: --> guest-1234 (12) sql: SQL-User-Name set to 'guest-1234' rlm_sql (sql): Reserved connection (1) (12) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (12) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (12) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'guest-1234' ORDER BY id (12) sql: User found in radcheck table (12) sql: Conditional check items matched, merging assignment check items (12) sql: Cleartext-Password := "guest-1324" (12) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (12) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (12) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'guest-1234' ORDER BY id (12) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (12) sql: --> SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (12) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'guest-1234' ORDER BY priority (12) sql: User found in the group table (12) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (12) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Group "wlanguest": Conditional check items matched (12) sql: Group "wlanguest": Merging assignment check items (12) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (12) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'wlanguest' ORDER BY id (12) sql: Group "wlanguest": Merging reply items rlm_sql (sql): Released connection (1) (12) [sql] = ok (12) [expiration] = noop (12) [logintime] = noop (12) pap: WARNING: Auth-Type already set. Not setting to PAP (12) [pap] = noop (12) } # authorize = updated (12) Found Auth-Type = eap (12) # Executing group from file /etc/freeradius/sites-enabled/inner-tunnel (12) authenticate { (12) eap: Expiring EAP session with state 0xf6a31d9cf6ae0731 (12) eap: Finished EAP session with state 0xf6a31d9cf6ae0731 (12) eap: Previous EAP request found for state 0xf6a31d9cf6ae0731, released from the list (12) eap: Peer sent packet with method EAP MSCHAPv2 (26) (12) eap: Calling submodule eap_mschapv2 to process data (12) eap_mschapv2: # Executing group from file /etc/freeradius/sites-enabled/inner-tunnel (12) eap_mschapv2: authenticate { (12) mschap: Found Cleartext-Password, hashing to create NT-Password (12) mschap: Creating challenge hash with username: guest-1234 (12) mschap: Client is using MS-CHAPv2 (12) mschap: Executing: /usr/bin/ntlm_auth --allow-mschapv2 --request-nt-key --domain=lmn --require-membership-of=lmn\wifi --username=%{%{Stripped-User-Name}:-%{%{User-Name}:-None}} --challenge=%{%{mschap:Challenge}:-00} --nt-response=%{%{mschap:NT-Response}:-00}: (12) mschap: EXPAND --username=%{%{Stripped-User-Name}:-%{%{User-Name}:-None}} (12) mschap: --> --username=guest-1234 (12) mschap: Creating challenge hash with username: guest-1234 (12) mschap: EXPAND --challenge=%{%{mschap:Challenge}:-00} (12) mschap: --> --challenge=d5ea76afcbd8b221 (12) mschap: EXPAND --nt-response=%{%{mschap:NT-Response}:-00} (12) mschap: --> --nt-response=0ba37e97f4871912a867e5827faff92a8c0913cc041d553c (12) mschap: ERROR: Program returned code (1) and output 'The attempted logon is invalid. This is either due to a bad username or authentication information. (0xc000006d)' (12) mschap: External script failed (12) mschap: ERROR: External script says: The attempted logon is invalid. This is either due to a bad username or authentication information. (0xc000006d) (12) mschap: ERROR: MS-CHAP2-Response is incorrect (12) eap_mschapv2: [mschap] = reject (12) eap_mschapv2: } # authenticate = reject (12) eap_mschapv2: MSCHAP-Error: E=691 R=1 C=d5792164bc5007872544f6bea0d25eca V=3 M=Authentication rejected (12) eap_mschapv2: Found new challenge from MS-CHAP-Error: err=691 retry=1 challenge=d5792164bc5007872544f6bea0d25eca (12) eap_mschapv2: ERROR: MSCHAP Failure (12) eap: Sending EAP Request (code 1) ID 14 length 83 (12) eap: EAP session adding &reply:State = 0xf6a31d9cf7ad0731 (12) [eap] = handled (12) } # authenticate = handled (12) } # server inner-tunnel (12) Virtual server sending reply (12) EAP-Message = 0x010e00531a040d004e453d36393120523d3120433d643537393231363462633530303738373235343466366265613064323565636120563d33204d3d41757468656e7469636174696f6e2072656a6563746564 (12) Message-Authenticator = 0x00000000000000000000000000000000 (12) State = 0xf6a31d9cf7ad073144da8e489e4d5069 (12) eap_peap: Got tunneled reply code 11 (12) eap_peap: EAP-Message = 0x010e00531a040d004e453d36393120523d3120433d643537393231363462633530303738373235343466366265613064323565636120563d33204d3d41757468656e7469636174696f6e2072656a6563746564 (12) eap_peap: Message-Authenticator = 0x00000000000000000000000000000000 (12) eap_peap: State = 0xf6a31d9cf7ad073144da8e489e4d5069 (12) eap_peap: Got tunneled reply RADIUS code 11 (12) eap_peap: EAP-Message = 0x010e00531a040d004e453d36393120523d3120433d643537393231363462633530303738373235343466366265613064323565636120563d33204d3d41757468656e7469636174696f6e2072656a6563746564 (12) eap_peap: Message-Authenticator = 0x00000000000000000000000000000000 (12) eap_peap: State = 0xf6a31d9cf7ad073144da8e489e4d5069 (12) eap_peap: Got tunneled Access-Challenge (12) eap: Sending EAP Request (code 1) ID 14 length 114 (12) eap: EAP session adding &reply:State = 0xbddf205cb1d139b6 (12) [eap] = handled (12) } # authenticate = handled (12) Using Post-Auth-Type Challenge (12) # Executing group from file /etc/freeradius/sites-enabled/school_8021x (12) Challenge { ... } # empty sub-section is ignored (12) session-state: Saving cached attributes (12) Framed-MTU = 1004 (12) TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (12) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (12) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (12) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (12) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (12) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, ClientKeyExchange" (12) TLS-Session-Information = "(TLS) recv TLS 1.2 Handshake, Finished" (12) TLS-Session-Information = "(TLS) send TLS 1.2 ChangeCipherSpec" (12) TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Finished" (12) TLS-Session-Cipher-Suite = "ECDHE-RSA-AES256-GCM-SHA384" (12) TLS-Session-Version = "TLS 1.2" (12) Sent Access-Challenge Id 183 from 172.16.8.2:1812 to 172.16.5.252:60626 length 172 (12) EAP-Message = 0x010e007219001703030067acbcc879c7f014975048c725f1bdd58720924cb98185edbe87e1cbd52be48d1664eef7bdffe3548f1e7b0d5047c7e60b59261276208a1b1b1957eb47d153e7393b0cabef8771c2861f46f0b37bf6af94595005e9efbcb5575fbfc87655ed3baace403e894e467a (12) Message-Authenticator = 0x00000000000000000000000000000000 (12) State = 0xbddf205cb1d139b6f7c918f7a32a79be (12) Finished request Waking up in 3.6 seconds.

2 7

Blank Page after Login
by Aghyad Fares 09 Jan '24

09 Jan '24

I hope this email finds you well. I am getting a blank page after I log in to the daloRADIUS login page http://127.0.0.1:8000/login.php and i am using administrator as a username and radius as a password [image: image.png] after i login i got a blank page [image: image.png] and in the error.log file ( var/log/httpd/daloradius/operators ) i got this : [Wed Jan 03 17:54:00.236092 2024] [:error] [pid 74529] [client 127.0.0.1:51586] PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /var/www/daloradius/app/operators/lang/en.php on line 35 [Wed Jan 03 17:55:43.419876 2024] [:error] [pid 70963] [client 127.0.0.1:51590] PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /var/www/daloradius/app/operators/dologin.php on line 79, referer: http://127.0.0.1:8000/login.php [Wed Jan 03 17:55:43.432125 2024] [:error] [pid 70963] [client 127.0.0.1:51590] PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /var/www/daloradius/app/operators/lang/en.php on line 35, referer: http://127.0.0.1:8000/login.php [Wed Jan 03 17:55:43.432734 2024] [:error] [pid 70963] [client 127.0.0.1:51590] PHP Fatal error: Arrays are not allowed as constants in /var/www/daloradius/app/common/includes/layout.php on line 32, referer: http://127.0.0.1:8000/login.php Would you help me? I'm looking forward to hearing from you soon. Aghyad

4 3

eap_peap: ERROR: (TLS) Alert read:fatal:unknown CA
by Dario Barbon 09 Jan '24

09 Jan '24

Hi all, I'm trying to configure Freeradius (version 3.2.3 on Ubuntu 22.04) to perform either EAP-TLS and EAP-PEAP MSCHAPv2. I need MSCHAPv2 as alternative configuration for Android 11 devices because we are experiencing the deletion of client certificates and I'm not understand why this issue happens. The EAP-TLS configuration works fine with self signed CA and client certs signed by our private CA (except for Android 11 devices as I said). Below are the logs when I try to connect to Freeradius using MSCHAPv2 (I enabled "bob" user): (6) Received Access-Request Id 194 from 172.31.190.2:32773 to 172.31.189.84:1812 length 291 (6) User-Name = "bob" (6) Chargeable-User-Identity = 0x00 (6) Location-Capable = Civic-Location (6) Calling-Station-Id = "9a-8b-7b-d9-b0-cd" (6) Called-Station-Id = "04-5f-b9-81-69-80:PIT_Tag" (6) NAS-Port = 1 (6) Cisco-AVPair = "audit-session-id=ac1fc7020000006765980031" (6) Acct-Session-Id = "65980031/9a:8b:7b:d9:b0:cd/108" (6) NAS-IP-Address = 172.31.190.2 (6) NAS-Identifier = "Cisco_b8:24:65" (6) Airespace-Wlan-Id = 2 (6) Service-Type = Framed-User (6) Framed-MTU = 1300 (6) NAS-Port-Type = Wireless-802.11 (6) Tunnel-Type:0 = VLAN (6) Tunnel-Medium-Type:0 = IEEE-802 (6) Tunnel-Private-Group-Id:0 = "190" (6) EAP-Message = 0x0207001119800000000715030300020230 (6) State = 0xc9ea21cfcced38f11a447042a250057a (6) Message-Authenticator = 0xc33e5f6f8276b61b9ab132b4687b2bdb (6) Restoring &session-state (6) &session-state:Framed-MTU = 994 (6) &session-state:TLS-Session-Information = "(TLS) recv TLS 1.3 Handshake, ClientHello" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHello" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, Certificate" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerKeyExchange" (6) &session-state:TLS-Session-Information = "(TLS) send TLS 1.2 Handshake, ServerHelloDone" (6) # Executing section authorize from file /etc/freeradius/sites-enabled/tlcamb-tag (6) authorize { (6) [preprocess] = ok (6) eap: Peer sent EAP Response (code 2) ID 7 length 17 (6) eap: Continuing tunnel setup (6) [eap] = ok (6) } # authorize = ok (6) Found Auth-Type = eap (6) # Executing group from file /etc/freeradius/sites-enabled/tlcamb-tag (6) authenticate { (6) eap: Expiring EAP session with state 0xc9ea21cfcced38f1 (6) eap: Finished EAP session with state 0xc9ea21cfcced38f1 (6) eap: Previous EAP request found for state 0xc9ea21cfcced38f1, released from the list (6) eap: Peer sent packet with method EAP PEAP (25) (6) eap: Calling submodule eap_peap to process data (6) eap_peap: (TLS) EAP Peer says that the final record size will be 7 bytes (6) eap_peap: (TLS) EAP Got all data (7 bytes) (6) eap_peap: (TLS) recv TLS 1.2 Alert, fatal unknown_ca (6) eap_peap: (TLS) The client is informing us that it does not recognize the CA used to issue the server certificate. Please update the client so that it knows about the CA. (6) eap_peap: ERROR: (TLS) Alert read:fatal:unknown CA tls: Removing session f3cdb8967121c0da520898ab8e5f39f803d24f44133c7ba63a4cbfb0ea161412 from the cache tls: Could not remove persisted session file /var/log/freeradius/tlscache/f3cdb8967121c0da520898ab8e5f39f803d24f44133c7ba63a4cbfb0ea161412.asn1: Permission denied (6) eap_peap: (TLS) Server : Need to read more data: error (6) eap_peap: ERROR: (TLS) Failed reading from OpenSSL: error:0A000418:SSL routines::tlsv1 alert unknown ca (6) eap_peap: (TLS) In Handshake Phase (6) eap_peap: (TLS) Application data. (6) eap_peap: ERROR: (TLS) Cannot continue, as the peer is misbehaving. (6) eap_peap: ERROR: [eaptls process] = fail (6) eap: ERROR: Failed continuing EAP PEAP (25) session. EAP sub-module failed (6) eap: Sending EAP Failure (code 4) ID 7 length 4 (6) eap: Failed in EAP select (6) [eap] = invalid (6) } # authenticate = invalid (6) Failed to authenticate the user (6) Using Post-Auth-Type Reject (6) # Executing group from file /etc/freeradius/sites-enabled/tlcamb-tag (6) Post-Auth-Type REJECT { (6) attr_filter.access_reject: EXPAND %{User-Name} (6) attr_filter.access_reject: --> bob (6) attr_filter.access_reject: Matched entry DEFAULT at line 11 (6) [attr_filter.access_reject] = updated (6) } # Post-Auth-Type REJECT = updated (6) Delaying response for 1.000000 seconds Waking up in 0.3 seconds. Waking up in 0.6 seconds. (6) Sending delayed response (6) Sent Access-Reject Id 194 from 172.31.189.84:1812 to 172.31.190.2:32773 length 44 (6) EAP-Message = 0x04070004 (6) Message-Authenticator = 0x00000000000000000000000000000000 Waking up in 3.9 seconds. (0) Cleaning up request packet ID 188 with timestamp +10 due to cleanup_delay was reached (1) Cleaning up request packet ID 189 with timestamp +10 due to cleanup_delay was reached (2) Cleaning up request packet ID 190 with timestamp +10 due to cleanup_delay was reached (3) Cleaning up request packet ID 191 with timestamp +10 due to cleanup_delay was reached (4) Cleaning up request packet ID 192 with timestamp +10 due to cleanup_delay was reached (5) Cleaning up request packet ID 193 with timestamp +10 due to cleanup_delay was reached (6) Cleaning up request packet ID 194 with timestamp +10 due to cleanup_delay was reached Ready to process requests Thanks and best regards. Dario Barbon

4 16

back-slash in username that making escape character issue
by Eric Lin 08 Jan '24

08 Jan '24

Hello, The story: I got an issue for escaping character issue when back-slash is in username. Recently, my company has introduced Azure MFA. On Microsoft RD Gateway, it sends radius auth to Microsoft NPS server in order to integrate to the Azure MFA authentication workflow. Everything works fine; however, NPS did not support account bypassing. Meaning, all radius auth requests sent to the NPS server will be enforced to use MFA. So we need to put a radius proxy in-between RD gateway and NPS to filter/redirect the radius auth requests for these special accounts. We plan to use freeradius as radius proxy for this purpose. The flow is RD client --> RD gateway --radius auth request --> freeradius --proxy to--> NPS. On the freeradius, normal accounts will be proxied to the NPS server and special accounts will be proxied to another radius server. The whole workflow looks good and only issue is the escaping characters (\n, \r, and \t). The username sent by RD Gateway server is DomainA\\username format The issue: for account without escape characters, it works fine as follows. ----------------------------------- Ready to process requests (0) Received Access-Request Id 3 from 10.88.18.245:56346 to 10.88.18.212:1812 length 153 (0) Service-Type = Sip-session (0) User-Name = "domainA\\eric" (0) Called-Station-Id = "UserAuthType:PW" (0) MS-Network-Access-Server-Type = Terminal-Server-Gateway (0) NAS-Port-Type = Virtual (0) Proxy-State = 0xfe800000000000003558d7bb169c1a1f0000001e (0) Message-Authenticator = 0xf2ac68355d495175cda15b87b7157ed5 (0) # Executing section authorize from file /etc/freeradius/3.0/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 !~ /(a)(.+)\.(.+)$/)) { (0) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (0) if (&User-Name =~ /\.$/) { (0) if (&User-Name =~ /\.$/) -> FALSE (0) if (&User-Name =~ /(a)\./) { (0) if (&User-Name =~ /(a)\./) -> FALSE (0) } # if (&User-Name) = notfound (0) } # policy filter_username = notfound (0) [preprocess] = ok (0) [chap] = noop (0) [mschap] = noop (0) [digest] = noop (0) ntdomain: Checking for prefix before "\" (0) ntdomain: Looking up realm "domainA" for User-Name = "domainA\eric" (0) ntdomain: Found realm "domainA" (0) ntdomain: Adding Realm = "domainA" (0) ntdomain: Proxying request from user domainA\eric to realm domainA (0) ntdomain: Preparing to proxy authentication request to realm "domainA" ----------------------------------- but accounts starting with r, t and n will encounter escape character issue ----------------------------------- Ready to process requests (0) Received Access-Request Id 3 from 10.88.18.245:56346 to 10.88.18.212:1812 length 153 (0) Service-Type = Sip-session (0) User-Name = "domainA\tee" (0) Called-Station-Id = "UserAuthType:PW" (0) MS-Network-Access-Server-Type = Terminal-Server-Gateway (0) NAS-Port-Type = Virtual (0) Proxy-State = 0xfe800000000000003558d7bb169c1a1f0000001e (0) Message-Authenticator = 0xf2ac68355d495175cda15b87b7157ed5 (0) # Executing section authorize from file /etc/freeradius/3.0/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 !~ /(a)(.+)\.(.+)$/)) { (0) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/)) -> FALSE (0) if (&User-Name =~ /\.$/) { (0) if (&User-Name =~ /\.$/) -> FALSE (0) if (&User-Name =~ /(a)\./) { (0) if (&User-Name =~ /(a)\./) -> FALSE (0) } # if (&User-Name) = notfound (0) } # policy filter_username = notfound (0) [preprocess] = ok (0) [chap] = noop (0) [mschap] = noop (0) [digest] = noop (0) ntdomain: Checking for prefix before "\" (0) ntdomain: No '\' in User-Name = "domainA ee", looking up realm NULL (0) ntdomain: Found realm "NULL" (0) ntdomain: Adding Realm = "NULL" (0) ntdomain: Proxying request from user domainA ee to realm NULL (0) ntdomain: Preparing to proxy authentication request to realm "NULL" (0) [ntdomain] = updated ----------------------------------- my freeradius version radiusd: FreeRADIUS Version 3.0.26, for host x86_64-pc-linux-gnu, built on Jan 4 2023 at 03:23:09 I had done my google search and found only one similar case https://lists.freeradius.org/pipermail/freeradius-users/2017-February/08663… I also tried different config/tests on freeradius, but no luck. Is there a way to not escaping characters in user-name on freeradius? in my tests, there are two solutions on Windows side 1. ask all users to use UPN name instead of Domain\username to login. This will have a major impact to users as it will change user behavior globally. Not a good option, 2. on RD Gateway server, add filters to radius auth requests for t, n and r accounts, for example, search (.*)\\(t.*) replace $1\$2 this solution will need to be applied to 30+ RD Gateway servers managed by different teams/admins across global. I am seeking if there is a more simple solution on freeradius. Can someone help? Regards, Eric

2 2

redis_ippool.renew is not able to update lease time
by Chinnapaiyan, Nagamani 03 Jan '24

03 Jan '24

I am seeing below issue with redis_ippool.renew for dhcp-request. IP is offered(discover-offer phase) by redis_ippool.allocate: Debug : (3) Received Discover XID 18c39c7b from 127.0.0.1:6768 to 127.0.0.1:6767 via lo Debug : (3) Opcode = Client-Message Debug : (3) Hardware-Type = Ethernet Debug : (3) Hardware-Address-Length = 6 Debug : (3) Hop-Count = 0 Debug : (3) Transaction-Id = 415472763 Debug : (3) Number-of-Seconds = 0 Debug : (3) Flags = 0 Debug : (3) Client-IP-Address = 0.0.0.0 Debug : (3) Your-IP-Address = 0.0.0.0 Debug : (3) Server-IP-Address = 0.0.0.0 Debug : (3) Gateway-IP-Address = 0.0.0.0 Debug : (3) Client-Hardware-Address = 01:01:bc:11:22:33 Debug : (3) Message-Type = Discover Debug : (3) Client-Identifier = 0x0101bc112233 Debug : (3) Parameter-Request-List = Vendor Debug : (3) Parameter-Request-List = NIS-Servers Debug : (3) Parameter-Request-List = Subnet-Mask Debug : (3) Parameter-Request-List = Router-Address Debug : (3) Parameter-Request-List = Domain-Name-Server Debug : (3) Maximum-Msg-Size = 1500 Debug : (3) Vendor-Class-Identifier = 0x766961736174312e30 Debug : (3) Relay-Agent-Information { Debug : (3) Subscriber-Id = 0101bc112233(a)aut.res.viasat.com<mailto:0101bc112233@aut.res.viasat.com> Debug : (3) Remote-Id = 0x0101bc112233 Debug : (3) Circuit-Id = 0x00a0bc332211 Debug : (3) } Debug : (3) Network-Subnet = 0.0.0.0/32 Debug : (3) Packet-Type = Discover Debug : (3) Running 'recv Discover' from file /etc/raddb/sites-enabled/dhcp Debug : (3) recv Discover { ... ... Debug : (3) redis_ippool - Allocating lease from pool "naw01_healthcheck_VSAT-UT", to "01:01:bc:11:22:33_01:01:bc:11:22:33_0x0101bc112233", expires in 120s Debug : (3) redis_ippool - Reserved connection (0) Debug : (3) redis_ippool - [1] >>> Sending command(s) to 10.43.16.101:6379 Debug : (3) redis_ippool - [1] <<< Returned: success Debug : (3) redis_ippool - Released connection (0) Debug : (3) redis_ippool - &reply.Your-IP-Address := 169.254.0.224 Debug : (3) redis_ippool - &reply.IP-Address-Lease-Time := 120 Debug : (3) redis_ippool - IP address lease allocated Debug : (3) redis_ippool.allocate (updated) But during request-ack phase, getting "requested ip not in the pool error" for redis_ippool.renew/redis_ippool.update: Debug : (4) dhcp { Debug : (4) Received Request XID 0805ae2e from 127.0.0.1:6768 to 127.0.0.1:6767 via lo Debug : (4) Opcode = Client-Message Debug : (4) Hardware-Type = Ethernet Debug : (4) Hardware-Address-Length = 6 Debug : (4) Hop-Count = 0 Debug : (4) Transaction-Id = 134589998 Debug : (4) Number-of-Seconds = 0 Debug : (4) Flags = 0 Debug : (4) Client-IP-Address = 0.0.0.0 Debug : (4) Your-IP-Address = 0.0.0.0 Debug : (4) Server-IP-Address = 0.0.0.0 Debug : (4) Gateway-IP-Address = 0.0.0.0 Debug : (4) Client-Hardware-Address = 01:01:bc:11:22:33 Debug : (4) Message-Type = Request Debug : (4) Client-Identifier = 0x0101bc112233 Debug : (4) Parameter-Request-List = Vendor Debug : (4) Parameter-Request-List = NIS-Servers Debug : (4) Parameter-Request-List = Subnet-Mask Debug : (4) Parameter-Request-List = Router-Address Debug : (4) Parameter-Request-List = Domain-Name-Server Debug : (4) Maximum-Msg-Size = 1500 Debug : (4) Vendor-Class-Identifier = 0x766961736174312e30 Debug : (4) Relay-Agent-Information { Debug : (4) Subscriber-Id = 0101bc112233(a)aut.res.viasat.com<mailto:0101bc112233@aut.res.viasat.com> Debug : (4) Remote-Id = 0x0101bc112233 Debug : (4) Circuit-Id = 0x00a0bc223344 Debug : (4) } Debug : (4) Requested-IP-Address = 169.254.0.224 Debug : (4) Server-Identifier = 10.43.18.51 Debug : (4) Network-Subnet = 0.0.0.0/32 Debug : (4) Packet-Type = Request Debug : (4) Running 'recv Request' from file /etc/raddb/sites-enabled/dhcp Debug : (4) recv Request { ... ... Debug : (4) redis_ippool - Updating 169.254.0.224 in pool "naw01_healthcheck_VSAT-UT", device "01:01:bc:11:22:33_01:01:bc:11:22:33_0x0101bc112233", expires in 900s Debug : (4) redis_ippool - Reserved connection (0) Debug : (4) redis_ippool - [1] >>> Sending command(s) to 10.43.16.101:6379 Debug : (4) redis_ippool - [1] <<< Returned: success Debug : (4) redis_ippool - Released connection (0) ERROR : (4) redis_ippool - ERROR: Requested IP address "169.254.0.224" is not a member of the specified pool Debug : (4) redis_ippool.renew (notfound) But that pool has that IP address in redis-db: > zscore {naw01_healthcheck_VSAT-UT}:pool 169.254.0.224 1704264141.0 I am using latest master(4.x) branch(dated Dec 17 2023. #104f1d2422f6dadc5526c92666a285cc01519907). Regards, Nagamani Chinnapaiyan

3 3

not able to access dhcp option82.9
by Chinnapaiyan, Nagamani 03 Jan '24

03 Jan '24

I am not able to access dhcp option82.9 by any of the following references, Relay-Agent-Information.Vendor-Specific-Information request.Relay-Agent-Information.Vendor-Specific-Information dhcpv4.Relay-Agent-Information.Vendor-Specific-Information Debug output displays the packet content. but I am not able to reference it. Debug : (0) dhcp { Debug : (0) Received Request XID 4051b530 from 10.43.18.160:67 to 10.43.18.51:67 via eth1 Debug : (0) Opcode = Client-Message Debug : (0) Hardware-Type = Ethernet Debug : (0) Hardware-Address-Length = 6 Debug : (0) Hop-Count = 0 Debug : (0) Transaction-Id = 1079096624 Debug : (0) Number-of-Seconds = 0 Debug : (0) Flags = 0 Debug : (0) Client-IP-Address = 0.0.0.0 Debug : (0) Your-IP-Address = 0.0.0.0 Debug : (0) Server-IP-Address = 0.0.0.0 Debug : (0) Gateway-IP-Address = 10.43.18.160 Debug : (0) Client-Hardware-Address = 00:a0:bc:00:10:1a Debug : (0) Message-Type = Request Debug : (0) Client-Identifier = 0x00a0bd112233 Debug : (0) Parameter-Request-List = Vendor Debug : (0) Parameter-Request-List = NIS-Servers Debug : (0) Parameter-Request-List = Subnet-Mask Debug : (0) Parameter-Request-List = Router-Address Debug : (0) Parameter-Request-List = Domain-Name-Server Debug : (0) Vendor-Class-Identifier = 0x766961736174312e30 Debug : (0) Relay-Agent-Information { Debug : (0) Subscriber-Id = 00A0BD112233(a)biz.res.viasat.com<mailto:00A0BD112233@biz.res.viasat.com> Debug : (0) Remote-Id = 0x00a0bc00101a Debug : (0) Circuit-Id = 0x00a0bcaaffbb Debug : (0) } Debug : (0) Requested-IP-Address = 173.21.0.104 Debug : (0) Server-Identifier = 10.43.18.96 Debug : (0) Maximum-Msg-Size = 1500 Debug : (0) Relay-Agent-Information { Debug : (0) Vendor-Specific-Information = 0x000021fa12636974657374732d697067726f75702d3231 Debug : (0) } Debug : (0) Network-Subnet = 10.43.18.160/32 Debug : (0) Packet-Type = Request Debug : (0) Running 'recv Request' from file /etc/raddb/sites-enabled/dhcp Debug : (0) recv Request { Debug : (0) policy viasat_strip_attributes { Debug : (0) | Relay-Agent-Information.Vendor-Specific-Information Debug : (0) | %{Relay-Agent-Information.Vendor-Specific-Information} Debug : (0) (null) Debug : (0) | request.Relay-Agent-Information.Vendor-Specific-Information Debug : (0) | %{request.Relay-Agent-Information.Vendor-Specific-Information} Debug : (0) (null) Debug : (0) | dhcpv4.Relay-Agent-Information.Vendor-Specific-Information Debug : (0) | %{dhcpv4.Relay-Agent-Information.Vendor-Specific-Information} Debug : (0) (null) Regards, Nagamani Chinnapaiyan

2 2

Error: blank page after logging
by Aghyad Fares 01 Jan '24

01 Jan '24

Hope this email finds you well. I am getting a blank page after I login into RADIUS management application using administrator as a username and radius as a password. P.s. I am using php 5.4 Looking forward to hearing from you soon. Aghyad

2 1