Freeradius-Users Digest, Vol 90, Issue 25
diwakara googly
diwakar.googly at gmail.com
Fri Nov 2 12:00:04 CET 2012
QpwertuytttuuipiusAsdfghllzc vv
hdk£§ ￦|°_|001#%2&/+()0&#)
' ;
On 9 Oct 2012 19:21, <freeradius-users-request at lists.freeradius.org> wrote:
> Send Freeradius-Users mailing list submissions to
> freeradius-users at 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 at lists.freeradius.org
>
> You can reach the person managing the list at
> freeradius-users-owner at 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.Heinzmann at 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.Heinzmann at belden.com
> To: FreeRadius users mailing list
> <freeradius-users at lists.freeradius.org>
> Subject: Re: freeRadius against Active Directory
> Message-ID:
>
> <OF9B65C4AF.4CC34B36-ONC1257A92.003C5704-C1257A92.003C8691 at 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.bastin at peerpointinternet.co.uk>
> To: <freeradius-users at 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 <aland at deployingradius.com>
> To: FreeRadius users mailing list
> <freeradius-users at lists.freeradius.org>
> Subject: Re: Query help
> Message-ID: <507423C4.2060002 at 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 <aland at deployingradius.com>
> To: FreeRadius users mailing list
> <freeradius-users at lists.freeradius.org>
> Subject: Re: Outpairs not working on external script when user is
> located in MYSQL
> Message-ID: <507426F2.2080206 at 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" <davidp at wirelessconnections.net>
> To: "FreeRadius users mailing list"
> <freeradius-users at 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
> ************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20121102/6d971ca6/attachment.html>
More information about the Freeradius-Users
mailing list