(RADIATOR) Accounting Table

[Hugh Irvine]

Hello GwangHee -

I will need to see a trace 4 debug from Radiator showing what is happening.

thanks

Hugh


On Tuesday 25 September 2001 07:10, GwangHee Yi wrote:
> Dear,
>
> I want to store cdr into mysql accounting table without authentication.
> I changed  a little bit from sql.cfg.
> I have generated tables with mysqlCreate.sql
> When I run radius, I got exact log file but accounting table is empty.
> What's wrong?
>
> The below is configuration.
>
> Thanks,
>
> ####################################
>
> Trace 0
> Foreground
> LogStdout
> LogDir          .
> DbDir           .
>
> AuthPort        1812
> AcctPort        1813
>
> # You will probably want to change this to suit your site.
> <Client DEFAULT>
>         Secret  xxxxxxxxxxx
>         DupInterval 0
> </Client>
>
> # This will authenticate users from SUBSCRIBERS
> <Realm DEFAULT>
>     <AuthBy SQL>
>         # Adjust DBSource, DBUsername, DBAuth to suit your DB
>         DBSource        dbi:mysql:radius
>         DBUsername      xxxxxx
>         DBAuth          xxxxx
>
>         # You may want to tailor these for your ACCOUNTING table
>         AccountingTable ACCOUNTING
>         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,integer
>         AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
>     </AuthBy>
>     # Log accounting to the detail file in LogDir
>     AcctLogFileName /var/radius_log/radius.log
> </Realm>
>
>
> ===
> 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.