September 2021 - Freeradius-Users - lists.freeradius.org

Authenticate to AD but only allow certain group
by Brian C. Huffman 16 Aug '25

16 Aug '25

All, I've got authentication working nicely with MSCHAP, but now I'd like to only allow users that are members of a certain AD group. I would prefer to have this happen only when requests come from a specific client (wireless access point). In this case the idea is to have users only be able to get wireless access when they're in a specific AD group. How can I do this in freeradius? Thanks, Brian

7 18

Re: Checkrad and IPv6 NAS IP address
by Fabricio Viana 05 Oct '22

05 Oct '22

Hello Alan, how are you? I ran some tests as fast as I could. Now it's giving the following message: (0) sql: Executing select query: SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = 'joseph.test' AND acctstoptime IS NULL checkrad: Unknown NAS 2804:444:1:1::2, not checking NAS 2804:444:1:1::2 was added normally: rlm_sql (sql): Adding client 2804:444:1:1::2 (R1.ITU) to global clients list rlm_sql (2804:444:1:1::2): Client "R1.ITU" (sql) added Authentication normally takes place with IPv6. The problem is with checkrad. Below is the Access-Request package and the freeradius -X command output. Could you help please? Thank you! Fabricio Viana root@li1268-188:/# freeradius -v radiusd: FreeRADIUS Version 3.0.24 (git #83d87a2), for host x86_64-pc-linux-gnu FreeRADIUS Version 3.0.24 (0) Received Access-Request Id 142 from [2804:444:1:1::2]:33926 to [2600:4a00::f132:91a4:f567:34fd]:1812 length 185 (0) Service-Type = Framed-User (0) Framed-Protocol = PPP (0) NAS-Port = 15813747 (0) NAS-Port-Type = Ethernet (0) User-Name = "joseph.test" (0) Calling-Station-Id = "AA:BB:B6:41:33:AA" (0) Called-Station-Id = "pppoe-server-olt02" (0) NAS-Port-Id = "ether3.501-PPPoE-OLT02" (0) CHAP-Challenge = 0x388b23cbdc8d67936f09a731c70acf6e (0) CHAP-Password = 0x018003bc3835139074138c89d63370276a (0) NAS-Identifier = "R1.ITU" (0) NAS-IPv6-Address = 2804:444:1:1::2 (0) # Executing section authorize from file /etc/freeradius/sites-enabled/default (0) authorize { (0) if ("%{Cisco-AVPair[*]}" =~ /client-mac-address=(.*)/) { (0) EXPAND %{Cisco-AVPair[*]} (0) --> (0) if ("%{Cisco-AVPair[*]}" =~ /client-mac-address=(.*)/) -> FALSE (0) elsif (ERX-Dhcp-Mac-Addr =~ /^([a-f0-9][a-f0-9])([a-f0-9][a-f0-9]).([a-f0-9][a-f0-9])([a-f0-9][a-f0-9]).([a-f0-9][a-f0-9])([a-f0-9][a-f0-9])$/) { (0) ERROR: Failed retrieving values required to evaluate condition (0) else { (0) update request { (0) EXPAND %{toupper:%{Calling-Station-Id}} (0) --> AA:BB:B6:41:33:AA (0) Calling-Station-Id := AA:BB:B6:41:33:AA (0) } # update request = noop (0) } # else = noop (0) if (!control:Cleartext-Password){ (0) if (!control:Cleartext-Password) -> TRUE (0) if (!control:Cleartext-Password) { (0) update control { (0) Cleartext-Password := "no_user_found_radiusnet" (0) } # update control = noop (0) } # if (!control:Cleartext-Password) = noop (0) [preprocess] = ok (0) chap: &control:Auth-Type := CHAP (0) [chap] = ok (0) [mschap] = noop (0) eap: No EAP-Message, not doing EAP (0) [eap] = noop (0) sql: EXPAND %{User-Name} (0) sql: --> joseph.test (0) sql: SQL-User-Name set to 'joseph.test' rlm_sql (sql): Reserved connection (1) (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 = 'joseph.test' ORDER BY id (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'joseph.test' ORDER BY id (0) sql: User found in radcheck table (0) sql: Conditional check items matched, merging assignment check items (0) sql: Cleartext-Password := "ellen8858" (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 = 'joseph.test' ORDER BY id (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'joseph.test' 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 = 'joseph.test' ORDER BY priority (0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'joseph.test' 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 = '2BLO' ORDER BY id (0) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '2BLO' ORDER BY id (0) sql: Group "2BLO": Conditional check items matched (0) sql: Group "2BLO": Merging assignment check items (0) sql: Simultaneous-Use := 1 (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 = '2BLO' ORDER BY id (0) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '2BLO' ORDER BY id (0) sql: Group "2BLO": Merging reply items (0) sql: Mikrotik-Rate-Limit = "100k/100k" (0) sql: WISPr-Bandwidth-Max-Down = 100000 (0) sql: WISPr-Bandwidth-Max-Up = 100000 (0) sql: Framed-Pool = "pool_bloqueados" (0) sql: Mikrotik-Address-List = "bloqueados" rlm_sql (sql): Released connection (1) (0) [sql] = ok (0) pap: WARNING: Auth-Type already set. Not setting to PAP (0) [pap] = noop (0) } # authorize = ok (0) Found Auth-Type = CHAP (0) # Executing group from file /etc/freeradius/sites-enabled/default (0) Auth-Type CHAP { (0) chap: Comparing with "known good" Cleartext-Password (0) chap: CHAP user "joseph.test" authenticated successfully (0) [chap] = ok (0) if (request:Service-Type == Login-User && !request:NAS-Port-Type && !reply:Mikrotik-Group){ (0) if (request:Service-Type == Login-User && !request:NAS-Port-Type && !reply:Mikrotik-Group) -> FALSE (0) if (request:Service-Type == Login-User && request:NAS-Port-Type && reply:Mikrotik-Group){ (0) if (request:Service-Type == Login-User && request:NAS-Port-Type && reply:Mikrotik-Group) -> FALSE (0) if (request:Service-Type == Framed-User && reply:Mikrotik-Group){ (0) if (request:Service-Type == Framed-User && reply:Mikrotik-Group) -> FALSE (0) if (reject && Framed-Protocol == PPP) { (0) if (reject && Framed-Protocol == PPP) -> FALSE (0) if (invalid && Framed-Protocol == PPP) { (0) if (invalid && Framed-Protocol == PPP) -> FALSE (0) } # Auth-Type CHAP = ok (0) # Executing section session from file /etc/freeradius/sites-enabled/default (0) session { (0) sql: EXPAND %{User-Name} (0) sql: --> joseph.test (0) sql: SQL-User-Name set to 'joseph.test' rlm_sql (sql): Reserved connection (2) (0) sql: EXPAND SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL (0) sql: --> SELECT COUNT(*) FROM radacct WHERE username = 'joseph.test' AND acctstoptime IS NULL (0) sql: Executing select query: SELECT COUNT(*) FROM radacct WHERE username = 'joseph.test' AND acctstoptime IS NULL (0) sql: EXPAND SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL (0) sql: --> SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = 'joseph.test' AND acctstoptime IS NULL (0) sql: Executing select query: SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = 'joseph.test' AND acctstoptime IS NULL checkrad: Unknown NAS 2804:444:1:1::2, not checking rlm_sql (sql): Released connection (2) (0) [sql] = ok (0) } # session = ok (0) Using Post-Auth-Type Reject (0) # Executing group from file /etc/freeradius/sites-enabled/default (0) Post-Auth-Type REJECT { (0) sql: EXPAND .query (0) sql: --> .query (0) sql: Using query template 'query' rlm_sql (sql): Reserved connection (3) (0) sql: EXPAND %{User-Name} (0) sql: --> joseph.test (0) sql: SQL-User-Name set to 'joseph.test' (0) sql: EXPAND INSERT INTO radpostauth (username, pass, reply, authdate, nasipaddress, callingstationid) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', UTC_TIMESTAMP(), '%{%{NAS-IP-Address}:-%{NAS-IPv6-Address}}', '%{Calling-Station-Id}') (0) sql: --> INSERT INTO radpostauth (username, pass, reply, authdate, nasipaddress, callingstationid) VALUES ( 'joseph.test', '0x018003bc3835139074138c89d63370276a', 'Access-Reject', UTC_TIMESTAMP(), '2804:444:1:1::2', 'AA:BB:B6:41:33:AA') (0) sql: Executing query: INSERT INTO radpostauth (username, pass, reply, authdate, nasipaddress, callingstationid) VALUES ( 'joseph.test', '0x018003bc3835139074138c89d63370276a', 'Access-Reject', UTC_TIMESTAMP(), '2804:444:1:1::2', 'AA:BB:B6:41:33:AA') (0) sql: SQL query returned: success (0) sql: 1 record(s) updated rlm_sql (sql): Released connection (3) (0) [sql] = ok (0) attr_filter.access_reject: EXPAND %{User-Name} (0) attr_filter.access_reject: --> joseph.test (0) attr_filter.access_reject: Matched entry DEFAULT at line 11 (0) [attr_filter.access_reject] = updated (0) [eap] = noop (0) policy remove_reply_message_if_eap { (0) if (&reply:EAP-Message && &reply:Reply-Message) { (0) if (&reply:EAP-Message && &reply:Reply-Message) -> FALSE (0) else { (0) [noop] = noop (0) } # else = noop (0) } # policy remove_reply_message_if_eap = noop (0) } # Post-Auth-Type REJECT = updated (0) Delaying response for 1.000000 seconds Waking up in 0.3 seconds. FreeRADIUS Version 3.0.24 Copyright (C) 1999-2021 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file /usr/share/freeradius/dictionary including dictionary file /usr/share/freeradius/dictionary.dhcp including dictionary file /usr/share/freeradius/dictionary.vqp including dictionary file /etc/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/pap including configuration file /etc/freeradius/mods-enabled/linelog including configuration file /etc/freeradius/mods-enabled/files including configuration file /etc/freeradius/mods-enabled/eap including configuration file /etc/freeradius/mods-enabled/echo including configuration file /etc/freeradius/mods-enabled/unix including configuration file /etc/freeradius/mods-enabled/expiration including configuration file /etc/freeradius/mods-enabled/sqlippool_v4 including configuration file /etc/freeradius/mods-config/sql/ippool/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/chap including configuration file /etc/freeradius/mods-enabled/utf8 including configuration file /etc/freeradius/mods-enabled/logintime including configuration file /etc/freeradius/mods-enabled/sqlippool including configuration file /etc/freeradius/mods-config/sql/ippool/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/realm 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/radutmp including configuration file /etc/freeradius/mods-enabled/mschap including configuration file /etc/freeradius/mods-enabled/unpack including configuration file /etc/freeradius/mods-enabled/detail.log including configuration file /etc/freeradius/mods-enabled/attr_filter including configuration file /etc/freeradius/mods-enabled/dynamic_clients including configuration file /etc/freeradius/mods-enabled/passwd including configuration file /etc/freeradius/mods-enabled/ddns_exec including configuration file /etc/freeradius/mods-enabled/ntlm_auth including configuration file /etc/freeradius/mods-enabled/preprocess including configuration file /etc/freeradius/mods-enabled/soh including configuration file /etc/freeradius/mods-enabled/sradutmp including configuration file /etc/freeradius/mods-enabled/sqlippool_v6 including configuration file /etc/freeradius/mods-config/sql/ippool/mysql/queries_v6.conf including configuration file /etc/freeradius/mods-enabled/replicate including configuration file /etc/freeradius/mods-enabled/exec including configuration file /etc/freeradius/mods-enabled/cache_eap including configuration file /etc/freeradius/mods-enabled/expr including configuration file /etc/freeradius/mods-enabled/always including configuration file /etc/freeradius/mods-enabled/detail including configuration file /etc/freeradius/mods-enabled/digest including files in directory /etc/freeradius/policy.d/ including configuration file /etc/freeradius/policy.d/canonicalization including configuration file /etc/freeradius/policy.d/eap including configuration file /etc/freeradius/policy.d/debug including configuration file /etc/freeradius/policy.d/operator-name including configuration file /etc/freeradius/policy.d/filter including configuration file /etc/freeradius/policy.d/moonshot-targeted-ids including configuration file /etc/freeradius/policy.d/accounting /etc/freeradius/policy.d/accounting[42]: Reference "${IDRADIUSSERVER}" not found /etc/freeradius/policy.d/accounting[54]: Reference "${IDRADIUSSERVER}" not found including configuration file /etc/freeradius/policy.d/abfab-tr including configuration file /etc/freeradius/policy.d/dhcp including configuration file /etc/freeradius/policy.d/cui including configuration file /etc/freeradius/policy.d/control including files in directory /etc/freeradius/sites-enabled/ including configuration file /etc/freeradius/sites-enabled/inner-tunnel including configuration file /etc/freeradius/sites-enabled/default including configuration file /etc/freeradius/freeradius.env including configuration file /etc/freeradius/ddns.env main { security { user = "root" group = "root" 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 = "/var/scriptsradius/callcheckrad.sh" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no colourise = yes msg_denied = "You are already logged in - access denied" } resources { } security { max_attributes = 200 reject_delay = 1.000000 status_server = yes } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = <<< secret >>> response_window = 20.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 check_timeout = 4 num_answers_to_alive = 3 revive_interval = 120 limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = <<< secret >>> nas_type = "other" proto = "*" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client localhost_ipv6 { ipv6addr = ::1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Debugger not attached systemd watchdog is disabled # Creating Auth-Type = mschap # Creating Auth-Type = eap # Creating Auth-Type = PAP # Creating Auth-Type = CHAP # Creating Auth-Type = MS-CHAP radiusd: #### Instantiating modules #### modules { # Loaded module rlm_pap # Loading module "pap" from file /etc/freeradius/mods-enabled/pap pap { normalise = yes } # 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 = "This is a log message for %{User-Name}" reference = "messages.%{%{reply: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_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_eap # Loading module "eap" from file /etc/freeradius/mods-enabled/eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loaded module rlm_exec # Loading module "echo" from file /etc/freeradius/mods-enabled/echo exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = 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_expiration # Loading module "expiration" from file /etc/freeradius/mods-enabled/expiration # Loaded module rlm_sqlippool # Loading module "sqlippool_v4" from file /etc/freeradius/mods-enabled/sqlippool_v4 sqlippool sqlippool_v4 { sql_module_instance = "sql" lease_duration = 3600 pool_name = "Pool-Name" default_pool = "main_pool" allocate_begin = "START TRANSACTION" allocate_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE expiry_time <= UTC_TIMESTAMP() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}'" allocate_clear_timeout = 1 allocate_existing = "" allocate_requested = "" allocate_find = "SELECT framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < UTC_TIMESTAMP() OR expiry_time IS NULL) AND banned = 0 ORDER BY (username <> '%{User-Name}'), (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE" allocate_update = "UPDATE radippool SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE framedipaddress = '%I' AND expiry_time IS NULL" allocate_commit = "COMMIT" pool_check = "SELECT id FROM radippool WHERE pool_name='%{control:Pool-Name}' LIMIT 1" start_begin = "" start_update = "UPDATE radippool SET expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'" start_commit = "" alive_begin = "" alive_update = "UPDATE radippool SET expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'" alive_commit = "" stop_begin = "" stop_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'" stop_commit = "" on_begin = "" on_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}'" on_commit = "" off_begin = "" off_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}'" off_commit = "" messages { exists = "Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" clear = "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" failed = "IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" nopool = "No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" } } # Loaded module rlm_chap # Loading module "chap" from file /etc/freeradius/mods-enabled/chap # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/freeradius/mods-enabled/utf8 # Loaded module rlm_logintime # Loading module "logintime" from file /etc/freeradius/mods-enabled/logintime logintime { minimum_timeout = 60 } # Loading module "sqlippool" from file /etc/freeradius/mods-enabled/sqlippool sqlippool { sql_module_instance = "sql" lease_duration = 3600 pool_name = "Pool-Name" default_pool = "main_pool" ipv6 = yes allocate_begin = "START TRANSACTION" allocate_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE expiry_time <= UTC_TIMESTAMP() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}'" allocate_clear_timeout = 1 allocate_existing = "" allocate_requested = "" allocate_find = "SELECT framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < UTC_TIMESTAMP() OR expiry_time IS NULL) AND banned = 0 ORDER BY (username <> '%{User-Name}'), (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE" allocate_update = "UPDATE radippool SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE framedipaddress = '%I' AND expiry_time IS NULL" allocate_commit = "COMMIT" pool_check = "SELECT id FROM radippool WHERE pool_name='%{control:Pool-Name}' LIMIT 1" start_begin = "" start_update = "UPDATE radippool SET expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'" start_commit = "" alive_begin = "" alive_update = "UPDATE radippool SET expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'" alive_commit = "" stop_begin = "" stop_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'" stop_commit = "" on_begin = "" on_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}'" on_commit = "" off_begin = "" off_clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}'" off_commit = "" messages { exists = "Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" clear = "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" failed = "IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" nopool = "No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" } } # 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 "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_sql # Loading module "sql" from file /etc/freeradius/mods-enabled/sql sql { driver = "rlm_sql_mysql" server = "192.0.2.2" port = 3306 login = "radius_user" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = yes delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT id, nasname, shortname, type, secret, server FROM nas" authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = "%{tolower:type.%{Acct-Status-Type}.query}" type { accounting-on { query = "UPDATE radacct SET acctstoptime = UTC_TIMESTAMP(), acctsessiontime = UNIX_TIMESTAMP(UTC_TIMESTAMP()) - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE acctstoptime IS NULL AND nasipaddress = '%{%{NAS-IP-Address}:-%{NAS-IPv6-Address}}' AND acctstarttime <= UTC_TIMESTAMP()" } accounting-off { query = "UPDATE radacct SET acctstoptime = UTC_TIMESTAMP(), acctsessiontime = UNIX_TIMESTAMP(UTC_TIMESTAMP()) - UNIX_TIMESTAMP(acctstarttime), acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE acctstoptime IS NULL AND nasipaddress = '%{%{NAS-IP-Address}:-%{NAS-IPv6-Address}}' AND acctstarttime <= UTC_TIMESTAMP()" } start { query = "INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, framedipv6prefix, delegatedipv6prefix) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{%{NAS-IP-Address}:-%{NAS-IPv6-Address}}', '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', UTC_TIMESTAMP(), UTC_TIMESTAMP(), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Framed-IPv6-Prefix}', '%{Delegated-IPv6-Prefix}')" } interim-update { query = "UPDATE radacct SET acctupdatetime = (@acctupdatetime_old:=acctupdatetime), acctupdatetime = UTC_TIMESTAMP(), acctinterval = UNIX_TIMESTAMP(UTC_TIMESTAMP()) - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', framedipv6prefix = '%{Framed-IPv6-Prefix}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctstoptime = NULL, nasportid = '%{NAS-Port-Id}', calledstationid = '%{Called-Station-Id}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' OR AcctUniqueId = '%{Segundo-AcctUnique-Id}' OR AcctUniqueId = '%{Terceiro-AcctUnique-Id}'" } stop { query = "UPDATE radacct SET acctstoptime = UTC_TIMESTAMP(), acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{%{NAS-IP-Address}:-%{NAS-IPv6-Address}}'" } } } post-auth { reference = ".query" query = "INSERT INTO radpostauth (username, pass, reply, authdate, nasipaddress, callingstationid) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', UTC_TIMESTAMP(), '%{%{NAS-IP-Address}:-%{NAS-IPv6-Address}}', '%{Calling-Station-Id}')" } } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Creating attribute SQL-Group # Loaded module rlm_radutmp # Loading module "radutmp" from file /etc/freeradius/mods-enabled/radutmp radutmp { filename = "/var/log/freeradius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 384 caller_id = yes } # 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 passchange { } allow_retry = yes winbind_retry_with_normalised_username = no } # Loaded module rlm_unpack # Loading module "unpack" from file /etc/freeradius/mods-enabled/unpack # Loaded module rlm_detail # 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_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 } # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/freeradius/mods-enabled/dynamic_clients # 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 "ddns_del" from file /etc/freeradius/mods-enabled/ddns_exec exec ddns_del { wait = yes program = "/var/scriptsradius/ddns.php del %{User-Name} %{Framed-IP-Address}" input_pairs = "request" shell_escape = no } # Loading module "ddns_add" from file /etc/freeradius/mods-enabled/ddns_exec exec ddns_add { wait = yes program = "/var/scriptsradius/ddns.php add %{User-Name} %{Framed-IP-Address}" input_pairs = "request" shell_escape = no } # Loading module "ntlm_auth" from file /etc/freeradius/mods-enabled/ntlm_auth exec ntlm_auth { wait = yes program = "/path/to/ntlm_auth --request-nt-key --domain=MYDOMAIN --username=%{mschap:User-Name} --password=%{User-Password}" shell_escape = yes } # Loaded module rlm_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_soh # Loading module "soh" from file /etc/freeradius/mods-enabled/soh soh { dhcp = yes } # 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 } # Loading module "sqlippool_v6" from file /etc/freeradius/mods-enabled/sqlippool_v6 sqlippool sqlippool_v6 { sql_module_instance = "sql" lease_duration = 3600 pool_name = "Pool-Name" default_pool = "main_pool" ipv6 = yes allocate_begin = "START TRANSACTION" allocate_clear = "UPDATE radippoolv6 SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE expiry_time <= UTC_TIMESTAMP() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}'" allocate_clear_timeout = 1 allocate_existing = "" allocate_requested = "" allocate_find = "SELECT framedipaddress FROM radippoolv6 WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < UTC_TIMESTAMP() OR expiry_time IS NULL) ORDER BY (username <> '%{User-Name}'), (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE" allocate_update = "UPDATE radippoolv6 SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE framedipaddress = '%I' AND expiry_time IS NULL" allocate_commit = "COMMIT" pool_check = "SELECT id FROM radippoolv6 WHERE pool_name='%{control:Pool-Name}' LIMIT 1" start_begin = "" start_update = "UPDATE radippoolv6 SET expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IPv6-Prefix}'" start_commit = "" alive_begin = "" alive_update = "UPDATE radippoolv6 SET expiry_time = UTC_TIMESTAMP() + INTERVAL 3600 SECOND WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IPv6-Prefix}'" alive_commit = "" stop_begin = "" stop_clear = "UPDATE radippoolv6 SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IPv6-Prefix}'" stop_commit = "" on_begin = "" on_clear = "UPDATE radippoolv6 SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}'" on_commit = "" off_begin = "" off_clear = "UPDATE radippoolv6 SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}'" off_commit = "" messages { exists = "Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" clear = "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" failed = "IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" nopool = "No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" } } # Loaded module rlm_replicate # Loading module "replicate" from file /etc/freeradius/mods-enabled/replicate # Loading module "exec" from file /etc/freeradius/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # 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_expr # Loading module "expr" from file /etc/freeradius/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôoùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔOÙÛÜY" } # 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 } # 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_digest # Loading module "digest" from file /etc/freeradius/mods-enabled/digest instantiate { } # Instantiating module "pap" from file /etc/freeradius/mods-enabled/pap # Instantiating module "linelog" from file /etc/freeradius/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/freeradius/mods-enabled/linelog # 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 "eap" from file /etc/freeradius/mods-enabled/eap # Linked to sub-module rlm_eap_md5 rlm_eap (EAP): Ignoring EAP method 'leap', because it is no longer supported # Linked to sub-module rlm_eap_gtc gtc { challenge = "Password: " auth_type = "PAP" } # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" } tls-config tls-common { verify_depth = 0 ca_path = "/etc/freeradius/certs" pem_file_type = yes private_key_file = "/etc/ssl/private/ssl-cert-snakeoil.key" certificate_file = "/etc/ssl/certs/ssl-cert-snakeoil.pem" ca_file = "/etc/ssl/certs/ca-certificates.crt" private_key_password = <<< secret >>> dh_file = "/etc/freeradius/certs/dh" fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no ca_path_reload_interval = 0 cipher_list = "DEFAULT" reject_unknown_intermediate_ca = no ecdh_curve = "prime256v1" tls_min_version = "1.2" cache { enable = yes lifetime = 24 max_entries = 255 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = yes use_tunneled_reply = yes virtual_server = "inner-tunnel" include_length = yes require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = yes proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "expiration" from file /etc/freeradius/mods-enabled/expiration # Instantiating module "sqlippool_v4" from file /etc/freeradius/mods-enabled/sqlippool_v4 # Instantiating module "sql" from file /etc/freeradius/mods-enabled/sql rlm_sql_mysql: libmysql version: 5.7.35 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 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 192.0.2.2 via TCP/IP, server version 5.7.18-log, protocol version 10 rlm_sql (sql): Opening additional connection (1), 1 of 31 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 192.0.2.2 via TCP/IP, server version 5.7.18-log, protocol version 10 rlm_sql (sql): Opening additional connection (2), 1 of 30 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 192.0.2.2 via TCP/IP, server version 5.7.18-log, protocol version 10 rlm_sql (sql): Opening additional connection (3), 1 of 29 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 192.0.2.2 via TCP/IP, server version 5.7.18-log, protocol version 10 rlm_sql (sql): Opening additional connection (4), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 192.0.2.2 via TCP/IP, server version 5.7.18-log, protocol version 10 rlm_sql (sql): Processing generate_sql_clients rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas rlm_sql (sql): Reserved connection (0) rlm_sql (sql): Executing select query: SELECT id, nasname, shortname, type, secret, server FROM nas rlm_sql (sql): Adding client 2804:444:1:1::2 (R1.ITU) to global clients list rlm_sql (2804:444:1:1::2): Client "R1.ITU" (sql) added rlm_sql (sql): Released connection (0) Need more connections to reach 10 spares rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on 192.0.2.2 via TCP/IP, server version 5.7.18-log, protocol version 10 Ignoring "allocate_clear_timeout = 1", forcing to "allocate_clear_timeout = 1" # Instantiating module "logintime" from file /etc/freeradius/mods-enabled/logintime # Instantiating module "sqlippool" from file /etc/freeradius/mods-enabled/sqlippool Ignoring "allocate_clear_timeout = 1", forcing to "allocate_clear_timeout = 1" # Instantiating module "IPASS" from file /etc/freeradius/mods-enabled/realm # Instantiating module "suffix" 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 "mschap" from file /etc/freeradius/mods-enabled/mschap rlm_mschap (mschap): using internal authentication # 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 # 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 [/etc/freeradius/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay" found in filter list for realm "DEFAULT". [/etc/freeradius/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay-USec" found in filter list for realm "DEFAULT". # Instantiating module "attr_filter.access_challenge" from file /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 "etc_passwd" from file /etc/freeradius/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # 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 "sqlippool_v6" from file /etc/freeradius/mods-enabled/sqlippool_v6 Ignoring "allocate_clear_timeout = 1", forcing to "allocate_clear_timeout = 1" # 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 "detail" from file /etc/freeradius/mods-enabled/detail } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/radiusd.conf } # server 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 # Loading authorize {...} Ignoring "ldap" (see raddb/mods-available/README.rst) # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} Compiling Post-Auth-Type REJECT for attr Post-Auth-Type } # server inner-tunnel server default { # from file /etc/freeradius/sites-enabled/default # Loading authenticate {...} Compiling Auth-Type PAP for attr Auth-Type Compiling Auth-Type CHAP for attr Auth-Type Compiling Auth-Type MS-CHAP for attr Auth-Type # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} Compiling Post-Auth-Type REJECT for attr Post-Auth-Type } # server default radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } listen { type = "auth" ipaddr = * port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipaddr = * port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipv6addr = :: port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipv6addr = :: port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on proxy address * port 38092 Listening on proxy address :: port 58617 Ready to process requests

2 3

Freeradius DHCP and "Failed adding ARP entry: Failed to add entry in ARP cache: Operation not permitted (1)"
by CpServiceSPb 11 Sep '22

11 Sep '22

I use Freeradius 3.0.21 on Ubuntu 18.04 x64 LTS. It is started under freerad:freerad, acts as DHCP as well listen to 0.0.0.0 IP and accept broadcast on one of two interfaces and listen to 192.168.0.254 and not accept broadcast on other one interface. During DHCP conversation with clients using broadcast accepting (IP 0.0.0.0) interface, the following message is got and DHCP don' t assign to the client: "Failed adding ARP entry: Failed to add entry in ARP cache: Operation not permitted (1)" I don' t want to launch Freeradius under either root user or root/admin group. What is the best solution to avoid the error under freerad:freerad and move on ?

4 7

RE: EAP-TLS Signature Check Failure
by nabble＠felix.world 12 Jul '22

12 Jul '22

Hi Together, we finally got the issue and for the anyone else, how will face the issue, the fix is quite simple. Update your TPM Firmware! In fact, during the authentication the client is sending a signature which only includes nulls. The packet itself is intact, sizes of the packets are valid and the signature algorithm is also well. The only thing that's not in the tls authentication is a signature. : ```` (4) eap_tls: <<< recv TLS 1.2 (type: 0016) [length 0108] handshake_type: 0f, alert_level: 00, alert_description: 00 0f000104 TLS handshake certificate_verify len 0x000104 = 260 0804 signature algorithm: rsa_pss_rsae_sha256 0100 signature size: 0x0100 = 256 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 00000000000000000000 000000000000 ```` That's also the reason why some of our clients are able to authenticate and some not, with the key, stored in TPM. Intel ships end customer TPM updater, STM as we know not. We also don't have clients with Infineon chips but they should also ship updates to the end customer. FYI: This was a team operation and thanks to all that helped here. Regards, Lineconnnect <quote author='Users mailing list'> 2 months later, a quick update on this topic (apologies, I may have broken the threading as I don't have a copy of the original e-mails any more!), just so there's an online reference here for anyone encountering the same error. Turns out I was wrong about it being Windows and OpenSSL getting muddled over TLS 1.2 vs. 1.3... To recap: Windows 10 clients, corporate WiFi network using EAP-TLS to RADIUS with machine certificate (SCEP) authentication only. Error in Freeradius logs: (6) eap_tls: ERROR: TLS Alert write:fatal:decrypt error tls: TLS_accept: Error in error (6) eap_tls: ERROR: Failed in __FUNCTION__ (SSL_read) (6) eap_tls: ERROR: error:0407E086:rsa routines:RSA_verify_PKCS1_PSS_mgf1:last octet invalid (6) eap_tls: ERROR: error:1417B07B:SSL routines:tls_process_cert_verify:bad signature (6) eap_tls: ERROR: System call (I/O) error (-1) (6) eap_tls: ERROR: TLS receive handshake failed during operation (6) eap_tls: ERROR: [eaptls process] = fail After encountering the error on a few machines again, even with "tls_max_version" set, I delved into the guts of Windows again, and found the error (which isn't helpful or descriptive) was actually caused because: * Some machine certificates had were stored/managed by the "Microsoft Platform Crypto Provider" (TPM-backed) * Built-in security measures control access to keys in that CSP, and it cannot be used non-interactively * Windows WiFi profile was set to auto-join (non-interactive) * Windows couldn't get the key, so $deity knows what signature it was sending * OpenSSL rightly got confused The solution: Ensure machine certificate keys are stored in the "Microsoft Software Key Storage Provider" (or another CSP/KSP that permits non-interactive use). All is well again, and I'm close to shutting down NPS :-) -- Peter Bance Information Security Adviser Alan DeKok wrote: > A final update on this, in case anyone here's interested (or to "wrap > up" for anyone stumbling across this thread online) - I fixed it, and > Windows clients are now happily joining WiFi. It's a beautiful thing to > behold :-) > > In the end, I had to force OpenSSL on FreeRADIUS to stop offering > TLS1.3 ciphers using the mods/eap config: > > tls_max_version = "1.2" Good to hear. > It seems there may be a bug in OpenSSL 1.1.1 such that even though the > negotiation resulted in a TLS 1.2 session, the weird back-port of TLS > 1.3 ciphers into TLS 1.2 confused things (a lot), and it tried checking > for TLS 1.3 style signatures inappropriately. Weird, but OK. It's OpenSSL :( Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html </quote> Quoted from: http://freeradius.1045715.n5.nabble.com/RE-EAP-TLS-Signature-Check-Failure-… _____________________________________ Sent from http://freeradius.1045715.n5.nabble.com

