Re: Help with groups on Mysql

Bill Neely <[email protected]> wrote:

> reply_attr_query  SELECT Attribute,Value \
>                   FROM radgroupreply \
>                   WHERE  GroupName='%C{Group}'
[...]
> Why does '%C{Group}' come up blank?

The problem here is that '%C{Group}' looks for this attribute in the
received request. Obviously, the NAS does not send this attribute and so
it is replaced with a null string.

Depending on what you wish to achieve, there may be various solutions to
the problem.

> Is it possible to pass more than one group name to reply_attr_query?

You can use arbitrary complex SQL constructs in both queries. Only make
sure all your '%C{}' attributes actually appear in incoming
requests. If some of them are not, you can either add them explicitely
using rewrite rules, or provide a reasonable default values, whichever is
more appropriate.


Regards,
Sergey