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

multiple fields from rlm_mysql?
by Jorge Pereira 04 May '15

04 May '15

Hi, I would like to know if have some way to do the below example in a single query. something like a tuple/foreach or otherwise way. my current solution is: My-AVP-A = "%{sql: SELECT field_a FROM tb_my WHERE field_a = '%{Value_A}'}" My-AVP-B = "%{sql: SELECT field_b FROM tb_my WHERE field_b = '%{Value_B}'}" My-AVP-C = "%{sql: SELECT field_c FROM tb_my WHERE field_c = '%{Value_C}'}" My-AVP-D = "%{sql: SELECT field_d FROM tb_my WHERE field_d = '%{Value_D}'}" the problem it's because i would like to avoid multiple queries. -- Jorge Pereira

3 5

Integrate Freeradius with DHCP
by Mohd Alkhaldi 04 May '15

04 May '15

Hi, We have multiple Radius servers, How can we get Framed-Ip-Address from central DHCP server, and release the IP when receive Accounting Stop. Best Regards, Alwaadalhaq

3 2

reading hosts from NAS table not working on 2.2.6?
by Alexander Silveröhrt 03 May '15

03 May '15

Hello, Anyone knows what could be wrong? We are trying to move from an older version to a newer version (2.2.6.) But can't get hosts reading from NAS table to work..And it has always been working. After recompiling and installing...Now hosts from the NAS table is read but not working anymore.. Debug at server start says it is reading all the hosts from database nas table but all requests gets rejected anyway. #############Radius debug . . . . Thu Apr 30 12:16:57 2015 : Info: rlm_sql (sql-smartedge-bng): Attempting to connect rlm_sql_mysql #49 Thu Apr 30 12:16:57 2015 : Info: rlm_sql_mysql: Starting connect to MySQL server for #49 Thu Apr 30 12:16:57 2015 : Info: rlm_sql (sql-smartedge-bng): Connected new DB handle, #49 Thu Apr 30 12:16:57 2015 : Debug: rlm_sql (sql-smartedge-bng): Processing generate_sql_clients Thu Apr 30 12:16:57 2015 : Debug: rlm_sql (sql-smartedge-bng) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas_smartedge Thu Apr 30 12:16:57 2015 : Debug: rlm_sql (sql-smartedge-bng): Reserving sql socket id: 49 TThu Apr 30 13:09:46 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=10.173.5.11,shortname=labb0,secret=redback Thu Apr 30 13:09:46 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 10.173.5.11 (labb0, server=smartedge-bng) to clients list . . . . . Thu Apr 30 12:16:57 2015 : Debug: rlm_sql (sql-smartedge-bng): Released sql socket id: 49 When sending a test from the local server echo "User-Name = 'alex_smartedge', NAS-Identifier = 'labb0', NAS-IP-Address = '10.173.5.11'" | radclient -x -s -c 1 -r 1 -t 3 10.173.5.11:1812 auth redback Thu Apr 30 12:48:50 2015 : Error: Ignoring request to authentication address 10.173.5.11 port 1812 from unknown client 10.173.5.11 port 60611 Thu Apr 30 12:48:50 2015 : Info: Ready to process requests. If i add local server to client.conf instead then it works client labb0{ ipaddr = 10.173.5.11 netmask = 32 secret = redback require_message_authenticator = no nastype = other virtual_server = smartedge-bng #coa_server = coa } echo "User-Name = 'alex_smartedge', NAS-Identifier = 'labb0', NAS-IP-Address = '10.173.5.11'" | radclient -x -s -c 1 -r 1 -t 3 10.173.5.11:1812 auth redback Sending Access-Request of id 168 to 10.173.5.11 port 1812 User-Name = "alex_smartedge" NAS-Identifier = "labb0" NAS-IP-Address = 10.173.5.11 rad_recv: Access-Accept packet from host 10.173.5.11 port 1812, id=168, length=115 DHCP-Max-Leases = 1 Qos-Policing-Profile-Name = "default_qos_policing_policy" Qos-Metering-Profile-Name = "default_qos_metering_policy" Context-Name = "BASIC" Total approved auths: 1 Total denied auths: 0 Total lost auths: 0 #############Radius debug rad_recv: Access-Request packet from host 10.173.5.11 port 60305, id=168, length=49 User-Name = "alex_smartedge" NAS-Identifier = "labb0" NAS-IP-Address = 192.168.6.5 Thu Apr 30 13:03:33 2015 : Info: server smartedge-bng { Thu Apr 30 13:03:33 2015 : Info: # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/smartedge-bng Any clues on what could be wrong? I can't see anything weird in the test conf? server smartedge-bng { authorize { bla... bla... sql-smartedge-bng preprocess perl-smartedge-bng } authenticate { bla... bla... perl-smartedge-bng } accounting { bla... bla... sql-smartedge-bng perl-smartedge-bng } } ### sql.conf ### ##default sql { bla... bla... readclients = yes nas_table = "nas" $INCLUDE sql/${database}/dialup.conf } sql sql-smartedge-bng { bla... bla... readclients = yes nas_table = "nas_smartedge" $INCLUDE sql/${database}/dialup-smartedge-bng.conf } sql server2 { bla.. bla.. $INCLUDE sql/${database}/server2.conf } sql server3 { bla.. bla.. $INCLUDE sql/${database}/server3.conf } etc. etc. ********* DISCLAIMER ********* This message and any attachment are confidential and may be privileged or otherwise protected from disclosure and may include proprietary information. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person