3 4

Radsec Regression Alpine 3.14
by Emile Swarts 11 Nov '21

11 Nov '21

I recently upgraded Alpine from v3.12 to v3.14. Noticed that Radsec stopped working, and the only error message I get in the server logs is "(0) FAILED in TLS handshake receive". Switching back to v3.12 fixes the issue and the AP is able to establish the Radsec tunnel and do the authentication. I'm currently looking through all the dependencies that upgraded as part of the OS upgrade but it's difficult to pinpoint which one broke Radsec. Noted that openssl has stayed on the same version. FreeRadius versions went from: freeradius-lib-3.0.21-r3 freeradius-3.0.21-r3 freeradius-eap-3.0.21-r3 To: freeradius-lib-3.0.23-r0 freeradius-3.0.23-r0 freeradius-eap-3.0.23-r0 The rest of the package upgrades can be found here: https://gist.github.com/emileswarts/fd7d46556eacac096d318170aea7a19d Does anyone have any pointers on how to narrow down this bug? Thanks, Emile

5 29

FW: EAP TTLS woes
by adrian.p.smith＠bt.com 18 Oct '21

18 Oct '21

>> >> I am testing EAP TTLS with Android and finding some mixed results. >> >> Using identical WifiConfig on the devices I see an error on some: >> ... >> Thu Sep 23 15:01:12 2021 : Debug: (4813) eap_ttls: <<< recv TLS 1.1 >> [length 0002] Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: TLS >> Alert read:fatal:internal error > Hmm... useful errors. :( > TBH I'd suggest using the head of v3.0.x from git, or the packages at .... > You're running 3.0.21 or earlier, and 3.0.22 added a lot more TLS debugging messages. So it's much easier to tell what's going on. > Right now, all we know is that it's "magic OpenSSL stuff". > Alan DeKok. Thanks Alan - in the process of building 3.0.23 for our machine.

3 9

We'll do 3.0.25
by Alan DeKok 06 Oct '21

06 Oct '21

It looks like there's a last-minute bug introduced in 3.0.24 which breaks the server. Sorry. :( It passed all of the regression tests, so we'll need to update the tests. Matthew will be releasing 3.0.25 shortly to fix the issue. A major issue with current development is that v4 is taking longer than we'd like. The end goal is in sight, but there's still a lot of work to do. We believe the result will be worth it, and surprisingly simple / powerful / useful. But in the mean time, we do need to get new functionality into v3. So after some internal discussion, our way forward is this: * Matthew will release 3.0.25 shortly * after that, the v3.0.x branch will be frozen for everything other than security fixes * we will create a v3.2.0 branch which will contain all new development for v3 * 3.2.0 will be 99.99% compatible with 3.0, so any upgrade will be painless. The same configuration files can be used The goal is to have a clear distinction between "stable" 3.0, and "new feature" 3.2. Sorry again for the issues. Alan DeKok.

3 3

Version 3.0.24 has been released
by Matthew Newton 30 Sep '21

30 Sep '21

Version 3.0.24 has now been released. Full release notes are on the web site: https://freeradius.org/release_notes/?br=3.0.x&re=3.0.24 This is mainly a bugfix release, with a few new features, for example: - More liberal SQL commands in rlm_sql_map - Dynamic loading of certificates via TLS-Session-Cert-File - Preliminary support for haproxy "PROXY" protocol - Generate more parse errors when we know the config is wrong - Update a few dictionaries The bugfixes include fixing some crashes, SQL query updates, and more. Packaging has been updated to add support for Debian 11 Bullseye. Download from all the usual places: https://packages.networkradius.com/ https://freeradius.org/releases/ ftp://ftp.freeradius.org/pub/freeradius/ https://github.com/FreeRADIUS/freeradius-server/releases/tag/release_3_0_24 The Network RADIUS packages and Docker images have all been built and are available now. -- Matthew

2 1

Windows authentication failed with FreeRadius
by Vinit Bhosle 28 Sep '21

28 Sep '21

Dear Support, I have installed freeradius server 3.0.20 and am using EAP-TLS for authentication. I have installed CA signed certificates. My Android devices, Linux and Mac OS are working fine but windows 10 is not working. It is giving the following error. Please suggest how to resolve this. (7) eap_peap: ERROR: TLS Alert read:fatal:access denied (7) eap_peap: SSL_read Error (7) eap_peap: ERROR: Error in fragmentation logic (7) eap_peap: ERROR: Failed in __FUNCTION__ (SSL_read): error:14094419:SSL routines:ssl3_read_bytes:tlsv1 alert access denied (7) eap_peap: ERROR: [eaptls process] = fail (7) eap: ERROR: Failed continuing EAP PEAP (25) session. EAP sub-module failed Regards Vinit

1 0

Re: FreeRadius Fresh installation 3.0.23 "${dialect}" Reference "${dialect}" not found
by Pizu 27 Sep '21

27 Sep '21

Hi, Videos uploaded here: https://www.transfernow.net/dl/20210927VzhbhVO0 Regards, On Mon, 27 Sept 2021 at 16:16, Pizu <pizpower(a)gmail.com> wrote: > Hi, > > @Marki > So the OS is being installed manually from a usb stick and attached. You > may find the recording of my screen installing the freeradius on a fresh > ubuntu installation. > > The recording is in 2 videos. > > @Alan if you need anything else from me please let me know in the videos > as you can see I am not doing anything special :( > > Regards, > > > > > On Fri, 24 Sept 2021 at 00:58, Marki <jm+freeradiususer(a)roth.lu> wrote: > >> You shouldn't take this personal. >> The golden rule of IT Support is "Everybody lies". >> People mostly do it unwittingly. >> Happens to everyone from time to time, including myself. >> People leave out details in their thought process (hence in their >> support queries) because they think they are unimportant. However since >> things are going bad for them and they ask for support, they shouldn't >> leave out anything beforehand and let the person(s) they are asking for >> help decide what is important and what is not. >> As someone pointed out before, you need to adopt a very systematic >> approach diagnosing this issue since it is very strange indeed. >> "Do you suggest I am lying" does not help. >> Questioning oneself is one of the primary qualities of IT engineers. >> *Something* is clearly interfering with some of your installations. It's >> either some automatic process or it's yourself. >> No insult intended. >> >> On 9/23/2021 11:46 PM, Pizu wrote: >> > Hmm are you suggesting I am lying? Why should I? I need help that is >> why I >> > asked for help. I don't need to lie to get help. >> > >> > I am installing the OS from a USB, formatted with Rufus with Ubuntu >> server >> > iso download from the official site. >> > >> > The VM is being installed by mounting the iso. Same iso. >> > >> > Gn >> > >> > >> > >> > >> > On Thu, 23 Sep 2021, 19:02 Marki, <jm+freeradiususer(a)roth.lu> wrote: >> > >> >> I also doubt that to be the root cause. >> >> I also doubt that replacing the physical server changes anything. >> >> >> >> But if any of it holds true, it will give a nice story ;) >> >> >> >> I suspect OP is not giving all the information of what he is doing / >> >> doing differently in VM and physical server. Just like in August ("I >> did >> >> stuff and it didn't work"[tm]) >> >> >> >> How are you installing the server / VM? Is it all manually? Is there >> any >> >> configuration mgmt / deployment / CI tool involved? >> >> Are you using _exactly_ the same repos both times and _exactly_ the >> same >> >> OS? >> >> Please provide output of "apt-cache policy" and "cat /etc/os-release" >> >> and "uname -a". >> >> >> >> Please stop posting images/screenshots of any command results. Use text >> >> and format it properly. >> >> >> >> _Before_ issuing for example any "ln" commands, have you checked the >> >> contents of the directories you are manipulating? >> >> Check that everything is as it should be before issuing any commands. >> >> Issue the commands. >> >> Then check if they did what they were supposed to do. >> >> >> >> On 9/23/2021 6:27 PM, Kristofer Hallin wrote: >> >>> How on earth can this possibly be different on a physical machine >> >> compared to a virtual? >> >>>> On 23 Sep 2021, at 18:23, Pizu <pizpower(a)gmail.com> wrote: >> >>>> >> >>>> Hi, >> >>>> >> >>>> Yes vm I have no issues. Live setup is on same os version and same >> >>>> freeradius version. >> >>>> >> >>>> Physical server I have issue, tomorrow I am going to try a >> >>>> different physical server as the current one is old and cannot >> install >> >> esxi >> >>>> on it, it's not supported. >> >>>> >> >>>> Will keep you all updated. >> >>>> >> >>>> Thanks & Regards >> >>>> >> >>>>> On Thu, 23 Sep 2021, 16:50 Kristofer Hallin, <kristofer(a)sunet.se> >> >> wrote: >> >>>>> Hi, >> >>>>> >> >>>>> I got curious and started a fresh VM with Ubuntu myself (Ubuntu >> 20.04.2 >> >>>>> LTS). I installed the packages from NetworkRADIUS and symlinked >> >> status, sql >> >>>>> and ldap just like you did. I then changed dialect in sql from >> sqlite >> >> to >> >>>>> mysql and restarted FreeRADIUS without seeing the same issue as you >> do >> >> (TLS >> >>>>> for MySQL, LDAP config etc are out of the scope here). >> >>>>> >> >>>>> The sql configuration now has the following two lines for dialect >> and >> >>>>> driver: >> >>>>> >> >>>>> dialect = "mysql" >> >>>>> driver = "rlm_sql_${dialect}" >> >>>>> >> >>>>> And that was the _only_ change I made to the configuration and it >> >> works. >> >>>>> BR, >> >>>>> /K >> >>>>> >> >>>>> — >> >>>>> Kristofer Hallin >> >>>>> SUNET >> >>>>>> On 23 Sep 2021, 16:17 +0200, Pizu <pizpower(a)gmail.com>, wrote: >> >>>>>> Hi, >> >>>>>> >> >>>>>> This is a formated server, fresh Ubuntu installation and fresh >> >> freeradius >> >>>>>> installation, just did the above mentioned configuration. I.e sym >> >> linked >> >>>>>> the LDAP/SQL/Status mods and site and changed the dialect from >> SQLite >> >> to >> >>>>>> MySQL and driver from null to use the dialect that's all the >> >>>>> configuration. >> >>>>>> I cannot understand what I did wrong here :( The same procedure for >> >> all >> >>>>>> servers.. >> >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> On Thu, 23 Sep 2021, 16:06 Alan DeKok, <aland(a)deployingradius.com> >> >>>>> wrote: >> >>>>>>> On Sep 23, 2021, at 9:22 AM, Pizu <pizpower(a)gmail.com> wrote: >> >>>>>>>> I am going to format it and install ESXi and will create a VM and >> >>>>> will >> >>>>>>> give >> >>>>>>>> you an update. >> >>>>>>> I suspect what happened is that you broke the configuration, and >> then >> >>>>>>> kept re-installing the packages, hoping that would fix it. >> >>>>>>> >> >>>>>>> The problem is that the packages don't wipe your configuration and >> >>>>>>> install the new ones. That's so you can upgrade the server by >> >>>>> installing >> >>>>>>> the new package, and it won't break a production system. >> >>>>>>> >> >>>>>>> So as always, if you make a change: >> >>>>>>> >> >>>>>>> * test it before the change. Make sure it works >> >>>>>>> >> >>>>>>> * make the change >> >>>>>>> >> >>>>>>> * test it after the change. If it doesn't work, then the problem >> is >> >> the >> >>>>>>> change you made. Don't do anything else until you fix the >> >>>>> configuration. >> >>>>>>> Alan DeKok. >> >>>>>>> >> >>>>>>> >> >>>>>>> - >> >>>>>>> List info/subscribe/unsubscribe? See >> >>>>>>> http://www.freeradius.org/list/users.html >> >>>>>> - >> >>>>>> List info/subscribe/unsubscribe? See >> >>>>> http://www.freeradius.org/list/users.html >> >>>>> - >> >>>>> List info/subscribe/unsubscribe? See >> >>>>> http://www.freeradius.org/list/users.html >> >>>> - >> >>>> List info/subscribe/unsubscribe? See >> >> http://www.freeradius.org/list/users.html >> >>> - >> >>> List info/subscribe/unsubscribe? See >> >> http://www.freeradius.org/list/users.html >> >> - >> >> List info/subscribe/unsubscribe? See >> >> http://www.freeradius.org/list/users.html >> > - >> > List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html > >

4 6

Problems starting FreeRadius after 3.0.23 install
by Weisteen Per 27 Sep '21

27 Sep '21

Hi Have just installed Freeradius 3.0.23 on my CentOS 7 test-servers as described in https://networkradius.com/packages/ . I'm not using LDAP so I've skipped that part. I'm also not using radiusd:radiusd as userid:groupid due to administrative naming rules, but got a xxxxrad:xxxxrad as userid:groupid instead. I've changed ownership for all files under /etc/raddb and /var/log/radiusd to xxxxrad:xxxxrad, changed user and group in radius.conf accordingly. Also copied the supplied /usr/lib/systemd/system/radiusd.service into /etc/systemd/system/radiusd.service and changed User and Group here too. Running radius -X as root gives no error messages. When starting radius through systemctl start radiusd I get "Failed to start FreeRADIUS multi-protocol policy server." Doing su - xxxxrad and the running radius -X gives these messages: Failed binding to interface net1: Operation not permitted /etc/raddb/sites-enabled/default[59]: Error binding to port for 10.141.8.20 port 1812 I've removed the comment that was in front of the CapabilityBoundingSet=CAP_NET_ADMIN CAP_NET_BIND_SERVICE CAP_NET_BROADCAST CAP_NET_RAW CAP_SETUID CAP_SETGID CAP_CHOWN CAP_DAC_OVERRIDE In radius.service. ./PerW

2 4

EAP TTLS woes
by adrian.p.smith＠bt.com 27 Sep '21

27 Sep '21

I am testing EAP TTLS with Android and finding some mixed results. Using identical WifiConfig on the devices I see an error on some: Thu Sep 23 15:01:12 2021 : Debug: (4808) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:01:12 2021 : Debug: (4808) eap_ttls: Initiating new EAP-TLS session Thu Sep 23 15:01:12 2021 : Debug: (4808) eap_ttls: [eaptls start] = request Thu Sep 23 15:01:12 2021 : Debug: (4809) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: Authenticate Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: Peer sent flags --- Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: Got final TLS record fragment (131 bytes) Thu Sep 23 15:01:12 2021 : WARNING: (4809) eap_ttls: Total received TLS record fragments (131 bytes), does not equal indicated TLS record length (0 bytes) Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: [eaptls verify] = ok Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: Done initial handshake Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: (other): before/accept initialization Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: before/accept initialization Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: <<< recv TLS 1.1 [length 007e] Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: SSLv3 read client hello A Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: >>> send TLS 1.1 [length 0039] Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: SSLv3 write server hello A Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: >>> send TLS 1.1 [length 0bc0] Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: SSLv3 write certificate A Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: >>> send TLS 1.1 [length 014b] Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: SSLv3 write key exchange A Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: >>> send TLS 1.1 [length 0004] Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: SSLv3 write server done A Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: SSLv3 flush data Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: Need to read more data: SSLv3 read client certificate A Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: TLS_accept: Need to read more data: SSLv3 read client certificate A Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: In SSL Handshake Phase Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: In SSL Accept mode Thu Sep 23 15:01:12 2021 : Debug: (4809) eap_ttls: [eaptls process] = handled Thu Sep 23 15:01:12 2021 : Debug: (4810) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:01:12 2021 : Debug: (4810) eap_ttls: Authenticate Thu Sep 23 15:01:12 2021 : Debug: (4810) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:01:12 2021 : Debug: (4810) eap_ttls: Peer sent flags --- Thu Sep 23 15:01:12 2021 : Debug: (4810) eap_ttls: Peer ACKed our handshake fragment Thu Sep 23 15:01:12 2021 : Debug: (4810) eap_ttls: [eaptls verify] = request Thu Sep 23 15:01:12 2021 : Debug: (4810) eap_ttls: [eaptls process] = handled Thu Sep 23 15:01:12 2021 : Debug: (4811) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:01:12 2021 : Debug: (4811) eap_ttls: Authenticate Thu Sep 23 15:01:12 2021 : Debug: (4811) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:01:12 2021 : Debug: (4811) eap_ttls: Peer sent flags --- Thu Sep 23 15:01:12 2021 : Debug: (4811) eap_ttls: Peer ACKed our handshake fragment Thu Sep 23 15:01:12 2021 : Debug: (4811) eap_ttls: [eaptls verify] = request Thu Sep 23 15:01:12 2021 : Debug: (4811) eap_ttls: [eaptls process] = handled Thu Sep 23 15:01:12 2021 : Debug: (4812) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:01:12 2021 : Debug: (4812) eap_ttls: Authenticate Thu Sep 23 15:01:12 2021 : Debug: (4812) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:01:12 2021 : Debug: (4812) eap_ttls: Peer sent flags --- Thu Sep 23 15:01:12 2021 : Debug: (4812) eap_ttls: Peer ACKed our handshake fragment Thu Sep 23 15:01:12 2021 : Debug: (4812) eap_ttls: [eaptls verify] = request Thu Sep 23 15:01:12 2021 : Debug: (4812) eap_ttls: [eaptls process] = handled Thu Sep 23 15:01:12 2021 : Debug: (4813) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:01:12 2021 : Debug: (4813) eap_ttls: Authenticate Thu Sep 23 15:01:12 2021 : Debug: (4813) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:01:12 2021 : Debug: (4813) eap_ttls: Peer sent flags --- Thu Sep 23 15:01:12 2021 : Debug: (4813) eap_ttls: [eaptls verify] = ok Thu Sep 23 15:01:12 2021 : Debug: (4813) eap_ttls: Done initial handshake Thu Sep 23 15:01:12 2021 : Debug: (4813) eap_ttls: <<< recv TLS 1.1 [length 0002] Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: TLS Alert read:fatal:internal error Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: TLS_accept: Failed in SSLv3 read client certificate A Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: Failed in __FUNCTION__ (SSL_read) Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: s3_pkt.c[1275]:error:14094438:SSL routines:SSL3_READ_BYTES:tlsv1 alert internal error Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: s3_pkt.c[992]:error:140940E5:SSL routines:SSL3_READ_BYTES:ssl handshake failure Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: System call (I/O) error (-1) Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: TLS receive handshake failed during operation Thu Sep 23 15:01:12 2021 : ERROR: (4813) eap_ttls: [eaptls process] = fail The working device shows this log: Thu Sep 23 15:07:35 2021 : Debug: (4844) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:07:35 2021 : Debug: (4844) eap_ttls: Initiating new EAP-TLS session Thu Sep 23 15:07:35 2021 : Debug: (4844) eap_ttls: [eaptls start] = request Thu Sep 23 15:07:35 2021 : Debug: (4845) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: Authenticate Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: Peer sent flags --- Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: Got final TLS record fragment (141 bytes) Thu Sep 23 15:07:35 2021 : WARNING: (4845) eap_ttls: Total received TLS record fragments (141 bytes), does not equal indicated TLS record length (0 bytes) Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: [eaptls verify] = ok Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: Done initial handshake Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: (other): before/accept initialization Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: before/accept initialization Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: <<< recv TLS 1.1 [length 0088] Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: SSLv3 read client hello A Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: >>> send TLS 1.1 [length 0039] Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: SSLv3 write server hello A Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: >>> send TLS 1.1 [length 0bc0] Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: SSLv3 write certificate A Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: >>> send TLS 1.1 [length 014b] Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: SSLv3 write key exchange A Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: >>> send TLS 1.1 [length 0004] Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: SSLv3 write server done A Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: SSLv3 flush data Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: Need to read more data: SSLv3 read client certificate A Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: TLS_accept: Need to read more data: SSLv3 read client certificate A Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: In SSL Handshake Phase Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: In SSL Accept mode Thu Sep 23 15:07:35 2021 : Debug: (4845) eap_ttls: [eaptls process] = handled Thu Sep 23 15:07:35 2021 : Debug: (4846) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:07:35 2021 : Debug: (4846) eap_ttls: Authenticate Thu Sep 23 15:07:35 2021 : Debug: (4846) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:07:35 2021 : Debug: (4846) eap_ttls: Peer sent flags --- Thu Sep 23 15:07:35 2021 : Debug: (4846) eap_ttls: Peer ACKed our handshake fragment Thu Sep 23 15:07:35 2021 : Debug: (4846) eap_ttls: [eaptls verify] = request Thu Sep 23 15:07:35 2021 : Debug: (4846) eap_ttls: [eaptls process] = handled Thu Sep 23 15:07:35 2021 : Debug: (4847) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:07:35 2021 : Debug: (4847) eap_ttls: Authenticate Thu Sep 23 15:07:35 2021 : Debug: (4847) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:07:35 2021 : Debug: (4847) eap_ttls: Peer sent flags --- Thu Sep 23 15:07:35 2021 : Debug: (4847) eap_ttls: Peer ACKed our handshake fragment Thu Sep 23 15:07:35 2021 : Debug: (4847) eap_ttls: [eaptls verify] = request Thu Sep 23 15:07:35 2021 : Debug: (4847) eap_ttls: [eaptls process] = handled Thu Sep 23 15:07:35 2021 : Debug: (4848) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:07:35 2021 : Debug: (4848) eap_ttls: Authenticate Thu Sep 23 15:07:35 2021 : Debug: (4848) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:07:35 2021 : Debug: (4848) eap_ttls: Peer sent flags --- Thu Sep 23 15:07:35 2021 : Debug: (4848) eap_ttls: Peer ACKed our handshake fragment Thu Sep 23 15:07:35 2021 : Debug: (4848) eap_ttls: [eaptls verify] = request Thu Sep 23 15:07:35 2021 : Debug: (4848) eap_ttls: [eaptls process] = handled Thu Sep 23 15:07:35 2021 : Debug: (4849) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: Authenticate Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: Peer sent flags --- Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: [eaptls verify] = ok Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: Done initial handshake Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: <<< recv TLS 1.1 [length 0046] Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: TLS_accept: SSLv3 read client key exchange A Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: <<< recv TLS 1.1 [length 0001] Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: <<< recv TLS 1.1 [length 0010] Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: TLS_accept: SSLv3 read finished A Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: >>> send TLS 1.1 [length 0001] Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: TLS_accept: SSLv3 write change cipher spec A Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: >>> send TLS 1.1 [length 0010] Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: TLS_accept: SSLv3 write finished A Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: TLS_accept: SSLv3 flush data Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: (other): SSL negotiation finished successfully Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: SSL Connection Established Thu Sep 23 15:07:35 2021 : Debug: (4849) eap_ttls: [eaptls process] = handled Thu Sep 23 15:07:35 2021 : Debug: (4850) eap: Calling submodule eap_ttls to process data Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: Authenticate Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: Continuing EAP-TLS Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: Peer sent flags --- Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: [eaptls verify] = ok Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: Done initial handshake Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: [eaptls process] = ok Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: Session established. Proceeding to decode tunneled attributes Thu Sep 23 15:07:35 2021 : Debug: (4850) eap_ttls: Got tunneled request Any clues appreciated. Adrian Smith

2 1

RADIUS protocol and password compatibility
by Network RADIUS 24 Sep '21

24 Sep '21

** RADIUS protocol and password compatibility -------------------------------------------- In order for RADIUS authentication to work, user passwords need to be stored in a format that is understood by the authentication protocol used by the client. Unfortunately, not all protocols work with all password storage formats. This can be especially problematic with platforms that use proprietary formats or protocols. Read the full article... https://networkradius.com/articles/2021/08/23/protocols-and-password-compat… <https://networkradius.com/articles/2021/06/09/8-most-common-RADIUS-mistakes…> ** Sign up to get this content directly --------------------------------------------- Want to get these articles in all their HTML glory? Sign up here: http://eepurl.com/hwuWrn <http://eepurl.com/hwuWrn> ** Need RADIUS help? --------------------------------------------- Get commercial support from the team behind FreeRADIUS. https://networkradius.com/contact/ <https://networkradius.com/contact/> ** What is the relationship between Network RADIUS and FreeRADIUS? ---------------------------------------------- FreeRADIUS is an open source implementation of the RADIUS protocol and was written by Alan DeKok in 1999. Network RADIUS is a private, for-profit company founded by Alan DeKok which provides commercial support for FreeRADIUS. The Network RADIUS team has been the primary contributor to FreeRADIUS for the last 20 years. The FreeRADIUS mailing list, wiki, and documentation are all moderated and maintained by the Network RADIUS team. FreeRADIUS has always been, and will always continue to be, open source. The Network RADIUS team provides commercial support to paying clients, and free product development for the FreeRADIUS community at large. All of our software development for FreeRADIUS is integrated into the Open Source platform, and will always continue to be.

1 0

FreeRadius Fresh installation 3.0.23 "${dialect}" Reference "${dialect}" not found
by Pizu 23 Sep '21

23 Sep '21

Hi, I have just installed FreeRadius from https://networkradius.com/packages/ repo on ubuntu 20.04 and am having the below error after configuring the dialect to mysql: Wed Sep 22 15:21:50 2021 : Info: FreeRADIUS Version 3.0.23 Wed Sep 22 15:21:50 2021 : Info: Copyright (C) 1999-2021 The FreeRADIUS server project and contributors Wed Sep 22 15:21:50 2021 : Info: There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A Wed Sep 22 15:21:50 2021 : Info: PARTICULAR PURPOSE Wed Sep 22 15:21:50 2021 : Info: You may redistribute copies of FreeRADIUS under the terms of the Wed Sep 22 15:21:50 2021 : Info: GNU General Public License Wed Sep 22 15:21:50 2021 : Info: For more information about these matters, see the file named COPYRIGHT Wed Sep 22 15:21:50 2021 : Info: Starting - reading configuration files ... Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary.dhcp Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /usr/share/freeradius/dictionary.vqp Wed Sep 22 15:21:50 2021 : Debug: including dictionary file /etc/freeradius/dictionary Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/radiusd.conf Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/proxy.conf Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/clients.conf Wed Sep 22 15:21:50 2021 : Debug: including files in directory /etc/freeradius/mods-enabled/ Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/ldap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/preprocess Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/ntlm_auth Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/utf8 Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/unix Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/realm Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/echo Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/mschap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/cache_eap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/expr Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/logintime Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/chap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/expiration Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/soh Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/replicate Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/dynamic_clients Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/eap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/totp Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/detail.log Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/radutmp Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/attr_filter Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/exec Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/linelog Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/digest Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/pap Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/detail Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/unpack Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/files Wed Sep 22 15:21:50 2021 : Debug: including configuration file /etc/freeradius/mods-enabled/sql *Wed Sep 22 15:21:50 2021 : Error: /etc/freeradius/mods-enabled/sql[365]: Reference "${dialect}" not foundWed Sep 22 15:21:50 2021 : Error: Errors reading or parsing /etc/freeradius/radiusd.co <http://radiusd.co>*nf in mods-enabled/sql I have the below: dialect = "mysql" driver = "rlm_sql_${dialect}" I tried changing it to mysql instead of ${dialect}, still the same error. Thanks.

6 29

Block guest VPN
by Sazzad Hossain 22 Sep '21

22 Sep '21

Hello, At first, Thanks in advance for your valuable time! I want to block our Guest users to use our VPN and i wrote following under / sites-enable/default. *ldap* * if (Ldap-Group [*] == "Gast") { update control { AUth-Type = reject } }* and under /freeradius/users *DEFAULT Ldap-Group == "Gast", Auth-Type := Reject Fall-Through = yes* when i compile it then shows the following output. ________________________________________________________________ root@xx:~# freeradius -X FreeRADIUS Version 3.0.20 Copyright (C) 1999-2019 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/3.0/dictionary including configuration file /etc/freeradius/3.0/radiusd.conf including configuration file /etc/freeradius/3.0/proxy.conf including configuration file /etc/freeradius/3.0/clients.conf including files in directory /etc/freeradius/3.0/mods-enabled/ including configuration file /etc/freeradius/3.0/mods-enabled/echo including configuration file /etc/freeradius/3.0/mods-enabled/replicate including configuration file /etc/freeradius/3.0/mods-enabled/cache_eap including configuration file /etc/freeradius/3.0/mods-enabled/radutmp including configuration file /etc/freeradius/3.0/mods-enabled/ntlm_auth including configuration file /etc/freeradius/3.0/mods-enabled/linelog including configuration file /etc/freeradius/3.0/mods-enabled/chap including configuration file /etc/freeradius/3.0/mods-enabled/passwd including configuration file /etc/freeradius/3.0/mods-enabled/realm including configuration file /etc/freeradius/3.0/mods-enabled/dynamic_clients including configuration file /etc/freeradius/3.0/mods-enabled/attr_filter including configuration file /etc/freeradius/3.0/mods-enabled/detail.log including configuration file /etc/freeradius/3.0/mods-enabled/preprocess including configuration file /etc/freeradius/3.0/mods-enabled/eap including configuration file /etc/freeradius/3.0/mods-enabled/always including configuration file /etc/freeradius/3.0/mods-enabled/sradutmp including configuration file /etc/freeradius/3.0/mods-enabled/ldap including configuration file /etc/freeradius/3.0/mods-enabled/logintime including configuration file /etc/freeradius/3.0/mods-enabled/digest including configuration file /etc/freeradius/3.0/mods-enabled/unix including configuration file /etc/freeradius/3.0/mods-enabled/utf8 including configuration file /etc/freeradius/3.0/mods-enabled/files including configuration file /etc/freeradius/3.0/mods-enabled/mschap including configuration file /etc/freeradius/3.0/mods-enabled/soh including configuration file /etc/freeradius/3.0/mods-enabled/unpack including configuration file /etc/freeradius/3.0/mods-enabled/expiration including configuration file /etc/freeradius/3.0/mods-enabled/pap including configuration file /etc/freeradius/3.0/mods-enabled/exec including configuration file /etc/freeradius/3.0/mods-enabled/expr including configuration file /etc/freeradius/3.0/mods-enabled/detail including files in directory /etc/freeradius/3.0/policy.d/ including configuration file /etc/freeradius/3.0/policy.d/cui including configuration file /etc/freeradius/3.0/policy.d/filter including configuration file /etc/freeradius/3.0/policy.d/dhcp including configuration file /etc/freeradius/3.0/policy.d/canonicalization including configuration file /etc/freeradius/3.0/policy.d/abfab-tr including configuration file /etc/freeradius/3.0/policy.d/rfc7542 including configuration file /etc/freeradius/3.0/policy.d/accounting including configuration file /etc/freeradius/3.0/policy.d/eap including configuration file /etc/freeradius/3.0/policy.d/control including configuration file /etc/freeradius/3.0/policy.d/moonshot-targeted-ids including configuration file /etc/freeradius/3.0/policy.d/operator-name including configuration file /etc/freeradius/3.0/policy.d/debug including files in directory /etc/freeradius/3.0/sites-enabled/ including configuration file /etc/freeradius/3.0/sites-enabled/inner-tunnel including configuration file /etc/freeradius/3.0/sites-enabled/default /etc/freeradius/3.0/sites-enabled/default[426]: *Parse error in condition* /etc/freeradius/3.0/sites-enabled/default[426]: (*Ldap-Group [*] == "Gast") {* /etc/freeradius/3.0/sites-enabled/default[426]: *^ Invalid text. Expected comparison operator* *Errors reading or parsing /etc/freeradius/3.0/radiusd.conf* Any suggestion please? Have a nice day! Regards!

3 8

FR 3.0.23 - bad talloc magic value - unknown value
by Micha Ballmann 21 Sep '21

21 Sep '21

Hi, I tried to upgrade my radius server from version 3.0.22 to 3.0.23. First i thought it worked but after few moments radiusd crashes with the follow notification: --bad talloc magic value - unknown value-- If i restart radiusd it works for few seconds and it also crashes with the same error. Im using ntlm_auth, eap, mschap for authentication against my samba4 AD DC. No problems in version 3.0.22. I rolled back to 3.0.22. BR ff

2 5

Freeradius , AD and Mikrotik Integration
by ReZa Esfahani 19 Sep '21

19 Sep '21

hello .i really need help .i have a Microsoft Active Directory in my network as a user database , and i installed freeradius as my radius server for wireless users and i have mikrotik router which i implement Nat ,Qos and Queue for bandwidth management .i integrate my freeradius with Active Directory so wireless user can authenticate via Active Directory. but my problem is how can i send user attributes to mikrotik for limiting RX and Tx bandwidth while users are not in Freeradius user file . how can i tell mikrotik to create a queue for that user which authenticates via Active Directory. thank you

3 4

Best Script
by mohamed almeshal 17 Sep '21

17 Sep '21

dear savers, which lanaguge is the best for writing the external script for implement in freeradius , bash , php . thanks alot

2 1

Problem when trying to store NAS-Port-ID into radpostauth table
by Antônio Modesto 17 Sep '21

17 Sep '21

Hi, I added a column to the radpostauth table to store the NAS-Port-ID, but I am noticing a strange behaviour for a specific type of NAS. Using tcpdump, I can see that the NAS-Port-Id attributes arrives in the following format: NAS-Port-Id Attribute (87), length: 38, Value: slot=0;subslot=2;port=1;vlanid=1110; But when I check what is being stored in the radpostauth table and in the radacct table, I get something like this: slot=3D3D0=3D3Bsubslot=3D3D2=3D3Bport=3D3D0=3D3Bvlanid=3D3D1001=3D3B I am using the following expression in my queries.conf to get the value of this attribute from the request: NULLIF('%{%{NAS-Port-ID}:-%{NAS-Port}}', '') It seems like unlang is encoding the value somehow. Do you guys have any suggestion?

3 10

eap_tls: Failed to read from child output
by Burn Zero 16 Sep '21

16 Sep '21

Hi, Our laptops are using Certificate authentication (EAP-TLS) to connect to the wifi network. Sometimes, I get the following errors in FreeRADIUS servers: Fri Sep 10 10:59:58 2021 : Auth: (185911) Login incorrect (eap_tls: Failed to read from child output): [machinename] (from client WIFI-WLC port 49315 cli Fri Sep 10 10:59:59 2021 : Auth: (185947) Login incorrect (eap_tls: Failed to read from child output): [machinename] (from client WIFI-WLC port 49315 cli Fri Sep 10 10:59:59 2021 : Auth: (185951) Login incorrect (eap_tls: Failed to read from child output): [machinename] (from client WIFI-WLC port 49315 cli Fri Sep 10 10:59:59 2021 : Auth: (185949) Login incorrect (eap_tls: Failed to read from child output): [machinename] (from client WIFI-WLC port 49315 cli Fri Sep 10 10:59:59 2021 : Auth: (185986) Login incorrect (eap_tls: Failed to read from child output): [machinename] (from client WIFI-WLC port 49315 cli It is very random and also we are not able to reproduce the issue. I have searched on the internet and freeradius mailing list archives and I don't see such issues discussed before. Could you please help on how to move forward? Thank you.

2 1

StrongSwan IKEv2 - eap-radius - Auth Failing
by Chris Myburgh 15 Sep '21

15 Sep '21

Hi Freeradius Users I am hoping you can help me. I have been battling the past couple of days getting StrongSwan (5.9.3) IKEv2 authentication by eap-radius to work. FreeRADIUS Version 3.0.23 ............ ............ ............ | (5) eap: Expiring EAP session with state 0x98fe0da799fc17eb | (5) eap: Finished EAP session with state 0x98fe0da799fc17eb | (5) eap: Previous EAP request found for state 0x98fe0da799fc17eb, released from the list | (5) eap: Peer sent packet with method EAP MSCHAPv2 (26) | (5) eap: Calling submodule eap_mschapv2 to process data | (5) eap_mschapv2: # Executing group from file /etc/raddb/sites-enabled/default | (5) eap_mschapv2: authenticate { | (5) mschap: WARNING: No Cleartext-Password configured. Cannot create NT-Password | (5) mschap: Creating challenge hash with username: chris | (5) mschap: Client is using MS-CHAPv2 | (5) mschap: ERROR: FAILED: No NT-Password. Cannot perform authentication | (5) mschap: ERROR: MS-CHAP2-Response is incorrect ............ ............ ............ | (5) } # Post-Auth-Type REJECT = updated | (5) Login incorrect (mschap: FAILED: No NT-Password. Cannot perform authentication): [chris/<via Auth-Type = eap>] (from client rad_clients port 8 cli 172.29.0.1[55829]) | (5) Delaying response for 1.000000 seconds | Waking up in 0.6 seconds. ================== Freeradius is using the MySQL driver (driver = "rlm_sql_mysql") and the eap module is set to use md5 as the default (default_eap_type = md5). When I do radtests directly to radius, I receive "Access-Accept" for PAP,CHAP & MSCHAP authentication types. However, radtest authentication type eap-md5 also fails stating that there is no cleartext-password in the radius logs. My users in freeradius are configured in the radcheck table with the following: ------------------------------------------------------------------------------------ id | username | attribute | op | value ================================================ 1 | chris | Cleartext-Password | := | chris12345 ------------------------------------------------------------------------------------ I've been up and down the configuration, but I cannot seem to figure it out. To me it seems that when I use the eap for authentication, it fails to lookup the radcheck table for the password. Any assistance or additional information I can provide to help the investigation? TIA __ Regards Chris Myburgh

2 5

Re: Checkrad and IPv6 NAS IP address
by Fabricio Viana 15 Sep '21

15 Sep '21

Hello! > I'll have to take a look. I'm pretty busy this week, so it might be a bit. > Alan DeKok. All right. Thanks for letting me know. I will follow the list and GitHub (v3.0.x branch). Regards Fabricio Viana

1 0

Good guest WLAN portal solution?
by Michael Schwartzkopff 15 Sep '21

15 Sep '21

Hi, perhaps this question is not completely FR related. But I'd like to ask this community anyway. What solution can you recommend for a Guest WLAN setup? We need a solution that provides a capture portal, so that the user can generate a OTP for a limited access. Also there must be a portal that the user agrees to the terms & conditions and only after agreement gets access. Mit freundlichen Grüßen, -- [*] sys4 AG https://sys4.de, +49 (89) 30 90 46 64 Schleißheimer Straße 26/MG,80333 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Marc Schiffbauer, Wolfgang Stief Aufsichtsratsvorsitzender: Florian Kirstein

1 0

Relase estimation for version 4?
by Michael Schwartzkopff 15 Sep '21

15 Sep '21

Hi, is there any estimation for a release date for the version 4 of FR? We would like to see the TACACS feature in the software. Then we could suggest my customer to switch from a commercial RADIUS server to FR. I assume that networkradius also will support the new features of version 4. Mit freundlichen Grüßen, -- [*] sys4 AG https://sys4.de, +49 (89) 30 90 46 64 Schleißheimer Straße 26/MG,80333 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Marc Schiffbauer, Wolfgang Stief Aufsichtsratsvorsitzender: Florian Kirstein

2 1

Two frreadius are connected to the same AD, and the first one is unavailable
by yanyi5496＠gmail.com 14 Sep '21

14 Sep '21

I have two freeradius on different ubuntu server, and I use freeradius to connect AD, when I configure freeradius A to connect AD, freeradius A was working, then I configure freeradius B to connect AD with same user and password, freeradius B was working, but freeradius A didn`t work, I checked their configuration, they arm same, freeradius A log is as follows: Tue Sep 14 03:02:26 2021 : Error: Program returned code (1) and output 'NT_STATUS_WRONG_PASSWORD: When trying to update a password, this return status indicates that the value provided as the current password is not correct. (0xc000006a)' Tue Sep 14 03:02:26 2021 : Auth: (3) Login incorrect: [sqauser/xxxxxxx] (from client 127.0.0.1 port 2 cli xxxxxxxxx) I make sure I use the correct account information, I don't know what went wrong, freeradius configuration or AD configuration. I'm really confused. Thanks Jason Chen

2 1