SQL Errors in Nagios

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
c.slagel
Posts: 57
Joined: Mon Dec 17, 2012 6:47 pm

SQL Errors in Nagios

Post by c.slagel »

Help. How do I resolve this:
Screen Shot 2013-11-14 at 11.55.01 AM.png
You do not have the required permissions to view the files attached to this post.
Top
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: SQL Errors in Nagios

Post by slansing »

Please run through:

http://assets.nagios.com/downloads/nagi ... tabase.pdf
Top
c.slagel
Posts: 57
Joined: Mon Dec 17, 2012 6:47 pm

Re: SQL Errors in Nagios

Post by c.slagel »

Trying to backup the database before running this and getting an error:

Code: Select all

Backing up MySQL databases...
mysqldump: Got error: 145: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!
Top
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: SQL Errors in Nagios

Post by abrist »

You have crashed tables. The backup will not work until the tables are fixed. Run the repair script.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Top
Locked

Return to “Nagios XI”