- Freeradius-Users - lists.freeradius.org

Multiple Accounting copies
by Shreya Shah 17 Jun '11

17 Jun '11

Hi, I need to send copies of accounting packets going to multiple servers. I do not want to set this up as failover or load balancing. I was able to setup one home server in proxy.conf for accounting and that is working fine but I'm unable to send this to multiple servers.Do I need to have multiple copies of copy-acct-to-home-server in sites-available ? Also do I need to send accounting packets on different port for every server ? Thanks Shreya.

2 5

eduroam using Eap-ttls and securing user's password
by regemailster＠gmail.com 17 Jun '11

17 Jun '11

Hi all, Sorry if this question has been posted before. I have a simple question regarding how to ensure the user's password is never leaked or found out by anyone, including administrators of the radius server or the backend LDAP server. My requirement is that I would like to store the user password as a hash (eg SHA-256) within the LDAP. Now if I was to use this LDAP server as the authentication source for the Radius server for eduroam. I would need to use EAP-TTLS with PAP as the inner authentication (since I don't have a reversible password at the backend). Now I notice that because it uses PAP, if I enable user-password logging on the radius server, I can see the user's supplied password when their machine is authenticating to access eduroam. This problem is even worse if the user is traveling at a partner's institution and using eduroam, in that if that partner insititution's RADIUS server has user-password logging enable, they too can see my user's password. I wonder if there's anything that can be done to prevent this, or have I missed something in my understanding? Thanks,

4 4

LDAP server failover in FreeRADIUS 2.1
by up＠3.am 16 Jun '11

16 Jun '11

