Print Page - NetXMS Debian 9 MsSQL

Title: NetXMS Debian 9 MsSQL
Post by: Francois on January 12, 2018, 10:12:55 PM

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

Title: Re: NetXMS Debian 9 MsSQL
Post by: Victor Kirhenshtein on January 14, 2018, 01:42:46 PM

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

Title: Re: NetXMS Debian 9 MsSQL
Post by: Francois on January 16, 2018, 05:36:07 PM

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

Title: Re: NetXMS Debian 9 MsSQL
Post by: Victor Kirhenshtein on January 17, 2018, 10:33:12 AM

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 (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

Title: Re: NetXMS Debian 9 MsSQL
Post by: Francois on January 29, 2018, 05:55:05 PM

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

NetXMS Support Forum

English Support => General Support => Topic started by: Francois on January 12, 2018, 10:12:55 PM