Re: [Help-gnu-radius] Reply attributes using mysql auth

[Gerald]

On Tue, 30 Mar 2004, Robin Brown wrote:

> I've just started to implement GNU radius and I'm having an issue trying to
> set the Cisco-AVPair in a reply to the requesting NAS.

I would try to single and double quote the value first. One of the posts
in the archive seemed to suggest it required double quotes.

> While the user can get authenticated, authorization fails and the privilege
> level is not set.  In the radius.log file I am getting SQL: invalid operator
> when the op field is set to null.

I believe the operator radius is interpreting is the "=" in the value.

> After reading through the SQL authorization docs I thought that if the op
> field was NULL in the attrib table that the entry would be returned when the
> reply_attr_query was executed.  It's not working, and when there is a NULL
> in the op field I get the SQL error.

That is correct.

> Also, when the mysql tables were setup, the attrib table does not have a
> primary key.  Which field is best to use as that?

With just the default 4 probably a combination of user_name + attr.

Or you could do something like (not real mysql syntax):
alter table attrib add unique_ID int(256) auto_increment && set key
unique_ID.

Gerald