Change SQL Groupcheck Query in Dialup.conf

2011-11-27 Thread JennyBlunt
I need to change the structure of the radusergroup table so it includes the radcheck_id and radgroupcheck_id's. Currently it's set to use the username and groupname. I'm editing the following sections in dialup.conf group_membership_query = SELECT groupname \ FROM

Re: Change SQL Groupcheck Query in Dialup.conf

2011-11-27 Thread Alan DeKok
JennyBlunt wrote: I need to change the structure of the radusergroup table so it includes the radcheck_id and radgroupcheck_id's. Why? And even if there is a good reason, it's just SQL... However, I need to know if it possible to change SQL-User-Name to use the radcheck id instead?

Re: Change SQL Groupcheck Query in Dialup.conf

2011-11-27 Thread JennyBlunt
Yes, it's a bit annoying Our front end management system is / will be built using ruby on rails. RoR seems a little funny with join tables when they don't use IDs. Hence the need for a change to the sql. The same went for the attribute column which we needed to alter too. Have things

Re: Change SQL Groupcheck Query in Dialup.conf

2011-11-27 Thread Alan DeKok
JennyBlunt wrote: Yes, it's a bit annoying Our front end management system is / will be built using ruby on rails. RoR seems a little funny with join tables when they don't use IDs. Hence the need for a change to the sql. The same went for the attribute column which we needed to alter