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?title=Pandora:Documentation_en:Server_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 (c) 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
database maintnencence issue
fcrowd · 13 jun 2019, 13:18 · 4 mensajes · 69 visitas
- Inicio del debate
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?title=Pandora:Documentation_en:Server_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 (c) 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 SpencerHello 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:
cd /var/www/html/pandora_console/extras/MR for i in ´ls | sort -n;´ do mysql -u -p pandora -e "source $i"; doneTell us if it works for you. Regards.
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?title=Pandora:Documentation_en:Server_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 (c) 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 SpencerHello 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:
cd /var/www/html/pandora_console/extras/MR for i in ´ls | sort -n;´ do mysql -u -p pandora -e "source $i"; doneTell 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
[root@netmon-01 mr]# pwd /var/www/html/pandora_console/extras/mr [root@netmon-01 mr]# ls -l total 0 drwxr-xr-x 2 apache apache 19 Jun 11 12:01 updated [root@netmon-01 mr]# cd updated [root@netmon-01 updated]# ls -l total 4 -rw-r--r-- 1 apache apache 1992 Jun 11 12:01 1.sql [root@netmon-01 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
- No that did not work. there are no sql files in the MR folder. there is only 1.sql file in the updated folder
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.
Entra en tu cuenta para publicar.
