November 2012 - Freeradius-Users - lists.freeradius.org

Dynamic Home Server For Sending CoA
by Stanislav Lorenc 07 Nov '12

07 Nov '12

Hi, I have problem with Home servers for sending CoA packets. This service works fine, but i have clients in sql (rml_sql). When NAS are in sql, home servers for configuring coa must be in sql too. But now they are stationary in text file defined. Is there some way how to change this ? Or I overlook some configuration options or functionality ? Stanislav Lorenc

2 1

Wireless EAP-TLS Login from Notebook with User and PASSWORD
by sierramailpapa＠gmx.de 07 Nov '12

07 Nov '12

Hey there, I’ve setup a freeradius Server and am using EAP-TLS, and would need some help from you. The users file contains the username and the password beeing allowed to connect after TLS Connection has been established, and this is working on an android phone with no problems so far. One can setup the -CA Cert -User Cert -Login Name and -Password But I dont’t have an option to enter a password when I try to connect from the notebook, running Windows7. Is there an add on tool one can use to deliver the password as well, or do I have to drop the user-pass auth from ttls completely? FR is V2 EAP is set to allow TLS only Users file contains cleartext passwort auth (used from ttls, which has been used before) Thanks in advance and best regards Martin

2 1

Issue with MSCHAP
by Ryan Summey 06 Nov '12

06 Nov '12

