NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: NetXMS Debian 9 MsSQL  (Read 485 times)

Francois

  • Newbie
  • *
  • Posts: 3
    • View Profile
NetXMS Debian 9 MsSQL
« 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:
Quote
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:
Quote
DBDriver=odbc.ddr
DBServer=SQL_NetXMS
DBName=NetXMS
DBLogin=sa_netxms
DBPassword=test

Can anyone help me make it run?

Thanks
Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6194
    • View Profile
Re: NetXMS Debian 9 MsSQL
« Reply #1 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
Logged

Francois

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: NetXMS Debian 9 MsSQL
« Reply #2 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
« Last Edit: January 16, 2018, 05:39:24 pm by Francois »
Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6194
    • View Profile
Re: NetXMS Debian 9 MsSQL
« Reply #3 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

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
Logged

Francois

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: NetXMS Debian 9 MsSQL
« Reply #4 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:
Quote
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
Logged