(RADIATOR) SQL Accounting, without Auth

[Hugh Irvine]

Hello Andy -

Instead of using a <Realm> clause, use this:

# define Handler for accounting starts and stops only

<Handler Acct-Status-Type = /Start|Stop/>
	AcctLogFileName /path/to/my/file
	<AuthBy SQL>
		.....
	</AuthBy>
</Handler>

<Handler>
	<AuthBy INTERNAL>
		AcctResult ACCEPT
	</AuthBy>
</Handler>


Note that the AuthBy INTERNAL is only available in Radiator 2.19, but you can 
get the same result by using an AuthBy FILE.

regards

Hugh


On Sat, 8 Dec 2001 02:34, Andy Coates wrote:
> Hugh Irvine wrote:
> > Hello Andy -
> >
> > On Thu, 6 Dec 2001 22:23, Andy Coates wrote:
> > > Hey,
> > >
> > > I'm taking over a system which currently runs Radiator, who's job
> > > is to simply log accounting requests.
>
> [snip]
>
> > > My config as it stands is:
> > >
> > > <Realm>
> > >         AcctLogFileName /path/to/my/file
> > >
> > > 	<AuthBy SQL>
> > >         	DBSource    <details>
> > >                 DBUsername  <user>
> > >                 DBAuth      <pass>
> > >
> > >                 AuthSelect
> > >                 AccountingTable accounting
> > >                 AcctColumnDef   timestamp,Timestamp,integer
> > >                 AcctColumnDef   type,Acct-Status-Type
> > >                 AcctColumnDef   session,Acct-Session-Id
> > >                 AcctColumnDef   online,Acct-Session-Time,integer
> > >                 AcctColumnDef   nas,NAS-IP-Address
> > >                 AcctColumnDef   caller,Calling-Station-Id
> > >                 AcctColumnDef   calling,Called-Station-Id
> > > 	</AuthBy>
> > > </Realm>
> > >
> > >
> > > Would this setup therefore log accounting requests to the SQL server,
> > > even if its doing no authentication? Or am I going about this the
> > > wrong way entirely? :)
> >
> > Your configuration is correct.
> >
> > As long as this server is only receiving accounting requests, those
> > requests will be written to the accounting log file and to the SQL
> > database.
>
> Hi again,
>
> Worked after I had fixed DBI issues, but then came my next problem...
>
> Unfortunately I get EVERYTHING logged, i.e. Tunnel-Start and Stops,
> which the server also receives accounting for. However, if I set
> AccountingStartsOnly it does do just Start, and not Tunnel-Start.
> So if I could do AccountingStopsOnly, it would just do Stops.
>
> But, you can't do AccountingStartsOnly and AccountingStopsOnly,
> so I'm stuck - any way around this on the Radiator side?
>
> Cheers,
> Andy.

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