Pandora FMS Community

"Can't connect to MySQL server" after improper shutdown

aeleus · 17 mar 2019, 18:44 · 22 mensajes · 110 visitas

  1. 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 116

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

    Greetings, 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.

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

  4. 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)

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

  6. 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.sql
    

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

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

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

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

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

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

  12. 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 mysql
    

    Kind regards,  Eduardo.

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

  14. 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 mysql
    

    or

    systemctl enable mysqld
    

    and then the command written in the previous post.  Kind regards,  Eduardo.

  15. [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

  16. [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.

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

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

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

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