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