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.