September 2009 - Freeradius-Users - lists.freeradius.org

Re: freeradius2.1.6| buffered-sql | acctstoptime problems
by ramesh p 02 Sep '09

02 Sep '09

db frozen in my production env. This issue has been seen. Exeperiencing Outages in prod. environment. Please suggest a fix to overcome this issue. > Alan Buxey wrote: >>> Hmmm... maybe over-writing it with spaces would work... or something >>> else might go wrong. >> >> or reverse it when making the .work copy and read from the end of the >> file.... > > That's hard... the detail.work file is created via a "rename", which > is nearly zero cost. > > Alan DeKok. Counter? Write detail.work.counter onto the disk, increment it every time packet is processed and return to zero when detail.work is deleted. It will say how many packets to skip when radiusd is restarted. Ivan Kalik Kalik Informatika ISP -

2 1

Re: sqlippool - Duplicate IP
by Neville 01 Sep '09

01 Sep '09

> Neville wrote: >> It's not as simple as your making it. Also, I am using %{NAS-Port} and >> not %{Calling-Station-Id} due to the Lack of Calling-Station-Id. > > Why didn't you say that in the first message? Giving out *part* of > the information is annoying. I Understand, but I was trying to make the message SHORT. >> pool-key = "%{NAS-Port}" >> # pool-key = "%{Calling-Station-Id}" >> >> $INCLUDE sql/mysql/ippool.conf >> #$INCLUDE sql/postgresql/ippool.conf >> >> if I use ippool module, it works fine so something wrong with the SQL. > > Well, it's not using the "allocate-find" query, so something is wrong > with the configuration. Are you able to provide some pointers please, e.g. where sqlippool should be placed or what other files should I look into or order to track the error down. Thx Nev

1 0

Re: Failed to authenticate the user.
by Paweł Pogorzelski 01 Sep '09

01 Sep '09

Hi Alan! I use Debian 5.0 Lenny and version of OpenSSL is 0.9.8.g. -- Best regards Pawel Pogorzelski

1 0

Re: Failed to authenticate the user.
by Paweł Pogorzelski 01 Sep '09

01 Sep '09

Hi Alan! I use Debian 5.0 Lenny and version of OpenSSL is 0.9.8.g. -- Best regards Pawel Pogorzelski

1 0

freeradius+openldap+802.1x
by Antonio Andrés Jiménez Cantillo 01 Sep '09

01 Sep '09

Hi I am mounting a platform of authentication with freeradius. I have formed freeradius in order that it works with Active Directory. Also I have mounted an openLDAP service, where I realize authentication without 802.1x support. There is some way of forming freeradius+openldap+802.1x as if it was treating itself of Activate Directory? Thanks

2 1

Re: sqlippool - Duplicate IP
by Neville 01 Sep '09

01 Sep '09

> Neville wrote: >> I've facing a problem since rebuild, where every user is being allocated >> the same IP from the sqlippool, and I'm not sure why this is happening. > ... >> pppd does not pass back Client-IP-Address or Client-Station-Id > > "Calling-Station-Id". > >> table structure for radipool is > > Yes... we have access to the source code, too. > >> rad_recv: Access-Request packet from host NASIPHERE port 53621, id=117, >> length=147 >> Service-Type = Framed-User >> Framed-Protocol = PPP >> User-Name = "TESTUSER" >> MS-CHAP-Challenge = 0xe325bfbeb22fbbb7a33a21326e5ce18a >> MS-CHAP2-Response = >> 0x51009da7f84750dd0f01bed231e11bab1f9a00000000000000002b9f4dad6844332eaec4aabcc1d8f03911ff654b6a7a8e96 >> NAS-Identifier = "NASIPHERE" >> NAS-Port = 0 > > OK. So how is the IP pool module supposed assign a unique IP for each > user? There's no MAC address in the request (i.e. Calling-Station-Id). > The SQL queries (if you read them) use Calling-Station-Id. How are > they supposed to work if there's no Calling-Station-Id? > > Fix your PPPd so that it sends *useful* information. > Dear Alan, It's not as simple as your making it. Also, I am using %{NAS-Port} and not %{Calling-Station-Id} due to the Lack of Calling-Station-Id. pool-key = "%{NAS-Port}" # pool-key = "%{Calling-Station-Id}" $INCLUDE sql/mysql/ippool.conf #$INCLUDE sql/postgresql/ippool.conf if I use ippool module, it works fine so something wrong with the SQL. Please can you confirm in want sections I have to add sqlippool module in order that I can test this again, but given the flakiness of sqlippool I might just stick with ippool module. Thx Nev

