Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
database maintnencence issue
#1
Hello,

We have installed PandoraFMS image 7.0NG.734 and have upgraded to 7.0NG.735 build 190610 MR1

After a few days we get the database maintenance warning on the console. So we follow this article:

https://pandorafms.com/docs/index.php?ti...Management

to carry out the maintenance.  When we run this command 

/usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf

we get this error:
=============================================

DB Tool 7.0NG.735 PS190530 Copyright © 2004-2018 Artica ST
This program is Free Software, licensed under the terms of GPL License v2
You can download latest versions and documentation at official web

DB Tool now initialized and running (PURGE=45 days, COMPACT=0 days, STEP=1) . 

 
[*] Pandora FMS Enterprise module not available.

Starting at 2019-06-13 10:08:13
10:08:13 [PURGE] No data to purge in tagente_datos.
10:08:13 [PURGE] Deleting old export data from tserver_export_data

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

10:08:13 [PURGE] No data in tagente_datos_log4x.
10:08:13 [PURGE] No data in tagente_datos_string.
10:08:13 [PURGE] Deleting old event data at tevento table (More than 7 days)..
10:08:13 [PURGE] Deleting old audit data (More than 15 days).
10:08:13 [PURGE] Deleting old SNMP traps (More than 7 days).
10:08:13 [PURGE] Deleting old GIS data (More than 7 days).
10:08:13 [PURGE] Deleting pending delete modules (data table).
10:08:13 [PURGE] Deleting pending delete modules (status, module table).
10:08:13 [PURGE] Deleting old access data (More than 24hr)
10:08:13 [PURGE] No agent access data to purge.
10:08:13 [PURGE] Delete contents in report that have some deleted modules.
10:08:13 [PURGE] Delete contents in report that have some deleted agents.
10:08:13 [PURGE] Delete empty contents in report (like SLA or Exception).
10:08:13 [PURGE] Delete autodisabled agents where last contact is bigger than 30 days.
10:08:13 [PURGE] Deleting old netflow data.
10:08:13 [PURGE] Deleting old log data.
10:08:13 [!] Log collection disabled.
10:08:13 [PURGE] Deleting old special days.
10:08:13 [PURGE] Deleting old network matrix data.
10:08:13 [PURGE] Deleting old messages.
10:08:13 [PURGE] Deleting old cache data.
DBD::mysql::db do failed: Table 'pandora.tvisual_console_elements_cache' doesn't exist at /usr/lib/perl5/PandoraFMS/DB.pm line 1146.
2 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154.

===============================================

How do we fix this?

Kind regards


Spencer
 Reply
#2
(06-13-2019, 09:18 AM)fcrowd Wrote: Hello,

We have installed PandoraFMS image 7.0NG.734 and have upgraded to 7.0NG.735 build 190610 MR1

After a few days we get the database maintenance warning on the console. So we follow this article:

https://pandorafms.com/docs/index.php?ti...Management

to carry out the maintenance.  When we run this command 

/usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf

we get this error:
=============================================

DB Tool 7.0NG.735 PS190530 Copyright © 2004-2018 Artica ST
This program is Free Software, licensed under the terms of GPL License v2
You can download latest versions and documentation at official web

DB Tool now initialized and running (PURGE=45 days, COMPACT=0 days, STEP=1) . 

 
[*] Pandora FMS Enterprise module not available.

Starting at 2019-06-13 10:08:13
10:08:13 [PURGE] No data to purge in tagente_datos.
10:08:13 [PURGE] Deleting old export data from tserver_export_data

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

10:08:13 [PURGE] No data in tagente_datos_log4x.
10:08:13 [PURGE] No data in tagente_datos_string.
10:08:13 [PURGE] Deleting old event data at tevento table (More than 7 days)..
10:08:13 [PURGE] Deleting old audit data (More than 15 days).
10:08:13 [PURGE] Deleting old SNMP traps (More than 7 days).
10:08:13 [PURGE] Deleting old GIS data (More than 7 days).
10:08:13 [PURGE] Deleting pending delete modules (data table).
10:08:13 [PURGE] Deleting pending delete modules (status, module table).
10:08:13 [PURGE] Deleting old access data (More than 24hr)
10:08:13 [PURGE] No agent access data to purge.
10:08:13 [PURGE] Delete contents in report that have some deleted modules.
10:08:13 [PURGE] Delete contents in report that have some deleted agents.
10:08:13 [PURGE] Delete empty contents in report (like SLA or Exception).
10:08:13 [PURGE] Delete autodisabled agents where last contact is bigger than 30 days.
10:08:13 [PURGE] Deleting old netflow data.
10:08:13 [PURGE] Deleting old log data.
10:08:13 [!] Log collection disabled.
10:08:13 [PURGE] Deleting old special days.
10:08:13 [PURGE] Deleting old network matrix data.
10:08:13 [PURGE] Deleting old messages.
10:08:13 [PURGE] Deleting old cache data.
DBD::mysql::db do failed: Table 'pandora.tvisual_console_elements_cache' doesn't exist at /usr/lib/perl5/PandoraFMS/DB.pm line 1146.
2 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154.

