(RADIATOR) <AuthBy RADIUS cumulated to database logging for accounting info' s only

[Bruhin Gregor]

Hi,


######################################################################
# realm for roaming out for toto.net
######################################################################

<Realm toto.net>

        RewriteUsername tr/[A-Z]/[a-z]/

        <AuthBy RADIUS>
                Host 123.123.123.123
                Secret topsecret
                AuthPort 1812
                AcctPort 1813
                RetryTimeout 10
        </AuthBy>

        AcctLogFileName %L/acct.log.%Y-%m-%d
        PasswordLogFileName %L/passwd.log.%Y-%m-%d
</Realm>


And I would like to add something like following to log the accounting
info's for this realm :

                # For PostgreSQL, use something like this
                DBSource        dbi:Pg:dbname=db_name
                DBUsername   db_user
                DBAuth           topsecret

                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_ID,NAS-Identifier
                AcctColumnDef   NASIDENTIFIER_IP,NAS-IP-Address
                AcctColumnDef   NASPORT,NAS-Port,integer
                AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address

How can I do it ???

Many thanks for your help !


Gregor Bruhin
gbruhin at vianetworks.ch  
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
VIA NET.WORKS (Suisse) SA
Internet, E-Commerce, Réseaux, IP-Security, Hosting
Microsoft Certified Partner & Citrix-Partner
Rue St-Pierre 1, CH-1700 Fribourg, Switzerland 
Tel: +41 26 347 20 40 / Fax: +41 26 347 20 49
http://www.vianetworks.ch <http://www.vianetworks.ch> ,
mailto:office at vianetworks.ch <mailto:office at vianetworks.ch> 
Local Touch ... Global Reach
 <<Bruhin Gregor.vcf>> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020307/c6485641/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Bruhin Gregor.vcf
Type: application/octet-stream
Size: 131 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020307/c6485641/attachment.obj>