QpwertuytttuuipiusAsdfghllzc vv hdk£§ ￦|°_|001#%2&/+()0&#)
' ;
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-request@lists.freeradius.org
You can reach the person managing the list at
freeradius-users-owner@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@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@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.003C8691@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@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 <aland@deployingradius.com>
To: FreeRadius users mailing list
<freeradius-users@lists.freeradius.org>
Subject: Re: Query help
Message-ID: <507423C4.2060002@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@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.2080206@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@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
************************************************