(RADIATOR) SQLAuthLog problem

[Hugh Irvine]

Hello Tuan Anh -

Thanks for bringing this to our attention. This is a bug that has been fixed 
in Radiator 3.0, so if it is not causing you too much trouble at the moment 
we would suggest you wait until Radiator 3.0 is released and upgrade.

regards

Hugh


On Thu, 21 Feb 2002 14:47, Nguyen Tuan Anh \( Netnam.org.vn\) wrote:
> 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.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.