The Pandora server VM was shutdown improperly. Now, monitoring has stopped and pandora_server.log shows the following: 2019-03-17 08:30:46 pandora.domain.tld [V1] Launching 7.0NG.731 190130 2019-03-17 08:30:47 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-17 08:30:47 pandora.domain.tld [V1] - Pandora FMS Enterprise module not available.
2019-03-17 08:30:47 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 126. Here is the output of cat /etc/pandora/pandora_server.conf | grep db # dbengine: mysql dbengine mysql # dbname: Database name (pandora by default) dbname pandora # dbuser: Database user name (pandora by default) dbuser pandora # dbpass: Database password dbpass okhkscmr # dbhost: Database hostname or IP address dbhost 127.0.0.1 # dbport: Database port number # Default value depends on the dbengine (mysql: 3306) #dbport 3306 # the SNMP Enterprise Server when pandora_db is run. I can connect to MySQL in the console using this command: mysql -upandora -pokhkscmr pandora -h localhost I also tried rebooting and updating to Pandora 7.0NG.732 190227 - no change. Interestingly, I can start the server manually: /etc/init.d/pandora_server status Pandora FMS Server is not running. /etc/init.d/pandora_server start Pandora FMS Server 7.0NG.732 Build 190227 Copyright (c) 2004-2018 Artica ST This program is OpenSource, licensed under the terms of GPL License version 2. You can download latest versions and documentation at official web page.- Backgrounding Pandora FMS Server process.
Pandora FMS Server is now running with PID 4601 Monitoring seems to be working but there are a couple of errors in the console ((Link not available anymore)). The logo and menu along the top show this instead: SQL error: Table 'pandora.tnotification_source' doesn't exist ('SELECT * FROM `tnotification_source` WHERE `description` = 'System status' LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116 and SQL error: Table 'pandora.tnotification_user' doesn't exist ('SELECT * FROM (SELECT DISTINCT tm.*, utimestamp_read > 0 as "read" FROM tmensajes tm LEFT JOIN tnotification_user nu ON tm.id_mensaje=nu.id_mensaje AND nu.id_user="admin" LEFT JOIN (tnotification_group ng INNER JOIN tusuario_perfil up ON ng.id_group=up.id_grupo AND up.id_grupo=ng.id_group) ON tm.id_mensaje=ng.id_mensaje WHERE utimestamp_erased is null AND (nu.id_user="admin" OR up.id_usuario="admin" OR ng.id_group=0)) t where t.read is null ORDER BY timestamp DESC LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116
"Can't connect to MySQL server" after improper shutdown
aeleus · 17 mar 2019, 18:44 · 22 mensajes · 112 visitas
- Inicio del debate
The Pandora server VM was shutdown improperly. Now, monitoring has stopped and pandora_server.log shows the following: 2019-03-17 08:30:46 pandora.domain.tld [V1] Launching 7.0NG.731 190130 2019-03-17 08:30:47 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-17 08:30:47 pandora.domain.tld [V1] - Pandora FMS Enterprise module not available.
2019-03-17 08:30:47 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 126. Here is the output of cat /etc/pandora/pandora_server.conf | grep db # dbengine: mysql dbengine mysql # dbname: Database name (pandora by default) dbname pandora # dbuser: Database user name (pandora by default) dbuser pandora # dbpass: Database password dbpass okhkscmr # dbhost: Database hostname or IP address dbhost 127.0.0.1 # dbport: Database port number # Default value depends on the dbengine (mysql: 3306) #dbport 3306 # the SNMP Enterprise Server when pandora_db is run. I can connect to MySQL in the console using this command: mysql -upandora -pokhkscmr pandora -h localhost I also tried rebooting and updating to Pandora 7.0NG.732 190227 - no change. Interestingly, I can start the server manually: /etc/init.d/pandora_server status Pandora FMS Server is not running. /etc/init.d/pandora_server start Pandora FMS Server 7.0NG.732 Build 190227 Copyright (c) 2004-2018 Artica ST This program is OpenSource, licensed under the terms of GPL License version 2. You can download latest versions and documentation at official web page.- Backgrounding Pandora FMS Server process.
Pandora FMS Server is now running with PID 4601 Monitoring seems to be working but there are a couple of errors in the console ((Link not available anymore)). The logo and menu along the top show this instead: SQL error: Table 'pandora.tnotification_source' doesn't exist ('SELECT * FROM `tnotification_source` WHERE `description` = 'System status' LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116 and SQL error: Table 'pandora.tnotification_user' doesn't exist ('SELECT * FROM (SELECT DISTINCT tm.*, utimestamp_read > 0 as "read" FROM tmensajes tm LEFT JOIN tnotification_user nu ON tm.id_mensaje=nu.id_mensaje AND nu.id_user="admin" LEFT JOIN (tnotification_group ng INNER JOIN tusuario_perfil up ON ng.id_group=up.id_grupo AND up.id_grupo=ng.id_group) ON tm.id_mensaje=ng.id_mensaje WHERE utimestamp_erased is null AND (nu.id_user="admin" OR up.id_usuario="admin" OR ng.id_group=0)) t where t.read is null ORDER BY timestamp DESC LIMIT 1') in /var/www/html/pandora_console/include/db/mysql.php on line 116Greetings, aeleus The error displayed refers to a possible problem with the cache, please try to delete it and reload everything. Anyway, which MR do you have in your installation? Kind regards, Eduardo.
Eduardo, Thanks for the quick reply. Can you be more specific (or point me to instructions) on what you mean by "delete it and reload everything"? Also, what do you mean by "which MR"? Thanks
Eduardo, Thanks for the quick reply. Can you be more specific (or point me to instructions) on what you mean by "delete it and reload everything"? Also, what do you mean by "which MR"? Thanks
Good morning, aeleus I was referring to the cache. Just delete the cache and reload both your server and your browser to see any possible changes applied to the console. About the MR, you can see which version you have at the bottom of the console as you can see in the image attached. Kind regards, Eduardo.
[

](//pandorafms.com/community/media/forum/11186/28033=2748-MROpen.png)
Eduardo, Thanks for the quick reply. Can you be more specific (or point me to instructions) on what you mean by "delete it and reload everything"? Also, what do you mean by "which MR"? Thanks
Good morning, aeleus I was referring to the cache. Just delete the cache and reload both your server and your browser to see any possible changes applied to the console. About the MR, you can see which version you have at the bottom of the console as you can see in the image attached. Kind regards, Eduardo.
If you mean the browser cache, I've tried it from different browsers and from different computers. The problem persists. It also does not explain why Pandora will only start manually. The mobile version of the web page works fine. The MR is 24. Thanks.
Eduardo, Thanks for the quick reply. Can you be more specific (or point me to instructions) on what you mean by "delete it and reload everything"? Also, what do you mean by "which MR"? Thanks
Good morning, aeleus I was referring to the cache. Just delete the cache and reload both your server and your browser to see any possible changes applied to the console. About the MR, you can see which version you have at the bottom of the console as you can see in the image attached. Kind regards, Eduardo.
If you mean the browser cache, I've tried it from different browsers and from different computers. The problem persists. It also does not explain why Pandora will only start manually. The mobile version of the web page works fine. The MR is 24. Thanks.
Good morning, aeleus Pandora is actually running MR 25, please try to update it as it follows: First of all check if you have MR 25 in /var/www/html/pandora_console/extras/mr Then proceed to enter your database an execute the following commands (please do take extra care doing this, because Pandora's database is extremely important).
mysql > use pandora; mysql > source /var/www/html/pandora-console/extras/mr/13.sql mysql > source /var/www/html/pandora-console/extras/mr/14.sql mysql > source /var/www/html/pandora-console/extras/mr/15.sql [...] mysql > source /var/www/html/pandora-console/extras/mr/25.sqlKeep doing this until you reach MR 25. DO NOT skip any MR, you'll have to apply them in order. After this, you'll have to update the console footer token.
mysql > use pandora; mysql > update tconfig set value=25 where token='MR';Please be extra careful with this step. Let us know how this works. Best regards, Eduardo.
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.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.
Looks okay to me...(?) Here are the "db" settings in pandora_server.conf: dbengine mysql dbname pandora dbuser pandora dbpass okhkscmr dbhost 127.0.0.1 dbport 3306 Here is my config.php:
Looks okay to me...(?) Here are the "db" settings in pandora_server.conf: dbengine mysql dbname pandora dbuser pandora dbpass okhkscmr dbhost 127.0.0.1 dbport 3306 Here is my config.php:
Good afternoon, aeleus I see that the config.php file has been modified, so let's try to run some checkings reverting it to its default state:
Please try to run Pandora FMS with that configuration and let me know how it goes. Kind regards, Eduardo.
No luck. Same problem. :-( 2019-03-26 12:28:58 pandora.domain.tld [V1] Launching 7.0NG.732 190227 2019-03-26 12:28:58 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-26 12:28:58 pandora.domain.tld [V1]- Pandora FMS Enterprise module not available.
2019-03-26 12:28:59 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-26 12:28:59 pandora.domain.tld [V1] Server 'pandora.domain.tld' unhandled error.No luck. Same problem. :-( 2019-03-26 12:28:58 pandora.domain.tld [V1] Launching 7.0NG.732 190227 2019-03-26 12:28:58 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-26 12:28:58 pandora.domain.tld [V1] - Pandora FMS Enterprise module not available.
2019-03-26 12:28:59 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-26 12:28:59 pandora.domain.tld [V1] Server 'pandora.domain.tld' unhandled error.Good morning, aeleus Can you execute the following command and send us what you get, please?
systemctl list-unit-files | grep mysqlKind regards, Eduardo.
Interesting. I get nothing back. Here is the whole list: UNIT FILE STATE proc-sys-fs-binfmt_misc.automount static dev-hugepages.mount static dev-mqueue.mount static proc-sys-fs-binfmt_misc.mount static sys-fs-fuse-connections.mount static sys-kernel-config.mount static sys-kernel-debug.mount static tmp.mount disabled brandbot.path disabled systemd-ask-password-console.path static systemd-ask-password-plymouth.path static systemd-ask-password-wall.path static session-2.scope static session-22.scope static session-c1.scope static arp-ethers.service disabled auditd.service enabled [email protected] enabled blk-availability.service disabled brandbot.service static [email protected] static chrony-wait.service disabled chronyd.service enabled console-getty.service disabled console-shell.service disabled [email protected] static cpupower.service disabled crond.service enabled dbus-org.freedesktop.hostname1.service static dbus-org.freedesktop.import1.service static dbus-org.freedesktop.locale1.service static dbus-org.freedesktop.login1.service static dbus-org.freedesktop.machine1.service static dbus-org.freedesktop.NetworkManager.service enabled dbus-org.freedesktop.nm-dispatcher.service enabled dbus-org.freedesktop.timedate1.service static dbus.service static debug-shell.service disabled dm-event.service static dracut-cmdline.service static dracut-initqueue.service static dracut-mount.service static dracut-pre-mount.service static dracut-pre-pivot.service static dracut-pre-trigger.service static dracut-pre-udev.service static dracut-shutdown.service static ebtables.service disabled emergency.service static firewalld.service disabled fstrim.service static [email protected] enabled halt-local.service static htcacheclean.service static httpd.service disabled hypervfcopyd.service static hypervkvpd.service static hypervvssd.service static initrd-cleanup.service static initrd-parse-etc.service static initrd-switch-root.service static initrd-udevadm-cleanup-db.service static iprdump.service disabled iprinit.service disabled iprupdate.service disabled irqbalance.service enabled kdump.service enabled kmod-static-nodes.service static lvm2-lvmetad.service static lvm2-lvmpolld.service static lvm2-monitor.service enabled [email protected] static mariadb.service enabled messagebus.service static microcode.service enabled NetworkManager-dispatcher.service enabled NetworkManager-wait-online.service enabled NetworkManager.service enabled plymouth-halt.service disabled plymouth-kexec.service disabled plymouth-poweroff.service disabled plymouth-quit-wait.service disabled plymouth-quit.service disabled plymouth-read-write.service disabled plymouth-reboot.service disabled plymouth-start.service disabled plymouth-switch-root.service static polkit.service static postfix.service enabled quotaon.service static rc-local.service static rdisc.service disabled rescue.service static rhel-autorelabel-mark.service disabled rhel-autorelabel.service enabled rhel-configure.service enabled rhel-dmesg.service enabled rhel-domainname.service enabled rhel-import-state.service enabled rhel-loadmodules.service enabled rhel-readonly.service enabled rsyslog.service enabled [email protected] static [email protected] disabled snmpd.service disabled snmptrapd.service disabled sshd-keygen.service static sshd.service enabled [email protected] static systemd-ask-password-console.service static systemd-ask-password-plymouth.service static systemd-ask-password-wall.service static [email protected] static systemd-binfmt.service static systemd-bootchart.service disabled systemd-firstboot.service static systemd-fsck-root.service static [email protected] static systemd-halt.service static [email protected] static systemd-hibernate.service static systemd-hostnamed.service static systemd-hwdb-update.service static systemd-hybrid-sleep.service static systemd-importd.service static systemd-initctl.service static systemd-journal-catalog-update.service static systemd-journal-flush.service static systemd-journald.service static systemd-kexec.service static systemd-localed.service static systemd-logind.service static systemd-machine-id-commit.service static systemd-machined.service static systemd-modules-load.service static [email protected] disabled systemd-poweroff.service static systemd-quotacheck.service static systemd-random-seed.service static systemd-readahead-collect.service enabled systemd-readahead-done.service indirect systemd-readahead-drop.service enabled systemd-readahead-replay.service enabled systemd-reboot.service static systemd-remount-fs.service static [email protected] static systemd-shutdownd.service static systemd-suspend.service static systemd-sysctl.service static systemd-timedated.service static systemd-tmpfiles-clean.service static systemd-tmpfiles-setup-dev.service static systemd-tmpfiles-setup.service static systemd-udev-settle.service static systemd-udev-trigger.service static systemd-udevd.service static systemd-update-done.service static systemd-update-utmp-runlevel.service static systemd-update-utmp.service static systemd-user-sessions.service static systemd-vconsole-setup.service static [email protected] static tuned.service enabled wpa_supplicant.service disabled -.slice static machine.slice static system.slice static user-0.slice static user-1000.slice static user.slice static dbus.socket static dm-event.socket enabled lvm2-lvmetad.socket enabled lvm2-lvmpolld.socket enabled sshd.socket disabled syslog.socket static systemd-initctl.socket static systemd-journald.socket static systemd-shutdownd.socket static systemd-udevd-control.socket static systemd-udevd-kernel.socket static basic.target static bluetooth.target static cryptsetup-pre.target static cryptsetup.target static ctrl-alt-del.target disabled default.target enabled emergency.target static final.target static getty-pre.target static getty.target static graphical.target static halt.target disabled hibernate.target static hybrid-sleep.target static initrd-fs.target static initrd-root-fs.target static initrd-switch-root.target static initrd.target static iprutils.target disabled kexec.target disabled local-fs-pre.target static local-fs.target static machines.target disabled multi-user.target enabled network-online.target static network-pre.target static network.target static nss-lookup.target static nss-user-lookup.target static paths.target static poweroff.target disabled printer.target static reboot.target disabled remote-cryptsetup.target disabled remote-fs-pre.target static remote-fs.target enabled rescue.target disabled rpcbind.target static runlevel0.target disabled runlevel1.target disabled runlevel2.target enabled runlevel3.target enabled runlevel4.target enabled runlevel5.target static runlevel6.target disabled shutdown.target static sigpwr.target static sleep.target static slices.target static smartcard.target static sockets.target static sound.target static suspend.target static swap.target static sysinit.target static system-update.target static time-sync.target static timers.target static umount.target static [email protected] disabled fstrim.timer disabled systemd-readahead-done.timer indirect systemd-tmpfiles-clean.timer static 244 unit files listed.
Interesting. I get nothing back. Here is the whole list: UNIT FILE STATE proc-sys-fs-binfmt_misc.automount static dev-hugepages.mount static dev-mqueue.mount static proc-sys-fs-binfmt_misc.mount static sys-fs-fuse-connections.mount static sys-kernel-config.mount static sys-kernel-debug.mount static tmp.mount disabled brandbot.path disabled systemd-ask-password-console.path static systemd-ask-password-plymouth.path static systemd-ask-password-wall.path static session-2.scope static session-22.scope static session-c1.scope static arp-ethers.service disabled auditd.service enabled [email protected] enabled blk-availability.service disabled brandbot.service static [email protected] static chrony-wait.service disabled chronyd.service enabled console-getty.service disabled console-shell.service disabled [email protected] static cpupower.service disabled crond.service enabled dbus-org.freedesktop.hostname1.service static dbus-org.freedesktop.import1.service static dbus-org.freedesktop.locale1.service static dbus-org.freedesktop.login1.service static dbus-org.freedesktop.machine1.service static dbus-org.freedesktop.NetworkManager.service enabled dbus-org.freedesktop.nm-dispatcher.service enabled dbus-org.freedesktop.timedate1.service static dbus.service static debug-shell.service disabled dm-event.service static dracut-cmdline.service static dracut-initqueue.service static dracut-mount.service static dracut-pre-mount.service static dracut-pre-pivot.service static dracut-pre-trigger.service static dracut-pre-udev.service static dracut-shutdown.service static ebtables.service disabled emergency.service static firewalld.service disabled fstrim.service static [email protected] enabled halt-local.service static htcacheclean.service static httpd.service disabled hypervfcopyd.service static hypervkvpd.service static hypervvssd.service static initrd-cleanup.service static initrd-parse-etc.service static initrd-switch-root.service static initrd-udevadm-cleanup-db.service static iprdump.service disabled iprinit.service disabled iprupdate.service disabled irqbalance.service enabled kdump.service enabled kmod-static-nodes.service static lvm2-lvmetad.service static lvm2-lvmpolld.service static lvm2-monitor.service enabled [email protected] static mariadb.service enabled messagebus.service static microcode.service enabled NetworkManager-dispatcher.service enabled NetworkManager-wait-online.service enabled NetworkManager.service enabled plymouth-halt.service disabled plymouth-kexec.service disabled plymouth-poweroff.service disabled plymouth-quit-wait.service disabled plymouth-quit.service disabled plymouth-read-write.service disabled plymouth-reboot.service disabled plymouth-start.service disabled plymouth-switch-root.service static polkit.service static postfix.service enabled quotaon.service static rc-local.service static rdisc.service disabled rescue.service static rhel-autorelabel-mark.service disabled rhel-autorelabel.service enabled rhel-configure.service enabled rhel-dmesg.service enabled rhel-domainname.service enabled rhel-import-state.service enabled rhel-loadmodules.service enabled rhel-readonly.service enabled rsyslog.service enabled [email protected] static [email protected] disabled snmpd.service disabled snmptrapd.service disabled sshd-keygen.service static sshd.service enabled [email protected] static systemd-ask-password-console.service static systemd-ask-password-plymouth.service static systemd-ask-password-wall.service static [email protected] static systemd-binfmt.service static systemd-bootchart.service disabled systemd-firstboot.service static systemd-fsck-root.service static [email protected] static systemd-halt.service static [email protected] static systemd-hibernate.service static systemd-hostnamed.service static systemd-hwdb-update.service static systemd-hybrid-sleep.service static systemd-importd.service static systemd-initctl.service static systemd-journal-catalog-update.service static systemd-journal-flush.service static systemd-journald.service static systemd-kexec.service static systemd-localed.service static systemd-logind.service static systemd-machine-id-commit.service static systemd-machined.service static systemd-modules-load.service static [email protected] disabled systemd-poweroff.service static systemd-quotacheck.service static systemd-random-seed.service static systemd-readahead-collect.service enabled systemd-readahead-done.service indirect systemd-readahead-drop.service enabled systemd-readahead-replay.service enabled systemd-reboot.service static systemd-remount-fs.service static [email protected] static systemd-shutdownd.service static systemd-suspend.service static systemd-sysctl.service static systemd-timedated.service static systemd-tmpfiles-clean.service static systemd-tmpfiles-setup-dev.service static systemd-tmpfiles-setup.service static systemd-udev-settle.service static systemd-udev-trigger.service static systemd-udevd.service static systemd-update-done.service static systemd-update-utmp-runlevel.service static systemd-update-utmp.service static systemd-user-sessions.service static systemd-vconsole-setup.service static [email protected] static tuned.service enabled wpa_supplicant.service disabled -.slice static machine.slice static system.slice static user-0.slice static user-1000.slice static user.slice static dbus.socket static dm-event.socket enabled lvm2-lvmetad.socket enabled lvm2-lvmpolld.socket enabled sshd.socket disabled syslog.socket static systemd-initctl.socket static systemd-journald.socket static systemd-shutdownd.socket static systemd-udevd-control.socket static systemd-udevd-kernel.socket static basic.target static bluetooth.target static cryptsetup-pre.target static cryptsetup.target static ctrl-alt-del.target disabled default.target enabled emergency.target static final.target static getty-pre.target static getty.target static graphical.target static halt.target disabled hibernate.target static hybrid-sleep.target static initrd-fs.target static initrd-root-fs.target static initrd-switch-root.target static initrd.target static iprutils.target disabled kexec.target disabled local-fs-pre.target static local-fs.target static machines.target disabled multi-user.target enabled network-online.target static network-pre.target static network.target static nss-lookup.target static nss-user-lookup.target static paths.target static poweroff.target disabled printer.target static reboot.target disabled remote-cryptsetup.target disabled remote-fs-pre.target static remote-fs.target enabled rescue.target disabled rpcbind.target static runlevel0.target disabled runlevel1.target disabled runlevel2.target enabled runlevel3.target enabled runlevel4.target enabled runlevel5.target static runlevel6.target disabled shutdown.target static sigpwr.target static sleep.target static slices.target static smartcard.target static sockets.target static sound.target static suspend.target static swap.target static sysinit.target static system-update.target static time-sync.target static timers.target static umount.target static [email protected] disabled fstrim.timer disabled systemd-readahead-done.timer indirect systemd-tmpfiles-clean.timer static 244 unit files listed.
Good morning, aeleus Please execute
systemctl enable mysqlor
systemctl enable mysqldand then the command written in the previous post. Kind regards, Eduardo.
[root@pandora ~]# systemctl enable mysql Failed to execute operation: No such file or directory [root@pandora ~]# systemctl enable mysqld Failed to execute operation: No such file or directory [root@pandora ~]# systemctl list-unit-files | grep mysql [root@pandora ~]# I'm running MariaDB [root@pandora ~]# systemctl list-unit-files | grep maria mariadb.service enabled
[root@pandora ~]# systemctl enable mysql Failed to execute operation: No such file or directory [root@pandora ~]# systemctl enable mysqld Failed to execute operation: No such file or directory [root@pandora ~]# systemctl list-unit-files | grep mysql [root@pandora ~]# I'm running MariaDB [root@pandora ~]# systemctl list-unit-files | grep maria mariadb.service enabled
Greetings, aeleus The fact that you are running MariaDB changes everything a little bit. Can you tell us if you can find a "mariadb.service" in /etc/systemd/system? Please let us know too what numeric value has the pandora_server file found under /etc/rc3.d. It should appear as SXXpandora_server. Kind regards, Eduardo.
FYI, I installed MariaDB according the instructions here: https://wiki.pandorafms.com/index.php?title=Pandora:Documentation\_en:Installing It was working fine until that dirty shutdown. /etc/rc3.d/S90pandora_server [root@pandora ~]# ls /etc/systemd/system basic.target.wants default.target local-fs.target.wants sockets.target.wants dbus-org.freedesktop.NetworkManager.service default.target.wants multi-user.target.wants sysinit.target.wants dbus-org.freedesktop.nm-dispatcher.service getty.target.wants network-online.target.wants system-update.target.wants
FYI, I installed MariaDB according the instructions here: https://wiki.pandorafms.com/index.php?title=Pandora:Documentation\_en:Installing It was working fine until that dirty shutdown. /etc/rc3.d/S90pandora_server [root@pandora ~]# ls /etc/systemd/system basic.target.wants default.target local-fs.target.wants sockets.target.wants dbus-org.freedesktop.NetworkManager.service default.target.wants multi-user.target.wants sysinit.target.wants dbus-org.freedesktop.nm-dispatcher.service getty.target.wants network-online.target.wants system-update.target.wants
Good morning, aeleus Let's try to take advantage of the release of the latest version of Pandora FMS. Would it be possible for you to update your installation to version 733 (MR 26)? Keep us posted with anything you might need. Greetings, Eduardo.
Pandora has been running just fine for the last few months - except that I have to manually start it after a reboot. I never got that resolved. Today, I ran 'yum update' and updated from Pandora FMS v7.0NG.732 - Build PC190227 - MR 25 to Pandora FMS v7.0NG.736 - Build PC190627 - MR 25 The good news is that Pandora Server now starts automatically after a reboot. The bad news is that none of the agents work anymore. I am getting this in the pandora_server.log every 60 seconds: 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] wmic not found. Pandora FMS WMI Server needs a DCOM/WMI client. 2019-07-10 13:13:56 pandora.domain.tld [V1]- Netflow daemon disabled.
2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:57 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:57 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:57 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:57 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:14:01 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:14:01 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:14:02 pandora.domain.tld [V1] Pandora FMS Server restarting () in 60 seconds.
Update: I registered for Update Manager Online and updated to Pandora FMS v7.0NG.736 - Build 190708 - MR 1 Pandora is still generating the same errors.
Pandora has been running just fine for the last few months - except that I have to manually start it after a reboot. I never got that resolved. Today, I ran 'yum update' and updated from Pandora FMS v7.0NG.732 - Build PC190227 - MR 25 to Pandora FMS v7.0NG.736 - Build PC190627 - MR 25 The good news is that Pandora Server now starts automatically after a reboot. The bad news is that none of the agents work anymore. I am getting this in the pandora_server.log every 60 seconds: 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] wmic not found. Pandora FMS WMI Server needs a DCOM/WMI client. 2019-07-10 13:13:56 pandora.domain.tld [V1]- Netflow daemon disabled.
2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:56 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:56 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:57 pandora.domain.tld [V1] [E] 'pandora.domain.tld': DBD::mysql::db do failed: Unknown column 'ff_normal' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 1146. 2019-07-10 13:13:57 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:13:57 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:13:57 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:14:01 pandora.domain.tld [V1] [E] 'pandora.domain.tld': 21 at /usr/lib/perl5/PandoraFMS/DB.pm line 1154. 2019-07-10 13:14:01 pandora.domain.tld [V1] Pandora FMS Server 'pandora.domain.tld' unhandled error. 2019-07-10 13:14:02 pandora.domain.tld [V1] Pandora FMS Server restarting () in 60 seconds.
Update: I registered for Update Manager Online and updated to Pandora FMS v7.0NG.736 - Build 190708 - MR 1 Pandora is still generating the same errors.
Good morning Aeleus, If you only update your Pandora Server probably you'll get an error like that, so you should update your MR to the last version too. Kind regards, Jamal.
Entra en tu cuenta para publicar.

