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

[Hugh Irvine]

Salut Gregor -

Faudrait quelque-chose comme ceci:

# define Realm

<Realm toto.net>

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

        AuthByPolicy ContinueAlways

        <AuthBy SQL>

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

                AuthSelect

                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
        </AuthBy>

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


A+

Hugues


On Thu, 7 Mar 2002 20:05, Bruhin Gregor wrote:
> 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>>

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