- Freeradius-Users - lists.freeradius.org

Prometheus module on FreeRADIUS 3.2.4
by dominic.stalder＠unibe.ch 08 Jun '24

08 Jun '24

Hi guys First of all, I wanted to let you know, that I was – w/o any problems – able to upgrade from FreeRADIUS 3.0.26 (Ubuntu own packages: /etc/freeradius/3.0) to FreeRADIUS 3.2.4 (networkRADIUS packages: /etc/freeradius); thanks for that. Now I would like to start from scratch with monitoring our FreeRADIUS infrastructure and would like to use Prometheus to export the data (primarly service status and RADIUS statistics) and Grafana to visualize it: 1. Does this setup sound reasonable to you guys? 2. I read, that FreeRADIUS does come with the Prometheus (exporter) module included, but I can not find it in /etc/freeradius/mods-available. If not, how can I install / enable the Prometheus module for a FreeRADIUS 3.2.4 version? The github repo for Prometheus says: Prometheus exporter for FreeRADIUS metrics. Supports FreeRADIUS 3.0.x. 3. Does anyone have FreeRADIUS 3.2 and Prometheus already working right now? Thanks a lot for any help provided and best regards Dominic _________________________________ Universität Bern Abteilung Informatikdienste Dominic Stalder Network Engineer Hochschulstrasse 6 CH-3012 Bern Tel. +41 (0)31 684 38 18 dominic.stalder(a)unibe.ch<mailto:dominic.stalder@unibe.ch> www.id.unibe.ch _________________________________

2 2

Assign user to a realm.
by Deepansha Gaur 03 Jun '24

03 Jun '24

Hi team, I am trying to assign VLANs to different realms, and only a few users to be part of a given realm. E.g.: user1 and user2 are part of @staff and should be assigned VLAN 123 user3 and user4 are part of @student and should be assigned 98 If a user is not part of a realm, he should be denied. Could you please help me on how I can assign a user to a realm? Thanks for your help. Regards, *Deepansha Gaur*

2 6

EAP Fast Reauth fails
by deepika parmar 03 Jun '24

03 Jun '24

