(RADIATOR) NoCheckPassword with <AuthBy SQL>

[Hugh Irvine]

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.