Hi again,

In case needed for my previous question, here is my cfg file:

<Client DEFAULT>
                Secret xxxxxxx
        DupInterval 300
</Client>
<Realm DEFAULT>
MaxSessions 1
<AuthBy SQL>
DBSource dbi:Oracle:radius
DBUsername xxxxxx
DBAuth xxxxxx
AuthSelect select PASSWORD,CHECKATTR,REPLYATTR \
        from SUBSCRIBERS \
        where USERNAME = '%n' and \
        (expiredate > sysdate or totaldays = 0)
AccountingTable ACCT%Y%m
        AcctColumnDef USERNAME,User-Name
        AcctColumnDef TIME_STAMP,Timestamp
        AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
        AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets
        AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets
        AcctColumnDef ACCTSESSIONID,Acct-Session-Id
        AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time
        AcctColumnDef ACCTTERMINATECAUSE,Ascend-Disconnect-Cause
        AcctColumnDef NASIDENTIFIER,NAS-Identifier
        AcctColumnDef NASPORT,NAS-Port
        AcctColumnDef CALLERID,Caller-Id
        AcctColumnDef FRAMEDADDRESS,Framed-Address
        AcctColumnDef CLIENTDNIS,Client-Port-DNIS
        AcctColumnDef XMITRATE,Ascend-Xmit-Rate
        AcctColumnDef DATARATE,Ascend-Data-Rate
        AcctColumnDef LOGDATE,Timestamp,integer-date
AcctSQLStatement update subscribers \
        set expiredate=sysdate+7,totaldays=8 \
        where username='%n' and totaldays=7
</AuthBy>
</Realm>
<SessionDatabase SQL>
DBSource dbi:Oracle:radius
DBUsername xxxxxxx
DBAuth xxxxxxx
</SessionDatabase>


===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to