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

SQL - How to use MSSQL for Authentication and MySQL for Accounting
by Jeremiah Peterson 12 May '14

12 May '14

Greetings, I have searched for some time but cannot seem to find an answer to this, but I am sure it can be done. I use a MSSQL database on a separate server for Authentication and that is working well. I want to use a MySQL database on a third server for Accounting. Everything I have searched shows how to configure it for one or the other but not both. I am trying to find out how to accomplish this, so if anyone has some insight, please do share. Thanks in advance. Jer

1 0

Question about "lower"
by Lucas Diaz 12 May '14

12 May '14

I've got installed freeradius 3.0.3 connected to a firebird database. It is working fine for about a week, but I'm getting my logs filled with following entries: Mon May 12 10:05:38 2014 : Info: rlm_sql (sql): Opening additional connection (1116) Mon May 12 10:05:38 2014 : Info: rlm_sql (sql): Closing connection (1114): Hit idle_timeout, was idle for 577 seconds Mon May 12 10:05:38 2014 : rlm_sql (sql): You probably need to lower "min" Mon May 12 10:05:51 2014 : Info: rlm_sql (sql): Opening additional connection (1117) Mon May 12 10:07:40 2014 : Info: rlm_sql (sql): Closing connection (1116): Hit idle_timeout, was idle for 109 seconds Mon May 12 10:07:40 2014 : rlm_sql (sql): You probably need to lower "min" Mon May 12 10:07:40 2014 : Info: rlm_sql (sql): Closing connection (1115): Hit idle_timeout, was idle for 123 seconds Mon May 12 10:08:12 2014 : Info: rlm_sql (sql): Opening additional connection (1118) Mon May 12 10:08:53 2014 : Info: rlm_sql (sql): Opening additional connection (1119) Mon May 12 10:12:16 2014 : Info: rlm_sql (sql): Closing connection (1118): Hit idle_timeout, was idle for 203 seconds Mon May 12 10:12:16 2014 : rlm_sql (sql): You probably need to lower "min" Mon May 12 10:12:16 2014 : Info: rlm_sql (sql): Closing connection (1117): Hit idle_timeout, was idle for 244 seconds I'd like to know what means " You probably need to lower "min" " Thank you. -- *LUCAS DIAZ | DPTO. REDES* _______________________________________________________ Istilart 255 | Tel.: 02983 513040 C.P. B7500EGE | Tres Arroyos | Bs As | Argentina * *www.eternet.cc <http://www.eternet.cc/> | *ETERNET SISTEMAS *

3 3

AVP EAP-KEY name support in FR
by Srinu Bandari 12 May '14

12 May '14

Hi, We are trying to bring up MACsec with Cisco and FR, and we are stuck because of Radius unable to send EAP-Key-Name AVP. Below is what is expected as per RFC4072 RFC4072 says "A home Diameter server receiving a Diameter-EAP-Request with a Key-Name AVP with non-empty data MUST silently discard the AVP. In addition, the home Diameter server SHOULD include this AVP in Diameter-EAP-Response only if an empty EAP-Key-Name AVP was present in Diameter-EAP-Request." But radius server is not sending EAP-Key-Name AVP (Radius Attribute Type 102) even invalid AVP present in the Diameter-EAP-Request". Below is the debug print of radius Sending Access-Accept of id 647 to 10.20.64.9 port 1645 MS-MPPE-Recv-Key = 0x84e5c624c3bcdeadca3c6210f24bd7b8336921ccc1c58399d397afc75770332c MS-MPPE-Send-Key = 0xa6c4860cc8092c251502f5adc3ee13586e05fe84cbbb8b6793b08d9523d12b1f EAP-Message = 0x03060004 Message-Authenticator = 0x00000000000000000000000000000000 User-Name = "user1" Does anyone have clue on this. Thanks, Srinivas CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

4 19

Re: rlm_sqlcounter: Max-Daily-Session.
by * 12 May '14

12 May '14

