Netxmsd doesn't start has database error var_name=?"): Unknown command
-
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 failedC:\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 -
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login