NetXMS Support Forum

Netxmsd dies with database query errors.  This a new install of 1.1.10. 
Also had tried to do an upgrade and the database upgrade failed at version 247 with an INSERT command to the same table with values of ?,?,?
Since it was a test install, I decided to start with a new database but then got the following errors.
Please let me know how to troubleshoot and hopefully fix.  Thanks.

C:\NetXMS\bin>netxmsd -D 9 -c c:\netxms\etc\netxmsd.conf standalone
Using configuration file "c:\netxms\etc\netxmsd.conf"
[28-Mar-2012 16:05:35] Debug callback set for DB library
[28-Mar-2012 16:05:35] Database driver "mysql.ddr" loaded and initialized succes
sfully
[28-Mar-2012 16:05:35] DBConnect: server=fl36nms02.am.mot-mobility.com db=netxms
_db login=netxms schema=
[28-Mar-2012 16:05:35] New DB connection opened: handle=00CF9BF0
[28-Mar-2012 16:05:35] Successfully connected to database [email protected]
.mot-mobility.com
[28-Mar-2012 16:05:35] Successful sync query: "SELECT var_value FROM metadata WH
ERE var_name='SchemaVersion'" [0 ms]
[28-Mar-2012 16:05:35] SQL query failed (Query = "SELECT var_value FROM config W
HERE var_name=?"): Unknown command
[28-Mar-2012 16:05:35] SQL query failed (Query = "SELECT var_value FROM config W
HERE var_name=?"): Unknown command
[28-Mar-2012 16:05:35] SQL query failed (Query = "SELECT var_value FROM config W
HERE var_name=?"): Unknown command
[28-Mar-2012 16:05:35] DBConnect: server=fl36nms02.am.mot-mobility.com db=netxms
_db login=netxms schema=
[28-Mar-2012 16:05:35] New DB connection opened: handle=00CF9040
[28-Mar-2012 16:05:35] DBConnect: server=fl36nms02.am.mot-mobility.com db=netxms
_db login=netxms schema=
[28-Mar-2012 16:05:35] New DB connection opened: handle=00CF9118
[28-Mar-2012 16:05:35] DBConnect: server=fl36nms02.am.mot-mobility.com db=netxms
_db login=netxms schema=
[28-Mar-2012 16:05:35] New DB connection opened: handle=00CF91F0
[28-Mar-2012 16:05:35] DBConnect: server=fl36nms02.am.mot-mobility.com db=netxms
_db login=netxms schema=
[28-Mar-2012 16:05:35] New DB connection opened: handle=00CF92E0
[28-Mar-2012 16:05:35] DBConnect: server=fl36nms02.am.mot-mobility.com db=netxms
_db login=netxms schema=
[28-Mar-2012 16:05:35] New DB connection opened: handle=00CF93D0
[28-Mar-2012 16:05:35] Database Connection Pool initialized
[28-Mar-2012 16:05:35] Successful sync query: "SELECT var_value FROM metadata WH
ERE var_name='Syntax'" [0 ms]
[28-Mar-2012 16:05:35] SQL query failed (Query = "SELECT var_value FROM config W
HERE var_name=?"): Unknown command
[28-Mar-2012 16:05:35] Successful sync query: "SELECT var_value FROM config WHER
E var_name='ServerID'" [0 ms]
[28-Mar-2012 16:05:35] Successful sync query: "UPDATE config SET var_value='7908
00000F6F734F' WHERE var_name='ServerID'" [0 ms]
[28-Mar-2012 16:05:35] SQL query failed (Query = "SELECT var_value FROM config W
HERE var_name=?"): Unknown command
[28-Mar-2012 16:05:35] DBLockStatus="ERROR"
[28-Mar-2012 16:05:35] Error initializing component locks table
NetXMS Core initialization failed

C:\NetXMS\bin>

Hello!

What is your MySQL version? So far it looks like your MySQL server does not support prepared statements, which is the case for versions before 4.1.

Best regards,
Victor

The MySQL version is 4.0.16.  I will look into upgrading MySQL.

Thanks for your help.