(RADIATOR) Account status field

[Stephen Malenshek]

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
stephen at valuelinx.net

-----Original Message-----
From: Ronan Eckelberry [mailto:radiator at gowebco.com] 
Sent: Monday, April 08, 2002 11:58 AM
To: 'Stephen Malenshek'; radiator at open.com.au
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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
Behalf Of Stephen Malenshek
Sent: Monday, 08 April, 2002 11:24
To: radiator at open.com.au
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
stephen at valuelinx.net



-------------- next part --------------
A non-text attachment was scrubbed...
Name: Stephen Malenshek (stephen at valuelinx.net).vcf
Type: text/x-vcard
Size: 616 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020408/bd68d237/attachment.vcf>