Offloading MySQL to a remote server
Posted: Thu May 17, 2018 6:42 pm
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
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