Zabbix4.0 for PostgreSQL (上篇)：基础环境的搭建部署
概述
Zabbix大家都很熟悉，一般的是使用MySQL作为存储库来使用的，而我看使用手册上是使用postgresql也是可以的，所以就做了一次基于pg的zabbix搭建测试，记录下来，分享给大家
Server端配置
配置PG环境
安装好pg，且在root和postgres下都配置好pg的环境变量，以供后续使用
在hba控制文件中直接加入这一行
host zabbix zabbix 192.168.0.0/24 trust
host all all 127.0.0.1/32 md5配置apache
创建user
[root@Zabbix_GW_TEST opt]# adduser apache准备好安装包并解压
[root@Zabbix_GW_TEST opt]# ls httpd-2.4.37.tar.gz
httpd-2.4.37.tar.gz
[root@Zabbix_GW_TEST opt]# tar -xvzf httpd-2.4.37.tar.gz 编译安装
执行编译命令
[root@Zabbix_GW_TEST httpd-2.4.37]# ./configure --prefix=/usr/local/apache --enable-rewrite --enable-deflate --enable-expires --enable-headers --enable-modules=most --with-mpm=worker --enable-so报错：
configure: error: APR not found. Please read the documentation.解决：
yum install apr
yum install apr-util-devel报错：
configure: error: in `/opt/httpd-2.4.37':
configure: error: C compiler cannot create executables
See `config.log' for more details解决：
yum install gcc问题：
configure: error: pcre-config for libpcre not found. PCRE is required and available from http://pcre.org/解决：
yum -y install pcre-devel问题：
configure: error: mod_deflate has been requested but can not be built due to prerequisite failures解决：
yum install -y zlib-devel以下画面说明编译成功
configure: summary of build options:
Server Version: 2.4.37
Install prefix: /usr/local/apache
C compiler: gcc -std=gnu99
CFLAGS: -pthread
CPPFLAGS: -DLINUX -D_REENTRANT -D_GNU_SOURCE
LDFLAGS:
LIBS:
C preprocessor: gcc -E继续安装
gmake
gmake install安装成功之后安装目录也就生成文件了
[root@Zabbix_GW_TEST apache]# ls
bin build cgi-bin conf error htdocs icons include logs man manual modules建立脚本根目录
用来存放html信息
mkdir /home/www
chown -R apache:apache /home/www配置运行参数
[root@nfs httpd-2.2.31]# vim /usr/local/apache/conf/httpd.conf
#监听port
Listen 80
#运营apache服务的用户及用户组，为apache
User apache
Group apache
#管理员的邮箱是
ServerAdmin 1058582934@qq.com
#配置脚本根目录
DocumentRoot "/home/www"
#配置
ServerName 127.0.0.1:80
<Directory />
Options FollowSymLinks
AllowOverride None
Order deny,allow
allow from all
</Directory>
<Directory "/home/www">
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>配置环境变量
添加一行环境变量到文件中
export PATH=/usr/local/apache/bin:$PATH
[root@Zabbix_GW_TEST apache]# source ~/.bash_profile
[root@Zabbix_GW_TEST apache]# which apachectl
/usr/local/apache/bin/apachectl
启动apache服务
apachectl start顺便配置开机自动
vim /etc/rc.d/rc.local
/usr/local/apache/bin/apachectl start至此，Apache配置完成
安装配置php
安装php依赖包
wget http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.14.tar.gz
tar zxf libiconv-1.14.tar.gz
./configure --prefix=/usr/local/libiconv
make
make install准备好包并解压
tar -xvzf php-5.5.38.tar.gz编译
./configure --prefix=/usr/local/php --with-apxs2=/usr/local/apache/bin/apxs --with-xmlrpc --with-openssl --with-zlib --with-freetype-dir --with-gd --with-jpeg-dir --with-png-dir --with-iconv=/usr/local/libiconv --enable-short-tags --enable-sockets --enable-soap --enable-mbstring --enable-static --enable-gd-native-ttf --with-curl --with-xsl --enable-ftp --with-libxml-dir --with-pgsql=/usr/postgresql --enable-fpm --enable-bcmath --with-gettext报错
Sorry, I cannot run apxs. Possible reasons follow:
1. Perl is not installed
2. apxs was not found. Try to pass the path using --with-apxs2=/path/to/apxs
3. Apache was not built using --enable-so (the apxs usage page is displayed)
The output of /usr/local/apache/bin/apxs follows:
./configure: /usr/local/apache/bin/apxs: /replace/with/path/to/perl/interpreter: bad interpreter: No such file or directory
configure: error: Aborting解决：将apache的bin文件下的apxs文件第一行改为
#!/usr/bin/perl -w报错：
configure: error: xml2-config not found. Please check your libxml2 installation
yum install libxml2-devel报错
configure: error: Cannot find OpenSSL's <evp.h>
yum install openssl openssl-devel报错
configure: error: Please reinstall the libcurl distribution -
easy.h should be in <curl-dir>/include/curl/
yum install curl curl-devel报错
configure: error: There is something wrong. Please check config.log for more information.
curl-devel-7.15.5-2.el5安装报错
configure: error: jpeglib.h not found.
yum -y install libjpeg-devel报错
configure: error: png.h not found.
yum install libpng libpng-devel报错：
configure: error: freetype-config not found.
yum install freetype-devel报错
configure: error: xslt-config not found. Please reinstall the libxslt >= 1.1.0 distribution
yum -y install libxslt libxslt-devel显示如下，则编译完成
creating main/internal_functions_cli.c
+--------------------------------------------------------------------+
| License: |
| This software is subject to the PHP License, available in this |
| distribution in the file LICENSE. By continuing this installation |
| process, you are bound by the terms of this license agreement. |
| If you do not agree with the terms of this license, you must abort |
| the installation process at this point. |
+--------------------------------------------------------------------+
Thank you for using PHP.
config.status: creating php5.spec
config.status: creating main/build-defs.h
config.status: creating scripts/phpize
config.status: creating scripts/man1/phpize.1
config.status: creating scripts/php-config
config.status: creating scripts/man1/php-config.1
config.status: creating sapi/cli/php.1
config.status: creating sapi/fpm/php-fpm.conf
config.status: creating sapi/fpm/init.d.php-fpm
config.status: creating sapi/fpm/php-fpm.service
config.status: creating sapi/fpm/php-fpm.8
config.status: creating sapi/fpm/status.html
config.status: creating sapi/cgi/php-cgi.1
config.status: creating ext/phar/phar.1
config.status: creating ext/phar/phar.phar.1
config.status: creating main/php_config.h
config.status: executing default commands安装
make
make install准备配置文件
[root@Zabbix_GW_TEST php-5.5.38]# cp php.ini-development /usr/local/php/lib/php.ini
[root@Zabbix_GW_TEST php-5.5.38]# vi /usr/local/php/lib/php.ini
修改配置文件
[root@nfs php-5.5.38]# cp php.ini-development /usr/local/php/lib/php.ini
[root@nfs php-5.5.38]# vim /usr/local/php/lib/php.ini
error_reporting = E_ALL & ~E_NOTICE
#报告所有的错误,但除了E_NOTICE这一种
display_errors = On
#在终端显示出错信息，这个在生产环境最好设置成off
track_errors = Off
#是否在变量$php_errormsg中保存最近一个错误或警告消息
post_max_size = 16M
#表单最大提交的数据量大小
upload_max_filesize = 16M
#准许上传文件大小限制为16M
date.timezone = PRC
#中华人民共和国时区
expose_php = Off
#隐藏php版本信息
curl -I www.ha97.com
HTTP/1.1 200 OK
Server: nginx
Date: Tue, 20 Jul 2010 05:45:13 GMT
Content-Type: text/html; charset=UTF-8
Connection: keep-alive
Vary: Accept-Encoding
#已经彻底隐藏了PHP版本。
extension_dir = "/usr/local/php/lib/php/extensions/no-debug-zts-20121212/"
#扩展模块存放目录修改Apache的文件，在重启
[root@nfs php-5.5.38]# vim /usr/local/apache/conf/httpd.conf
增加下面内容
<IfModule dir_module>
DirectoryIndex index.php index.html
</IfModule>
<IfModule mime_module>
AddType application/x-httpd-php-source .phps
AddType application/x-httpd-php .php .phtml
</IfModule>换一个思路的nginx搭建
概述
在apache配置解析php的操作种，遇到种种坑，Apache的配置不太熟悉，界面打不开php文件，理论上问题是出在Apache配置访问php上。但是我能力有限，解决不来，所以就换一个NGINX试试。
编译安装
上传解压，并编译。NGINX的编译相对简单，就不做详细记录
tar -xvzf nginx-1.6.0.tar.gz
cd nginx-1.6.0
./configure --prefix=/usr/local/nginx --without-http_memcached_module --user=www --group=www --with-http_stub_status_module --with-http_ssl_module --with-http_gzip_static_module
make
make install配置NGINX访问PHP
这个是NGINX的关键，因为zabbix的界面全部都是PHP语言写的，必须使用PHP软件才能解析应用
server {
listen 80;
server_name localhost;
location ~ \.(php|php5)?$ {
root /data/html;
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME /data/html$fastcgi_script_name;
include fastcgi_params;
}
location ~* ^.+\.(ico|gif|jpg|jpeg|png|html|css|htm|bmp|js|svg)$ {
root /data/html;
}
}
配置nginx.conf文件。增加两个location，第一个location增加的是站点的地址信息。第二个是增加解析各种图片样式的功能（因为在没有加的时候，我打开的zabbix界面全部都是只有文字，没有任何图片与样式，如下。原因就是PHP没有解析这些内容）
创建好站点目录
浏览器通过端口来访问服务器的文件，并用解析器解析，我们需要先准备好这些文件。zabbix的PHP文件是放在源码包里的，解压后就可以看到可以在上面的配置文件中可以看到我已经选择了/data/html
cp -r /opt/zabbix-4.0.2/frontends/php/* /data/html注意赋权
启动nginx
把环境变量配置在root下
export PATH=/usr/local/nginx/sbin:$PATH启动nginx,没有报错则启动成功，看监听端口和后台进程
[root@Zabbix_GW_TEST ~]# netstat -lnp|grep 80
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 25373/nginx: master
[root@Zabbix_GW_TEST ~]# ps -ef|grep nginx
root 12817 10266 0 18:11 pts/1 00:00:00 grep --color=auto nginx
root 25373 1 0 01:21 ? 00:00:00 nginx: master process nginx
www 27717 25373 0 02:07 ? 00:00:00 nginx: worker processZabbix配置
用户环境配置好
用户
adduser zabbix编译zabbix
编译
./configure --prefix=/usr/local/zabbix --enable-server --enable-proxy --enable-agent --enable-ipv6 --with-postgresql=/usr/local/pgsql/bin/pg_config --with-net-snmp --with-ssh2 --with-openipmi --with-ldap --with-libcurl --with-iconv安装依赖
yum install net-snmp-devel
yum install libssh2-devel
yum install OpenIPMI-devel
yum install openldap-devel
yum install libevent-devel
yum install curl-devel编译到此界面则安装成功
***********************************************************
* Now run 'make install' *
* *
* Thank you for using Zabbix! *
* <http://www.zabbix.com> *
***********************************************************执行make install
配置好环境变量
将此行写进配置文件中
PATH=/usr/local/zabbix/bin:/usr/local/zabbix/sbin:$PATH创建zabbix 数据库
postgres=# create role zabbix login
postgres-# ;
CREATE ROLE
postgres=# \password zabbix
Enter new password:
Enter it again:
postgres=# create database zabbix with template template0 encoding 'UTF8' ;
CREATE DATABASE
postgres=# grant all on database zabbix to zabbix;
GRANT
postgres=# \q导入zabbix数据
在源码下，有zabbix数据库的数据
cd /opt/zabbix-4.0.2/database/postgresql/
psql -Uzabbix -dzabbix -h127.0.0.1 -f schema.sql
psql -Uzabbix -dzabbix -h127.0.0.1 -f images.sql
psql -Uzabbix -dzabbix -h127.0.0.1 -f data.sql配置zabbix_server参数
[root@Zabbix_GW_server ~]# vim /usr/local/zabbix/etc/zabbix_server.conf
#监听port
ListenPort=10051
#日志存放地点及大小
LogFile=/tmp/zabbix_server.log
LogFileSize=10
#pid文件存放地点
PidFile=/tmp/zabbix_server.pid
#下面几个参数是配置数据库连接参数
DBHost=127.0.0.1
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBPort=5432
#监听ip范围
ListenIP=0.0.0.0
#media types中使用script存放目录
AlertScriptsPath=/usr/local/zabbix/alertscripts启动服务
zabbix_server查看是否有错，就查看zabbix_server 的启动日志，如果有报错，按照报错修改。反正我安装的时候真的报错频出，经历过，懂得都懂
查看web界面
此时就可以通过web界面来访问zabbix了
输入地址
可以看到，配存在一些问题也还是需要修改的，不然的话无法安装
agent端配置
概述
agnet端就是被监控的数据库主机，也是需要做一些安装
创建用户
groupadd zabbix
useradd -g zabbix -s /sbin/nologin zabbix编译安装
./configure --prefix=/usr/local/zabbix-agent --enable-agent
make install无需指定其他的编译参数
修改配置文件
vi /usr/local/zabbix-agent/etc/zabbix_agentd.conf
LogFile=/tmp/zabbix_agentd.log
Server=192.168.6.17/32
Hostname=Zabbix agent配置到环境变量
PATH=/usr/local/zabbix-agent/bin:/usr/local/zabbix-agent/sbin:$PATH启动zabbix_agent
直接运行zabbix_agent命令，查看日志，观察是否正常
至此
至此，zabbix的基本配置完成。后续还要配置监控等操作。后面慢慢再说
