manually remove data from mysql db

[BradZynda]

So someone restarted iptables when Nagios was running, guess this was enough to junk out the DB... :/

Aug 9 12:43:58 nms1 ndo2db: Error: mysql_query() failed for 'UPDATE nagios_conninfo SET disconnect_time=NOW(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='0', lines_processed='0', entries_processed='0' WHERE conninfo_id='0''

Ran all the repair scripts which seems to have fixed the DB but in the time frame a mount created via Linux SNMP wizard was attempted to be deleted.

/usr/local/nagiosxi/scripts/repairmysql.sh nagios
/usr/local/nagiosxi/scripts/repairmysql.sh nagiosql

(another one as well which did all three, though I don't remember the name off the top of my head)

and

/usr/bin/mysqlcheck --auto-repair --all-databases

All of which returned ok or repairs completed.


The deletion appears to have only occurred on the ccm side and is no longer showing in the server service area under Core Config Manager -> Services but is still in the DB and is checking...

How does one now remove that mount check? Guessing a specific mysql query.. tried a config restore but didn't bring back the listing in the ccm.

Thanks,
Brad

[bolson]

Hi Brad, if I understand your question, Navigate to Configure ~ Core Config Manager ~ __Commands

Find the commands and delete them. Please let me know if I'm not understanding your issue or if you have additional questions.