(RADIATOR) Logging to SQL DB

[Hugh Irvine]

Hello Magnus -

The answer to this depends somewhat on what else you are doing, however here 
is one way to do it.

# define AuthBy clauses

<AuthBy SQL>
	Identifier SQLAccounting
	DBSource ...
	DBUsername ....
	DBAuth .....
	# empty AuthSelect (no authentication)
	AuthSelect
	AccountingTable ACCOUNTING
	AcctColumnDef .....
	AcctColumnDef .....
	.....
</AuthBy>

<AuthBy RADIUS>
	Identifier ForwardToProxy
	.....
</AuthBy>

# define Realms or Handlers

<Realm ....>
	AuthByPolicy ContinueAlways
	AuthBy SQLAccounting
	AuthBy ForwardToProxy
	.....
</Realm>

This is a simple example and much more sophisticated configurations are 
possible of course.

hth

Hugh


On Wednesday 29 August 2001 11:12, Magnus E. Sigurdsson wrote:

> > Hi,
>
> Is it possible to set up Radiator in such a way so that I can get it to
> authenticate by one method and log accounting to an SQL DB? Specifically I
> need to proxy authentication requests to another Radius server using
> <AuthBy Radius> but I'd still like to log to our MS SQL 7 DB.
>
> Thanks,
>
> Magnus E. Sigurdsson
> Network Administrator
> Hringidan ehf. / Vortex Inc.

----------------------------------------
Content-Type: text/html; charset="Windows-1252"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

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