- Freeradius-Users - lists.freeradius.org

Is this possible?
by Dajka Tamás 28 Oct '08

28 Oct '08

Hi, I want to use a freeradius server for the following purposes: - grant authorizaton to Cisco switches via LDAP (group membership checking, etc). - make a WIFI with WPA+802.1x via MS IAS/RRAS (the main auth is done by the IAS, so the freeradius acts as client for IAS/RRAS, and the WIFI APs act as radclients for freeradius) - wired 802.1x via MS IAS/RRAS Is this possible in one server? Thanks, Viper

2 1

Need help for configuration - LDAP with custom files Failover
by Dajka Tamás 28 Oct '08

28 Oct '08

Dear All, I'm facing a problem with Freeradius 2.0.4. I want to make a configuration to allow our Cisco routers to auth via RADIUS. For this, we're using a password file now (let's call it ciscopwd) and another file for granting rights. I want to change the config file, so that the auth is done by LDAP (plain passwords), BUT if the LDAP is not available the ciscopwd file will do the job. How can this be done? (moreover, I want to have some LDAP group limitations on the logins) Thanks in advance, Tamas

2 14

Simultaneous-Use check not working
by DAve 28 Oct '08

28 Oct '08

Good afternoon, I have inherited an aged ICRadius install and I am in process of converting to FreeRadius 1.1.7. Currently I have a master DB on our Management server replicating to two radius servers. Each radius server has a unique sql instance to send accounting data to the master DB. Everything is working, the DB conversion from ICRadius to FreeRadius went fine. In testing the only issue I have found is I am unable to stop Simultaneous use. I read the docs carefully, checked the Wiki, and I believe I have everything configured properly. Using RadiusTest 2.4.3 and radwho I see the following. I check for a login using radwho and I see I have a session, I then attempt both a new auth and start accounting again and still radwho shows only one login. [root@radius1 /usr/local/etc/raddb]# radwho Login Name What TTY When From Location yellowhous yellowhousejake shell S1 Mon 11:35 192.168.4 192.168.0.1 --------------------10/27/2008 11:55:13 AM Test started [check newrad1]------------------------- Info:Sending Access-Request of id 0 to 10.0.241.95:1645 Password = "marlin" User-Name = "yellowhousejake" Framed-IP-Address = 192.168.0.1 Acct-Session-Id = "201" Info: Access-Accept packet from host 10.0.241.95:1645, id=0, length=89 Service-Type = Framed-User Framed-Protocol = PPP Framed-IP-Address = 255.255.255.254 Framed-IP-Netmask = 255.255.255.255 Framed-Routing = None Framed-Compression = Van-Jacobson-TCP-IP Filter-Id = "std.ppp" Framed-MTU = 1500 Port-Limit = 1 Idle-Timeout = 600 Session-Timeout = 28800 Total approved auths: 1 Total denied auths: 0 Total lost auths: 0 Total time(secs): 0 --------------------10/27/2008 11:55:13 AM Test finished [check newrad1]------------------------- --------------------10/27/2008 11:55:40 AM Test started [start acct]------------------------- Info:Sending Accounting-Request of id 0 to 10.0.241.95:1646 User-Name = "yellowhousejake" Acct-Session-Id = "201" Acct-Status-Type = Start NAS-Port = 1 Framed-IP-Address = 192.168.0.1 Info: Accounting-Response packet from host 10.0.241.95:1646, id=0, length=20 Info:Sending Accounting-Request of id 1 to 10.0.241.95:1646 User-Name = "yellowhousejake" Acct-Session-Id = "201" Acct-Status-Type = Alive NAS-Port = 1 Framed-IP-Address = 192.168.0.1 Info: Accounting-Response packet from host 10.0.241.95:1646, id=1, length=20 Total approved auths: 2 Total denied auths: 0 Total lost auths: 0 Total time(secs): 0 --------------------10/27/2008 11:55:40 AM Test finished [start acct]------------------------- --------------------10/27/2008 11:55:40 AM Test started [start acct]------------------------- Info:Sending Accounting-Request of id 0 to 10.0.241.95:1646 User-Name = "yellowhousejake" Acct-Session-Id = "201" Acct-Status-Type = Start NAS-Port = 1 Framed-IP-Address = 192.168.0.1 Info: Accounting-Response packet from host 10.0.241.95:1646, id=0, length=20 Info:Sending Accounting-Request of id 1 to 10.0.241.95:1646 User-Name = "yellowhousejake" Acct-Session-Id = "201" Acct-Status-Type = Alive NAS-Port = 1 Framed-IP-Address = 192.168.0.1 Info: Accounting-Response packet from host 10.0.241.95:1646, id=1, length=20 Total approved auths: 2 Total denied auths: 0 Total lost auths: 0 Total time(secs): 0 --------------------10/27/2008 11:55:40 AM Test finished [start acct]------------------------- [root@radius1 /usr/local/etc/raddb]# radwho Login Name What TTY When From Location yellowhous yellowhousejake shell S1 Mon 11:55 192.168.4 192.168.0.1 Here are the parts of my conf I believe I need to check for simultaneous use. ## radiusd.conf radutmp { filename = ${logdir}/radutmp username = %{User-Name} case_sensitive = yes check_with_nas = no callerid = "yes" } accounting { radutmp ## sradutmp sql_acct } session { radutmp sql_acct } ## sql.conf # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = "SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE UserName='%{SQL-User-Name}' \ AND AcctStopTime = 0" Note I enabled radutmp after sql was failing to stop the second login. I am certain I have missed something simple but I am unable to find it. Any help, cluesmacks, etc are appreciated. DAve -- I am watching the debate and I am very disappointed. The rules are simple, "answer the question". I would vote right now, and I can in Indiana, for the man who answered the question directly, in less than a minute, and then sat down before the green light was out.

3 8

freeradius- update radacct
by Oguzhan Kayhan 28 Oct '08

28 Oct '08

Hello, I have freeradius virtual configurations. Until today all were working without a problem. But today i created a new one and i have a tiny problem about it. It doesnt update sql queries until the user logs off. SO i can not track the statistics of online users and transferred data etc via mysql. But as i see freeradius gets the following packets below in normal intervals And if it was an error about sql.conf i think it wont write the data when user disconnected too.It just does not update the online users data..and i wonder why..Seems like it does not create user data at the begining so it can not update the data too. ----------------------------------------------------------------- expand: 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}') -> 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 ('4906e32a00000001', '83f3f3b94fce6dc1', '7798-1', '', '192.168.182.1', '1', 'Wireless-802.11', DATE_SUB('2008-10-28 13:01:21', INTERVAL (3401 + 0) SECOND), '3401', '', '', '0' << 32 | '34293752', '0' << 32 | '1270253', '00-0E-0C-6E-6E-7C', '00-14-22-A1-BB-AB', '', '', '192.168.182.2', '0', '') NAS-IP-Address = 192.168.182.1 -------------------------------------------------- This is the virtual config and sql.conf parameters i am using (which are same of the previous virtual servers actually) ------------------------- server lojnet { authorize { preprocess files update control { Auth-Type := perl } perl_lojnet } authenticate { Auth-Type Perl { perl_lojnet } } preacct { acct_unique files } accounting { detail unix sql_lojnet } session { sql_lojnet } post-auth { exec Post-Auth-Type REJECT { attr_filter.access_reject } } ----------------------------------- and the sql part belongs to this virtual server -------------------------------------- sql sql_lojnet { database = "mysql" driver = "rlm_sql_${database}" # Connection info: server = "xxxxxxxxx" login = "xxxxxxxxx" password = "xxxxxxxxxx" # Database table configuration for everything except Oracle radius_db = "lojnet" acct_table1 = "radacct" acct_table2 = "radacct" # Allow for storing data after authentication postauth_table = "radpostauth" authcheck_table = "radcheck" authreply_table = "radreply" groupcheck_table = "radgroupcheck" groupreply_table = "radgroupreply" # Table to keep group info usergroup_table = "usergroup" # If set to 'yes' (default) we read the group tables # If set to 'no' the user MUST have Fall-Through = Yes in the radreply table # read_groups = yes # Remove stale session if checkrad does not see a double login deletestalesessions = yes # Print all SQL statements when in debug mode (-x) sqltrace = no sqltracefile = ${logdir}/sqltrace.sql # number of sql connections to make to server num_sql_socks = 5 # number of seconds to dely retrying on a failed database # connection (per_socket) # number of seconds to dely retrying on a failed database # connection (per_socket) connect_failure_retry_delay = 60 #readclients = yes # Table to keep radius client info nas_table = "nas" # Read driver-specific configuration $INCLUDE sql/${database}/dialup.conf }

