NetXMS Support Forum

Hi,

I have used NetXMS for a while on a Win 2008 server, and while it was great when it worked I found it a little unstable and it couldnt be trusted to restart correctly. So I am now moving it to Debian, but would like to create a fresh DB on the same MSSQL server.

I have installed from the .debs available (with unixodbc and freetds) and have got to a point where the DB is installed, but the daemon wont start. When I install the database it succeeds, then 'nxdbmgr check' passes. But when I start the service, the log produces:

[16-Jan-2013 10:02:24.276] Log file opened
[16-Jan-2013 10:02:24.276] Code page set to ISO-8859-1
[16-Jan-2013 10:02:24.277] Platform subagent "/usr/lib/libnsm_linux.so" successfully loaded
[16-Jan-2013 10:02:24.277] Debug callback set for DB library
[16-Jan-2013 10:02:24.277] Database driver "odbc.ddr" loaded and initialized successfully
[16-Jan-2013 10:02:24.283] New DB connection opened: handle=0x8147008
[16-Jan-2013 10:02:24.283] Successfully connected to database netxms_linux@kgsql
[16-Jan-2013 10:02:24.284] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name=?"): Unable to obtain description for this error
[16-Jan-2013 10:02:24.284] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name=?"): Unable to obtain description for this error
[16-Jan-2013 10:02:24.284] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name=?"): Unable to obtain description for this error
[16-Jan-2013 10:02:24.287] New DB connection opened: handle=0x8147140
[16-Jan-2013 10:02:24.290] New DB connection opened: handle=0x8195d38
[16-Jan-2013 10:02:24.292] New DB connection opened: handle=0x8195690
[16-Jan-2013 10:02:24.294] New DB connection opened: handle=0x81bc610
[16-Jan-2013 10:02:24.297] New DB connection opened: handle=0x81e3b00
[16-Jan-2013 10:02:24.297] Database Connection Pool initialized
[16-Jan-2013 10:02:24.297] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name=?"): Unable to obtain description for this error
[16-Jan-2013 10:02:24.298] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name=?"): Unable to obtain description for this error
[16-Jan-2013 10:02:24.298] SQL query failed (Query = "INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES (?,?,?,?)"): Unable to obtain description for this error
[16-Jan-2013 10:02:24.298] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name=?"): Unable to obtain description for this error
[16-Jan-2013 10:02:24.299] Error initializing component locks table

My config file contains:

LogFile = {syslog}
DBDriver = odbc.ddr
DBServer = kgsql
DBName = netxms_linux
DBLogin = netxms
DBPassword = netxms
LogFile = /var/log/netxmsd
LogFailedSQLQueries = yes
DBDrvParams = unicode=false

Any hints on how to overcome the ?

Thanks in advance.

BTW I did try the suggestion from the previous post too. Initially I setup with:
nxdbmgr init /usr/share/netxms/sql/dbinit_mssql.sql

Then I tried:
nxdbmgr -c /etc/netxmsd.conf init /usr/share/netxms/sql/dbinit_mssql.sql

Didnt seem to make any difference, as my config file is in /etc which I believe is default.

Dont worry about it - I couldnt make it work. I had enough resources on the same machine so I whacked MySQL on there and it works fine.