3 14

ldapi:// with SASL/EXTERNAL
by Michael Ströder 02 May '15

02 May '15

HI! My FreeRADIUS 3.0.8 server works with OpenLDAP also with ldapi:// and simple bind. But it does not work with SASL/EXTERNAL bind (see relevant -X output attached below). A short test as the correct demon user 'radiusd' with ldapwhoami -H ldapi:// -Y EXTERNAL returns the expected and correct authz-DN. But if FreeRADIUS starts OpenLDAP logs look strange: 2015-05-02T00:28:03.170556+02:00 srv3 slapd[1350]: conn=1344 fd=18 ACCEPT from PATH=/run/slapd/ldapi (PATH=/run/slapd/ldapi) 2015-05-02T00:28:03.172464+02:00 srv3 slapd[1350]: conn=1344 op=0 BIND dn="" method=163 2015-05-02T00:28:03.173796+02:00 srv3 slapd[1350]: conn=1344 op=0 RESULT tag=97 err=14 text=SASL(0): successful result: 2015-05-02T00:28:03.179488+02:00 srv3 slapd[1350]: connection_operation: error: SASL bind in progress (tag=66). 2015-05-02T00:28:03.179758+02:00 srv3 slapd[1350]: conn=1344 op=1 RESULT tag=48 err=1 text=SASL bind in progress 2015-05-02T00:28:03.180154+02:00 srv3 slapd[1350]: conn=1344 fd=18 closed Ciao, Michael. --------------------------- snip --------------------------- # Loaded module rlm_ldap # Instantiating module "ldap" from file /etc/raddb/mods-enabled/ldap ldap { server = "ldapi://" sasl_mech = "EXTERNAL" user { scope = "sub" access_positive = yes } group { filter = "(objectClass=posixGroup)" scope = "sub" name_attribute = "cn" membership_attribute = "memberOf" membership_filter = "(member=%{control:Ldap-UserDn})" cacheable_name = no cacheable_dn = no } client { filter = "(objectClass=radiusClient)" scope = "sub" base_dn = "${..base_dn}" } profile { } options { ldap_debug = 40 chase_referrals = no rebind = yes net_timeout = 1 res_timeout = 20 srv_timelimit = 20 idle = 60 probes = 3 interval = 3 } tls { start_tls = no } } rlm_ldap: libldap vendor: OpenLDAP, version: 20440 accounting { reference = "%{tolower:type.%{Acct-Status-Type}}" } post-auth { reference = "." } rlm_ldap (ldap): Initialising connection pool pool { start = 5 min = 4 max = 6 spare = 3 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 1 spread = no } WARNING: Ignoring "spare = 3", forcing to "spare = 2" rlm_ldap (ldap): Opening additional connection (0), 1 of 6 pending slots used rlm_ldap (ldap): Connecting to ldapi:// rlm_ldap (ldap): Waiting for bind result... rlm_ldap (ldap): Bind with (anonymous) to ldapi:// failed: SASL bind in progress rlm_ldap (ldap): Server said: SASL(0): successful result: . rlm_ldap (ldap): Opening connection failed (0) rlm_ldap (ldap): Removing connection pool /etc/raddb/mods-enabled/ldap[8]: Instantiation failed for module "ldap"