2 4

rlm_unix cannot find users (2.1.0)
by Martin Pauly 28 Oct '08

28 Oct '08

Hi all, I am trying to upgrade from an ancient 1.0.5 to 2.1.0, and ran into trouble where I least expected it. Underneath is Debian Lenny system run as Linux vserver. I have a large set of users handled by LDAP, and a small group (admins with only a few logins) that I used to handle by setting up a bunch of local unix accounts and doing Auth-Type := System. So my users file looks like pauly Auth-Type := System, Calling-Station-Id =~ "our-special-id-prefix" Reply-Message = "Matched local user entry %{User-Name} in users file", [ more local accounts ...] DEFAULT Auth-Type := Reject, Calling-Station-Id =~ "our-special-id-prefix" Reply-Message = "Illegal username %{User-Name} for this type of request" DEFAULT User-Name = `%{User-Name}`, Reply-Message = "Matched DEFAULT user entry with User-Name %{User-Name}" In sites-available/default, I have 'unix' in both the authorize and authenticate section. The debug output upon a request reads: rad_recv: Access-Request packet from host 192.168.x.y port 1645, id=204, length=77 NAS-IP-Address = 192.168.x.y NAS-Port = 1 NAS-Port-Type = Virtual User-Name = "pauly" Calling-Station-Id = "our-special-id" User-Password = "xxxxxx" +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [suffix] No '@' in User-Name = "pauly", 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: %{Calling-Station-Id} -> our-special-id [files] users: Matched entry pauly at line 17 expand: Matched local user entry %{User-Name} in users file -> Matched local user entry pauly in users file ++[files] returns ok [ the whole thing is sent to LDAP for authorization now which succeeds, but could perhaps be avoided anyway] ++- entering policy redundant {...} [ldap stuff ...] [ldap2] user pauly authorized to use remote access rlm_ldap: ldap_release_conn: Release Id: 0 +++[ldap2] returns ok ++- policy redundant 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 = System +- entering group authenticate {...} ++[unix] returns notfound Failed to authenticate the user. Using Post-Auth-Type Reject +- entering group REJECT {...} expand: %{User-Name} -> pauly attr_filter: Matched entry DEFAULT at line 11 So to me it looks like rlm_unix can't find me :-( I've read about rlm_passwd, but I don't need any caching or the like. Oh, and user freerad is in group shadow. But as I understand it, this is no longer relevant for my case since rlm_unix uses getpwent which is supposed to handle access to /etc/shadow, right? Thanks for any hint Martin -- Dr. Martin Pauly Fax: 49-6421-28-26994 HRZ Univ. Marburg Phone: 49-6421-28-23527 Hans-Meerwein-Str. E-Mail: pauly(a)HRZ.Uni-Marburg.DE D-35032 Marburg

