(RADIATOR) NoCheckPassword with <AuthBy SQL>

[Herman Scholtens]

Hello Hugh,

Thank you for this solution.
It seems to work fine!

But do you also think that the function "NoCheckPassword" should also work 
with the <AuthBy SQL> clause?

PS: This server is running Radiator 3.8

Best wishes for 2006!

-- 
Regards,

Herman Scholtens

----- Original Message ----- 
From: "Hugh Irvine" <hugh at open.com.au>
To: "Herman Scholtens" <radiator at hermanscholtens.com>
Cc: <radiator at open.com.au>
Sent: Saturday, December 31, 2005 11:17 PM
Subject: Re: (RADIATOR) NoCheckPassword with <AuthBy SQL>


>
> Hello Herman -
>
> You can do this:
>
> <Handler Realm = xxxxx.abc>
>        <AuthBy SQL>
>                NoDefault
>                AuthSelect select CHECKATTR, REPLYATTR from Users  where 
> USERNAME='%n'
>                AuthColumnDef 0, GENERIC, check
>                AuthColumnDef 1, GENERIC, reply
>                DBSource dbi:mysql:%{GlobalVar:AuthDb}
>                DBUsername %{GlobalVar:AuthUser}
>                DBAuth %{GlobalVar:AuthPass}
>        </AuthBy>
> </Handler>
>
> See section 6.29 in the Radiator 3.13 reference manual ("doc/ref.html").
>
> BTW - what version of Radiator are you running?
>
> regards
>
> Hugh
>
>
> On 1 Jan 2006, at 04:41, Herman Scholtens wrote:
>
>> Hello,
>>
>> I would like to use the NoCheckPassword feature in combination with  the 
>> <AuthBy SQL> (So do no password checking for a specific handler)
>>
>> According to http://www.open.com.au/radiator/ref.html#pgfId=399936,  "All 
>> AuthBy clauses understand the following parameters:"
>>
>> Unfortunately the <AuthBy SQL> clause doesn't support the 
>> "NoCheckPassword" feature.
>>
>> <Handler Realm = xxxxx.abc>
>>        <AuthBy SQL>
>>                NoCheckPassword # This doesn't seem to work..
>>                NoDefault
>>                AuthSelect Select PASSWORD, CHECKATTR, REPLYATTR  from 
>> Users where USERNAME='%n'
>>                DBSource dbi:mysql:%{GlobalVar:AuthDb}
>>                DBUsername %{GlobalVar:AuthUser}
>>                DBAuth %{GlobalVar:AuthPass}
>>        </AuthBy>
>> </Handler>
>>
>> In the logfile you see:
>> Sat Dec 31 18:08:10 2005: ERR: Unknown keyword 'NoCheckPassword'  in 
>> /usr/local/etc/raddb/radiator.cfg line 437
>>
>>
>> Can somebody tell me if this is a bug, or if I'm doing something  wrong?
>>
>> Maybe there are alternatives to get the result of not checking the 
>> Users' password?
>>
>>
>> -- 
>> Regards,
>>
>> Herman Scholtens
>> --
>> Archive at http://www.open.com.au/archives/radiator/
>> Announcements on radiator-announce at open.com.au
>> To unsubscribe, email 'majordomo at open.com.au' with
>> 'unsubscribe radiator' in the body of the message.
>
>
> NB:
>
> Have you read the reference manual ("doc/ref.html")?
> Have you searched the mailing list archive (www.open.com.au/archives/ 
> radiator)?
> Have you had a quick look on Google (www.google.com)?
> Have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> -- 
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
>
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message. 

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.