Hello, I have configured *EAP-AKA virtual-server in FreeRADIUS to perform authentication. I have enabled eap cache so that fast reauth will work and session data will be stored in cache. However during store session i could not restore Counter and hence reauth fails. Logs are: Debug : (0.0) h9-auth-server - store session { Debug : (0.0) h9-auth-server - | debug_attr INFO : (0.0) h9-auth-server - Attributes matching "&session-state" INFO : (0.0) h9-auth-server - &session-State.session-State = { INFO : (0.0) h9-auth-server - Permanent-Identity = 10026000000000(a)wlan.mnc11343.mcc0.3gppnetwork.org INFO : (0.0) h9-auth-server - SIM-Ki = 0x465b5ce8b199b49faa5f0a2ee238a6bc INFO : (0.0) h9-auth-server - SIM-OPc = 0xcd63cb71954a9f4e48a5994e37a02baf INFO : (0.0) h9-auth-server - SIM-SQN = 528 INFO : (0.0) h9-auth-server - Identity = 27CL9C1yARfBU1l(a)wlan.mnc11343.mcc0.3gppnetwork.org INFO : (0.0) h9-auth-server - Session-Data = 0xd9407284e28f09c788dd047dbd2350adcf91a5ef INFO : (0.0) h9-auth-server - Counter = 0 >>>>>>>>>>>>>>>>> Counter is available here....>>>>>> INFO : (0.0) h9-auth-server - } Debug : (0.0) h9-auth-server - | eap-aka-sim.Session-ID Debug : (0.0) h9-auth-server - | %{eap-aka-sim.Session-ID} Debug : (0.0) h9-auth-server - | --> 0x34374631353345367a547775664157 Debug : (0.0) eap_aka_cache - No cache entry found for "47F153E6zTwufAW" Debug : (0.0) eap_aka_cache - Creating new cache entry Debug : (0.0) eap_aka_cache - &session-State.Session-Data := &session-State.Session-Data -> 0xd9407284e28f09c788dd047dbd2350adcf91a5ef Debug : (0.0) eap_aka_cache - EXPAND %{session-state.Permanent-Identity} Debug : (0.0) eap_aka_cache - | session-state.Permanent-Identity Debug : (0.0) eap_aka_cache - | %{session-state.Permanent-Identity} Debug : (0.0) eap_aka_cache - | --> 10026000000000(a)wlan.mnc11343.mcc0.3gppnetwork.org Debug : (0.0) eap_aka_cache - --> 10026000000000(a)wlan.mnc11343.mcc0.3gppnetwork.org Debug : (0.0) eap_aka_cache - &session-State.Permanent-Identity := "10026000000000(a)wlan.mnc11343.mcc0.3gppnetwork.org" Debug : (0.0) eap_aka_cache - EXPAND %{session-state.Encr-Data.Counter} Debug : (0.0) eap_aka_cache - | session-state.Encr-Data.Counter Debug : (0.0) eap_aka_cache - | %{session-state.Encr-Data.Counter} Debug : (0.0) eap_aka_cache - (null) Debug : (0.0) eap_aka_cache - --> Debug : (0.0) eap_aka_cache - Skipping %{session-state.Encr-Data.Counter} Debug : (0.0) eap_aka_cache - Committed entry, TTL 150 seconds Debug : (0.0) h9-auth-server - eap_aka_cache (updated) Session is stored in eap cache however it could not store Counter as its value is nil in Encr-Data and direct access to Counter in session-state is failing. During Reauth request , it could fetch the session from the cache but as Counter is not there, fast reauth is failing... Debug : (2.0) h9-auth-server - New EAP-AKA session Debug : (2.0) h9-auth-server - Changed state INIT -> REAUTHENTICATION Debug : (2.0) h9-auth-server - load session { Debug : (2.0) h9-auth-server - | eap-aka-sim.Session-ID Debug : (2.0) h9-auth-server - | %{eap-aka-sim.Session-ID} Debug : (2.0) h9-auth-server - | --> 0x34374631353345367a547775664157 Debug : (2.0) eap_aka_cache - Found entry for "47F153E6zTwufAW" Debug : (2.0) eap_aka_cache - Merging cache entry into request Debug : (2.0) eap_aka_cache - &session-State.Session-Data := 0xd9407284e28f09c788dd047dbd2350adcf91a5ef Debug : (2.0) eap_aka_cache - &session-State.Permanent-Identity := '10026000000000(a)wlan.mnc11343.mcc0.3gppnetwork.org' Debug : (2.0) h9-auth-server - eap_aka_cache (updated) Debug : (2.0) h9-auth-server - ok (ok) Debug : (2.0) h9-auth-server - | debug_attr INFO : (2.0) h9-auth-server - Attributes matching "&session-state" INFO : (2.0) h9-auth-server - &session-State.session-State = { INFO : (2.0) h9-auth-server - Session-Data = 0xd9407284e28f09c788dd047dbd2350adcf91a5ef INFO : (2.0) h9-auth-server - Permanent-Identity = 10026000000000(a)wlan.mnc11343.mcc0.3gppnetwork.org INFO : (2.0) h9-auth-server - } Debug : (2.0) h9-auth-server - | %debug_attr({&session-state}) Debug : (2.0) h9-auth-server - } # send Reauthentication-Request (ok) Debug : (2.0) h9-auth-server - Generating new session keys Debug : (2.0) h9-auth-server - No &session-state.Counter attribute found, can't calculate re-auth keys Debug : (2.0) h9-auth-server - Composing EAP-Request/Reauthentication failed. Clearing reply attributes and requesting additional Identity Debug : (2.0) h9-auth-server - Changed state REAUTHENTICATION -> AKA-IDENTITY Debug : (2.0) h9-auth-server - send Identity-Request { Store session setting in virtual server: store session { "%(debug_attr:&session-state)" eap_aka_cache "%(debug_attr:&session-state)" ok } Currently my eap_cache is cache eap_aka_cache { # # key:: Cache key. # key = "%{eap-aka-sim.Session-ID}" # # ttl:: TTL for cache entries. # ttl = 150 # # update <section> { ... }:: # update session-state { &session-state.Session-Data := &session-state.Session-Data &Permanent-Identity := "%{session-state.Permanent-Identity}" &Encr-Data.Counter := "%{session-state.Encr-Data.Counter}" } } If i add accessing Counter, it fails as follows: &session-state.Counter := &session-state.Counter Debug : Compiling policies in - store session {...} Error : /usr/local/etc/raddb/mods-enabled/eap-cache[22]: Failed parsing attribute reference &session-state.Counter - Unresolved attributes are not allowed here Error : /usr/local/etc/raddb/mods-enabled/eap-cache[22]: &session-state.Counter Error : /usr/local/etc/raddb/mods-enabled/eap-cache[22]: ^ Error : /usr/local/etc/raddb/mods-enabled/eap-cache[22]: Failed creating map from '&session-state.Counter = &session-state.Counter' Error : /usr/local/etc/raddb/mods-enabled/eap-cache[1]: Failed parsing configuration section update Error : /usr/local/etc/raddb/sites-enabled/h9-auth-server[1006]: Invalid keyword "eap_aka_cache". Am i missing any configuration? Can anyone help? Summary of my setup: * FreeRadius version4 - Configured, compiled and installed from master Branch synced on 10th May 2024. * wpa_supplicant version 2.10 * Ubuntu 20.04 LTS Thanks, Deepika

2 4

IP Addr Comparison
by BOUILLOUD Corentin 03 Jun '24

03 Jun '24

Hi Team, I would like to ask your help about IP address comparisons in FreeRADIUS 3.0.27. I want to restrict a mac-address to a network, but comparison of ip address with a subnet doesn't seems to work as a check items : 11-22-33-44-55-66 NAS-IP-Address < 192.168.8.0/22 /etc/freeradius/3.0/authorized_macs[10]: Parse error (check) for entry 11-22-33-44-55-66: Invalid IPv4 mask length "/22". Only "/32" permitted for non-prefix types Yet, documentation says it should be possible. "The syntax allows conditions such as 192.0.2.1 < 192.0.2/24. This condition will return true, as the IP address 192.0.2.1' is within the network `192.0.2/24." I also tried casting the attribute, without success : 11-22-33-44-55-66 <ipaddr>NAS-IP-Address < "192.168.8.0/22" /etc/freeradius/3.0/authorized_macs[10]: Parse error (check) for entry 11-22-33-44-55-66: Invalid attribute name Do user files have a different behaviour for comparisons and casting ? I could use regex as a backup solution but it's quickly going to get difficult to read in the file : 11-22-33-44-55-66 NAS-IP-Address =~ "/^192\.168\.(8|9|10|11)\./" https://freeradius.org/documentation/freeradius-server/4.0.0/raddb/mods-con… https://freeradius.org/documentation/freeradius-server/3.0.27/unlang/condit… https://freeradius.org/documentation/freeradius-server/3.0.27/unlang/condit… Regards, Corentin BOUILLOUD ======================================================== This message has been scanned for malware. This message and any attachments (the "message") are confidential, intended solely for the addressees, and may contain legally privileged information. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither our company or any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified. ========================================================= Ce message a ete verifie et ne contient pas de programme malveillant. Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et susceptibles de contenir des informations couvertes par le secret professionnel. Ce message est etabli a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisee est interdite. Tout message electronique est susceptible d'alteration. Notre societe et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme falsifie. O =========================================================

3 5

Access-Request counter on accounting server with TCP/TLS & Freeradius Proxy
by Marcin Majkowski 31 May '24

31 May '24

Greetings, I've encountered a rising number of Access-Request, when I've switched proxy.conf from Replicate-To-Realm by udp to Proxy-To-Realm with tcp+tls. Number of Access-Request is gathered via builtin status server in accounting server. [echo -e "Message-Authenticator = 0x00\nFreeRADIUS-Statistics-Type = 3" | radclient -x 127.0.0.1:18121 status pass-pass ] What I mean by rising, from noise level ~1 req/s upto 200 req/s. After some debug, to my surprise there is no significant number of Access-Request in stdout when running freeradius acct in foreground mode as freeradius -fxxx -l stdout. Apart from Access-Accept sent to Status-Server which is expected/fine. Setup is: 3 hosts (proxy/auth/acct) with: radiusd: FreeRADIUS Version 3.2.4 (git #7e8f34ec5) [ FreeRADIUS Version 3.2.3 (git #db3d1924d) - was also affected ] 1st host is acting only as proxy, it forwards request to acct and auth servers via local haproxy(tcp+tls). Haproxy is configured to listen on different ports for both and in proxy.conf servers are set as different under same realm. (I've also set them to different realms accordingly, no change) Is it a expected behaviour when using Proxy-To-Realm instead of Replicate-To-Realm?

2 1

3.2.4 Debian Bookworm via networkradius.com packages
by Jack Carter 30 May '24

30 May '24

Hi all, Can someone confirm if I’m using the freeRADIUS Packages from networkradius.com and select the following that I should be running 3.2.4? * FreeRADIUS 3.2 - stable with latest features (recommended)<https://networkradius.com/packages/#fr32> * Debian * Debian 12 “Bookworm” When I run freedradius -v it says 3.2.1 which looks like the main Debian package version. Interestingly when I saw Alan’s email about 3.2.4 and I ran sudo apt update and sudo apt upgrade freeradius-common was upgraded. I have confirmed the NetworkRADIUS PGP public key is present as well as APT preferences file and sources list plus when I run sudo apt update I can see the following: Hit:1 http://packages.networkradius.com/freeradius-3.2/debian/bookworm bookworm InRelease Again, if someone could confirm if 3.2.1 is correct or if this method should install 3.2.4 that would be great. I’m running on a Raspberry Pi 3B+ Linux 6.6.28+rpt-rpi-v8 #1 SMP PREEMPT Debian 1:6.6.28-1+rpt1 (2024-04-22) aarch64 GNU/Linux. Many thanks, Jack

2 2

Tuning freeradius memory usage for small footprint machines
by Peter Thomas (pethoma2) 30 May '24

30 May '24

I'm working on setting up FreeRADIUS on some pretty small servers with limited memory. I was wondering if anyone here has tips or tricks for reducing the memory footprint of FreeRADIUS. Are there any config tweaks to lower memory usage? I am running version 3.2.3 and the servers have about 256MB of RAM. Thanks, Pete

3 6

3.2.4 upgrade messed up?
by Jonathan Chan 30 May '24

30 May '24

Hi, I've attempted to upgrade FreeRADIUS from 3.2.3 to 3.2.4 on two test machines running Ubuntu 24. After the upgrade, I noticed the directory structure was off, with files residing outside of the 3.0 directory, and running freeradius -X would no longer load (not really the purpose of this message). Did I do something wrong with the upgrade? Below is the output of the folder structure of ls -al /etc/freeradius after doing the upgrade. jonathan@vm:~$ sudo ls -al /etc/freeradius/ total 168 drwxr-s--- 10 freerad freerad 4096 May 30 03:37 . drwxr-xr-x 110 root root 4096 May 30 03:37 .. drwxr-xr-x 9 freerad freerad 4096 May 30 03:37 3.0 drwxr-xr-x 3 root root 4096 May 30 03:37 certs -rw-r--r-- 1 root root 9054 May 29 18:42 clients.conf -rw-r--r-- 1 root root 1420 May 29 18:42 dictionary -rw-r--r-- 1 root root 2661 May 29 18:42 experimental.conf lrwxrwxrwx 1 root root 28 May 29 18:42 hints -> mods-config/preprocess/hints lrwxrwxrwx 1 root root 33 May 29 18:42 huntgroups -> mods-config/preprocess/huntgroups drwxr-xr-x 2 root root 4096 May 30 03:37 mods-available drwxr-xr-x 10 root root 4096 May 30 03:37 mods-config drwxr-xr-x 2 root root 4096 May 30 03:37 mods-enabled -rw-r--r-- 1 root root 52 May 29 18:42 panic.gdb drwxr-xr-x 2 root root 4096 May 30 03:37 policy.d -rw-r--r-- 1 root root 29779 May 29 18:42 proxy.conf -rw-r--r-- 1 root root 31890 May 29 18:42 radiusd.conf -rw-r--r-- 1 root root 20754 May 29 18:42 README.rst drwxr-xr-x 2 root root 4096 May 30 03:37 sites-available drwxr-xr-x 2 root root 4096 May 30 03:37 sites-enabled -rw-r--r-- 1 root root 3470 May 29 18:42 templates.conf -rw-r--r-- 1 root root 8536 May 29 18:42 trigger.conf lrwxrwxrwx 1 root root 27 May 29 18:42 users -> mods-config/files/authorize jonathan@vm:~$ sudo ls -al /etc/freeradius/3.0 total 176 drwxr-xr-x 9 freerad freerad 4096 May 30 03:37 . drwxr-s--- 10 freerad freerad 4096 May 30 03:37 .. drwxr-xr-x 2 freerad freerad 4096 May 1 08:22 certs -rw-r----- 1 freerad freerad 8330 May 21 02:03 clients.conf -rw-r----- 1 root root 8323 May 11 09:59 clients.conf.orig -rw-r----- 1 freerad freerad 1420 Mar 31 05:22 dictionary -rw-r----- 1 freerad freerad 2661 Mar 31 05:22 experimental.conf drwxr-xr-x 2 freerad freerad 4096 May 21 19:12 mods-available drwxr-xr-x 10 freerad freerad 4096 May 1 08:22 mods-config drwxr-xr-x 2 freerad freerad 4096 May 1 08:22 mods-enabled -rw-r----- 1 freerad freerad 52 Mar 31 05:22 panic.gdb drwxr-xr-x 2 freerad freerad 4096 May 1 08:22 policy.d -rw-r----- 1 freerad freerad 30005 May 21 20:41 proxy.conf -rw-r----- 1 freerad freerad 30773 Mar 31 05:22 radiusd.conf -rw-r----- 1 freerad freerad 20754 Mar 31 05:22 README.rst drwxr-xr-x 2 freerad freerad 4096 May 30 03:18 sites-available drwxr-xr-x 2 freerad freerad 4096 May 21 04:36 sites-enabled -rw-r----- 1 freerad freerad 3470 Mar 31 05:22 templates.conf -rw-r----- 1 freerad freerad 8536 Mar 31 05:22 trigger.conf And here's the output from running sudo apt install freeradius: jonathan@vm:~$ sudo apt install freeradius Reading package lists... Done Building dependency tree... Done Reading state information... Done The following packages were automatically installed and are no longer required: freetds-common libct4 libdbi-perl Use 'sudo apt autoremove' to remove them. The following additional packages will be installed: freeradius-common freeradius-config freeradius-python3 freeradius-utils libfreeradius3 libpcre3 Suggested packages: freeradius-ldap freeradius-postgresql freeradius-mysql freeradius-krb5 snmp The following NEW packages will be installed: freeradius-python3 libpcre3 The following packages will be upgraded: freeradius freeradius-common freeradius-config freeradius-utils libfreeradius3 5 upgraded, 2 newly installed, 0 to remove and 21 not upgraded. Need to get 2,815 kB of archives. After this operation, 2,025 kB of additional disk space will be used. Do you want to continue? [Y/n] Get:1 http://us.archive.ubuntu.com/ubuntu noble/universe amd64 libpcre3 amd64 2:8.39-15build1 [248 kB] Get:2 http://packages.networkradius.com/freeradius-3.2/ubuntu/noble noble/main amd64 freeradius-common all 3.2.4-1 [248 kB] Get:3 http://packages.networkradius.com/freeradius-3.2/ubuntu/noble noble/main amd64 freeradius-config amd64 3.2.4-1 [216 kB] Get:4 http://packages.networkradius.com/freeradius-3.2/ubuntu/noble noble/main amd64 freeradius-utils amd64 3.2.4-1 [116 kB] Get:5 http://packages.networkradius.com/freeradius-3.2/ubuntu/noble noble/main amd64 freeradius amd64 3.2.4-1 [1,761 kB] Get:6 http://packages.networkradius.com/freeradius-3.2/ubuntu/noble noble/main amd64 libfreeradius3 amd64 3.2.4-1 [204 kB] Get:7 http://packages.networkradius.com/freeradius-3.2/ubuntu/noble noble/main amd64 freeradius-python3 amd64 3.2.4-1 [21.5 kB] Fetched 2,815 kB in 2s (1,462 kB/s) (Reading database ... 84870 files and directories currently installed.) Preparing to unpack .../0-freeradius-common_3.2.4-1_all.deb ... Unpacking freeradius-common (3.2.4-1) over (3.2.3+dfsg-2build7) ... Preparing to unpack .../1-freeradius-config_3.2.4-1_amd64.deb ... Unpacking freeradius-config (3.2.4-1) over (3.2.3+dfsg-2build7) ... dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/sites-enabled': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/sites-available': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/policy.d': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-enabled': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/unbound': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/moonshot-targeted-ids/sqlite': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/moonshot-targeted-ids/postgresql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/moonshot-targeted-ids/mysql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/moonshot-targeted-ids': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/sqlite': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/postgresql/extras': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/postgresql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/oracle': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/ndb': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/mysql/extras/wimax': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/mysql/extras': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/mysql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/mssql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main/mongo': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/main': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool-dhcp/sqlite': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool-dhcp/postgresql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool-dhcp/oracle': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool-dhcp/mysql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool-dhcp/mssql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool-dhcp': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool/sqlite': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool/postgresql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool/oracle': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool/mysql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool/mssql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool/mongo': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/ippool': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/dhcp/sqlite': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/dhcp/postgresql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/dhcp/oracle': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/dhcp/mysql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/dhcp/mssql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/dhcp': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/cui/sqlite': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/cui/postgresql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/cui/mysql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/cui': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/counter/sqlite': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/counter/postgresql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/counter/mysql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql/counter': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/sql': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/realm': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/python3': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/preprocess': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/perl': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/files': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config/attr_filter': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-config': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/mods-available': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0/certs': Directory not empty dpkg: warning: unable to delete old directory '/etc/freeradius/3.0': Directory not empty Selecting previously unselected package libpcre3:amd64. Preparing to unpack .../2-libpcre3_2%3a8.39-15build1_amd64.deb ... Unpacking libpcre3:amd64 (2:8.39-15build1) ... Preparing to unpack .../3-freeradius-utils_3.2.4-1_amd64.deb ... Unpacking freeradius-utils (3.2.4-1) over (3.2.3+dfsg-2build7) ... Preparing to unpack .../4-freeradius_3.2.4-1_amd64.deb ... Unpacking freeradius (3.2.4-1) over (3.2.3+dfsg-2build7) ... Preparing to unpack .../5-libfreeradius3_3.2.4-1_amd64.deb ... Unpacking libfreeradius3 (3.2.4-1) over (3.2.3+dfsg-2build7) ... Selecting previously unselected package freeradius-python3. Preparing to unpack .../6-freeradius-python3_3.2.4-1_amd64.deb ... Unpacking freeradius-python3 (3.2.4-1) ... Setting up libpcre3:amd64 (2:8.39-15build1) ... Setting up freeradius-common (3.2.4-1) ... Setting up libfreeradius3 (3.2.4-1) ... Setting up freeradius-config (3.2.4-1) ... Setting up freeradius (3.2.4-1) ... Installing new version of config file /etc/default/freeradius ... Installing new version of config file /etc/init.d/freeradius ... Installing new version of config file /etc/logrotate.d/freeradius ... Warning: The unit file, source configuration file or drop-ins of freeradius.service changed on disk. Run 'systemctl daemon-reload' to reload units. Job for freeradius.service failed because the control process exited with error code. See "systemctl status freeradius.service" and "journalctl -xeu freeradius.service" for details. invoke-rc.d: initscript freeradius, action "restart" failed. ● freeradius.service - FreeRADIUS multi-protocol policy server Loaded: loaded (/usr/lib/systemd/system/freeradius.service; enabled; preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Thu 2024-05-30 03:37:48 UTC; 57ms ago Docs: man:radiusd(8) man:radiusd.conf(5) http://wiki.freeradius.org/ http://networkradius.com/doc/ Process: 1926 ExecStartPre=/usr/sbin/freeradius $FREERADIUS_OPTIONS -Cx -lstdout (code=exited, status=1/FAILURE) CPU: 219ms Warning: The unit file, source configuration file or drop-ins of freeradius.service changed on disk. Run 'systemctl daemon-reload' to reload units. Setting up freeradius-python3 (3.2.4-1) ... Warning: The unit file, source configuration file or drop-ins of freeradius.service changed on disk. Run 'systemctl daemon-reload' to reload units. freeradius.service is not active, cannot reload. invoke-rc.d: initscript freeradius, action "force-reload" failed. Setting up freeradius-utils (3.2.4-1) ... Processing triggers for man-db (2.12.0-4build2) ... Processing triggers for libc-bin (2.39-0ubuntu8.1) ... Scanning processes... Scanning linux images... Running kernel seems to be up-to-date. No services need to be restarted. No containers need to be restarted. No user sessions are running outdated binaries. No VM guests are running outdated hypervisor (qemu) binaries on this host.

2 1

FreeRADIUS DHCP Server is receiving requests but not replying
by Jan-Willem Curinckx 28 May '24

28 May '24

The FreeRADIUS DHCP 3.2.2 Server on Ubuntu 24.04 I had issues with last time starts without displaying errors, however as I'm testing the functionalities by sending packets from a different host, the DHCP server only receives requests without replying. Thanks in advance, Kind regards, Jan-Willem Curinckx The dhcpclient sending packets from a different host: root@frituur:~# dhcpclient 193.191.177.231:6700 -f dhcp-packet.txt -x discover DHCP-Client-Identifier := 0x616263313233 ---------------------------------------------------------------------- DHCP-Opcode = 0x01 DHCP-Hardware-Type = 0x01 DHCP-Hardware-Address-Length = 0x06 DHCP-Hop-Count = 0x00 DHCP-Transaction-Id = 0x3603f3f3 DHCP-Number-of-Seconds = 0x0000 DHCP-Flags = 0x0000 DHCP-Client-IP-Address = 0x00000000 DHCP-Your-IP-Address = 0x00000000 DHCP-Server-IP-Address = 0x00000000 DHCP-Gateway-IP-Address = 0x00000000 DHCP-Client-Hardware-Address = 0x0201aabbccdd00000000000000000000 DHCP-Server-Host-Name = 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 DHCP-Boot-Filename = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 63 82 53 63 35 01 01 3d 06 61 62 63 31 32 33 ---------------------------------------------------------------------- dhcpclient: Error receiving reply: Failed reading DHCP socket: Resource temporarily unavailable root@frituur:~# dhcpclient 193.191.177.231:6700 -f dhcp-packet.txt -x auto DHCP-Client-Identifier := 0x616263313233 ---------------------------------------------------------------------- DHCP-Opcode = 0x01 DHCP-Hardware-Type = 0x01 DHCP-Hardware-Address-Length = 0x06 DHCP-Hop-Count = 0x00 DHCP-Transaction-Id = 0xdc1551df DHCP-Number-of-Seconds = 0x0000 DHCP-Flags = 0x0000 DHCP-Client-IP-Address = 0x00000000 DHCP-Your-IP-Address = 0x00000000 DHCP-Server-IP-Address = 0x00000000 DHCP-Gateway-IP-Address = 0x00000000 DHCP-Client-Hardware-Address = 0x0201aabbccdd00000000000000000000 DHCP-Server-Host-Name = 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 DHCP-Boot-Filename = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 63 82 53 63 35 01 01 3d 06 61 62 63 31 32 33 ---------------------------------------------------------------------- dhcpclient: Error receiving reply: Failed reading DHCP socket: Resource temporarily unavailable The logs from using freeradius -X: FreeRADIUS Version 3.2.3 Copyright (C) 1999-2022 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file /usr/share/freeradius/dictionary including dictionary file /usr/share/freeradius/dictionary.dhcp including dictionary file /usr/share/freeradius/dictionary.vqp including dictionary file /etc/freeradius/dictionary including configuration file /etc/freeradius/radiusd.conf including configuration file /etc/freeradius/proxy.conf including configuration file /etc/freeradius/clients.conf including files in directory /etc/freeradius/mods-enabled/ including configuration file /etc/freeradius/mods-enabled/unpack including configuration file /etc/freeradius/mods-enabled/radutmp including configuration file /etc/freeradius/mods-enabled/always including configuration file /etc/freeradius/mods-enabled/eap including configuration file /etc/freeradius/mods-enabled/sradutmp including configuration file /etc/freeradius/mods-enabled/exec including configuration file /etc/freeradius/mods-enabled/date including configuration file /etc/freeradius/mods-enabled/unix including configuration file /etc/freeradius/mods-enabled/detail including configuration file /etc/freeradius/mods-enabled/digest including configuration file /etc/freeradius/mods-enabled/ntlm_auth including configuration file /etc/freeradius/mods-enabled/replicate including configuration file /etc/freeradius/mods-enabled/files including configuration file /etc/freeradius/mods-enabled/echo including configuration file /etc/freeradius/mods-enabled/dhcp_sqlippool including configuration file /etc/freeradius/mods-config/sql/ippool-dhcp/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/expr including configuration file /etc/freeradius/mods-enabled/logintime including configuration file /etc/freeradius/mods-enabled/linelog including configuration file /etc/freeradius/mods-enabled/attr_filter including configuration file /etc/freeradius/mods-enabled/soh including configuration file /etc/freeradius/mods-enabled/chap including configuration file /etc/freeradius/mods-enabled/expiration including configuration file /etc/freeradius/mods-enabled/dhcp_sql including configuration file /etc/freeradius/mods-config/sql/dhcp/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/dynamic_clients including configuration file /etc/freeradius/mods-enabled/preprocess including configuration file /etc/freeradius/mods-enabled/passwd including configuration file /etc/freeradius/mods-enabled/detail.log including configuration file /etc/freeradius/mods-enabled/mschap including configuration file /etc/freeradius/mods-enabled/pap including configuration file /etc/freeradius/mods-enabled/totp including configuration file /etc/freeradius/mods-enabled/realm including configuration file /etc/freeradius/mods-enabled/utf8 including files in directory /etc/freeradius/policy.d/ including configuration file /etc/freeradius/policy.d/cui including configuration file /etc/freeradius/policy.d/eap including configuration file /etc/freeradius/policy.d/control including configuration file /etc/freeradius/policy.d/operator-name including configuration file /etc/freeradius/policy.d/canonicalization including configuration file /etc/freeradius/policy.d/moonshot-targeted-ids including configuration file /etc/freeradius/policy.d/debug including configuration file /etc/freeradius/policy.d/abfab-tr including configuration file /etc/freeradius/policy.d/dhcp including configuration file /etc/freeradius/policy.d/rfc7542 including configuration file /etc/freeradius/policy.d/accounting including configuration file /etc/freeradius/policy.d/filter 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/sites-enabled/dhcp main { security { user = "freerad" group = "freerad" allow_core_dumps = no } name = "freeradius" prefix = "/usr" localstatedir = "/var" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" } main { name = "freeradius" prefix = "/usr" localstatedir = "/var" sbindir = "/usr/sbin" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/freeradius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 16384 postauth_client_lost = no pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = 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 { nonblock = no ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = <<< secret >>> response_window = 20.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 check_timeout = 4 num_answers_to_alive = 3 revive_interval = 120 limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } recv_coa { } } 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 # Creating Auth-Type = digest # Creating Autz-Type = New-TLS-Connection radiusd: #### Instantiating modules #### modules { # Loaded module rlm_unpack # Loading module "unpack" from file /etc/freeradius/mods-enabled/unpack # 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_always # Loading module "reject" from file /etc/freeradius/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/freeradius/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/freeradius/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/freeradius/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/freeradius/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/freeradius/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/freeradius/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/freeradius/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/freeradius/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Loaded module rlm_eap # Loading module "eap" from file /etc/freeradius/mods-enabled/eap eap { default_eap_type = "md5" timer_expire = 60 max_eap_type = 52 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loading module "sradutmp" from file /etc/freeradius/mods-enabled/sradutmp radutmp sradutmp { filename = "/var/log/freeradius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loaded module rlm_exec # Loading module "exec" from file /etc/freeradius/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_date # Loading module "date" from file /etc/freeradius/mods-enabled/date date { format = "%b %e %Y %H:%M:%S %Z" utc = no } # Loading module "wispr2date" from file /etc/freeradius/mods-enabled/date date wispr2date { format = "%Y-%m-%dT%H:%M:%S" utc = no } # Loaded module rlm_unix # Loading module "unix" from file /etc/freeradius/mods-enabled/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Creating attribute Unix-Group # Loaded module rlm_detail # Loading module "detail" from file /etc/freeradius/mods-enabled/detail detail { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_digest # Loading module "digest" from file /etc/freeradius/mods-enabled/digest # 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_replicate # Loading module "replicate" from file /etc/freeradius/mods-enabled/replicate # 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" } # 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_sqlippool # Loading module "dhcp_sqlippool" from file /etc/freeradius/mods-enabled/dhcp_sqlippool sqlippool dhcp_sqlippool { sql_module_instance = "dhcp_sql" lease_duration = 7200 pool_name = "Pool-Name" default_pool = "main_pool" attribute_name = "DHCP-Your-IP-Address" req_attribute_name = "DHCP-Requested-IP-Address" allocate_begin = "START TRANSACTION" allocate_clear = "" allocate_clear_timeout = 1 allocate_existing = "SELECT framedipaddress FROM dhcpippool WHERE pool_name = '%{control:Pool-Name}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND `status` IN ('dynamic', 'static') ORDER BY expiry_time DESC LIMIT 1 FOR UPDATE SKIP LOCKED" allocate_requested = "SELECT framedipaddress FROM dhcpippool WHERE pool_name = '%{control:Pool-Name}' AND framedipaddress = '%{%{DHCP-Requested-IP-Address}:-0.0.0.0}' AND `status` = 'dynamic' AND expiry_time < NOW() FOR UPDATE SKIP LOCKED" allocate_find = "SELECT framedipaddress FROM dhcpippool WHERE pool_name = '%{control:Pool-Name}' AND expiry_time < NOW() AND `status` = 'dynamic' ORDER BY expiry_time LIMIT 1 FOR UPDATE SKIP LOCKED" allocate_update = "UPDATE dhcpippool SET gateway = '%{DHCP-Gateway-IP-Address}', pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}', expiry_time = NOW() + INTERVAL 10 SECOND WHERE framedipaddress = '%I'" allocate_commit = "COMMIT" pool_check = "SELECT id FROM dhcpippool WHERE pool_name='%{control:Pool-Name}' LIMIT 1" start_begin = "" start_update = "UPDATE dhcpippool SET gateway = '', pool_key = '', expiry_time = NOW() WHERE pool_name = '%{control:Pool-Name}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress <> '%{DHCP-Requested-IP-Address}' AND expiry_time > NOW() AND `status` = 'dynamic'" start_commit = "" alive_begin = "" alive_update = "UPDATE dhcpippool SET expiry_time = NOW() + INTERVAL 7200 SECOND, counter = counter + 1 WHERE pool_name = '%{control:Pool-Name}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress = '%{%{DHCP-Requested-IP-Address}:-%{DHCP-Client-IP-Address}}'" alive_commit = "" stop_begin = "" stop_clear = "UPDATE dhcpippool SET gateway = '', pool_key = '', expiry_time = NOW() WHERE pool_name = '%{control:Pool-Name}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress = '%{DHCP-Client-IP-Address}' AND `status` = 'dynamic'" stop_commit = "" on_begin = "" on_clear = "" on_commit = "" off_begin = "" off_clear = "UPDATE dhcpippool SET status = 'declined' WHERE pool_name = '%{control:Pool-Name}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress = '%{DHCP-Requested-IP-Address}'" off_commit = "" messages { exists = "DHCP: Existing IP: %{reply:DHCP-Your-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" success = "DHCP: Allocated IP: %{reply:DHCP-Your-IP-Address} from %{control:Pool-Name} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" clear = "DHCP: Released IP %{DHCP-Client-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" failed = "DHCP: IP Allocation FAILED from %{control:Pool-Name} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" nopool = "DHCP: No Pool-Name defined (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" } } # Loaded module rlm_expr # Loading module "expr" from file /etc/freeradius/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_logintime # Loading module "logintime" from file /etc/freeradius/mods-enabled/logintime logintime { minimum_timeout = 60 } # 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_attr_filter # Loading module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/freeradius/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.pre-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/freeradius/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.access_reject" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/freeradius/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.access_challenge" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/freeradius/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.accounting_response" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/freeradius/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.coa" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.coa { filename = "/etc/freeradius/mods-config/attr_filter/coa" key = "%{User-Name}" relaxed = no } # Loaded module rlm_soh # Loading module "soh" from file /etc/freeradius/mods-enabled/soh soh { dhcp = yes } # Loaded module rlm_chap # Loading module "chap" from file /etc/freeradius/mods-enabled/chap # Loaded module rlm_expiration # Loading module "expiration" from file /etc/freeradius/mods-enabled/expiration # Loaded module rlm_sql # Loading module "dhcp_sql" from file /etc/freeradius/mods-enabled/dhcp_sql sql dhcp_sql { driver = "rlm_sql_mysql" server = "localhost" port = 3306 login = "radius" password = <<< secret >>> radius_db = "radius" read_groups = no read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "%{control:DHCP-SQL-Option-Identifier}" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" authorize_reply_query = "SELECT id, identifier, attribute, value, Op FROM dhcpreply WHERE identifier = '%{SQL-User-Name}' AND context = '%{control:DHCP-SQL-Option-Context}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM dhcpgroupreply WHERE groupname = '%{dhcp_sql-SQL-Group}' AND context = '%{control:DHCP-SQL-Option-Context}' ORDER BY id" group_membership_query = "SELECT groupnme FROM dhcpgroup WHERE identifier='%{SQL-User-Name}' AND context = '%{control:DHCP-SQL-Option-Context}' ORDER BY priority" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = ".query" type { accounting-on { } accounting-off { } start { } interim-update { } stop { } } } post-auth { reference = ".query" } } rlm_sql (dhcp_sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Creating attribute dhcp_sql-SQL-Group # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/freeradius/mods-enabled/dynamic_clients # 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_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 "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_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_pap # Loading module "pap" from file /etc/freeradius/mods-enabled/pap pap { normalise = yes } # Loaded module rlm_totp # Loading module "totp" from file /etc/freeradius/mods-enabled/totp # Loaded module rlm_realm # Loading module "IPASS" from file /etc/freeradius/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/freeradius/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "bangpath" from file /etc/freeradius/mods-enabled/realm realm bangpath { format = "prefix" delimiter = "!" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/freeradius/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/freeradius/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/freeradius/mods-enabled/utf8 instantiate { } # 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 "eap" from file /etc/freeradius/mods-enabled/eap # Linked to sub-module rlm_eap_md5 # Linked to sub-module rlm_eap_gtc gtc { challenge = "Password: " auth_type = "PAP" } # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" } tls-config tls-common { verify_depth = 0 ca_path = "/etc/freeradius/certs" pem_file_type = yes private_key_file = "/etc/freeradius/certs/server.pem" certificate_file = "/etc/freeradius/certs/server.pem" ca_file = "/etc/freeradius/certs/ca.pem" private_key_password = <<< secret >>> fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no ca_path_reload_interval = 0 cipher_list = "DEFAULT" cipher_server_preference = no reject_unknown_intermediate_ca = no ecdh_curve = "" tls_max_version = "1.2" tls_min_version = "1.2" cache { enable = no lifetime = 24 max_entries = 255 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "detail" from file /etc/freeradius/mods-enabled/detail # 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 "dhcp_sqlippool" from file /etc/freeradius/mods-enabled/dhcp_sqlippool # Instantiating module "dhcp_sql" from file /etc/freeradius/mods-enabled/dhcp_sql rlm_sql_mysql: libmysql version: 8.0.36 mysql { tls { ca_file = "/etc/ssl/certs/ca-cert.pem" ca_path = "/etc/ssl/certs/" certificate_file = "/etc/ssl/certs/private/client-cert.pem" private_key_file = "/etc/ssl/certs/private/client-key.pem" cipher = "DHE-RSA-AES256-SHA:AES128-SHA" tls_required = no check_cert = no check_cert_cn = no } warnings = "auto" } rlm_sql (dhcp_sql): Attempting to connect to database "radius" rlm_sql (dhcp_sql): Initialising connection pool pool { start = 5 min = 3 max = 32 spare = 10 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 30 max_retries = 5 spread = no } rlm_sql (dhcp_sql): Opening additional connection (0), 1 of 32 pending slots used rlm_sql_mysql: Starting connect to MySQL server WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX socket, server version 5.5.5-10.11.7-MariaDB-2ubuntu2, protocol version 10 rlm_sql (dhcp_sql): Opening additional connection (1), 1 of 31 pending slots used rlm_sql_mysql: Starting connect to MySQL server WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX socket, server version 5.5.5-10.11.7-MariaDB-2ubuntu2, protocol version 10 rlm_sql (dhcp_sql): Opening additional connection (2), 1 of 30 pending slots used rlm_sql_mysql: Starting connect to MySQL server WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX socket, server version 5.5.5-10.11.7-MariaDB-2ubuntu2, protocol version 10 rlm_sql (dhcp_sql): Opening additional connection (3), 1 of 29 pending slots used rlm_sql_mysql: Starting connect to MySQL server WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX socket, server version 5.5.5-10.11.7-MariaDB-2ubuntu2, protocol version 10 rlm_sql (dhcp_sql): Opening additional connection (4), 1 of 28 pending slots used rlm_sql_mysql: Starting connect to MySQL server WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX socket, server version 5.5.5-10.11.7-MariaDB-2ubuntu2, protocol version 10 # Instantiating module "logintime" from file /etc/freeradius/mods-enabled/logintime # Instantiating module "linelog" from file /etc/freeradius/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/freeradius/mods-enabled/linelog # Instantiating module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/post-proxy # Instantiating module "attr_filter.pre-proxy" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/pre-proxy # Instantiating module "attr_filter.access_reject" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/access_reject # Instantiating module "attr_filter.access_challenge" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/access_challenge # Instantiating module "attr_filter.accounting_response" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/accounting_response # Instantiating module "attr_filter.coa" from file /etc/freeradius/mods-enabled/attr_filter reading pairlist file /etc/freeradius/mods-config/attr_filter/coa # Instantiating module "expiration" from file /etc/freeradius/mods-enabled/expiration # 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 "etc_passwd" from file /etc/freeradius/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # 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 "mschap" from file /etc/freeradius/mods-enabled/mschap rlm_mschap (mschap): using internal authentication # Instantiating module "pap" from file /etc/freeradius/mods-enabled/pap # Instantiating module "IPASS" from file /etc/freeradius/mods-enabled/realm # Instantiating module "suffix" from file /etc/freeradius/mods-enabled/realm # Instantiating module "bangpath" from file /etc/freeradius/mods-enabled/realm # Instantiating module "realmpercent" from file /etc/freeradius/mods-enabled/realm # Instantiating module "ntdomain" from file /etc/freeradius/mods-enabled/realm } # 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 "sql" (see raddb/mods-available/README.rst) Ignoring "ldap" (see raddb/mods-available/README.rst) # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} # Skipping contents of 'if' as it is always 'false' -- /etc/freeradius/sites-enabled/inner-tunnel:366 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 {...} Compiling Autz-Type New-TLS-Connection for attr Autz-Type # Loading preacct {...} # Loading accounting {...} # Loading post-proxy {...} # Loading post-auth {...} Compiling Post-Auth-Type REJECT for attr Post-Auth-Type Compiling Post-Auth-Type Challenge for attr Post-Auth-Type Compiling Post-Auth-Type Client-Lost for attr Post-Auth-Type } # server default server dhcp { # from file /etc/freeradius/sites-enabled/dhcp # Loading dhcp DHCP-Discover {...} Compiling dhcp DHCP-Discover for attr DHCP-Message-Type # Loading dhcp DHCP-Request {...} Compiling dhcp DHCP-Request for attr DHCP-Message-Type # Loading dhcp DHCP-Decline {...} Compiling dhcp DHCP-Decline for attr DHCP-Message-Type # Loading dhcp DHCP-Inform {...} Compiling dhcp DHCP-Inform for attr DHCP-Message-Type # Loading dhcp DHCP-Release {...} Compiling dhcp DHCP-Release for attr DHCP-Message-Type # Loading dhcp DHCP-Lease-Query {...} Compiling dhcp DHCP-Lease-Query for attr DHCP-Message-Type } # server dhcp 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 } } listen { type = "dhcp" ipaddr = 193.191.177.231 port = 6700 performance { skip_duplicate_checks = no } src_ipaddr = 193.191.177.231 } 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 dhcp interface ens18 address 193.191.177.231 port 6700 bound to server dhcp Listening on proxy address * port 48665 Listening on proxy address :: port 53697 Ready to process requests Received DHCP-Discover of Id e0807a36 from 193.191.177.230:6701 to 193.191.177.231:6700 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 3766516278 DHCP-Number-of-Seconds = 0 DHCP-Flags = 0 DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 02:01:aa:bb:cc:dd DHCP-Message-Type = DHCP-Discover DHCP-Client-Identifier = 0x616263313233 DHCP-Network-Subnet = 0.0.0.0/32 (0) Received code 1025 Id 3766516278 from 193.191.177.230:6701 to 193.191.177.231:6700 length 300 (0) DHCP-Opcode = Client-Message (0) DHCP-Hardware-Type = Ethernet (0) DHCP-Hardware-Address-Length = 6 (0) DHCP-Hop-Count = 0 (0) DHCP-Transaction-Id = 3766516278 (0) DHCP-Number-of-Seconds = 0 (0) DHCP-Flags = 0 (0) DHCP-Client-IP-Address = 0.0.0.0 (0) DHCP-Your-IP-Address = 0.0.0.0 (0) DHCP-Server-IP-Address = 0.0.0.0 (0) DHCP-Gateway-IP-Address = 0.0.0.0 (0) DHCP-Client-Hardware-Address = 02:01:aa:bb:cc:dd (0) DHCP-Message-Type = DHCP-Discover (0) DHCP-Client-Identifier = 0x616263313233 (0) DHCP-Network-Subnet = 0.0.0.0/32 Trying sub-section dhcp DHCP-Discover {...} (0) dhcp DHCP-Discover { (0) update control { (0) &DHCP-DHCP-Server-Identifier = 193.191.177.231 (0) } # update control = noop (0) policy dhcp_common { (0) update reply { (0) &DHCP-Domain-Name-Server = 127.0.0.1 (0) &DHCP-Domain-Name-Server += 127.0.0.2 (0) &DHCP-Subnet-Mask = 255.255.255.0 (0) &DHCP-Router-Address = 192.0.2.1 (0) &DHCP-Broadcast-Address = 192.0.2.255 (0) &DHCP-IP-Address-Lease-Time = 7200 (0) &DHCP-DHCP-Server-Identifier = &control:DHCP-DHCP-Server-Identifier -> 193.191.177.231 (0) } # update reply = noop (0) } # policy dhcp_common = noop (0) update reply { (0) &DHCP-Your-IP-Address := 1.2.3.4 (0) } # update reply = noop (0) } # dhcp DHCP-Discover = noop (0) Not sending reply to client. (0) Finished request (0) Cleaning up request packet ID 3766516278 with timestamp +66 due to done Ready to process requests Received DHCP-Discover of Id 3603f3f3 from 193.191.177.230:6701 to 193.191.177.231:6700 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 906228723 DHCP-Number-of-Seconds = 0 DHCP-Flags = 0 DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 02:01:aa:bb:cc:dd DHCP-Message-Type = DHCP-Discover DHCP-Client-Identifier = 0x616263313233 DHCP-Network-Subnet = 0.0.0.0/32 (1) Received code 1025 Id 906228723 from 193.191.177.230:6701 to 193.191.177.231:6700 length 300 (1) DHCP-Opcode = Client-Message (1) DHCP-Hardware-Type = Ethernet (1) DHCP-Hardware-Address-Length = 6 (1) DHCP-Hop-Count = 0 (1) DHCP-Transaction-Id = 906228723 (1) DHCP-Number-of-Seconds = 0 (1) DHCP-Flags = 0 (1) DHCP-Client-IP-Address = 0.0.0.0 (1) DHCP-Your-IP-Address = 0.0.0.0 (1) DHCP-Server-IP-Address = 0.0.0.0 (1) DHCP-Gateway-IP-Address = 0.0.0.0 (1) DHCP-Client-Hardware-Address = 02:01:aa:bb:cc:dd (1) DHCP-Message-Type = DHCP-Discover (1) DHCP-Client-Identifier = 0x616263313233 (1) DHCP-Network-Subnet = 0.0.0.0/32 Trying sub-section dhcp DHCP-Discover {...} (1) dhcp DHCP-Discover { (1) update control { (1) &DHCP-DHCP-Server-Identifier = 193.191.177.231 (1) } # update control = noop (1) policy dhcp_common { (1) update reply { (1) &DHCP-Domain-Name-Server = 127.0.0.1 (1) &DHCP-Domain-Name-Server += 127.0.0.2 (1) &DHCP-Subnet-Mask = 255.255.255.0 (1) &DHCP-Router-Address = 192.0.2.1 (1) &DHCP-Broadcast-Address = 192.0.2.255 (1) &DHCP-IP-Address-Lease-Time = 7200 (1) &DHCP-DHCP-Server-Identifier = &control:DHCP-DHCP-Server-Identifier -> 193.191.177.231 (1) } # update reply = noop (1) } # policy dhcp_common = noop (1) update reply { (1) &DHCP-Your-IP-Address := 1.2.3.4 (1) } # update reply = noop (1) } # dhcp DHCP-Discover = noop (1) Not sending reply to client. (1) Finished request (1) Cleaning up request packet ID 906228723 with timestamp +90 due to done Ready to process requests Received DHCP-Discover of Id dc1551df from 193.191.177.230:6701 to 193.191.177.231:6700 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 3692384735 DHCP-Number-of-Seconds = 0 DHCP-Flags = 0 DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 02:01:aa:bb:cc:dd DHCP-Message-Type = DHCP-Discover DHCP-Client-Identifier = 0x616263313233 DHCP-Network-Subnet = 0.0.0.0/32 (2) Received code 1025 Id 3692384735 from 193.191.177.230:6701 to 193.191.177.231:6700 length 300 (2) DHCP-Opcode = Client-Message (2) DHCP-Hardware-Type = Ethernet (2) DHCP-Hardware-Address-Length = 6 (2) DHCP-Hop-Count = 0 (2) DHCP-Transaction-Id = 3692384735 (2) DHCP-Number-of-Seconds = 0 (2) DHCP-Flags = 0 (2) DHCP-Client-IP-Address = 0.0.0.0 (2) DHCP-Your-IP-Address = 0.0.0.0 (2) DHCP-Server-IP-Address = 0.0.0.0 (2) DHCP-Gateway-IP-Address = 0.0.0.0 (2) DHCP-Client-Hardware-Address = 02:01:aa:bb:cc:dd (2) DHCP-Message-Type = DHCP-Discover (2) DHCP-Client-Identifier = 0x616263313233 (2) DHCP-Network-Subnet = 0.0.0.0/32 Trying sub-section dhcp DHCP-Discover {...} (2) dhcp DHCP-Discover { (2) update control { (2) &DHCP-DHCP-Server-Identifier = 193.191.177.231 (2) } # update control = noop (2) policy dhcp_common { (2) update reply { (2) &DHCP-Domain-Name-Server = 127.0.0.1 (2) &DHCP-Domain-Name-Server += 127.0.0.2 (2) &DHCP-Subnet-Mask = 255.255.255.0 (2) &DHCP-Router-Address = 192.0.2.1 (2) &DHCP-Broadcast-Address = 192.0.2.255 (2) &DHCP-IP-Address-Lease-Time = 7200 (2) &DHCP-DHCP-Server-Identifier = &control:DHCP-DHCP-Server-Identifier -> 193.191.177.231 (2) } # update reply = noop (2) } # policy dhcp_common = noop (2) update reply { (2) &DHCP-Your-IP-Address := 1.2.3.4 (2) } # update reply = noop (2) } # dhcp DHCP-Discover = noop (2) Not sending reply to client. (2) Finished request (2) Cleaning up request packet ID 3692384735 with timestamp +502 due to done Ready to process requests

2 1

Issue with starting FreeRADIUS dhcp on Ubuntu 24.04
by Jan-Willem Curinckx 27 May '24

27 May '24

We're Trying to set up FreeRADIUS 3.2.2 as a DHCP server on Ubuntu 24.04, we've been having the same issue for a while now, where FreeRADIUS can't start the service because of an error. Kind regards, In the logs upon executing 'freeradius -X': FreeRADIUS Version 3.2.3 Copyright (C) 1999-2022 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file /usr/share/freeradius/dictionary including dictionary file /usr/share/freeradius/dictionary.dhcp including dictionary file /usr/share/freeradius/dictionary.vqp including dictionary file /etc/freeradius/dictionary including configuration file /etc/freeradius/radiusd.conf including configuration file /etc/freeradius/proxy.conf including configuration file /etc/freeradius/clients.conf including files in directory /etc/freeradius/mods-enabled/ including configuration file /etc/freeradius/mods-enabled/unpack including configuration file /etc/freeradius/mods-enabled/radutmp including configuration file /etc/freeradius/mods-enabled/always including configuration file /etc/freeradius/mods-enabled/eap including configuration file /etc/freeradius/mods-enabled/sradutmp including configuration file /etc/freeradius/mods-enabled/exec including configuration file /etc/freeradius/mods-enabled/date including configuration file /etc/freeradius/mods-enabled/unix including configuration file /etc/freeradius/mods-enabled/detail including configuration file /etc/freeradius/mods-enabled/digest including configuration file /etc/freeradius/mods-enabled/ntlm_auth including configuration file /etc/freeradius/mods-enabled/replicate including configuration file /etc/freeradius/mods-enabled/files including configuration file /etc/freeradius/mods-enabled/echo including configuration file /etc/freeradius/mods-enabled/dhcp_sqlippool including configuration file /etc/freeradius/mods-config/sql/ippool-dhcp/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/expr including configuration file /etc/freeradius/mods-enabled/logintime including configuration file /etc/freeradius/mods-enabled/linelog including configuration file /etc/freeradius/mods-enabled/attr_filter including configuration file /etc/freeradius/mods-enabled/soh including configuration file /etc/freeradius/mods-enabled/chap including configuration file /etc/freeradius/mods-enabled/expiration including configuration file /etc/freeradius/mods-enabled/dhcp_sql including configuration file /etc/freeradius/mods-config/sql/dhcp/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/dynamic_clients including configuration file /etc/freeradius/mods-enabled/preprocess including configuration file /etc/freeradius/mods-enabled/passwd including configuration file /etc/freeradius/mods-enabled/detail.log including configuration file /etc/freeradius/mods-enabled/mschap including configuration file /etc/freeradius/mods-enabled/pap including configuration file /etc/freeradius/mods-enabled/totp including configuration file /etc/freeradius/mods-enabled/realm including configuration file /etc/freeradius/mods-enabled/utf8 including files in directory /etc/freeradius/policy.d/ including configuration file /etc/freeradius/policy.d/cui including configuration file /etc/freeradius/policy.d/eap including configuration file /etc/freeradius/policy.d/control including configuration file /etc/freeradius/policy.d/operator-name including configuration file /etc/freeradius/policy.d/canonicalization including configuration file /etc/freeradius/policy.d/moonshot-targeted-ids including configuration file /etc/freeradius/policy.d/debug including configuration file /etc/freeradius/policy.d/abfab-tr including configuration file /etc/freeradius/policy.d/dhcp including configuration file /etc/freeradius/policy.d/rfc7542 including configuration file /etc/freeradius/policy.d/accounting including configuration file /etc/freeradius/policy.d/filter 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/sites-enabled/dhcp main { security { user = "freerad" group = "freerad" allow_core_dumps = no } name = "freeradius" prefix = "/usr" localstatedir = "/var" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" } main { name = "freeradius" prefix = "/usr" localstatedir = "/var" sbindir = "/usr/sbin" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/freeradius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 16384 postauth_client_lost = no pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = 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 { nonblock = no ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = <<< secret >>> response_window = 20.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 check_timeout = 4 num_answers_to_alive = 3 revive_interval = 120 limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } recv_coa { } } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = <<< secret >>> nas_type = "other" proto = "*" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client localhost_ipv6 { ipv6addr = ::1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Debugger not attached # Creating Auth-Type = mschap # Creating Auth-Type = eap # Creating Auth-Type = PAP # Creating Auth-Type = CHAP # Creating Auth-Type = MS-CHAP # Creating Auth-Type = digest # Creating Autz-Type = New-TLS-Connection radiusd: #### Instantiating modules #### modules { # Loaded module rlm_unpack # Loading module "unpack" from file /etc/freeradius/mods-enabled/unpack # 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_always # Loading module "reject" from file /etc/freeradius/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/freeradius/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/freeradius/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/freeradius/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/freeradius/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/freeradius/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/freeradius/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/freeradius/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/freeradius/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Loaded module rlm_eap # Loading module "eap" from file /etc/freeradius/mods-enabled/eap eap { default_eap_type = "md5" timer_expire = 60 max_eap_type = 52 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loading module "sradutmp" from file /etc/freeradius/mods-enabled/sradutmp radutmp sradutmp { filename = "/var/log/freeradius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loaded module rlm_exec # Loading module "exec" from file /etc/freeradius/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_date # Loading module "date" from file /etc/freeradius/mods-enabled/date date { format = "%b %e %Y %H:%M:%S %Z" utc = no } # Loading module "wispr2date" from file /etc/freeradius/mods-enabled/date date wispr2date { format = "%Y-%m-%dT%H:%M:%S" utc = no } # Loaded module rlm_unix # Loading module "unix" from file /etc/freeradius/mods-enabled/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Creating attribute Unix-Group # Loaded module rlm_detail # Loading module "detail" from file /etc/freeradius/mods-enabled/detail detail { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_digest # Loading module "digest" from file /etc/freeradius/mods-enabled/digest # 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_replicate # Loading module "replicate" from file /etc/freeradius/mods-enabled/replicate # 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" } # 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_sqlippool # Loading module "dhcp_sqlippool" from file /etc/freeradius/mods-enabled/dhcp_sqlippool sqlippool dhcp_sqlippool { sql_module_instance = "dhcp_sql" lease_duration = 7200 pool_name = "IP-Pool" default_pool = "main_pool" attribute_name = "DHCP-Your-IP-Address" req_attribute_name = "DHCP-Requested-IP-Address" allocate_begin = "START TRANSACTION" allocate_clear = "" allocate_clear_timeout = 1 allocate_existing = "SELECT framedipaddress FROM dhcpippool WHERE pool_name = '%{control:IP-Pool}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND `status` IN ('dynamic', 'static') ORDER BY expiry_time DESC LIMIT 1 FOR UPDATE SKIP LOCKED" allocate_requested = "SELECT framedipaddress FROM dhcpippool WHERE pool_name = '%{control:IP-Pool}' AND framedipaddress = '%{%{DHCP-Requested-IP-Address}:-0.0.0.0}' AND `status` = 'dynamic' AND expiry_time < NOW() FOR UPDATE SKIP LOCKED" allocate_find = "SELECT framedipaddress FROM dhcpippool WHERE pool_name = '%{control:IP-Pool}' AND expiry_time < NOW() AND `status` = 'dynamic' ORDER BY expiry_time LIMIT 1 FOR UPDATE SKIP LOCKED" allocate_update = "UPDATE dhcpippool SET gateway = '%{DHCP-Gateway-IP-Address}', pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}', expiry_time = NOW() + INTERVAL 10 SECOND WHERE framedipaddress = '%I'" allocate_commit = "COMMIT" pool_check = "SELECT id FROM dhcpippool WHERE pool_name='%{control:IP-Pool}' LIMIT 1" start_begin = "" start_update = "UPDATE dhcpippool SET gateway = '', pool_key = '', expiry_time = NOW() WHERE pool_name = '%{control:IP-Pool}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress <> '%{DHCP-Requested-IP-Address}' AND expiry_time > NOW() AND `status` = 'dynamic'" start_commit = "" alive_begin = "" alive_update = "UPDATE dhcpippool SET expiry_time = NOW() + INTERVAL 7200 SECOND, counter = counter + 1 WHERE pool_name = '%{control:IP-Pool}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress = '%{%{DHCP-Requested-IP-Address}:-%{DHCP-Client-IP-Address}}'" alive_commit = "" stop_begin = "" stop_clear = "UPDATE dhcpippool SET gateway = '', pool_key = '', expiry_time = NOW() WHERE pool_name = '%{control:IP-Pool}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress = '%{DHCP-Client-IP-Address}' AND `status` = 'dynamic'" stop_commit = "" on_begin = "" on_clear = "" on_commit = "" off_begin = "" off_clear = "UPDATE dhcpippool SET status = 'declined' WHERE pool_name = '%{control:IP-Pool}' AND pool_key = '%{%{DHCP-Client-Identifier}:-%{DHCP-Client-Hardware-Address}}' AND framedipaddress = '%{DHCP-Requested-IP-Address}'" off_commit = "" messages { exists = "DHCP: Existing IP: %{reply:DHCP-Your-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" success = "DHCP: Allocated IP: %{reply:DHCP-Your-IP-Address} from %{control:IP-Pool} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" clear = "DHCP: Released IP %{DHCP-Client-IP-Address} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" failed = "DHCP: IP Allocation FAILED from %{control:IP-Pool} (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" nopool = "DHCP: No IP-Pool defined (cid %{DHCP-Client-Identifier} chaddr %{DHCP-Client-Hardware-Address} giaddr %{DHCP-Gateway-IP-Address})" } } # Loaded module rlm_expr # Loading module "expr" from file /etc/freeradius/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_logintime # Loading module "logintime" from file /etc/freeradius/mods-enabled/logintime logintime { minimum_timeout = 60 } # 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_attr_filter # Loading module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/freeradius/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.pre-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/freeradius/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.access_reject" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/freeradius/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.access_challenge" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/freeradius/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.accounting_response" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/freeradius/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.coa" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.coa { filename = "/etc/freeradius/mods-config/attr_filter/coa" key = "%{User-Name}" relaxed = no } # Loaded module rlm_soh # Loading module "soh" from file /etc/freeradius/mods-enabled/soh soh { dhcp = yes } # Loaded module rlm_chap # Loading module "chap" from file /etc/freeradius/mods-enabled/chap # Loaded module rlm_expiration # Loading module "expiration" from file /etc/freeradius/mods-enabled/expiration # Loaded module rlm_sql # Loading module "dhcp_sql" from file /etc/freeradius/mods-enabled/dhcp_sql sql dhcp_sql { driver = "rlm_sql_mysql" server = "localhost" port = 3306 login = "radius" password = <<< secret >>> radius_db = "radius" read_groups = no read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "%{control:DHCP-SQL-Option-Identifier}" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" authorize_reply_query = "SELECT id, identifier, attribute, value, Op FROM dhcpreply WHERE identifier = '%{SQL-User-Name}' AND context = '%{control:DHCP-SQL-Option-Context}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM dhcpgroupreply WHERE groupname = '%{dhcp_sql-SQL-Group}' AND context = '%{control:DHCP-SQL-Option-Context}' ORDER BY id" group_membership_query = "SELECT groupnme FROM dhcpgroup WHERE identifier='%{SQL-User-Name}' AND context = '%{control:DHCP-SQL-Option-Context}' ORDER BY priority" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = ".query" type { accounting-on { } accounting-off { } start { } interim-update { } stop { } } } post-auth { reference = ".query" } } rlm_sql (dhcp_sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Creating attribute dhcp_sql-SQL-Group # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/freeradius/mods-enabled/dynamic_clients # 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_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 "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_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_pap # Loading module "pap" from file /etc/freeradius/mods-enabled/pap pap { normalise = yes } # Loaded module rlm_totp # Loading module "totp" from file /etc/freeradius/mods-enabled/totp # Loaded module rlm_realm # Loading module "IPASS" from file /etc/freeradius/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/freeradius/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "bangpath" from file /etc/freeradius/mods-enabled/realm realm bangpath { format = "prefix" delimiter = "!" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/freeradius/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/freeradius/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/freeradius/mods-enabled/utf8 instantiate { } # 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 "eap" from file /etc/freeradius/mods-enabled/eap # Linked to sub-module rlm_eap_md5 # Linked to sub-module rlm_eap_gtc gtc { challenge = "Password: " auth_type = "PAP" } # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" } tls-config tls-common { verify_depth = 0 ca_path = "/etc/freeradius/certs" pem_file_type = yes private_key_file = "/etc/freeradius/certs/server.pem" certificate_file = "/etc/freeradius/certs/server.pem" ca_file = "/etc/freeradius/certs/ca.pem" private_key_password = <<< secret >>> fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no ca_path_reload_interval = 0 cipher_list = "DEFAULT" cipher_server_preference = no reject_unknown_intermediate_ca = no ecdh_curve = "" tls_max_version = "1.2" tls_min_version = "1.2" cache { enable = no lifetime = 24 max_entries = 255 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "detail" from file /etc/freeradius/mods-enabled/detail # 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 /etc/freeradius/mods-config/sql/ippool-dhcp/mysql/queries.conf[23]: Failed parsing expanded string: /etc/freeradius/mods-config/sql/ippool-dhcp/mysql/queries.conf[23]: ...FROM dhcpippool WHERE pool_name = '%{control:IP-Pool}' AND pool_key = '%{%{DHCP-Client-Ident... /etc/freeradius/mods-config/sql/ippool-dhcp/mysql/queries.conf[23]: ^ Unknown attribute

2 1