Thank you for your reply. Here is my radius -X > radiusd: FreeRADIUS Version 3.0.1, for host x86_64-pc-linux-gnu, built on Apr 15 2014 at 14:04:23 > > Copyright (C) 1999-2014 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 /etc/freeradius/dictionary > > including configuration file /etc/freeradius/radiusd.conf > > including configuration file /etc/freeradius/proxy.conf > > including configuration file /etc/freeradius/clients.conf > > including files in directory /etc/freeradius/mods-enabled/ > > including configuration file /etc/freeradius/mods-enabled/eap > > including configuration file /etc/freeradius/mods-enabled/always > > including configuration file /etc/freeradius/mods-enabled/dynamic_clients > > including configuration file /etc/freeradius/mods-enabled/detail.log > > including configuration file /etc/freeradius/mods-enabled/detail > > including configuration file /etc/freeradius/mods-enabled/sradutmp > > including configuration file /etc/freeradius/mods-enabled/expiration > > including configuration file /etc/freeradius/mods-enabled/preprocess > > including configuration file /etc/freeradius/mods-enabled/logintime > > including configuration file /etc/freeradius/mods-enabled/soh > > including configuration file /etc/freeradius/mods-enabled/dhcp > > including configuration file /etc/freeradius/mods-enabled/radutmp > > including configuration file /etc/freeradius/mods-enabled/digest > > including configuration file /etc/freeradius/mods-enabled/exec > > including configuration file /etc/freeradius/mods-enabled/echo > > including configuration file /etc/freeradius/mods-enabled/replicate > > including configuration file /etc/freeradius/mods-enabled/cache_eap > > including configuration file /etc/freeradius/mods-enabled/linelog > > including configuration file /etc/freeradius/mods-enabled/utf8 > > including configuration file /etc/freeradius/mods-enabled/attr_filter > > including configuration file /etc/freeradius/mods-enabled/chap > > including configuration file /etc/freeradius/mods-enabled/realm > > including configuration file /etc/freeradius/mods-enabled/passwd > > including configuration file /etc/freeradius/mods-enabled/ntlm_auth > > including configuration file /etc/freeradius/mods-enabled/sql > > including configuration file /etc/freeradius/mods-config/sql/main/mysql/queries.conf > > including configuration file /etc/freeradius/mods-enabled/sqlcounter > > including configuration file /etc/freeradius/mods-enabled/pap > > including configuration file /etc/freeradius/mods-enabled/perl > > including configuration file /etc/freeradius/mods-enabled/files > > including configuration file /etc/freeradius/mods-enabled/expr > > including configuration file /etc/freeradius/mods-enabled/unix > > including configuration file /etc/freeradius/mods-enabled/mschap > > including files in directory /etc/freeradius/policy.d/ > > including configuration file /etc/freeradius/policy.d/eap > > including configuration file /etc/freeradius/policy.d/cui > > including configuration file /etc/freeradius/policy.d/operator-name > > including configuration file /etc/freeradius/policy.d/dhcp > > including configuration file /etc/freeradius/policy.d/control > > including configuration file /etc/freeradius/policy.d/filter > > including configuration file /etc/freeradius/policy.d/canonicalization > > including configuration file /etc/freeradius/policy.d/accounting > > including files in directory /etc/freeradius/sites-enabled/ > > including configuration file /etc/freeradius/sites-enabled/inner-tunnel > > including configuration file /etc/freeradius/sites-enabled/default > > main { > > security { > > user = "freerad" > > group = "freerad" > > allow_core_dumps = no > > } > > } > > 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 = 1024 > > pidfile = "/var/run/freeradius/freeradius.pid" > > checkrad = "/usr/sbin/checkrad" > > debug_level = 0 > > proxy_requests = no > > log { > > stripped_names = no > > auth = no > > auth_badpass = no > > auth_goodpass = no > > colourise = yes > > } > > security { > > max_attributes = 200 > > reject_delay = 1 > > 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 = "testing123" > > response_window = 20 > > max_outstanding = 65536 > > zombie_period = 40 > > status_check = "status-server" > > ping_interval = 30 > > check_interval = 30 > > num_answers_to_alive = 3 > > revive_interval = 120 > > status_check_timeout = 4 > > coa { > > irt = 2 > > mrt = 16 > > mrc = 5 > > mrd = 30 > > } > > limit { > > max_connections = 16 > > max_requests = 0 > > lifetime = 0 > > idle_timeout = 0 > > } > > } > > 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 = "radius" > > shortname = "localhost" > > nas_type = "other" > > proto = "*" > > limit { > > max_connections = 16 > > lifetime = 0 > > idle_timeout = 30 > > } > > } > > client 27.33.228.125 { > > require_message_authenticator = no > > secret = "radius" > > shortname = "14kimberleyst" > > nas_type = "mikrotik" > > limit { > > max_connections = 16 > > lifetime = 0 > > idle_timeout = 30 > > } > > } > > client 220.244.108.10 { > > require_message_authenticator = no > > secret = "radius" > > shortname = "30cookst" > > nas_type = "mikrotik_snmp" > > limit { > > max_connections = 16 > > lifetime = 0 > > idle_timeout = 30 > > } > > } > > client 10.1.1.22/24 { > > require_message_authenticator = no > > secret = "radius" > > shortname = "MikroTik" > > limit { > > max_connections = 16 > > lifetime = 0 > > idle_timeout = 30 > > } > > } > > client 99hamilton.no-ip.biz { > > require_message_authenticator = no > > secret = "radius" > > shortname = "99hamilton" > > nas_type = "mikrotik" > > limit { > > max_connections = 16 > > lifetime = 0 > > idle_timeout = 30 > > } > > } > > radiusd: #### Instantiating modules #### > > instantiate { > > } > > modules { > > # Loaded module rlm_eap > > # Instantiating module "eap" from file /etc/freeradius/mods-enabled/eap > > eap { > > default_eap_type = "md5" > > timer_expire = 60 > > ignore_unknown_eap_types = no > > mod_accounting_username_bug = no > > max_sessions = 4096 > > } > > # 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 { > > rsa_key_exchange = no > > dh_key_exchange = yes > > rsa_key_length = 512 > > dh_key_length = 512 > > verify_depth = 0 > > ca_path = "/etc/freeradius/certs" > > pem_file_type = yes > > private_key_file = "/etc/freeradius/certs/server.pem" > > certificate_file = "/etc/freeradius/certs/server.pem" > > ca_file = "/etc/freeradius/certs/ca.pem" > > private_key_password = "whatever" > > dh_file = "/etc/freeradius/certs/dh" > > fragment_size = 1024 > > include_length = yes > > check_crl = no > > cipher_list = "DEFAULT" > > ecdh_curve = "prime256v1" > > cache { > > enable = yes > > lifetime = 24 > > max_entries = 255 > > } > > verify { > > } > > ocsp { > > enable = no > > override_cert_url = yes > > url = "http://127.0.0.1/ocsp/" > > use_nonce = yes > > timeout = 0 > > softfail = yes > > } > > } > > # 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 > > } > > Using cached TLS configuration from previous invocation > > # Linked to sub-module rlm_eap_peap > > peap { > > tls = "tls-common" > > default_method = "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 > > } > > Using cached TLS configuration from previous invocation > > # Linked to sub-module rlm_eap_mschapv2 > > mschapv2 { > > with_ntdomain_hack = no > > send_error = no > > } > > # Loaded module rlm_always > > # Instantiating module "fail" from file /etc/freeradius/mods-enabled/always > > always fail { > > rcode = "fail" > > simulcount = 0 > > mpp = no > > } > > # Instantiating module "reject" from file /etc/freeradius/mods-enabled/always > > always reject { > > rcode = "reject" > > simulcount = 0 > > mpp = no > > } > > # Instantiating module "noop" from file /etc/freeradius/mods-enabled/always > > always noop { > > rcode = "noop" > > simulcount = 0 > > mpp = no > > } > > # Instantiating module "handled" from file /etc/freeradius/mods-enabled/always > > always handled { > > rcode = "handled" > > simulcount = 0 > > mpp = no > > } > > # Instantiating module "updated" from file /etc/freeradius/mods-enabled/always > > always updated { > > rcode = "updated" > > simulcount = 0 > > mpp = no > > } > > # Instantiating module "notfound" from file /etc/freeradius/mods-enabled/always > > always notfound { > > rcode = "notfound" > > simulcount = 0 > > mpp = no > > } > > # Instantiating module "ok" from file /etc/freeradius/mods-enabled/always > > always ok { > > rcode = "ok" > > simulcount = 0 > > mpp = no > > } > > # Loaded module rlm_dynamic_clients > > # Instantiating module "dynamic_clients" from file /etc/freeradius/mods-enabled/dynamic_clients > > # Loaded module rlm_detail > > # Instantiating module "auth_log" from file /etc/freeradius/mods-enabled/detail.log > > detail auth_log { > > filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d" > > header = "%t" > > permissions = 384 > > dir_permissions = 493 > > locking = no > > log_packet_header = no > > } > > rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output > > # Instantiating module "reply_log" from file /etc/freeradius/mods-enabled/detail.log > > detail reply_log { > > filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/reply-detail-%Y%m%d" > > header = "%t" > > permissions = 384 > > dir_permissions = 493 > > locking = no > > log_packet_header = no > > } > > # Instantiating module "pre_proxy_log" from file /etc/freeradius/mods-enabled/detail.log > > detail pre_proxy_log { > > filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/pre-proxy-detail-%Y%m%d" > > header = "%t" > > permissions = 384 > > dir_permissions = 493 > > locking = no > > log_packet_header = no > > } > > # Instantiating module "post_proxy_log" from file /etc/freeradius/mods-enabled/detail.log > > detail post_proxy_log { > > filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/post-proxy-detail-%Y%m%d" > > header = "%t" > > permissions = 384 > > dir_permissions = 493 > > locking = no > > log_packet_header = no > > } > > # Instantiating module "detail" from file /etc/freeradius/mods-enabled/detail > > detail { > > filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" > > header = "%t" > > permissions = 384 > > dir_permissions = 493 > > locking = no > > log_packet_header = no > > } > > # Loaded module rlm_radutmp > > # Instantiating module "sradutmp" from file /etc/freeradius/mods-enabled/sradutmp > > radutmp sradutmp { > > filename = "/var/log/freeradius/sradutmp" > > username = "%{User-Name}" > > case_sensitive = yes > > check_with_nas = yes > > permissions = 420 > > caller_id = no > > } > > # Loaded module rlm_expiration > > # Instantiating module "expiration" from file /etc/freeradius/mods-enabled/expiration > > # Loaded module rlm_preprocess > > # Instantiating module "preprocess" from file /etc/freeradius/mods-enabled/preprocess > > preprocess { > > huntgroups = "/etc/freeradius/mods-config/preprocess/huntgroups" > > hints = "/etc/freeradius/mods-config/preprocess/hints" > > with_ascend_hack = no > > ascend_channels_per_line = 23 > > with_ntdomain_hack = no > > with_specialix_jetstream_hack = no > > with_cisco_vsa_hack = no > > with_alvarion_vsa_hack = no > > } > > reading pairlist file /etc/freeradius/mods-config/preprocess/huntgroups > > reading pairlist file /etc/freeradius/mods-config/preprocess/hints > > # Loaded module rlm_logintime > > # Instantiating module "logintime" from file /etc/freeradius/mods-enabled/logintime > > logintime { > > minimum_timeout = 60 > > } > > # Loaded module rlm_soh > > # Instantiating module "soh" from file /etc/freeradius/mods-enabled/soh > > soh { > > dhcp = yes > > } > > # Loaded module rlm_dhcp > > # Instantiating module "dhcp" from file /etc/freeradius/mods-enabled/dhcp > > # Instantiating module "radutmp" from file /etc/freeradius/mods-enabled/radutmp > > radutmp { > > filename = "/var/log/freeradius/radutmp" > > username = "%{User-Name}" > > case_sensitive = yes > > check_with_nas = yes > > permissions = 384 > > caller_id = yes > > } > > # Loaded module rlm_digest > > # Instantiating module "digest" from file /etc/freeradius/mods-enabled/digest > > # Loaded module rlm_exec > > # Instantiating module "exec" from file /etc/freeradius/mods-enabled/exec > > exec { > > wait = no > > input_pairs = "request" > > shell_escape = yes > > timeout = 10 > > } > > # Instantiating module "echo" from file /etc/freeradius/mods-enabled/echo > > exec echo { > > wait = yes > > program = "/bin/echo %{User-Name}" > > input_pairs = "request" > > output_pairs = "reply" > > shell_escape = yes > > } > > # Loaded module rlm_replicate > > # Instantiating module "replicate" from file /etc/freeradius/mods-enabled/replicate > > # Loaded module rlm_cache > > # Instantiating module "cache_eap" from file /etc/freeradius/mods-enabled/cache_eap > > cache cache_eap { > > key = "%{%{control:State}:-%{%{reply:State}:-%{State}}}" > > ttl = 15 > > max_entries = 16384 > > epoch = 0 > > add_stats = no > > } > > # Loaded module rlm_linelog > > # Instantiating module "linelog" from file /etc/freeradius/mods-enabled/linelog > > linelog { > > filename = "/var/log/freeradius/linelog" > > permissions = 384 > > format = "This is a log message for %{User-Name}" > > reference = "%{%{Packet-Type}:-format}" > > } > > # Loaded module rlm_utf8 > > # Instantiating module "utf8" from file /etc/freeradius/mods-enabled/utf8 > > # Loaded module rlm_attr_filter > > # Instantiating module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter > > attr_filter attr_filter.post-proxy { > > filename = "/etc/freeradius/mods-config/attr_filter/post-proxy" > > key = "%{Realm}" > > relaxed = no > > } > > reading pairlist file /etc/freeradius/mods-config/attr_filter/post-proxy > > # Instantiating module "attr_filter.pre-proxy" from file /etc/freeradius/mods-enabled/attr_filter > > attr_filter attr_filter.pre-proxy { > > filename = "/etc/freeradius/mods-config/attr_filter/pre-proxy" > > key = "%{Realm}" > > relaxed = no > > } > > reading pairlist file /etc/freeradius/mods-config/attr_filter/pre-proxy > > # Instantiating module "attr_filter.access_reject" from file /etc/freeradius/mods-enabled/attr_filter > > attr_filter attr_filter.access_reject { > > filename = "/etc/freeradius/mods-config/attr_filter/access_reject" > > key = "%{User-Name}" > > relaxed = no > > } > > reading pairlist file /etc/freeradius/mods-config/attr_filter/access_reject > > # Instantiating module "attr_filter.access_challenge" from file /etc/freeradius/mods-enabled/attr_filter > > attr_filter attr_filter.access_challenge { > > filename = "/etc/freeradius/mods-config/attr_filter/access_challenge" > > key = "%{User-Name}" > > relaxed = no > > } > > reading pairlist file /etc/freeradius/mods-config/attr_filter/access_challenge > > # Instantiating module "attr_filter.accounting_response" from file /etc/freeradius/mods-enabled/attr_filter > > attr_filter attr_filter.accounting_response { > > filename = "/etc/freeradius/mods-config/attr_filter/accounting_response" > > key = "%{User-Name}" > > relaxed = no > > } > > reading pairlist file /etc/freeradius/mods-config/attr_filter/accounting_response > > # Loaded module rlm_chap > > # Instantiating module "chap" from file /etc/freeradius/mods-enabled/chap > > # Loaded module rlm_realm > > # Instantiating module "IPASS" from file /etc/freeradius/mods-enabled/realm > > realm IPASS { > > format = "prefix" > > delimiter = "/" > > ignore_default = no > > ignore_null = no > > } > > # Instantiating module "suffix" from file /etc/freeradius/mods-enabled/realm > > realm suffix { > > format = "suffix" > > delimiter = "@" > > ignore_default = no > > ignore_null = no > > } > > # Instantiating module "realmpercent" from file /etc/freeradius/mods-enabled/realm > > realm realmpercent { > > format = "suffix" > > delimiter = "%" > > ignore_default = no > > ignore_null = no > > } > > # Instantiating module "ntdomain" from file /etc/freeradius/mods-enabled/realm > > realm ntdomain { > > format = "prefix" > > delimiter = "\" > > ignore_default = no > > ignore_null = no > > } > > # Loaded module rlm_passwd > > # Instantiating module "etc_passwd" from file /etc/freeradius/mods-enabled/passwd > > passwd etc_passwd { > > filename = "/etc/passwd" > > format = "*User-Name:Crypt-Password:" > > delimiter = ":" > > ignore_nislike = no > > ignore_empty = yes > > allow_multiple_keys = no > > hash_size = 100 > > } > > rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no > > # Instantiating module "ntlm_auth" from file /etc/freeradius/mods-enabled/ntlm_auth > > exec ntlm_auth { > > wait = yes > > program = "/path/to/ntlm_auth --request-nt-key --domain=MYDOMAIN --username=%{mschap:User-Name} --password=%{User-Password}" > > shell_escape = yes > > } > > # Loaded module rlm_sql > > # Instantiating module "sql" from file /etc/freeradius/mods-enabled/sql > > sql { > > driver = "rlm_sql_mysql" > > server = "localhost" > > port = "3306" > > login = "radius" > > password = "fheman" > > radius_db = "radius" > > read_groups = yes > > read_clients = yes > > delete_stale_sessions = yes > > sql_user_name = "%{User-Name}" > > default_user_profile = "" > > client_query = "SELECT id, nasname, shortname, type, secret, server FROM nas" > > authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" > > authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" > > authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id" > > authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id" > > group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" > > simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" > > simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" > > safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" > > } > > accounting { > > reference = "%{tolower:type.%{Acct-Status-Type}.query}" > > } > > post-auth { > > reference = ".query" > > } > > mysql { > > tls { > > } > > } > > rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked > > rlm_sql (sql): Attempting to connect to database "radius" > > rlm_sql (sql): Initialising connection pool > > pool { > > start = 5 > > min = 4 > > max = 10 > > spare = 3 > > uses = 0 > > lifetime = 0 > > cleanup_delay = 5 > > idle_timeout = 60 > > spread = no > > } > > rlm_sql (sql): Opening additional connection (0) > > rlm_sql_mysql: Starting connect to MySQL server > > ...

