(RADIATOR) Disabling users using mysql

Anton Krall akrall at intruder.com.mx
Fri Dec 13 18:20:01 CST 2002


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

 


> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au] 
> Sent: Viernes, 13 de Diciembre de 2002 03:36 p.m.
> To: Anton Krall
> Cc: radiator at open.com.au
> 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: 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.


More information about the radiator mailing list