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

Force ignore access request \ blacklist
by Bartek Chmielewski 20 May '21

20 May '21

Hi, I`m looking how to ignore\blacklist request based on certain condition, e.g. ip address, something like: if "%{request:Calling-Station-Id}" == <ip_address> { (ignore request) } or any module which would enable blacklisting? I would need to drop a packet rather than reject it. Appreciate this software and your help, thanks Bart

2 1

Version 3.0.22 has been released
by Matthew Newton 17 May '21

17 May '21

Version 3.0.22 has now been released. It's been rather a long delay due to a number of reasons, but hopefully worth the wait. There have been a lot of updates in this "TLS and DHCP" release, and a number of new features. Some highlights: - TLS1.3 support, thanks to Alexander Clouter - Major DHCP improvements from Terry Burton and Nick Porter - Significant improvements to readability of TLS debug messages - rlm_sql_map, to handle multiple columns in SQL queries - rlm_totp, for calculating Google Authenticator type OTP codes As well as many other improvements and bug fixes. Full release notes are available on the web site: https://freeradius.org/release_notes/?br=3.0.x&re=3.0.22 Download from the usual places: https://freeradius.org/releases/ ftp://ftp.freeradius.org/pub/freeradius/ https://github.com/FreeRADIUS/freeradius-server/releases/tag/release_3_0_22 Packages are available on the Network RADIUS web site: https://packages.networkradius.com/ Docker images will also be available on Dockerhub shortly: https://hub.docker.com/u/freeradius -- Matthew

2 1

How do I see if the user has disconnected?
by Mark Antony 15 May '21

15 May '21

I would like to run an sql update statement, every time the user disconnects a session. Correct me if I'm wrong, but I believe I should capture that inside accounting { ... } where the final acctstoptime etc get stored into radacct table. But I don't know how exactly to achieve this. I suppose something like this below, but how do I know if the user actually disconnected? accounting { update request { ... } } Thanks, Mark Sent with [ProtonMail](https://protonmail.com) Secure Email.

3 15

COA server times out
by Mark Antony 13 May '21

13 May '21

Hello, I have setup freeradius to disconnect the NAS when certain conditions are met. However the COA server can't be reached or doesn't react, so the requests get duplicated and sent over and over again, until it times out. (3) Received Accounting-Request Id 220 from 127.0.0.1:36559 to 127.0.0.1:1813 length 158 (3) User-Name = "mark" (3) NAS-IP-Address = 127.0.0.1 (3) NAS-Port = 1 (3) Service-Type = Outbound-User (3) Framed-Protocol = PPP (3) Framed-IP-Address = 10.8.0.2 (3) Calling-Station-Id = "89.32.xxx.xxx" (3) NAS-Identifier = "OpenVpn" (3) Acct-Status-Type = Interim-Update (3) Acct-Input-Octets = 103730 (3) Acct-Output-Octets = 356871 (3) Acct-Session-Id = "A7E4B3803D0E4A87C8CC76B5C0E1910B" (3) Acct-Session-Time = 20 (3) Acct-Input-Gigawords = 0 (3) Acct-Output-Gigawords = 0 (3) NAS-Port-Type = Virtual (3) # Executing section preacct from file /etc/freeradius/3.0/sites-enabled/default (3) preacct { (3) update control { (3) EXPAND %l (3)--> 1620718410 (3) &Current-Timestamp := 1620718410 (3) } # update control = noop (3) update request { rlm_sql (sql): Reserved connection (0) rlm_sql (sql): Released connection (0) Need 2 more connections to reach 10 spares rlm_sql (sql): Opening additional connection (8), 1 of 24 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius_db' on 3.64.143.170 via TCP/IP, server version 8.0.24, protocol version 10 (3) EXPAND %{User-Name} (3)--> mark (3) SQL-User-Name set to 'mark' rlm_sql (sql): Reserved connection (5) (3) Executing select query: SELECT COALESCE((SELECT UNIX_TIMESTAMP(expires_at) FROM master_db.device d WHERE d.id='mark'), 0) rlm_sql (sql): Released connection (5) (3) EXPAND %{sql:SELECT COALESCE((SELECT UNIX_TIMESTAMP(expires_at) FROM master_db.device d WHERE d.id='%{User-Name}'), 0)} (3)--> 1589143717 (3) &Expires-Timestamp := 1589143717 rlm_sql (sql): Reserved connection (1) rlm_sql (sql): Released connection (1) (3) EXPAND %{User-Name} (3)--> mark (3) SQL-User-Name set to 'mark' rlm_sql (sql): Reserved connection (7) (3) Executing select query: SELECT COALESCE(MAX(is_banned), 0) as banned FROM master_db.device d WHERE d.id = 'mark' rlm_sql (sql): Released connection (7) (3) EXPAND %{sql:SELECT COALESCE(MAX(is_banned), 0) as banned FROM master_db.device d WHERE d.id = '%{User-Name}'} (3)--> 0 (3) &Banned := 0 (3) } # update request = noop (3) if (&request:Banned == 1) { (3) if (&request:Banned == 1)-> FALSE (3) if (&control:Current-Timestamp > &request:Expires-Timestamp) { (3) if (&control:Current-Timestamp > &request:Expires-Timestamp)-> TRUE (3) if (&control:Current-Timestamp > &request:Expires-Timestamp){ (3) update disconnect { (3) EXPAND %{User-Name} (3)--> mark (3) &User-Name = mark (3) } # update disconnect = noop (3) } # if (&control:Current-Timestamp > &request:Expires-Timestamp)= noop (3) [preprocess] = ok (3) policy acct_unique { (3) update request { (3) &Tmp-String-9 := "ai:" (3) } # update request = noop (3) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (3) EXPAND %{hex:&Class} (3)--> (3) EXPAND ^%{hex:&Tmp-String-9} (3)--> ^61693a (3) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i))-> FALSE (3) else { (3) update request { (3) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}} (3)--> 47a7883f04b4faeba08349f153a68b6b (3) &Acct-Unique-Session-Id := 47a7883f04b4faeba08349f153a68b6b (3) } # update request = noop (3) } # else = noop (3) } # policy acct_unique = noop (3) suffix: Checking for suffix after "@" (3) suffix: No '@' in User-Name = "mark", looking up realm NULL (3) suffix: No such realm "NULL" (3) [suffix] = noop (3) } # preacct = ok (3) # Executing section accounting from file /etc/freeradius/3.0/sites-enabled/default (3) accounting { (3) detail: EXPAND /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d (3) detail:--> /var/log/freeradius/radacct/127.0.0.1/detail-20210511 (3) detail: /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/freeradius/radacct/127.0.0.1/detail-20210511 (3) detail: EXPAND %t (3) detail:--> Tue May 11 07:33:30 2021 (3) [detail] = ok (3) [unix] = noop (3) sql: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (3) sql:--> type.interim-update.query (3) sql: Using query template 'query' rlm_sql (sql): Reserved connection (6) (3) sql: EXPAND %{User-Name} (3) sql:--> mark (3) sql: SQL-User-Name set to 'mark' (3) sql: EXPAND UPDATE radacct SET acctupdatetime= (@acctupdatetime_old:=acctupdatetime), acctupdatetime= FROM_UNIXTIME(%{%{integer:Event-Timestamp}:-%l}), acctinterval= %{%{integer:Event-Timestamp}:-%l} - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '%{Framed-IP-Address}', framedipv6address = '%{Framed-IPv6-Address}', framedipv6prefix = '%{Framed-IPv6-Prefix}', framedinterfaceid = '%{Framed-Interface-Id}', delegatedipv6prefix = '%{Delegated-IPv6-Prefix}', acctsessiontime = %{%{Acct-Session-Time}:-NULL}, acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (3) sql:--> UPDATE radacct SET acctupdatetime= (@acctupdatetime_old:=acctupdatetime), acctupdatetime= FROM_UNIXTIME(1620718410), acctinterval= 1620718410 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '10.8.0.2', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 20, acctinputoctets = '0' << 32 | '103730', acctoutputoctets = '0' << 32 | '356871' WHERE AcctUniqueId = '47a7883f04b4faeba08349f153a68b6b' (3) sql: Executing query: UPDATE radacct SET acctupdatetime= (@acctupdatetime_old:=acctupdatetime), acctupdatetime= FROM_UNIXTIME(1620718410), acctinterval= 1620718410 - UNIX_TIMESTAMP(@acctupdatetime_old), framedipaddress = '10.8.0.2', framedipv6address = '', framedipv6prefix = '', framedinterfaceid = '', delegatedipv6prefix = '', acctsessiontime = 20, acctinputoctets = '0' << 32 | '103730', acctoutputoctets = '0' << 32 | '356871' WHERE AcctUniqueId = '47a7883f04b4faeba08349f153a68b6b' rlm_sql_mysql: Rows matched: 1Changed: 1Warnings: 1 (3) sql: SQL query returned: success (3) sql: 1 record(s) updated rlm_sql (sql): Released connection (6) (3) [sql] = ok (3) [exec] = noop (3) attr_filter.accounting_response: EXPAND %{User-Name} (3) attr_filter.accounting_response:--> mark (3) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (3) [attr_filter.accounting_response] = updated (3) } # accounting = updated (3) Sent Disconnect-Request Id 155 from 0.0.0.0:57659 to 127.0.0.1:3799 length 28 (3) User-Name = "mark" (3) Sent Accounting-Response Id 220 from 127.0.0.1:1813 to 127.0.0.1:36559 length 0 (3) Finished request (3) Cleaning up request packet ID 220 with timestamp +44 Waking up in 2.3 seconds. (3) Sending duplicate CoA request to home server 127.0.0.1 port 3799 - ID: 155 Waking up in 4.5 seconds. (5) Sending duplicate CoA request to home server 127.0.0.1 port 3799 - ID: 211 Waking up in 0.3 seconds. (6) Sending duplicate CoA request to home server 127.0.0.1 port 3799 - ID: 79 Waking up in 3.5 seconds. ... (4) ERROR: Failing request - originate-coa ID 83, due to lack of any response from coa server 127.0.0.1 port 3799 within 30 seconds This is the coa section defined in the /etc/freeradius/3.0/proxy.conf home_server my-coa { type = coa ipaddr = 127.0.0.1 port = 3799 secret = coa123 coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } Do I also have to set it in /etc/freeradius/3.0/clients.conf: client localhost { ... coa_server = my-coa } Is there anything else I need to do to setup the COA server? My NAS is OpenVPN and I'm using openvpn-auth-radius plugin from Debian: https://packages.debian.org/buster/openvpn-auth-radius /etc/openvpn/radiusplugin.cnf NAS-Identifier=OpenVpn Service-Type=5 Framed-Protocol=1 NAS-Port-Type=5 NAS-IP-Address=127.0.0.1 OpenVPNConfig=/etc/openvpn/server.conf subnet=255.255.255.0 overwriteccfiles=true server { authport=1812 name=127.0.0.1 retry=1 wait=1 sharedsecret=${CLIENT_SECRET} } Thanks

2 4

Acct-Interim-Interval
by Aurélio de Souza Ribeiro Neto 12 May '21

12 May '21

Hello List, Someone can explain how Acct-Interim-Interval works? This function checks if the IP on radippool is active in NAS? Many thanks Aurélio

2 1

Active Directory authenticated VPN
by Pisch Tamás 12 May '21

12 May '21

Hello, I would like to set up VPN on a Samba DC (Debian Bullseye). I could set it up with ntlm_auth, but I read that ntlm_auth may serve about 30 request per second maximum, and uses smbv1. I would like to filter users by group or msNPAllowDialin AD property. I can use: winbind_username = "%{mschap:User-Name}" winbind_domain = "%{mschap:NT-Domain}" in mschap, but how I can filter users? Regards, Tamas.

4 33

How to design RADIUS systems for ISPs
by marketing＠networkradius.com 11 May '21

11 May '21

** How to design RADIUS systems for ISPs --------------------------------------------- More than almost any other business, Internet Service Providers (ISPs) need to provide their customers with fast, reliable access to their network. Any downtime can be catastrophic to their business, and slow connection speeds will drive customers away to other providers. ISPs need to ensure that their network has several levels of redundancy in order to provide stable service at all times. This week’s article outlines our ISP RADIUS deployment design best practices. At Network RADIUS, we have been successfully using these principles for over ten years, with customers who are distributed across the world. These practices have been tested, and proven in production. These practices apply to all ISPs, from small to large, though the individual methods can vary depending on the ISPs size and needs. Read the full article… https://networkradius.com/articles/2021/02/10/ISP-RADIUS-design.html ** Sign up to get this content directly --------------------------------------------- Want to get these articles in all their HTML glory? Sign up here: http://eepurl.com/hwuWrn ** Need RADIUS help? --------------------------------------------- Get commercial support from the team behind FreeRADIUS. https://networkradius.com/contact/ ** What is the relationship between Network RADIUS and FreeRADIUS? ---------------------------------------------- FreeRADIUS is an open source implementation of the RADIUS protocol and was written by Alan DeKok in 1999. Network RADIUS is a private, for-profit company founded by Alan DeKok which provides commercial support for FreeRADIUS. The Network RADIUS team has been the primary contributor to FreeRADIUS for the last 20 years. The FreeRADIUS mailing list, wiki, and documentation are all moderated and maintained by the Network RADIUS team. FreeRADIUS has always been, and will always continue to be, open source. The Network RADIUS team provides commercial support to paying clients, and free product development for the FreeRADIUS community at large. All of our software development for FreeRADIUS is integrated into the Open Source platform, and will always continue to be.

1 0

Log entries when proxying
by Tony Skalski 11 May '21

11 May '21

I am proxying some clients (based on outer identity) to our old NPS servers. This is an eduroam wireless environment and many of the example configs I've found have linelog statements in the outer tunnel pre-proxy and post-proxy sections. This results in about 25-30 log messages for a single proxied authentication. This seemed like a lot of messages for a single authn, so I went looking for a state attribute that would allow me to identify the first proxy request and log that, as well as the final proxy accept, but not all of the intervening proxy requests and challenges. Is it commonplace to log a message for each proxy request and challenge like this? (and I should not worry about the number of log messages) Or, is there a way to identify the initial proxy request and not log the intervening requests and challenges? Thanks! ajs -- *Tony Skalski* System Administrator | IT *Office: *507-786-3227 <(507)786-3227> 1510 St. Olaf Avenue Northfield, MN 55057 stolaf.edu

2 2

Failed to start FreeRadius without Error Code
by SImon Dankau 11 May '21

11 May '21

Hello, i am trying to set up a FreeRADIUS-Server with more than one virtual servers. One virtual server is for the WLAN-Connection for different users and the other virtual servers should be for our VPN-connection. While restarting the freeradius.service i with two virtual servers i got the following message: root@bkr-idm1:/etc/freeradius/3.0/sites-available# systemctl restart freeradius.service Job for freeradius.service failed because the control process exited with error code. See "systemctl status freeradius.service" and "journalctl -xe" for details. The messages from journalctl -xe: root@bkr-idm1:/etc/freeradius/3.0/sites-available# journalctl -xe -- Unit freeradius.service has begun shutting down. Mai 11 09:30:36 bkr-idm1 systemd[1]: Stopped FreeRADIUS multi-protocol policy server. -- Subject: Unit freeradius.service has finished shutting down -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- Unit freeradius.service has finished shutting down. Mai 11 09:30:36 bkr-idm1 systemd[1]: Starting FreeRADIUS multi-protocol policy server... -- Subject: Unit freeradius.service has begun start-up -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- Unit freeradius.service has begun starting up. Mai 11 09:30:36 bkr-idm1 freeradius[2150]: FreeRADIUS Version 3.0.12 Mai 11 09:30:36 bkr-idm1 freeradius[2150]: Copyright (C) 1999-2016 The FreeRADIUS server project and contributors Mai 11 09:30:36 bkr-idm1 freeradius[2150]: There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A Mai 11 09:30:36 bkr-idm1 freeradius[2150]: PARTICULAR PURPOSE Mai 11 09:30:36 bkr-idm1 freeradius[2150]: You may redistribute copies of FreeRADIUS under the terms of the Mai 11 09:30:36 bkr-idm1 freeradius[2150]: GNU General Public License Mai 11 09:30:36 bkr-idm1 freeradius[2150]: For more information about these matters, see the file named COPYRIGHT Mai 11 09:30:36 bkr-idm1 freeradius[2150]: Starting - reading configuration files ... Mai 11 09:30:36 bkr-idm1 freeradius[2150]: Debugger not attached Mai 11 09:30:36 bkr-idm1 freeradius[2150]: Creating attribute Unix-Group Mai 11 09:30:36 bkr-idm1 freeradius[2150]: Creating attribute LDAP-Group Mai 11 09:30:36 bkr-idm1 freeradius[2150]: rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output Mai 11 09:30:36 bkr-idm1 freeradius[2150]: tls: Using cached TLS configuration from previous invocation Mai 11 09:30:36 bkr-idm1 freeradius[2150]: [/etc/freeradius/3.0/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay" found in filter list for realm "DEFAULT". Mai 11 09:30:36 bkr-idm1 freeradius[2150]: [/etc/freeradius/3.0/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay-USec" found in filter list for realm "DEFAULT". Mai 11 09:30:36 bkr-idm1 freeradius[2150]: rlm_mschap (mschap): authenticating by calling 'ntlm_auth' Mai 11 09:30:36 bkr-idm1 freeradius[2150]: rlm_ldap: libldap vendor: OpenLDAP, version: 20445 Mai 11 09:30:36 bkr-idm1 freeradius[2150]: rlm_ldap (ldap): Initialising connection pool Mai 11 09:30:36 bkr-idm1 freeradius[2150]: rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked Mai 11 09:30:36 bkr-idm1 freeradius[2150]: Ignoring "sql" (see raddb/mods-available/README.rst) Mai 11 09:30:36 bkr-idm1 freeradius[2150]: radiusd: #### Skipping IP addresses and Ports #### Mai 11 09:30:36 bkr-idm1 freeradius[2150]: Configuration appears to be OK Mai 11 09:30:36 bkr-idm1 freeradius[2150]: rlm_ldap (ldap): Removing connection pool Mai 11 09:30:36 bkr-idm1 systemd[1]: freeradius.service: Control process exited, code=exited status=1 Mai 11 09:30:36 bkr-idm1 systemd[1]: Failed to start FreeRADIUS multi-protocol policy server. -- Subject: Unit freeradius.service has failed -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- Unit freeradius.service has failed. -- -- The result is failed. Mai 11 09:30:36 bkr-idm1 systemd[1]: freeradius.service: Unit entered failed state. Mai 11 09:30:36 bkr-idm1 systemd[1]: freeradius.service: Failed with result 'exit-code'. The configuration of my virtual servers and the clients.conf should be ok. While configuring the virtual servers i got a few error messages from the command journalctl -xe. If i just use one virtual server everthing works fine. A little bit of helf would be appreciated. Regards, Simon Dankau

4 9

Some Question Tricky
by mohamed almeshal 11 May '21

11 May '21

First of all thanks for those kind info . my questions are : * what is the best way to reject all user packets except those who is registered to server . * I need to bind voucher accounts to mac address those are first use the voucher what is the best way to do ? * I have repeated problem that use of MAX-ALL-SESSION for the hotspot usually reject with this message :" Your maximum never usage time has been reached " I try to undestand the problem with no luck . Thanks For generous kind

3 2