---------- Forwarded Message ----------
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["Nguyen
Tuan Anh" <[EMAIL PROTECTED]>]
Date: Wed, 20 Feb 2002 19:54:56 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
>From [EMAIL PROTECTED] Wed Feb 20 19:54:56 2002
Received: from smtp.netnam.vn (smtp.netnam.vn [203.162.7.93])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id g1L1ss304695
for <[EMAIL PROTECTED]>; Wed, 20 Feb 2002 19:54:54 -0600
Received: from tec (h39.netnam.vn [203.160.0.39] (may be forged))
by smtp.netnam.vn (8.10.2/8.10.2) with SMTP id g1L3T0A15386
for <[EMAIL PROTECTED]>; Thu, 21 Feb 2002 10:29:00 +0700 (GMT)
From: "Nguyen Tuan Anh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: SQLAuthLog problem
Date: Thu, 21 Feb 2002 10:26:56 +0700
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 V5.00.2919.6700
Importance: Normal
Hi all
I log login error by using AuthLog
FailureQuery insert into
RadAuthLog(Time_Stamp,username,realm,nasipaddress,nasport,reason) values
(getdate(),'%U','%R','%N','%{NAS-Port}','%1')
Normally, It works fine but when I limit Calling station ID, the error
message occurrs when logging into database:
Wed Feb 20 09:46:20 2002: DEBUG: do query is: insert into
RadAuthLog(Time_Stamp,username,realm,nasipaddress,nasport,reason) values
(getdate(),'lam.nied','internet','10.9.0.6','16909325','Check item
Calling-Station-Id expression '/47561890|9421993/' does not match '47561885'
in request')
Wed Feb 20 09:46:20 2002: ERR: do failed for 'insert into
RadAuthLog(Time_Stamp,username,realm,nasipaddress,nasport,reason) values
(getdate(),'lam.nied','internet','10.9.0.6','16909325','Check item
Calling-Station-Id expression '/47561890|9421993/' does not match '47561885'
in request')': [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax near '47561885'. (SQL-37000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1)
Because of quoted character in reason value.
How can I delete quoted character in config file ?
Nguyen Tuan Anh
Netnam-IOIT
-------------------------------------------------------
--
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.