I can tell that ldap failover config is a FAQ by the number of hits I found searching for this, but it seems that many of the config examples are for older versions of FreeRADIUS. In any case, this is what I've tried, but it's not working: In radiusd.conf: ldap ldap1{ server = "serverA.domain.com" basedn = "dc=domain,dc=com" filter = "(uid=%{Stripped-User-Name:-%{User-Name}})" ldap_connections_number = 5 timeout = 4 timelimit = 3 net_timeout = 1 tls { start_tls = no } dictionary_mapping = ${confdir}/ldap.attrmap edir_account_policy_check = no set_auth_type = no } ldap ldap2{ server = "serverB.domain.com" basedn = "dc=domain,dc=com" filter = "(uid=%{Stripped-User-Name:-%{User-Name}})" ldap_connections_number = 5 timeout = 4 timelimit = 3 net_timeout = 1 tls { start_tls = no } dictionary_mapping = ${confdir}/ldap.attrmap edir_account_policy_check = no set_auth_type = yes } ----------- This is what I put in sites-enabled/default AND in sites-enabled/inner-tunnel (it doesn't look right to me, but it's what I found): authorize { preprocess redundant LDAP{ ldap1 ldap2 } Auth-Type LDAP { ldap1 ldap2 } ------------- Again, sorry for the FAQ, but if somebody could put me straight here, I'd appreciate it.

2 2

FreeRadius with AD
by Javier Lidó Fernandez 16 Jun '11

16 Jun '11

Hi there, I´ve installed FreeRADIUS with Active Directory Authentication (ntlm_auth for mschap) and is working 100% correctly. No probs with that. The only thing is that my users log in using their windows account (username and password), but I would need to change it to user@DOMAIN and password. I've spent lots of hours trying to find out how to do it but with no success. Could someone point me in the right direction please? Thanks Javier

2 3

If in post-auth
by seb2020 16 Jun '11

16 Jun '11

Hi ! I have a problem in my post-auth configuration. I have write this with the help of my other topic in this forum: update reply { Tunnel-Type := VLAN Tunnel-Medium-Type := IEEE-802 Tunnel-Private-Group-Id := "unauthorised" Termination-Action := RADIUS-Request Session-Timeout := 300 Acct-Interim-Interval := 3600 } if ("%{Aruba-Essid-Name}" == "ssid_student") { if ("%{reply:MailUtilisateur}" =~ /^[a-z0-9._-]+(a)students.XXX.ch/) { update reply { Tunnel-Private-Group-Id := "std" Aruba-User-Role := "std" } } else { update reply { Tunnel-Private-Group-Id := "std_false" Aruba-User-Role := "std_false" } } } elsif ("%{Aruba-Essid-Name}" == "ssid_staff") { if ("%{reply:MailUtilisateur}" =~ /^[a-z0-9._-]+(a)XXX.ch/) { update reply { Tunnel-Private-Group-Id := "staff" Aruba-User-Role := "staff" } } else { update reply { Tunnel-Private-Group-Id := "staff_false" Aruba-User-Role := "staff_false" } } And this is the result of radiusd -X : # Executing section post-auth from file /etc/raddb/sites-enabled/default +- entering group post-auth {...} [reply_log] expand: /var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d -> /var/log/radius/radacct/153.109.XXX/reply-detail-20110615 [reply_log] /var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /var/log/radius/radacct/153.109XXX/reply-detail-20110615 [reply_log] expand: %t -> Wed Jun 15 15:55:01 2011 ++[reply_log] returns ok ++[exec] returns noop ++[reply] returns noop ++? if ("%{Aruba-Essid-Name}" == "ssid_student") expand: %{Aruba-Essid-Name} -> ssid_staff ? Evaluating ("%{Aruba-Essid-Name}" == "ssid_student") -> FALSE ++? if ("%{Aruba-Essid-Name}" == "ssid_student") -> FALSE Sending Access-Accept of id 247 to 153.109.XXX port 32834 MS-MPPE-Recv-Key = 0x90169c2ffb6f14c1aa01efed861f32c21da05dfb0e43bea0a5b8aa72d63626d6 MS-MPPE-Send-Key = 0xefa74ededebd9066dadc8b0d369884155e9a73e9685241f408afbdc3e1a8de3e EAP-Message = 0x03090004 Message-Authenticator = 0x00000000000000000000000000000000 User-Name = "sgistpi" Tunnel-Type:0 = VLAN Tunnel-Medium-Type:0 = IEEE-802 Tunnel-Private-Group-Id:0 = "unauthorised" Termination-Action = RADIUS-Request Session-Timeout = 300 Acct-Interim-Interval = 3600 Just like it say, Aruba-Essid-Name is : "expand: %{Aruba-Essid-Name} -> ssid_staff", but it doesn't work with my if. Why is it not going to the elsif ? Can you help me ? Thanks ! ----- >From Switzerland -- View this message in context: http://freeradius.1045715.n5.nabble.com/If-in-post-auth-tp4491348p4491348.h… Sent from the FreeRadius - User mailing list archive at Nabble.com.

3 4

Two-phase, "pass-thru" authentication possible?
by cwfnetman 16 Jun '11

16 Jun '11

I've got an interesting problem to try to solve and was curious if such a concept is even possible with FreeRadius. I've got to implement mac address filtering to a Cisco WiFi (WLC plus numerous LWAPPs) system that also requires Active Directory authentication of the Windows credentials of the user plus the wireless client workstation machine's AD account. Presently I'm using Microsoft IAS on a Windows 2003 server to act as my Windows AD radius server. Implementing the additional mac address filtering isn't my idea, so please refrain from questioning why. I know it really does nothing for true security, but I'm ordered to do so my authorities above me, so I must implement this mandate just because... well it's now become mandatory for my job. A problem is that the mac addresses of the wifi interfaces in all the various workstations are not always rigidly assigned to any particular laptop PC, the WiFi adapters in the set of client PCs are subject to frequent change and movement around the pool of PCs, so basically I need a simple whitelist (several hundred mac addresses) to validate against. If the incoming mac address on the authentication request is simply somewhere on the whitelist (anywhere within those hundreds of addresses), then I next need to authenticate the Windows AD credentials, and if they're good, and in a certain AD group, and their domain member workstation PC is in a certain machine account group, etc, etc, according to the set of remote access policies in the IAS server, then go ahead and "let 'em in". So, can FreeRadius be set up to perform a sort of two-phase, cascaded authentication such that the Cisco WiFi controller first sends the incoming authentication access-request to FreeRadius, which checks a big whitelist of pre-approved mac addresses, and if that tests good, then FreeRadius acts as a relay/proxy/radius client to pass the next ActiveDirectory authentication portion of the request off to my Windows IAS server, then if that part comes back good, to reassemble all the pieces-parts back together as a completed access-accept message and hand it back to the Cisco wireless system to let the wireless user in, and basically fool the Cisco WiFi system into thinking that one Radius server handled it all? -- View this message in context: http://freeradius.1045715.n5.nabble.com/Two-phase-pass-thru-authentication-… Sent from the FreeRadius - User mailing list archive at Nabble.com.

2 1

Attribute evaluation IF the attribute exists
by Tiberiu Breana 15 Jun '11

15 Jun '11

Greetings. Is it possible to authenticate users based on an attribute, if it exists (in their request), but ignore it if it doesn't? I've read the 'man users', but haven't found anything suitable. Any advice is welcome. Thanks!

2 3

Auth: rlm_krb5: [test1@CSP-BACK] krb5_rd_req() failed: Permission denied in replay cache code
by Jimmy 15 Jun '11

15 Jun '11

I have Kerberos 1.6 configured to use OpenLDAP 2.3.43 as a back end. I am trying to configure Freeradius 2.1.7 to authenticate to Kerberos. I am having problems getting Freeradiusto authenticate while started in daemon mode. When the process is started in debug mode it seems to funciton, but authentications while in daemon mode return the error: >Auth: rlm_krb5: [test1@CSP-BACK] krb5_rd_req() failed: Permission denied in replay cache code Since authentication works in debug mode I'm not sure what I can give to support the error besides the krb5kdc/slapd/radius log outputs and the client side output. Functional output of debug mode is included as well. I appreciate any help you can provide. If I should post any config files please let me know what you would like to see. Thank you very much. *****************client side output***************** radtest test1@CSP-BACK qwer krb 1812 SharedSecret Sending Access-Request of id 213 to [SERVER IP ADDRESS ] port 1812 User-Name = "test1@CSP-BACK" User-Password = "qwer" NAS-IP-Address = 127.0.0.1 NAS-Port = 1812 rad_recv: Access-Reject packet from host [SERVER IP ADDRESS ] port 1812, id=213, length=20 *********************************************** *****************radius log***************** Tue Jun 14 16:17:23 2011 : Auth: rlm_krb5: [test1@CSP-BACK] krb5_rd_req() failed: Permission denied in replay cache code *********************************************** *****************krb5kdc log***************** Jun 14 16:17:22 krb.csp krb5kdc[10954](info): AS_REQ (12 etypes {18 17 16 23 1 3 2 11 10 15 12 13}) [SERVER IP ADDRESS ]: ISSUE: authtime 1308082642, etypes {rep=18 tkt=18 ses=18}, test1@CSP-BACK for krbtgt/CSP-BACK@CSP-BACK Jun 14 16:17:23 krb.csp krb5kdc[10954](info): TGS_REQ (7 etypes {18 17 16 23 1 3 2}) [SERVER IP ADDRESS ]: ISSUE: authtime 1308082642, etypes {rep=18 tkt=18 ses=18}, test1@CSP-BACK for radius/krb.csp@CSP-BACK ******************************************** *****************slapd log***************** Jun 14 16:17:22 krb slapd[10742]: conn=9 op=54 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=test1@CSP-BACK))" Jun 14 16:17:22 krb slapd[10742]: conn=9 op=54 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:17:22 krb slapd[10742]: conn=9 op=54 SEARCH RESULT tag=101 err=0 nentries=1 text= Jun 14 16:17:22 krb slapd[10742]: conn=9 op=55 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=krbtgt/CSP-BACK@CSP-BACK))" Jun 14 16:17:22 krb slapd[10742]: conn=9 op=55 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:17:22 krb slapd[10742]: conn=9 op=55 SEARCH RESULT tag=101 err=0 nentries=1 text= Jun 14 16:17:23 krb slapd[10742]: conn=9 op=56 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=krbtgt/CSP-BACK@CSP-BACK))" Jun 14 16:17:23 krb slapd[10742]: conn=9 op=56 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:17:23 krb slapd[10742]: conn=9 op=56 SEARCH RESULT tag=101 err=0 nentries=1 text= Jun 14 16:17:23 krb slapd[10742]: conn=9 op=57 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=radius/krb.csp@CSP-BACK))" Jun 14 16:17:23 krb slapd[10742]: conn=9 op=57 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:17:23 krb slapd[10742]: conn=9 op=57 SEARCH RESULT tag=101 err=0 nentries=1 text= ******************************************** **************************************************************************************** **************************************************************************************** DEBUG MODE OUTPUT When I run the server in debug mode here is the output from radiusd -X: ******************************************** FreeRADIUS Version 2.1.7, for host x86_64-redhat-linux-gnu, built on Mar 31 2010 at 00:14:28 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/raddb/radiusd.conf including configuration file /etc/raddb/proxy.conf including configuration file /etc/raddb/clients.conf including files in directory /etc/raddb/modules/ including configuration file /etc/raddb/modules/unix including configuration file /etc/raddb/modules/pap including configuration file /etc/raddb/modules/always including configuration file /etc/raddb/modules/attr_rewrite including configuration file /etc/raddb/modules/perl including configuration file /etc/raddb/modules/detail including configuration file /etc/raddb/modules/detail.example.com including configuration file /etc/raddb/modules/expr including configuration file /etc/raddb/modules/checkval including configuration file /etc/raddb/modules/preprocess including configuration file /etc/raddb/modules/sql_log including configuration file /etc/raddb/modules/inner-eap including configuration file /etc/raddb/modules/chap including configuration file /etc/raddb/modules/detail.log including configuration file /etc/raddb/modules/digest including configuration file /etc/raddb/modules/sradutmp including configuration file /etc/raddb/modules/files including configuration file /etc/raddb/modules/linelog including configuration file /etc/raddb/modules/smbpasswd including configuration file /etc/raddb/modules/mschap including configuration file /etc/raddb/modules/cui including configuration file /etc/raddb/modules/pam including configuration file /etc/raddb/modules/exec including configuration file /etc/raddb/modules/policy including configuration file /etc/raddb/modules/smsotp including configuration file /etc/raddb/modules/acct_unique including configuration file /etc/raddb/modules/expiration including configuration file /etc/raddb/modules/otp including configuration file /etc/raddb/modules/realm including configuration file /etc/raddb/modules/sqlcounter_expire_on_login including configuration file /etc/raddb/modules/etc_group including configuration file /etc/raddb/modules/ippool including configuration file /etc/raddb/modules/logintime including configuration file /etc/raddb/modules/passwd including configuration file /etc/raddb/modules/attr_filter including configuration file /etc/raddb/modules/wimax including configuration file /etc/raddb/modules/radutmp including configuration file /etc/raddb/modules/mac2ip including configuration file /etc/raddb/modules/counter including configuration file /etc/raddb/modules/echo including configuration file /etc/raddb/modules/mac2vlan including configuration file /etc/raddb/modules/krb5 including configuration file /etc/raddb/eap.conf including configuration file /etc/raddb/policy.conf including files in directory /etc/raddb/sites-enabled/ including configuration file /etc/raddb/sites-enabled/control-socket including configuration file /etc/raddb/sites-enabled/inner-tunnel including configuration file /etc/raddb/sites-enabled/default group = radiusd user = radiusd including dictionary file /etc/raddb/dictionary main { prefix = "/usr" localstatedir = "/var" logdir = "/var/log/radius" libdir = "/usr/lib64/freeradius" radacctdir = "/var/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 allow_core_dumps = no pidfile = "/var/run/radiusd/radiusd.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 = no 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 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 [CLIENT SUBNET]/16 { require_message_authenticator = no secret = "SharedSecret" nastype = "other" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating expr Module: Linked to module rlm_expiration Module: Instantiating expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server inner-tunnel { modules { Module: Checking authorize {...} for more modules to load } # modules } # server server { modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_krb5 Module: Instantiating krb5 krb5 { keytab = "/etc/raddb/rad.keytab" service_principal = "radius/krb.csp" } rlm_krb5: krb5_init ok Module: Linked to module rlm_eap Module: Instantiating eap eap { default_eap_type = "ttls" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 2048 } 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 pem_file_type = yes private_key_file = "/etc/raddb/certs/server.pem" certificate_file = "/etc/raddb/certs/server.pem" CA_file = "/etc/raddb/certs/ca.pem" private_key_password = "whatever" dh_file = "/etc/raddb/certs/dh" random_file = "/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/etc/raddb/certs/bootstrap" cache { enable = no lifetime = 24 max_entries = 255 } } 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: Checking authorize {...} for more modules to load Module: Linked to module rlm_preprocess Module: Instantiating preprocess preprocess { huntgroups = "/etc/raddb/huntgroups" hints = "/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_detail Module: Instantiating auth_log detail auth_log { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Linked to module rlm_realm Module: Instantiating suffix realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_unix Module: Instantiating unix unix { radwtmp = "/var/log/radius/radwtmp" } Module: Linked to module rlm_files Module: Instantiating files files { usersfile = "/etc/raddb/users" acctusersfile = "/etc/raddb/acct_users" preproxy_usersfile = "/etc/raddb/preproxy_users" compat = "no" } Module: Linked to module rlm_pap Module: Instantiating pap pap { encryption_scheme = "auto" auto_header = no } Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating 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: Instantiating detail detail { detailfile = "/var/log/radius/radacct/%{Client-IP-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 radutmp radutmp { filename = "/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 attr_filter.accounting_response attr_filter attr_filter.accounting_response { attrsfile = "/etc/raddb/attrs.accounting_response" key = "%{User-Name}" } 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 attr_filter.access_reject attr_filter attr_filter.access_reject { attrsfile = "/etc/raddb/attrs.access_reject" key = "%{User-Name}" } } # 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 = "/var/run/radiusd/radiusd.sock" } } Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/radiusd/radiusd.sock Listening on proxy address * port 1814 Ready to process requests. ***************************************************upon issing radtest*************************************************** rad_recv: Access-Request packet from host [CLIENT IP ADDRESS ] port 35916, id=141, length=66 User-Name = "test1@CSP-BACK" User-Password = "qwer" NAS-IP-Address = 127.0.0.1 NAS-Port = 1812 +- entering group authorize {...} ++[preprocess] returns ok [auth_log] expand: /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d -> /var/log/radius/radacct/ [CLIENT IP ADDRESS ]/auth-detail-20110614 [auth_log] /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/radius/radacct/ [CLIENT IP ADDRESS ]/auth-detail-20110614 [auth_log] expand: %t -> Tue Jun 14 16:25:45 2011 ++[auth_log] returns ok [suffix] Looking up realm "CSP-BACK" for User-Name = "test1@CSP-BACK" [suffix] No such realm "CSP-BACK" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound [files] users: Matched entry DEFAULT at line 49 ++[files] returns ok ++[expiration] returns noop ++[logintime] returns noop [pap] WARNING! No "known good" password found for the user. Authentication may fail because of this. ++[pap] returns noop Found Auth-Type = Kerberos +- entering group Kerberos {...} ++[krb5] returns ok WARNING: Empty section. Using default return values. Sending Access-Accept of id 141 to [CLIENT IP ADDRESS ] port 35916 Finished request 0. Going to the next request Waking up in 4.9 seconds. Cleaning up request 0 ID 141 with timestamp +168 Ready to process requests. *************************************************** *****************client side output***************** radtest test1@CSP-BACK qwer krb 1812 SharedSecret Sending Access-Request of id 141 to [CLIENT IP ADDRESS ] port 1812 User-Name = "test1@CSP-BACK" User-Password = "qwer" NAS-IP-Address = 127.0.0.1 NAS-Port = 1812 rad_recv: Access-Accept packet from host [CLIENT IP ADDRESS ] port 1812, id=141, length=20 *************************************************** *****************krb5kdc.log***************** Jun 14 16:25:45 krb.csp krb5kdc[10954](info): AS_REQ (12 etypes {18 17 16 23 1 3 2 11 10 15 12 13}) [SERVER IP ADDRESS ]: ISSUE: authtime 1308083145, etypes {rep=18 tkt=18 ses=18}, test1@CSP-BACK for krbtgt/CSP-BACK@CSP-BACK Jun 14 16:25:46 krb.csp krb5kdc[10954](info): TGS_REQ (7 etypes {18 17 16 23 1 3 2}) [SERVER IP ADDRESS ]: ISSUE: authtime 1308083145, etypes {rep=18 tkt=18 ses=18}, test1@CSP-BACK for radius/krb.csp@CSP-BACK *************************************************** *****************slapd.log***************** Jun 14 16:25:45 krb slapd[10742]: conn=9 op=58 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=test1@CSP-BACK))" Jun 14 16:25:45 krb slapd[10742]: conn=9 op=58 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:25:45 krb slapd[10742]: conn=9 op=58 SEARCH RESULT tag=101 err=0 nentries=1 text= Jun 14 16:25:45 krb slapd[10742]: conn=9 op=59 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=krbtgt/CSP-BACK@CSP-BACK))" Jun 14 16:25:45 krb slapd[10742]: conn=9 op=59 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:25:45 krb slapd[10742]: conn=9 op=59 SEARCH RESULT tag=101 err=0 nentries=1 text= Jun 14 16:25:46 krb slapd[10742]: conn=9 op=60 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=krbtgt/CSP-BACK@CSP-BACK))" Jun 14 16:25:46 krb slapd[10742]: conn=9 op=60 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:25:46 krb slapd[10742]: conn=9 op=60 SEARCH RESULT tag=101 err=0 nentries=1 text= Jun 14 16:25:46 krb slapd[10742]: conn=9 op=61 SRCH base="cn=KRB,dc=CSPKRB" scope=2 deref=0 filter="(&(|(objectClass=krbPrincipalAux)(objectClass=krbPrincipal))(krbPrincipalName=radius/krb.csp@CSP-BACK))" Jun 14 16:25:46 krb slapd[10742]: conn=9 op=61 SRCH attr=krbprincipalname objectclass krbprincipalkey krbmaxrenewableage krbmaxticketlife krbticketflags krbprincipalexpiration krbticketpolicyreference krbUpEnabled krbpwdpolicyreference krbpasswordexpiration krbLastFailedAuth krbLoginFailedCount krbLastSuccessfulAuth nsaccountlock loginexpirationtime logindisabled modifytimestamp krbLastPwdChange krbExtraData krbObjectReferences Jun 14 16:25:46 krb slapd[10742]: conn=9 op=61 SEARCH RESULT tag=101 err=0 nentries=1 text= (no radius log output in debug mode)

4 5

Re: Mysql Errors
by Alan DeKok 15 Jun '11

15 Jun '11

Stefan A. wrote: > is there an option to turn just SQL Errors and warnings on, to be written to > disk? They should be logged by default. > My opinion is, that not FR is ignoring attributes, but SQL is simply not > delivering them ... from time to time, possibly by timeouts .... > I assume, that FR would recognise it by reporting some timeouts or other > errors/warnings, but to get them, I need the debug mode, which is too hard > to get written to disk at that transaction rate. Write it to a ramdisk, and periodically rotate the files. Alan DeKok.

1 0

Slow Mysql Queries
by OzSpots - Carl Sawers 14 Jun '11

14 Jun '11

Hi All, I have a freeradius server which has some slow mysql queries and some errors like the below happen now and again(daily). We have actually just upgraded to this server and have imported all the MYsql data into the new server (it was working fine on the older quite similar server). One thing I have noticed; the server boots with around 280mb of ram used but after an hour or two is closer to 400mb used and stays around this point until rebooted again. My research says that the tables need to be indexed but it seems I would have to manually do this and I don't know which ones would need it anyway... and why would this be the case when it wasn't needed previously. The other thing that I have noticed is what appear to be doubled up entries in radius.log, (check the times) Anyone know what this could be? Fri Jun 3 19:40:30 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:31 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:31 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:31 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:32 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) --------------- Here are the server errors: Fri Jun 3 19:39:40 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 210 due to unfinished request 5001 Fri Jun 3 19:39:40 2011 : Error: WARNING: Unresponsive child (id 2995579792) for request 5008 (in component accounting module rlm_sql) Fri Jun 3 19:39:40 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:40 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:41 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:41 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:41 2011 : Error: Discarding duplicate request from client localhost:2048 - ID: 32 due to unfinished request 5008 Fri Jun 3 19:39:43 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 210 due to unfinished request 5001 Fri Jun 3 19:39:43 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:44 2011 : Error: Discarding duplicate request from client localhost:2048 - ID: 32 due to unfinished request 5008 Fri Jun 3 19:39:46 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 210 due to unfinished request 5001 Fri Jun 3 19:39:46 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:46 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:47 2011 : Error: Discarding duplicate request from client localhost:2048 - ID: 32 due to unfinished request 5008 Fri Jun 3 19:39:47 2011 : Error: WARNING: Unresponsive child (id 2985089936) for request 5009 (in component accounting module rlm_sql) Fri Jun 3 19:39:49 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:49 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:50 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Regards Carl

7 12