Ad Widget

Collapse

Zabbix frontend shows database error but server logs looks normal

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • bumpyd
    Junior Member
    • Sep 2020
    • 2
    #1

    Zabbix frontend shows database error but server logs looks normal

    Hello,

    I have just upgraded my zabbix from 3.0 to 4.0 (new machine with CentOS 8).

    I restored the dump, did the utf-8 conversion, all looks well after all the work - except the webpage shows the following:

    Database error
    • Error connecting to database: Access denied for user 'zabbix'@'localhost' (using password: YES)
    I expected to see some error from zabbix_server.log, but I don't see any:

    1511:20201001:001132.761 Starting Zabbix Server. Zabbix 4.0.25 (revision 32662425e6).
    1511:20201001:001132.834 ****** Enabled features ******
    1511:20201001:001132.834 SNMP monitoring: YES
    1511:20201001:001132.834 IPMI monitoring: YES
    1511:20201001:001132.834 Web monitoring: YES
    1511:20201001:001132.834 VMware monitoring: YES
    1511:20201001:001132.834 SMTP authentication: YES
    1511:20201001:001132.834 Jabber notifications: NO
    1511:20201001:001132.834 Ez Texting notifications: YES
    1511:20201001:001132.834 ODBC: YES
    1511:20201001:001132.834 SSH support: YES
    1511:20201001:001132.834 IPv6 support: YES
    1511:20201001:001132.834 TLS support: YES
    1511:20201001:001132.834 ******************************
    1511:20201001:001132.834 using configuration file: /etc/zabbix/zabbix_server.conf
    1511:20201001:001135.345 current database version (mandatory/optional): 04000000/04000006
    1511:20201001:001135.345 required mandatory version: 04000000
    1511:20201001:001136.099 server #0 started [main process]
    1658:20201001:001136.100 server #1 started [configuration syncer #1]
    1662:20201001:001137.506 server #5 started [discoverer #1]
    1663:20201001:001137.506 server #6 started [history syncer #1]
    1665:20201001:001137.508 server #8 started [history syncer #3]
    1666:20201001:001137.509 server #9 started [history syncer #4]
    1672:20201001:001137.512 server #13 started [task manager #1]
    1689:20201001:001137.556 server #30 started [preprocessing manager #1]
    1673:20201001:001137.556 server #14 started [poller #1]
    1690:20201001:001137.557 server #31 started [preprocessing worker #1]
    1691:20201001:001137.557 server #32 started [preprocessing worker #2]
    1675:20201001:001137.557 server #16 started [poller #3]
    1676:20201001:001137.557 server #17 started [poller #4]
    1668:20201001:001137.558 server #10 started [escalator #1]
    1671:20201001:001137.558 server #12 started [self-monitoring #1]
    1659:20201001:001137.558 server #2 started [housekeeper #1]
    1660:20201001:001137.558 server #3 started [timer #1]
    1661:20201001:001137.559 server #4 started [http poller #1]
    1680:20201001:001137.559 server #21 started [trapper #2]
    1681:20201001:001137.562 server #22 started [trapper #3]
    1682:20201001:001137.564 server #23 started [trapper #4]
    1683:20201001:001137.566 server #24 started [trapper #5]
    1684:20201001:001137.568 server #25 started [icmp pinger #1]
    1685:20201001:001137.568 server #26 started [alert manager #1]
    1686:20201001:001137.569 server #27 started [alerter #1]
    1687:20201001:001137.569 server #28 started [alerter #2]
    1688:20201001:001137.569 server #29 started [alerter #3]
    1664:20201001:001137.569 server #7 started [history syncer #2]
    1679:20201001:001137.570 server #20 started [trapper #1]
    1674:20201001:001137.572 server #15 started [poller #2]
    1677:20201001:001137.572 server #18 started [poller #5]
    1692:20201001:001137.572 server #33 started [preprocessing worker #3]
    1678:20201001:001137.572 server #19 started [unreachable poller #1]
    1670:20201001:001137.573 server #11 started [proxy poller #1]
    1664:20201001:001204.806 item "Google DNS:icmppingsec" became supported

    ...followed by a bunch of "became supported" messages.

    Am I missing something here? Please let me know if I should provide other information.

    Thanks!
    Tags: None
    • tim.mooney
      Senior Member
      • Dec 2012
      • 1427
      #2
      The web front end has its own configuration file, including parameters for how to connect to the database. Look in the zabbix/conf/zabbix.conf.php file in your web front-end install and make sure the parameters in that file are correct.

      The zabbix_server process can function (gathering data for items, evaluating triggers to determine if there's a problem, performing actions to alert or remedy the problem) independently from the web interface.

        Comment

        • bumpyd
          Junior Member
          • Sep 2020
          • 2
          #3
          Originally posted by tim.mooney
          The web front end has its own configuration file, including parameters for how to connect to the database. Look in the zabbix/conf/zabbix.conf.php file in your web front-end install and make sure the parameters in that file are correct.

          The zabbix_server process can function (gathering data for items, evaluating triggers to determine if there's a problem, performing actions to alert or remedy the problem) independently from the web interface.
          Many thanks good sir! Looks like there was a password mismatch in zabbix/conf/zabbix.conf.php
          I was looking for zabbix.conf.php under /var/www/html/ to no avail, but turns out its in /etc/zabbix/web/zabbix.conf.php

            Comment

            Previous template Next
            Working...