Re: [Help-gnu-radius] Efficient and Various a/v pairs..

[Lewis Watson]

Hi Sergey,
I appreciate your help and I see what you are saying. This leads me to my
next question. Since we are trying to pull multiple av pairs from MySQL
what's the syntax for doing so? We have created an additional column that
has the attribute name and then another column that has the specific value
for that attribute for each user and we are only able to get the first
pair.. Here is our reply_attr_query
reply_attr_query  SELECT
IPAttr,FramedIPAddress,SesTimAttr,SessionLimit,IdlTimAttr,IdleLimit \
                  FROM Authentication \
                  WHERE UserName='%u'

Should we have a reply_attr_query for each pair we are trying to pull or
please tell me how we get multiple av pairs returned from MySQL.
Thanks a bunch!!
Lewis



----- Original Message ----- 
From: "Sergey Poznyakoff" <address@hidden>
To: "Lewis Watson" <address@hidden>
Cc: "gnu radius" <address@hidden>
Sent: Saturday, May 24, 2003 3:35 AM
Subject: Re: [Help-gnu-radius] Efficient and Various a/v pairs..


> Hello Lewis,
>
> > I have a few different classes of users that get different values for
> > session limit, idle limit, IP, etc etc. . What would be the most
efficient
> > (fastest) way to authenticate and specify session attributes for
users?
> > By storing the different values in mySQL (we currently have all users/
> > passwords + more values in a mysql DB), or by making a different
profile
> > in the user or hints files with the different attr/ values within each
> > profile?
>
> Well, of course explicit profiles in raddb/users work faster than the
> database lookup. However the tradeoff is usually not that noticeable.
> The database lookup is more flexible in the sense that one can alter
> the class data by a simple insert or update command and
> the daemon will pick up the changes at once, without the need of
> notifying it.
>
> Since you already use the database, storing attributes there seems the
> logical choice.
>
> Regards,
> Sergey
>
>