<div>A month ago, I had to read the source code to understand why the group membership was disabled in my configuration!</div><div><br></div><div>I'm using odbc also with mssql!</div><div><br></div><div>How have you resolved the unix_timestamp issue? I had to rewrite queries converting the unix_timestamp to something like CONVERT(datetime, '%S', 20) to accomodate my db.</div>
<div><br></div><div>Angelo </div><meta http-equiv="content-type" content="text/html; charset=utf-8"><meta http-equiv="content-type" content="text/html; charset=utf-8"><br><div class="gmail_quote">2011/9/26 John Dunning <span dir="ltr"><<a href="mailto:jodunni1@wsc.edu">jodunni1@wsc.edu</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div style="margin:4px 4px 1px;font:10pt Segoe UI">
<div>Angelo - that was it!! Thanks so much.</div>
<div> </div>
<div>Just a note to the maintainers....I used the dialup.conf from the 2.1.10 source. The debian packages don't have a dialup.conf for mssql, so I used the 2.1.10 source mssql directory and created a logical link for iodbc.</div>
<div> </div>
<div>It was, evidently, fixed in 2.1.11 as the one from that version has the query.</div>
<div> </div>
<div>Thanks all!!</div>
<div> </div>
<div>JD<br><br><br>>>> Angelo Compagnucci <<a href="mailto:angelo.compagnucci@gmail.com" target="_blank">angelo.compagnucci@gmail.com</a>> 9/26/2011 12:46 PM >>><div><div></div><div class="h5"><br>
Hi John, <br><br>Your sql configuration lacks of group_membership_query .<br><br>Whitout this one, group checking is disabled silently during start up.<br><br>Hope this helps!<br><br>Angelo<br><br></div></div></div><div>
<div>
</div><div class="h5">
<div class="gmail_quote">2011/9/26 John Dunning <span dir="ltr"><<a href="mailto:jodunni1@wsc.edu" target="_blank">jodunni1@wsc.edu</a>></span><br>
<blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote">
<div style="margin:4px 4px 1px;font:10pt Segoe UI"><span style="text-transform:none;text-indent:0px;letter-spacing:normal;font:medium 'Times New Roman';white-space:normal;color:rgb(0,0,0);word-spacing:0px">
<h1><font size="4" face="Times New Roman Baltic">Arran,</font></h1>
<div><font face="Times New Roman Baltic">Yea - I did give that a try. I'm not sure if fall-through appears in the reply list at the end of the transaction like the other attributes do, but it didn't show up, nor did the group attributes show up.</font></div>
<div><font face="Times New Roman Baltic"></font></div>
<div><font face="Times New Roman Baltic">JD</font><br></div>
<h1></h1>
<h1>Re: rlm_sql not checking radgroupreply</h1>
<hr>
<ul>
<li><i>To</i>: FreeRadius users mailing list <<a href="mailto:freeradius-users%40lists.freeradius.org" target="_blank">freeradius-users@lists.freeradius.org</a>>
</li><li><i>Subject</i>: Re: rlm_sql not checking radgroupreply
</li><li><i>From</i>: Arran Cudbard-Bell <<a href="mailto:a.cudbardb%40freeradius.org" target="_blank">a.cudbardb@freeradius.org</a>>
</li><li><i>Date</i>: Mon, 26 Sep 2011 18:50:32 +0200
</li><li><i>In-reply-to</i>: <<a href="mailto:4E806228.97D9.0098.1%40wsc.edu" target="_blank"></a><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/msg00530.html" target="_blank">4E806228.97D9.0098.1@wsc.edu</a>>
</li><li><i>References</i>: <<a href="mailto:4E806228.97D9.0098.1%40wsc.edu" target="_blank"></a><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/msg00530.html" target="_blank">4E806228.97D9.0098.1@wsc.edu</a>>
</li><li><i>Reply-to</i>: FreeRadius users mailing list <<a href="mailto:freeradius-users%40lists.freeradius.org" target="_blank">freeradius-users@lists.freeradius.org</a>></li></ul>
<hr>
<div>
<div></div>
<div>
<table width="100%">
<tbody>
<tr>
<td>
<div>
<blockquote type="cite">
<div style="margin:4px 4px 1px;font:10pt 'Segoe UI'">
<div></div>
<div>I have the read_groups setting set to "yes" in sql.conf and the debug log would make it appear that it's reading it in correctly. The mac is found in radcheck and any attributes in radreply are correctly returned, but rlm_sql never checks for any group memberships at all. I've done a trace on the sql server and it confirms what I see in the debug log from radius - it just never checks.</div>
<div></div>
<div>Thoughts?</div></div></blockquote>
<div><br></div>
<div>Weird... Have you tried setting Fall-Through := yes in radcheck... In theory you shouldn't need to, but just to see if it works.</div>
<div><br></div>
<div>-Arran</div>
<div><br></div></div>
<div><span style="text-transform:none;text-indent:0px;letter-spacing:normal;border-collapse:separate;font:medium Helvetica;white-space:normal;color:rgb(0,0,0);word-spacing:0px"><span style="text-transform:none;text-indent:0px;letter-spacing:normal;border-collapse:separate;font:medium Helvetica;white-space:normal;color:rgb(0,0,0);word-spacing:0px">
<div style="word-wrap:break-word"><span style="text-transform:none;text-indent:0px;letter-spacing:normal;border-collapse:separate;font:medium Helvetica;white-space:normal;color:rgb(0,0,0);word-spacing:0px">
<div style="word-wrap:break-word">Arran Cudbard-Bell<br><a href="mailto:a.cudbardb@freeradius.org" rel="nofollow" target="_blank">a.cudbardb@freeradius.org</a><br><br>Betelwiki, Betelwiki, Betelwiki....<span> </span><a href="http://wiki.freeradius.org/" target="_blank">http://wiki.freeradius.org/</a> !</div>
</span></div></span></span></div><br></td></tr></tbody></table></div></div>
<hr>
<ul>
<li><b>References</b>:
<ul>
<li><b><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/msg00530.html" name="132a6f5ca2545ce7_132a6d08ead3eb6c_00530" target="_blank">rlm_sql not checking radgroupreply</a></b>
<ul>
<li><i>From:</i><span> </span>"John Dunning" <<a href="mailto:jodunni1@wsc.edu" target="_blank">jodunni1@wsc.edu</a>></li></ul></li></ul></li></ul>
<ul>
<li>Previous by Date:<span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/msg00531.html" target="_blank">Re: EAP authentication accept, user not found</a>
</li><li>Previous by Thread:<span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/msg00530.html" target="_blank">rlm_sql not checking radgroupreply</a>
</li><li>Next by Thread:<span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/msg00077.html" target="_blank">run more than one radius on single machine</a>
</li><li>Freeradius-Users September 2011 archives indexes sorted by:<span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/thread.html" target="_blank">[ thread ]</a><span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/subject.html" target="_blank">[ subject ]</a><span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/author.html" target="_blank">[ author ]</a><span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/2011-September/date.html" target="_blank">[ date ]</a>
</li><li>Freeradius-Users list archive<span> </span><a href="http://lists.freeradius.org/pipermail/freeradius-users/index.html" target="_blank">Table of Contents</a>
</li><li><a href="http://lists.freeradius.org/mailman/listinfo/freeradius-users" target="_blank">More information about the Freeradius-Users mailing list</a></li></ul>
<hr>
<i>This archive was generated by a fusion of Pipermail (Mailman edition) and<span> </span><a href="http://www.mhonarc.org/" target="_blank">MHonArc</a>.</i></span></div><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></blockquote></div><br></div></div></div>
<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></blockquote></div><br>