Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database maintenance issue and all system down
#1
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?
 Reply
#2
Hello ying7690,

First, make sure your pandorafms server is running:

Code:
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:
/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.
 Reply
#3
(04-17-2017, 11:12 AM)antonio.sanchez Wrote: Hello ying7690,

First, make sure your pandorafms server is running:

Code:
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:
/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


[[email protected] ~]# service pandora_server start

Pandora FMS Server 6.0SP5 Build 170120 Copyright © 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
[[email protected] ~]# 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_data

10:13:32 [PURGE] Deleting old session data from tsessions_php

DBD::mysql:Confusedt execute failed: Table 'pandora.tsessions_php' doesn't exist at /usr/lib/perl5/PandoraFMS/DB.pm line 720.
DBD::mysql:Confusedt execute failed: Table 'pandora.tsessions_php' doesn't exist at /usr/lib/perl5/PandoraFMS/DB.pm line 720.
[[email protected] ~]# service pandora_server status                               Pandora FMS Server is not running.
[[email protected] ~]#
 Reply
#4
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.
 Reply
#5
(05-03-2017, 08:44 AM)antonio Wrote: 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?tit...:Inventory

but i cannot found inventory module on my pandora v6sp5
i have attah my image .


Attached Files


.jpg   export.JPG (Size: 31.58 KB / Downloads: 4)
 Reply
#6
Hello ying7690,

As the documentation sais, inventory is only available on the Enterprise version.

Kind regards,
Antonio.
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes