SQLAuthLog problem

[Nguyen Tuan Anh]

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                               mikem at open.com.au
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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.