Help with groups on Mysql

Bill Neely <[email protected]> Sun, 2 Oct 2005 11:26:06 -0700
Newsgroups gmane.comp.gnu.radius.general
Message-ID <[email protected]>
I am having some trouble understanding how to pick up groups that a user belongs
to and using those groups to pass reply pairs back to the NAS.

I have the following:

users:

## Default entry.
DEFAULT Auth-Type = Local,
	Password-Location = SQL,
	Group = ascendgroup,
              Auth-Type = SQL
	Service-Type = Framed-User

sqlserver:

group_query SELECT GroupName   \
            FROM usergroup \
            WHERE username = '%C{User-Name}'

reply_attr_query  SELECT Attribute,Value \
                  FROM radgroupreply \
                  WHERE  GroupName='%C{Group}'

The group query appears to execute and returns two rows (two group names) one of
which matches  "ascendgroup",
but
when reply_attr_query is executed the group name is blank and so no attribute
pairs are returned.

Two questions:

Is it possible to pass more than one group name to reply_attr_query?
Why does '%C{Group}' come up blank?

Surely I am missing something. TIA
Bill
-- 
1-888-217-5498





----------------------------------------------------------------
This message was sent using http://newwebmail.gct21.net