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