Fw: (RADIATOR) Disabling users using mysql

[Romain Vergniol]

It seems that my last message died before arriving on the mailing-list....
:)


----- Original Message -----
From: "Romain Vergniol" <romain.vergniol at cegedim.fr>
To: "Anton Krall" <akrall at intruder.com.mx>; <radiator at open.com.au>
Sent: Monday, December 16, 2002 11:27 AM
Subject: Re: (RADIATOR) Disabling users using mysql


| Hi all,
|
| after adding a column called "ACTIVE" in the SUBSCRIBERS table,
| you should try something like this in your "AuthBy SQL" statement :
|
| AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME='%n' and
| ACTIVE='1'
| AuthColumnDef 0, User-Password, check
|
| hope this helps,
| Romain Vergniol
| --- C E G E D I M ---
| Equipe Reseau
| Tel : +33 (0)1 49 09 84 02
| Mail : romain.vergniol at cegedim.fr
| ----- Original Message -----
| From: "Anton Krall" <akrall at intruder.com.mx>
| To: <radiator at open.com.au>
| Sent: Friday, December 13, 2002 5:32 PM
| Subject: (RADIATOR) Disabling users using mysql
|
|
| | 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.
|

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