<html><body><div>I forgot to mention that the look up works if I enter the Huntgroup-Name in radcheck.</div><div><br>For some reason, it's just failing in radgroupcheck</div><div><br>On Jul 26, 2012, at 09:51 AM, Jenny Blunt <jennyshoehorn@me.com> wrote:<br><br></div><div><blockquote type="cite"><div class="msg-quote"><div>I'm looking for some help with the implementation of huntgroups. </div><div><br></div><div>Am using mysql and have followed the following topic through:</div><div><br></div><div> http://freeradius.1045715.n5.nabble.com/Huntgroup-Checking-td4950385.html</div><div><br></div><div>In sites-available/default I have this, (just after preprocess:</div><div><br></div><div><div> update request {</div><div> Huntgroup-Name := "%{sql:SELECT `groupname` FROM `radhuntgroup` WHERE nasipaddress='%{NAS-IP-Address}'}"</div><div> }</div></div><div><br></div><div>And the debug log show's this query's working:</div><div><br></div><div> expand: %{sql:SELECT `groupname` FROM `radhuntgroup` WHERE nasipaddress='%{NAS-IP-Address}'} -> Location One</div><div><br></div><div>In my radgroupcheck table, I've added </div><div><br></div><div> Huntgroup-Name == Location One</div><div><br></div><div>I've also modified my authorize_group_check_query in dialup.conf as per a recommendation</div><div><br></div><div><div>authorize_group_check_query = "SELECT id, groupname, attribute_name, \</div><div> Value, op \</div><div> FROM ${groupcheck_table} \</div><div> WHERE ( groupname = '%{Sql-Group}' OR groupname = '%{Huntgroup-Name}' ) \</div><div> ORDER BY id"</div><div><br></div></div><div>(Which doesn't make logical sense to me)</div><div><br></div><div>What I'm failing to get my head around is how to reject or allow access based on the location their dialing in from?</div><div><br></div><div>For example, a user from IP 1.x.x.x should be allowed access at location 1 only.</div><div><br></div><div><br></div><div><br></div><div class="_stretch">-<br> List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" data-mce-href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></div></div></blockquote></div></body></html>