(RADIATOR) Radiator config for Redback SMS1800

[Hugh Irvine]

Hello Balgaa -

As mentioned in my previous mail, you should have a look at the detail 
file produced by this device and then simply translate the attributes 
into SQL AcctColumnDef's.

You will find the Redback VSA's in the file "dictionary.redback" (which 
you should add to the standard dictionary.

regards

Hugh


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

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

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