- Freeradius-Users - lists.freeradius.org

How to update a MySql table after successfully WIFI authentication?
by 2394263740 01 Sep '11

01 Sep '11

Hello, I'm using free radius server 2.1.11 on Linux Enterprise Server 6.1. OS: Linux Enterprise Server 6.1 Radius: free radius server 2.1.11 Database: Mysql I got a WIFI network, using one radius server. The whole thing works fine. I got a requirement, which is, after each successful WIFI connection, one record need be added into connectionlog table. CREATE TABLE connectionlog ( radacctid bigint(21) NOT NULL auto_increment, acctsessionid varchar(64) NOT NULL default '', acctuniqueid varchar(32) NOT NULL default '', username varchar(64) NOT NULL default '', groupname varchar(64) NOT NULL default '', realm varchar(64) default '', nasipaddress varchar(15) NOT NULL default '', nasportid varchar(15) default NULL, nasporttype varchar(32) default NULL, acctstarttime datetime NULL default NULL, acctstoptime datetime NULL default NULL, acctsessiontime int(12) default NULL, acctauthentic varchar(32) default NULL, connectinfo_start varchar(50) default NULL, connectinfo_stop varchar(50) default NULL, acctinputoctets bigint(20) default NULL, acctoutputoctets bigint(20) default NULL, calledstationid varchar(50) NOT NULL default '', callingstationid varchar(50) NOT NULL default '', acctterminatecause varchar(32) NOT NULL default '', servicetype varchar(32) default NULL, framedprotocol varchar(32) default NULL, framedipaddress varchar(15) NOT NULL default '', acctstartdelay int(12) default NULL, acctstopdelay int(12) default NULL, xascendsessionsvrkey varchar(10) default NULL, PRIMARY KEY (radacctid), KEY username (username), KEY framedipaddress (framedipaddress), KEY acctsessionid (acctsessionid), KEY acctsessiontime (acctsessiontime), KEY acctuniqueid (acctuniqueid), KEY acctstarttime (acctstarttime), KEY acctstoptime (acctstoptime), KEY nasipaddress (nasipaddress) ) ; Can you please kindly advise how to do this? Which file should be edited? Where is the context to put in the script? What is the script? Thanks! Tom

2 1

Re: Special WIFI Router MAC check for the user's first connection (Tom)
by 2394263740 01 Sep '11

01 Sep '11