2 1

Re: Setting FreeRadius + WPA - Enterprises (PEAP) CA Cert?
by Steven Sprague 01 Sep '09

01 Sep '09

Hello Experts, Now that I have my 1st. test user working with clear text passwords I am ready to setup WPA - Enterprise (PEAP). I noticed in my client (RedHat RHEL Workstation) will need a CA.Cert in the connection settings. Can I simply copy the FR ca.pem file to my client for this or not? Or do I need to create my own? If I need to create my own CA is there a guide for doing this for Free Radius. I have read all the docs and can not find a clear approach. Thanks, Steven -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

3 7

Simple Accounting 'radrelay' functionality - Version 2.1.6
by Craig Campbell 01 Sep '09

01 Sep '09

Hi. FreeRadius 2.1.6 running in Redhat Linux AS5.3 We are upgrading from ancient radius servers to current, and discovered the radrelay program no longer exists. Despite my best efforts, I have failed to configure relaying correctly. I think I am including below the required changes. I hope someone that has done this successfully can easily see where I went wrong. (Thanks in advance!) We have two (2) radius servers (Redhat Linux AS5), radius-a and radius-b and wish to replicate accounting info between them. (Previously radius-1 ran radrelay to radius-2 and radius-2 ran radrelay to radius-1 -- just to be clear) For my testing, I am attempting to get radius-a to replicate to radius-b (Get things working in 1 direction first.) I have created a symbolic link in /usr/local/etc/raddb/sites-enabled/ to /usr/local/etc/raddb/sites-available/copy-acct-to-home-server I have ADDED the following to (and REMOVED NOTHING FROM) the proxy.conf file, home_server radius-b { type = acct ipaddr = 192.168.1.226 port = 1813 secret = booboo require_message_authenticator = no response_window = 20 zombie_period = 40 revive_interval = 120 status_check = status-server check_interval = 30 num_answers_to_alive = 3 coa { # Initial retransmit interval: 1..5 irt = 2 # Maximum Retransmit Timeout: 1..30 (0 == no maximum) mrt = 16 # Maximum Retransmit Count: 1..20 (0 == retransmit forever) mrc = 5 # Maximum Retransmit Duration: 5..60 mrd = 30 } } home_server_pool my_acct_relay { type = fail-over home_server = radius-b } realm relay_realm { acct_pool = my_acct_relay } ~~~~~~~ I have modified the file /usr/local/etc/raddb/sites-enabled/copy-to-home-server as follows, server copy-acct-to-home-server { listen { type = detail #CEC filename = ${radacctdir}/detail filename = ${radacctdir}/%{Client-IP-Address}/detail-%Y%m%d load_factor = 10 } preacct { #CEC Added this from web searches... update control { Proxy-To-Realm := relay_realm } preprocess suffix files } ~~~~~~~ Accounting packets are being sent from 192.168.1.101 to radius-a and are logged. No IP traffic has been detected from from radius-a to radius-b. The detail file I expect is being updated. No log files of the form, ${radacctdir}/%{Client-IP-Address}/pre-proxy-detail-%Y%m%d and ${radacctdir}/%{Client-IP-Address}/post-proxy-detail-%Y%m%d have been created, although I thought they should have been. The startup log has no obvious errors I can see, FreeRADIUS Version 2.1.6, for host x86_64-unknown-linux-gnu, built on Aug 28 2009 at 09:39:34 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/perl including configuration file /usr/local/etc/raddb/modules/pap including configuration file /usr/local/etc/raddb/modules/sradutmp including configuration file /usr/local/etc/raddb/modules/counter including configuration file /usr/local/etc/raddb/modules/policy including configuration file /usr/local/etc/raddb/modules/passwd including configuration file /usr/local/etc/raddb/modules/exec including configuration file /usr/local/etc/raddb/modules/expiration including configuration file /usr/local/etc/raddb/modules/digest including configuration file /usr/local/etc/raddb/modules/mac2ip including configuration file /usr/local/etc/raddb/modules/mschap including configuration file /usr/local/etc/raddb/modules/realm 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/logintime including configuration file /usr/local/etc/raddb/modules/sqlcounter_expire_on_login including configuration file /usr/local/etc/raddb/modules/radutmp including configuration file /usr/local/etc/raddb/modules/sql_log including configuration file /usr/local/etc/raddb/modules/linelog including configuration file /usr/local/etc/raddb/modules/smbpasswd including configuration file /usr/local/etc/raddb/modules/smsotp including configuration file /usr/local/etc/raddb/modules/otp including configuration file /usr/local/etc/raddb/modules/krb5 including configuration file /usr/local/etc/raddb/modules/etc_group including configuration file /usr/local/etc/raddb/modules/inner-eap including configuration file /usr/local/etc/raddb/modules/detail.log including configuration file /usr/local/etc/raddb/modules/ldap including configuration file /usr/local/etc/raddb/modules/ippool including configuration file /usr/local/etc/raddb/modules/wimax including configuration file /usr/local/etc/raddb/modules/always including configuration file /usr/local/etc/raddb/modules/files including configuration file /usr/local/etc/raddb/modules/acct_unique including configuration file /usr/local/etc/raddb/modules/preprocess including configuration file /usr/local/etc/raddb/modules/detail.example.com including configuration file /usr/local/etc/raddb/modules/pam including configuration file /usr/local/etc/raddb/modules/chap including configuration file /usr/local/etc/raddb/modules/echo including configuration file /usr/local/etc/raddb/modules/unix including configuration file /usr/local/etc/raddb/modules/expr including configuration file /usr/local/etc/raddb/modules/detail including configuration file /usr/local/etc/raddb/modules/checkval including configuration file /usr/local/etc/raddb/modules/attr_rewrite including configuration file /usr/local/etc/raddb/eap.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/copy-acct-to-home-server including configuration file /usr/local/etc/raddb/sites-enabled/default including configuration file /usr/local/etc/raddb/sites-enabled/control-socket group = radiusd user = radiusd including dictionary file /usr/local/etc/raddb/dictionary main { prefix = "/usr/local" localstatedir = "/var" logdir = "/var/log/radius" libdir = "/usr/local/lib" 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/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 = 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 } home_server radius-b { ipaddr = 192.168.1.226 port = 1813 type = "acct" secret = "booboo" 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_acct_relay { type = fail-over home_server = radius-b } realm relay_realm { acct_pool = my_acct_relay } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "testing123" shortname = "localhost" nastype = "other" } client 65.119.114.4 { require_message_authenticator = no secret = "s3t6r!synv3rs3" shortname = "114.4" } client 65.119.115.2 { require_message_authenticator = no secret = "s3t6r!synv3rs3" shortname = "115.2" } client 65.119.115.7 { require_message_authenticator = no secret = "s3t6r!synv3rs3" shortname = "115.7" } client 172.16.16.14 { require_message_authenticator = no secret = "booboo" shortname = "16.14" } client 172.16.17.20 { require_message_authenticator = no secret = "booboo" shortname = "17.20" } client 192.168.1.100 { require_message_authenticator = no secret = "booboo" shortname = "BRAS_100" nastype = "juniper" } client 192.168.1.101 { require_message_authenticator = no secret = "booboo" shortname = "BRAS_100" nastype = "juniper" } client 199.0.80.1 { require_message_authenticator = no secret = "booboo" shortname = "BRAS_100" nastype = "juniper" } client 192.168.1.103 { require_message_authenticator = no secret = "booboo" shortname = "radius-1" } client 192.168.1.104 { require_message_authenticator = no secret = "booboo" shortname = "radius-2" } client 192.168.1.225 { require_message_authenticator = no secret = "booboo" shortname = "radius-a" } client 192.168.1.226 { require_message_authenticator = no secret = "booboo" shortname = "radius-b" } client 206.48.23.170 { require_message_authenticator = no secret = "booboo" shortname = "23.170" } client 209.88.128.5 { require_message_authenticator = no secret = "booboo" shortname = "128.5" } client 209.88.128.6 { require_message_authenticator = no secret = "booboo" shortname = "128.6" } client 209.88.128.7 { require_message_authenticator = no secret = "booboo" shortname = "128.7" } client 209.88.128.10 { require_message_authenticator = no secret = "booboo" shortname = "128.10" } client 209.88.128.73 { require_message_authenticator = no secret = "booboo" shortname = "access1" } client 209.88.128.74 { require_message_authenticator = no secret = "booboo" shortname = "access2" nastype = "cisco" login = "" password = "setarsnmp" } client 209.88.128.75 { require_message_authenticator = no secret = "booboo" shortname = "access3" } client 209.88.128.76 { require_message_authenticator = no secret = "booboo" shortname = "access4" } client 209.88.128.77 { require_message_authenticator = no secret = "booboo" shortname = "access5" } client 209.88.128.78 { require_message_authenticator = no secret = "booboo" shortname = "access6" } client 209.88.128.131 { require_message_authenticator = no secret = "booboo" shortname = "128.131" } client 209.88.129.61 { require_message_authenticator = no secret = "booboo" shortname = "129.61" } 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 authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating chap Module: Linked to module rlm_mschap Module: Instantiating mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating unix unix { radwtmp = "/var/log/radius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 2048 } 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 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 } } 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" } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_hack = no } Module: Checking authorize {...} for more modules to load 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_files Module: Instantiating 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: Checking session {...} for more modules to load 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: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load Module: Linked to module rlm_attr_filter Module: Instantiating attr_filter.access_reject attr_filter attr_filter.access_reject { attrsfile = "/usr/local/etc/raddb/attrs.access_reject" key = "%{User-Name}" } } # modules } # server server copy-acct-to-home-server { modules { Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_preprocess Module: Instantiating 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: Checking accounting {...} for more modules to load Module: Linked to module rlm_always Module: Instantiating ok always ok { rcode = "ok" simulcount = 0 mpp = no } Module: Checking pre-proxy {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating pre_proxy_log detail pre_proxy_log { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/pre-proxy-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Checking post-proxy {...} for more modules to load Module: Instantiating post_proxy_log detail post_proxy_log { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/post-proxy-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } } # modules } # server server { modules { Module: Checking authenticate {...} for more modules to load Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_attr_rewrite Module: Instantiating hexconvert attr_rewrite hexconvert { attribute = "User-Name" searchfor = "^.*(a)ftth.aw$" searchin = "packet" replacewith = "%{exec:/usr/local/sbin/hexconvert -lX %{User-Name} }" append = no ignore_case = no new_attribute = no max_matches = 1 } 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: Instantiating sanenasport attr_rewrite sanenasport { attribute = "NAS-Port" searchfor = "^.*" searchin = "packet" replacewith = "%{Acct-Session-Id}" append = no ignore_case = no new_attribute = no max_matches = 1 } 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: Instantiating nameonly attr_rewrite nameonly { attribute = "User-Name" searchfor = "@.*$" searchin = "packet" replacewith = "" append = no ignore_case = no new_attribute = no max_matches = 1 } Module: Instantiating attr_filter.accounting_response attr_filter attr_filter.accounting_response { attrsfile = "/usr/local/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 } # 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" } } listen { type = "detail" listen { filename = "/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d" load_factor = 10 poll_interval = 1 retry_interval = 30 } } Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/radiusd/radiusd.sock Listening on detail file /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d as server copy-acct-to-home-server Listening on proxy address * port 1814 Waking up in 0.9 seconds. rad_recv: Accounting-Request packet from host 192.168.1.101 port 50125, id=70, length=245 Acct-Status-Type = Start User-Name = "nathanjoe@comfort" Event-Timestamp = "Aug 31 2009 13:40:56 AST" Acct-Delay-Time = 20 NAS-Identifier = "ERX-2" Acct-Session-Id = "0314462397" NAS-IP-Address = 192.168.1.101 Service-Type = Framed-User Framed-Protocol = PPP Framed-Compression = None ERX-Pppoe-Description = "pppoe 00:90:d0:63:df:79" Framed-IP-Address = 201.229.46.219 Framed-IP-Netmask = 255.255.255.255 ERX-Ingress-Policy-Name = "COMFORT_UP" ERX-Egress-Policy-Name = "COMFORT_DOWN" Calling-Station-Id = "ERX-08000000269" NAS-Port-Type = Ethernet NAS-Port = 2147483917 NAS-Port-Id = "GigabitEthernet 8/0.269:269" Acct-Authentic = RADIUS +- entering group preacct {...} ++[preprocess] returns ok [acct_unique] Hashing 'NAS-Port = 2147483917,Client-IP-Address = 192.168.1.101,NAS-IP-Address = 192.168.1.101,Acct-Session-Id = "0314462397",User-Name = "nathanjoe@comfort"' [acct_unique] Acct-Unique-Session-ID = "526c378c1dcaa12d". ++[acct_unique] returns ok [sanenasport] expand: ^.* -> ^.* [sanenasport] expand: %{Acct-Session-Id} -> 0314462397 sanenasport: Changed value for attribute NAS-Port from '?' to '0314462397' sanenasport: Could not find value pair for attribute NAS-Port ++[sanenasport] returns ok [hexconvert] expand: ^.*(a)ftth.aw$ -> ^.*(a)ftth.aw$ hexconvert: Does not match: User-Name = nathanjoe@comfort ++[hexconvert] returns ok [suffix] Looking up realm "comfort" for User-Name = "nathanjoe@comfort" [suffix] No such realm "comfort" ++[suffix] returns noop ++[files] returns noop +- entering group accounting {...} [detail] expand: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radius/radacct/192.168.1.101/detail-20090831 [detail] /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.101/detail-20090831 [detail] expand: %t -> Mon Aug 31 13:41:10 2009 ++[detail] returns ok ++[unix] returns ok [nameonly] expand: @.*$ -> @.*$ nameonly: Changed value for attribute User-Name from 'nathanjoe@comfort' to 'nathanjoe' ++[nameonly] returns ok [radutmp] expand: /var/log/radius/radutmp -> /var/log/radius/radutmp [radutmp] expand: %{User-Name} -> nathanjoe ++[radutmp] returns ok [attr_filter.accounting_response] expand: %{User-Name} -> nathanjoe attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 70 to 192.168.1.101 port 50125 Finished request 0. Cleaning up request 0 ID 70 with timestamp +1 Going to the next request Waking up in 0.3 seconds. __________ Information from ESET Smart Security, version of virus signature __________ Information from ESET Smart Security, version of virus signature database 4385 (20090831) __________ The message was checked by ESET Smart Security. http://www.eset.com

3 4

Radius, MySQL and encrypted passwords
by retroneo 01 Sep '09

01 Sep '09

Hello all, I'm trying to get Radius to work with encrypted passwords in the MySQL database. My setup : FreeRADIUS 2.1.0 + MySQL + Dialup Admin installed via Ubuntu 9.04's official packages I posted my full config files here (please tell me if you need more info) : http://pastebin.com/f529d2cce If I leave "sql_password_attribute: Crypt-Password" in /etc/freeradius-dialupadmin/admin.conf After creating a user, I get this in the database : 5 | test1 | User-Password | := | $1$B0q/wVK4$2bxfP9RJMfqBbi/APaxa2 And here is the error I get : rad_recv: Access-Request packet from host x.x.x.x port 32769, id=175, length=57 User-Name = "test1" User-Password = "testing" NAS-IP-Address = x.x.x.x NAS-Port = 1812 +- entering group authorize {...} ++[preprocess] returns ok [suffix] No '@' in User-Name = "test1", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound expand: %{User-Name} -> test1 [sql] sql_set_user escaped user --> 'test1' rlm_sql (sql): Reserving sql socket id: 4 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 = 'test1' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test1' ORDER BY id [sql] User found in radcheck table 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 = 'test1' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'test1' ORDER BY id expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'test1' ORDER BY priority rlm_sql_mysql: query: SELECT groupname FROM radusergroup WHERE username = 'test1' ORDER BY priority rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns updated Found Auth-Type = PAP !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! Replacing User-Password in config items with Cleartext-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! Please update your configuration so that the "known good" !!! !!! clear text password is in Cleartext-Password, and not in User-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! +- entering group PAP {...} [pap] login attempt with password "testing" [pap] Using clear text password "$1$B0q/wVK4$2bxfP9RJMfqBbi/APaxa2/" [pap] Passwords don't match ++[pap] returns reject Failed to authenticate the user. Using Post-Auth-Type Reject +- entering group REJECT {...} expand: %{User-Name} -> test1 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.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 175 to x.x.x.x port 32769 But when I set "sql_password_attribute: Crypt-Password" and add "encryption_scheme = crypt" in "modules/pap" I then re-create a new user via dialupadmin, and get this in the database : 4 | test1 | Crypt-Password | := | $1$G/t7x3UX$GcfvNdGecUt6TJDyywOcZ0 I still get a Access-Reject, and this is the debug info : rad_recv: Access-Request packet from host x.x.x.x port 32769, id=230, length=57 User-Name = "test1" User-Password = "testing" NAS-IP-Address = x.x.x.x NAS-Port = 1812 +- entering group authorize {...} ++[preprocess] returns ok [suffix] No '@' in User-Name = "test1", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound expand: %{User-Name} -> test1 [sql] sql_set_user escaped user --> 'test1' rlm_sql (sql): Reserving sql socket id: 4 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 = 'test1' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test1' ORDER BY id [sql] User found in radcheck table 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 = 'test1' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'test1' ORDER BY id expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'test1' ORDER BY priority rlm_sql_mysql: query: SELECT groupname FROM radusergroup WHERE username = 'test1' ORDER BY priority rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns updated Found Auth-Type = PAP +- entering group PAP {...} [pap] login attempt with password "testing" [pap] No password configured for the user. Cannot do authentication ++[pap] returns fail Failed to authenticate the user. Using Post-Auth-Type Reject +- entering group REJECT {...} expand: %{User-Name} -> test1 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.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 230 to x.x.x.x port 32769 For now I tried using crypt, but would like using SHA if possible. Thank you

1 0

Failed to authenticate the user.
by Paweł Pogorzelski 01 Sep '09

01 Sep '09

Hi! I have problem with user authentication. I have Freeradius 2.1.5 with Daloradius and meru controller here is log from freeradius -X ------------------------- rad_recv: Access-Request packet from host 192.168.1.17 port 32768, id=151, length=281 User-Name = "test(a)test.pl" NAS-IP-Address = 192.168.1.17 NAS-Port = 4097 Called-Station-Id = "00-02-B6-35-D2-D2:eduroam_secure" Calling-Station-Id = "00-13-E8-82-90-FD" Framed-MTU = 1250 NAS-Port-Type = Wireless-802.11 Connect-Info = "CONNECT 802.11b/g" EAP-Message = 0x02040060190017030100203f76662de7ba5ad6abd3ddd6e1c9d1e3ce30c9a7c8c3d75d2f72704e3f1dfb741703010030022f4ed8866f1068cb5e6ba40fda334eefba9d407ef8c915bf3b7c14b3019e11c9add4a556e43c6c993f1e18262484d6 State = 0x611ce3106318fa3ccfeca13fec4558b9 Message-Authenticator = 0x6d9a86305cb15774a87d56fa5e9288e6 +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [suffix] Looking up realm "test.pl" for User-Name = "test(a)test.pl" [suffix] Found realm "test.pl" [suffix] Adding Realm = "test.pl" [suffix] Authentication realm is LOCAL. ++[suffix] returns ok [eap] EAP packet type response id 4 length 96 [eap] Continuing tunnel setup. ++[eap] returns ok ++[files] returns noop [sql] expand: %{User-Name} -> test(a)test.pl [sql] sql_set_user escaped user --> 'test(a)test.pl' 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 = 'test(a)test.pl' 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 = 'test(a)test.pl' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'test(a)test.pl' ORDER BY priority rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++? if ("%{control:Proxy-To-Realm}" == 'mojman') expand: %{control:Proxy-To-Realm} -> ? Evaluating ("%{control:Proxy-To-Realm}" == 'mojman') -> FALSE ++? if ("%{control:Proxy-To-Realm}" == 'mojman') -> FALSE Found Auth-Type = EAP +- entering group authenticate {...} [eap] Request found, released from the list [eap] EAP/peap [eap] processing type peap [peap] processing EAP-TLS [peap] eaptls_verify returned 7 [peap] Done initial handshake [peap] eaptls_process returned 7 [peap] EAPTLS_OK [peap] Session established. Decoding tunneled attributes. [peap] Received EAP-TLV response. [peap] Success [peap] FAIL: Forcibly stopping session resumption as it is not allowed. [eap] Freeing handler ++[eap] returns reject Failed to authenticate the user. Using Post-Auth-Type Reject WARNING: Unknown value specified for Post-Auth-Type. Cannot perform requested action. Delaying reject of request 32 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 32 Sending Access-Reject of id 151 to 192.168.1.17 port 32768 EAP-Message = 0x04040004 Message-Authenticator = 0x00000000000000000000000000000000 Waking up in 3.6 seconds. --------------------------------- Please help

2 1