3 3

FR 2.2.5 64 bit
by Mohd Alkhaldi 12 May '14

12 May '14

HI, Can FR 2.2.5 64 bit be compiled on Solaris 10. Thanks; Alwaad Alhaq

4 7

EAP-TTLS session resumption does not work.
by hashimotoku＠nttdata.co.jp 12 May '14

12 May '14

Hello FreeRadius mailing list users. I am using FreeRadius on our WiFi system. I enabled EAP-TTLS session resumption, but it seems the functionality does not work well. - Our system. (a)WiFi supplicant -- (b)WiFi access point -- (c)WiFi Controler -- (d)FreeRadius -- (e)RADIUS server (d) listen on 10.180.4.19:18120. (e) listen on 127.0.0.1:18150. (d) and (e) are installed on the same server. - Authentication Method. Outer authentication: EAP-TTLS Inner authentication: PAP We are using one-time-password on RADIUS server(e) for authentication. - Symptom. (1)[Near the access point A] I input my username and password (authenticate) on supplicant installed in my laptop PC, then I can connect our WiFi network. (2)[Move from the access point A to the access point B] I move my laptop PC. Access point hands over from A to B. (3)[Near the access point B] I lost WiFi connectivity. To connect WiFi again, I have to re-enter username and password. - Wish. I want to resume WiFi connectivity automatically without one-time-password authentication, when I move between WiFi access point. - FreeRadius version. 3.0.1 - Below is our configuration <radiusd.conf>. etcdir = /usr/local/freeradius/etc confdir = ${etcdir}/raddb pidfile = /var/run/radius/freeradius.pid max_requests = 1024 listen { ipaddr = 10.180.4.19 port = 18120 type = auth } authorize { eap } authenticate { eap } post-proxy { eap } server inner-tunnel { authorize { update control { Proxy-To-Realm := "tinyradius" } } authenticate { eap } } modules { eap { default_eap_type = ttls max_sessions = 16384 timer_expire = 120 tls-config tls-common { certsdir = ${confdir}/certs private_key_file = ${certsdir}/our.key certificate_file = ${certsdir}/our.cer dh_file = ${certsdir}/dh cache { enable = yes lifetime = 12 max_entries = 1024 } } ttls { tls = tls-common virtual_server = inner-tunnel } } } client 10.0.0.0/8 { secret = xxxx } realm tinyradius { authhost = 127.0.0.1:18150 secret = xxxx nostrip } log { destination = syslog facility = local1 } Regards. --- Kouki Hashimoto hashimotoku(a)nttdata.co.jp

