(RADIATOR) Radiator config for Cisco VOIP

[Hugh Irvine]

Hello Balgaa -

There is a file in the goodies directory called "voip.txt". You should 
read it thoroughly.

You should also look at the detail file that is produced by your 
configuration file below, and then just translate the attributes into 
the equivalent SQL AcctColumnDef's like you show further down.

regards

Hugh


On Sunday, September 1, 2002, at 02:40 PM, User BALGAA System Engineer 
wrote:

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

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

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