---------- Forwarded Message ----------
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["Alex
Fritz" <[EMAIL PROTECTED]>]
Date: Thu, 20 Dec 2001 10:48:19 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
>From [EMAIL PROTECTED] Thu Dec 20 10:48:18 2001
Received: from ncninternet.com (ns1.ncninternet.com [63.252.251.123])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id fBKGmI309554
for <[EMAIL PROTECTED]>; Thu, 20 Dec 2001 10:48:18 -0600
Received: from cc529972a [65.81.72.44] by ncninternet.com
(SMTPD32-7.04) id AEEF73F0112; Thu, 20 Dec 2001 12:33:19 -0600
From: "Alex Fritz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Logging in a database with a proxying realm
Date: Thu, 20 Dec 2001 12:25:24 -0600
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Importance: Normal
Hey guys,
Just need a little help here. We have some realms that are "passing
through" our radius server. The actual authentication takes place at their
server but we are the server the NAS looks to. We set it up to AuthBy
RADIUS and that works great. The problem is that we want to log the users
that authenticate or fail to that realm. We need to figure out how to
insert the packets into our database.
We tried using <AuthLog SQL> but were having difficulties getting it work
correctly. This is the piece of the config file we are having problems
with:
###############
<Realm always-onlineusa.com>
AuthByPolicy ContinueWhileAccept
<AuthBy RADIUS>
<Host 63.252.251.119>
Secret ncn123456
AuthPort 1814
AcctPort 1815
</Host>
</AuthBy>
<AuthLog SQL>
DBSource dbi:Oracle:ncnora
DBUsername radius_21globe
DBAuth 123456
LogSuccess 1
Table ACCOUNTING
DateFormat %a %b %e, %Y %I:%M %p
SuccessQuery insert into RADIUS_21GLOBE.ACCOUNTING \
(USERNAME, TIME_STAMP, LOGDATESTR, ACCTSTATUSTYPE,
ACCTDELAYTIME, \
ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID,
ACCTSESSIONTIME, \
ACCTTERMINATECAUSE, NASIDENTIFIER, NASPORT, FRAMEDIPADDRESS, \
CALLINGSTATIONID, CALLSTATIONID) \
values \
('%{User-Name}', %{Timestamp,integer}, \
'%{Timestamp,integer-date}', '%{Acct-Status-Type}', \
%{Acct-Delay-Time}, %{Acct-Input-Octets,integer}, \
%{Acct-Output-Octets,integer}, '%{Acct-Session-Id}', \
%{Acct-Session-Time,integer}, %{Acct-Terminate-Cause}, \
'%{NAS-Identifier}', %{NAS-Port,integer}, \
'%{NAS-IP-Address}', '%{Calling-Station-Id}', \
'%{Called-Station-Id}')
</AuthLog>
# Log accounting to a detail file
AcctLogFileName ./logs/always-online.detail
</Realm>
##################
Problem is that some of the values that come from the Special string
formatting characters are coming back null (which needs to be fixed because
we need those values) and this causes the SQL statement to fail. Please
help, we need to have these logs in our database and not in text files on
the radius server. Thanks.
Alex Fritz
[EMAIL PROTECTED]
Kerdaino Enterprises, Inc.
Mobile, AL USA
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.307 / Virus Database: 168 - Release Date: 12/11/2001
-------------------------------------------------------
--
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.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