3 2

RADIUS accounting request not sent: no response
by Osvaldo T Crispim Filho 11 May '14

11 May '14

A few days back here I started getting these messages on mikrotiks: " RADIUS accounting request not sent: no response " Any help? My environment: NAS: RB1100 e RB1100AHx2 NAS: APs Ubiquiti (WPAe EAP PEAP) Server: ubuntu 64 12:04 freeradius 2.1.10+dfsg-3ubuntu0.12.04.2 freeradius-postgresql Messages on freeradius: 00:35:05 hotspot,warning,debug 00:27:22:52:48:5B (1x7.19.xxx.xxx): RADIUS accounting request not sent: no response 00:35:06 hotspot,warning,debug 00:15:6D:F8:D6:2B (1x7.19.xxx.xx): RADIUS accounting request not sent: no response Sat May 10 21:26:30 2014 : Info: ++[preprocess] returns ok Sat May 10 21:26:30 2014 : Info: [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent Sat May 10 21:26:30 2014 : Info: [acct_unique] WARNING: Attribute Acct-Session-Id was not found in request, unique ID MAY be inconsistent Sat May 10 21:26:30 2014 : Info: [acct_unique] WARNING: Attribute User-Name was not found in request, unique ID MAY be inconsistent -- - Osvaldo T Crispim Filho -

2 3

Re: Freeradius.net Authentication wrong
by Serdar Metin 10 May '14

10 May '14

How can i achieve this? but there is also something else i noticed:for request 4auth: Failed to validate the user.Login incorrect: [bob/<no User-Password attribute>] (from client testing123 port 0 cli 00-1F-3B-B2-F5-09i'm 100 sure this user and some password is beeing saved in the users.conf file

4 5

LDAP for Authorization
by Walter Reynolds 10 May '14

10 May '14

I would like to use LDAP to be able to authorize a user so if there have a certain attribute I can return a radius AVP with a VLAN ID in the access-accept. This would be used for allowing access to licensed library resources. However, I am not sure if I can do this the way my LDAP stuff is set up. The attribute that has the data I need is multi-valued. - StudentAA, StudentDBRN, and StudentFLNT (continuing and incoming students regardless of enrollment; includes detached study); - EnrolledStudentAA, EnrolledStudentDBRN, EnrolledStudentFLNT (enrolled in at least one credit hour for ""current"" term; next term information is used during gap between terms) - AlumniAA, AlumniDBRN, AlumniFLNT (any person who has completed at least one semester in a degree-granting program) - FacultyAA, FacultyDBRN, FacultyFLNT (defined as academic, instructional, and research appointments; includes emeritus faculty) - RegularStaffAA, RegularStaffDBRN, RegularStaffFLNT (current appointment with a status of active, suspended, short-work break, leave, or paid leave); - TemporaryStaffAA, TemporaryStaffDBRN, TemporaryStaffFLNT (current appointment with a status of active, suspended, short-work break, leave, or paid leave) - Retiree (retired from any U-Mcampus, regardless of other appoints that may still be active) - SponsoredAffiliateAA, SponsoredAffiliateDBRN, SponsoredAffiliateFLNT (has at least one departmental sponsorship). However, only 5 of them (StudentAA, EnrolledStudentAA, FacultyAA, RegularStaffAA and TemoraryStaffAA) should get the radius AVP and be allowed access. However, when I query I get something like the following ldapsearch -h ldap.umich.edu -ZZ -z0 -x -D <cut> -b ou=people,dc=umich,dc=edu -LLL -s sub uniqueid=<username> umichinstroles dn: uid=royboy,ou=People,dc=umich,dc=edu umichinstroles: RegularStaffAA umichinstroles: AlumniFLNT So that is not realyy a group membership. Is this something I will be able to do? If not natively can folks mention other options/solutions? ------------------------ Walter Reynolds Principal Systems Security Development Engineer Information and Technology Services University of Michigan (734) 615-9438

2 1

LDAP for defining AVP
by Walter Reynolds 09 May '14

09 May '14

I would like to use LDAP to be able to authorize a user so if there have a certain attribute I can return a radius AVP with a VLAN ID in the access-accept. This would be used for allowing access to licensed library resources. However, I am not sure if I can do this the way my LDAP stuff is set up. The attribute that has the data I need is multi-valued. - StudentAA, StudentDBRN, and StudentFLNT (continuing and incoming students regardless of enrollment; includes detached study); - EnrolledStudentAA, EnrolledStudentDBRN, EnrolledStudentFLNT (enrolled in at least one credit hour for ""current"" term; next term information is used during gap between terms) - AlumniAA, AlumniDBRN, AlumniFLNT (any person who has completed at least one semester in a degree-granting program) - FacultyAA, FacultyDBRN, FacultyFLNT (defined as academic, instructional, and research appointments; includes emeritus faculty) - RegularStaffAA, RegularStaffDBRN, RegularStaffFLNT (current appointment with a status of active, suspended, short-work break, leave, or paid leave); - TemporaryStaffAA, TemporaryStaffDBRN, TemporaryStaffFLNT (current appointment with a status of active, suspended, short-work break, leave, or paid leave) - Retiree (retired from any U-Mcampus, regardless of other appoints that may still be active) - SponsoredAffiliateAA, SponsoredAffiliateDBRN, SponsoredAffiliateFLNT (has at least one departmental sponsorship). However, only 5 of them (StudentAA, EnrolledStudentAA, FacultyAA, RegularStaffAA and TemoraryStaffAA) should get the radius AVP and be allowed access. However, when I query I get something like the following ldapsearch -h ldap.umich.edu -ZZ -z0 -x -D <cut> -b ou=people,dc=umich,dc=edu -LLL -s sub uniqueid=<username> umichinstroles dn: uid=<username>,ou=People,dc=umich,dc=edu umichinstroles: RegularStaffAA umichinstroles: AlumniFLNT So that is not really a group membership. Is this something I will be able to do? If I can not do it natively can folks mention other options/solutions? ------------------------ ------------------------ Walter Reynolds Principal Systems Security Development Engineer Information and Technology Services University of Michigan (734) 615-9438

1 0