zabbix支持oracle odbc吗
发布网友
发布时间：2022-04-09 05:33
共2个回答
懂视网
时间：2022-04-09 09:54
背景描述：
1、原来安装zabbix是在LAMP的环境下是可以正常运行；（Linux CentOS 7）
2、现想把mysql换成oracle，通过安装oracle客户端远程访问另外一台机器上oracle服务，客户e端和zabbix是同一台机器，sqlplus是可以正常运行访问；
3、PHP页面通过OCI也是可以正常登陆http://127.0.0.1/zabbix；
4、zabbix_server.conf中配置DBHost=数据库IP,DBNAME=数据库实例名，DBPORT=1521...
可是后台zabbix_server.log报错【Z3001] connection to database ‘ORCL‘ failed : [2013] Lost connection to MySQL server at ‘reading initial communication packet ‘,system error :0
5、安装zabbix时使用源码安装 ，进入解压目录
./configure --with-mysql=/usr/bin/mysql_config --with-net-snmp --with-libcurl --enable-server --enable-agent --enable-proxy --prefix=/usr/local/zabbix
此处没有 配置 --with-oracle
疑问：
1、出现上述描述4中连接数据库失败如何解决？
2、zabbix_server是通过什么方式访问数据库的？OCI?
3、再次使用5的命令./configure --with-oracle --enable-server --prefix=/usr/local/zabbix提示OCI library not found
./configure --with-oracle=$ORACLE_HOME/lib --enable-server --prefix=/usr/local/zabbix 提示OCI library not found
谢谢！
zabbix存储oracle
标签：zabbix
热心网友
时间：2022-04-09 07:02
Software Requirements
Zabbix is built around modern Apache WEB server, leading database engines, and the PHP scripting language.
The following software is required to run Zabbix:
Software
Version
Comments
Apache
1.3.12 or later
PHP
5.0 or later
PHP moles:
php-gd
GD 2.0 or later
PHP GD mole must support PNG images.
PHP TrueType support
--with-ttf
PHP bc support
php-bcmath, --enable-bcmath
PHP XML support
php-xml or php5-dom, if provided as a separate package by the distributor
PHP session support
php-session, if provided as a separate package by the distributor
PHP socket support
php-net-socket, --enable-sockets. Required for user script support.
PHP multibyte support
php-mbstring, --enable-mbstring
IBM DB2
ibm_db2
Required if IBM DB2 is used as Zabbix back end database.
MySQL
php-mysql
3.22 or later
Required if MySQL is used as Zabbix back end database.
Oracle
oci8
Required if Oracle is used as Zabbix back-end database.
PostgreSQL
php-pgsql
7.0.2 or later if Zabbix < 1.8.9
7.4 or later if Zabbix >= 1.8.9
Required if PostgreSQL is used as Zabbix back-end database.
Consider using PostgreSQL 8.x or later for much better performance.
It is suggested to use at least PostgreSQL 8.3, which introced much better VACUUM performance.
SQLite
php-sqlite3
3.3.5 or later
Required if SQLite is used as Zabbix back-end database.
数据库端设置
create tablespace zabbix datafile '+ASM1/momorac/datafile/zabbix1.bdf' size 500M autoextend on next 50m maxsize 4096M;
Alter Profile Default Limit Failed_Login_Attempts Unlimited;
Alter Profile Default Limit Password_Life_Time Unlimited;
Create User Zabbix Identified By 111111 Default Tablespace Zabbix;
Grant Connect To Zabbix;
Grant Resouse To Zabbix;
Grant Unlimited Tablespace To Zabbix;
grant create any DIRECTORY to zabbix;
grant dba to zabbix; --临时授权
安装oracle即时客户端
数据库和zabbix没在同一台主机上，所以需要安装oracle即时客户端，也可以是oracle的客户端。只不过客户端比较庞大。
