--- Forwarded mail from [EMAIL PROTECTED]
Date: Mon, 7 May 2001 16:55:40 -0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["James
Laszko" <[EMAIL PROTECTED]>]
>From [EMAIL PROTECTED] Mon May 7 16:55:39 2001
Received: from galaxy.TFBnet-AD.com (galaxy.tfb.com [209.68.228.8])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id f47Ltd405628
for <[EMAIL PROTECTED]>; Mon, 7 May 2001 16:55:39 -0500
Subject: Radiator/RadiusNT Logging and Platypus 3.0 build 587
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Date: Mon, 7 May 2001 16:53:46 -0700
content-class: urn:content-classes:message
X-MimeOLE: Produced By Microsoft Exchange V6.0.4417.0
Message-ID: <[EMAIL PROTECTED]>
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: Radiator/RadiusNT Logging and Platypus 3.0 build 587
Thread-Index: AcDXUPSFg7bfMNDKQ26ASjxIXyO9dg==
From: "James Laszko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by server1.open.com.au id
f47Ltd405629
We've got a Radiator 2.18 installation that isn't properly logging to
our SQL server for failed logins, etc... It worked in 2.17.1, but not
in the new version -- what have I got wrong?? Nothing new appears to be
added to the RadLogs table in the Platypus database...
Here's our radius.cfg file:
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=-=-=-=-=
# TFBnet Radiator Configuration
#
#
#
# Turn on debug tracing below
Trace 4
# Turn application run in foreground mode on below
#Foreground
LogStdout
LogDir c:\var\log
DbDir c:\etc\raddb
<ClientListSQL>
DBSource dbi:ODBC:Platypus
DBUsername platuser
DBAuth <pw>
GetClientQuery select IPAddress,secret from Servers
</ClientListSQL>
<AuthBy EMERALD>
Identifier CheckEMERALD
DBSource dbi:ODBC:platypus
DBUsername platuser
DBAuth <pw>
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
AcctColumnDef AcctStatusType,Acct-Status-Type,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef AcctSessionId,Acct-Session-Id
AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIdentifier,NAS-IP-Address
AcctColumnDef NASPort,NAS-Port,integer
AcctColumnDef ipaddress,Framed-IP-Address
AcctColumnDef CalledStationID,Called-Station-ID
AcctColumnDef CallingStationID,Calling-Station-ID
AuthSelect ,sa.LoginLimit
AuthColumnDef 0,Simultaneous-Use,check
</AuthBy>
<AuthBy RADIUS>
Identifier CheckLUCENT
Synchronous
<Host vortex.tfb.com>
Secret <secret>
</Host>
</AuthBy>
<Handler Request-Type=Accounting-Request>
AuthBy CheckEMERALD
</Handler>
<Handler Realm=tfb.com>
AuthByPolicy ContinueUntilAccept
RejectHasReason
<AuthBy GROUP>
# Check to see if [EMAIL PROTECTED] authenticates
AuthBy CheckEMERALD
</AuthBy>
<AuthBy GROUP>
AuthBy CheckLUCENT
</AuthBy>
<AuthBy GROUP>
# Check to see if username (stripped off realm)
authenticates
RewriteUsername s/^([^@]+).*/$1/
AuthBy CheckEMERALD
</AuthBy>
<AuthBy GROUP>
AuthBy CheckLUCENT
</AuthBy>
</Handler>
<Handler>
AuthByPolicy ContinueUntilAccept
RejectHasReason
<AuthBy GROUP>
# Check to see if username authenticates
AuthBy CheckEMERALD
</AuthBy>
<AuthBy GROUP>
AuthBy CheckLUCENT
</AuthBy>
<AuthBy GROUP>
# Check to see if [EMAIL PROTECTED] (added on realm)
authenticates
RewriteUsername s/(.*)/$1\@tfb.com/
AuthBy CheckEMERALD
</AuthBy>
<AuthBy GROUP>
AuthBy CheckLUCENT
</AuthBy>
</Handler>
# If you wish, you can also log to the Emerald message log
# by uncommenting this. The Emerald message log is also
# supported by the Platypus RadiusNT compatibility package
#<Log EMERALD>
# # These should probably be the same as for your AuthBy EMERALD
# DBSource dbi:ODBC:Platypus
# DBUsername platuser
# DBAuth <pw>
# DateFormat %b %e, %Y %H:%M:%S
# Trace 3
#</Log>
<Log EMERALD>
DBSource dbi:ODBC:Platypus
DBUsername platuser
DBAuth <pw>
</Log>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=-=-=-=-=
Thanks,
James Laszko
TFBnet
[EMAIL PROTECTED]
---End of forwarded mail from [EMAIL PROTECTED]
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.