Offloading MySQL to a remote server

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
pierros
Posts: 1
Joined: Thu May 17, 2018 6:02 pm

Offloading MySQL to a remote server

Post by pierros »

Hello everybody,

I meet some problems with offloading MySQL to a remote server.
In fact, since the offloading, data are not added to the database anymore.

Errors I got in log/messages:

ndo2db: mysql_error: 'Data too long for column 'command_line' at row 1'
ndo2db: mysql_error: 'Data too long for column 'varvalue' at row 1'


So I modified the types of these columns (that were varchar255) to text to make these errors disappear.

However, I noticed that each time I try insert hosts from Auto-Discovery, old records (that were already in DB) have their host_id increment by the number of total records in the database.

The problem is very similar to this topic (https://support.nagios.com/forum/viewto ... 5&p=107741) but the solution doesn't work for me.

Thank you for your help.

Pierre
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Offloading MySQL to a remote server

Post by scottwilkerson »

Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
Locked