Problem installing zabbix 1.6 with Oracle 10.2.0 on RHEL4

[albertxiao]

I managed to build and install zabbix server.

[root@localhost include]# ps -ef|grep zabbix
root 31216 2233 0 14:39 ? 00:00:00 sshd: zabbix [priv]
zabbix 31219 31216 0 14:39 ? 00:00:12 sshd: zabbix@pts/1
zabbix 31220 31219 0 14:39 pts/1 00:00:00 -bash
zabbix 31301 1 0 14:41 ? 00:00:01 /usr/local/sbin/zabbix_server
zabbix 31304 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31305 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31308 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31309 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31314 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31315 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31316 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31324 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31325 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31328 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31331 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31332 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31337 31301 0 14:41 ? 00:00:24 /usr/local/sbin/zabbix_server
zabbix 31340 31301 0 14:41 ? 00:00:03 /usr/local/sbin/zabbix_server
zabbix 31341 31301 0 14:41 ? 00:00:01 /usr/local/sbin/zabbix_server
zabbix 31346 31301 0 14:41 ? 00:00:08 /usr/local/sbin/zabbix_server
zabbix 31347 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31348 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31349 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31361 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31362 31301 0 14:41 ? 00:00:02 /usr/local/sbin/zabbix_server
zabbix 31363 31301 0 14:41 ? 00:00:00 /usr/local/sbin/zabbix_server
zabbix 31368 31301 0 14:41 ? 00:00:03 /usr/local/sbin/zabbix_server
root 8004 31256 0 17:38 pts/1 00:00:00 grep zabbix


I copy the php pages to apache.

cp -R /home/zabbix/zabbix-1.6.1/frontends/php/* /var/www/html/zabbix

Problem comes when I begin with the webpage configuration at the check of pre-requisite page.

PHP version: 5.2.5 Ok
PHP Memory limit: 128M Ok
PHP post max size: 8M Ok
PHP max execution time: 30 sec Fail
PHP Databases support: No Fail
PHP BC math support yes Ok
GD Version: bundled (2.0.34 compatible) Ok
Image formats: PNG Ok
PHP Timezone: Asia/Shanghai Ok

Fail
Please correct all issuse and press "Retry" button

I have the configuration in db.inc.php file as shown below:

<?php

$DB_TYPE ="Oracle";
$DB_SERVER ="192.168.74.130";
$DB_PORT = "1521";
$DB_DATABASE ="albertdb";
$DB_USER ="zabbix";
$DB_PASSWORD ="zabbix";

if(!isset($DB)){
$DB = array();
if(isset($DB_TYPE)) $DB['TYPE'] = $DB_TYPE;
if(isset($DB_SERVER)) $DB['SERVER'] = $DB_SERVER;
if(isset($DB_PORT)) $DB['PORT'] = $DB_PORT;
if(isset($DB_DATABASE)) $DB['DATABASE'] = $DB_DATABASE;
if(isset($DB_USER)) $DB['USER'] = $DB_USER;
if(isset($DB_PASSWORD)) $DB['PASSWORD'] = $DB_PASSWORD;
}
...

The database server is up and running and it has been restarted many times.

The /etc/php.ini file has the following setting (default setting except for the timezone)

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30 ; Maximum execution time of each script, in seconds

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

extension=oci8.so

extension_dir = "/usr/lib/php/modules"


[root@localhost etc]# ls /usr/lib/php/modules
bcmath.so gd.so oci8.so odbc.so pdo_oci.so pdo_odbc.so pdo.so pdo_sqlite.so

The PHP package I have are:

rpm -qa |grep php
php-odbc-5.2.5-1
php-common-5.2.5-1
php-5.2.5-1
php-pdo-5.2.5-1
php-bcmath-5.2.5-1
php-oci8-5.2.5-1
php-cli-5.2.5-1
php-gd-5.2.5-1

Can anyone help me with the problem?

Thanks

/Albert

[dotneft]

Try thise manual http://www.oracle.com/technology/pub...p_instant.html

PHP max execution time: 30 sec Fail...You need increase this parametre

[albertxiao]

I have done the following changes and now it works.

the configuration in db.inc.php file as shown below:

<?php

$DB_TYPE ="Oracle";
$DB_SERVER ="192.168.74.130";
$DB_PORT = "1521";
$DB_DATABASE ="albertdb";
$DB_USER ="zabbix";
$DB_PASSWORD ="zabbix";

I remove this which I have added by other installation guide.

in php.ini file

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30 ; Maximum execution time of each script, in secon

I change it to 300

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

;extension=oci8.so

;extension_dir = "/usr/lib/php/modules"

The Dynamic extension needs to comment out. Because when I install the PHP oracle support, it has already done related modification.

I install the oracleclient devel package.

Also add the parameters like TNS_ADMIN, LD_LIB_PATH to run both apache and zabbix.