(RADIATOR) Radiator config for Cisco VOIP

[User BALGAA System Engineer]

Hello,

I am trying to configure Radiator to store accounting CDR from Cisco
AS5300 VOIP gateways.

I created sample radiator config:
---------------------------------
Foreground
LogDir          .
LogFile     %L/logfile
DictionaryFile /usr/local/Radiator-3.1/dictionary
DbDir           .
Trace           4

<Client x.x.x.x>
        Secret  <removed>
        DupInterval 15
</Client>

<Client y.y.y.y>
        Secret  <removed>
        DupInterval 15
</Client>

<Client 127.0.0.1>
        Secret  <removed>
        DupInterval 15
</Client>
<Realm DEFAULT>
                PasswordLogFileName %L/publicb.log
        <AuthBy FILE>
                Nocache
                Filename %D/mtc.users

        </AuthBy>
                AcctLogFileName /usr/local/voip/detail
</Realm>


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?

Any suggestion?

Secondly, if possible I would like to know any production system using
Radiator for Cisco VOIP prepaid/debit calling card application.

Could you send me Radiator config for such application? Also what TCL or other scripts
needed for Radiator, Cisco gateway.

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.