(RADIATOR) NoCheckPassword with <AuthBy SQL>

[Hugh Irvine]

Hello Herman -

NoCheckPassword was introduced in Radiator 3.12 and works correctly  
with AuthBy SQL.

See the history file:

	http://www.open.com.au/radiator/history.html

regards

Hugh


On 1 Jan 2006, at 21:08, Herman Scholtens wrote:

> 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.
>>


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.