2 2

let radius distinguish more cases
by alois blasbichler 28 Oct '08

28 Oct '08

hello list I have a question to understanding better radius. For this i make a simple example-scenario : I want to use my radius for 2 things : 1. wireless-access for laptops with machine authentication over a wireless switch with ip 1.1.1.1 2. authentication for the login to my switches for some admin-users My machines (case 1) are in a samba-domain and saved in a openldap-DB in the tree : basedn = "ou=samba-machines,dc=sb-brixen,dc=it" My users (case 2), where i select my admins with a ldap-filter are also in an openldap-dB in the tree: basedn = "ou=users,dc=sb-brixen,dc=it" How and where i distinguish this 2 cases? In the standard configuration, what i have understood radius let try the clients a lot of possibilities and i have read its better to not restrict the auth-methods. A possibility to solve my question is to make 2 files under /modules like ldap1 and ldap2 for my separate cases - but now my problem : Where i say that my wireless switch gos to ldap1 (with mschap) and my switches (for example all the network 1.1.20.x) gos to ldap2 (with ldap-authentication) : in users, or maybe in raddb/sites-available/default In clients.conf i have defined my switches and my network. For the users-file i have seen som examples like : DEFAULT Huntgroup-Name = "vpn-pix",Auth-Type := ldap But where i define "Huntgroup-Name = "vpn-pix"" is this the normal name in the client.conf ? Thank you for a response luis

