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 [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.