(RADIATOR) Disabling users using mysql

[Hugh Irvine]

Hello Anton -

You simply need to specify your own AuthSelect statement in the AuthBy 
SQL clause:

# define AuthBy

<AuthBy SQL>
	Identifier CheckSQL
	.....
	AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME=%0 and 
STATUS=1
	AuthColumnDef 0, Password, check
	.....
</AuthBy>

.....

regards

Hugh



On Saturday, Dec 14, 2002, at 03:32 Australia/Melbourne, Anton Krall 
wrote:

> Guys, I need help trying to figure how to do this:
>
> Im using mysql as my SUBSCRIBERS db for radiator users.
> I have 2 columns, username and password and I want to add a 3rd one
> saying active so that when a user tryies to login, radiator will also
> check this caloumn and if active is = 1 it lets him in otherwise, will
> not authenticate.
>
> How can I configure radiator to look for this column and check the 
> value
> and if its 1 then proceed?
>
> Thx for any help you can provide.
>
> __________________________________________________________________
> Anton Krall
> Intruder Consulting
>
> Email: akrall at intruder.com.mx
> Tel: 5233-9281
> Celular: 044-555-105-5160
> ICQ#: 4979450
> MSN: akrall at hotmail.com
> AIM: antonkrall
> Web: http://www.intruder.com.mx
>
>
> ===
> 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.
>
>

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

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