Hello Guest

Author Topic: Database maintenance issue and all system down  (Read 69 times)

0 Members and 1 Guest are viewing this topic.

Offline ying7690

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
    • View Profile
Database maintenance issue and all system down
« on: April 12, 2017, 02:47:03 AM »
HI

I have update my Linux server recently, but it auto update the pandora too.
 
then my pandora show "all system: down" and database maintenance issue

Database maintenance issue.    
Your database is not maintained correctly. It seems that more than 48hrs have passed without proper maintenance. Please review Pandora FMS' documents on how to perform this maintenance process (pandora_db.pl) and enable it as soon as possible.

I dont know what it going on, i already restart the server, but still the same. is it got anyone can help?

Offline antonio.s

  • Administrator
  • Smart member
  • *****
  • Posts: 343
  • Karma: 5
    • View Profile
Re: Database maintenance issue and all system down
« Reply #1 on: April 17, 2017, 04:12:07 AM »
Hello ying7690,

First, make sure your pandorafms server is running:

Code: [Select]
service pandora_server status

Then, you can manually execute the pandora maintenance script and take a look at what it retrieves, the execution looks like this:

Code: [Select]
/usr/bin/perl /usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf

If the execution looks correct, check that it still exists on /etc/cron.hourly/pandora_db, if that's the case, you should have nothing to worry about.

Kind regards,
Antonio.