(RADIATOR) AuthLog questions

[Hugh Irvine]

Hello Robert -

You would use the same DBSource, DBUsername and DBAuth as for the other SQL 
clauses.

<AuthLog SQL>
	DBSource ....
	DBUsername .....
	DBAuth ....
	.....
</AuthLog>

regards

Hugh


On Thu, 30 May 2002 23:28, Robert Blayzor wrote:
> I've followed the Radiator manual for <AuthLog SQL>
>
> Here are my config entries:
>
> <AuthLog SQL>
>         Identifier      SQL-AuthLog1
>         FailureQuery    EXEC sp_RadiusAuthLog
> '%{GlobalVar:ServerID}','%n','%{Class}','%N','%{Called-Station-Id}','%{C
> alling-Station-Id}','%1'
>         LogSuccess      0
>         LogFailure      1
> </AuthLog>
>
> <Handler>
>         RewriteUsername         s/^(P|C|S)//
>         RewriteUsername         tr/A-Z/a-z/
>         RewriteUsername         s/\s+//g
>         AuthByPolicy            ContinueAlways
>         AuthBy                  Acct-SQL
>         AuthBy                  Auth-NAS
>         AuthLog                 SQL-AuthLog1
>         SessionDatabase         Null-SDB
> </Handler>
>
>
> My questions is, how does AuthLog SQL know which database source to use?
> Or will it assume to use the same source as the AuthBy?   Or does it
> accept DBSource, etc?  The manual does not state so.  All the manual
> states is:
>
> 6.50 <AuthLog SQL>
> The clause indicates to log authentication successes and failures to an
> SQL database. You can define as many <AuthLog SQL> clauses as you wish
> at the top level or within Realm or Handler clauses. Each clause can
> specify different logging conditions and a different log database.
>
> As well as the generic parameters described in Section 6.48 , AuthLog
> SQL understands the following parameters:
>
>
> Please advise.

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