(RADIATOR) Radiator config for Redback SMS1800

User BALGAA System Engineer balgaa at publica.ub.mng.net
Sat Aug 31 23:48:40 CDT 2002


Hello,

I am trying to configure Radiator with Redback SMS1800 system.
We are using SMS1800 for ADSL subscriber management.

And I would like to store accounting CDR to MySQL database instead of
detail file.
But I need to know which AcctColumnDef need to define in Radiator config
and MySQL database?

I know how to store accounting for dial-up like following:
----------------------------------------------------------
<AuthBy SQL>
        DBSource        dbi:mysql:radius:x.x.x.x
        DBUsername      <removed>
        DBAuth          <removed>

        Identifier SQLAcctOnly

        AuthSelect

        AccountingTable ACCOUNTING
        AccountingStopsOnly

        AcctColumnDef   USERNAME,User-Name
        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   NASIDENTIFIER,NAS-Identifier
        AcctColumnDef   NASPORT,NAS-Port
        AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
        AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id
        AcctColumnDef   class,Class

</AuthBy>


How can I to define AcctColumnDef in MySQL? Because I don't know which VSA
attributes can be used with Redback.

Any suggestion?

Thanks,
Balgaa


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


More information about the radiator mailing list