2 1

Insert billiplan code in radacct table during authenticaiton
by Bishal 27 Oct '08

27 Oct '08

Hi all, I am using freeradius for AAA of my cable users. Now what I want to do is, insert billiplan code 001 into radacct table during authentication so that I can view online users according to billingplan code. There will be Billingplan field in radcheck table and when users tries to login the script will check the radcheck table and update that billingplan code into radacct table. Is it possible with rlm_perl module? Thank you Bishal

4 8

EAP-MSK & WiMAX-MSK validity?
by Stefano Colagreco 27 Oct '08

27 Oct '08

Hi All, i use: - WiMAX-MSK = EAP-MSK and all it works correctly, and I suppose It's validity is only for the authentication session, it is right? - WiMAX-AAA-Session-Id: is set as a pseudo-random value. It's correct? It's value is related to the duration of the session? Thanks all in advance! Stefano

1 0

Help with sqlippool
by Madwifi 27 Oct '08

27 Oct '08

I need some help trying to configure sqlippool. I've followed the instruction from http://wiki.freeradius.org/Rlm_sqlippool and few other places. I did compile FR from source with the following configuration options: Options 1: ./configure --prefix=/usr/local/freeradius-server-2.1.1 --with-openssl --with-threads --with-vmps --with-modules=rlm_sqlippool Options 2: ./configure --prefix=/usr/local/freeradius-server-2.1.1 --with-openssl --with-threads --with-vmps --with-rlm_sqlippool Options 3: ./configure --prefix=/usr/local/freeradius-server-2.1.1 --with-openssl --with-threads --with-vmps --enable-rlm_sqlippool Each time my start access point running hostapd, FR crashes with the following message. Sun Oct 26 22:10:49 2008 : Info: ++[sradutmp] returns ok Sun Oct 26 22:10:49 2008 : Debug: rlm_sql (sql): Reserving sql socket id: 1 Sun Oct 26 22:10:49 2008 : Info: [sqlippool] expand: %{User-Name} -> Sun Oct 26 22:10:49 2008 : Info: [sqlippool] sql_set_user escaped user --> '' Sun Oct 26 22:10:49 2008 : Info: [sqlippool] expand: START TRANSACTION -> START TRANSACTION radiusd: symbol lookup error: /usr/local/freeradius-server-2.1.1/lib/rlm_sqlippool-2.1.1.so: undefined symbol: rlm_sql_query Below are my configuration OS: Ubuntu (Kernel 2.6.24-21) FR: 2.1.1 radiusd.conf exec_prefix = ${prefix} sysconfdir = ${prefix}/etc localstatedir = ${prefix}/var sbindir = ${exec_prefix}/sbin logdir = ${localstatedir}/log/radius raddbdir = ${sysconfdir}/raddb radacctdir = ${logdir}/radacct name = radiusd confdir = ${raddbdir} run_dir = ${localstatedir}/run/radiusd db_dir = ${raddbdir} libdir = ${exec_prefix}/lib pidfile = ${run_dir}/${name}.pid max_request_time = 30 cleanup_delay = 5 max_requests = 1024 listen { type = auth ipaddr = * port = 0 } listen { ipaddr = * port = 0 type = acct } hostname_lookups = no allow_core_dumps = no regular_expressions = yes extended_expressions = yes log { destination = files file = ${logdir}/radius.log syslog_facility = daemon stripped_names = no auth = no auth_badpass = no auth_goodpass = no } checkrad = ${sbindir}/checkrad security { max_attributes = 200 reject_delay = 1 status_server = yes } proxy_requests = yes $INCLUDE proxy.conf $INCLUDE clients.conf thread pool { start_servers = 5 max_servers = 32 min_spare_servers = 3 max_spare_servers = 10 max_requests_per_server = 0 } modules { $INCLUDE ${confdir}/modules/ $INCLUDE eap.conf $INCLUDE sql.conf $INCLUDE sql/mysql/counter.conf $INCLUDE sqlippool.conf } instantiate { exec expr daily expiration logintime } $INCLUDE policy.conf $INCLUDE sites-enabled/ sites-enabled/default authorize { preprocess chap mschap suffix eap { ok = return } unix #files sql daily expiration logintime pap } authenticate { Auth-Type PAP { pap } Auth-Type CHAP { chap } Auth-Type MS-CHAP { mschap } unix eap } preacct { preprocess acct_unique suffix #files } accounting { detail daily unix radutmp sradutmp sqlippool sql sql_log attr_filter.accounting_response } session { radutmp } post-auth { sqlippool reply_log sql sql_log exec Post-Auth-Type REJECT { attr_filter.access_reject } } pre-proxy { } post-proxy { eap } ippool.conf allocate-clear = "UPDATE ${ippool_table} \ SET nasipaddress = '', pool_key = 0, \ callingstationid = '', username = '', \ expiry_time IS NULL \ WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}'" allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ WHERE pool_name = '%{control:Pool-Name}' AND expiry_time < NOW() \ ORDER BY (username <> '%{User-Name}'), \ (callingstationid <> '%{Calling-Station-Id}'), \ expiry_time \ LIMIT 1 \ FOR UPDATE" pool-check = "SELECT id FROM ${ippool_table} \ WHERE pool_name='%{control:Pool-Name}' LIMIT 1" allocate-update = "UPDATE ${ippool_table} \ SET nasipaddress = '%{NAS-IP-Address}', pool_key = '${pool-key}', \ callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', \ expiry_time = NOW() + INTERVAL ${lease-duration} SECOND \ WHERE framedipaddress = '%I'" start-update = "UPDATE ${ippool_table} \ SET expiry_time = NOW() + INTERVAL ${lease-duration} SECOND \ WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '${pool-key}'" stop-clear = "UPDATE ${ippool_table} \ SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', \ expiry_time IS NULL \ WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '${pool-key}' \ AND username = '%{User-Name}' \ AND callingstationid = '%{Calling-Station-Id}' \ AND framedipaddress = '%{Framed-IP-Address}'" alive-update = "UPDATE ${ippool_table} \ SET expiry_time = NOW() + INTERVAL ${lease-duration} SECOND \ WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '${pool-key}' \ AND username = '%{User-Name}' \ AND callingstationid = '%{Calling-Station-Id}' \ AND framedipaddress = '%{Framed-IP-Address}'" on-clear = "UPDATE ${ippool_table} \ SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', \ expiry_time IS NULL \ WHERE nasipaddress = '%{Nas-IP-Address}'" off-clear = "UPDATE ${ippool_table} \ SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', \ expiry_time IS NULL \ WHERE nasipaddress = '%{Nas-IP-Address}'" sqlippool.conf sqlippool { sql-instance-name = "sql" ippool_table = "radippool" lease-duration = 3600 pool-key = "%{NAS-Port}" #pool-key = "%{Calling-Station-Id}" $INCLUDE sql/mysql/ippool.conf sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} \ (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" sqlippool_log_success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} \ (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" sqlippool_log_clear = "Released IP %{Framed-IP-Address}\ (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" sqlippool_log_failed = "IP Allocation FAILED from %{control:Pool-Name} \ (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" sqlippool_log_nopool = "No Pool-Name defined \ (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" } radippool table mysql> select * from radippool; +----+-----------+-----------------+--------------+---------------------------+------------------+-------------+----------+----------+-----------------+-------------+----------+----------+ | id | pool_name | framedipaddress | nasipaddress | calledstationid | callingstationid | expiry_time | username | pool_key | +----+-----------+-----------------+--------------+---------------------------+------------------+-------------+----------+----------+-----------------+-------------+----------+----------+ | 2 | main_pool | 10.5.5.29 | 192.168.2.31 | 06-07-6F-4A-C1-60:Tlink-g | | NULL | testuser | | | 3 | main_pool | 10.5.5.30 | 192.168.2.31 | 06-07-6F-4A-C1-60:Tlink-g | | NULL | testuser2 | | +----+-----------+-----------------+--------------+---------------------------+------------------+-------------+----------+----------+-----------------+-------------+----------+----------+ 2 rows in set (0.00 sec)

1 0

How long do dynamic clients stay cached?
by jasoneswan 26 Oct '08

26 Oct '08

How long do dynamic clients stay cached? And is this time configurable? -- View this message in context: http://www.nabble.com/How-long-do-dynamic-clients-stay-cached--tp20171312p2… Sent from the FreeRadius - User mailing list archive at Nabble.com.

4 3