-
Database maintenance issue and all system down
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?
-
5 Replies
-
Hello ying7690,
First, make sure your pandorafms server is running:
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:
/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. -
Hello ying7690,
First, make sure your pandorafms server is running:
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:
/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.HI Antonio,Â
i failed to enable the pandora service , and it prompt the error while i delete the old data
[root@localhost ~]# service pandora_server start
Pandora FMS Server 6.0SP5 Build 170120 Copyright (c) 2004-2015 ArticaST
This program is OpenSource, licensed under the terms of GPL License version 2.
You can download latest versions and documentation at http://www.pandorafms.orgÂ
- Backgrounding Pandora FMS Server process.
Pandora Server is now running with PID 8417
[root@localhost ~]# service pandora_server status
Pandora FMS Server is not running.Starting at 2017-05-03 10:12:37
10:13:32 [PURGE] Deleting old data from tagente_datos. 100%
10:13:32 [PURGE] Deleting old export data from tserver_export_data10:13:32 [PURGE] Deleting old session data from tsessions_php
DBD::mysql::st execute failed: Table ‘pandora.tsessions_php’ doesn’t exist at /usr/lib/perl5/PandoraFMS/DB.pm line 720.
DBD::mysql::st execute failed: Table ‘pandora.tsessions_php’ doesn’t exist at /usr/lib/perl5/PandoraFMS/DB.pm line 720.
[root@localhost ~]# service pandora_server status                Pandora FMS Server is not running.
[root@localhost ~]# -
Hello ying7690,
If you have accidentally upgraded your Pandora console from v5 to v6, the problem may be that you have not migrated your database, so you get database errors here and there.
Follow this quickguide about the migration from v5 to v6, pay attention to the database migration steps to make sure you get your database properly updated.Â
Also, before following the guide, make sure to make a backup of your database just in case.
Kind regards,
Antonio. -
Hello ying7690,
If you have accidentally upgraded your Pandora console from v5 to v6, the problem may be that you have not migrated your database, so you get database errors here and there.
Follow this quickguide about the migration from v5 to v6, pay attention to the database migration steps to make sure you get your database properly updated.Â
Also, before following the guide, make sure to make a backup of your database just in case.
Kind regards,
Antonio.HI Antonio,Â
I will re-install the v7, may i know how to export the agent.Â
i have check the Administrator guideline by refering the URL below
http://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Inventorybut i cannot found inventory module on my pandora v6sp5
i have attah my image .
-
