NetXMS Debian 9 MsSQL

[Francois]

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:

2018.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:

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

Can anyone help me make it run?

Thanks

[victor]

Hi,

if you are using ODBC driver then database server is in fact ODBC data source. Are you sure that you have configured UNIX ODBC data source correctly?

Best regards,
Victor

[Francois]

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

[victor]

Configuring ODBC is not related to NetXMS itself, so it is not covered in manual. There are lot of information on how to configure unixODBC to work with MS SQL, for example: http://help.interfaceware.com/kb/904

On NetXMS side, you may need to add to your netxmsd.conf the following line:

DBDrvParams = unicode=false

but only do that if you'll be unable to connect without it.

Best regards,
Victor

[Francois]

Thanks, it works.

I added this in my ODBC.ini:

[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:

DBDrvParams = 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