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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
