(RADIATOR) sql and logfiles

[Hugh Irvine]

Hello -

You will simply need an AuthBy SQL clause configured to log accounting to 
your database, and you will also need an AcctLogFileName parameter in your 
Realm(s) or Handler(s).

# define a Realm with SQL accounting, proxy radius and an accounting file

<Realm ....>
	AuthByPolicy ContinueAlways
	<AuthBy SQL>
		......
		# empty AuthSelect to disable authentication
		AuthSelect
		# AccountingTable and AcctColumnDef's
		AccountingTable ACCOUNTING
		AcctColumnDef .....
		.....
	</AuthBy>
	<AuthBy RADIUS>
		.....
	</AuthBy>
	AcctLogFileName %L/detail-%Y-%m-%d
	......
</Realm>

Have a look at the relevant sections in the Radiator 3.0 manual.
("doc/ref.html").

regards

Hugh


On Wed, 1 May 2002 17:20, Tech wrote:
> As our radiator runs only as a proxy server I need to send accounting by
> radius plus I now need on our system both to have a detail file and also
> to do our accounting to a Oracle DB.
>
> Any help in doing this this would be of great value to me, also any
> examples would be a great help to me. I am how using handlers in my
> config file.
>
> Also please advise the url to pick up all the patches for ver3
>
> ===
> 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.