Basically, you can customize it however. This is what I use. I admit I
didn't
put a whole lot of time into customization, but this works pretty well. I
added
the STATUS field so I can easily expire accounts. It was basically designed
for MegaPOP customers.
<AuthBy SQL>
AuthSelect select PASSWORD,SERVICETYPE,PROTOCOL,IPADDRESS,IPNETMASK
from
SUBSCRIBERS where USERNAME='%n' and STATUS="A"
DBSource dbi:mysql:database_name
DBUsername uid
DBAuth pwd
AuthColumnDef 0, User-Password, check
AuthColumnDef 1, Service-Type, reply
AuthColumnDef 2, Framed-Protocol, reply
AuthColumnDef 3, Framed-IP-Address, reply
AuthColumnDef 4, Framed-IP-Netmask, reply
AcctColumnDef USERNAME,User-Name
AcctColumnDef IPADDRESS,Framed-IP-Address
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct_Terminate-Cause
AcctColumnDef NASPORT,NAS-Port,integer
At 02:12 PM 1/6/00 -0600, you wrote:
>Does anyone have a list of tables, columns, and data types that Radiator
>users when SQL is the auth method? Thanks.
>
>--
>Josh Arnold
>
Matt Chambers
Internet Visionary
The PressRoom
http://www.pressroom.com
703-631-5755 x3001
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
