Hi, I installed FMS from the iso image recently and only has one agent created. Today, I found the server application was unable to boot after I upgraded the packages. Here's what I did: 1. Upgrade the web console from the web interface. 2. Upgrade the rpm packages from 7.0NG 714 to 7.0NG 730 followed by this order:
# rpm -U pandorafms_console-7.0NG.730-1.noarch.rpm
# rpm -U pandorafms_server-7.0NG.730-1.noarch.rpm
# rpm -U pandorafms_agent_unix-7.0NG.730-1.noarch.rpm
3. Upgrade system packages
# yum upgrade
4. Reboot the system. After that, the pandora server is no longer able to start. pandora_server.log
2019-01-20 13:41:03 magneto [V1] Launching 7.0NG.730 181217
2019-01-20 13:41:03 magneto [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 0, Server Threshold at 5 sec, verbosity at 3, Alert Threshold at 60, ServerName is 'magneto'
2019-01-20 13:41:03 magneto [V1] Pandora FMS Enterprise module not available.
2019-01-20 13:41:03 magneto [V1] Netflow daemon disabled.
2019-01-20 13:41:04 magneto [V1] [E] 'magneto': DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1135.
2019-01-20 13:41:04 magneto [V1] Pandora FMS Server 'magneto' unhandled error.
2019-01-20 13:41:04 magneto [V1] [E] 'magneto': 24 at /usr/lib/perl5/PandoraFMS/DB.pm line 1143.
2019-01-20 13:41:04 magneto [V1] Pandora FMS Server 'magneto' unhandled error.
2019-01-20 13:41:04 magneto [V3] Warmup mode for unknown modules started.
2019-01-20 13:41:04 magneto [V1] [E] 'magneto': DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1135.
2019-01-20 13:41:04 magneto [V1] Pandora FMS Server 'magneto' unhandled error.
2019-01-20 13:41:04 magneto [V1] [E] 'magneto': 24 at /usr/lib/perl5/PandoraFMS/DB.pm line 1143.
2019-01-20 13:41:04 magneto [V1] Pandora FMS Server 'magneto' unhandled error.
pandora_server.error
2019-01-20 13:49:59 - magneto Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 4877.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4352.
Use of uninitialized value in numeric gt (>) at /usr/lib/perl5/PandoraFMS/Core.pm line 4354.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1134.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1134.
24 at /usr/lib/perl5/PandoraFMS/DB.pm line 1142.
Perl exited with active threads:
13 running and unjoined
1 finished and unjoined
0 running and detached
The MySQL instance is up and running and I can connect it with the pandora user. The pandora_server.conf remains unmodified and I didn't update any MySQL password.