===============================================

How do we fix this?

Kind regards


Spencer
[*]

Hello fcrowd,

As I can see in your post, you have your MR outdated. Pandora FMS is currently working with MR 28. To update your MR execute the following commands: 

Code:
Code:
cd /var/www/html/pandora_console/extras/MR
for i in ´ls | sort -n;´ do mysql -u <usuario msql> -p<pasword mysql> pandora -e "source $i"; done
[*]

Tell us if it works for you.

Regards.
 Reply
#3
(06-13-2019, 10:40 AM)jose.almendros Wrote:
(06-13-2019, 09:18 AM)fcrowd Wrote: Hello,

We have installed PandoraFMS image 7.0NG.734 and have upgraded to 7.0NG.735 build 190610 MR1

After a few days we get the database maintenance warning on the console. So we follow this article:

https://pandorafms.com/docs/index.php?ti...Management

to carry out the maintenance.  When we run this command 

/usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf

we get this error:
=============================================

DB Tool 7.0NG.735 PS190530 Copyright © 2004-2018 Artica ST
This program is Free Software, licensed under the terms of GPL License v2
You can download latest versions and documentation at official web

DB Tool now initialized and running (PURGE=45 days, COMPACT=0 days, STEP=1) . 

 
[*] Pandora FMS Enterprise module not available.

Starting at 2019-06-13 10:08:13
10:08:13 [PURGE] No data to purge in tagente_datos.
10:08:13 [PURGE] Deleting old export data from tserver_export_data

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

10:08:13 [PURGE] No data in tagente_datos_log4x.
10:08:13 [PURGE] No data in tagente_datos_string.
10:08:13 [PURGE] Deleting old event data at tevento table (More than 7 days)..
10:08:13 [PURGE] Deleting old audit data (More than 15 days).
10:08:13 [PURGE] Deleting old SNMP traps (More than 7 days).
10:08:13 [PURGE] Deleting old GIS data (More than 7 days).
10:08:13 [PURGE] Deleting pending delete modules (data table).
10:08:13 [PURGE] Deleting pending delete modules (status, module table).
10:08:13 [PURGE] Deleting old access data (More than 24hr)
10:08:13 [PURGE] No agent access data to purge.
10:08:13 [PURGE] Delete contents in report that have some deleted modules.
10:08:13 [PURGE] Delete contents in report that have some deleted agents.
10:08:13 [PURGE] Delete empty contents in report (like SLA or Exception).
10:08:13 [PURGE] Delete autodisabled agents where last contact is bigger than 30 days.
10:08:13 [PURGE] Deleting old netflow data.
10:08:13 [PURGE] Deleting old log data.
10:08:13 [!] Log collection disabled.
10:08:13 [PURGE] Deleting old special days.
10:08:13 [PURGE] Deleting old network matrix data.
10:08:13 [PURGE] Deleting old messages.
10:08:13 [PURGE] Deleting old cache data.
DBD::mysql::db do failed: Table 'pandora.tvisual_console_elements_cache' doesn't exist at /usr/lib/perl5/PandoraFMS/DB.pm line 1146.
2 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154.

===============================================

How do we fix this?

Kind regards


Spencer
[*]

Hello fcrowd,

As I can see in your post, you have your MR outdated. Pandora FMS is currently working with MR 28. To update your MR execute the following commands: 

Code:
Code:
cd /var/www/html/pandora_console/extras/MR
for i in ´ls | sort -n;´ do mysql -u <usuario msql> -p<pasword mysql> pandora -e "source $i"; done


[*]

Tell us if it works for you.

Regards.


[*]Hello Jose

[*]No that did not work.  there are no sql files in the MR folder.  there is only 1.sql file in the updated folder

[[email protected] mr]# pwd
/var/www/html/pandora_console/extras/mr
[[email protected] mr]# ls -l
total 0
drwxr-xr-x 2 apache apache 19 Jun 11 12:01 updated
[[email protected] mr]# cd updated
[[email protected] updated]# ls -l
total 4
-rw-r--r-- 1 apache apache 1992 Jun 11 12:01 1.sql
[[email protected] updated]# 


This matches the updated version we see from the console:  Pandora FMS v7.0NG.735 - Build 190610 - MR 1

What should we try next?

regards
Spencer
 Reply
#4
Hello fcrowd,

It is weird that you don't have any sql file in mr folder or update.

Try to execute pandora_migrate_6.0 to 7.0 sql located in /var/www/html/pandora_console/extras folder in your database, it should create the missing tables anyway.

Regards.
 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