Pandora FMS Community

Field 'critical_instructions' doesn't have a default value

karel.krobath · 12 ago 2014, 13:13 · 2 mensajes · 51 visitas

  1. Inicio del debate

    Hi, I ran in to an error on a fresh new Pandora FMS 5.1 installation on an OpenSuse 13.1.

    # pandora_server -d /etc/pandora/pandora_server.conf
    
    Pandora FMS Server 5.1 Build 140701 Copyright (c) 2004-2014 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
    
      Pandora FMS Enterprise module not available.
      Netflow daemon disabled.
      Starting Pandora FMS Data Server.
      Starting Pandora FMS Network Server.
      Starting Pandora FMS Recon Server.
      Starting Pandora FMS WMI Server.
      Starting Pandora FMS Plugin Server.
     [E] Unhandled error in "s-web-vie-2". See more information in logfiles at '/var/log/pandora'
    
     Error description:
    
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    

    I followed the instructions from: http://wiki.pandorafms.com/index.php?title=Pandora:Documentation_en:Installing for Opensuse. I was able to install all the prerequisites successfully.

    # more /var/log/pandora/pandora_server.error
    2014-08-12 10:54:56 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 10:56:04 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 10:56:58 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 10:58:05 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 10:59:12 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:00:19 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:01:25 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:02:32 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:03:39 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:04:45 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:05:51 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:06:57 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:08:03 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:09:10 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    2014-08-12 11:10:16 - s-web-vie-2 Starting Pandora FMS Server. Error logging activated.
    DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
     more /var/log/pandora/pandora_server.log
    2014-08-12 10:54:56 s-web-vie-2 [V1] Launching 5.1 140701
    2014-08-12 10:54:56 s-web-vie-2 [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 1,
    Alert Threshold at 60, ServerName is 's-web-vie-2'
    2014-08-12 10:54:56 s-web-vie-2 [V1]   Pandora FMS Enterprise module not available.
    2014-08-12 10:54:57 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 10:55:02 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:55:02 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:55:03 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:55:03 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:55:04 s-web-vie-2 [V1] Pandora FMS Server restarting () in 60 seconds.
    2014-08-12 10:56:04 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 10:56:05 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:56:05 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:56:10 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:56:10 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:56:10 s-web-vie-2 [V1] Pandora FMS Server restarting () in 60 seconds.
    2014-08-12 10:56:53 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' Shutdown by signal
    2014-08-12 10:56:58 s-web-vie-2 [V1] Launching 5.1 140701
    2014-08-12 10:56:58 s-web-vie-2 [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 1,
    Alert Threshold at 60, ServerName is 's-web-vie-2'
    2014-08-12 10:56:58 s-web-vie-2 [V1]   Pandora FMS Enterprise module not available.
    2014-08-12 10:56:59 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 10:57:04 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:57:04 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:57:05 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:57:05 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:57:05 s-web-vie-2 [V1] Pandora FMS Server restarting () in 60 seconds.
    2014-08-12 10:58:05 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 10:58:06 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:58:06 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:58:11 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:58:11 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:58:11 s-web-vie-2 [V1] Pandora FMS Server restarting () in 60 seconds.
    2014-08-12 10:59:12 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 10:59:13 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:59:13 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:59:18 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 10:59:18 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 10:59:18 s-web-vie-2 [V1] Pandora FMS Server restarting () in 60 seconds.
    2014-08-12 11:00:19 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 11:00:20 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 11:00:20 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 11:00:25 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 11:00:25 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 11:00:25 s-web-vie-2 [V1] Pandora FMS Server restarting () in 60 seconds.
    2014-08-12 11:01:25 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 11:01:26 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 11:01:26 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 11:01:31 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 11:01:31 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 11:01:32 s-web-vie-2 [V1] Pandora FMS Server restarting () in 60 seconds.
    2014-08-12 11:02:32 s-web-vie-2 [V1]   Netflow daemon disabled.
    2014-08-12 11:02:33 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 11:02:33 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    2014-08-12 11:02:38 s-web-vie-2 [V1] [E] 's-web-vie-2': DBD::mysql::db do failed: Field 'critical_instructions' doesn't have a default value at /usr/lib/perl5/PandoraFMS/DB.pm line 646.
    
    2014-08-12 11:02:38 s-web-vie-2 [V1] Pandora FMS Server 's-web-vie-2' unhandled error.
    

    Any help is appreciated.

  2. hi, Try to get into mysql: mysql -u root -p pandora password: grant all privileges on pandora.* to pandora@localhost identified by 'password'; flush privileges;

Entra en tu cuenta para publicar.