zabbix连oracle+php+Apache

资源包到我的主页下载或者我的qq1464202534
资源包：https://download.csdn.net/download/qq_40055558/11037595

数据库实例名：zabbixdb
用户名：zabbixusr01 / zabbixts01

1. 服务端安装配置
   参考文档https://www.iyunv.com/thread-337453-1-1.html
   1.1 环境准备

1.1.1. 安装数据库
数据库实例名：zabbixdb
用户名：zabbixusr01 / zabbixts01
虚拟机：sv-zabbixdev01

数据库安装过程省略。。。（要注意就是安装时选择的字符集为UTF8或AL32UTF8）

1.1.2. 创建zabbix表空间,创建用户指定表空间
create tablespace “ZABBIXTS01” datafile ‘/u01/oracle/product/12.2/oradata/zabbixdb/zabbix_data01.dbf’ size 5g autoextend on next 10m maxsize 16g logging online permanent blocksize 8192 extent management local autoallocate segment space management auto;
CREATE USER zabbixusr01 IDENTIFIED BY zabbix DEFAULT TABLESPACE ZABBIXTS01;
GRANT DBA TO zabbixusr01 WITH ADMIN OPTION;
1.1.3. oracle 给zabbix 权限
GRANT ALTER SESSION TO ZABBIXUSR01 ;
GRANT CREATE SESSION TO ZABBIXUSR01 ;
GRANT CONNECT TO ZABBIXUSR01 ;
ALTER USER ZABBIXUSR01 DEFAULT ROLE ALL;
GRANT SELECT ON V_KaTeX parse error: Expected group after '_' at position 87: …ANT SELECT ON V_̲LOG_HISTORY TO ZABBIXUSR01 ;
GRANT SELECT ON V_KaTeX parse error: Expected group after '_' at position 100: …ANT SELECT ON V_̲LOCK TO ZABBIXUSR01 ;
GRANT SELECT ON DBA_REGISTRY TO ZABBIXUSR01 ;
GRANT SELECT ON DBA_SEGMENTS TO ZABBIXUSR01 ;
GRANT SELECT ON V_KaTeX parse error: Expected group after '_' at position 48: …ANT SELECT ON V_̲SYSSTAT TO ZABBIXUSR01 ;
GRANT SELECT ON V_KaTeX parse error: Expected group after '_' at position 45: …ANT SELECT ON V_̲LATCH TO ZABBIXUSR01 ;
GRANT SELECT ON V_KaTeX parse error: Expected group after '_' at position 43: …ANT SELECT ON V_̲SGASTAT TO ZABBIXUSR01 ;
GRANT SELECT ON V_KaTeX parse error: Expected group after '_' at position 48: …ANT SELECT ON V_̲PROCESS TO ZABBIXUSR01 ;
GRANT SELECT ON DBA_DATA_FILES TO ZABBIXUSR01 ;
GRANT SELECT ON DBA_TEMP_FILES TO ZABBIXUSR01 ;
GRANT SELECT ON DBA_FREE_SPACE TO ZABBIXUSR01 ;
GRANT SELECT ON V_$SYSTEM_EVENT TO ZABBIXUSR01 ;
exec dbms_network_acl_admin.create_acl(acl => ‘resolve_server.xml’,description =>‘resolve acl’, principal =>‘ZABBIXUSR01’, is_grant => true, privilege =>‘resolve’);
exec dbms_network_acl_admin.assign_acl(acl=> ‘resolve_server.xml’, host =>’*’);

1.1.4. 用zabbxi 用户登录数据库运行SQL脚本

[root@sv-zabbixdev01 zabbixinstall]# tar -xf zabbix-4.0.5.tar.gz -C /tmp/ #解压到/tmp
将图片拷贝到/tmp/images目录中并修改脚本
mkdir /tmp/output_png
cp -r /tmp/zabbix-4.0.5/misc/images/ /tmp/output_png
sed -i ‘s%/home/zabbix/zabbix/create/output_png%/tmp/output_png/%g’ /tmp/zabbix-4.0.5/database/oracle/images.sql
chown oracle:dba /tmp/output_png
[root@sv-zabbixdev01 ~]# su – oracle #登录到oracle用户
[oracle@sv-zabbixdev01 ~]$ cd /tmp/zabbix-4.0.5/database/oracle/ #到zabbix连oracle数据库的脚本目录
[oracle@sv-zabbixdev01 oracle]$ sqlplus zabbixusr01/zabbix #记得使用 zabbix 登录oracle
有三个文件，data.sql images.sql schema.sql，顺序执行
sqlplus> @schema.sql #如报错可以尝试sed -i ‘s/2048/2000/g’ schema.sql因为里面有个oracle可能不支持的字符长度，所以先要修改字符串长度
sqlplus> @images.sql
sqlplus> @data.sql

##调整字段的长度：##
#SQL> alter table items add(new_description nvarchar2(2000));
#SQL> update items set new_description = DESCRIPTION;
#SQL> alter table items drop column DESCRIPTION;
#SQL> alter table items rename column new_description to DESCRIPTION;
2. 安装zabbix_WEB及server
2.1. 安装PHP及相关组件
cd /root/zabbixinstall/php55
yum -y localinstall *.rpm
yum install wget libmicrohttpd-devel httpd-devel httpd-tools libmicrohttpd.x86_64 lrzsz httpd net-snmp-devel java-devel openldap openldap-devel libssh2-devel.x86_64 unixODBC-devel.x86_64 OpenIPMI-devel OpenIPMI-libs.x86_64 net-snmp-devel libxml2 curl-devel libxml2-devel gcc gcc-c++ compat-libstdc+±33
2.2. 安装oracle client和OCI
cd /root/zabbixinstall/oracleoci8
rpm –ivh oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
rpm –ivh oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
rpm –ivh oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

