Problem with group table being not checked by freeradius

Akash akash at satelinknepal.com.np
Wed Nov 12 15:00:57 CET 2014


 

I have installed Freeradius-3.0.1....rpm on CentOS-7, which fails to
check for group tables 

I have set 

read_group = yes 

In /etc/raddb/mods-enabled/sql file 

And in /etc/raddb/mods-config/sql/main/mysql/queries.conf file 

 group_membership_query = "
 SELECT groupname 
 FROM ${usergroup_table} 
 WHERE username = '%{SQL-User-Name}' 
 ORDER BY priority"

 authorize_group_check_query = "
 SELECT id, groupname, attribute, 
 Value, op 
 FROM ${groupcheck_table} 
 WHERE groupname = '%{Sql-Group}' 
 ORDER BY id"

 authorize_group_reply_query = "
 SELECT id, groupname, attribute, 
 value, op 
 FROM ${groupreply_table} 
 WHERE groupname = '%{Sql-Group}' 
 ORDER BY id"

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. 

Thanks 

Akash 

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20141112/a72eb15c/attachment.html>


More information about the Freeradius-Users mailing list