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 ${usergroup_table} \
WHERE username = '%{SQL-User-Name}' \
ORDER BY priority"
However, I need to know if it possible to change SQL-User-Name to use the
radcheck id instead?
Is it possible to look up the user id prior to this statement running?
Ideally, it would then look like this:
group_membership_query = "SELECT radgroup_id \
FROM ${usergroup_table} \
WHERE username = '%{SQL-User-ID}' \
ORDER BY priority"
If so, where do I do this?
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Change-SQL-Groupcheck-Query-in-Dialup-conf-tp5026372p5026372.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
