Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

Welcome to Pandora FMS Community Forums Community support “Can’t connect to MySQL server” after improper shutdown “Can’t connect to MySQL server” after improper shutdown

  • eduardo-corral

    Member
    March 25, 2019 at 13:32
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Okay. The update to MR 25 fixed the web page issues. That’s all good now. Thank you.

    Pandora still won’t start automatically after a reboot though. I have to start it manually. Here is what I find in pandora_server.log

    After reboot:

    2019-03-23 13:50:49 pandora.domain.tld [V1] Launching 7.0NG.732 190227
    2019-03-23 13:50:49 pandora.domain.tld [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 ‘pandora.domain.tld’
    2019-03-23 13:50:49 pandora.domain.tld [V1] 

  •  Pandora FMS Enterprise module not available.
  • 2019-03-23 13:50:50 pandora.domain.tld [V1] [E] ‘pandora.domain.tld’: DBI connect(‘pandora:127.0.0.1:3306′,’pandora’,…) failed: Can’t connect to MySQL server on ‘127.0.0.1’ (111) at /usr/lib/perl5/PandoraFMS/DB.pm line 128.

    2019-03-23 13:50:50 pandora.domain.tld [V1]  Server ‘pandora.domain.tld’ unhandled error.

    After running /etc/init.d/pandora_server start:

    2019-03-23 13:51:38 pandora.domain.tld [V1] Launching 7.0NG.732 190227
    2019-03-23 13:51:38 pandora.domain.tld [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 ‘pandora.domain.tld’
    2019-03-23 13:51:38 pandora.domain.tld [V1] 

  •  Pandora FMS Enterprise module not available.
  • 2019-03-23 13:51:39 pandora.domain.tld [V1]  [E] wmic not found. Pandora FMS WMI Server needs a DCOM/WMI client.
    2019-03-23 13:51:39 pandora.domain.tld [V1] 

  • Netflow daemon disabled.
  • 2019-03-23 13:51:39 pandora.domain.tld [V3] Warmup mode for unknown modules started.
    2019-03-23 13:51:40 pandora.domain.tld [V1] Server pandora.domain.tld is the current master.

  • Greetings, aeleus

    Please do check that the parameters regarding the database in pandora_server.conf are the same as the ones found in config.php. 

    You can find both these files in: 

    /etc/pandora/pandora_server.conf

    /var/www/html/pandora_console/include/config.php

    You have to notice, though, that the host parameter in pandora_server.conf must be the IPv4 even though in the config.php file it appears under its name. 

    Regards, 

    Eduardo.