Well, I tested what I said I was going to do
When I run radiusd -X, I do not see the server using the reply_attr_query that I have
set in the sql.conf file
reply_attr_query = "SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
username='%{SQL-User-Name}'"
So it seems that this is not a query that the SQL modules know to use (or the more
probable answer...I am doing something wrong)
I am obviously doing something wrong. When you say
"Just list the attribute in the normal SQL tables. There's nothing special about a
vendor attribute once you've added it to the dictionary."
I must appologize. I am new to FreeRadius. Can you explain a little more by what you
mean here? Do you mean I should put this attribute into an extra column in the
radreply table? (if so, then that is not a problem for me)
Is reply_attr_query correct for putting an attribute into the access-accept packet?
Is there a way to see all of the attributes in the Access-Accept packet? (I tried
using ethereal, but I was not able to find them)
thanks again for your help
Evan Stenmark
---------- Original Message ----------------------------------
From: "stenmark " <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Sat, 17 Apr 2004 13:19:28 -0600
>I was thinking I needed a check and reply for this attribute. (But I know now that I
>do not)
>
>So can I put this new attribute in the radcheck table?
>the Attribute name is Slipstream-Auth and it's value is slip(True/Null)
>Is this new query correct?
>reply_attr_query = "SELECT id,UserName,'Slipstream-Auth',slip,op FROM radcheck WHERE
>username='%{SQL-User-Name}' ORDER BY id"
>
>Does an attribute query need all of the listed items that I have in my query? ie
>id,UserName,'Slipstream-Auth',slip,op
>or do I just need UserName,'Slipstream-Auth',slip?
>Also, where can I find a list of queries the SQL module knows about?
>
>Thanks for your help Alan and Bob
>Evan Stenmark
>---------- Original Message ----------------------------------
>From: "Alan DeKok" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>Date: Sat, 17 Apr 2004 08:58:59 -0400
>
>>"stenmark " <[EMAIL PROTECTED]> wrote:
>>> We have normal and accelerated dialup (using a program called
>>> Slipstream). I have added an attribute in the dictionary VENDOR
>>> Slipstream 7000 ATTRIBUTE Slipstream-Auth 1 string Slipstream
>>
>> OK...
>>
>>> I'm pretty sure that I need the attribute in the Access-Accept packet
>>>
>>> In sql.conf, I have added (as per the comments in sql.conf and the other sql
>>> queries listed):
>>>
>>> attr_check_query = "SELECT id,UserName,Attribute,Value,op FROM slipcheck WHERE
>>> username='%{SQL-User-Name}' ORDER BY id"
>>
>> I'm not sure why you would expect that to work. The SQL modules
>>reads sql.conf, and uses queries it knows about. Adding another query
>>it *doesn't* know about won't do anything.
>>
>>> When I do a radtest, I don't see the attribute in the access-accept
>>> packet. So as far as I know, it does not appear to be working. It
>>> seems I am missing something. It must be something easy because I'm
>>> sure many people have done something like this before.
>>
>> Just list the attribute in the normal SQL tables. There's nothing
>>special about a vendor attribute once you've added it to the
>>dictionary.
>>
>> Alan DeKok.
>>
>>-
>>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
