(RADIATOR) Unclosed quotation mark in SQL SessionDatabase DeleteQuery

[Hugh Irvine]

Hello William -

There were some patches for this in Radiator 3.4.

 From the history file ("doc/history.html"):

Improvements to SessionDatabase SQL, so that the NAS ID, NAS port and 
SQL quoted
     Acct-Session-Id are available in the AddQuery.


The latest version is Radiator 3.6 (plus patches) so I suggest you test 
the latest version.

regards

Hugh


On Thursday, Sep 18, 2003, at 02:26 Australia/Melbourne, William 
Hernandez wrote:

> Hello everyone,
>
> The following error messages appeared in radius.log:
>
> Wed Sep 17 09:17:55 2003: ERR: do failed for 'delete from
> RADONLINE where NASIDENTIFIER='xxx.xxx.xx.x' and NASPORT=010212':
> Server message number=105 severity=15 state=1 line=1 server=SQL
> text=Unclosed quotation mark before the character string
> 'xxx.xxx.xx.x'.Server message number=170 severity=15 state=1
> line=1 server=SQL text=Line 1: Incorrect syntax near
> 'xxx.xxx.xx.x'.
>
> Wed Sep 17 09:17:55 2003: ERR: do failed for 'delete from
> RADONLINE where NASIDENTIFIER='xxx.xxx.xx.x' and NASPORT=010212':
> Server message number=105 severity=15 state=1 line=1 server=SQL
> text=Unclosed quotation mark before the character string
> 'xxx.xxx.xx.x'.Server message number=170 severity=15 state=1 line
> 1 server=SQL text=Line 1: Incorrect syntax near 'xxx.xxx.xx.x'.
>
> Our Radiator 3.3.1 is configured to use an MSSQL2000 session
> database with a fallback to MySQL 3.23.49. We are using the
> default DeleteQuery. The messages appeared when the SQL Server
> was put temporarily offline causing Radiator to fallback to
> MySQL. And disappeared when the SQL Server was put back online
> and Radiator restarted.
>
> Actually the fallback to MySQL was a recent change to radius.cfg.
> Previously we only used MySQL as our session database and
> everything worked fine. We now use MSSQL with a fallback to
> MySQL.
>
> Any thoughts on what's happening here?
>
> Thanks in advance,
> William
>
> ===
> 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.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, 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.