- Freeradius-Users - lists.freeradius.org

Centos 7 package
by Luc Paulin 18 May '17

18 May '17

Look like the latest release avaialble in centos7 packages is 3.0.4, this build doesn't seem to have the fixes for windows10 TLS issues. Anyone know where latest package can be downloaded for centos7 ? I have try find a repo for centos7/freeradius but unfortunately look like there none. I would prefer to avoid doing a source installation -Luc -- !!!!! ( o o ) --------------oOO----(_)----OOo-------------- Luc Paulin email: paulinster(at)gmail.com Skype: paulinster

3 3

Defining multiple post-auth INSERT queries for the same table
by Stefan Paetow 18 May '17

18 May '17

So, here is the scenario: We've been asked to provide CUI-style backing for the Moonshot-*-TargetedId functionality in FreeRADIUS. Since this originates from us, I thought it might be more useful to simply use *one* column for the pre-requisite GSS-Acceptor-* and the Trust-Router-COI attributes (i.e. mix and mingle). But now, for the life of me, I can't remember for the life of me how to define multiple queries in one sql instance. Do I simply name them (i.e. name_of_query = 'query here...') and then just invoke them in their appropriate section? Or, since many here use databases, would you prefer using a table that includes a column for the appropriate attribute (even if it's not used for the retrieval)? That seems like an awful waste of space and data to me... :-/ Thoughts (on the approach) and the aide memoire are very much appreciated. :-) With Regards Stefan Paetow Moonshot Industry & Research Liaison Coordinator t: +44 (0)1235 822 125 gpg: 0x3FCE5142 xmpp: stefanp(a)jabber.dev.ja.net skype: stefan.paetow.janet jisc.ac.uk Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.

3 8

Supplicant Authentication in raidus.
by Arun Maha 17 May '17

17 May '17

Hi, I installed freeRadius and configured EAP-peap. I used hostapd as NAS. When supplicant connects to nas. It asks for username and password. On filling those there is a serious communication between radius and nas. Finally radius sends accept packet to nas. But my supplicant is not able to connect to the network. It keeps sending connection request. How to connect my device to nas after a single authentication. Thanks.

2 1

linelog best practice
by cedric delaunay 17 May '17

17 May '17

Hello all, I'm trying to log accounting and requests into our elasticsearch/graylog logserver. I use home made linelog modules to rewrite logs into json format. modules are called in authorize, accounting, post-auth, Post-Auth-Type REJECT, preproxy and post-proxy sections here is an exemple of my module : linelog linelog_postauth { format = "%t linelog_postauth \%Packet-Type non reconnu for %{User-Name} (%{Packet-Type})" filename = ${logdir}/linelog_json permissions = 0600 reference = "messages.%{%{reply:Packet-Type}:-format}" messages { Access-Reject = "{\"Datetime\":\"%t\",\"Module_Name\":\"linelog_postauth\",\"Packet-Type\":\"%{reply:Packet-Type}\",\"User-Name\":\"%{User-Name}\",\"Realm\":\"%{Realm}\",\"NAS-IP-Address\":\"%{NAS-IP-Address}\",\"NAS-Port\":\"%{NAS-Port}\",\"Service-Type\":\"%{Service-Type}\",\"Framed-MTU\":\"%{Framed-MTU}\",\"State\":\"%{State}\",\"Class\":\"%{Class}\",\"Vendor-Specific\":\"%{Vendor-Specific}\",\"Session-Timeout\":\"%{Session-Timeout}\",\"Idle-Timeout\":\"%{Idle-Timeout}\",\"Termination-Action\":\"%{Termination-Action}\",\"Called-Station-Id\":\"%{Called-Station-Id}\",\"Calling-Station-Id\":\"%{Calling-Station-Id}\",\"NAS-Identifier\":\"%{NAS-Identifier}\",\"Proxy-State\":\"%{Proxy-State}\",\"Login-LAT-Service\":\"%{Login-LAT-Service}\",\"Login-LAT-Node\":\"%{Login-LAT-Node}\",\"Login-LAT-Group\":\"%{Login-LAT-Group}\",\"Framed-AppleTalk-Link\":\"%{Framed-AppleTalk-Link}\",\"Framed-AppleTalk-Network\":\"%{Framed-AppleTalk-Network}\",\"Framed-AppleTalk-Zone\":\"%{Framed-AppleTalk-Zone}\",\"CHAP-Challenge\":\"%{CHAP-Challenge}\",\"NAS-Port-Type\":\"%{NAS-Port-Type}\",\"Port-Limit\":\"%{Port-Limit}\",\"Login-LAT-Port\":\"%{Login-LAT-Port}\"}" Access-Challenge = "{\"Datetime\":\"%t\",\"Module_Name\":\"linelog_postauth\",\"Packet-Type\":\"%{reply:Packet-Type}\",\"User-Name\":\"%{User-Name}\",\"Realm\":\"%{Realm}\",\"NAS-IP-Address\":\"%{NAS-IP-Address}\",\"NAS-Port\":\"%{NAS-Port}\",\"Service-Type\":\"%{Service-Type}\",\"Framed-Protocol\":\"%{Framed-Protocol}\",\"Framed-IP-Address\":\"%{Framed-IP-Address}\",\"Framed-IP-Netmask\":\"%{Framed-IP-Netmask}\",\"Framed-Routing\":\"%{Framed-Routing}\",\"Filter-Id\":\"%{Filter-Id}\",\"Framed-MTU\":\"%{Framed-MTU}\",\"Framed-Compression\":\"%{Framed-Compression}\",\"Login-IP-Host\":\"%{Login-IP-Host}\",\"Login-Service\":\"%{Login-Service}\",\"Login-TCP-Port\":\"%{Login-TCP-Port}\",\"Reply-Message\":\"%{Reply-Message}\",\"Callback-Number\":\"%{Callback-Number}\",\"Callback-Id\":\"%{Callback-Id}\",\"Framed-Route\":\"%{Framed-Route}\",\"Framed-IPX-Network\":\"%{Framed-IPX-Network}\",\"State\":\"%{State}\",\"Class\":\"%{Class}\",\"Vendor-Specific\":\"%{Vendor-Specific}\",\"Session-Timeout\":\"%{Session-Timeout}\",\"Idle-Timeout\":\"%{Idle-Timeout}\",\"Termination-Action\":\"%{Termination-Action}\",\"Called-Station-Id\":\"%{Called-Station-Id}\",\"Calling-Station-Id\":\"%{Calling-Station-Id}\",\"NAS-Identifier\":\"%{NAS-Identifier}\",\"Proxy-State\":\"%{Proxy-State}\",\"Login-LAT-Service\":\"%{Login-LAT-Service}\",\"Login-LAT-Node\":\"%{Login-LAT-Node}\",\"Login-LAT-Group\":\"%{Login-LAT-Group}\",\"Framed-AppleTalk-Link\":\"%{Framed-AppleTalk-Link}\",\"Framed-AppleTalk-Network\":\"%{Framed-AppleTalk-Network}\",\"Framed-AppleTalk-Zone\":\"%{Framed-AppleTalk-Zone}\",\"CHAP-Challenge\":\"%{CHAP-Challenge}\",\"NAS-Port-Type\":\"%{NAS-Port-Type}\",\"Port-Limit\":\"%{Port-Limit}\",\"Login-LAT-Port\":\"%{Login-LAT-Port}\"}" Access-Accept = "{\"Datetime\":\"%t\",\"Module_Name\":\"linelog_postauth\",\"Packet-Type\":\"%{reply:Packet-Type}\",\"User-Name\":\"%{User-Name}\",\"Realm\":\"%{Realm}\",\"NAS-IP-Address\":\"%{NAS-IP-Address}\",\"NAS-Port\":\"%{NAS-Port}\",\"Service-Type\":\"%{Service-Type}\",\"Framed-MTU\":\"%{Framed-MTU}\",\"Login-IP-Host\":\"%{Login-IP-Host}\",\"Login-Service\":\"%{Login-Service}\",\"Login-TCP-Port\":\"%{Login-TCP-Port}\",\"Reply-Message\":\"%{Reply-Message}\",\"Callback-Number\":\"%{Callback-Number}\",\"Callback-Id\":\"%{Callback-Id}\",\"Framed-Route\":\"%{Framed-Route}\",\"Framed-IPX-Network\":\"%{Framed-IPX-Network}\",\"State\":\"%{State}\",\"Class\":\"%{Class}\",\"Vendor-Specific\":\"%{Vendor-Specific}\",\"Session-Timeout\":\"%{Session-Timeout}\",\"Idle-Timeout\":\"%{Idle-Timeout}\",\"Termination-Action\":\"%{Termination-Action}\",\"Called-Station-Id\":\"%{Called-Station-Id}\",\"Calling-Station-Id\":\"%{Calling-Station-Id}\",\"NAS-Identifier\":\"%{NAS-Identifier}\",\"Proxy-State\":\"%{Proxy-State}\",\"Login-LAT-Service\":\"%{Login-LAT-Service}\",\"Login-LAT-Node\":\"%{Login-LAT-Node}\",\"Login-LAT-Group\":\"%{Login-LAT-Group}\",\"Framed-AppleTalk-Link\":\"%{Framed-AppleTalk-Link}\",\"Framed-AppleTalk-Network\":\"%{Framed-AppleTalk-Network}\",\"Framed-AppleTalk-Zone\":\"%{Framed-AppleTalk-Zone}\",\"CHAP-Challenge\":\"%{CHAP-Challenge}\",\"NAS-Port-Type\":\"%{NAS-Port-Type}\",\"Port-Limit\":\"%{Port-Limit}\",\"Login-LAT-Port\":\"%{Login-LAT-Port}\",\"VLAN\":\"%{Tunnel-Private-Group-ID:0}\"}" } } the goal is to keep info about login attempts and failure and why. when we run radius in debug mode we can see failure reason as next example : ..... (17) authenticate { (17) eap : Expiring EAP session with state 0x2ee654852ee14efb (17) eap : Finished EAP session with state 0x2ee654852ee14efb (17) eap : Previous EAP request found for state 0x2ee654852ee14efb, released from the list (17) eap : Peer sent method MSCHAPv2 (26) (17) eap : EAP MSCHAPv2 (26) (17) eap : Calling eap_mschapv2 to process EAP data (17) eap_mschapv2 : # Executing group from file /etc/raddb//sites-enabled/eduroam-inner-tunnel (17) eap_mschapv2 : Auth-Type MS-CHAP { (17) mschap : Found LM-Password (17) WARNING: mschap : No Cleartext-Password configured. Cannot create LM-Password (17) mschap : Found NT-Password (17) WARNING: mschap : No Cleartext-Password configured. Cannot create NT-Password (17) mschap : Creating challenge hash with username: cdelauna(a)univ-rennes1.fr (17) mschap : Client is using MS-CHAPv2 (17) ERROR: mschap : MS-CHAP2-Response is incorrect (17) [mschap] = reject (17) } # Auth-Type MS-CHAP = reject (17) eap : Freeing handler (17) [eap] = reject (17) } # authenticate = reject ..... I can't find reject reason (mscahp result, ...) in access-reject variables. I had a look into mailist's archives without success ;( Do anybody can help me to find the best way doing this ? Thanks a lot -- Cédric Delaunay Direction des Systèmes d'Informations Equipe Réseau & Telephonie 263, Avenue du Général Leclerc Tel: 02 23 23 71 59 CS 74205 - 35042 Rennes Cedex Pour toute demande utiliser l'aide et assistance via l'ENT à l'adresse http://ent.univ-rennes1.fr

7 19

Help with non-compliant client (TLS issue)
by Geoffrey McRae 17 May '17

17 May '17

Hi, I am trying to use an ESP8266 to connect to a network using freeradius, I have confirmed that the fault is not due to freeradius but since the code in the SDK for the device is closed, I am limited in what I can do to resolve the problem. The server is configured and is working fine with EAP-PEAP using MSCHAPv2 auth, which the device is supposed to support. Other devices and eapol_test confirm that the radius server is setup correctly. When the device attempts to authenticate the following in the freeradius debug output is observed. [eap] Request found, released from the list [eap] EAP/peap [eap] processing type peap [peap] processing EAP-TLS TLS Length 7 [peap] Length Included [peap] eaptls_verify returned 11 [peap] <<< TLS 1.0 Alert [length 0002], fatal bad_certificate TLS Alert read:fatal:bad certificate TLS_accept: failed in unknown state rlm_eap: SSL error error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate SSL: SSL_read failed inside of TLS (-1), TLS session fails. My assumption is that the device is erroneously trying to tell the server that it is providing a client certificate, which it obviously is not, but I do not know enough about TLS to verify this and would love some feedback if anyone is a guru in this area. Even if I provide a client certificate the above error still occurs, clearly the fault is in the binary blob that Espressif provides. -- Kind Regards, Geoffrey McRae HostFission Server Management & Monitoring W: https://hostfission.com P: +61 2 9037 0321

2 4

Authentication Issue in FR 3.0.12
by mustafa mujahid 16 May '17

16 May '17

hi, I'm working with freeradius 3.0.12 and I'm having a peculiar issue. The server is stuck on the first iteration of debug output and does not move forward. Normally after receiving an access-request it should call the sql module but that doesn't happen and it just stops. The configuration is exactly the same as a working freeradius 3.0.12 server im running in my environment. I'm unable to pin point what the issue might be. Please see the Complete debug [root@Office-Auth-Pri certs]# /usr/local/radius/sbin/radiusd -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/local/radius/share/freeradius/dictionary including dictionary file /usr/local/radius/share/freeradius/dictionary.dhcp including dictionary file /usr/local/radius/share/freeradius/dictionary.vqp including dictionary file /etc/raddb/dictionary including configuration file /etc/raddb/radiusd.conf including configuration file /etc/raddb/proxy.conf including configuration file /etc/raddb/clients.conf including files in directory /etc/raddb/mods-enabled/ including configuration file /etc/raddb/mods-enabled/attr_filter including configuration file /etc/raddb/mods-enabled/echo including configuration file /etc/raddb/mods-enabled/linelog including configuration file /etc/raddb/mods-enabled/mschap including configuration file /etc/raddb/mods-enabled/unix including configuration file /etc/raddb/mods-enabled/chap including configuration file /etc/raddb/mods-enabled/utf8 including configuration file /etc/raddb/mods-enabled/dhcp including configuration file /etc/raddb/mods-enabled/detail including configuration file /etc/raddb/mods-enabled/sradutmp including configuration file /etc/raddb/mods-enabled/always including configuration file /etc/raddb/mods-enabled/replicate including configuration file /etc/raddb/mods-enabled/preprocess including configuration file /etc/raddb/mods-enabled/expiration including configuration file /etc/raddb/mods-enabled/files including configuration file /etc/raddb/mods-enabled/eap including configuration file /etc/raddb/mods-enabled/realm including configuration file /etc/raddb/mods-enabled/detail.log including configuration file /etc/raddb/mods-enabled/expr including configuration file /etc/raddb/mods-enabled/passwd including configuration file /etc/raddb/mods-enabled/digest including configuration file /etc/raddb/mods-enabled/unpack including configuration file /etc/raddb/mods-enabled/ntlm_auth including configuration file /etc/raddb/mods-enabled/pap including configuration file /etc/raddb/mods-enabled/dynamic_clients including configuration file /etc/raddb/mods-enabled/radutmp including configuration file /etc/raddb/mods-enabled/exec including configuration file /etc/raddb/mods-enabled/cache_eap including configuration file /etc/raddb/mods-enabled/soh including configuration file /etc/raddb/mods-enabled/logintime including configuration file /etc/raddb/mods-enabled/date including configuration file /etc/raddb/mods-enabled/oracle including files in directory /etc/raddb/policy.d/ including configuration file /etc/raddb/policy.d/operator-name including configuration file /etc/raddb/policy.d/canonicalization including configuration file /etc/raddb/policy.d/moonshot-targeted-ids including configuration file /etc/raddb/policy.d/dhcp including configuration file /etc/raddb/policy.d/abfab-tr including configuration file /etc/raddb/policy.d/debug including configuration file /etc/raddb/policy.d/control including configuration file /etc/raddb/policy.d/eap including configuration file /etc/raddb/policy.d/accounting including configuration file /etc/raddb/policy.d/filter including configuration file /etc/raddb/policy.d/cui including files in directory /etc/raddb/sites-enabled/ including configuration file /etc/raddb/sites-enabled/cisco_lan-tunnel including configuration file /etc/raddb/sites-enabled/inner-tunnel including configuration file /etc/raddb/sites-enabled/default including configuration file /etc/raddb/sites-enabled/wlc_huawei including configuration file /etc/raddb/sites-enabled/cisco_lan including configuration file /etc/raddb/sites-enabled/control-socket including configuration file /etc/raddb/sites-enabled/wlc_huawei-tunnel main { security { allow_core_dumps = no } name = "radiusd" prefix = "/usr/local/radius" localstatedir = "/var/log/radius" logdir = "/var/log/radius/log/radius" run_dir = "/var/log/radius/run/radiusd" } main { name = "radiusd" prefix = "/usr/local/radius" localstatedir = "/var/log/radius" sbindir = "/usr/local/radius/sbin" logdir = "/var/log/radius/log/radius" run_dir = "/var/log/radius/run/radiusd" libdir = "/usr/local/radius/lib" radacctdir = "/var/log/radius/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 16384 pidfile = "/var/log/radius/run/radiusd/radiusd.pid" checkrad = "/usr/local/radius/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 allow_vulnerable_openssl = "CVE-2016-6304" } } 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 >>> src_ipaddr = "58.65.165.3" 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 = 50 lifetime = 0 idle_timeout = 30 } } client localhost_ipv6 { ipv6addr = ::1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Debugger not attached # Creating Auth-Type = mschap # Creating Auth-Type = eap_cisco_lan # Creating Auth-Type = PAP # Creating Auth-Type = MS-CHAP # Creating Auth-Type = eap # Creating Auth-Type = digest # Creating Auth-Type = CHAP # Creating Auth-Type = eap_wlc_huawei radiusd: #### Instantiating modules #### modules { # Loaded module rlm_attr_filter # Loading module "attr_filter.post-proxy" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/raddb/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.pre-proxy" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/raddb/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.access_reject" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/raddb/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.access_challenge" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/raddb/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.accounting_response" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/raddb/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } # Loaded module rlm_exec # Loading module "echo" from file /etc/raddb/mods-enabled/echo exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = yes } # Loaded module rlm_linelog # Loading module "linelog" from file /etc/raddb/mods-enabled/linelog linelog { filename = "/var/log/radius/log/radius/linelog" escape_filenames = no syslog_severity = "info" permissions = 384 format = "This is a log message for %{User-Name}" reference = "messages.%{%{reply:Packet-Type}:-default}" } # Loading module "log_accounting" from file /etc/raddb/mods-enabled/linelog linelog log_accounting { filename = "/var/log/radius/log/radius/linelog-accounting" escape_filenames = no syslog_severity = "info" permissions = 384 format = "" reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}" } # Loaded module rlm_mschap # Loading module "mschap" from file /etc/raddb/mods-enabled/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = yes passchange { } allow_retry = yes } # Loaded module rlm_unix # Loading module "unix" from file /etc/raddb/mods-enabled/unix unix { radwtmp = "/var/log/radius/log/radius/radwtmp" } Creating attribute Unix-Group # Loaded module rlm_chap # Loading module "chap" from file /etc/raddb/mods-enabled/chap # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/raddb/mods-enabled/utf8 # Loaded module rlm_dhcp # Loading module "dhcp" from file /etc/raddb/mods-enabled/dhcp # Loaded module rlm_detail # Loading module "detail" from file /etc/raddb/mods-enabled/detail detail { filename = "/var/log/radius/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_radutmp # Loading module "sradutmp" from file /etc/raddb/mods-enabled/sradutmp radutmp sradutmp { filename = "/var/log/radius/log/radius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loaded module rlm_always # Loading module "reject" from file /etc/raddb/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/raddb/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/raddb/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/raddb/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/raddb/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/raddb/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/raddb/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/raddb/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/raddb/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Loaded module rlm_replicate # Loading module "replicate" from file /etc/raddb/mods-enabled/replicate # Loaded module rlm_preprocess # Loading module "preprocess" from file /etc/raddb/mods-enabled/preprocess preprocess { huntgroups = "/etc/raddb/mods-config/preprocess/huntgroups" hints = "/etc/raddb/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/raddb/mods-enabled/expiration # Loaded module rlm_files # Loading module "files" from file /etc/raddb/mods-enabled/files files { filename = "/etc/raddb/mods-config/files/authorize" acctusersfile = "/etc/raddb/mods-config/files/accounting" preproxy_usersfile = "/etc/raddb/mods-config/files/pre-proxy" } # Loaded module rlm_eap # Loading module "eap" from file /etc/raddb/mods-enabled/eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loading module "eap_cisco_lan" from file /etc/raddb/mods-enabled/eap eap eap_cisco_lan { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loading module "eap_wlc_huawei" from file /etc/raddb/mods-enabled/eap eap eap_wlc_huawei { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loaded module rlm_realm # Loading module "IPASS" from file /etc/raddb/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/raddb/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/raddb/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/raddb/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loading module "auth_log" from file /etc/raddb/mods-enabled/detail.log detail auth_log { filename = "/var/log/radius/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "reply_log" from file /etc/raddb/mods-enabled/detail.log detail reply_log { filename = "/var/log/radius/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/reply-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "pre_proxy_log" from file /etc/raddb/mods-enabled/detail.log detail pre_proxy_log { filename = "/var/log/radius/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/pre-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "post_proxy_log" from file /etc/raddb/mods-enabled/detail.log detail post_proxy_log { filename = "/var/log/radius/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/post-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_expr # Loading module "expr" from file /etc/raddb/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_passwd # Loading module "etc_passwd" from file /etc/raddb/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_digest # Loading module "digest" from file /etc/raddb/mods-enabled/digest # Loaded module rlm_unpack # Loading module "unpack" from file /etc/raddb/mods-enabled/unpack # Loading module "ntlm_auth" from file /etc/raddb/mods-enabled/ntlm_auth exec ntlm_auth { wait = yes program = "/path/to/ntlm_auth --request-nt-key --domain=MYDOMAIN --username=%{mschap:User-Name} --password=%{User-Password}" shell_escape = yes } # Loaded module rlm_pap # Loading module "pap" from file /etc/raddb/mods-enabled/pap pap { normalise = yes } # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/raddb/mods-enabled/dynamic_clients # Loading module "radutmp" from file /etc/raddb/mods-enabled/radutmp radutmp { filename = "/var/log/radius/log/radius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 384 caller_id = yes } # Loading module "exec" from file /etc/raddb/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_cache # Loading module "cache_eap" from file /etc/raddb/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_soh # Loading module "soh" from file /etc/raddb/mods-enabled/soh soh { dhcp = yes } # Loaded module rlm_logintime # Loading module "logintime" from file /etc/raddb/mods-enabled/logintime logintime { minimum_timeout = 60 } # Loaded module rlm_date # Loading module "date" from file /etc/raddb/mods-enabled/date date { format = "%b %e %Y %H:%M:%S %Z" } # Loaded module rlm_sql # Loading module "sql" from file /etc/raddb/mods-enabled/oracle sql { driver = "rlm_sql_oracle" server = "ip" port = 0 login = "central" password = <<< secret >>> radius_db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ntlbill)(SERVER=DEDICATED)))" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = no sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM radcheck_office WHERE Username = '%{SQL-User-Name}' and attribute = 'NT-Password' ORDER BY id" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" accounting { Accounting queries } post-auth { reference = ".query" } } rlm_sql (sql): Driver rlm_sql_oracle (module rlm_sql_oracle) loaded and linked # Loading module "sql_cisco_lan" from file /etc/raddb/mods-enabled/oracle sql sql_cisco_lan { driver = "rlm_sql_oracle" server = "IP" port = 0 login = "login1" password = <<< secret >>> radius_db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip )(PORT = 1521)))(CONNECT_DATA = (SID = ntlbill)(SERVER=DEDICATED)))" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = no sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM radcheck_office WHERE Username = '%{SQL-User-Name}' and lan = 'y' and Attribute = 'NT-Password' and macaddress = '%{Calling-Station-Id}' ORDER BY id" simul_count_query = "SELECT COUNT(*) FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime IS NULL AND AcctStartTime >=sysdate-1" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" accounting { Accouting queries } post-auth { reference = ".query" } } rlm_sql (sql_cisco_lan): Driver rlm_sql_oracle (module rlm_sql_oracle) loaded and linked # Loading module "sql_wlc_huawei" from file /etc/raddb/mods-enabled/oracle sql sql_wlc_huawei { driver = "rlm_sql_oracle" server = "ip" port = 1521 login = "ntlradius" password = <<< secret >>> radius_db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)))(CONNECT_DATA = (SID = ntlbill )(SERVER=DEDICATED)))" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM radcheck_office WHERE Username = '%{SQL-User-Name}' and wlan = 'y' and Attribute = 'NT-Password' and macaddress = '%{Calling-Station-Id}' ORDER BY id" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" accounting { reference = ".query" type { accounting-on { } accounting-off { } start { } interim-update { } stop { } } } post-auth { reference = ".query" } } rlm_sql (sql_wlc_huawei): Driver rlm_sql_oracle (module rlm_sql_oracle) loaded and linked instantiate { } # Instantiating module "attr_filter.post-proxy" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/post-proxy # Instantiating module "attr_filter.pre-proxy" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/pre-proxy # Instantiating module "attr_filter.access_reject" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/access_reject # Instantiating module "attr_filter.access_challenge" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/access_challenge # Instantiating module "attr_filter.accounting_response" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/accounting_response # Instantiating module "linelog" from file /etc/raddb/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/raddb/mods-enabled/linelog # Instantiating module "mschap" from file /etc/raddb/mods-enabled/mschap rlm_mschap (mschap): using internal authentication # Instantiating module "detail" from file /etc/raddb/mods-enabled/detail # Instantiating module "reject" from file /etc/raddb/mods-enabled/always # Instantiating module "fail" from file /etc/raddb/mods-enabled/always # Instantiating module "ok" from file /etc/raddb/mods-enabled/always # Instantiating module "handled" from file /etc/raddb/mods-enabled/always # Instantiating module "invalid" from file /etc/raddb/mods-enabled/always # Instantiating module "userlock" from file /etc/raddb/mods-enabled/always # Instantiating module "notfound" from file /etc/raddb/mods-enabled/always # Instantiating module "noop" from file /etc/raddb/mods-enabled/always # Instantiating module "updated" from file /etc/raddb/mods-enabled/always # Instantiating module "preprocess" from file /etc/raddb/mods-enabled/preprocess reading pairlist file /etc/raddb/mods-config/preprocess/huntgroups reading pairlist file /etc/raddb/mods-config/preprocess/hints # Instantiating module "expiration" from file /etc/raddb/mods-enabled/expiration # Instantiating module "files" from file /etc/raddb/mods-enabled/files reading pairlist file /etc/raddb/mods-config/files/authorize reading pairlist file /etc/raddb/mods-config/files/accounting reading pairlist file /etc/raddb/mods-config/files/pre-proxy # Instantiating module "eap" from file /etc/raddb/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/raddb/certs" pem_file_type = yes private_key_file = "/etc/raddb/certs/server.pem" certificate_file = "/etc/raddb/certs/server.pem" ca_file = "/etc/raddb/certs/ca.pem" private_key_password = <<< secret >>> dh_file = "/etc/raddb/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 = no lifetime = 24 max_entries = 255 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = yes use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_eap_type = "mschapv2" copy_request_to_tunnel = yes use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "eap_cisco_lan" from file /etc/raddb/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/raddb/certs" pem_file_type = yes private_key_file = "/etc/raddb/certs/server.pem" certificate_file = "/etc/raddb/certs/server.pem" ca_file = "/etc/raddb/certs/ca.pem" private_key_password = <<< secret >>> dh_file = "/etc/raddb/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 = no lifetime = 24 max_entries = 25 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = yes use_tunneled_reply = no virtual_server = "cisco_lan-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 = yes use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "cisco_lan-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 "eap_wlc_huawei" from file /etc/raddb/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/raddb/certs" pem_file_type = yes private_key_file = "/etc/raddb/certs/server.pem" certificate_file = "/etc/raddb/certs/server.pem" ca_file = "/etc/raddb/certs/ca.pem" private_key_password = <<< secret >>> dh_file = "/etc/raddb/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 = no lifetime = 24 max_entries = 25 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = yes use_tunneled_reply = no virtual_server = "wlc_huawei-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 = yes use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "wlc_huawei-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 "IPASS" from file /etc/raddb/mods-enabled/realm # Instantiating module "suffix" from file /etc/raddb/mods-enabled/realm # Instantiating module "realmpercent" from file /etc/raddb/mods-enabled/realm # Instantiating module "ntdomain" from file /etc/raddb/mods-enabled/realm # Instantiating module "auth_log" from file /etc/raddb/mods-enabled/detail.log rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output # Instantiating module "reply_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "pre_proxy_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "post_proxy_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "etc_passwd" from file /etc/raddb/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # Instantiating module "pap" from file /etc/raddb/mods-enabled/pap # Instantiating module "cache_eap" from file /etc/raddb/mods-enabled/cache_eap rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked # Instantiating module "logintime" from file /etc/raddb/mods-enabled/logintime # Instantiating module "sql" from file /etc/raddb/mods-enabled/oracle rlm_sql (sql): Attempting to connect to database "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ntlbill)(SERVER=DEDICATED)))" rlm_sql (sql): Initialising connection pool pool { start = 5 min = 5 max = 25 spare = 0 uses = 0 lifetime = 0 cleanup_interval = 0 idle_timeout = 0 retry_delay = 1 spread = no } rlm_sql (sql): Opening additional connection (0), 1 of 25 pending slots used rlm_sql (sql): Opening additional connection (1), 1 of 24 pending slots used rlm_sql (sql): Opening additional connection (2), 1 of 23 pending slots used rlm_sql (sql): Opening additional connection (3), 1 of 22 pending slots used rlm_sql (sql): Opening additional connection (4), 1 of 21 pending slots used # Instantiating module "sql_cisco_lan" from file /etc/raddb/mods-enabled/oracle rlm_sql (sql_cisco_lan): Attempting to connect to database "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)))(CONNECT_DATA = (SID = ntlbill)(SERVER=DEDICATED)))" rlm_sql (sql_cisco_lan): Initialising connection pool pool { start = 5 min = 5 max = 25 spare = 0 uses = 0 lifetime = 0 cleanup_interval = 0 idle_timeout = 0 retry_delay = 1 spread = no } rlm_sql (sql_cisco_lan): Opening additional connection (0), 1 of 25 pending slots used rlm_sql (sql_cisco_lan): Opening additional connection (1), 1 of 24 pending slots used rlm_sql (sql_cisco_lan): Opening additional connection (2), 1 of 23 pending slots used rlm_sql (sql_cisco_lan): Opening additional connection (3), 1 of 22 pending slots used rlm_sql (sql_cisco_lan): Opening additional connection (4), 1 of 21 pending slots used # Instantiating module "sql_wlc_huawei" from file /etc/raddb/mods-enabled/oracle rlm_sql (sql_wlc_huawei): Attempting to connect to database "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)))(CONNECT_DATA = (SID = ntlbill )(SERVER=DEDICATED)))" rlm_sql (sql_wlc_huawei): Initialising connection pool pool { start = 5 min = 5 max = 25 spare = 0 uses = 0 lifetime = 0 cleanup_interval = 0 idle_timeout = 0 retry_delay = 1 spread = no } rlm_sql (sql_wlc_huawei): Opening additional connection (0), 1 of 25 pending slots used rlm_sql (sql_wlc_huawei): Opening additional connection (1), 1 of 24 pending slots used rlm_sql (sql_wlc_huawei): Opening additional connection (2), 1 of 23 pending slots used rlm_sql (sql_wlc_huawei): Opening additional connection (3), 1 of 22 pending slots used rlm_sql (sql_wlc_huawei): Opening additional connection (4), 1 of 21 pending slots used } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/raddb/radiusd.conf } # server server cisco_lan-tunnel { # from file /etc/raddb/sites-enabled/cisco_lan-tunnel # Loading authenticate {...} # Loading authorize {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server cisco_lan-tunnel server inner-tunnel { # from file /etc/raddb/sites-enabled/inner-tunnel # Loading authenticate {...} # Loading authorize {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server inner-tunnel server default { # from file /etc/raddb/sites-enabled/default # Loading authenticate {...} # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server default server wlc_huawei { # from file /etc/raddb/sites-enabled/wlc_huawei # Loading authenticate {...} # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server wlc_huawei server cisco_lan { # from file /etc/raddb/sites-enabled/cisco_lan # Loading authenticate {...} # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server cisco_lan server wlc_huawei-tunnel { # from file /etc/raddb/sites-enabled/wlc_huawei-tunnel # Loading authenticate {...} # Loading authorize {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server wlc_huawei-tunnel radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = * port = 0 limit { max_connections = 0 lifetime = 0 idle_timeout = 30 } clients = "disambiguate" client one { ipaddr = ip require_message_authenticator = no secret = <<< secret >>> shortname = "ops-switch" virtual_server = "cisco_lan" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client two { ipaddr = ip require_message_authenticator = no secret = <<< secret >>> shortname = "test" virtual_server = "wlc_huawei" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client CGNAT { ipaddr = ip require_message_authenticator = no secret = <<< secret >>> shortname = "MX-480" virtual_server = "default" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client meraki { ipaddr = ip require_message_authenticator = no secret = <<< secret >>> virtual_server = "default" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client meraki1 { ipaddr = ip require_message_authenticator = no secret = <<< secret >>> virtual_server = "default" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client untangle { ipaddr = ip require_message_authenticator = no secret = <<< secret >>> virtual_server = "default" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } } listen { type = "acct" ipaddr = * port = 0 limit { max_connections = 0 lifetime = 0 idle_timeout = 30 } clients = "disambiguate" } listen { type = "control" listen { socket = "/var/log/radius/run/radiusd/radiusd.sock" peercred = yes } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } listen { type = "auth" ipaddr = 127.0.0.1 port = 18140 } listen { type = "auth" ipaddr = 127.0.0.1 port = 18130 } Listening on auth interface eth0 address * port 1812 Listening on acct interface eth0 address * port 1813 Listening on command file /var/log/radius/run/radiusd/radiusd.sock Listening on auth address 127.0.0.1 port 18120 bound to server cisco_lan-tunnel Listening on auth address 127.0.0.1 port 18140 bound to server inner-tunnel Listening on auth address 127.0.0.1 port 18130 bound to server wlc_huawei-tunnel Listening on proxy address * port 31975 Ready to process requests (0) Received Access-Request Id 49 from 172.16.33.246:1812 to 172.16.26.52:1812 length 337 (0) User-Name = "sheraz.raja" (0) NAS-Port = 50 (0) Service-Type = Framed-User (0) Framed-Protocol = PPP (0) Calling-Station-Id = "606d-c7ef-8d39" (0) NAS-Identifier = "NTL-WLC-AC6605-B" (0) NAS-Port-Type = Wireless-802.11 (0) NAS-Port-Id = "slot=0;subslot=0;port=0;vlanid=50" (0) EAP-Message = 0x029800100173686572617a2e72616a61 (0) Message-Authenticator = 0xae7f85ec892111599a6b0b1091b3d915 (0) Called-Station-Id = "F8-4A-BF-F2-98-80:MUSTAFA_RADIUS" (0) NAS-IP-Address = ip (0) Framed-MTU = 1500 (0) Acct-Session-Id = "NTL-WLC00000000000050c75934006064" (0) Huawei-Startup-Stamp = 1471070906 (0) Huawei-IPHost-Addr = "255.255.255.255 60:6d:c7:ef:8d:39" (0) Huawei-Connect-ID = 6064 (0) Huawei-Version = "Huawei AC6605" (0) Huawei-Product-ID = "AC" (0) Huawei-Loopback-Address = "F84A-BFF2-9880" (0) Huawei-User-Mac = "\000\000\000\001" (0) # Executing section authorize from file /etc/raddb/sites-enabled/wlc_huawei (0) authorize { (0) [preprocess] = ok (0) auth_log: EXPAND /var/log/radius/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d (0) auth_log: --> /var/log/radius/log/radius/radacct/172.16.33.246/auth-detail-20170516 (0) auth_log: /var/log/radius/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d expands to /var/log/radius/log/radius/radacct/172.16.33.246/auth-detail-20170516 (0) auth_log: EXPAND %t (0) auth_log: --> Tue May 16 12:18:06 2017 (0) [auth_log] = ok (0) [digest] = noop (0) suffix: Checking for suffix after "@" (0) suffix: No '@' in User-Name = "sheraz.raja", looking up realm NULL (0) suffix: No such realm "NULL" (0) [suffix] = noop (0) eap_wlc_huawei: Peer sent EAP Response (code 2) ID 152 length 16 (0) eap_wlc_huawei: EAP-Identity reply, returning 'ok' so we can short-circuit the rest of authorize (0) [eap_wlc_huawei] = ok (0) } # authorize = ok (0) Found Auth-Type = eap_wlc_huawei (0) # Executing group from file /etc/raddb/sites-enabled/wlc_huawei (0) authenticate { (0) eap_wlc_huawei: Peer sent packet with method EAP Identity (1) (0) eap_wlc_huawei: Calling submodule eap_md5 to process data (0) eap_md5: Issuing MD5 Challenge (0) eap_wlc_huawei: Sending EAP Request (code 1) ID 153 length 22 (0) eap_wlc_huawei: EAP session adding &reply:State = 0x2f8d2fdb2f142bf2 (0) [eap_wlc_huawei] = handled (0) } # authenticate = handled (0) Using Post-Auth-Type Challenge (0) Post-Auth-Type sub-section not found. Ignoring. (0) # Executing group from file /etc/raddb/sites-enabled/wlc_huawei (0) Sent Access-Challenge Id 49 from 172.16.26.52:1812 to 172.16.33.246:1812 length 0 (0) EAP-Message = 0x019900160410979a377ba2e77ab75e881959c3bc7f0e (0) Message-Authenticator = 0x00000000000000000000000000000000 (0) State = 0x2f8d2fdb2f142bf26b8337a4984bcade (0) Finished request Waking up in 4.9 seconds. Waking up in 5.0 seconds. Waking up in 10.0 seconds. (0) Cleaning up request packet ID 49 with timestamp +24 Ready to process requests And it just stops here. This happens for both virtual hosts. Any help on this would be greatly appreciated. Thanks!!

1 1

Freeradius3 + SQL -> radusergroup check is not matched
by Martin Bednar 15 May '17

15 May '17

Hello Allan, many thanks for help. To be honest I believe that for me it would be easier to make it work with tables and queries already in place so if you don't mind I'd just like to doublecheck what am I not understanding well from the rlm_sql documentation. -->Search the radcheck table for any check attributes specific to the user -->If check attributes are found, and there's a match, pull the reply items from the radreply table for this user and add them to the reply In my case it is password MariaDB [radius]> select * from radcheck where username = "miro"; +----+----------+--------------------+----+-------+ | id | username | attribute | op | value | +----+----------+--------------------+----+-------+ | 7 | miro | Cleartext-Password | := | miro | +----+----------+--------------------+----+-------+ nothing is in radreply table MariaDB [radius]> select * from radreply; Empty set (0.00 sec) --> Group processing then begins if any of the following conditions are met: The user IS NOT found in radcheck The user IS found in radcheck, but the check items don't match The user IS found in radcheck, the check items DO match AND Fall-Through is set in the radreply table The user IS found in radcheck, the check items DO match AND the read_groups directive is set to 'yes' I'm matching last condition: # grep read_clients /etc/raddb/mods-available/sql read_clients = yes --> If groups are to be processed for this user, the first thing that is done is the list of groups this user is a member of is pulled from the usergroup table ordered by the priority field. MariaDB [radius]> select * from radusergroup where username = "miro" order by priority; +----------+----------------+----------+ | username | groupname | priority | +----------+----------------+----------+ | miro | SSID_EMPL-Test | 1 | | miro | Reject-Profile | 2 | +----------+----------------+----------+ 2 rows in set (0.00 sec) So group SSID_EMPL-Test is the one which will be checked first : MariaDB [radius]> select * from radgroupcheck where groupname = "SSID_EMPL-Test"; +----+----------------+------------------+----+-----------+ | id | groupname | attribute | op | value | +----+----------------+------------------+----+-----------+ | 6 | SSID_EMPL-Test | Aruba-Essid-Name | == | EMPL-Test | +----+----------------+------------------+----+-----------+ 1 row in set (0.00 sec) --> If there is a match, the reply items for this group are pulled from the radgroupreply table and applied. MariaDB [radius]> select * from radgroupreply where groupname = "SSID_EMPL-Test"; +----+----------------+-----------+----+--------+ | id | groupname | attribute | op | value | +----+----------------+-----------+----+--------+ | 6 | SSID_EMPL-Test | Auth-Type | := | Accept | +----+----------------+-----------+----+--------+ 1 row in set (0.00 sec) --> Processing continues to the next group IF: There was not a match for the last group's check items so my understanding is that check won't continue and user will get Accept. Clearly I'm missing something but I don't know what. You're saying that " 6 | SSID_EMPL-Test | Aruba-Essid-Name | == | EMPL-Test Which says that anyone in the SSID_EMPL-Test is rejected if they use the EMPL-Test SSID." If you could show me here right directions I'd really appreciate that. How should I check if Aruba-Essid-Name has value EMPL-Test and if so Accept the user ? Thanks for your time, Martin

2 1

Re: sql failover
by Richard J Palmer 15 May '17

15 May '17

Hi I think this is where I am going wrong. The aim is I want FR to handle the failover - We should be using the primary SQL server at all times UNLESS it fails. MS SQL is set as a mirrored pair (nothing to do with FR) the 'Live' Server will answer queries - the backup will allow connections BUT the queries will fail. IF the primary fails the backup automatically allows queries and the primary will not >From https://wiki.freeradius.org/config/Fail-over I have set redundant { # try module sql1 sql1 # if that's down, try module sql2 sql2 # otherwise drop the request as # it's been "handled" by the "always" # module (see doc/rlm_always) handled } Within the authenticate / authorise / accounting / postauth sections The issue is the startup of the modules that is causing the issue given that the Database on sql2 is not available unless it is the 'live' server With regards to > >> >> IF I use the odbc driver I can set the radius database to be blank AND >> set the table names to be radius..<table name> BUT If I leave the >> database name blank in the freetds driver I get 'rlm_sql_freetds: >> Server msg from "<Server Name>": severity(102), number(15), origin(1), >> layer(1), procedure "none": Incorrect syntax near ';'.' Which I assume >> is from when it is trying to select the database. > > Sounds like and ODBC syntax error to me. This is because the database is not available on the backup server - so the select db to radius fails. Using the unixodbc driver I can leave the database name to blank - and edit the table names to eg radius..radacct for example - but with the freetds driver if I leave the database name blank It seems to be trying the select anyway which fails - as the db name is blank. For now I have changed to using unixodbc. It is totally possible I have the wrong end of the stick somewhere - If I have misunderstood / read this I am always happy for some pointers. Richard > --- Original message --- > Subject: Re: sql failover > From: Alan DeKok <aland(a)deployingradius.com> > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Date: Monday, 15/05/2017 1:45 PM > > On May 14, 2017, at 8:38 PM, Richard J Palmer <richard(a)merula.net> > wrote: >> >> This may be a simple question but I am a little stuck. >> >> We are using mssql as a backend for a radius server - this generally >> works fine. >> >> A new mirror server was recently installed and I am trying to create >> redundancy within freeradius - However I have a problem to which I am >> not sure of the answer >> >> I have created sql1 and sql2 One pointing to the primary server - the >> second to the backup >> >> the config loads OK etc however with the current mirror setup only one >> of the two SQL servers will allow the radius databases to be accessed. >> The other when connected gives 'Database 'radius' cannot be opened. It >> is in the middle of a restore.' At this point the radius server stops >> loading rather than using the working SQL connection. > > You can set "start = 0" in the SQL module configuration. This is > documented in the comments in the SQL module, for the "start" > configuration. > > But it's generally a bad idea to have your system lie to > FreeRADIUS. If you want fail-over, do it in FreeRADIUS. *Don't* do > it somewhere else, and then also try to do it in FreeRADIUS. That's a > recipe for disaster. > > The two systems can get out of sync, and then the "redundant" > solution will end up causing problems instead of solving them. > >> >> IF I use the odbc driver I can set the radius database to be blank AND >> set the table names to be radius..<table name> BUT If I leave the >> database name blank in the freetds driver I get 'rlm_sql_freetds: >> Server msg from "<Server Name>": severity(102), number(15), origin(1), >> layer(1), procedure "none": Incorrect syntax near ';'.' Which I >> assume is from when it is trying to select the database. > > Sounds like and ODBC syntax error to me. > >> >> Can you confirm if there is a way to work with the current SQL setup ? > > Let FreeRADIUS do fail-over if you want it to do fail-over. > > Extra layers between FR and SQL just causes problems 99% of the > time. > > Alan DeKok. > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html

2 1

sql failover
by Richard J Palmer 15 May '17

15 May '17

Hi there... This may be a simple question but I am a little stuck. We are using mssql as a backend for a radius server - this generally works fine. A new mirror server was recently installed and I am trying to create redundancy within freeradius - However I have a problem to which I am not sure of the answer I have created sql1 and sql2 One pointing to the primary server - the second to the backup the config loads OK etc however with the current mirror setup only one of the two SQL servers will allow the radius databases to be accessed. The other when connected gives 'Database 'radius' cannot be opened. It is in the middle of a restore.' At this point the radius server stops loading rather than using the working SQL connection. IF I use the odbc driver I can set the radius database to be blank AND set the table names to be radius..<table name> BUT If I leave the database name blank in the freetds driver I get 'rlm_sql_freetds: Server msg from "<Server Name>": severity(102), number(15), origin(1), layer(1), procedure "none": Incorrect syntax near ';'.' Which I assume is from when it is trying to select the database. Can you confirm if there is a way to work with the current SQL setup ? Thanks! Richard Palmer

2 1

Freeradius3 + SQL -> radusergroup check is not matched
by Martin Bednar 15 May '17

15 May '17

Hello, I'm struggling with this issue for couple days so any help would be appreciated I'm running 3.0.13 version with mariadb as backend # rpm -aq | grep -i radius freeradius-config-3.0.13-19.1.x86_64 freeradius-3.0.13-19.1.x86_64 freeradius-utils-3.0.13-19.1.x86_64 freeradius-mysql-3.0.13-19.1.x86_64 basic authentication is working fine, however I have problem with groupcheck. What I'm trying to achieve is to limit user per SSID. I have created 2 profiles with appropriate reply actions MariaDB [radius]> select * from radgroupcheck; +----+---------------------------+-------------------+----+----------------------+ | id | groupname | attribute | op | value | +----+---------------------------+-------------------+----+----------------------+ | 1 | Reject-Profile | Auth-Type | := | Reject | | 6 | SSID_EMPL-Test | Aruba-Essid-Name | == | EMPL-Test | MariaDB [radius]> select * from radgroupreply; +----+---------------------------+---------------+----+--------+ | id | groupname | attribute | op | value | +----+---------------------------+---------------+----+--------+ | 1 | Reject-Profile | Auth-Type | := | Reject | | 6 | SSID_EMPL-Test | Reply-Message | = | Vitaj | and assigned them to the user MariaDB [radius]> select * from radusergroup; +-----------------------+---------------------------+----------+ | username | groupname | priority | +-----------------------+---------------------------+----------+ | miro | SSID_EMPL-Test | 1 | | miro | Reject-Profile | 2 | +-----------------------+---------------------------+----------+ Expectation is that Radius will check whether user is connecting to the SSID "EMPL-Test" if so it will be accepted otherwise it will go to Reject profile and request will be rejected. Problem is that user is always rejected even when is connecting to the correct SSID. (6) Received Access-Request Id 9 from 10.200.99.38:56327 to 10.1.20.5:1812 length 258 (6) User-Name = "miro" (6) NAS-IP-Address = 10.200.99.38 (6) NAS-Port = 0 (6) NAS-Identifier = "10.200.99.38" (6) NAS-Port-Type = Wireless-802.11 (6) Calling-Station-Id = "606720cbfb52" (6) Called-Station-Id = "84d47ec68cda" (6) Service-Type = Login-User (6) Framed-MTU = 1100 (6) EAP-Message = 0x0207002b190017030100205b4dc9fa8209387ae85ddd94e674431e428c4baacb2f58cc7c14d4d310106e6d (6) State = 0x97bd745292ba6df3cc8378af9230d359 (6) Aruba-Essid-Name = "EMPL-Test" (6) Aruba-Location-Id = "84:d4:7e:c6:8c:da" (6) Aruba-AP-Group = "instant-C6:8C:DA" (6) Aruba-Device-Type = "Win 7" We can see in the output that Aruba-Essid-Name = "EMPL-Test" but in the SQL part there is no match on that profile, instead of that it is going to next one Reject-profile and rejecting the request: (7) sql: EXPAND %{User-Name} (7) sql: --> miro (7) sql: SQL-User-Name set to 'miro' rlm_sql (sql): Reserved connection (1) (7) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (7) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'miro' ORDER BY id (7) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'miro' ORDER BY id (7) sql: User found in radcheck table (7) sql: Conditional check items matched, merging assignment check items (7) sql: Cleartext-Password := "miro" (7) sql: Expiration := "May 31 2017 00:00:00 CEST" (7) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (7) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'miro' ORDER BY id (7) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'miro' ORDER BY id (7) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (7) sql: --> SELECT groupname FROM radusergroup WHERE username = 'miro' ORDER BY priority (7) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'miro' ORDER BY priority (7) sql: User found in the group table (7) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (7) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'SSID_EMPL-Test' ORDER BY id (7) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'SSID_EMPL-Test' ORDER BY id (7) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (7) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'Reject-Profile' ORDER BY id (7) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'Reject-Profile' ORDER BY id (7) sql: Group "Reject-Profile": Conditional check items matched (7) sql: Group "Reject-Profile": Merging assignment check items (7) sql: Auth-Type := Reject (7) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (7) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'Reject-Profile' ORDER BY id (7) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'Reject-Profile' ORDER BY id (7) sql: Group "Reject-Profile": Merging reply items (7) sql: Auth-Type := Reject rlm_sql (sql): Released connection (1) What I don't really understand is that if I do the test with radclient I got Accept: # echo "User-Name=miro,User-Password=miro,Aruba-Essid-Name=EMPL-Test" | radclient localhost:1812 auth test123 Sent Access-Request Id 148 from 0.0.0.0:35642 to 127.0.0.1:1812 length 61 Received Access-Accept Id 148 from 127.0.0.1:1812 to 0.0.0.0:0 length 33 #radiusd -X (9) Received Access-Request Id 225 from 127.0.0.1:41535 to 127.0.0.1:1812 length 61 (9) User-Name = "miro" (9) User-Password = "miro" (9) Aruba-Essid-Name = "EMPL-Test" ... (9) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id (9) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'miro' ORDER BY id (9) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'miro' ORDER BY id (9) sql: User found in radcheck table (9) sql: Conditional check items matched, merging assignment check items (9) sql: Cleartext-Password := "miro" (9) sql: Expiration := "May 31 2017 00:00:00 CEST" (9) sql: EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id (9) sql: --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'miro' ORDER BY id (9) sql: Executing select query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'miro' ORDER BY id (9) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority (9) sql: --> SELECT groupname FROM radusergroup WHERE username = 'miro' ORDER BY priority (9) sql: Executing select query: SELECT groupname FROM radusergroup WHERE username = 'miro' ORDER BY priority (9) sql: User found in the group table (9) sql: EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY id (9) sql: --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'SSID_EMPL-Test' ORDER BY id (9) sql: Executing select query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'SSID_EMPL-Test' ORDER BY id (9) sql: Group "SSID_EMPL-Test": Conditional check items matched (9) sql: Group "SSID_EMPL-Test": Merging assignment check items (9) sql: EXPAND SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY id (9) sql: --> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'SSID_EMPL-Test' ORDER BY id (9) sql: Executing select query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'SSID_EMPL-Test' ORDER BY id (9) sql: Group "SSID_EMPL-Test": Merging reply items (9) sql: Reply-Message = "Vitaj" It seems that in both cases is Aruba-Essid-Name = "EMPL-Test" the same so I don't understand the difference in behaviour. I tried also different attribute but with the same result. I changed AP type also the same result. Any idea what could be the problem ? Thank you, -- Martin

2 1