{"id":615,"date":"2016-04-26T15:23:08","date_gmt":"2016-04-26T09:53:08","guid":{"rendered":"http:\/\/www.middlewareprimer.com\/blog\/?p=615"},"modified":"2016-04-26T15:23:08","modified_gmt":"2016-04-26T09:53:08","slug":"sql-error-nagios-xi-console","status":"publish","type":"post","link":"http:\/\/www.middlewareprimer.com\/blog\/2016\/04\/26\/sql-error-nagios-xi-console\/","title":{"rendered":"SQL Error in Nagios XI Console"},"content":{"rendered":"

SQL Error in Nagios XI Console pops up strangley after configuring services for monitoring. This has happened frequently and after checking out Nagios XI library, there is resolution given by them for the same.<\/p>\n

Error message:<\/p>\n

SQL: SQL Error [ndoutils] : Table ‘.\/nagios\/nagios_servicestatus’ is marked as crashed and last (automatic?) repair failed SQL: SQL Error [ndoutils] : Table ‘.\/nagios\/nagios_servicestatus’ is marked as crashed and last (automatic?) repair failed SQL: SQL Error [ndoutils] : Table ‘.\/nagios\/nagios_servicestatus’ is marked as crashed and last (automatic?) repair failed<\/p>\n

\"SQL<\/p>\n

Solution:<\/strong> Run below commands and make sure that no one is configuring any hosts or services while executing the same.<\/p>\n

service mysqld stop
\n\/usr\/local\/nagiosxi\/scripts\/repairmysql.sh nagios
\nservice mysqld start<\/p>\n

After these 3 commands (restart of mysql), the SQL error moves out of the Nagios XI console.<\/p>\n

Nagios XI Solution for reference here<\/a><\/span>.<\/p>\n","protected":false},"excerpt":{"rendered":"

SQL Error in Nagios XI Console pops up strangley after configuring services for monitoring. This has happened frequently and after checking out Nagios XI library, there is resolution given by them for the same. Error message: SQL: SQL Error [ndoutils] : Table ‘.\/nagios\/nagios_servicestatus’ is marked as crashed and last (automatic?) repair failed SQL: SQL Error […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[153],"tags":[156,173,172],"class_list":["post-615","post","type-post","status-publish","format-standard","hentry","category-nagios","tag-nagios-xi","tag-ndoutils","tag-sql-error"],"_links":{"self":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/comments?post=615"}],"version-history":[{"count":2,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/615\/revisions"}],"predecessor-version":[{"id":644,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/615\/revisions\/644"}],"wp:attachment":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/media?parent=615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/categories?post=615"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/tags?post=615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}