Pandora FMS Community

Server Startup Failed After Software Upgrade

nabor · 20 ene 2019, 4:51 · 3 mensajes · 62 visitas

  1. Inicio del debate

    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.

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

    Good morning nabor, Have you installed the minor changes of the MySQL? To do this, please enter to MySQL and follow these steps: 1- Use pandora; 2- sourcer /var/www/html/pandora_console/extras/mr/X.sql, where X is 1 by 1 the package you must do in order ( 1,2,3...) After doing this steps try to start the server. Alberto

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

    Good morning nabor, Have you installed the minor changes of the MySQL? To do this, please enter to MySQL and follow these steps: 1- Use pandora; 2- sourcer /var/www/html/pandora_console/extras/mr/X.sql, where X is 1 by 1 the package you must do in order ( 1,2,3...) After doing this steps try to start the server. Alberto

    Hi Alberto,  Thank you, it's working now.

Entra en tu cuenta para publicar.