(RADIATOR) SQL Accounting, without Auth

[Hugh Irvine]

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.
>
> Its a very simple config, which basically has:
>
> <Realm>
> 	AcctLogFileName /path/to/my/file
> </Realm>
>
>
> What I'd like to do is log to an SQL server instead, which is fine
> if I have an <AuthBy SQL> section with AccountTable defined, but
> since I'm not Authenticatng it doesn't want to take notice of it.
>
> I read the mailing list archives and did come across a similar
> thread which talked about multiple accounting types - but in the
> scenario used various Auth types.
>
> It did mention however that if you did have an AuthBy but used
> the option "AuthSelect" without any parameters it would ignore
> authentication - but would it still use the AccountingTable?
>
> 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.

regards

Hugh


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