That is exactly it.... How well does it work, and can we take it one
step further with the following:
In the radius.cfg file, I have the following statements:
<AuthLog FILE>
Identifier logger
Filename %L/%m%Y-radius.log
SuccessFormat %l: Auth: Login OK: [%u(%U)] (from %C)
FailureFormat %l: Auth: Login Failure: [%u/%P(%U/%P)]
(from %C)
LogSuccess 1
LogFailure 1
</AuthLog>
<Handler>
AuthLog logger
</Handler>
If it comes to an entry that it shows to be a suspended or "0" code
account, can it make an entry into the logfile I have created besides
the Failure entry. Maybe it to say that the account actually shows to
be suspended because of the entry in the Active field? Just a
thought..... Thanks again.
Stephen Malenshek
President/CEO
Valuelinx Corporation
[EMAIL PROTECTED]
-----Original Message-----
From: Ronan Eckelberry [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 11:58 AM
To: 'Stephen Malenshek'; [EMAIL PROTECTED]
Subject: RE: (RADIATOR) Account status field
Stephen,
Try changing your AuthSelect. I do basically what you are
saying by adding "AND ACTIVE='Y'". In your case it would be something
like "AND status='1'"
Here is my AuthSelect:
AuthSelect select PASSWORD,PORTLIMIT,STATICIP,SIMLOGIN from SUBSCRIBERS
where USERNAME='%n' AND ACTIVE='Y'
Is that kinda like what you are looking for?
-Ronan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Stephen Malenshek
Sent: Monday, 08 April, 2002 11:24
To: [EMAIL PROTECTED]
Subject: (RADIATOR) Account status field
Is there a way to make radiator look at an additional field to see if
the account is in a suspended or valid state. For instance, I have a
postgres database with the following fields:
radius=# \d subscribers
Table "subscribers"
Attribute | Type | Modifier
--------------+------------------------+----------
username | character varying(50) | not null
realname | character varying(50) |
passwd | character varying(50) |
epasswd | character varying(50) |
uid | integer |
gid | integer |
homedir | character varying(90) |
huntgroup | character varying(30) |
staticip | character varying(22) |
shell | character varying(50) |
checkattr | character varying(200) |
replyattr | character varying(200) |
mailonlyacct | character varying(10) |
status | character varying(30) |
Indices: subscribers_pkey,
username_i
If an account request comes in and the username and epassword fields
show to be the correct information, how could we get the software to
check and see if the status field shows a 0 or 1. The 0 would be
suspended and 1 would be active, or something to that effect. Please
let me know what your thoughts are. Thanks
Stephen Malenshek
President/CEO
Valuelinx Corporation
[EMAIL PROTECTED]
BEGIN:VCARD
VERSION:2.1
N:Malenshek;Stephen
FN:Stephen Malenshek ([EMAIL PROTECTED])
ORG:Valuelinx Corporation
TITLE:President/CEO
TEL;WORK;VOICE:(479) 546-0000
TEL;CELL;VOICE:(479) 650-2789
TEL;WORK;FAX:(479) 546-0007
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Post Office Box 1966=0D=0A#11 North Main Street;Greenwood;Arkansas;72936;U=
nited States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Post Office Box 1966=0D=0A#11 North Main Street=0D=0AGreenwood, Arkansas 729=
36=0D=0AUnited States of America
URL;WORK:http://www.valuelinx.net/
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20020402T180709Z
END:VCARD
