(RADIATOR) SQLAuthLog problem

[Nguyen Tuan Anh ( Netnam.org.vn)]

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



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