Zabbix Core Concern

[vnoc]

Hi Team,

I have recently tried to install zabbix with postgresql Database which i got struck in one of the part. Could you please help me in fixing this

Below is the error I am getting

The frontend does not match Zabbix database.

Below are the steps I followed.
1.To install and start Apache packages

# yum install httpd httpd-devel -y
# systemctl start httpd
# systemctl enable httpd

2.To install and start postgreSQL packages

# yum install https://download.postgresql.org/pub/...5-2.noarch.rpm
# yum install postgresql95-server postgresql95-contrib

To Create the database cluster:

# /usr/pgsql-9.5/bin/postgresql95-setup initdb
# systemctl start postgresql-9.5
# systemctl enable postgresql-9.5

Adjust the pg_hba.conf, allowing local access without password, replacing:
# vi /etc/postgresql/9.5/main/pg_hba.conf
# “local” is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust

To Create the database and user zabbix:

# psql -U postgres

CREATE USER zabbix;
ALTER USER “zabbix” WITH PASSWORD ‘new_password’;
CREATE DATABASE zabbix OWNER zabbix;
\q



3.To install php packages

#yum install php php-cli php-common php-devel php-pear php-gd php-mbstring php-mysql php-xml

# vi /etc/php.ini
date.timezone = “Asia/Kolkata”

# /etc/init.d/httpd restart



4.To install YUM repository for zabbix

# yum install http://repo.zabbix.com/zabbix/3.0/rh...el7.noarch.rpm

5.To Install Zabbix Server with MySQL

# yum install zabbix-server-pgsql zabbix-web-pgsql zabbix-agent zabbix-get

6.To Create Zabbix postgresSQL Database

# cd /usr/share/doc/zabbix-server-pgsql-3.0.4/
# zcat create.sql.gz | psql -U zabbix -d zabbix

7.Setup Zabbix Apache Configuration

# vi /etc/httpd/conf.d/zabbix.conf
php_value date.timezone Asia/Kolkata

# systemctl restart httpd

8. Adjust the /etc/zabbix/zabbix_server.conf, adding:

DBUser=zabbix
DBPort=5432
DBHost=localhost
DBPassword = Password

8.To Start Zabbix Server & Agent

# systemctl restart zabbix-server
# systemctl enable zabbix-server

# systemctl restart zabbix-agent
# systemctl enable zabbix-agent

9. https://IP_Address/zabbix or https://hostname/zabbix

[vnoc]

Hi Team ,

The raised concern is fixed . You can close this thread