FreeRadius and MySql custom attributes

[Stephen Bowman]

>
> authorize_reply_query = "SELECT '',Username,'Profile',Profiles,':=' FROM
> radius_auth WHERE Username = '%{SQL-User-Name}'"
>
>
It's doing exactly what you tell it to do.


>
>
> query:  SELECT '',Username,'Profile',Profiles,':=' FROM radius_auth
> WHERE Username = 'aseibert at evenlink.com'
>

There's the query as you defined it above...


>
>
> Sending Access-Accept of id 46 to 206.174.130.217 port 40278
>        Profile := "Slip"


And there's the access-accept with a reply attribute of Profile := "Slip".
In your database you clearly have a column titled 'Profile' in radius_auth
with value of "Slip" for the row for the username "aseibert at evenlink.com"

To get what you want, you would need a column titled "Slipstream-Auth" with
a value of "True" for the row for the username "aseibert at evenlink.com".

But all this is actually a bit horkie.  It makes little sense to have to add
a column everytime you want a random check/reply attribute.  It's bad
practice and going to be terribly inefficient by any database backend.

Why is it that you don't want to follow the provided schema (in 2.x
raddb/sql/mysql/) and predefined queries?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20081105/9957779b/attachment.html>