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.