2 1

adding policies
by Juan Pablo L. 01 May '15

01 May '15

Hi, i m trying to enabled policies in my AAA, but i m getting the following error: Thu Apr 30 13:02:22 2015 : Error: ~/etc/raddb/policy.d/filter[66]: Failed to find "reject" as a module or policy. Thu Apr 30 13:02:22 2015 : Error: ~/etc/raddb/policy.d/filter[66]: Please verify that the configuration exists in ~/etc/raddb/mods-enabled/reject. Thu Apr 30 13:02:22 2015 : Error: ~/etc/raddb/policy.d/filter[66]: Failed to parse "reject" entry. Thu Apr 30 13:02:22 2015 : Error: ~/etc/raddb/policy.d/filter[65]: Failed to parse "if" subsection. Thu Apr 30 13:02:22 2015 : Error: ~/etc/raddb/sites-enabled/default[220]: Errors parsing authorize section. i have enabled policies in radius.conf: policy { $INCLUDE policy.d/ } i have defined the policy in the ~/etc/raddb/policy.d/filter filter_username { if (User-Name != "%{tolower:%{User-Name}}") { reject } } and i configured sites-available/default to call the policy in the authorize section by simply calling the name of the filter: filter_username but i get the above error, i would appreciate where to look for more info about this. thanks!!

2 5

3.0.3 Segmentation fault (core dumped)
by Mohamed Lrhazi 01 May '15

01 May '15

Hello, Running 3.0.3... from ppa:freeradius/stable-3.0 /usr/sbin/freeradius -v freeradius: FreeRADIUS Version 3.0.3, for host x86_64-pc-linux-gnu, built on May 20 2014 at 11:59:21 Am running four instances (in docker containers) on two VMs... behind a load balancer. After running for a couple hundred hours, instances start hitting seg faults... restarting the instances gets them going again for few hundred hours... How would you debug this in production settings? should I upgrade to newer version first? Thanks, Mohamed.

7 10

Re: Freeradius-Users Digest, Vol 121, Issue 1
by Rui Ribeiro 01 May '15

01 May '15

Hi, You where told the solution, and you chose to ignore it, and then ask why. The make deb makes the necessary changes to conform to the Debian environment. Debian has it´s own rules. Plus, installing from debs has other niceties like besides tracking things and being capable of uninstalling, also allows you to upgrade and not think much about losing the current config. Regards > Message: 5 > Date: Thu, 30 Apr 2015 18:31:47 -0400 > From: Mohamed Lrhazi <Mohamed.Lrhazi(a)georgetown.edu> > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Subject: Re: 3.0.3 Segmentation fault (core dumped) > Message-ID: > < > CAEU_gmcTXXCNf6HYFGWeb6BmfF3Vik17uFQk28WPr5hBq9tCDA(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Thanks guys.. got it to build and install cleanly with the bellow > Dockerfile... "make deb" works too, but decided to use make install > instead. > > I notice it installs as /etc/raddb... instead of the /etc/freeradius the > previous package I was using used... also the binary is radiusd, instead of > freeradius... is there a switch to ./configure to change these things? > > Thanks a lot, > Mohamed. > > FROM ubuntu:latest > > # Run upgrades > RUN apt-get update && apt-get -y upgrade > > # Install dependencies > RUN apt-get install -y software-properties-common build-essential > checkinstall libssl1.0.0 libssl-dev libtalloc-dev debhelper quilt > autotools-dev libcurl4-gnutls-dev libcap-dev libgdbm-dev libiodbc2-dev > libjson-c-dev libkrb5-dev libldap2-dev libpam0g-dev libpcap-dev > libperl-dev libmysqlclient-dev libpq-dev libreadline-dev libsasl2-dev > libsqlite3-dev libwbclient-dev libyubikey-dev python-dev > > RUN mkdir /src > ADD files/freeradius-server-3.0.8.tar.gz /src > RUN cd /src/freeradius-server-3.0.8 && ./configure --prefix=/ && make && > make install > > > > -- Regards, -- Rui Ribeiro Senior Sysadm ISCTE-IUL https://www.linkedin.com/pub/rui-ribeiro/16/ab8/434

2 2