<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<div class="rcmBody" style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif;">
<p>I have installed Freeradius-3.0.1....rpm on CentOS-7, which fails to check for group tables</p>
<p>I have set</p>
<p>read_group = yes</p>
<p> </p>
<p>In /etc/raddb/mods-enabled/sql file</p>
<p>And in /etc/raddb/mods-config/sql/main/mysql/queries.conf file</p>
<p> </p>
<p> group_membership_query = "\<br /> SELECT groupname \<br /> FROM ${usergroup_table} \<br /> WHERE username = '%{SQL-User-Name}' \<br /> ORDER BY priority"<br /><br /> authorize_group_check_query = "\<br /> SELECT id, groupname, attribute, \<br /> Value, op \<br /> FROM ${groupcheck_table} \<br /> WHERE groupname = '%{Sql-Group}' \<br /> ORDER BY id"<br /><br /> authorize_group_reply_query = "\<br /> SELECT id, groupname, attribute, \<br /> value, op \<br /> FROM ${groupreply_table} \<br /> WHERE groupname = '%{Sql-Group}' \<br /> ORDER BY id"<br /><br /></p>
<p>How can I make radiusd check for group tables. I'm using mysql and have entries in radgroupcheck and radgrouply and also in radcheck and radreply.</p>
<p>Thanks</p>
<p>Akash</p>
<div> </div>
</div>
<div> </div>
</body></html>