[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Help-gnu-radius] Help with groups on Mysql
From: |
Bill Neely |
Subject: |
[Help-gnu-radius] Help with groups on Mysql |
Date: |
Sun, 2 Oct 2005 11:26:06 -0700 |
User-agent: |
Internet Messaging Program (IMP) H3 (4.0.2) |
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
- [Help-gnu-radius] Help with groups on Mysql,
Bill Neely <=