NetXMS Support Forum

Thanks, it works.

I added this in my ODBC.ini:

Quote[sql-server]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
Server = <servername>
Port = 1433
Database = <DBname>
Username = <username>
Password = <password>

and it connected but with a lot of errors so I added this to my netxmsd.conf:

QuoteDBDrvParams = unicode=false

I still had some error when the process started but not after.
so I deleted all the tables from my database and recreate it using nxdbmgr and no more errors

Thanks

No I'm not sure, my odbc.ini file is empty
can you tell me where is the information in the guide? I didn't found anything

Thanks

Frank

Hi,

I installed NetXMS 2.2.2 on Debian 9.3.0 with netxms release package.
I tried to use nxdbmgr to create all the table but it didn't work.
I copied the dbinit_mssql.sql file from the /usr/share/netxms and ran it manually on the sql server.

everytime I try to start the process I get this error:

Quote2018.01.12 14:30:51.864 Log file opened (rotation policy 2, max size 16777216)
2018.01.12 14:30:51.865 *I* Platform subagent "/usr/lib/x86_64-linux-gnu/netxms/linux.nsm" successfully loaded
2018.01.12 14:30:51.865 *I* Database driver "odbc.ddr" loaded and initialized successfully
2018.01.12 14:31:16.892 *E* Unable to establish connection with database ([unixODBC][Driver Manager]Data source name not found, and no default driver specified)

This is my netxmsd.conf:

QuoteDBDriver=odbc.ddr
DBServer=SQL_NetXMS
DBName=NetXMS
DBLogin=sa_netxms
DBPassword=test

Can anyone help me make it run?

Thanks