--- Forwarded mail from [EMAIL PROTECTED] (Hugh Irvine)
Date: Tue, 20 Jul 1999 11:04:58 +1000
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED] (Hugh Irvine)
Subject: (RADIATOR) SQL accounting
>>Received: from yarrina.connect.com.au (yarrina.connect.com.au
>>[192.189.54.17]) by perki.connect.com.au with ESMTP id XAA13574
> (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Mon, 19 Jul 1999 23:52:14
>+1000 (EST)
>From: "Jamie Orzechowski" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: (RADIATOR) SQL accounting
>Date: Mon, 19 Jul 1999 09:57:31 -0400
>MIME-Version: 1.0
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2918.2701
>Sender: [EMAIL PROTECTED]
>Precedence: bulk
>Status:
>
>I have successfully created a database call ACCOUNTING on my SQL server with
>all the tables I need ...
>
>how can I make it authenticate via RODOPI as usual and also send just the
>accounting records to another database (while still sending them to my
>rodopi database also)
>
>my config which works fine is
>
><AuthBy RODOPI>
> DBSource dbi:Sybase:rodopi
> DBUsername Rodopi
> DBAuth xxxxxxxxxx
></AuthBy>
>
>I would also like to send the following to another database called
>"SPAMTRACKER"
>
>AccountingTable ACCOUNTING
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
>
You will need something like this:
<Realm ....>
# Set up a series of AuthBy to handle both tasks
AuthByPolicy ContinueAlways
# First AuthBy logs all accounting records to SPAMTRACKER database (note
empty AuthSelect)
<AuthBy SQL>
DBSource dbi:Sybase:SPAMTRACKER
DBUsername ....
DBAuth ....
AuthSelect
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy>
# Then do your normal authentication with Rodopi
<AuthBy RODOPI>
DBSource dbi:Sybase:rodopi
DBUsername Rodopi
DBAuth xxxxxxxxxx
</AuthBy>
</Realm>
Hugh
---End of forwarded mail from [EMAIL PROTECTED] (Hugh Irvine)
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
