Installing Zabbix with postgresql in CentOS6

Friend , recently I configured Zabbix with postgresql in my office infrastructure.

We have one zabbix master server (192.168.0.1) and one pgsql database server (192.168.0.2)

Below are the step that I performs on configuring zabbix.

Step 1) Download and install RPM’s for postgresql in database server (192.168.0.2)

[root@localhost ~]#wget http://yum.postgresql.org/9.1/redhat/rhel-6-x86_64/pgdg-redhat91-9.1-5.noarch.rpm

[root@localhost ~]#rpm -ivh pgdg-redhat91-9.1-5.noarch.rpm

[root@localhost ~]#yum install postgresql91-server postgresql91-contrib

[root@localhost ~]#/etc/init.d/postgresql-9.1 restart

[root@localhost ~]#service postgresql-9.1 initdb

Step 2) Configure Postgresql on (192.168.0.2)

[root@localhost ~]# su – postgres

-bash-4.1$ psql

postgres=# CREATE DATABASE zabbix WITH ENCODING='UTF-8';

postgres=# CREATE USER zabbix WITH PASSWORD 'zabbix';

postgres=# GRANT ALL ON DATABASE zabbix TO zabbix;

postgres=# GRANT ALL PRIVILEGES ON DATABASE zabbix to postgres;

postgres=# ALTER USER Postgres WITH PASSWORD 'redhat';

postgres=# \q

-bash-4.1$

-bash-4.1$ logout

[root@localhost ~]#vi /var/lib/pgsql/9.1/data/pg_hba.conf

****************

# "local" is for Unix domain socket connections only

local   all             all                                     md5

# IPv4 local connections:

host    all             all             127.0.0.1/32            md5

host    all             all             10.10.2.0/16            md5

******************

[root@localhost ~]#vi /var/lib/pgsql/9.1/data/ postgresql.conf

**************

listen_addresses = '192.168.0.2'         # what IP address(es) to listen on;

                                        # comma-separated list of addresses;

                                        # defaults to 'localhost', '*' = all

                                        # (change requires restart)

port = 5432    

**************

[root@localhost ~]#/etc/init.d/postgresql-9.1 restart

Step 3) Configure php.ini in Zabbix server (192.168.0.1)

[root@localhost ~]#yum -y install gcc net-snmp-devel curl-devel gcc make curl-devel httpd php php-pgsql php-bcmath php-gd php-mbstring net-snmp-devel fping e2fsprogs-devel zlib-devel libgssapi-devel krb5-devel openssl-devel libidn-devel iksemel-devel libXpm openssh-clients  php-xmlrpc sharutils OpenIPMI-devel libssh2-devel php-xml

[root@localhost ~]#vi /etc/php.ini

*******

max_execution_time = 300

memory_limit = 128M

post_max_size = 16M

upload_max_filesize = 2M

max_input_time = 300

date.timezone = Asia/Kolkata

*******

Step 4) Download and install zabbix from source code for zabbix frontend (192.168.0.1)

[root@localhost ~]#groupadd zabbix

[root@localhost ~]#useradd -g zabbix –s /sbin/nologin zabbix

[root@localhost ~]#wget http://sourceforge.net/projects/zabbix/files/ZABBIX%20Latest%20Stable/2.0.6/zabbix-2.0.6.tar.gz                                                                                                                                                       

[root@localhost ~]#mv zabbix-2.0.6.tar.gz /opt/;cd /opt

[root@localhost ~]#tar -xvzf /opt/zabbix-2.0.6.tar.gz

[root@localhost ]#cd zabbix-2.0.0.6

[root@localhost ]#./configure --prefix=/opt/zabbix --enable-server --enable-agent --with-net-snmp --with-postgresql=/usr/pgsql-9.1/bin/pg_config --with-ssh2 --with-openipmi --with-libcurl

[root@localhost ]#make;make install

Step 5) Configure frontend

[root@localhost ~]#cp -R /opt/zabbix-2.0.6/frontends/php /var/www/html/zabbix

[root@localhost ~]#Service httpd restart

Step 5) Configure zabbix config files (192.168.0.1)

[root@localhost ]#vi /opt/zabbix/etc/zabbix_server.conf

*********

ListenPort=10051

LogFile=/opt/zabbix/log/zabbix_server.log

 PidFile=/opt/zabbix/log/zabbix_server.pid

 DBHost=192.168.0.2

DBName=zabbix

DBUser=zabbix

 DBPassword=zabbix

 StartPollers=10

 DisableHousekeeping=1

 CacheSize=128M

 HistoryCacheSize=128M

 TrendCacheSize=64M

 HistoryTextCacheSize=128M

 Timeout=30

***********

[root@localhost ]#vi /opt/zabbix/etc/zabbix_agentd.conf

************

LogFile=/tmp/zabbix_agentd.log

Server=127.0.0.1

ServerActive=127.0.0.1

Hostname=Zabbix server

************

Step 6) Import zabbix database to postgresql server

[root@localhost ]#cd /opt/zabbix-2.0.6/database/postgresql

 [root@localhost ]#   psql -U zabbix -h 192.168.0.2 -d zabbix -f schema.sql

  [root@localhost ]#psql -U zabbix -h 192.168.0.2 -d zabbix -f images.sql

  [root@localhost ]#psql -U zabbix -h 192.168.0.2 -d zabbix -f data.sql

Step 7) Installing Zabbix through web

Go to web browser and type below link

http://192.168.0.1/zabbix

Download the config file and paste it to the location /var/www/html/zabbix/conf/zabbix.conf.php

Step 7) Copy init script for zabbix_server and zabbix_agentd

[root@localhost ]#cp /root/zabbix.2.0.6/misc/init.d/fedora/core/zabbix_server /etc/init.d/

[root@localhost ]#cp /root/zabbix.2.0.6/misc/init.d/fedora/core/zabbix_agentd /etc/init.d/

[root@localhost ]#vi /etc/init.d/ zabbix_server

**************

# Zabbix-Directory

        BASEDIR=/opt/zabbix

        # Binary File

        BINARY_NAME=zabbix_server

        # Full Binary File Call

        FULLPATH=$BASEDIR/sbin/$BINARY_NAME

        # PID file

        PIDFILE=/opt/zabbix/log/$BINARY_NAME.pid

******************

[root@localhost ]#vi /etc/init.d/ zabbix_agentd

***************** 

        # Zabbix-Directory

        BASEDIR=/opt/zabbix

        # Binary File

        BINARY_NAME=zabbix_agentd

        # Full Binary File Call

        FULLPATH=$BASEDIR/sbin/$BINARY_NAME

        # PID file

        PIDFILE=/tmp/$BINARY_NAME.pid

************

[root@localhost ]# service zabbix_server restart

[root@localhost ]# service zabbix_agentd restart

Now You have done your installation part. Try to login with credentials 

URL: http://192.168.0.1/zabbix

User: Admin

Password: zabbix