Arran, Thanks for your kind reply. It works. As you and Phil advised, I edit 2 files. /usr/local/etc/raddb/sites-available/default /usr/local/etc/raddb/sites-available/inner-tunnel The script Phil wrote was put right after "sql" line. Thanks! Tom ------------------ Original ------------------ From: "freeradius-users"<freeradius-users-request(a)lists.freeradius.org>; Date: Thu, Sep 1, 2011 09:48 PM To: "freeradius-users"<freeradius-users(a)lists.freeradius.org>; Subject: Freeradius-Users Digest, Vol 77, Issue 3 Send Freeradius-Users mailing list submissions to freeradius-users(a)lists.freeradius.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeradius.org/mailman/listinfo/freeradius-users or, via email, send a message with subject or body 'help' to freeradius-users-request(a)lists.freeradius.org You can reach the person managing the list at freeradius-users-owner(a)lists.freeradius.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Freeradius-Users digest..." Today's Topics: 1. Re: Special WIFI Router MAC check for the user's first connection. (Tom) (Arran Cudbard-Bell) ---------------------------------------------------------------------- Message: 1 Date: Thu, 1 Sep 2011 15:48:18 +0200 From: Arran Cudbard-Bell <a.cudbardb(a)freeradius.org> Subject: Re: Special WIFI Router MAC check for the user's first connection. (Tom) To: FreeRadius users mailing list <freeradius-users(a)lists.freeradius.org> Message-ID: <5FF70066-722F-42B0-B2E1-6B63649E133F(a)freeradius.org> Content-Type: text/plain; charset="iso-8859-1" On 1 Sep 2011, at 15:40, 2394263740 wrote: > Phil, > > Thanks a lot for your great help. > > I understand the scripts you wrote. But I don't know where I should put it in. > > Can you please kindly advise which file I should edit? > > /usr/local/etc/raddb/sites-available/default? Yes in the authorize section, thats why the script is encapsulated within and authorize {} stanza :) -Arran > > > > ------------------ Original ------------------ > From: "freeradius-users"<freeradius-users-request(a)lists.freeradius.org>; > Date: Thu, Sep 1, 2011 02:51 AM > To: "freeradius-users"<freeradius-users(a)lists.freeradius.org>; > Subject: Freeradius-Users Digest, Vol 76, Issue 108 > > Send Freeradius-Users mailing list submissions to > freeradius-users(a)lists.freeradius.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.freeradius.org/mailman/listinfo/freeradius-users > or, via email, send a message with subject or body 'help' to > freeradius-users-request(a)lists.freeradius.org > > You can reach the person managing the list at > freeradius-users-owner(a)lists.freeradius.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Freeradius-Users digest..." > > > Today's Topics: > > 1. Re: Example configuration that proxy PEAP MSCHAPv2 to an IAS > server (Phil Mayers) > 2. Re: Special WIFI Router MAC check for the user?s first > connection. (Phil Mayers) > 3. Using rlm_passwd as a substitute for hunt groups > (Jan.Weiss(a)t-systems.com) > 4. problem with LDAP backend (Frank Bonnet) > 5. Re: problem with chillispot (Alan DeKok) > 6. Re: problem with LDAP backend (Alan DeKok) > 7. Rating usage (Shreya Shah) > 8. Re: problem with chillispot (Goke M Aruna) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 31 Aug 2011 14:48:00 +0100 > From: Phil Mayers <p.mayers(a)imperial.ac.uk> > Subject: Re: Example configuration that proxy PEAP MSCHAPv2 to an IAS > server > To: freeradius-users(a)lists.freeradius.org > Message-ID: <4E5E3B90.2020109(a)imperial.ac.uk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 30/08/11 21:12, Glenn Machin wrote: > > Phil - thanks for the feedback. > > > > I just ended up proxying out to the IAS server usernames starting with > > "DOMAIN\". > > Ok. Obviously that will fail if enters their wireless credentials > without a domain. > > > > > I configured the freeradius server to not support mschapv2 but will > > support PEAP/GTC EAP/TLS. > > > > > > It seems to be working fine with the Macs, iPads and Linux systems while > > the windows systems are happy to talk to the IAS server. > > > > > > It still bugs that ntlm_auth would not authenticate to the domain > > controllers the challenge and nt-response. > > I repeat: if you send debug info, people may be able to help. > > > > > > > I assume no one else is having any issues using ntlm_auth to W2008 > > servers? It may be some Windows GPO at our site for all I know. > > Exactly which version of windows (2008 or 2008R2?) and at which > functional level is your domain? > > Did you try increasing the debug level for winbind using "smbcontrol" > and then examining the debug logs after a failed auth? > > For what it's worth, we have no problems with Windows 2008R2 domain > controllers and the "samba3x" package available under RHEL5 (samba > version 3.5.4-0.70.el5). We did have problems with earlier (Samba 3.3) > versions after we'd upgraded to 2008R2 and upgraded functional level. > > > ------------------------------ > > Message: 2 > Date: Wed, 31 Aug 2011 14:55:35 +0100 > From: Phil Mayers <p.mayers(a)imperial.ac.uk> > Subject: Re: Special WIFI Router MAC check for the user?s first > connection. > To: freeradius-users(a)lists.freeradius.org > Message-ID: <4E5E3D57.2000903(a)imperial.ac.uk> > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 31/08/11 12:38, 2394263740 wrote: > > > For example, WIFI AP 26, has the MAC address MAC26. I need ensure one > > WIFI user, say user 58, must connect to WIFI AP 26 for the first time. > > After the first connection, user 58 can connect to any WIFI AP in the > > network. > > Can someone give some advice on how to do it? > > 1. Create a whitelist of users who can authenticate to any AP using > files, rlm_passwd or ideally SQL - see the FreeRADIUS wiki > > 2. If they are *not* found in the whitelist, check the > "Called-Station-Id" attribute, which usually contains the MAC address of > the AP. If your equipment uses a different attribute, check that. > > 3. If the AP MAC is the correct one, add the user to the whitelist, > else reject > > For example: > > authorize { > > ... > update control { > Tmp-String-0 := "%{sql:select 1 from whitelist where > username='%{User-Name}'}" > } > if (control:Tmp-String-0 == 1) { > # user is in whitelist > } > elsif (Called-Station-Id == "aa-bb-cc-dd-ee-ff") { > # user is connecting to the "whitelist" AP > update control { > Tmp-String-0 = "%{sql:insert into whitelist (username) values > ('%{User-Name}')}" > } > } > else { > reject > } > ... > > } > > > ------------------------------ > > Message: 3 > Date: Wed, 31 Aug 2011 16:11:48 +0200 > From: Jan.Weiss(a)t-systems.com > Subject: Using rlm_passwd as a substitute for hunt groups > To: <freeradius-users(a)lists.freeradius.org> > Message-ID: > <3DD77603D0726248A46541D5119607CE27DFC71606(a)HE111524.emea1.cds.t-internal.com> > > Content-Type: text/plain; charset="us-ascii" > > >Did you remember to actually define 'My-Device-Group' as an attribute? > > > >-Arran > > > >Arran Cudbard-Bell > >a.cudbardb(a)freeradius.org > > > >RADIUS - Half the complexity of Diameter > > > Dictionary: > ATTRIBUTE My-Device-Group 3000 string > > > ------------------------------ > > Message: 4 > Date: Wed, 31 Aug 2011 17:02:32 +0200 > From: Frank Bonnet <f.bonnet(a)esiee.fr> > Subject: problem with LDAP backend > To: freeradius-users(a)lists.freeradius.org > Message-ID: <4E5E4D08.5060109(a)esiee.fr> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hello > > Still trying to use freeradius with chillispot I still have problems > > I'm trying to use mixed authentication > > MAC addresses for some video devices in the "users" file > as follows : > > 00-06-F4-0D-08-66 Auth-Type := Local, User-Password == "xxxxxxxx" > Framed-IP-Address = 192.168.182.213, > Fall-Through = Yes > > LDAP backend for "real" users at the end of the "users" file I have this > statement > > DEFAULT Auth-Type = LDAP > Fall-Through = 1 > > This configuration were working well on a very old debian machine which > died suddenly > > When I try to access the the chilli portal it ask radius for authentication > but it dows not work. See below the debug trace of radius daemon. > Help greatly appreciated, thank you. > > > Wed Aug 31 16:52:39 2011 : Debug: Processing the authorize section of > radiusd.conf > Wed Aug 31 16:52:39 2011 : Debug: modcall: entering group authorize for > request 15 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling > preprocess (rlm_preprocess) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from > preprocess (rlm_preprocess) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module > "preprocess" returns ok for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling eap > (rlm_eap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: rlm_eap: No EAP-Message, not doing EAP > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from > eap (rlm_eap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "eap" > returns noop for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling files > (rlm_files) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: users: Matched entry DEFAULT at > line 398 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from > files (rlm_files) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "files" > returns ok for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling ldap > (rlm_ldap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: - authorize > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: performing user > authorization for xxxxxxxx > Wed Aug 31 16:52:39 2011 : Debug: radius_xlat: '(uid=xxx)' > Wed Aug 31 16:52:39 2011 : Debug: radius_xlat: 'ou=Users,dc=esiee,dc=fr' > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_get_conn: Checking Id: 0 > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_get_conn: Got Id: 0 > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: performing search in > ou=Users,dc=esiee,dc=fr, with filter (uid=hrazdira) > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: checking if remote access > for xxxxxxxx is allowed by uid > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: looking for check items in > directory... > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: looking for reply items in > directory... > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: user xxxxxxxx authorized to > use remote access > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_release_conn: Release Id: 0 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from > ldap (rlm_ldap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "ldap" > returns ok for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling pap > (rlm_pap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: rlm_pap: WARNING! No "known good" > password found for the user. Authentication may fail because of this. > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from > pap (rlm_pap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "pap" > returns noop for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall: leaving group authorize > (returns ok) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: rad_check_password: Found Auth-Type > LDAP > Wed Aug 31 16:52:39 2011 : Debug: auth: type "LDAP" > Wed Aug 31 16:52:39 2011 : Debug: Processing the authenticate section > of radiusd.conf > Wed Aug 31 16:52:39 2011 : Debug: modcall: entering group authenticate > for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authenticate]: calling > ldap (rlm_ldap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: - authenticate > Wed Aug 31 16:52:39 2011 : Auth: rlm_ldap: Attribute "User-Password" is > required for authentication. Cannot use "CHAP-Password". > Wed Aug 31 16:52:39 2011 : Debug: modsingle[authenticate]: returned > from ldap (rlm_ldap) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall[authenticate]: module "ldap" > returns invalid for request 15 > Wed Aug 31 16:52:39 2011 : Debug: modcall: leaving group authenticate > (returns invalid) for request 15 > Wed Aug 31 16:52:39 2011 : Debug: auth: Failed to validate the user. > Wed Aug 31 16:52:39 2011 : Debug: Delaying request 15 for 1 seconds > Wed Aug 31 16:52:39 2011 : Debug: Finished request 15 > Wed Aug 31 16:52:39 2011 : Debug: Going to the next request > Wed Aug 31 16:52:39 2011 : Debug: --- Walking the entire request list --- > > > > ------------------------------ > > Message: 5 > Date: Wed, 31 Aug 2011 12:27:36 -0400 > From: Alan DeKok <aland(a)deployingradius.com> > Subject: Re: problem with chillispot > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <4E5E60F8.8070409(a)deployingradius.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Goke M Aruna wrote: > > Is it bug on freeradius v2? > > No. > > > I got the chillispot working with freeradius 1.7 then and still tested > > same recently but v2 of radius give same error while v1 work > > seamlessly. I compiled this on centos 5.6. > > You mistyped the shared secret. > > Alan DeKok. > > > ------------------------------ > > Message: 6 > Date: Wed, 31 Aug 2011 12:30:45 -0400 > From: Alan DeKok <aland(a)deployingradius.com> > Subject: Re: problem with LDAP backend > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <4E5E61B5.2000601(a)deployingradius.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Frank Bonnet wrote: > > MAC addresses for some video devices in the "users" file > > as follows : > > > > 00-06-F4-0D-08-66 Auth-Type := Local, User-Password == "xxxxxxxx" > > That's wrong. See the debug output for reasons why. See the FAQ for > correct examples. > > > LDAP backend for "real" users at the end of the "users" file I have this > > statement > > > > DEFAULT Auth-Type = LDAP > > Fall-Through = 1 > > That's not needed. > > > Wed Aug 31 16:52:39 2011 : Auth: rlm_ldap: Attribute "User-Password" is > > required for authentication. Cannot use "CHAP-Password". > > That's pretty clear. The NAS is sending a CHAP request. You can't do > that with "Auth-Type LDAP" > > Instead, list "ldap" in the "authorize" section. > > Don't set Auth-Type. It's almost always wrong. > > Alan DeKok. > > > ------------------------------ > > Message: 7 > Date: Wed, 31 Aug 2011 13:23:20 -0400 > From: Shreya Shah <shreya.nshah(a)gmail.com> > Subject: Rating usage > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: > <CANN_Z9KOKD0HfM+s_wVmZTyobN=8qcLxbfdQBBrX+KBPUBo-2w(a)mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Is it possible to rate users based on their data usage and reject > authentication to those users exceeding the limit ? > > I think I can achieve rating using counter.conf and reading the usage from > radacct but not sure how to reject this user from authenticating when he > exceeds this usage limit ? > > Thanks, > Shreya. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/2011083…> > > ------------------------------ > > Message: 8 > Date: Wed, 31 Aug 2011 19:51:20 +0100 > From: Goke M Aruna <goksie(a)gmail.com> > Subject: Re: problem with chillispot > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: > <CAE=DitpQoroJHxQA7u+BtCuXhEh0_1V-TahmuW1ntgiO9_e69Q(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi Allan, > Mistyped shared-secret? How can I confirm that? > > Thank you. > > On 8/31/11, Alan DeKok <aland(a)deployingradius.com> wrote: > > Goke M Aruna wrote: > >> Is it bug on freeradius v2? > > > > No. > > > >> I got the chillispot working with freeradius 1.7 then and still tested > >> same recently but v2 of radius give same error while v1 work > >> seamlessly. I compiled this on centos 5.6. > > > > You mistyped the shared secret. > > > > Alan DeKok. > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > -- > Sent from my mobile device > > > ------------------------------ > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > End of Freeradius-Users Digest, Vol 76, Issue 108 > ************************************************* > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Arran Cudbard-Bell a.cudbardb(a)freeradius.org RADIUS - Half the complexity of Diameter -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/2011090…> ------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html End of Freeradius-Users Digest, Vol 77, Issue 3 ***********************************************

1 0

Re: Special WIFI Router MAC check for the user's first connection. (Tom)
by 2394263740 01 Sep '11

01 Sep '11

Phil, Thanks a lot for your great help. I understand the scripts you wrote. But I don't know where I should put it in. Can you please kindly advise which file I should edit? /usr/local/etc/raddb/sites-available/default? Where I should put the scripts you wrote previously? The context? Thanks! Tom ------------------ Original ------------------ From: "freeradius-users"<freeradius-users-request(a)lists.freeradius.org>; Date: Thu, Sep 1, 2011 02:51 AM To: "freeradius-users"<freeradius-users(a)lists.freeradius.org>; Subject: Freeradius-Users Digest, Vol 76, Issue 108 Send Freeradius-Users mailing list submissions to freeradius-users(a)lists.freeradius.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeradius.org/mailman/listinfo/freeradius-users or, via email, send a message with subject or body 'help' to freeradius-users-request(a)lists.freeradius.org You can reach the person managing the list at freeradius-users-owner(a)lists.freeradius.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Freeradius-Users digest..." Today's Topics: 1. Re: Example configuration that proxy PEAP MSCHAPv2 to an IAS server (Phil Mayers) 2. Re: Special WIFI Router MAC check for the user?s first connection. (Phil Mayers) 3. Using rlm_passwd as a substitute for hunt groups (Jan.Weiss(a)t-systems.com) 4. problem with LDAP backend (Frank Bonnet) 5. Re: problem with chillispot (Alan DeKok) 6. Re: problem with LDAP backend (Alan DeKok) 7. Rating usage (Shreya Shah) 8. Re: problem with chillispot (Goke M Aruna) ---------------------------------------------------------------------- Message: 1 Date: Wed, 31 Aug 2011 14:48:00 +0100 From: Phil Mayers <p.mayers(a)imperial.ac.uk> Subject: Re: Example configuration that proxy PEAP MSCHAPv2 to an IAS server To: freeradius-users(a)lists.freeradius.org Message-ID: <4E5E3B90.2020109(a)imperial.ac.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 30/08/11 21:12, Glenn Machin wrote: > Phil - thanks for the feedback. > > I just ended up proxying out to the IAS server usernames starting with > "DOMAIN\". Ok. Obviously that will fail if enters their wireless credentials without a domain. > > I configured the freeradius server to not support mschapv2 but will > support PEAP/GTC EAP/TLS. > > > It seems to be working fine with the Macs, iPads and Linux systems while > the windows systems are happy to talk to the IAS server. > > > It still bugs that ntlm_auth would not authenticate to the domain > controllers the challenge and nt-response. I repeat: if you send debug info, people may be able to help. > > > I assume no one else is having any issues using ntlm_auth to W2008 > servers? It may be some Windows GPO at our site for all I know. Exactly which version of windows (2008 or 2008R2?) and at which functional level is your domain? Did you try increasing the debug level for winbind using "smbcontrol" and then examining the debug logs after a failed auth? For what it's worth, we have no problems with Windows 2008R2 domain controllers and the "samba3x" package available under RHEL5 (samba version 3.5.4-0.70.el5). We did have problems with earlier (Samba 3.3) versions after we'd upgraded to 2008R2 and upgraded functional level. ------------------------------ Message: 2 Date: Wed, 31 Aug 2011 14:55:35 +0100 From: Phil Mayers <p.mayers(a)imperial.ac.uk> Subject: Re: Special WIFI Router MAC check for the user?s first connection. To: freeradius-users(a)lists.freeradius.org Message-ID: <4E5E3D57.2000903(a)imperial.ac.uk> Content-Type: text/plain; charset=UTF-8; format=flowed On 31/08/11 12:38, 2394263740 wrote: > For example, WIFI AP 26, has the MAC address MAC26. I need ensure one > WIFI user, say user 58, must connect to WIFI AP 26 for the first time. > After the first connection, user 58 can connect to any WIFI AP in the > network. > Can someone give some advice on how to do it? 1. Create a whitelist of users who can authenticate to any AP using files, rlm_passwd or ideally SQL - see the FreeRADIUS wiki 2. If they are *not* found in the whitelist, check the "Called-Station-Id" attribute, which usually contains the MAC address of the AP. If your equipment uses a different attribute, check that. 3. If the AP MAC is the correct one, add the user to the whitelist, else reject For example: authorize { ... update control { Tmp-String-0 := "%{sql:select 1 from whitelist where username='%{User-Name}'}" } if (control:Tmp-String-0 == 1) { # user is in whitelist } elsif (Called-Station-Id == "aa-bb-cc-dd-ee-ff") { # user is connecting to the "whitelist" AP update control { Tmp-String-0 = "%{sql:insert into whitelist (username) values ('%{User-Name}')}" } } else { reject } ... } ------------------------------ Message: 3 Date: Wed, 31 Aug 2011 16:11:48 +0200 From: Jan.Weiss(a)t-systems.com Subject: Using rlm_passwd as a substitute for hunt groups To: <freeradius-users(a)lists.freeradius.org> Message-ID: <3DD77603D0726248A46541D5119607CE27DFC71606(a)HE111524.emea1.cds.t-internal.com> Content-Type: text/plain; charset="us-ascii" >Did you remember to actually define 'My-Device-Group' as an attribute? > >-Arran > >Arran Cudbard-Bell >a.cudbardb(a)freeradius.org > >RADIUS - Half the complexity of Diameter Dictionary: ATTRIBUTE My-Device-Group 3000 string ------------------------------ Message: 4 Date: Wed, 31 Aug 2011 17:02:32 +0200 From: Frank Bonnet <f.bonnet(a)esiee.fr> Subject: problem with LDAP backend To: freeradius-users(a)lists.freeradius.org Message-ID: <4E5E4D08.5060109(a)esiee.fr> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hello Still trying to use freeradius with chillispot I still have problems I'm trying to use mixed authentication MAC addresses for some video devices in the "users" file as follows : 00-06-F4-0D-08-66 Auth-Type := Local, User-Password == "xxxxxxxx" Framed-IP-Address = 192.168.182.213, Fall-Through = Yes LDAP backend for "real" users at the end of the "users" file I have this statement DEFAULT Auth-Type = LDAP Fall-Through = 1 This configuration were working well on a very old debian machine which died suddenly When I try to access the the chilli portal it ask radius for authentication but it dows not work. See below the debug trace of radius daemon. Help greatly appreciated, thank you. Wed Aug 31 16:52:39 2011 : Debug: Processing the authorize section of radiusd.conf Wed Aug 31 16:52:39 2011 : Debug: modcall: entering group authorize for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling preprocess (rlm_preprocess) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from preprocess (rlm_preprocess) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "preprocess" returns ok for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling eap (rlm_eap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_eap: No EAP-Message, not doing EAP Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from eap (rlm_eap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "eap" returns noop for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling files (rlm_files) for request 15 Wed Aug 31 16:52:39 2011 : Debug: users: Matched entry DEFAULT at line 398 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from files (rlm_files) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "files" returns ok for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: - authorize Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: performing user authorization for xxxxxxxx Wed Aug 31 16:52:39 2011 : Debug: radius_xlat: '(uid=xxx)' Wed Aug 31 16:52:39 2011 : Debug: radius_xlat: 'ou=Users,dc=esiee,dc=fr' Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_get_conn: Checking Id: 0 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_get_conn: Got Id: 0 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: performing search in ou=Users,dc=esiee,dc=fr, with filter (uid=hrazdira) Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: checking if remote access for xxxxxxxx is allowed by uid Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: looking for check items in directory... Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: looking for reply items in directory... Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: user xxxxxxxx authorized to use remote access Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_release_conn: Release Id: 0 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "ldap" returns ok for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling pap (rlm_pap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_pap: WARNING! No "known good" password found for the user. Authentication may fail because of this. Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from pap (rlm_pap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "pap" returns noop for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall: leaving group authorize (returns ok) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rad_check_password: Found Auth-Type LDAP Wed Aug 31 16:52:39 2011 : Debug: auth: type "LDAP" Wed Aug 31 16:52:39 2011 : Debug: Processing the authenticate section of radiusd.conf Wed Aug 31 16:52:39 2011 : Debug: modcall: entering group authenticate for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authenticate]: calling ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: - authenticate Wed Aug 31 16:52:39 2011 : Auth: rlm_ldap: Attribute "User-Password" is required for authentication. Cannot use "CHAP-Password". Wed Aug 31 16:52:39 2011 : Debug: modsingle[authenticate]: returned from ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authenticate]: module "ldap" returns invalid for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall: leaving group authenticate (returns invalid) for request 15 Wed Aug 31 16:52:39 2011 : Debug: auth: Failed to validate the user. Wed Aug 31 16:52:39 2011 : Debug: Delaying request 15 for 1 seconds Wed Aug 31 16:52:39 2011 : Debug: Finished request 15 Wed Aug 31 16:52:39 2011 : Debug: Going to the next request Wed Aug 31 16:52:39 2011 : Debug: --- Walking the entire request list --- ------------------------------ Message: 5 Date: Wed, 31 Aug 2011 12:27:36 -0400 From: Alan DeKok <aland(a)deployingradius.com> Subject: Re: problem with chillispot To: FreeRadius users mailing list <freeradius-users(a)lists.freeradius.org> Message-ID: <4E5E60F8.8070409(a)deployingradius.com> Content-Type: text/plain; charset=ISO-8859-1 Goke M Aruna wrote: > Is it bug on freeradius v2? No. > I got the chillispot working with freeradius 1.7 then and still tested > same recently but v2 of radius give same error while v1 work > seamlessly. I compiled this on centos 5.6. You mistyped the shared secret. Alan DeKok. ------------------------------ Message: 6 Date: Wed, 31 Aug 2011 12:30:45 -0400 From: Alan DeKok <aland(a)deployingradius.com> Subject: Re: problem with LDAP backend To: FreeRadius users mailing list <freeradius-users(a)lists.freeradius.org> Message-ID: <4E5E61B5.2000601(a)deployingradius.com> Content-Type: text/plain; charset=ISO-8859-1 Frank Bonnet wrote: > MAC addresses for some video devices in the "users" file > as follows : > > 00-06-F4-0D-08-66 Auth-Type := Local, User-Password == "xxxxxxxx" That's wrong. See the debug output for reasons why. See the FAQ for correct examples. > LDAP backend for "real" users at the end of the "users" file I have this > statement > > DEFAULT Auth-Type = LDAP > Fall-Through = 1 That's not needed. > Wed Aug 31 16:52:39 2011 : Auth: rlm_ldap: Attribute "User-Password" is > required for authentication. Cannot use "CHAP-Password". That's pretty clear. The NAS is sending a CHAP request. You can't do that with "Auth-Type LDAP" Instead, list "ldap" in the "authorize" section. Don't set Auth-Type. It's almost always wrong. Alan DeKok. ------------------------------ Message: 7 Date: Wed, 31 Aug 2011 13:23:20 -0400 From: Shreya Shah <shreya.nshah(a)gmail.com> Subject: Rating usage To: FreeRadius users mailing list <freeradius-users(a)lists.freeradius.org> Message-ID: <CANN_Z9KOKD0HfM+s_wVmZTyobN=8qcLxbfdQBBrX+KBPUBo-2w(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Is it possible to rate users based on their data usage and reject authentication to those users exceeding the limit ? I think I can achieve rating using counter.conf and reading the usage from radacct but not sure how to reject this user from authenticating when he exceeds this usage limit ? Thanks, Shreya. -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/2011083…> ------------------------------ Message: 8 Date: Wed, 31 Aug 2011 19:51:20 +0100 From: Goke M Aruna <goksie(a)gmail.com> Subject: Re: problem with chillispot To: FreeRadius users mailing list <freeradius-users(a)lists.freeradius.org> Message-ID: <CAE=DitpQoroJHxQA7u+BtCuXhEh0_1V-TahmuW1ntgiO9_e69Q(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi Allan, Mistyped shared-secret? How can I confirm that? Thank you. On 8/31/11, Alan DeKok <aland(a)deployingradius.com> wrote: > Goke M Aruna wrote: >> Is it bug on freeradius v2? > > No. > >> I got the chillispot working with freeradius 1.7 then and still tested >> same recently but v2 of radius give same error while v1 work >> seamlessly. I compiled this on centos 5.6. > > You mistyped the shared secret. > > Alan DeKok. > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > -- Sent from my mobile device ------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html End of Freeradius-Users Digest, Vol 76, Issue 108 *************************************************

2 1

AW: Using rlm_passwd as a substitute for hunt groups
by Jan.Weiss＠t-systems.com 01 Sep '11

01 Sep '11

Hi, I made further tests, and (imho) it seems that rlm_passwd can´t handle IP-Addresses. In my setup the module is able to assign "My-Device-Group" when searching for: -User-Name -User-Password -NAS-Port But not when searching for NAS-IP-Address :-( I´m using freeradius2-2.1.7-7.el5 Jan

2 1

Re: Freeradius-Users Digest, Vol 77, Issue 1
by david.suarezdelis＠telefonica.es 01 Sep '11

01 Sep '11

Hi, > Date: Thu, 1 Sep 2011 10:59:32 +0300 > From: Boian Jordanov <bjordanov(a)orbitel.bg> > > On Aug 30, 2011, at 12:06 PM, david.suarezdelis(a)telefonica.es wrote: > > > in libperl.a. I include the complete output of radiusd -X below with both > > Did you compile perl with support for libperl.so ? Yes, but some other problems got in the middle, so things were a bit harder to solve. There are two issues here: First, that factory packages for Debian 6 weren't working together; and second, problems with compilation. On the second case, I was compiling both Freeradius and Perl but my Perl build (after several attempts) got things mangled. A make realclean solved the issue, but I got some problems because the change of running user ruined the perlbrew instalation (an access to libraries, etc). I have finally solved it, just an hour ago, by compiling Freeradius-2.1.11 and linking it to the system-wide libperl.so available library (somehow upgrading to Perl-5.14.1 is hard on Debian, as apt-get insist the installed package is the newest, even specifying the experimental repos, probably I am doing something wrong). Anyway, I will take the chance and link to 5.14.1 (eventually) as Perl 5.10 is about to get out of support... So it's solved, and the pointers I got were very helpful, thanks a lot for your attention. As for the first issue, I'll contact the package maintainers and let them know there's some mismatch (I suspect it is either an LD_PRELOAD issue or maybe the package has some problems, I recall that on versions 1.x there were several freeradius debian packages...) So thanks and best regards, dwd

1 0

Symbol "Perl_hv_undef_flags" problem using rlm_perl
by david.suarezdelis＠telefonica.es 01 Sep '11

01 Sep '11

Greetings, I have installed a Debian 6 stable on a 64b machine. Using the factory freeradius-2.1.10 and perl-5.10.1 I got a symbol lookup problem, which sounded weird enough... So I downloaded both last stable versions (Freeradius-2.1.11 and Perl 5.14.1) and compiled them myself, making sure that all Perl symbols were available (I compiled everything with -g and -fPIC where it made sense). Using perlbrew I made sure that Freeradius was indeed finding the right Perl version and everything compiled and installed perfectly. However, when making some testing on localhost with radtest the problem reappeared (with exactly the same error as the debian packaged versions). I am not sure why this is failing, as the symbols are, indeel, available in libperl.a. I include the complete output of radiusd -X below with both the correct localuser test and the failed one. Thanks in advance for any hints. dwd PS- the output: root@myserver:/var/tmp/2.1.11/freeradius-server-2.1.11# sh -x /usr/local/sbin/rc.radiusd start + prefix=/usr/local + exec_prefix=/usr/local + sbindir=/usr/local/sbin + localstatedir=/usr/local/var + logdir=/usr/local/var/log/radius + rundir=/usr/local/var/run/radiusd + sysconfdir=/usr/local/etc + export LD_LIBRARY_PATH LD_RUN_PATH LD_PRELOAD + RADIUSD=/usr/local/sbin/radiusd + RADDBDIR=/usr/local/etc/raddb + DESC=FreeRADIUS + ARGS= + test -f /usr/local/sbin/radiusd + test -f /usr/local/etc/raddb/radiusd.conf + echo -n Starting FreeRADIUS: Starting FreeRADIUS:+ /usr/local/sbin/radiusd -X FreeRADIUS Version 2.1.11, for host x86_64-unknown-linux-gnu, built on Aug 30 2011 at 09:35:35 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/soh including configuration file /usr/local/etc/raddb/modules/exec including configuration file /usr/local/etc/raddb/modules/attr_filter including configuration file /usr/local/etc/raddb/modules/smsotp including configuration file /usr/local/etc/raddb/modules/counter including configuration file /usr/local/etc/raddb/modules/detail including configuration file /usr/local/etc/raddb/modules/dynamic_clients including configuration file /usr/local/etc/raddb/modules/rediswho including configuration file /usr/local/etc/raddb/modules/sql_log including configuration file /usr/local/etc/raddb/modules/krb5 including configuration file /usr/local/etc/raddb/modules/replicate including configuration file /usr/local/etc/raddb/modules/perl.ORIG including configuration file /usr/local/etc/raddb/modules/realm including configuration file /usr/local/etc/raddb/modules/ldap including configuration file /usr/local/etc/raddb/modules/perl.EVOAR including configuration file /usr/local/etc/raddb/modules/detail.example.com including configuration file /usr/local/etc/raddb/modules/detail.log including configuration file /usr/local/etc/raddb/modules/otp including configuration file /usr/local/etc/raddb/modules/ippool including configuration file /usr/local/etc/raddb/modules/files including configuration file /usr/local/etc/raddb/modules/attr_rewrite including configuration file /usr/local/etc/raddb/modules/mac2vlan including configuration file /usr/local/etc/raddb/modules/sqlcounter_expire_on_login including configuration file /usr/local/etc/raddb/modules/etc_group including configuration file /usr/local/etc/raddb/modules/linelog including configuration file /usr/local/etc/raddb/modules/acct_unique including configuration file /usr/local/etc/raddb/modules/opendirectory including configuration file /usr/local/etc/raddb/modules/inner-eap including configuration file /usr/local/etc/raddb/modules/checkval including configuration file /usr/local/etc/raddb/modules/pam including configuration file /usr/local/etc/raddb/modules/expiration including configuration file /usr/local/etc/raddb/modules/logintime including configuration file /usr/local/etc/raddb/modules/digest including configuration file /usr/local/etc/raddb/modules/passwd including configuration file /usr/local/etc/raddb/modules/sradutmp including configuration file /usr/local/etc/raddb/modules/mac2ip including configuration file /usr/local/etc/raddb/modules/perl including configuration file /usr/local/etc/raddb/modules/redis including configuration file /usr/local/etc/raddb/modules/wimax 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/ntlm_auth including configuration file /usr/local/etc/raddb/modules/radutmp including configuration file /usr/local/etc/raddb/modules/expr including configuration file /usr/local/etc/raddb/modules/unix including configuration file /usr/local/etc/raddb/modules/pap including configuration file /usr/local/etc/raddb/modules/smbpasswd including configuration file /usr/local/etc/raddb/modules/preprocess including configuration file /usr/local/etc/raddb/modules/policy including configuration file /usr/local/etc/raddb/modules/mschap including configuration file /usr/local/etc/raddb/modules/cui including configuration file /usr/local/etc/raddb/modules/always 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/control-socket including configuration file /usr/local/etc/raddb/sites-enabled/default including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel main { user = "freerad" group = "freerad" allow_core_dumps = no } including dictionary file /usr/local/etc/raddb/dictionary main { name = "freeradius" prefix = "/usr" localstatedir = "/var" sbindir = "/usr/sbin" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/freeradius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = no log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no } security { max_attributes = 200 reject_delay = 1 status_server = yes } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = "testing123" response_window = 20 max_outstanding = 65536 require_message_authenticator = yes zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client 127.0.0.1 { require_message_authenticator = no secret = "testing123" shortname = "localhost" nastype = "other" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating module "exec" from file /usr/local/etc/raddb/modules/exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating module "expr" from file /usr/local/etc/raddb/modules/expr Module: Linked to module rlm_expiration Module: Instantiating module "expiration" from file /usr/local/etc/raddb/modules/expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating module "logintime" from file /usr/local/etc/raddb/modules/logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } Module: Linked to module rlm_perl Module: Instantiating module "perl" from file /usr/local/etc/raddb/modules/perl.ORIG perl { module = "/usr/local/etc/raddb/example.pl" func_authorize = "authorize" func_authenticate = "authenticate" func_accounting = "accounting" func_preacct = "preacct" func_checksimul = "checksimul" func_detach = "detach" func_xlat = "xlat" func_pre_proxy = "pre_proxy" func_post_proxy = "post_proxy" func_post_auth = "post_auth" func_recv_coa = "recv_coa" func_send_coa = "send_coa" } } radiusd: #### Loading Virtual Servers #### server { # from file /usr/local/etc/raddb/radiusd.conf modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating module "pap" from file /usr/local/etc/raddb/modules/pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating module "chap" from file /usr/local/etc/raddb/modules/chap Module: Linked to module rlm_mschap Module: Instantiating module "mschap" from file /usr/local/etc/raddb/modules/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no allow_retry = yes } Module: Linked to module rlm_digest Module: Instantiating module "digest" from file /usr/local/etc/raddb/modules/digest Module: Linked to module rlm_unix Module: Instantiating module "unix" from file /usr/local/etc/raddb/modules/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating module "eap" from file /usr/local/etc/raddb/eap.conf eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 4096 } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 Module: Linked to sub-module rlm_eap_leap Module: Instantiating eap-leap Module: Linked to sub-module rlm_eap_gtc Module: Instantiating eap-gtc gtc { challenge = "Password: " auth_type = "PAP" } Module: Linked to sub-module rlm_eap_tls Module: Instantiating eap-tls tls { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 CA_path = "/usr/local/etc/raddb/certs" pem_file_type = yes private_key_file = "/usr/local/etc/raddb/certs/server.pem" certificate_file = "/usr/local/etc/raddb/certs/server.pem" CA_file = "/usr/local/etc/raddb/certs/ca.pem" private_key_password = "whatever" dh_file = "/usr/local/etc/raddb/certs/dh" random_file = "/usr/local/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/usr/local/etc/raddb/certs/bootstrap" cache { enable = no lifetime = 24 max_entries = 255 } verify { } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" } } Module: Linked to sub-module rlm_eap_ttls Module: Instantiating eap-ttls ttls { default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes } Module: Linked to sub-module rlm_eap_peap Module: Instantiating eap-peap peap { default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_preprocess Module: Instantiating module "preprocess" from file /usr/local/etc/raddb/modules/preprocess preprocess { huntgroups = "/usr/local/etc/raddb/huntgroups" hints = "/usr/local/etc/raddb/hints" with_ascend_hack = no ascend_channels_per_line = 23 with_ntdomain_hack = no with_specialix_jetstream_hack = no with_cisco_vsa_hack = no with_alvarion_vsa_hack = no } Module: Linked to module rlm_realm Module: Instantiating module "suffix" from file /usr/local/etc/raddb/modules/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_files Module: Instantiating module "files" from file /usr/local/etc/raddb/modules/files files { usersfile = "/usr/local/etc/raddb/users" acctusersfile = "/usr/local/etc/raddb/acct_users" preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" compat = "no" } Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating module "acct_unique" from file /usr/local/etc/raddb/modules/acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } Module: Checking accounting {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating module "detail" from file /usr/local/etc/raddb/modules/detail detail { detailfile = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Linked to module rlm_radutmp Module: Instantiating module "radutmp" from file /usr/local/etc/raddb/modules/radutmp radutmp { filename = "/var/log/freeradius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes perm = 384 callerid = yes } Module: Linked to module rlm_attr_filter Module: Instantiating module "attr_filter.accounting_response" from file /usr/local/etc/raddb/modules/attr_filter 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 Module: Instantiating module "attr_filter.access_reject" from file /usr/local/etc/raddb/modules/attr_filter attr_filter attr_filter.access_reject { attrsfile = "/usr/local/etc/raddb/attrs.access_reject" key = "%{User-Name}" } } # modules } # server server inner-tunnel { # from file /usr/local/etc/raddb/sites-enabled/inner-tunnel modules { Module: Checking authenticate {...} for more modules to load Module: Checking authorize {...} for more modules to load Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load } # 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/freeradius/freeradius.sock" } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/freeradius/freeradius.sock Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 41585, id=20, length=62 User-Name = "test" User-Password = "hola1234" NAS-IP-Address = 127.0.0.1 NAS-Port = 1 Framed-Protocol = PPP # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop ++[digest] returns noop [suffix] No '@' in User-Name = "test", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop [files] users: Matched entry test at line 1 ++[files] returns ok ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns updated Found Auth-Type = PAP # Executing group from file /usr/local/etc/raddb/sites-enabled/default +- entering group PAP {...} [pap] login attempt with password "hola1234" [pap] Using clear text password "hola1234" [pap] User authenticated successfully ++[pap] returns ok # Executing section post-auth from file /usr/local/etc/raddb/sites-enabled/default +- entering group post-auth {...} ++[exec] returns noop Sending Access-Accept of id 20 to 127.0.0.1 port 41585 Service-Type = Framed-User Framed-Protocol = PPP Finished request 0. Going to the next request Waking up in 4.9 seconds. Cleaning up request 0 ID 20 with timestamp +7 Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 50419, id=37, length=65 User-Name = "un24956" User-Password = "hola1234" NAS-IP-Address = 127.0.0.1 NAS-Port = 1 Framed-Protocol = PPP # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop ++[digest] returns noop [suffix] No '@' in User-Name = "un24956", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop [files] users: Matched entry DEFAULT at line 7 ++[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 = External # Executing group from file /usr/local/etc/raddb/sites-enabled/default +- entering group External {...} /usr/local/sbin/radiusd: symbol lookup error: /usr/local/lib/rlm_perl-2.1.11.so: undefined symbol: Perl_hv_undef_flags + echo radiusd radiusd + exit 0

3 2

Rating usage
by Shreya Shah 31 Aug '11

31 Aug '11

Is it possible to rate users based on their data usage and reject authentication to those users exceeding the limit ? I think I can achieve rating using counter.conf and reading the usage from radacct but not sure how to reject this user from authenticating when he exceeds this usage limit ? Thanks, Shreya.

2 1

problem with LDAP backend
by Frank Bonnet 31 Aug '11

31 Aug '11

Hello Still trying to use freeradius with chillispot I still have problems I'm trying to use mixed authentication MAC addresses for some video devices in the "users" file as follows : 00-06-F4-0D-08-66 Auth-Type := Local, User-Password == "xxxxxxxx" Framed-IP-Address = 192.168.182.213, Fall-Through = Yes LDAP backend for "real" users at the end of the "users" file I have this statement DEFAULT Auth-Type = LDAP Fall-Through = 1 This configuration were working well on a very old debian machine which died suddenly When I try to access the the chilli portal it ask radius for authentication but it dows not work. See below the debug trace of radius daemon. Help greatly appreciated, thank you. Wed Aug 31 16:52:39 2011 : Debug: Processing the authorize section of radiusd.conf Wed Aug 31 16:52:39 2011 : Debug: modcall: entering group authorize for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling preprocess (rlm_preprocess) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from preprocess (rlm_preprocess) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "preprocess" returns ok for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling eap (rlm_eap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_eap: No EAP-Message, not doing EAP Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from eap (rlm_eap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "eap" returns noop for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling files (rlm_files) for request 15 Wed Aug 31 16:52:39 2011 : Debug: users: Matched entry DEFAULT at line 398 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from files (rlm_files) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "files" returns ok for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: - authorize Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: performing user authorization for xxxxxxxx Wed Aug 31 16:52:39 2011 : Debug: radius_xlat: '(uid=xxx)' Wed Aug 31 16:52:39 2011 : Debug: radius_xlat: 'ou=Users,dc=esiee,dc=fr' Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_get_conn: Checking Id: 0 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_get_conn: Got Id: 0 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: performing search in ou=Users,dc=esiee,dc=fr, with filter (uid=hrazdira) Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: checking if remote access for xxxxxxxx is allowed by uid Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: looking for check items in directory... Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: looking for reply items in directory... Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: user xxxxxxxx authorized to use remote access Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: ldap_release_conn: Release Id: 0 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "ldap" returns ok for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: calling pap (rlm_pap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_pap: WARNING! No "known good" password found for the user. Authentication may fail because of this. Wed Aug 31 16:52:39 2011 : Debug: modsingle[authorize]: returned from pap (rlm_pap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authorize]: module "pap" returns noop for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall: leaving group authorize (returns ok) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rad_check_password: Found Auth-Type LDAP Wed Aug 31 16:52:39 2011 : Debug: auth: type "LDAP" Wed Aug 31 16:52:39 2011 : Debug: Processing the authenticate section of radiusd.conf Wed Aug 31 16:52:39 2011 : Debug: modcall: entering group authenticate for request 15 Wed Aug 31 16:52:39 2011 : Debug: modsingle[authenticate]: calling ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: rlm_ldap: - authenticate Wed Aug 31 16:52:39 2011 : Auth: rlm_ldap: Attribute "User-Password" is required for authentication. Cannot use "CHAP-Password". Wed Aug 31 16:52:39 2011 : Debug: modsingle[authenticate]: returned from ldap (rlm_ldap) for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall[authenticate]: module "ldap" returns invalid for request 15 Wed Aug 31 16:52:39 2011 : Debug: modcall: leaving group authenticate (returns invalid) for request 15 Wed Aug 31 16:52:39 2011 : Debug: auth: Failed to validate the user. Wed Aug 31 16:52:39 2011 : Debug: Delaying request 15 for 1 seconds Wed Aug 31 16:52:39 2011 : Debug: Finished request 15 Wed Aug 31 16:52:39 2011 : Debug: Going to the next request Wed Aug 31 16:52:39 2011 : Debug: --- Walking the entire request list ---

2 1

Using rlm_passwd as a substitute for hunt groups
by Jan.Weiss＠t-systems.com 31 Aug '11

31 Aug '11

>Did you remember to actually define 'My-Device-Group' as an attribute? > >-Arran > >Arran Cudbard-Bell >a.cudbardb(a)freeradius.org > >RADIUS - Half the complexity of Diameter Dictionary: ATTRIBUTE My-Device-Group 3000 string

1 0

Special WIFI Router MAC check for the user’s first connection.
by 2394263740 31 Aug '11

31 Aug '11

Special WIFI Router MAC check for the user’s first connection. I’m using free radius server 2.1.11 on Linux Enterprise Server 6.1. OS: Linux Enterprise Server 6.1 Radius: free radius server 2.1.11 Database: Mysql WIFI AP: Use WPA/WPA2 There’re about 100 WIFI APs in the network. All these APs use this free radius server. The whole thing is working fine. Now I got a requirement, this requirement need to check the WIFI AP MAC address for user’s first login. For example, WIFI AP 26, has the MAC address MAC26. I need ensure one WIFI user, say user 58, must connect to WIFI AP 26 for the first time. After the first connection, user 58 can connect to any WIFI AP in the network. Can someone give some advice on how to do it? Thanks! Tom

2 1