Seems its working! Now I have a question... The error it return when a
user is not Y is

Access rejected for akrall: No such user

Is there a way to tell radiator to return another msg like "user
deactivated".. The now such user can be misleading...

Any ideas?

__________________________________________________________________
Anton Krall
Intruder Consulting
 
Email: [EMAIL PROTECTED]
Tel: 5233-9281
Celular: 044-555-105-5160
ICQ#: 4979450
MSN: [EMAIL PROTECTED]
AIM: antonkrall
Web: http://www.intruder.com.mx

 


> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED]] On Behalf Of Hugh Irvine
> Sent: Viernes, 13 de Diciembre de 2002 03:36 p.m.
> To: Anton Krall
> Cc: [EMAIL PROTECTED]
> Subject: Re: (RADIATOR) Disabling users using mysql
> 
> 
> 
> 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: [EMAIL PROTECTED]
> > Tel: 5233-9281
> > Celular: 044-555-105-5160
> > ICQ#: 4979450
> > MSN: [EMAIL PROTECTED]
> > AIM: antonkrall
> > Web: http://www.intruder.com.mx
> >
> >
> > ===
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on [EMAIL PROTECTED]
> > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
> 
> 


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to