(RADIATOR) Sending SQL accounting to a different server

[Hugh Irvine]

Hello William -

Yes this is very simple to do.

There are a number of ways of configuring this depending on what your  
existing setup looks like.

Here is an example:


# define AuthBy clause for accounting

<AuthBy SQL>
	Identifier SQLAccounting
	DBSource ....
	DBUsername ....
	DBAuth ....
	# disable authentication
	AuthSelect
	# set up accounting
	AccountingTable ACCOUNTING
	AcctColumnDef .....
	.....
</AuthBy>

# define Realms or Handlers

<Handler ...>

	AuthByPolicy ContinueAlways

	AuthBy SQLAccounting

	<AuthBy ...>
		# your exisitng AuthBy
		.....
	</AuthBy>

</Handler>

......


hope that helps

regards

Hugh



On 30 Apr 2006, at 23:28, William Holmes wrote:

> Hello,
>
>
>
> I would like to send my Accounting Info to a SQL server other than  
> the one that my Auth Data is being stored.  Is this possible?   
> Actually what I am really trying to do is send all accounting data  
> to another SQL server globally. I have several different AuthBy  
> clauses and I want the accounting for all of them to go to the same  
> SQL Server.
>
>
>
> Is there an example of setting this up (assuming it can be done)?
>
>
>
> Thanks
>
>
>
> Bill
>
>


NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


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