Below is the log. I am able to connect using clear-text passwords but not encrypted passwords... What is confusing me is if i do a radtest it works fine using the users credentials that are encrypted... But as you can see below ths is me trying to connecting from my phone using the account i created in the databse with the password md5. Again this works when i do a radtest but not in a real world test. Only clear-text pw work in the realworld test. Thank you for your time. freeradius -X FreeRADIUS Version 2.1.12, for host i686-pc-linux-gnu, built on Sep 11 2012 at 22:27:08 Copyright (C) 1999-2009 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 v2. Starting - reading configuration files ... 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/modules/ including configuration file /etc/freeradius/modules/always including configuration file /etc/freeradius/modules/mac2ip including configuration file /etc/freeradius/modules/sql_log including configuration file /etc/freeradius/modules/smbpasswd including configuration file /etc/freeradius/modules/detail including configuration file /etc/freeradius/modules/smsotp including configuration file /etc/freeradius/modules/cui including configuration file /etc/freeradius/modules/wimax including configuration file /etc/freeradius/modules/replicate including configuration file /etc/freeradius/modules/sqlcounter_expire_on_login including configuration file /etc/freeradius/modules/sradutmp including configuration file /etc/freeradius/modules/pap including configuration file /etc/freeradius/modules/echo including configuration file /etc/freeradius/modules/expiration including configuration file /etc/freeradius/modules/files including configuration file /etc/freeradius/modules/mac2vlan including configuration file /etc/freeradius/modules/acct_unique including configuration file /etc/freeradius/modules/krb5 including configuration file /etc/freeradius/modules/mschap including configuration file /etc/freeradius/modules/checkval including configuration file /etc/freeradius/modules/preprocess including configuration file /etc/freeradius/modules/logintime including configuration file /etc/freeradius/modules/pam including configuration file /etc/freeradius/modules/passwd including configuration file /etc/freeradius/modules/etc_group including configuration file /etc/freeradius/modules/opendirectory including configuration file /etc/freeradius/modules/attr_filter including configuration file /etc/freeradius/modules/linelog including configuration file /etc/freeradius/modules/soh including configuration file /etc/freeradius/modules/attr_rewrite including configuration file /etc/freeradius/modules/chap including configuration file /etc/freeradius/modules/rediswho including configuration file /etc/freeradius/modules/counter including configuration file /etc/freeradius/modules/digest including configuration file /etc/freeradius/modules/policy including configuration file /etc/freeradius/modules/unix including configuration file /etc/freeradius/modules/ldap including configuration file /etc/freeradius/modules/otp including configuration file /etc/freeradius/modules/radutmp including configuration file /etc/freeradius/modules/perl including configuration file /etc/freeradius/modules/dynamic_clients including configuration file /etc/freeradius/modules/detail.example.com including configuration file /etc/freeradius/modules/redis including configuration file /etc/freeradius/modules/ntlm_auth including configuration file /etc/freeradius/modules/inner-eap including configuration file /etc/freeradius/modules/ippool including configuration file /etc/freeradius/modules/realm including configuration file /etc/freeradius/modules/detail.log including configuration file /etc/freeradius/modules/exec including configuration file /etc/freeradius/modules/expr including configuration file /etc/freeradius/eap.conf including configuration file /etc/freeradius/sql.conf including configuration file /etc/freeradius/sql/mysql/dialup.conf including configuration file /etc/freeradius/policy.conf including files in directory /etc/freeradius/sites-enabled/ including configuration file /etc/freeradius/sites-enabled/default including configuration file /etc/freeradius/sites-enabled/inner-tunnel main { user = "freerad" group = "freerad" allow_core_dumps = no } including dictionary file /etc/freeradius/dictionary 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 = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no } 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 require_message_authenticator = yes zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 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 = "testsecret" nastype = "other" } client 192.168.2.24 { require_message_authenticator = no secret = "testsecret" shortname = "cvpn-pptp" nastype = "other" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating module "exec" from file /etc/freeradius/modules/exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating module "expr" from file /etc/freeradius/modules/expr Module: Linked to module rlm_expiration Module: Instantiating module "expiration" from file /etc/freeradius/modules/expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating module "logintime" from file /etc/freeradius/modules/logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/radiusd.conf modules { Module: Creating Auth-Type = digest Module: Creating Post-Auth-Type = REJECT Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating module "pap" from file /etc/freeradius/modules/pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating module "chap" from file /etc/freeradius/modules/chap Module: Linked to module rlm_mschap Module: Instantiating module "mschap" from file /etc/freeradius/modules/mschap mschap { use_mppe = yes require_encryption = yes require_strong = yes with_ntdomain_hack = no allow_retry = yes } Module: Linked to module rlm_digest Module: Instantiating module "digest" from file /etc/freeradius/modules/digest Module: Linked to module rlm_unix Module: Instantiating module "unix" from file /etc/freeradius/modules/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating module "eap" from file /etc/freeradius/eap.conf eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 4096 } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 Module: Linked to sub-module rlm_eap_leap Module: Instantiating eap-leap Module: Linked to sub-module rlm_eap_gtc Module: Instantiating eap-gtc gtc { challenge = "Password: " auth_type = "PAP" } Module: Linked to sub-module rlm_eap_tls Module: Instantiating eap-tls tls { 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.key" certificate_file = "/etc/freeradius/certs/server.pem" CA_file = "/etc/freeradius/certs/ca.pem" private_key_password = "whatever" dh_file = "/etc/freeradius/certs/dh" random_file = "/dev/urandom" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/etc/freeradius/certs/bootstrap" ecdh_curve = "prime256v1" cache { enable = no lifetime = 24 max_entries = 255 } verify { } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" } } Module: Linked to sub-module rlm_eap_ttls Module: Instantiating eap-ttls ttls { default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes } Module: Linked to sub-module rlm_eap_peap Module: Instantiating eap-peap peap { default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_preprocess Module: Instantiating module "preprocess" from file /etc/freeradius/modules/preprocess preprocess { huntgroups = "/etc/freeradius/huntgroups" hints = "/etc/freeradius/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 } Module: Linked to module rlm_realm Module: Instantiating module "suffix" from file /etc/freeradius/modules/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_files Module: Instantiating module "files" from file /etc/freeradius/modules/files files { usersfile = "/etc/freeradius/users" acctusersfile = "/etc/freeradius/acct_users" preproxy_usersfile = "/etc/freeradius/preproxy_users" compat = "no" } Module: Linked to module rlm_sql Module: Instantiating module "sql" from file /etc/freeradius/sql.conf sql { driver = "rlm_sql_mysql" server = "mysql.claravpn.com" port = "3306" login = "cvpnadmin" password = "106westwhiteoakstreet" radius_db = "cvpnradiusdb" read_groups = yes sqltrace = no sqltracefile = "/var/log/freeradius/sqltrace.sql" readclients = no deletestalesessions = yes num_sql_socks = 5 lifetime = 0 max_queries = 0 sql_user_name = "%{User-Name}" default_user_profile = "" nas_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" accounting_onoff_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = unix_timestamp('%S') - unix_timestamp(acctstarttime), acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = %{%{Acct-Delay-Time}:-0} WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= '%S'" accounting_update_query = " UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_update_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query_alt = " UPDATE radacct SET acctstarttime = '%S', acctstartdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_start = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{%{Acct-Delay-Time}:-0}')" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" connect_failure_retry_delay = 60 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" postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to cvpnadmin@mysql.claravpn.com:3306/cvpnradiusdb rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating module "acct_unique" from file /etc/freeradius/modules/acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } Module: Checking accounting {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating module "detail" from file /etc/freeradius/modules/detail detail { detailfile = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Linked to module rlm_radutmp Module: Instantiating module "radutmp" from file /etc/freeradius/modules/radutmp radutmp { filename = "/var/log/freeradius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes perm = 384 callerid = yes } Module: Linked to module rlm_attr_filter Module: Instantiating module "attr_filter.accounting_response" from file /etc/freeradius/modules/attr_filter attr_filter attr_filter.accounting_response { attrsfile = "/etc/freeradius/attrs.accounting_response" key = "%{User-Name}" relaxed = no } Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load Module: Instantiating module "attr_filter.access_reject" from file /etc/freeradius/modules/attr_filter attr_filter attr_filter.access_reject { attrsfile = "/etc/freeradius/attrs.access_reject" key = "%{User-Name}" relaxed = no } } # modules } # server server inner-tunnel { # from file /etc/freeradius/sites-enabled/inner-tunnel modules { Module: Checking authenticate {...} for more modules to load Module: Checking authorize {...} for more modules to load Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load } # modules } # server radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = * port = 0 } listen { type = "acct" ipaddr = * port = 0 } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } ... adding new socket proxy address * port 48747 Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 192.168.2.24 port 37360, id=33, length=151 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "md5sonder" MS-CHAP-Challenge = 0x0450cfc169281de4596f775878e83202 MS-CHAP2-Response = 0x50002036d573a3f3f443f0adaaf52b1557b300000000000000004fab1da0b14e7e7827768b24019d9c9e41dec2d11872bbad Calling-Station-Id = "97.218.49.75" NAS-IP-Address = 127.0.0.1 NAS-Port = 0 # Executing section authorize from file /etc/freeradius/sites-enabled/default +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop [mschap] Found MS-CHAP attributes. Setting 'Auth-Type = mschap' ++[mschap] returns ok ++[digest] returns noop [suffix] No '@' in User-Name = "md5sonder", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop [files] users: Matched entry DEFAULT at line 172 ++[files] returns ok [sql] expand: %{User-Name} -> md5sonder [sql] sql_set_user escaped user --> 'md5sonder' rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'md5sonder' ORDER BY id [sql] User found in radcheck table [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'md5sonder' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'md5sonder' ORDER BY priority rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop [pap] Normalizing MD5-Password from hex encoding [pap] WARNING: Auth-Type already set. Not setting to PAP ++[pap] returns noop Found Auth-Type = MSCHAP # Executing group from file /etc/freeradius/sites-enabled/default +- entering group MS-CHAP {...} [mschap] No Cleartext-Password configured. Cannot create LM-Password. [mschap] No Cleartext-Password configured. Cannot create NT-Password. [mschap] Creating challenge hash with username: md5sonder [mschap] Told to do MS-CHAPv2 for md5sonder with NT-Password [mschap] FAILED: No NT/LM-Password. Cannot perform authentication. [mschap] FAILED: MS-CHAP2-Response is incorrect ++[mschap] returns reject Failed to authenticate the user. Using Post-Auth-Type Reject # Executing group from file /etc/freeradius/sites-enabled/default +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} -> md5sonder attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.6 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 33 to 192.168.2.24 port 37360 MS-CHAP-Error = "PE=691 R=1" Waking up in 4.9 seconds. Cleaning up request 0 ID 33 with timestamp +121 Ready to process requests.

6 16

log error
by Miha 06 Nov '12

06 Nov '12

Hi, I am looking at this log radius file. What could be causing this? BR; Miha Mon Nov 5 08:35:03 2012 : Error: Discarding duplicate request from client intraswitch port 46634 - ID: 134 due to unfinished request 11902 Mon Nov 5 08:35:03 2012 : Error: Discarding duplicate request from client intraswitch port 40649 - ID: 231 due to unfinished request 11904 Mon Nov 5 09:10:02 2012 : Error: Discarding duplicate request from client intraswitch port 55647 - ID: 187 due to unfinished request 16624 Mon Nov 5 09:10:02 2012 : Error: Discarding duplicate request from client intraswitch port 57890 - ID: 139 due to unfinished request 16626 Mon Nov 5 09:25:03 2012 : Error: Discarding duplicate request from client intraswitch port 46201 - ID: 179 due to unfinished request 19014 Mon Nov 5 09:40:03 2012 : Error: Discarding duplicate request from client intraswitch port 38970 - ID: 184 due to unfinished request 21166 Mon Nov 5 09:45:02 2012 : Error: Discarding duplicate request from client intraswitch port 46440 - ID: 227 due to unfinished request 21746 Mon Nov 5 09:50:02 2012 : Error: Discarding duplicate request from client intraswitch port 57355 - ID: 116 due to unfinished request 22475 Mon Nov 5 09:55:03 2012 : Error: Discarding duplicate request from client intraswitch port 48695 - ID: 154 due to unfinished request 23172 Mon Nov 5 10:00:02 2012 : Error: Discarding duplicate request from client intraswitch port 49085 - ID: 121 due to unfinished request 24106 Mon Nov 5 10:10:02 2012 : Error: Discarding duplicate request from client intraswitch port 36544 - ID: 26 due to unfinished request 25411 Mon Nov 5 10:20:02 2012 : Error: Discarding duplicate request from client intraswitch port 42534 - ID: 6 due to unfinished request 26755 Mon Nov 5 10:30:02 2012 : Error: Discarding duplicate request from client intraswitch port 32994 - ID: 173 due to unfinished request 28238 Mon Nov 5 11:00:03 2012 : Error: Discarding duplicate request from client intraswitch port 54529 - ID: 67 due to unfinished request 32859 Mon Nov 5 11:15:02 2012 : Error: Discarding duplicate request from client intraswitch port 56675 - ID: 60 due to unfinished request 35280 Mon Nov 5 11:45:02 2012 : Error: Discarding duplicate request from client intraswitch port 60703 - ID: 225 due to unfinished request 39541 Mon Nov 5 12:03:12 2012 : Error: Discarding duplicate request from client intraswitch port 51296 - ID: 245 due to unfinished request 41695 Mon Nov 5 12:15:02 2012 : Error: Discarding duplicate request from client intraswitch port 35090 - ID: 24 due to unfinished request 42950 Mon Nov 5 12:20:02 2012 : Error: Discarding duplicate request from client intraswitch port 39325 - ID: 171 due to unfinished request 43408 Mon Nov 5 12:30:03 2012 : Error: Discarding duplicate request from client intraswitch port 36165 - ID: 89 due to unfinished request 44456 Mon Nov 5 12:40:02 2012 : Error: Discarding duplicate request from client intraswitch port 54846 - ID: 219 due to unfinished request 45559 Mon Nov 5 12:45:02 2012 : Error: Discarding duplicate request from client intraswitch port 41737 - ID: 239 due to unfinished request 46056 Mon Nov 5 12:50:02 2012 : Error: Discarding duplicate request from client intraswitch port 34792 - ID: 111 due to unfinished request 46529 Mon Nov 5 13:05:02 2012 : Error: Discarding duplicate request from client intraswitch port 56632 - ID: 231 due to unfinished request 48180 Mon Nov 5 13:25:03 2012 : Error: Discarding duplicate request from client intraswitch port 50078 - ID: 75 due to unfinished request 50845 Mon Nov 5 13:45:02 2012 : Error: Discarding duplicate request from client intraswitch port 33412 - ID: 88 due to unfinished request 53659 Mon Nov 5 14:45:02 2012 : Error: Discarding duplicate request from client intraswitch port 50311 - ID: 25 due to unfinished request 60391 Mon Nov 5 15:03:05 2012 : Error: Discarding duplicate request from client intraswitch port 60010 - ID: 57 due to unfinished request 62264 Mon Nov 5 15:03:06 2012 : Error: Discarding duplicate request from client intraswitch port 35760 - ID: 215 due to unfinished request 62265 Mon Nov 5 15:03:06 2012 : Error: Discarding duplicate request from client intraswitch port 38622 - ID: 31 due to unfinished request 62266 Mon Nov 5 15:03:06 2012 : Error: Discarding duplicate request from client intraswitch port 33797 - ID: 214 due to unfinished request 62267 Mon Nov 5 15:03:06 2012 : Error: Discarding duplicate request from client intraswitch port 60010 - ID: 57 due to unfinished request 62264 Mon Nov 5 15:03:08 2012 : Error: Discarding duplicate request from client intraswitch port 40499 - ID: 176 due to unfinished request 62271 Mon Nov 5 15:03:08 2012 : Error: Discarding duplicate request from client intraswitch port 49325 - ID: 154 due to unfinished request 62272 Mon Nov 5 15:03:09 2012 : Error: Discarding duplicate request from client intraswitch port 40499 - ID: 176 due to unfinished request 62271 Mon Nov 5 15:03:09 2012 : Error: Discarding duplicate request from client intraswitch port 49325 - ID: 154 due to unfinished request 62272 Mon Nov 5 15:03:10 2012 : Error: Discarding duplicate request from client intraswitch port 40499 - ID: 176 due to unfinished request 62271 Mon Nov 5 15:03:10 2012 : Error: Discarding duplicate request from client intraswitch port 49325 - ID: 154 due to unfinished request 62272 Mon Nov 5 15:03:11 2012 : Error: Discarding duplicate request from client intraswitch port 46918 - ID: 219 due to unfinished request 62273 Mon Nov 5 15:03:11 2012 : Error: Discarding duplicate request from client intraswitch port 40499 - ID: 176 due to unfinished request 62271 Mon Nov 5 15:03:12 2012 : Error: Discarding duplicate request from client intraswitch port 49325 - ID: 154 due to unfinished request 62272 Mon Nov 5 15:03:12 2012 : Error: Discarding duplicate request from client intraswitch port 40499 - ID: 176 due to unfinished request 62271 Mon Nov 5 15:03:12 2012 : Error: Discarding duplicate request from client intraswitch port 54468 - ID: 21 due to unfinished request 62274 Mon Nov 5 15:03:12 2012 : Error: Discarding duplicate request from client intraswitch port 46918 - ID: 219 due to unfinished request 62273 Mon Nov 5 15:03:12 2012 : Error: Discarding duplicate request from client intraswitch port 49325 - ID: 154 due to unfinished request 62272 Mon Nov 5 15:03:12 2012 : Error: Discarding duplicate request from client intraswitch port 54468 - ID: 21 due to unfinished request 62274 Mon Nov 5 15:03:13 2012 : Error: Discarding duplicate request from client intraswitch port 46918 - ID: 219 due to unfinished request 62273 Mon Nov 5 15:03:13 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0 Mon Nov 5 15:03:13 2012 : Error: Discarding duplicate request from client intraswitch port 58481 - ID: 132 due to unfinished request 62275 Mon Nov 5 15:03:13 2012 : Error: Discarding duplicate request from client intraswitch port 54468 - ID: 21 due to unfinished request 62274 Mon Nov 5 15:03:14 2012 : Error: Discarding duplicate request from client intraswitch port 46918 - ID: 219 due to unfinished request 62273 Mon Nov 5 15:03:14 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0 Mon Nov 5 15:03:14 2012 : Error: Discarding duplicate request from client intraswitch port 58481 - ID: 132 due to unfinished request 62275 Mon Nov 5 15:03:14 2012 : Error: Discarding duplicate request from client intraswitch port 54468 - ID: 21 due to unfinished request 62274 Mon Nov 5 15:03:15 2012 : Error: Discarding duplicate request from client intraswitch port 46918 - ID: 219 due to unfinished request 62273 Mon Nov 5 15:03:15 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0 Mon Nov 5 15:03:15 2012 : Error: Discarding duplicate request from client intraswitch port 58481 - ID: 132 due to unfinished request 62275 Mon Nov 5 15:03:15 2012 : Error: Discarding duplicate request from client intraswitch port 54468 - ID: 21 due to unfinished request 62274 Mon Nov 5 15:03:16 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0 Mon Nov 5 15:03:16 2012 : Error: Discarding duplicate request from client intraswitch port 58481 - ID: 132 due to unfinished request 62275 Mon Nov 5 15:03:17 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0 Mon Nov 5 15:03:17 2012 : Error: Discarding duplicate request from client intraswitch port 58481 - ID: 132 due to unfinished request 62275 Mon Nov 5 15:03:18 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0 Mon Nov 5 15:03:19 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0 Mon Nov 5 15:03:20 2012 : Error: rlm_sql (sql2): There are no DB handles to use! skipped 0, tried to connect 0

4 5

rlm_perl and threads
by Edgar Fuß 05 Nov '12

05 Nov '12

Sorry if this sounds like a stupid question with an obvious answer, but I could not easily find this documented. If I have an rlm_perl script, is it possible that multiple instances of it are running concurrently due to FreeRADIUS' threading?

2 3

simultaneous-Use is not worrking
by Miha 04 Nov '12

04 Nov '12

Hi there, i am turning out you due to issue with simultaneous-Use. I readed mailing list but did not find any appropriate answer. My configuration: .../raddb/site-avalible/default: session {mysql} .../raddb/sql/mysql/dialup.conf: uncomment simul_count_query.. In radcheck I have put user with cleartext password and also add line for this user with simultaneous-Use :=1. When I try to call with simultaneous-Use :=1 call is rejacted if I put simultaneous-Use :=2 all calls goes through from this account. NAS is sending start/stop packet and If call is in progress there is a NULL value in acc stop time raw. Accounting and authorization is uncomment:) my config: [root@localhost sites-available]# radiusd -X FreeRADIUS Version 2.1.12, for host x86_64-unknown-linux-gnu, built on Nov 8 2011 at 15:23:48 Copyright (C) 1999-2009 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 v2. Starting - reading configuration files ... including configuration file /usr/local/etc/raddb/radiusd.conf including configuration file /usr/local/etc/raddb/proxy.conf including configuration file /usr/local/etc/raddb/clients.conf including files in directory /usr/local/etc/raddb/modules/ including configuration file /usr/local/etc/raddb/modules/policy including configuration file /usr/local/etc/raddb/modules/realm including configuration file /usr/local/etc/raddb/modules/acct_unique including configuration file /usr/local/etc/raddb/modules/krb5 including configuration file /usr/local/etc/raddb/modules/files including configuration file /usr/local/etc/raddb/modules/mac2ip including configuration file /usr/local/etc/raddb/modules/detail including configuration file /usr/local/etc/raddb/modules/inner-eap including configuration file /usr/local/etc/raddb/modules/sqlcounter_expire_on_login including configuration file /usr/local/etc/raddb/modules/linelog including configuration file /usr/local/etc/raddb/modules/detail.example.com including configuration file /usr/local/etc/raddb/modules/counter including configuration file /usr/local/etc/raddb/modules/ippool including configuration file /usr/local/etc/raddb/modules/echo including configuration file /usr/local/etc/raddb/modules/smsotp including configuration file /usr/local/etc/raddb/modules/unix including configuration file /usr/local/etc/raddb/modules/mschap including configuration file /usr/local/etc/raddb/modules/perl including configuration file /usr/local/etc/raddb/modules/detail.log including configuration file /usr/local/etc/raddb/modules/replicate including configuration file /usr/local/etc/raddb/modules/always including configuration file /usr/local/etc/raddb/modules/wimax including configuration file /usr/local/etc/raddb/modules/mac2vlan including configuration file /usr/local/etc/raddb/modules/attr_filter including configuration file /usr/local/etc/raddb/modules/opendirectory including configuration file /usr/local/etc/raddb/modules/soh including configuration file /usr/local/etc/raddb/modules/sql_log including configuration file /usr/local/etc/raddb/modules/etc_group including configuration file /usr/local/etc/raddb/modules/preprocess including configuration file /usr/local/etc/raddb/modules/redis including configuration file /usr/local/etc/raddb/modules/logintime including configuration file /usr/local/etc/raddb/modules/pap including configuration file /usr/local/etc/raddb/modules/expiration including configuration file /usr/local/etc/raddb/modules/rediswho including configuration file /usr/local/etc/raddb/modules/smbpasswd including configuration file /usr/local/etc/raddb/modules/chap including configuration file /usr/local/etc/raddb/modules/dynamic_clients including configuration file /usr/local/etc/raddb/modules/radutmp including configuration file /usr/local/etc/raddb/modules/ldap including configuration file /usr/local/etc/raddb/modules/cui including configuration file /usr/local/etc/raddb/modules/exec including configuration file /usr/local/etc/raddb/modules/passwd including configuration file /usr/local/etc/raddb/modules/attr_rewrite including configuration file /usr/local/etc/raddb/modules/ntlm_auth including configuration file /usr/local/etc/raddb/modules/expr including configuration file /usr/local/etc/raddb/modules/digest including configuration file /usr/local/etc/raddb/modules/otp including configuration file /usr/local/etc/raddb/modules/sradutmp including configuration file /usr/local/etc/raddb/modules/checkval including configuration file /usr/local/etc/raddb/modules/pam including configuration file /usr/local/etc/raddb/eap.conf including configuration file /usr/local/etc/raddb/sql.conf including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf including configuration file /usr/local/etc/raddb/policy.conf including files in directory /usr/local/etc/raddb/sites-enabled/ including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel including configuration file /usr/local/etc/raddb/sites-enabled/control-socket including configuration file /usr/local/etc/raddb/sites-enabled/default main { allow_core_dumps = no } including dictionary file /usr/local/etc/raddb/dictionary main { name = "radiusd" prefix = "/usr/local" localstatedir = "/usr/local/var" sbindir = "/usr/local/sbin" logdir = "/usr/local/var/log/radius" run_dir = "/usr/local/var/run/radiusd" libdir = "/usr/local/lib" radacctdir = "/usr/local/var/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/usr/local/var/run/radiusd/radiusd.pid" checkrad = "/usr/local/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no } 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 require_message_authenticator = yes zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 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 = "testing123" nastype = "other" } client xxx.xxx.xxx.xxx { require_message_authenticator = no secret = "test1234" } client xxx.xxx.xxx.xxx{ require_message_authenticator = no secret = "test1234" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating module "exec" from file /usr/local/etc/raddb/modules/exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating module "expr" from file /usr/local/etc/raddb/modules/expr Module: Linked to module rlm_expiration Module: Instantiating module "expiration" from file /usr/local/etc/raddb/modules/expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating module "logintime" from file /usr/local/etc/raddb/modules/logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server { # from file /usr/local/etc/raddb/radiusd.conf modules { Module: Creating Auth-Type = digest Module: Creating Post-Auth-Type = REJECT Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating module "pap" from file /usr/local/etc/raddb/modules/pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating module "chap" from file /usr/local/etc/raddb/modules/chap Module: Linked to module rlm_mschap Module: Instantiating module "mschap" from file /usr/local/etc/raddb/modules/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no allow_retry = yes } Module: Linked to module rlm_digest Module: Instantiating module "digest" from file /usr/local/etc/raddb/modules/digest Module: Linked to module rlm_unix Module: Instantiating module "unix" from file /usr/local/etc/raddb/modules/unix unix { radwtmp = "/usr/local/var/log/radius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating module "eap" from file /usr/local/etc/raddb/eap.conf eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 4096 } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 Module: Linked to sub-module rlm_eap_leap Module: Instantiating eap-leap Module: Linked to sub-module rlm_eap_gtc Module: Instantiating eap-gtc gtc { challenge = "Password: " auth_type = "PAP" } Module: Linked to sub-module rlm_eap_tls Module: Instantiating eap-tls tls { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 CA_path = "/usr/local/etc/raddb/certs" pem_file_type = yes private_key_file = "/usr/local/etc/raddb/certs/server.pem" certificate_file = "/usr/local/etc/raddb/certs/server.pem" CA_file = "/usr/local/etc/raddb/certs/ca.pem" private_key_password = "whatever" dh_file = "/usr/local/etc/raddb/certs/dh" random_file = "/usr/local/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/usr/local/etc/raddb/certs/bootstrap" cache { enable = no lifetime = 24 max_entries = 255 } verify { } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" } } Module: Linked to sub-module rlm_eap_ttls Module: Instantiating eap-ttls ttls { default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes } Module: Linked to sub-module rlm_eap_peap Module: Instantiating eap-peap peap { default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_preprocess Module: Instantiating module "preprocess" from file /usr/local/etc/raddb/modules/preprocess preprocess { huntgroups = "/usr/local/etc/raddb/huntgroups" hints = "/usr/local/etc/raddb/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 } Module: Linked to module rlm_realm Module: Instantiating module "suffix" from file /usr/local/etc/raddb/modules/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_files Module: Instantiating module "files" from file /usr/local/etc/raddb/modules/files files { usersfile = "/usr/local/etc/raddb/users" acctusersfile = "/usr/local/etc/raddb/acct_users" preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" compat = "no" } Module: Linked to module rlm_sql Module: Instantiating module "sql" from file /usr/local/etc/raddb/sql.conf sql { driver = "rlm_sql_mysql" server = "localhost" port = "" login = "root" password = "soft1234" radius_db = "radius" read_groups = yes sqltrace = no sqltracefile = "/usr/local/var/log/radius/sqltrace.sql" readclients = no deletestalesessions = yes num_sql_socks = 5 lifetime = 0 max_queries = 0 sql_user_name = "%{User-Name}" default_user_profile = "" nas_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" accounting_onoff_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = unix_timestamp('%S') - unix_timestamp(acctstarttime), acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = %{%{Acct-Delay-Time}:-0} WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= '%S'" accounting_update_query = " UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_update_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{Freeswitch-Src}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query_alt = " UPDATE radacct SET acctstarttime = '%S', acctstartdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_start = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query = " UPDATE radacct SET acctstoptime = '%S', username = '%Freeswitch-Src', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', calledstationid = '%{Freeswitch-Src}', callingstationid = '%{Freeswitch-Dst}', acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{Freeswitch-Src}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Freeswitch-Dst}', '%{Freeswitch-Src}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{%{Acct-Delay-Time}:-0}')" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" connect_failure_retry_delay = 60 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" postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating module "acct_unique" from file /usr/local/etc/raddb/modules/acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } Module: Checking accounting {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating module "detail" from file /usr/local/etc/raddb/modules/detail detail { detailfile = "/usr/local/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Linked to module rlm_radutmp Module: Instantiating module "radutmp" from file /usr/local/etc/raddb/modules/radutmp radutmp { filename = "/usr/local/var/log/radius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes perm = 384 callerid = yes } Module: Linked to module rlm_attr_filter Module: Instantiating module "attr_filter.accounting_response" from file /usr/local/etc/raddb/modules/attr_filter attr_filter attr_filter.accounting_response { attrsfile = "/usr/local/etc/raddb/attrs.accounting_response" key = "%{User-Name}" relaxed = no } Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load } # modules } # server server inner-tunnel { # from file /usr/local/etc/raddb/sites-enabled/inner-tunnel modules { Module: Checking authenticate {...} for more modules to load Module: Checking authorize {...} for more modules to load Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load Module: Instantiating module "attr_filter.access_reject" from file /usr/local/etc/raddb/modules/attr_filter attr_filter attr_filter.access_reject { attrsfile = "/usr/local/etc/raddb/attrs.access_reject" key = "%{User-Name}" relaxed = no } } # modules } # server radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = * port = 0 } listen { type = "acct" ipaddr = * port = 0 } listen { type = "control" listen { socket = "/usr/local/var/run/radiusd/radiusd.sock" } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } ... adding new socket proxy address * port 44469 Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /usr/local/var/run/radiusd/radiusd.sock Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. Thanks! Miha

2 3

Server Crashes
by Eric Geier 03 Nov '12

03 Nov '12

The server keeps crashing, sometimes within 10 minutes or sometimes after weeks. I'm using the supervise command to start/run it and here's what I get after it crashes. Please help. Is there a setting I should tweak or check? I'm running 1.1.8 and yes I should upgrade, but could you please still help. Thanks! Thu Nov 1 06:38:36 2012 : Info: Starting - reading configuration files ... *** glibc detected *** /usr/sbin/freeradius: corrupted double-linked list: 0x00007f9334d88e30 *** ======= Backtrace: ========= /lib/libc.so.6(+0x71bd6)[0x7f93319dcbd6] /lib/libc.so.6(+0x73608)[0x7f93319de608] /lib/libc.so.6(cfree+0x6c)[0x7f93319e194c] /usr/lib/freeradius/libradius-1.1.8.so(pairfree+0x2c)[0x7f93327acedc] /usr/lib/freeradius/libradius-1.1.8.so(rad_free+0x37)[0x7f93327a74f7] /usr/sbin/freeradius(request_free+0x3d)[0x7f93332381ed] /usr/sbin/freeradius(rl_delete+0x100)[0x7f9333233ae0] /usr/sbin/freeradius(+0x15cc0)[0x7f9333233cc0] /usr/sbin/freeradius(rl_walk+0x46)[0x7f9333233056] /usr/sbin/freeradius(rl_clean_list+0x83)[0x7f93332341b3] /usr/sbin/freeradius(main+0xc34)[0x7f9333231974] /lib/libc.so.6(__libc_start_main+0xfd)[0x7f9331989c8d] /usr/sbin/freeradius(+0x83e9)[0x7f93332263e9] ======= Memory map: ======== 7f9328000000-7f9328021000 rw-p 00000000 00:00 0 7f9328021000-7f932c000000 ---p 00000000 00:00 0 7f932d401000-7f932d404000 r-xp 00000000 ca:01 16913553 /usr/lib/freeradius/rlm_radutmp-1.1.8.so 7f932d404000-7f932d603000 ---p 00003000 ca:01 16913553 /usr/lib/freeradius/rlm_radutmp-1.1.8.so 7f932d603000-7f932d604000 rw-p 00002000 ca:01 16913553 /usr/lib/freeradius/rlm_radutmp-1.1.8.so 7f932d604000-7f932d608000 r-xp 00000000 ca:01 16913951 /usr/lib/freeradius/rlm_unix-1.1.8.so 7f932d608000-7f932d807000 ---p 00004000 ca:01 16913951 /usr/lib/freeradius/rlm_unix-1.1.8.so 7f932d807000-7f932d808000 rw-p 00003000 ca:01 16913951 /usr/lib/freeradius/rlm_unix-1.1.8.so 7f932d808000-7f932d80b000 r-xp 00000000 ca:01 16913182 /usr/lib/freeradius/rlm_detail-1.1.8.so 7f932d80b000-7f932da0a000 ---p 00003000 ca:01 16913182 /usr/lib/freeradius/rlm_detail-1.1.8.so 7f932da0a000-7f932da0b000 rw-p 00002000 ca:01 16913182 /usr/lib/freeradius/rlm_detail-1.1.8.so 7f932da0b000-7f932da0d000 r-xp 00000000 ca:01 16875849 /usr/lib/freeradius/rlm_acct_unique-1.1.8.so 7f932da0d000-7f932dc0c000 ---p 00002000 ca:01 16875849 /usr/lib/freeradius/rlm_acct_unique-1.1.8.so 7f932dc0c000-7f932dc0d000 rw-p 00001000 ca:01 16875849 /usr/lib/freeradius/rlm_acct_unique-1.1.8.so 7f932dc0d000-7f932dc23000 r-xp 00000000 ca:01 16777649 /lib/libgcc_s.so.1 7f932dc23000-7f932de22000 ---p 00016000 ca:01 16777649 /lib/libgcc_s.so.1 7f932de22000-7f932de23000 rw-p 00015000 ca:01 16777649 /lib/libgcc_s.so.1 7f932de23000-7f932de24000 ---p 00000000 00:00 0 7f932de24000-7f932e624000 rw-p 00000000 00:00 0 7f932e624000-7f932e6a4000 r-xp 00000000 ca:01 18344792 /lib/libm-2.11.3.so 7f932e6a4000-7f932e8a4000 ---p 00080000 ca:01 18344792 /lib/libm-2.11.3.so 7f932e8a4000-7f932e8a5000 r--p 00080000 ca:01 18344792 /lib/libm-2.11.3.so 7f932e8a5000-7f932e8a6000 rw-p 00081000 ca:01 18344792 /lib/libm-2.11.3.so 7f932e8a6000-7f932ea72000 r-xp 00000000 ca:01 33668983 /usr/lib/libmysqlclient_r.so.16.0.0 7f932ea72000-7f932ec72000 ---p 001cc000 ca:01 33668983 /usr/lib/libmysqlclient_r.so.16.0.0 7f932ec72000-7f932ec7a000 r--p 001cc000 ca:01 33668983 /usr/lib/libmysqlclient_r.so.16.0.0 7f932ec7a000-7f932ecc4000 rw-p 001d4000 ca:01 33668983 /usr/lib/libmysqlclient_r.so.16.0.0 7f932ecc4000-7f932ecc6000 rw-p 00000000 00:00 0 7f932ecc6000-7f932ecc8000 r-xp 00000000 ca:01 16875827 /usr/lib/freeradius/rlm_sql_mysql-1.1.8.so 7f932ecc8000-7f932eec7000 ---p 00002000 ca:01 16875827 /usr/lib/freeradius/rlm_sql_mysql-1.1.8.so 7f932eec7000-7f932eec8000 rw-p 00001000 ca:01 16875827 /usr/lib/freeradius/rlm_sql_mysql-1.1.8.so 7f932eec8000-7f932eed0000 r-xp 00000000 ca:01 16913564 /usr/lib/freeradius/rlm_sql-1.1.8.so 7f932eed0000-7f932f0cf000 ---p 00008000 ca:01 16913564 /usr/lib/freeradius/rlm_sql-1.1.8.so 7f932f0cf000-7f932f0d0000 rw-p 00007000 ca:01 16913564 /usr/lib/freeradius/rlm_sql-1.1.8.so 7f932f0d0000-7f932f0d2000 r-xp 00000000 ca:01 16913425 /usr/lib/freeradius/rlm_files-1.1.8.so 7f932f0d2000-7f932f2d2000 ---p 00002000 ca:01 16913425 /usr/lib/freeradius/rlm_files-1.1.8.so 7f932f2d2000-7f932f2d3000 rw-p 00002000 ca:01 16913425 /usr/lib/freeradius/rlm_files-1.1.8.so 7f932f2d3000-7f932f2d5000 r-xp 00000000 ca:01 16913563 /usr/lib/freeradius/rlm_realm-1.1.8.so 7f932f2d5000-7f932f4d4000 ---p 00002000 ca:01 16913563 /usr/lib/freeradius/rlm_realm-1.1.8.so 7f932f4d4000-7f932f4d5000 rw-p 00001000 ca:01 16913563 /usr/lib/freeradius/rlm_realm-1.1.8.so 7f932f4d5000-7f932f4d7000 r-xp 00000000 ca:01 16913511 /usr/lib/freeradius/rlm_preprocess-1.1.8.so 7f932f4d7000-7f932f6d7000 ---p 00002000 ca:01 16913511 /usr/lib/freeradius/rlm_preprocess-1.1.8.so 7f932f6d7000-7f932f6d8000 rw-p 00002000 ca:01 16913511 /usr/lib/freeradius/rlm_preprocess-1.1.8.so 7f932f6d8000-7f932f6da000 r-xp 00000000 ca:01 16913213 /usr/lib/freeradius/rlm_eap_mschapv2-1.1.8.so 7f932f6da000-7f932f8da000 ---p 00002000 ca:01 16913213 /usr/lib/freeradius/rlm_eap_mschapv2-1.1.8.so 7f932f8da000-7f932f8db000 rw-p 00002000 ca:01 16913213 /usr/lib/freeradius/rlm_eap_mschapv2-1.1.8.so 7f932f8db000-7f932f8df000 r-xp 00000000 ca:01 16913384 /usr/lib/freeradius/rlm_eap_peap-1.1.8.so 7f932f8df000-7f932fadf000 ---p 00004000 ca:01 16913384 /usr/lib/freeradius/rlm_eap_peap-1.1.8.so 7f932fadf000-7f932fae0000 rw-p 00004000 ca:01 16913384 /usr/lib/freeradius/rlm_eap_peap-1.1.8.so 7f932fae0000-7f932fae4000 r-xp 00000000 ca:01 16913408 /usr/lib/freeradius/rlm_eap_ttls-1.1.8.so 7f932fae4000-7f932fce4000 ---p 00004000 ca:01 16913408 /usr/lib/freeradius/rlm_eap_ttls-1.1.8.so 7f932fce4000-7f932fce5000 rw-p 00004000 ca:01 16913408 /usr/lib/freeradius/rlm_eap_ttls-1.1.8.so 7f932fce5000-7f932fce9000 r-xp 00000000 ca:01 16913403 /usr/lib/freeradius/rlm_eap_tls-1.1.8.so 7f932fce9000-7f932fee8000 ---p 00004000 ca:01 16913403 /usr/lib/freeradius/rlm_eap_tls-1.1.8.so 7f932fee8000-7f932fee9000 rw-p 00003000 ca:01 16913403 /usr/lib/freeradius/rlm_eap_tls-1.1.8.so 7f932fee9000-7f932feeb000 r-xp 00000000 ca:01 16913198 /usr/lib/freeradius/rlm_eap_gtc-1.1.8.so 7f932feeb000-7f93300ea000 ---p 00002000 ca:01 16913198 /usr/lib/freeradius/rlm_eap_gtc-1.1.8.so 7f93300ea000-7f93300eb000 rw-p 00001000 ca:01 16913198 /usr/lib/freeradius/rlm_eap_gtc-1.1.8.so Thu Nov 1 07:42:35 2012 : Info: Starting - reading configuration files ...

2 1

Could not find requested key warnings
by jobhunts02＠aol.com 02 Nov '12

02 Nov '12

I am using the rlm_counter module and am getting “rlm_counter: Could not find requested key in the database.” warnings even though the key (the username) is in the database. I know this because later, without adding any or deleting any users, it does find the user in the database. Why would a user not be found in the database?

1 0

No luck connecting from a ZyXEL NWA3160-N AP
by Erich Titl 02 Nov '12

02 Nov '12

Hi everybody I am running a freshly compiled FreeRADIUS Version 2.2.0, for host i686-pc-linux-gnu, built on Oct 31 2012 at 16:56:00 Copyright (C) 1999-2012 The FreeRADIUS server project and contributors. authenticating against a MySQL database appeast to work fine using radtest luna:/usr/local/etc/raddb # radtest test 1234 localhost 1812 testing123 Sending Access-Request of id 104 to 127.0.0.1 port 1812 User-Name = "test" User-Password = "1234" NAS-IP-Address = 194.124.158.51 NAS-Port = 1812 Message-Authenticator = 0x00000000000000000000000000000000 rad_recv: Access-Accept packet from host 127.0.0.1 port 1812, id=104, length=20 I connected a ZyXEL NWA 3160-N (latest Firmware), generated a certificate request, signed it using XCA and reimported it on the AP. I also installed a certificate signed by the same CA in the ..../raddb/certs directory and of course the CA cert to be able to verify the client cert. If I try now to connect to the AP using the same credentials as before, I am getting the following in the output of radiusd -X .... Module: Linked to sub-module rlm_eap_tls Module: Instantiating eap-tls tls { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 CA_path = "/usr/local/etc/raddb/certs" pem_file_type = yes private_key_file = "/usr/local/etc/raddb/certs/luna.think.ch.key" certificate_file = "/usr/local/etc/raddb/certs/luna.think.ch.pem" CA_file = "/usr/local/etc/raddb/certs/Think_CA.pem" private_key_password = "" dh_file = "/usr/local/etc/raddb/certs/dh" random_file = "/usr/local/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" ecdh_curve = "prime256v1" cache { enable = no lifetime = 24 max_entries = 255 } ..... Found Auth-Type = EAP # Executing group from file /usr/local/etc/raddb/sites-enabled/default +- entering group authenticate {...} [eap] EAP Identity [eap] processing type md5 rlm_eap_md5: Issuing Challenge ++[eap] returns handled Sending Access-Challenge of id 7 to 194.124.158.62 port 59115 EAP-Message = 0x0102001604106133379bfac030f9a2efcf9a2e3e9641 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x0c2c33890c2e3790fae8bf762d1a9802 Finished request 0. Waking up in 4.9 seconds. Going to the next request rad_recv: Access-Request packet from host 194.124.158.62 port 59115, id=8, length=162 User-Name = "test" NAS-Port = 0 Called-Station-Id = "50-67-F0-38-A9-E5:ZyXEL" Vendor-Specific = 0x000000000402 Calling-Station-Id = "74-F0-6D-07-9B-91" Framed-MTU = 1400 NAS-Port-Type = Wireless-802.11 Connect-Info = "CONNECT 0Mbps 802.11" EAP-Message = 0x020200060319 State = 0x0c2c33890c2e3790fae8bf762d1a9802 Message-Authenticator = 0x2ad76dbb03af18776e0c10b36df81895 # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop ++[digest] returns noop [suffix] No '@' in User-Name = "test", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] EAP packet type response id 2 length 6 [eap] No EAP Start, assuming it's an on-going EAP conversation ...... ...... ...... [peap] <<< TLS 1.0 Alert [length 0002], fatal unknown_ca TLS Alert read:fatal:unknown CA TLS_accept: failed in SSLv3 read client certificate A rlm_eap: SSL error error:14094418:SSL routines:SSL3_READ_BYTES:tlsv1 alert unknown ca ..... There appears to be something wrong with the client certificate passed by the AP in the eap conversation. I doublechecked the certificates and googled my fingers raw on this. This is the server cert luna:/usr/local/etc/raddb/certs # openssl x509 -in luna.think.ch.pem -noout -text Certificate: Data: Version: 3 (0x2) Serial Number: 29 (0x1d) Signature Algorithm: sha1WithRSAEncryption Issuer: C=CH, L=Stallikon, O=THINK, OU=CA Section, CN=Think CA/emailAddress=ca(a)think.ch Validity Not Before: Nov 2 00:00:00 2012 GMT Not After : Sep 14 23:59:59 2014 GMT Subject: C=CH, L=Stallikon, O=THINK, OU=Mail Service, CN=luna.think.ch .... and the client cert luna:/usr/local/etc/raddb/certs # openssl x509 -in 194.124.158.62.pem -noout -text Certificate: Data: Version: 3 (0x2) Serial Number: 28 (0x1c) Signature Algorithm: sha1WithRSAEncryption Issuer: C=CH, L=Stallikon, O=THINK, OU=CA Section, CN=Think CA/emailAddress=ca(a)think.ch Validity Not Before: Nov 1 00:00:00 2012 GMT Not After : Oct 31 23:59:59 2013 GMT Subject: C=CH, L=Stallikon, O=THINK, OU=AP, CN=194.124.158.62 Subject Public Key Info: Public Key Algorithm: rsaEncryption RSA Public Key: (1024 bit) ..... and the CA cert luna:/usr/local/etc/raddb/certs # openssl x509 -in Think_CA.pem -noout -text Certificate: Data: Version: 3 (0x2) Serial Number: 0 (0x0) Signature Algorithm: md5WithRSAEncryption Issuer: C=CH, L=Stallikon, O=THINK, OU=CA Section, CN=Think CA/emailAddress=ca(a)think.ch Validity Not Before: Sep 16 17:00:07 2004 GMT Not After : Sep 14 17:00:07 2014 GMT Subject: C=CH, L=Stallikon, O=THINK, OU=CA Section, CN=Think CA/emailAddress=ca(a)think.ch Subject Public Key Info: Public Key Algorithm: rsaEncryption RSA Public Key: (2048 bit) ... If you need the full output of radiusd, let me know. Maybe someone can give me a push in the right direction. Thanks Erich Titl

2 2

Re: Freeradius-Users Digest, Vol 90, Issue 25
by diwakara googly 02 Nov '12

02 Nov '12

QpwertuytttuuipiusAsdfghllzc vv hdk£§ ￦|°_|001#%2&/+()0&#) ' ; On 9 Oct 2012 19:21, <freeradius-users-request(a)lists.freeradius.org> wrote: > Send Freeradius-Users mailing list submissions to > freeradius-users(a)lists.freeradius.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.freeradius.org/mailman/listinfo/freeradius-users > or, via email, send a message with subject or body 'help' to > freeradius-users-request(a)lists.freeradius.org > > You can reach the person managing the list at > freeradius-users-owner(a)lists.freeradius.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Freeradius-Users digest..." > > > Today's Topics: > > 1. Re: freeRadius against Active Directory > (Martin.Heinzmann(a)belden.com) > 2. Query help (Jonathan Bastin) > 3. Re: Query help (Alan DeKok) > 4. Re: Outpairs not working on external script when user is > located in MYSQL (Alan DeKok) > 5. v2.2 (David Peterson) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 9 Oct 2012 13:01:06 +0200 > From: Martin.Heinzmann(a)belden.com > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Subject: Re: freeRadius against Active Directory > Message-ID: > > <OF9B65C4AF.4CC34B36-ONC1257A92.003C5704-C1257A92.003C8691(a)BeldenCDT.com> > > Content-Type: text/plain; charset="us-ascii" > > > Thank you guys very much. With your hints and a tutorial I found then( > > http://www.perkinsblog.net/blog/index.php/2010/02/freeradius-and-windows-ad/ > ) I managed to make it work :-) > Thanks again > > Martin > DISCLAIMER: > > Privileged and/or Confidential information may be contained in this > message. If you are not the addressee of this message, you may not > copy, use or deliver this message to anyone. In such event, you > should destroy the message and kindly notify the sender by reply > e-mail. It is understood that opinions or conclusions that do not > relate to the official business of the company are neither given > nor endorsed by the company. > > Thank You. > >

2 1