QpwertuytttuuipiusAsdfghllzc vv hdk£§ ₩|°_|001#%2&/+()0&#) ' ; On 9 Oct 2012 19:21, <freeradius-users-requ...@lists.freeradius.org> wrote:
> Send Freeradius-Users mailing list submissions to > freeradius-users@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-requ...@lists.freeradius.org > > You can reach the person managing the list at > freeradius-users-ow...@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: freeRadius against Active Directory > (martin.heinzm...@belden.com) > 2. Query help (Jonathan Bastin) > 3. Re: Query help (Alan DeKok) > 4. Re: Outpairs not working on external script when user is > located in MYSQL (Alan DeKok) > 5. v2.2 (David Peterson) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 9 Oct 2012 13:01:06 +0200 > From: martin.heinzm...@belden.com > To: FreeRadius users mailing list > <freeradius-users@lists.freeradius.org> > Subject: Re: freeRadius against Active Directory > Message-ID: > > <of9b65c4af.4cc34b36-onc1257a92.003c5704-c1257a92.003c8...@beldencdt.com> > > Content-Type: text/plain; charset="us-ascii" > > > Thank you guys very much. With your hints and a tutorial I found then( > > http://www.perkinsblog.net/blog/index.php/2010/02/freeradius-and-windows-ad/ > ) I managed to make it work :-) > Thanks again > > Martin > DISCLAIMER: > > Privileged and/or Confidential information may be contained in this > message. If you are not the addressee of this message, you may not > copy, use or deliver this message to anyone. In such event, you > should destroy the message and kindly notify the sender by reply > e-mail. It is understood that opinions or conclusions that do not > relate to the official business of the company are neither given > nor endorsed by the company. > > Thank You. > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.freeradius.org/pipermail/freeradius-users/attachments/20121009/40426ef7/attachment-0001.html > > > > ------------------------------ > > Message: 2 > Date: Tue, 9 Oct 2012 13:48:43 +0100 > From: Jonathan Bastin <jonathan.bas...@peerpointinternet.co.uk> > To: <freeradius-users@lists.freeradius.org> > Subject: Query help > Message-ID: <003901cda61c$6a4b3060$3ee19120$@peerpointinternet.co.uk> > Content-Type: text/plain; charset="us-ascii" > > I am trying to write a query to look at peoples quota and change their > speed biased on these details. So far I have: > > if ("%{sql: SELECT radgroupcheck.value FROM radusergroup Inner Join > radgroupcheck ON radusergroup.groupname = radgroupcheck.groupname WHERE > radusergroup.username = '%{User-Name}' AND radgroupcheck.attribute = > 'CS-Total-Octets-Monthly';}"<= "%{sql: SELECT SUM( AcctInputOctets + > AcctOutputOctets) FROM radacct WHERE UserName='%{User-Name}' AND > AcctStartTime > (DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())DAY));}"){ > > update reply { > Reply-Message := "You have reached your transfer > limit. Limited bandwitch" > Cisco-AVPair := > "lcp:interface-config#1=rate-limit output 524288 98304 196608 > conform-action transmit exceed-action drop" > Cisco-AVPair := > "lcp:interface-config#2=rate-limit input 524288 98304 196608 conform-action > transmit exceed-action drop" > } > } > > > Issue I get is that I always get > > Tue Oct 9 13:43:17 2012 : Info: ++- if ("%{sql: SELECT > radgroupcheck.value FROM radusergroup Inner Join radgroupcheck ON > radusergroup.groupname = radgroupcheck.groupname WHERE > radusergroup.username = '%{User-Name}' AND radgroupcheck.attribute = > 'CS-Total-Octets-Monthly';}"<= "%{sql: SELECT SUM( AcctInputOctets + > AcctOutputOctets) FROM radacct WHERE UserName='%{User-Name}' AND > AcctStartTime > (DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())DAY));}") > returns ok > > It doesn't actualy update the reply biased on what the outcome is of the > SQL query. Any help would be very much appreciated. > > -------------------------------------------------------------------------------------------------------------------------- > This email (including any attachments) is intended only for the > recipient(s) named above. It may contain confidential or privileged > information and should not be read, copied or otherwise used by any other > person. If you are not the named recipient please contact the sender and > delete the email from your system. The author's incumbent expressions, > views and thoughts are their own and not necessarily representative of > those of the Peer Point Internet Ltd or associated companies. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.freeradius.org/pipermail/freeradius-users/attachments/20121009/f481e673/attachment-0001.html > > > > ------------------------------ > > Message: 3 > Date: Tue, 09 Oct 2012 09:16:52 -0400 > From: Alan DeKok <al...@deployingradius.com> > To: FreeRadius users mailing list > <freeradius-users@lists.freeradius.org> > Subject: Re: Query help > Message-ID: <507423c4.2060...@deployingradius.com> > Content-Type: text/plain; charset=UTF-8 > > Jonathan Bastin wrote: > > *Issue I get is that I always get * > > > > Tue Oct 9 13:43:17 2012 : Info: ++- if ("%{sql: SELECT > > radgroupcheck.value FROM radusergroup Inner Join radgroupcheck ON > > radusergroup.groupname = radgroupcheck.groupname WHERE > > radusergroup.username = '%{User-Name}' AND radgroupcheck.attribute = > > 'CS-Total-Octets-Monthly';}"<= "%{sql: SELECT SUM( AcctInputOctets + > > AcctOutputOctets) FROM radacct WHERE UserName='%{User-Name}' AND > > AcctStartTime > (DATE_SUB(CURDATE(),INTERVAL > > DAYOFMONTH(CURDATE())DAY));}") returns ok > > > > *It doesn?t actualy update the reply biased on what the outcome is of > > the SQL query. Any help would be very much appreciated.* > > a) you're using "radiusd -xX". That's not necessary. Just use > "radiusd -X" > > b) You're not looking at the debug lines BEFORE that one. They show > why the "if" is taken, or not taken. > > > ------------------------------ > > Message: 4 > Date: Tue, 09 Oct 2012 09:30:26 -0400 > From: Alan DeKok <al...@deployingradius.com> > To: FreeRadius users mailing list > <freeradius-users@lists.freeradius.org> > Subject: Re: Outpairs not working on external script when user is > located in MYSQL > Message-ID: <507426f2.2080...@deployingradius.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Thomas Raabo - Zitcom A/S wrote: > > Need som help getting my external script to work > > > > Here is my External module > > > > exec MOTP { > > wait = yes > > program = "/etc/raddb/otpverify.sh %{User-Name} %{User-Password} > %{reply:Secret} %{reply:Pin} %{reply:Offset}" > > What do you think that does? What is "reply:Secret" and "reply:Pin" ? > > > Mon Oct 8 23:52:57 2012 : Info: [MOTP] expand: %{reply:Secret} > -> > > Mon Oct 8 23:52:57 2012 : Info: [MOTP] expand: %{reply:Pin} -> > > Mon Oct 8 23:52:57 2012 : Info: [MOTP] expand: %{reply:Offset} > -> > > Well, they don't exist, do they? > > > In /usr/share/freeradius/dictionary I have > > > > $INCLUDE dictionary.motp > > Don't do that. There's a dictionary file in raddb/dictionary for a > reason. Go read it. > > > And from my > > > > Dictionary.motp > > > > # > > ATTRIBUTE Secret 960 string > > ATTRIBUTE Pin 961 string > > ATTRIBUTE Offset 962 string > > Which is wrong. It's been wrong for pretty much a decade. > > Read raddb/dictionary for instructions on creating attributes which work. > > > All my configuration is based on > > > > http://nicoblog.goralski.fr/tag/Radius > > That web site is wrong. Read the *FreeRADIUS* documentation for > instructions on how to properly edit the dictionaries. > > Alan DeKok. > > > ------------------------------ > > Message: 5 > Date: Tue, 9 Oct 2012 09:44:50 -0400 > From: "David Peterson" <dav...@wirelessconnections.net> > To: "FreeRadius users mailing list" > <freeradius-users@lists.freeradius.org> > Subject: v2.2 > Message-ID: <001801cda624$44524c10$ccf6e430$@wirelessconnections.net> > Keywords: [CRM] Regarding: (None) > Content-Type: text/plain; charset="us-ascii" > > I seem to be losing it today. How do I check out the 2.2 version from git? > > > > David > > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: winmail.dat > Type: application/ms-tnef > Size: 2962 bytes > Desc: not available > URL: < > http://lists.freeradius.org/pipermail/freeradius-users/attachments/20121009/9f0967f9/attachment.bin > > > > ------------------------------ > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > End of Freeradius-Users Digest, Vol 90, Issue 25 > ************************************************ >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html