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