安装OCI
tar -xf oci8-2.0.12.tgz
cd oci8-2.0.12
phpize
./configure --with-oci8=shared,instantclient,/usr/lib/oracle/12.2/client64/lib --with-php-config=/usr/bin/php-config
make
make test
###Do you want to send this report now? [Yns]: n
make install
启用OCI8(此步也是启用PHP database support中对oracle的支持)
echo “/usr/lib/oracle/12.2/client64/lib” > /etc/ld.so.conf.d/oracle.conf
echo “extension=oci8.so” >> /etc/php.ini
ldconfig

安装完成后可以测试一下是否安装OCI成功
echo “<?php phpinfo(); ?>”>/var/www/html/test.php
systemctl restart httpd

2.3. 配置环境变量：

1. 将以下内容写入/etc/profile文件
   export ORACLE_HOME=/usr/lib/oracle/12.2/client64/
   export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64:/usr/lib/oracle/12.2/client64/bin:$L{D}_{L}IBRAR{Y}_{P}ATHexportNL{S}_{L}ANG=AMERICA{N}_{A}MERICA.AL32UTF8exportTN{S}_{A}DMIN=/usr/lib/oracle/12.2/client64/network/adminexportPATH=$PATH:/usr/lib/oracle/12.2/client64/bin

2. network/admin两个目录自己建一下，然后把zabbixDB的tnsname.ora复制到admin目录下，把12C的tnsping文件上传到/usr/lib/oracle/12.2/client64/bin/目录下
   mkdir –P /usr/lib/oracle/12.2/client64/network/admin
   cp /u01/oracle/product/12.2/network/admin/tnsnames.ora /usr/lib/oracle/12.2/client64/network/admin
   cp /u01/oracle/product/12.2/bin/tnsping /usr/lib/oracle/12.2/client64/bin

3. 安装zabbix
   解压：
   tar -xf zabbix-4.0.5.tar.gz -C /tmp/
   创建:
   创建/usr/lib/oracle/12.2/client64/rdbms/public 然后将/usr/include/oracle/12.2/client64/的内容复制到/usr/lib/oracle/12.2/client64/rdbms/public之下
   mkdir -p /usr/lib/oracle/12.2/client64/rdbms/public
   cp /usr/include/oracle/12.2/client64/* /usr/lib/oracle/12.2/client64/rdbms/public/
   安装依赖：
   shell> wget http://monkey.org/~provos/libevent-1.4.14b-stable.tar.gz
   shell> tar xf libevent-1.4.14b-stable.tar.gz
   shell>cd libevent-1.4.14b-stable
   shell> ./configure --prefix=/opt/libevent
   shell> make && make install
   编译：
   cd cd /tmp/zabbix-4.0.5/
   ./configure --prefix=/usr/local/zabbix --enable-server --enable-agent --enable-java --with-oracle=/usr/lib/oracle/12.2/client64/ --with-unixodbc --with-net-snmp --with-libcurl --with-libxml2 --with-libevent=/opt/libevent/

make && make install

ln -s /usr/local/zabbix/etc /etc/zabbix #创建一个软连接
2. 配置zabbix
vi /etc/zabbix/zabbix_server.conf
LogFile=/tmp/zabbix_server.log
DBHost=localhost
DBName=zabbixdb
DBUser=zabbixusr01
Password=zabbix
DBPort=1521
Timeout=4
LogSlowQueries=3000

3. 配置PHP和拷贝网页
   sed -i “s@;date.timezone =@date.timezone = Asia/Shanghai@g” /etc/php.ini
   sed -i “s@max_execution_time = 30@max_execution_time = 300@g” /etc/php.ini
   sed -i “s@post_max_size = 8M@post_max_size = 32M@g” /etc/php.ini
   sed -i “s@max_input_time = 60@max_input_time = 300@g” /etc/php.ini
   sed -i “s@memory_limit = 128M@memory_limit = 128M@g” /etc/php.ini
   sed -i “s@;mbstring.func_overload = 0@ambstring.func_overload = 2@g” /etc/php.ini
   sed -i “s@upload_max_filesize = 2M@upload_max_filesize = 32M@g” /etc/php.ini
   拷贝网页
   cd /tmp/zabbix-4.0.5
   mkdir /var/www/html/zabbix
   cp -r frontends/php/* /var/www/html/zabbix
   chmod 777 /var/www/html/conf
   systemctl restart httpd
4. 配置开机自启
   添加zabbix服务启动及开机启动
   cp /tmp/zabbix-4.0.5/misc/init.d/fedora/core5/zabbix_server /etc/init.d/
   cp /tmp/zabbix-4.0.5/misc/init.d/fedora/core5/zabbix_agentd /etc/init.d/
   sed -i “s@ZABBIX_BIN=”/usr/local/sbin/zabbix_server"@ZABBIX_BIN="/usr/local/zabbix/sbin/zabbix_server"@g" /etc/init.d/zabbix_server
   sed -i “s@ZABBIX_BIN=”/usr/local/sbin/zabbix_agentd"@ZABBIX_BIN="/usr/local/zabbix/sbin/zabbix_agentd"@g" /etc/init.d/zabbix_agentd
   sed -i ‘$a/opt/libevent/lib’ /etc/ld.so.conf.d/oracle.conf
   ldconfig
   chkconfig --add zabbix_server
   chkconfig --add zabbix_agentd
   chkconfig --level 345 zabbix_server on
   chkconfig --level 345 zabbix_agentd on
   systemctl start zabbix_server
   systemctl start zabbix_agentd
5. 进入网页配置
   http://ip/zabbix
   
   一个LDAP的warning不需要管

填写数据库中zabbix用户的信息

为zabbix server命名

安装完成
初始用户是：Admin
密码：zabbix