- Freeradius-Users - lists.freeradius.org

Help Unlang Freeradius 2.x to 3.x
by Olivier CALVANO 02 Jul '20

02 Jul '20

Hello, I get stuck a little to find the solution in unlang; =) I admit that I don't master at all. I have this condition which works under Freeradius 2.x: if ((Tunnel-Server-Endpoint: 0 [0]! = '192.168.1.1') && (User-Name = ~ /\\.local/) && (User-Name! ~ /network\\.local/) && ("% {Packet-Src-IP-Address}" == "172.16.100.100")) { I can't find the equivalent in Freeradius 3.0.17 I tried in particular if ((& Tunnel-Server-Endpoint! = '192.168.1.1') && (User-Name = ~ /\\.local/) && (User-Name! ~ /network\\.local/) && ("% { Packet-Src-IP-Address} "==" 172.16.100.100 ")) { but that blocks, it is always at the level of the first condition that there is the problem. What I would like is: Yes Tunnel-Server-Endpoint * (0 1 or other) is not equal to 192.168.1.1 Or Tunnel-Server-Endpoint * (0 1 or other) is not equal to 192.168.1.2 so he looks at the other conditions including User-Name and Packet-Src Otherwise, would I have to do several if ? sample: if ("%{Packet-Src-IP-Address}" == "172.16.100.100") { if ((User-Name =~ /\\.local/) && (User-Name !~ /network\\.local/)) { if (&Tunnel-Server-Endpoint* != '192.168.1.1') { xxxx } } } thank you for your help Olivier

2 3

Memory leak in FR 3.0.19 ?
by Arnaud LAURIOU 30 Jun '20

30 Jun '20

Hi, We are suspecting memory leak in FR 3.0.19 : process memory status show VmData always keep increasing leading to VmSwap use after a few days which also keep increasing. I have 2 questions : - What are the compile options to use valgrind ? only flag --enable-developper ?|| - In the changelog for version 3.0.20 : some memories problems seems to be solved, do you know when this version will be released ? (if the release date is close, we can wait to test this release rather than 3.0.19) Regards, Arnaud Lauriou

3 5

Plan assignment based on nas and ugroups
by Ganga R. Dhungyel 30 Jun '20

30 Jun '20

Hello Community I am running freeradius-3.0.13-10 with sql backend on centos to authenticate and authorize users based on group membership. Now a new requirement to assign vlan based on group AND nas has come up and I am not sure what is the best way to accomplish this. Need something like: If nas is xyz and user belong to group A, then reply with vlan id 10, else if nas is abc and user belongs to group A, reply with vlan 100, else reply with vlan 200. Is using huntgroup and groupcheck the best way to accomplish this? If so, what all need modifications. Example would be great. If not, what would be a better solution considering that I am using realm sql. My apologies if this has been answered before..browsed the list and really could not find the use case described. Thank you. -- Dhungyel

2 3

TLS 1.3
by Vieri 29 Jun '20

29 Jun '20

Unfortunately, I can't grab a packet trace just yet until I locate one of those devices (custom external firmware). I'll have a look at it asap. In the meantime, maybe setting cipher_list = "ALL" can be more permissive than "DEFAULT", but I'm guessing I won't have much luck because the most reasonable set that might be excluded is LOW, but "As of OpenSSL 1.0.2g, these are disabled in default builds". On the freeradius server I have: # openssl ciphers -s -tls1 ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:DHE-RSA-AES128-SHA:AES256-SHA:AES128-SHA # openssl ciphers -s -tls1_1 ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:DHE-RSA-AES128-SHA:AES256-SHA:AES128-SHA # openssl ciphers -s -tls1_2 ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA384:DHE-RSA-AES256-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:DHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA256:AES128-SHA256:AES256-SHA:AES128-SHA # openssl ciphers -s -tls1_3 TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256 These devices have started to fail when I upgraded my FreeRADIUS server (openssl, etc.). So I'm guessing I'm missing some old insecure ciphers in openssl. Now convince the vendor to upgrade their client systems... Thanks, Vieri

2 1

TLS 1.3
by Vieri 29 Jun '20

29 Jun '20

So, I gather that "recv TLS 1.3" does not necessarily mean that the client *requires* TLS 1.3. Then,"send TLS 1.0" might mean that we offered TLS 1.0 but a cipher the client refused. There's no way to tell which is the culprit (TLS or cipher suite)? In freeradius eap I have: cipher_list = "DEFAULT" cipher_server_preference = no So I guess I'm not being very picky, am I? Maybe I can be more permissive by changing "DEFAULT" to an explicit list? Vieri

2 1

TLS 1.3
by Vieri 29 Jun '20

29 Jun '20

Hi, What does this log snippet mean? (2) eap_peap: Continuing EAP-TLS (2) eap_peap: Peer indicated complete TLS record size will be 71 bytes (2) eap_peap: Got complete TLS record (71 bytes) (2) eap_peap: [eaptls verify] = length included (2) eap_peap: (other): before SSL initialization (2) eap_peap: TLS_accept: before SSL initialization (2) eap_peap: TLS_accept: before SSL initialization (2) eap_peap: <<< recv TLS 1.3 [length 0042] (2) eap_peap: >>> send TLS 1.0 Alert [length 0002], fatal handshake_failure (2) eap_peap: ERROR: TLS Alert write:fatal:handshake failure tls: TLS_accept: Error in error (2) eap_peap: ERROR: Failed in __FUNCTION__ (SSL_read): error:1417A0C1:SSL routines:tls_post_process_client_hello:no shared cipher (2) eap_peap: ERROR: System call (I/O) error (-1) (2) eap_peap: ERROR: TLS receive handshake failed during operation (2) eap_peap: ERROR: [eaptls process] = fail (2) eap: ERROR: Failed continuing EAP PEAP (25) session. EAP sub-module failed (2) eap: Sending EAP Failure (code 4) ID 101 length 4 (2) eap: Failed in EAP select Does it mean that the wifi client asked for TLS 1.3, but we replied with TLS 1.0? I have this in freeradius: tls_min_version = "1.0" tls_max_version = "1.2" and I'm using openssl-1.1.1g. Regards, Vieri

2 1

EAP-TEAP support on the radar?
by Graham Clinch 29 Jun '20

29 Jun '20

Hi, I've stumbled across a few slightly obscured mentions of EAP-TEAP support coming in the latest Windows 10 release - eg "EAP-TEAP is supported on Windows 10 v2004 operating system and later" from: https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-gpwl/6694fb… I think this is first time a widely deployed supplicant (with apologies to wpa_supplicant) will have TEAP support. We would be absolutely ecstatic if we were able to use both computer and user credentials as part of the network placement decision (in particular for VPN sessions). Is TEAP support on a future-plans-list for FreeRADIUS? Graham

3 3

Rewriting contents of Accounting messages
by Pavel Uhliar 26 Jun '20

26 Jun '20

... my apologies, resending previous mail again with correct subject, sorry for posting it without ... Hello, guys. I am stuck with rewriting the contents of Accounting messages and need your advice. I need to manipulate Class attribute (I might use another one, but I guess there is no difference in handling attributes internally) according to actual state of local database running on RADIUS server. To be specific, based on data received in Access-Request packet and actual contents of RADIUS database my custom function in policy.conf decides which service name should be supplied to customer and relays this info to NAS using Class attribute. The NAS itself is not the entity that needs to receive the information. NAS copies the Class attribute into subsequent Accounting messages sent after opening the session, and those Accounting messages are proxied to another entity (let's call it "black-box", since it is beyond my control). Black-box influences traffic transferred by the session according to service template (which is my desired effect). xxx.rewrite.class { if ((Called-Station-Id) && "%{Called-Station-Id}" =~ /^IW-REG([0-9]{3})-SVC(.*)$/i) { update reply { Class := "%{tolower:IW-R%{1}-S%{2}}-%{sql: SELECT SVC FROM radcheck WHERE MAC='%{Calling-Station-Id}'}" } updated } else { noop } } I included my function into "authorize" and "preacct" sections of "default" site config and everything works fine when the session is being started. Now I need to change contents of the Class attribute DURING THE LIFETIME of the session. NAS keeps sending Accounting Interim updates. The information coming from NAS is still the same as it was in Access-Request, but setting in local database changed, so my script produces another contents for Class attribute, and I need the change to be reflected in Accounting messsage proxied to the black-box. My idea was just to keep the same rewrite function in place, and I was hoping that Class attribute will be sent back in response to Accounting same as it was in response to Access-Request, then NAS will start to include new version of my Class, that will be proxied to black-box, and black-box does its job. Unfortunately I can't get RADIUS to send the Class attribute in response to Accounting message (neither Start nor Interim), Response contains just Authenticator. So my intended solution does not work. Can you advise how to force the Class attribute to be included? 09:31:01.466731 IP (tos 0x0, ttl 56, id 65225, offset 0, flags [DF], proto UDP (17), length 217) xxxxx.59947 > yyyyy.radius-acct: RADIUS, length: 189 Accounting Request (4), id: 0x1b, Authenticator: c88c72cdfc48aa71744fbd90733a09a5 Accounting Status Attribute (40), length: 6, Value: Start NAS Port Type Attribute (61), length: 6, Value: Wireless - IEEE 802.11 Calling Station Attribute (31), length: 19, Value: 34:A8:EB:0B:4D:03 Called Station Attribute (30), length: 21, Value: IW-REG001-SVCabc NAS Port ID Attribute (87), length: 11, Value: BR-airmax Username Attribute (1), length: 19, Value: 34:A8:EB:0B:4D:03 NAS Port Attribute (5), length: 6, Value: -2141191544 Accounting Session ID Attribute (44), length: 10, Value: 80600288 Framed IP Address Attribute (8), length: 6, Value: 192.168.98.189 Vendor Specific Attribute (26), length: 12, Value: Vendor: Unknown (14988) Vendor Attribute: 10, Length: 4, Value: ..b. Class Attribute (25), length: 22, Value: iw-r001-sabc-bbbb Event Timestamp Attribute (55), length: 6, Value: Thu Jun 25 09:31:01 2020 NAS ID Attribute (32), length: 13, Value: DHR Lucerna Accounting Delay Attribute (41), length: 6, Value: 00 secs NAS IP Address Attribute (4), length: 6, Value: xxxxx 09:31:01.474679 IP (tos 0x0, ttl 64, id 8369, offset 0, flags [none], proto UDP (17), length 48) yyyyy.radius-acct > xxxxx.59947: RADIUS, length: 20 Accounting Response (5), id: 0x1b, Authenticator: 3025c6d75fd16ac5992ac3278afa5630 As I mentioned before, I do not need the NAS to receive the info, it would be sufficient for me to modify the proxied Accounting message. So, if including the Class in Accounting Response is not possible (or does not do what I need), I could solve it just between RADIUS and Accounting proxy. I was trying to achieve this by including my function into "pre-proxy" section of default site, but it does not influence the message, Class contents is copied the same as it was ingested by the RADIUS. Can you advise how to achieve this? pre-proxy { #attr_rewrite # Uncomment the following line if you want to change attributes # as defined in the preproxy_users file. #files xxx.rewrite.class # Uncomment the following line if you want to filter requests # sent to remote servers based on the rules defined in the # 'attrs.pre-proxy' file. #attr_filter.pre-proxy # If you want to have a log of packets proxied to a home # server, un-comment the following line, and the # 'detail pre_proxy_log' section, above. #pre_proxy_log } Thanks for all hints in advance, Pavel Uhliar

2 1

(no subject)
by Pavel Uhliar 26 Jun '20

26 Jun '20

Hello, guys. I am stuck with rewriting the contents of Accounting messages and need your advice. I need to manipulate Class attribute (I might use another one, but I guess there is no difference in handling attributes internally) according to actual state of local database running on RADIUS server. To be specific, based on data received in Access-Request packet and actual contents of RADIUS database my custom function in policy.conf decides which service name should be supplied to customer and relays this info to NAS using Class attribute. The NAS itself is not the entity that needs to receive the information. NAS copies the Class attribute into subsequent Accounting messages sent after opening the session, and those Accounting messages are proxied to another entity (let's call it "black-box", since it is beyond my control). Black-box influences traffic transferred by the session according to service template (which is my desired effect). xxx.rewrite.class { if ((Called-Station-Id) && "%{Called-Station-Id}" =~ /^IW-REG([0-9]{3})-SVC(.*)$/i) { update reply { Class := "%{tolower:IW-R%{1}-S%{2}}-%{sql: SELECT SVC FROM radcheck WHERE MAC='%{Calling-Station-Id}'}" } updated } else { noop } } I included my function into "authorize" and "preacct" sections of "default" site config and everything works fine when the session is being started. Now I need to change contents of the Class attribute DURING THE LIFETIME of the session. NAS keeps sending Accounting Interim updates. The information coming from NAS is still the same as it was in Access-Request, but setting in local database changed, so my script produces another contents for Class attribute, and I need the change to be reflected in Accounting messsage proxied to the black-box. My idea was just to keep the same rewrite function in place, and I was hoping that Class attribute will be sent back in response to Accounting same as it was in response to Access-Request, then NAS will start to include new version of my Class, that will be proxied to black-box, and black-box does its job. Unfortunately I can't get RADIUS to send the Class attribute in response to Accounting message (neither Start nor Interim), Response contains just Authenticator. So my intended solution does not work. Can you advise how to force the Class attribute to be included? 09:31:01.466731 IP (tos 0x0, ttl 56, id 65225, offset 0, flags [DF], proto UDP (17), length 217) xxxxx.59947 > yyyyy.radius-acct: RADIUS, length: 189 Accounting Request (4), id: 0x1b, Authenticator: c88c72cdfc48aa71744fbd90733a09a5 Accounting Status Attribute (40), length: 6, Value: Start NAS Port Type Attribute (61), length: 6, Value: Wireless - IEEE 802.11 Calling Station Attribute (31), length: 19, Value: 34:A8:EB:0B:4D:03 Called Station Attribute (30), length: 21, Value: IW-REG001-SVCabc NAS Port ID Attribute (87), length: 11, Value: BR-airmax Username Attribute (1), length: 19, Value: 34:A8:EB:0B:4D:03 NAS Port Attribute (5), length: 6, Value: -2141191544 Accounting Session ID Attribute (44), length: 10, Value: 80600288 Framed IP Address Attribute (8), length: 6, Value: 192.168.98.189 Vendor Specific Attribute (26), length: 12, Value: Vendor: Unknown (14988) Vendor Attribute: 10, Length: 4, Value: ..b. Class Attribute (25), length: 22, Value: iw-r001-sabc-bbbb Event Timestamp Attribute (55), length: 6, Value: Thu Jun 25 09:31:01 2020 NAS ID Attribute (32), length: 13, Value: DHR Lucerna Accounting Delay Attribute (41), length: 6, Value: 00 secs NAS IP Address Attribute (4), length: 6, Value: xxxxx 09:31:01.474679 IP (tos 0x0, ttl 64, id 8369, offset 0, flags [none], proto UDP (17), length 48) yyyyy.radius-acct > xxxxx.59947: RADIUS, length: 20 Accounting Response (5), id: 0x1b, Authenticator: 3025c6d75fd16ac5992ac3278afa5630 As I mentioned before, I do not need the NAS to receive the info, it would be sufficient for me to modify the proxied Accounting message. So, if including the Class in Accounting Response is not possible (or does not do what I need), I could solve it just between RADIUS and Accounting proxy. I was trying to achieve this by including my function into "pre-proxy" section of default site, but it does not influence the message, Class contents is copied the same as it was ingested by the RADIUS. Can you advise how to achieve this? pre-proxy { #attr_rewrite # Uncomment the following line if you want to change attributes # as defined in the preproxy_users file. #files xxx.rewrite.class # Uncomment the following line if you want to filter requests # sent to remote servers based on the rules defined in the # 'attrs.pre-proxy' file. #attr_filter.pre-proxy # If you want to have a log of packets proxied to a home # server, un-comment the following line, and the # 'detail pre_proxy_log' section, above. #pre_proxy_log } Thanks for all hints in advance, Pavel Uhliar

1 0

Incorrect username being registered by freeradius
by Daniel Guimaraes Pena 25 Jun '20

25 Jun '20

Hi everyone, My freeradius (FreeRADIUS Version 3.0.12) sometimes accept users and logs at postgre some username that just don’t exist at Active Directory. I just couldn’t debug and stopped at dead end now. Here to illustrate: Mon Jun 22 18:35:06 2020 : Auth: (82485) Login OK: [flaviol] (from client AP-SD1-A07-Q04 port 0 via TLS tunnel) Mon Jun 22 18:35:06 2020 : Auth: (82486) Login OK: [flaviol] (from client AP-SD1-A07-Q04 port 2 cli E0-5F-45-###) -[ RECORD 1 ]------+--------------------------------- radacctid | 5993772 acctsessionid | 38ED2133-00000040 acctuniqueid | 2e3edbe1aa2069c36ac67cf96384219c username | e05f4588a57d groupname | realm | nasipaddress | 10.34.27.223 nasportid | 2 nasporttype | Wireless-802.11 acctstarttime | 2020-06-22 18:35:05-03 acctupdatetime | 2020-06-22 18:35:05-03 acctstoptime | 2020-06-22 18:35:05-03 Mon Jun 22 19:04:09 2020 : Auth: (89109) Login OK: [flaviol] (from client AP-SD2-A07-Q04 port 0 via TLS tunnel) Mon Jun 22 19:04:09 2020 : Auth: (89111) Login OK: [flaviol] (from client AP-SD2-A07-Q04 port 1 cli E0-5F-45-###) -[ RECORD 1 ]------+--------------------------------- radacctid | 5994474 acctsessionid | 38FCC022-00000000 acctuniqueid | c980c8b18ff062712f838541c50d9d83 username | flaviol realm | nasipaddress | 10.34.58.220 nasportid | 1 nasporttype | Wireless-802.11 acctstarttime | 2020-06-22 19:04:09-03 acctupdatetime | 2020-06-22 19:04:11-03 acctstoptime | 2020-06-22 19:04:11-03 Both entries are from the same device (same MAC address), received Login OK, but the first one got that string as username. Client is not the same. But there is a lot of entries with the correct username for that client. The odd thing is when it happens, the same string appears to the that user all the time. For other user, a different string appears and it will be always the same. Sorry, but this is a difficult problem to explain... Even the title of thread was difficult to choose =[ Anyway, can anyone help me debug this problem? # lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 9.12 (stretch) Release: 9.12 Codename: stretch # dpkg -l freeradius Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++-========================-=================-=================-===================================================== ii freeradius 3.0.12+dfsg-5+deb amd64 high-performance and highly configurable RADIUS serve # =~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2020.06.22 22:51:13 =~=~=~=~=~=~=~=~=~=~=~= freeradius -X FreeRADIUS Version 3.0.12 Copyright (C) 1999-2016 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file /usr/share/freeradius/dictionary including dictionary file /usr/share/freeradius/dictionary.dhcp including dictionary file /usr/share/freeradius/dictionary.vqp including dictionary file /etc/freeradius/3.0/dictionary including configuration file /etc/freeradius/3.0/radiusd.conf including configuration file /etc/freeradius/3.0/proxy.conf including configuration file /etc/freeradius/3.0/clients.conf including files in directory /etc/freeradius/3.0/mods-enabled/ including configuration file /etc/freeradius/3.0/mods-enabled/realm including configuration file /etc/freeradius/3.0/mods-enabled/digest including configuration file /etc/freeradius/3.0/mods-enabled/exec including configuration file /etc/freeradius/3.0/mods-enabled/linelog including configuration file /etc/freeradius/3.0/mods-enabled/passwd including configuration file /etc/freeradius/3.0/mods-enabled/eap including configuration file /etc/freeradius/3.0/mods-enabled/unix including configuration file /etc/freeradius/3.0/mods-enabled/pap including configuration file /etc/freeradius/3.0/mods-enabled/detail.log including configuration file /etc/freeradius/3.0/mods-enabled/chap including configuration file /etc/freeradius/3.0/mods-enabled/expr including configuration file /etc/freeradius/3.0/mods-enabled/date including configuration file /etc/freeradius/3.0/mods-enabled/dynamic_clients including configuration file /etc/freeradius/3.0/mods-enabled/sradutmp including configuration file /etc/freeradius/3.0/mods-enabled/ntlm_auth including configuration file /etc/freeradius/3.0/mods-enabled/utf8 including configuration file /etc/freeradius/3.0/mods-enabled/unpack including configuration file /etc/freeradius/3.0/mods-enabled/soh including configuration file /etc/freeradius/3.0/mods-enabled/radutmp including configuration file /etc/freeradius/3.0/mods-enabled/preprocess including configuration file /etc/freeradius/3.0/mods-enabled/expiration including configuration file /etc/freeradius/3.0/mods-enabled/attr_filter including configuration file /etc/freeradius/3.0/mods-enabled/sql including configuration file /etc/freeradius/3.0/mods-config/sql/main/postgresql/queries.conf including configuration file /etc/freeradius/3.0/mods-enabled/always including configuration file /etc/freeradius/3.0/mods-enabled/cache_eap including configuration file /etc/freeradius/3.0/mods-enabled/mschap including configuration file /etc/freeradius/3.0/mods-enabled/files including configuration file /etc/freeradius/3.0/mods-enabled/echo including configuration file /etc/freeradius/3.0/mods-enabled/detail including configuration file /etc/freeradius/3.0/mods-enabled/logintime including configuration file /etc/freeradius/3.0/mods-enabled/replicate including files in directory /etc/freeradius/3.0/policy.d/ including configuration file /etc/freeradius/3.0/policy.d/eap including configuration file /etc/freeradius/3.0/policy.d/filter including configuration file /etc/freeradius/3.0/policy.d/cui including configuration file /etc/freeradius/3.0/policy.d/accounting including configuration file /etc/freeradius/3.0/policy.d/operator-name including configuration file /etc/freeradius/3.0/policy.d/dhcp including configuration file /etc/freeradius/3.0/policy.d/abfab-tr including configuration file /etc/freeradius/3.0/policy.d/canonicalization including configuration file /etc/freeradius/3.0/policy.d/debug including configuration file /etc/freeradius/3.0/policy.d/control including configuration file /etc/freeradius/3.0/policy.d/moonshot-targeted-ids including files in directory /etc/freeradius/3.0/sites-enabled/ including configuration file /etc/freeradius/3.0/sites-enabled/control-socket including configuration file /etc/freeradius/3.0/sites-enabled/default including configuration file /etc/freeradius/3.0/sites-enabled/inner-tunnel including configuration file /etc/freeradius/3.0/sites-enabled/status 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 = 204800 pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = yes auth_badpass = no auth_goodpass = no colourise = yes msg_denied = "You are already logged in - access denied" } resources { } security { max_attributes = 200 reject_delay = 1.000000 status_server = yes } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = <<< secret >>> response_window = 20.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 check_timeout = 4 num_answers_to_alive = 3 revive_interval = 120 limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = <<< secret >>> nas_type = "other" proto = "*" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client localhost_ipv6 { ipv6addr = ::1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Debugger not attached # Creating Auth-Type = mschap # Creating Auth-Type = digest # Creating Auth-Type = eap # Creating Auth-Type = NTLM_AUTH # Creating Auth-Type = PAP # Creating Auth-Type = CHAP # Creating Auth-Type = MS-CHAP # Creating Acct-Type = Status-Server # Creating Autz-Type = Status-Server radiusd: #### Instantiating modules #### modules { # Loaded module rlm_realm # Loading module "IPASS" from file /etc/freeradius/3.0/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/freeradius/3.0/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/freeradius/3.0/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/freeradius/3.0/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loaded module rlm_digest # Loading module "digest" from file /etc/freeradius/3.0/mods-enabled/digest # Loaded module rlm_exec # Loading module "exec" from file /etc/freeradius/3.0/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_linelog # Loading module "linelog" from file /etc/freeradius/3.0/mods-enabled/linelog linelog { filename = "/var/log/freeradius/linelog" escape_filenames = no syslog_severity = "notice" 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/3.0/mods-enabled/linelog linelog log_accounting { filename = "/var/log/freeradius/linelog-accounting" escape_filenames = no syslog_severity = "notice" permissions = 384 format = "" reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}" } # Loaded module rlm_passwd # Loading module "etc_passwd" from file /etc/freeradius/3.0/mods-enabled/passwd passwd etc_passwd { filename = "/etc/passwd" format = "*User-Name:Crypt-Password:" delimiter = ":" ignore_nislike = no ignore_empty = yes allow_multiple_keys = no hash_size = 100 } # Loaded module rlm_eap # Loading module "eap" from file /etc/freeradius/3.0/mods-enabled/eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 204800 } # Loaded module rlm_unix # Loading module "unix" from file /etc/freeradius/3.0/mods-enabled/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Creating attribute Unix-Group # Loaded module rlm_pap # Loading module "pap" from file /etc/freeradius/3.0/mods-enabled/pap pap { normalise = yes } # Loaded module rlm_detail # Loading module "auth_log" from file /etc/freeradius/3.0/mods-enabled/detail.log detail auth_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "reply_log" from file /etc/freeradius/3.0/mods-enabled/detail.log detail reply_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/reply-detail" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "pre_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log detail pre_proxy_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/pre-proxy-detail" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "post_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log detail post_proxy_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/post-proxy-detail" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_chap # Loading module "chap" from file /etc/freeradius/3.0/mods-enabled/chap # Loaded module rlm_expr # Loading module "expr" from file /etc/freeradius/3.0/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_date # Loading module "date" from file /etc/freeradius/3.0/mods-enabled/date date { format = "%a, %d-%m-%Y %H:%M:%S" } # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/freeradius/3.0/mods-enabled/dynamic_clients # Loaded module rlm_radutmp # Loading module "sradutmp" from file /etc/freeradius/3.0/mods-enabled/sradutmp radutmp sradutmp { filename = "/var/log/freeradius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loading module "ntlm_auth" from file /etc/freeradius/3.0/mods-enabled/ntlm_auth exec ntlm_auth { wait = yes program = "/usr/bin/ntlm_auth --request-nt-key --domain=MPDFT --username=%{mschap:User-Name} --password=%{User-Password}" shell_escape = yes } # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/freeradius/3.0/mods-enabled/utf8 # Loaded module rlm_unpack # Loading module "unpack" from file /etc/freeradius/3.0/mods-enabled/unpack # Loaded module rlm_soh # Loading module "soh" from file /etc/freeradius/3.0/mods-enabled/soh soh { dhcp = yes } # Loading module "radutmp" from file /etc/freeradius/3.0/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_preprocess # Loading module "preprocess" from file /etc/freeradius/3.0/mods-enabled/preprocess preprocess { huntgroups = "/etc/freeradius/3.0/mods-config/preprocess/huntgroups" hints = "/etc/freeradius/3.0/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_expiration # Loading module "expiration" from file /etc/freeradius/3.0/mods-enabled/expiration # Loaded module rlm_attr_filter # Loading module "attr_filter.post-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/freeradius/3.0/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.pre-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/freeradius/3.0/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.access_reject" from file /etc/freeradius/3.0/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/freeradius/3.0/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.access_challenge" from file /etc/freeradius/3.0/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/freeradius/3.0/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.accounting_response" from file /etc/freeradius/3.0/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/freeradius/3.0/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } # Loaded module rlm_sql # Loading module "sql" from file /etc/freeradius/3.0/mods-enabled/sql sql { driver = "rlm_sql_postgresql" server = "localhost" port = 5432 login = "radius" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = yes delete_stale_sessions = yes sql_user_name = "%{tolower:%{%{Stripped-User-Name}:-%{%{User-Name}:-none}}}" default_user_profile = "" client_query = "SELECT id, nasname, shortname, type, secret, server FROM nas" authorize_check_query = "SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, GroupName, Attribute, Value, op FROM radgroupcheck WHERE GroupName = '%{SQL-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, GroupName, Attribute, Value, op FROM radgroupreply WHERE GroupName = '%{SQL-Group}' ORDER BY id" group_membership_query = "SELECT GroupName FROM radusergroup WHERE UserName='%{SQL-User-Name}' ORDER BY priority" simul_count_query = "SELECT COUNT(distinct callingstationid) FROM radacct WHERE UserName='%{SQL-User-Name}' AND CallingStationId<>'%{outer.request:Calling-Station-Id}' AND AcctStopTime IS NULL" simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime IS NULL" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" accounting { reference = "%{tolower:type.%{%{Acct-Status-Type}:-none}.query}" type { accounting-on { query = "UPDATE radacct SET AcctStopTime = TO_TIMESTAMP(%{integer:Event-Timestamp}), AcctUpdateTime = TO_TIMESTAMP(%{integer:Event-Timestamp}), AcctSessionTime = (%{integer:Event-Timestamp} - EXTRACT(EPOCH FROM(AcctStartTime))), AcctTerminateCause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE AcctStopTime IS NULL AND NASIPAddress= '%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= '%S'::timestamp" } accounting-off { query = "UPDATE radacct SET AcctStopTime = TO_TIMESTAMP(%{integer:Event-Timestamp}), AcctUpdateTime = TO_TIMESTAMP(%{integer:Event-Timestamp}), AcctSessionTime = (%{integer:Event-Timestamp} - EXTRACT(EPOCH FROM(AcctStartTime))), AcctTerminateCause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE AcctStopTime IS NULL AND NASIPAddress= '%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= '%S'::timestamp" } start { query = "INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_Stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIpAddress) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', NULLIF('%{Realm}', ''), '%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}}', NULLIF('%{%{NAS-Port-ID}:-%{NAS-Port}}', ''), '%{NAS-Port-Type}', TO_TIMESTAMP(%{integer:Event-Timestamp}), TO_TIMESTAMP(%{integer:Event-Timestamp}), NULL, 0, '%{Acct-Authentic}', '%{Connect-Info}', NULL, 0, 0, '%{Called-Station-Id}', '%{Calling-Station-Id}', NULL, '%{Service-Type}', '%{Framed-Protocol}', NULLIF('%{Framed-IP-Address}', '')::inet)" } interim-update { query = "UPDATE radacct SET FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet, AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, AcctInterval = (%{integer:Event-Timestamp} - EXTRACT(EPOCH FROM (COALESCE(AcctUpdateTime, AcctStartTime)))), AcctUpdateTime = TO_TIMESTAMP(%{integer:Event-Timestamp}), AcctInputOctets = (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), AcctOutputOctets = (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint) WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' AND AcctStopTime IS NULL" } stop { query = "UPDATE radacct SET AcctStopTime = TO_TIMESTAMP(%{integer:Event-Timestamp}), AcctUpdateTime = TO_TIMESTAMP(%{integer:Event-Timestamp}), AcctSessionTime = COALESCE(%{%{Acct-Session-Time}:-NULL}, (%{integer:Event-Timestamp} - EXTRACT(EPOCH FROM(AcctStartTime)))), AcctInputOctets = (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), AcctOutputOctets = (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint), AcctTerminateCause = '%{Acct-Terminate-Cause}', FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet, ConnectInfo_stop = '%{Connect-Info}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' AND AcctStopTime IS NULL" } } } post-auth { reference = ".query" query = "INSERT INTO radpostauth (username, pass, reply, calledstationid, callingstationid, authdate) VALUES('%{User-Name}', '%{%{User-Password}:-Chap-Password}', '%{reply:Packet-Type}', '%{Called-Station-Id}', '%{Calling-Station-Id}', TO_TIMESTAMP(%{integer:Event-Timestamp}))" } } rlm_sql (sql): Driver rlm_sql_postgresql (module rlm_sql_postgresql) loaded and linked Creating attribute SQL-Group # Loaded module rlm_always # Loading module "reject" from file /etc/freeradius/3.0/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/freeradius/3.0/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/freeradius/3.0/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/freeradius/3.0/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/freeradius/3.0/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/freeradius/3.0/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/freeradius/3.0/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/freeradius/3.0/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/freeradius/3.0/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Loaded module rlm_cache # Loading module "cache_eap" from file /etc/freeradius/3.0/mods-enabled/cache_eap cache cache_eap { driver = "rlm_cache_rbtree" key = "%{%{control:State}:-%{%{reply:State}:-%{State}}}" ttl = 15 max_entries = 0 epoch = 0 add_stats = no } # Loaded module rlm_mschap # Loading module "mschap" from file /etc/freeradius/3.0/mods-enabled/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = yes passchange { ntlm_auth = "/usr/bin/ntlm_auth --helper-protocol=ntlm-change-password-1" ntlm_auth_username = "username: %{mschap:User-Name}" ntlm_auth_domain = "nt-domain: %{mschap:NT-Domain}" } allow_retry = yes } # Loaded module rlm_files # Loading module "files" from file /etc/freeradius/3.0/mods-enabled/files files { filename = "/etc/freeradius/3.0/mods-config/files/authorize" acctusersfile = "/etc/freeradius/3.0/mods-config/files/accounting" preproxy_usersfile = "/etc/freeradius/3.0/mods-config/files/pre-proxy" } # Loading module "echo" from file /etc/freeradius/3.0/mods-enabled/echo exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = yes } # Loading module "detail" from file /etc/freeradius/3.0/mods-enabled/detail detail { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_logintime # Loading module "logintime" from file /etc/freeradius/3.0/mods-enabled/logintime logintime { minimum_timeout = 60 } # Loaded module rlm_replicate # Loading module "replicate" from file /etc/freeradius/3.0/mods-enabled/replicate instantiate { # Instantiating module "logintime" from file /etc/freeradius/3.0/mods-enabled/logintime } # Instantiating module "IPASS" from file /etc/freeradius/3.0/mods-enabled/realm # Instantiating module "suffix" from file /etc/freeradius/3.0/mods-enabled/realm # Instantiating module "realmpercent" from file /etc/freeradius/3.0/mods-enabled/realm # Instantiating module "ntdomain" from file /etc/freeradius/3.0/mods-enabled/realm # Instantiating module "linelog" from file /etc/freeradius/3.0/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/freeradius/3.0/mods-enabled/linelog # Instantiating module "etc_passwd" from file /etc/freeradius/3.0/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # Instantiating module "eap" from file /etc/freeradius/3.0/mods-enabled/eap # Linked to sub-module rlm_eap_md5 # Linked to sub-module rlm_eap_leap # Linked to sub-module rlm_eap_gtc gtc { challenge = "Password: " auth_type = "PAP" } # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" } tls-config tls-common { verify_depth = 0 ca_path = "/etc/freeradius/3.0/certs" pem_file_type = yes private_key_file = "/etc/ssl/private/ssl-cert-snakeoil.key" certificate_file = "/etc/ssl/certs/ssl-cert-snakeoil.pem" ca_file = "/etc/ssl/certs/ca-certificates.crt" private_key_password = <<< secret >>> dh_file = "/etc/freeradius/3.0/certs/dh" fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no cipher_list = "DEFAULT" ecdh_curve = "prime256v1" cache { enable = yes lifetime = 24 max_entries = 255 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "pap" from file /etc/freeradius/3.0/mods-enabled/pap # Instantiating module "auth_log" from file /etc/freeradius/3.0/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/3.0/mods-enabled/detail.log # Instantiating module "pre_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log # Instantiating module "post_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log # Instantiating module "preprocess" from file /etc/freeradius/3.0/mods-enabled/preprocess reading pairlist file /etc/freeradius/3.0/mods-config/preprocess/huntgroups reading pairlist file /etc/freeradius/3.0/mods-config/preprocess/hints # Instantiating module "expiration" from file /etc/freeradius/3.0/mods-enabled/expiration # Instantiating module "attr_filter.post-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/post-proxy # Instantiating module "attr_filter.pre-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/pre-proxy # Instantiating module "attr_filter.access_reject" from file /etc/freeradius/3.0/mods-enabled/attr_filter reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/access_reject /etc/freeradius/3.0/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay" found in filter list for realm "DEFAULT". /etc/freeradius/3.0/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay-USec" found in filter list for realm "DEFAULT". # Instantiating module "attr_filter.access_challenge" from file /etc/freeradius/3.0/mods-enabled/attr_filter reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/access_challenge # Instantiating module "attr_filter.accounting_response" from file /etc/freeradius/3.0/mods-enabled/attr_filter reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/accounting_response # Instantiating module "sql" from file /etc/freeradius/3.0/mods-enabled/sql postgresql { send_application_name = no } rlm_sql (sql): Attempting to connect to database "radius" rlm_sql (sql): Initialising connection pool pool { start = 5 min = 3 max = 32 spare = 10 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 30 spread = no } rlm_sql (sql): Opening additional connection (0), 1 of 32 pending slots used rlm_sql_postgresql: Connecting using parameters: dbname='radius' host='localhost' port=5432 user='radius' password='senhadoradius' Connected to database 'radius' on 'localhost' server version 90617, protocol version 3, backend PID 13108 rlm_sql (sql): Opening additional connection (1), 1 of 31 pending slots used rlm_sql_postgresql: Connecting using parameters: dbname='radius' host='localhost' port=5432 user='radius' password='senhadoradius' Connected to database 'radius' on 'localhost' server version 90617, protocol version 3, backend PID 13109 rlm_sql (sql): Opening additional connection (2), 1 of 30 pending slots used rlm_sql_postgresql: Connecting using parameters: dbname='radius' host='localhost' port=5432 user='radius' password='senhadoradius' Connected to database 'radius' on 'localhost' server version 90617, protocol version 3, backend PID 13110 rlm_sql (sql): Opening additional connection (3), 1 of 29 pending slots used rlm_sql_postgresql: Connecting using parameters: dbname='radius' host='localhost' port=5432 user='radius' password='senhadoradius' Connected to database 'radius' on 'localhost' server version 90617, protocol version 3, backend PID 13111 rlm_sql (sql): Opening additional connection (4), 1 of 28 pending slots used rlm_sql_postgresql: Connecting using parameters: dbname='radius' host='localhost' port=5432 user='radius' password='senhadoradius' Connected to database 'radius' on 'localhost' server version 90617, protocol version 3, backend PID 13112 rlm_sql (sql): Processing generate_sql_clients rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas rlm_sql (sql): Reserved connection (0) rlm_sql (sql): Executing select query: SELECT id, nasname, shortname, type, secret, server FROM nas rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: query affected rows = 179 , fields = 6 rlm_sql (sql): Adding client 10.34.158.220 (AP-AGC-A03-220) to global clients list rlm_sql (10.34.158.220): Client "AP-AGC-A03-220" (sql) added rlm_sql (sql): Adding client 10.34.158.221 (AP-AGC-A03-221) to global clients list rlm_sql (10.34.158.221): Client "AP-AGC-A03-221" (sql) added rlm_sql (sql): Adding client 10.35.93.224 (AP-BR2-A01-Q01) to global clients list rlm_sql (10.35.93.224): Client "AP-BR2-A01-Q01" (sql) added rlm_sql (sql): Adding client 10.35.93.225 (AP-BR2-A01-Q02) to global clients list rlm_sql (10.35.93.225): Client "AP-BR2-A01-Q02" (sql) added rlm_sql (sql): Adding client 10.35.93.226 (AP-BR2-A01-Q03) to global clients list rlm_sql (10.35.93.226): Client "AP-BR2-A01-Q03" (sql) added rlm_sql (sql): Adding client 10.35.93.227 (AP-BR2-A01-Q04) to global clients list rlm_sql (10.35.93.227): Client "AP-BR2-A01-Q04" (sql) added rlm_sql (sql): Adding client 10.35.93.228 (AP-BR2-A02-Q01) to global clients list rlm_sql (10.35.93.228): Client "AP-BR2-A02-Q01" (sql) added rlm_sql (sql): Adding client 10.35.93.229 (AP-BR2-A02-Q02) to global clients list rlm_sql (10.35.93.229): Client "AP-BR2-A02-Q02" (sql) added rlm_sql (sql): Adding client 10.35.93.230 (AP-BR2-A02-Q03) to global clients list rlm_sql (10.35.93.230): Client "AP-BR2-A02-Q03" (sql) added rlm_sql (sql): Adding client 10.35.93.231 (AP-BR2-A02-Q04) to global clients list rlm_sql (10.35.93.231): Client "AP-BR2-A02-Q04" (sql) added rlm_sql (sql): Adding client 10.35.93.223 (AP-BR2-TER-223) to global clients list rlm_sql (10.35.93.223): Client "AP-BR2-TER-223" (sql) added rlm_sql (sql): Adding client 10.35.93.221 (AP-BR2-TER-Q02) to global clients list rlm_sql (10.35.93.221): Client "AP-BR2-TER-Q02" (sql) added rlm_sql (sql): Adding client 10.35.93.222 (AP-BR2-TER-Q03) to global clients list rlm_sql (10.35.93.222): Client "AP-BR2-TER-Q03" (sql) added rlm_sql (sql): Adding client 10.34.82.220 (AP-BRZ-TER-220) to global clients list rlm_sql (10.34.82.220): Client "AP-BRZ-TER-220" (sql) added rlm_sql (sql): Adding client 10.34.82.221 (AP-BRZ-TER-221) to global clients list rlm_sql (10.34.82.221): Client "AP-BRZ-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.82.222 (AP-BRZ-TER-222) to global clients list rlm_sql (10.34.82.222): Client "AP-BRZ-TER-222" (sql) added rlm_sql (sql): Adding client 10.34.87.220 (AP-CEI-A01-220) to global clients list rlm_sql (10.34.87.220): Client "AP-CEI-A01-220" (sql) added rlm_sql (sql): Adding client 10.34.87.222 (AP-CEI-A01-222) to global clients list rlm_sql (10.34.87.222): Client "AP-CEI-A01-222" (sql) added rlm_sql (sql): Adding client 10.34.87.224 (AP-CEI-SUB-224) to global clients list rlm_sql (10.34.87.224): Client "AP-CEI-SUB-224" (sql) added rlm_sql (sql): Adding client 10.34.87.221 (AP-CEI-TER-221) to global clients list rlm_sql (10.34.87.221): Client "AP-CEI-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.87.223 (AP-CEI-TER-223) to global clients list rlm_sql (10.34.87.223): Client "AP-CEI-TER-223" (sql) added rlm_sql (sql): Adding client 10.34.92.225 (AP-CRI-A01-225) to global clients list rlm_sql (10.34.92.225): Client "AP-CRI-A01-225" (sql) added rlm_sql (sql): Adding client 10.34.92.226 (AP-CRI-A01-226) to global clients list rlm_sql (10.34.92.226): Client "AP-CRI-A01-226" (sql) added rlm_sql (sql): Adding client 10.34.92.223 (AP-CRI-A02-223) to global clients list rlm_sql (10.34.92.223): Client "AP-CRI-A02-223" (sql) added rlm_sql (sql): Adding client 10.34.92.227 (AP-CRI-A02-227) to global clients list rlm_sql (10.34.92.227): Client "AP-CRI-A02-227" (sql) added rlm_sql (sql): Adding client 10.34.92.234 (AP-CRI-A02-234) to global clients list rlm_sql (10.34.92.234): Client "AP-CRI-A02-234" (sql) added rlm_sql (sql): Adding client 10.34.97.221 (AP-GAM-A01-221) to global clients list rlm_sql (10.34.97.221): Client "AP-GAM-A01-221" (sql) added rlm_sql (sql): Adding client 10.34.97.223 (AP-GAM-A01-223) to global clients list rlm_sql (10.34.97.223): Client "AP-GAM-A01-223" (sql) added rlm_sql (sql): Adding client 10.34.97.220 (AP-GAM-SUB-220) to global clients list rlm_sql (10.34.97.220): Client "AP-GAM-SUB-220" (sql) added rlm_sql (sql): Adding client 10.34.97.222 (AP-GAM-TER-222) to global clients list rlm_sql (10.34.97.222): Client "AP-GAM-TER-222" (sql) added rlm_sql (sql): Adding client 10.34.102.220 (AP-GAR-A01-220) to global clients list rlm_sql (10.34.102.220): Client "AP-GAR-A01-220" (sql) added rlm_sql (sql): Adding client 10.34.117.221 (AP-INF-A01-221) to global clients list rlm_sql (10.34.117.221): Client "AP-INF-A01-221" (sql) added rlm_sql (sql): Adding client 10.34.117.222 (AP-INF-A01-222) to global clients list rlm_sql (10.34.117.222): Client "AP-INF-A01-222" (sql) added rlm_sql (sql): Adding client 10.34.121.100 (AP-INF-SUB-121) to global clients list rlm_sql (10.34.121.100): Client "AP-INF-SUB-121" (sql) added rlm_sql (sql): Adding client 10.34.117.224 (AP-INF-SUB-224) to global clients list rlm_sql (10.34.117.224): Client "AP-INF-SUB-224" (sql) added rlm_sql (sql): Adding client 10.34.117.225 (AP-INF-SUB-225) to global clients list rlm_sql (10.34.117.225): Client "AP-INF-SUB-225" (sql) added rlm_sql (sql): Adding client 10.34.117.220 (AP-INF-TER-220) to global clients list rlm_sql (10.34.117.220): Client "AP-INF-TER-220" (sql) added rlm_sql (sql): Adding client 10.34.117.223 (AP-INF-TER-223) to global clients list rlm_sql (10.34.117.223): Client "AP-INF-TER-223" (sql) added rlm_sql (sql): Adding client 10.34.177.220 (AP-NAI-A01-220) to global clients list rlm_sql (10.34.177.220): Client "AP-NAI-A01-220" (sql) added rlm_sql (sql): Adding client 10.34.127.221 (AP-PAR-A01-221) to global clients list rlm_sql (10.34.127.221): Client "AP-PAR-A01-221" (sql) added rlm_sql (sql): Adding client 10.34.127.224 (AP-PAR-A01-224) to global clients list rlm_sql (10.34.127.224): Client "AP-PAR-A01-224" (sql) added rlm_sql (sql): Adding client 10.34.127.223 (AP-PAR-SUB-223) to global clients list rlm_sql (10.34.127.223): Client "AP-PAR-SUB-223" (sql) added rlm_sql (sql): Adding client 10.34.127.225 (AP-PAR-SUB-225) to global clients list rlm_sql (10.34.127.225): Client "AP-PAR-SUB-225" (sql) added rlm_sql (sql): Adding client 10.34.127.220 (AP-PAR-TER-220) to global clients list rlm_sql (10.34.127.220): Client "AP-PAR-TER-220" (sql) added rlm_sql (sql): Adding client 10.34.127.222 (AP-PAR-TER-222) to global clients list rlm_sql (10.34.127.222): Client "AP-PAR-TER-222" (sql) added rlm_sql (sql): Adding client 10.34.132.222 (AP-PLA-A01-222) to global clients list rlm_sql (10.34.132.222): Client "AP-PLA-A01-222" (sql) added rlm_sql (sql): Adding client 10.34.132.223 (AP-PLA-A01-223) to global clients list rlm_sql (10.34.132.223): Client "AP-PLA-A01-223" (sql) added rlm_sql (sql): Adding client 10.34.132.224 (AP-PLA-SUB-224) to global clients list rlm_sql (10.34.132.224): Client "AP-PLA-SUB-224" (sql) added rlm_sql (sql): Adding client 10.34.132.220 (AP-PLA-TER-220) to global clients list rlm_sql (10.34.132.220): Client "AP-PLA-TER-220" (sql) added rlm_sql (sql): Adding client 10.34.132.221 (AP-PLA-TER-221) to global clients list rlm_sql (10.34.132.221): Client "AP-PLA-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.187.222 (AP-REM-A01-222) to global clients list rlm_sql (10.34.187.222): Client "AP-REM-A01-222" (sql) added rlm_sql (sql): Adding client 10.34.187.223 (AP-REM-A01-223) to global clients list rlm_sql (10.34.187.223): Client "AP-REM-A01-223" (sql) added rlm_sql (sql): Adding client 10.34.187.220 (AP-REM-SUB-220) to global clients list rlm_sql (10.34.187.220): Client "AP-REM-SUB-220" (sql) added rlm_sql (sql): Adding client 10.34.187.221 (AP-REM-TER-221) to global clients list rlm_sql (10.34.187.221): Client "AP-REM-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.137.223 (AP-SAM-A01-223) to global clients list rlm_sql (10.34.137.223): Client "AP-SAM-A01-223" (sql) added rlm_sql (sql): Adding client 10.34.137.224 (AP-SAM-A01-224) to global clients list rlm_sql (10.34.137.224): Client "AP-SAM-A01-224" (sql) added rlm_sql (sql): Adding client 10.34.137.222 (AP-SAM-SUB-222) to global clients list rlm_sql (10.34.137.222): Client "AP-SAM-SUB-222" (sql) added rlm_sql (sql): Adding client 10.34.137.225 (AP-SAM-SUB-225) to global clients list rlm_sql (10.34.137.225): Client "AP-SAM-SUB-225" (sql) added rlm_sql (sql): Adding client 10.34.137.226 (AP-SAM-SUB-226) to global clients list rlm_sql (10.34.137.226): Client "AP-SAM-SUB-226" (sql) added rlm_sql (sql): Adding client 10.34.137.220 (AP-SAM-TER-220) to global clients list rlm_sql (10.34.137.220): Client "AP-SAM-TER-220" (sql) added rlm_sql (sql): Adding client 10.34.137.221 (AP-SAM-TER-221) to global clients list rlm_sql (10.34.137.221): Client "AP-SAM-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.9.222 (AP-SD1-A01-Q01) to global clients list rlm_sql (10.34.9.222): Client "AP-SD1-A01-Q01" (sql) added rlm_sql (sql): Adding client 10.34.9.223 (AP-SD1-A01-Q02) to global clients list rlm_sql (10.34.9.223): Client "AP-SD1-A01-Q02" (sql) added rlm_sql (sql): Adding client 10.34.9.220 (AP-SD1-A01-Q03) to global clients list rlm_sql (10.34.9.220): Client "AP-SD1-A01-Q03" (sql) added rlm_sql (sql): Adding client 10.34.9.221 (AP-SD1-A01-Q04) to global clients list rlm_sql (10.34.9.221): Client "AP-SD1-A01-Q04" (sql) added rlm_sql (sql): Adding client 10.34.12.222 (AP-SD1-A02-Q01) to global clients list rlm_sql (10.34.12.222): Client "AP-SD1-A02-Q01" (sql) added rlm_sql (sql): Adding client 10.34.12.223 (AP-SD1-A02-Q02) to global clients list rlm_sql (10.34.12.223): Client "AP-SD1-A02-Q02" (sql) added rlm_sql (sql): Adding client 10.34.12.220 (AP-SD1-A02-Q03) to global clients list rlm_sql (10.34.12.220): Client "AP-SD1-A02-Q03" (sql) added rlm_sql (sql): Adding client 10.34.12.221 (AP-SD1-A02-Q04) to global clients list rlm_sql (10.34.12.221): Client "AP-SD1-A02-Q04" (sql) added rlm_sql (sql): Adding client 10.34.15.221 (AP-SD1-A03-Q01) to global clients list rlm_sql (10.34.15.221): Client "AP-SD1-A03-Q01" (sql) added rlm_sql (sql): Adding client 10.34.15.220 (AP-SD1-A03-Q02) to global clients list rlm_sql (10.34.15.220): Client "AP-SD1-A03-Q02" (sql) added rlm_sql (sql): Adding client 10.34.15.223 (AP-SD1-A03-Q03) to global clients list rlm_sql (10.34.15.223): Client "AP-SD1-A03-Q03" (sql) added rlm_sql (sql): Adding client 10.34.15.222 (AP-SD1-A03-Q04) to global clients list rlm_sql (10.34.15.222): Client "AP-SD1-A03-Q04" (sql) added rlm_sql (sql): Adding client 10.34.18.222 (AP-SD1-A04-Q01) to global clients list rlm_sql (10.34.18.222): Client "AP-SD1-A04-Q01" (sql) added rlm_sql (sql): Adding client 10.34.18.223 (AP-SD1-A04-Q02) to global clients list rlm_sql (10.34.18.223): Client "AP-SD1-A04-Q02" (sql) added rlm_sql (sql): Adding client 10.34.18.220 (AP-SD1-A04-Q03) to global clients list rlm_sql (10.34.18.220): Client "AP-SD1-A04-Q03" (sql) added rlm_sql (sql): Adding client 10.34.21.223 (AP-SD1-A05-Q01) to global clients list rlm_sql (10.34.21.223): Client "AP-SD1-A05-Q01" (sql) added rlm_sql (sql): Adding client 10.34.21.222 (AP-SD1-A05-Q02) to global clients list rlm_sql (10.34.21.222): Client "AP-SD1-A05-Q02" (sql) added rlm_sql (sql): Adding client 10.34.21.221 (AP-SD1-A05-Q03) to global clients list rlm_sql (10.34.21.221): Client "AP-SD1-A05-Q03" (sql) added rlm_sql (sql): Adding client 10.34.21.220 (AP-SD1-A05-Q04) to global clients list rlm_sql (10.34.21.220): Client "AP-SD1-A05-Q04" (sql) added rlm_sql (sql): Adding client 10.34.24.223 (AP-SD1-A06-Q01) to global clients list rlm_sql (10.34.24.223): Client "AP-SD1-A06-Q01" (sql) added rlm_sql (sql): Adding client 10.34.24.222 (AP-SD1-A06-Q02) to global clients list rlm_sql (10.34.24.222): Client "AP-SD1-A06-Q02" (sql) added rlm_sql (sql): Adding client 10.34.24.221 (AP-SD1-A06-Q03) to global clients list rlm_sql (10.34.24.221): Client "AP-SD1-A06-Q03" (sql) added rlm_sql (sql): Adding client 10.34.24.220 (AP-SD1-A06-Q04) to global clients list rlm_sql (10.34.24.220): Client "AP-SD1-A06-Q04" (sql) added rlm_sql (sql): Adding client 10.34.27.220 (AP-SD1-A07-Q01) to global clients list rlm_sql (10.34.27.220): Client "AP-SD1-A07-Q01" (sql) added rlm_sql (sql): Adding client 10.34.27.221 (AP-SD1-A07-Q02) to global clients list rlm_sql (10.34.27.221): Client "AP-SD1-A07-Q02" (sql) added rlm_sql (sql): Adding client 10.34.27.222 (AP-SD1-A07-Q03) to global clients list rlm_sql (10.34.27.222): Client "AP-SD1-A07-Q03" (sql) added rlm_sql (sql): Adding client 10.34.27.223 (AP-SD1-A07-Q04) to global clients list rlm_sql (10.34.27.223): Client "AP-SD1-A07-Q04" (sql) added rlm_sql (sql): Adding client 10.34.30.220 (AP-SD1-A08-Q01) to global clients list rlm_sql (10.34.30.220): Client "AP-SD1-A08-Q01" (sql) added rlm_sql (sql): Adding client 10.34.30.221 (AP-SD1-A08-Q02) to global clients list rlm_sql (10.34.30.221): Client "AP-SD1-A08-Q02" (sql) added rlm_sql (sql): Adding client 10.34.30.222 (AP-SD1-A08-Q03) to global clients list rlm_sql (10.34.30.222): Client "AP-SD1-A08-Q03" (sql) added rlm_sql (sql): Adding client 10.34.30.223 (AP-SD1-A08-Q04) to global clients list rlm_sql (10.34.30.223): Client "AP-SD1-A08-Q04" (sql) added rlm_sql (sql): Adding client 10.34.33.221 (AP-SD1-A09-Q01) to global clients list rlm_sql (10.34.33.221): Client "AP-SD1-A09-Q01" (sql) added rlm_sql (sql): Adding client 10.34.33.220 (AP-SD1-A09-Q02) to global clients list rlm_sql (10.34.33.220): Client "AP-SD1-A09-Q02" (sql) added rlm_sql (sql): Adding client 10.34.33.222 (AP-SD1-A09-Q03) to global clients list rlm_sql (10.34.33.222): Client "AP-SD1-A09-Q03" (sql) added rlm_sql (sql): Adding client 10.34.33.223 (AP-SD1-A09-Q04) to global clients list rlm_sql (10.34.33.223): Client "AP-SD1-A09-Q04" (sql) added rlm_sql (sql): Adding client 10.34.7.220 (AP-SD1-MEZ-220) to global clients list rlm_sql (10.34.7.220): Client "AP-SD1-MEZ-220" (sql) added rlm_sql (sql): Adding client 10.34.5.220 (AP-SD1-SUB-Q02) to global clients list rlm_sql (10.34.5.220): Client "AP-SD1-SUB-Q02" (sql) added rlm_sql (sql): Adding client 10.34.5.223 (AP-SD1-SUB-Q03) to global clients list rlm_sql (10.34.5.223): Client "AP-SD1-SUB-Q03" (sql) added rlm_sql (sql): Adding client 10.34.5.222 (AP-SD1-SUB-Q04) to global clients list rlm_sql (10.34.5.222): Client "AP-SD1-SUB-Q04" (sql) added rlm_sql (sql): Adding client 10.34.7.221 (AP-SD1-TER-221) to global clients list rlm_sql (10.34.7.221): Client "AP-SD1-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.7.222 (AP-SD1-TER-222) to global clients list rlm_sql (10.34.7.222): Client "AP-SD1-TER-222" (sql) added rlm_sql (sql): Adding client 10.34.7.223 (AP-SD1-TER-223) to global clients list rlm_sql (10.34.7.223): Client "AP-SD1-TER-223" (sql) added rlm_sql (sql): Adding client 10.34.7.224 (AP-SD1-TER-224) to global clients list rlm_sql (10.34.7.224): Client "AP-SD1-TER-224" (sql) added rlm_sql (sql): Adding client 10.34.40.222 (AP-SD2-A01-Q01) to global clients list rlm_sql (10.34.40.222): Client "AP-SD2-A01-Q01" (sql) added rlm_sql (sql): Adding client 10.34.40.223 (AP-SD2-A01-Q02) to global clients list rlm_sql (10.34.40.223): Client "AP-SD2-A01-Q02" (sql) added rlm_sql (sql): Adding client 10.34.40.221 (AP-SD2-A01-Q03) to global clients list rlm_sql (10.34.40.221): Client "AP-SD2-A01-Q03" (sql) added rlm_sql (sql): Adding client 10.34.40.220 (AP-SD2-A01-Q04) to global clients list rlm_sql (10.34.40.220): Client "AP-SD2-A01-Q04" (sql) added rlm_sql (sql): Adding client 10.34.43.222 (AP-SD2-A02-Q01) to global clients list rlm_sql (10.34.43.222): Client "AP-SD2-A02-Q01" (sql) added rlm_sql (sql): Adding client 10.34.43.223 (AP-SD2-A02-Q02) to global clients list rlm_sql (10.34.43.223): Client "AP-SD2-A02-Q02" (sql) added rlm_sql (sql): Adding client 10.34.43.221 (AP-SD2-A02-Q03) to global clients list rlm_sql (10.34.43.221): Client "AP-SD2-A02-Q03" (sql) added rlm_sql (sql): Adding client 10.34.43.220 (AP-SD2-A02-Q04) to global clients list rlm_sql (10.34.43.220): Client "AP-SD2-A02-Q04" (sql) added rlm_sql (sql): Adding client 10.34.46.222 (AP-SD2-A03-Q01) to global clients list rlm_sql (10.34.46.222): Client "AP-SD2-A03-Q01" (sql) added rlm_sql (sql): Adding client 10.34.46.223 (AP-SD2-A03-Q02) to global clients list rlm_sql (10.34.46.223): Client "AP-SD2-A03-Q02" (sql) added rlm_sql (sql): Adding client 10.34.46.221 (AP-SD2-A03-Q03) to global clients list rlm_sql (10.34.46.221): Client "AP-SD2-A03-Q03" (sql) added rlm_sql (sql): Adding client 10.34.46.220 (AP-SD2-A03-Q04) to global clients list rlm_sql (10.34.46.220): Client "AP-SD2-A03-Q04" (sql) added rlm_sql (sql): Adding client 10.34.49.222 (AP-SD2-A04-Q01) to global clients list rlm_sql (10.34.49.222): Client "AP-SD2-A04-Q01" (sql) added rlm_sql (sql): Adding client 10.34.49.223 (AP-SD2-A04-Q02) to global clients list rlm_sql (10.34.49.223): Client "AP-SD2-A04-Q02" (sql) added rlm_sql (sql): Adding client 10.34.49.221 (AP-SD2-A04-Q03) to global clients list rlm_sql (10.34.49.221): Client "AP-SD2-A04-Q03" (sql) added rlm_sql (sql): Adding client 10.34.49.220 (AP-SD2-A04-Q04) to global clients list rlm_sql (10.34.49.220): Client "AP-SD2-A04-Q04" (sql) added rlm_sql (sql): Adding client 10.34.52.222 (AP-SD2-A05-Q01) to global clients list rlm_sql (10.34.52.222): Client "AP-SD2-A05-Q01" (sql) added rlm_sql (sql): Adding client 10.34.52.223 (AP-SD2-A05-Q02) to global clients list rlm_sql (10.34.52.223): Client "AP-SD2-A05-Q02" (sql) added rlm_sql (sql): Adding client 10.34.52.221 (AP-SD2-A05-Q03) to global clients list rlm_sql (10.34.52.221): Client "AP-SD2-A05-Q03" (sql) added rlm_sql (sql): Adding client 10.34.52.220 (AP-SD2-A05-Q04) to global clients list rlm_sql (10.34.52.220): Client "AP-SD2-A05-Q04" (sql) added rlm_sql (sql): Adding client 10.34.55.222 (AP-SD2-A06-Q01) to global clients list rlm_sql (10.34.55.222): Client "AP-SD2-A06-Q01" (sql) added rlm_sql (sql): Adding client 10.34.55.223 (AP-SD2-A06-Q02) to global clients list rlm_sql (10.34.55.223): Client "AP-SD2-A06-Q02" (sql) added rlm_sql (sql): Adding client 10.34.55.221 (AP-SD2-A06-Q03) to global clients list rlm_sql (10.34.55.221): Client "AP-SD2-A06-Q03" (sql) added rlm_sql (sql): Adding client 10.34.55.220 (AP-SD2-A06-Q04) to global clients list rlm_sql (10.34.55.220): Client "AP-SD2-A06-Q04" (sql) added rlm_sql (sql): Adding client 10.34.58.222 (AP-SD2-A07-Q01) to global clients list rlm_sql (10.34.58.222): Client "AP-SD2-A07-Q01" (sql) added rlm_sql (sql): Adding client 10.34.58.223 (AP-SD2-A07-Q02) to global clients list rlm_sql (10.34.58.223): Client "AP-SD2-A07-Q02" (sql) added rlm_sql (sql): Adding client 10.34.58.221 (AP-SD2-A07-Q03) to global clients list rlm_sql (10.34.58.221): Client "AP-SD2-A07-Q03" (sql) added rlm_sql (sql): Adding client 10.34.58.220 (AP-SD2-A07-Q04) to global clients list rlm_sql (10.34.58.220): Client "AP-SD2-A07-Q04" (sql) added rlm_sql (sql): Adding client 10.34.61.222 (AP-SD2-A08-Q01) to global clients list rlm_sql (10.34.61.222): Client "AP-SD2-A08-Q01" (sql) added rlm_sql (sql): Adding client 10.34.61.223 (AP-SD2-A08-Q02) to global clients list rlm_sql (10.34.61.223): Client "AP-SD2-A08-Q02" (sql) added rlm_sql (sql): Adding client 10.34.61.221 (AP-SD2-A08-Q03) to global clients list rlm_sql (10.34.61.221): Client "AP-SD2-A08-Q03" (sql) added rlm_sql (sql): Adding client 10.34.61.220 (AP-SD2-A08-Q04) to global clients list rlm_sql (10.34.61.220): Client "AP-SD2-A08-Q04" (sql) added rlm_sql (sql): Adding client 10.34.64.222 (AP-SD2-A09-Q01) to global clients list rlm_sql (10.34.64.222): Client "AP-SD2-A09-Q01" (sql) added rlm_sql (sql): Adding client 10.34.64.223 (AP-SD2-A09-Q02) to global clients list rlm_sql (10.34.64.223): Client "AP-SD2-A09-Q02" (sql) added rlm_sql (sql): Adding client 10.34.64.221 (AP-SD2-A09-Q03) to global clients list rlm_sql (10.34.64.221): Client "AP-SD2-A09-Q03" (sql) added rlm_sql (sql): Adding client 10.34.64.220 (AP-SD2-A09-Q04) to global clients list rlm_sql (10.34.64.220): Client "AP-SD2-A09-Q04" (sql) added rlm_sql (sql): Adding client 10.34.38.221 (AP-SD2-MEZ-Q01) to global clients list rlm_sql (10.34.38.221): Client "AP-SD2-MEZ-Q01" (sql) added rlm_sql (sql): Adding client 10.34.38.220 (AP-SD2-MEZ-Q04) to global clients list rlm_sql (10.34.38.220): Client "AP-SD2-MEZ-Q04" (sql) added rlm_sql (sql): Adding client 10.34.36.219 (AP-SD2-S02-Q01) to global clients list rlm_sql (10.34.36.219): Client "AP-SD2-S02-Q01" (sql) added rlm_sql (sql): Adding client 10.34.36.220 (AP-SD2-SUB-220) to global clients list rlm_sql (10.34.36.220): Client "AP-SD2-SUB-220" (sql) added rlm_sql (sql): Adding client 10.34.36.222 (AP-SD2-TER-Q02) to global clients list rlm_sql (10.34.36.222): Client "AP-SD2-TER-Q02" (sql) added rlm_sql (sql): Adding client 10.34.36.221 (AP-SD2-TER-Q03) to global clients list rlm_sql (10.34.36.221): Client "AP-SD2-TER-Q03" (sql) added rlm_sql (sql): Adding client 10.34.36.224 (AP-SD2-TER-Q04) to global clients list rlm_sql (10.34.36.224): Client "AP-SD2-TER-Q04" (sql) added rlm_sql (sql): Adding client 10.34.147.219 (AP-SEB-A01-219) to global clients list rlm_sql (10.34.147.219): Client "AP-SEB-A01-219" (sql) added rlm_sql (sql): Adding client 10.34.147.222 (AP-SEB-A01-222) to global clients list rlm_sql (10.34.147.222): Client "AP-SEB-A01-222" (sql) added rlm_sql (sql): Adding client 10.34.147.224 (AP-SEB-A01-224) to global clients list rlm_sql (10.34.147.224): Client "AP-SEB-A01-224" (sql) added rlm_sql (sql): Adding client 10.34.147.225 (AP-SEB-A01-225) to global clients list rlm_sql (10.34.147.225): Client "AP-SEB-A01-225" (sql) added rlm_sql (sql): Adding client 10.34.147.223 (AP-SEB-SUB-223) to global clients list rlm_sql (10.34.147.223): Client "AP-SEB-SUB-223" (sql) added rlm_sql (sql): Adding client 10.34.147.227 (AP-SEB-SUB-227) to global clients list rlm_sql (10.34.147.227): Client "AP-SEB-SUB-227" (sql) added rlm_sql (sql): Adding client 10.34.147.218 (AP-SEB-TER-218) to global clients list rlm_sql (10.34.147.218): Client "AP-SEB-TER-218" (sql) added rlm_sql (sql): Adding client 10.34.147.220 (AP-SEB-TER-220) to global clients list rlm_sql (10.34.147.220): Client "AP-SEB-TER-220" (sql) added rlm_sql (sql): Adding client 10.34.147.221 (AP-SEB-TER-221) to global clients list rlm_sql (10.34.147.221): Client "AP-SEB-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.147.226 (AP-SEB-TER-226) to global clients list rlm_sql (10.34.147.226): Client "AP-SEB-TER-226" (sql) added rlm_sql (sql): Adding client 10.34.152.219 (AP-SOB-A02-219) to global clients list rlm_sql (10.34.152.219): Client "AP-SOB-A02-219" (sql) added rlm_sql (sql): Adding client 10.34.152.221 (AP-SOB-TER-221) to global clients list rlm_sql (10.34.152.221): Client "AP-SOB-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.142.220 (AP-STA-A01-220) to global clients list rlm_sql (10.34.142.220): Client "AP-STA-A01-220" (sql) added rlm_sql (sql): Adding client 10.34.142.223 (AP-STA-A01-223) to global clients list rlm_sql (10.34.142.223): Client "AP-STA-A01-223" (sql) added rlm_sql (sql): Adding client 10.34.142.222 (AP-STA-SUB-222) to global clients list rlm_sql (10.34.142.222): Client "AP-STA-SUB-222" (sql) added rlm_sql (sql): Adding client 10.34.142.221 (AP-STA-TER-221) to global clients list rlm_sql (10.34.142.221): Client "AP-STA-TER-221" (sql) added rlm_sql (sql): Adding client 10.34.157.220 (AP-TAG-A01-220) to global clients list rlm_sql (10.34.157.220): Client "AP-TAG-A01-220" (sql) added rlm_sql (sql): Adding client 10.34.157.221 (AP-TAG-A01-221) to global clients list rlm_sql (10.34.157.221): Client "AP-TAG-A01-221" (sql) added rlm_sql (sql): Adding client 10.34.157.224 (AP-TAG-SUB-224) to global clients list rlm_sql (10.34.157.224): Client "AP-TAG-SUB-224" (sql) added rlm_sql (sql): Adding client 10.34.157.223 (AP-TAG-TER-223) to global clients list rlm_sql (10.34.157.223): Client "AP-TAG-TER-223" (sql) added rlm_sql (sql): Adding client 10.34.182.220 (AP-TJ-GUA-220) to global clients list rlm_sql (10.34.182.220): Client "AP-TJ-GUA-220" (sql) added rlm_sql (sql): Adding client 10.34.157.222 (AP-TAG-TER-222) to global clients list rlm_sql (10.34.157.222): Client "AP-TAG-TER-222" (sql) added rlm_sql (sql): Adding client 10.34.240.20 (nagios) to global clients list rlm_sql (10.34.240.20): Client "nagios" (sql) added rlm_sql (sql): Adding client 10.34.241.56 (nagios2) to global clients list rlm_sql (10.34.241.56): Client "nagios2" (sql) added rlm_sql (sql): Adding client 10.34.173.10 (nagiosCont) to global clients list rlm_sql (10.34.173.10): Client "nagiosCont" (sql) added rlm_sql (sql): Adding client 10.34.5.221 (AP-SD1-SUB-Q01) to global clients list rlm_sql (10.34.5.221): Client "AP-SD1-SUB-Q01" (sql) added rlm_sql (sql): Adding client 10.35.93.220 (AP-BR2-S01-220) to global clients list rlm_sql (10.35.93.220): Client "AP-BR2-S01-220" (sql) added rlm_sql (sql): Adding client 10.34.152.220 (AP-SOB-A01-220) to global clients list rlm_sql (10.34.152.220): Client "AP-SOB-A01-220" (sql) added rlm_sql (sql): Adding client 10.35.36.201 (AP-SD2-S02-201) to global clients list rlm_sql (10.35.36.201): Client "AP-SD2-S02-201" (sql) added rlm_sql (sql): Adding client 10.34.97.219 (AP-GAM-S01-219) to global clients list rlm_sql (10.34.97.219): Client "AP-GAM-S01-219" (sql) added rlm_sql (sql): Adding client 10.34.97.224 (AP-GAM-TER-224) to global clients list rlm_sql (10.34.97.224): Client "AP-GAM-TER-224" (sql) added rlm_sql (sql): Adding client 10.34.36.223 (AP-SD2-S01-Q01) to global clients list rlm_sql (10.34.36.223): Client "AP-SD2-S01-Q01" (sql) added rlm_sql (sql): Released connection (0) rlm_sql (sql): Need 5 more connections to reach 10 spares rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used rlm_sql_postgresql: Connecting using parameters: dbname='radius' host='localhost' port=5432 user='radius' password='senhadoradius' Connected to database 'radius' on 'localhost' server version 90617, protocol version 3, backend PID 13113 # Instantiating module "reject" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "fail" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "ok" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "handled" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "invalid" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "userlock" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "notfound" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "noop" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "updated" from file /etc/freeradius/3.0/mods-enabled/always # Instantiating module "cache_eap" from file /etc/freeradius/3.0/mods-enabled/cache_eap rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked # Instantiating module "mschap" from file /etc/freeradius/3.0/mods-enabled/mschap rlm_mschap (mschap): Initialising connection pool pool { start = 5 min = 3 max = 32 spare = 10 uses = 0 lifetime = 86400 cleanup_interval = 300 idle_timeout = 600 retry_delay = 30 spread = no } rlm_mschap (mschap): Opening additional connection (0), 1 of 32 pending slots used rlm_mschap (mschap): Opening additional connection (1), 1 of 31 pending slots used rlm_mschap (mschap): Opening additional connection (2), 1 of 30 pending slots used rlm_mschap (mschap): Opening additional connection (3), 1 of 29 pending slots used rlm_mschap (mschap): Opening additional connection (4), 1 of 28 pending slots used rlm_mschap (mschap): authenticating directly to winbind # Instantiating module "files" from file /etc/freeradius/3.0/mods-enabled/files reading pairlist file /etc/freeradius/3.0/mods-config/files/authorize reading pairlist file /etc/freeradius/3.0/mods-config/files/accounting reading pairlist file /etc/freeradius/3.0/mods-config/files/pre-proxy # Instantiating module "detail" from file /etc/freeradius/3.0/mods-enabled/detail rlm_detail (detail): 'User-Password' suppressed, will not appear in detail output } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/3.0/radiusd.conf } # server server default { # from file /etc/freeradius/3.0/sites-enabled/default # Loading authenticate {...} # Loading authorize {...} Ignoring "ldap" (see raddb/mods-available/README.rst) # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server default server inner-tunnel { # from file /etc/freeradius/3.0/sites-enabled/inner-tunnel # Loading authenticate {...} # Loading authorize {...} # Loading session {...} # Loading pre-proxy {...} # Loading post-proxy {...} # Loading post-auth {...} } # server inner-tunnel server status { # from file /etc/freeradius/3.0/sites-enabled/status # Loading authorize {...} } # server status radiusd: #### Opening IP addresses and Ports #### listen { type = "control" listen { socket = "/var/run/freeradius/freeradius.sock" mode = "rw" peercred = yes } } 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 = "auth" ipaddr = 127.0.0.1 port = 18120 } listen { type = "status" ipaddr = 127.0.0.1 port = 18121 client admin { ipaddr = 127.0.0.1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } } Listening on command file /var/run/freeradius/freeradius.sock 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 auth address 127.0.0.1 port 18120 bound to server inner-tunnel Listening on status address 127.0.0.1 port 18121 bound to server status Listening on proxy address * port 54845 Listening on proxy address :: port 40154 Ready to process requests

3 7