Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20776

zabbix setup will not complete with remote postgres 14 db unless selinux is disabled on zabbix 6 server

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Won't fix
    • 6.0.2
    • 6.2 (plan)
    • Installation (I)
    • OS = Red Hat Enterprise Linux 8.5
      selinux was enabled
      Zabbix server 6.0.2 with Apache on Virtual Machine 1
      Postgres 14.1 on Virtual Machine 2
    • 3

    Description

      Steps to reproduce:

      1. Follow instructions from postgres to install postgresql on VM1 using postgres repo
      2. Follow instructions from zabbix.com to install zabbix 6.0.2 (install postgres client from postgres repo) on VM2
      3. I verified that VM1 could log into postgres server on VM2 using command as follows ```psql -h postgres3-vis.rtp.raleigh.ibm.com -d zabbix -U zabbix -W``` where -h i have my hostname
      4. I made the connection setting in postgres config files to ensure issue was not a postgress config in this file ```/var/lib/pgsql/14/data/pg_hba.conf``` I made this entry
      5. ```  host    all             all             0.0.0.0/0          scram-sha-256 ```   In ```/var/lib/pgsql/14/data/postgresql.conf``` I have this entry ```listen_addresses = '*' ```
      6. I made sure   /etc/zabbix/zabbix_server.conf had correct parameters for DBPassword, DBHost, DBUser, DBPassword etc.
      7. it is impossible to get passed the database configuration on the UI, in my case http://zabbix3-vis.rtp.raleigh.ibm.com/zabbix/setup.php unless I disabled selinux on Zabbix host.  All other install steps worked fine.  
      8. /var/log/zabbix/zabbix_server.conf gave no indication as to why and postgres log files show absolutely nothing /var/lib/pgsql/14/data/log/postgresql-Tue.log

      Result:
      The only way to get past this issue was to run  these command on the zabbix host

      ```
      sestatus
      sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
      setenforce 0
      sestatus
      setenforce 0
      ```

      See log file...
      See memory dump...
      Expected:
      See screenshot....
      See attached patch file...

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            strouja James G Stroud
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: