rc2.4.4rc1 oracle install issues

[Fran581]

Because I ran into this issue <Compilation of server fails for 2.4.3 with Oracle support with zabbix 2.4.3 I tried 2.4.4rc1, as was suggested in the article.

Linux OL6.5
Oracle 12.1.0.2

1) for oracle and db2 the schema.sql is not generated
2) the webinterface does not get me past setup.php
3) almost forgot to mention: in oracle nvarchar2 length limit is 2000 characters, not 2048.

The webinterface has an issue with case sensitivity in DB[TYPE] ORACLE. If using Oracle it shows the db config screen, If using ORACLE it just complains about not being able to connect. Looks like some inconsistency.

I can not find logs, access_log and error_log don't have any error messages related to the database connection. 192.168.1.1 192.168.0.1 10.0.0.1

zabbix_server is running without problems.
Also installed the images.

With the config in /var/www/html/zabbix/conf/zabbix.conf.php I can choose between the following error message:

<?php
// Zabbix GUI configuration file.
global $DB;

$DB["TYPE"] = 'ORACLE';
$DB["SERVER"] = 'localhost';
$DB["PORT"] = '1521';
$DB["DATABASE"] = 'orcl';
$DB["USER"] = 'zabbix';
$DB["PASSWORD"] = 'zabbix';
// Schema name. Used for IBM DB2 and PostgreSQL.
$DB["SCHEMA"] = 'zabbix';
$ZBX_SERVER = 'localhost';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = '';
$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
?>

I get:
Zabbix 2.4.4rc1
Database error
Error connecting to database:


and with
<?php
// Zabbix GUI configuration file.
global $DB;

$DB["TYPE"] = 'Oracle';
$DB["SERVER"] = 'localhost';
$DB["PORT"] = '1521';
$DB["DATABASE"] = 'orcl';
$DB["USER"] = 'zabbix';
$DB["PASSWORD"] = 'zabbix';
// Schema name. Used for IBM DB2 and PostgreSQL.
$DB["SCHEMA"] = 'zabbix';
$ZBX_SERVER = 'localhost';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = '';
$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
?>

I get:
Zabbix 2.4.4rc1
Configuration file error
DB type has wrong value. Possible values MYSQL, POSTGRESQL, ORACLE, IBM_DB2, SQLITE3

It's a pity that I can not find a more descriptive error message.

/* $DB['DB'] = @oci_connect($DB['USER'], $DB['PASSWORD'], $connect); */
$DB['DB'] = @oci_connect('zabbix', 'zabbix', '127.0.0.1:1521/orcl');
if ($DB['DB']) {
DBexecute('ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.zbx_dbstr('. '));
}
else {
$ociError = oci_error();
$error = 'Error boe connecting to database: '.$ociError['message'];
$result = false;
}

does not show any error info, I guess the problem is the oci_connect itself. I see not a single request in the oracle listener log file. I do see my 'boe' marker in the browser.

[hihoss]

on step

I got OCI8 loaded in the PHP process, at least no errors. but I am getting "Error connecting to Database" I have tried all options in the zabbix.conf.php. How do I get some helpful messages fro the php process to see what the issue is?

[hihoss]

still blank

I am not a php guy either so I am fighting this one. How did you get zabbix front end to talk to the db. I do not have access to pull from pecl. Do I need to rebuild php for oracle? or is there a binary I can drop in?

[ik_zelf]

I am an Oracle guy, not so much php ..... normally I get tools working on Oracle, if I have enough privileges .....
I think you need

pecl install oci8

[hihoss]

does PHP that came in the postgres install pkg have

Thanks very much for the quick response.
does PHP that came in the postgres install pkg have oracle enabled?
"--with-oci8"

[ik_zelf]

does this: http://php.net/manual/en/book.oci8.php help?

[hihoss]

still not there

Thanks for the reply. I am a step closer but still not there.
I added the oci8.so to the ini and the I got.

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/oci8.so' - /usr/lib64/php/modules/oci8.so: cannot open shared object file: No such file or directory in Unknown on line 0

I made a link in /usr/lib64/php/modules/oci8.so to libclntsh.so. no luch
I added Environment=LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib to the httpd.service file; no luck

Do I need to rebuild php?
I have instantclient12.1-basic-12.1.0.2.0-1 loaded for oracle.

[ik_zelf]

you need to config php to use the Oracle driver. For that you need the Oracle client installation and in /etc/php.d/ the oci8.ini with "extension=oci8.so"

[hihoss]

Oracle config. PHP issue

I am trying to config zabbix to se oracel for the backend DB. I had postGresql running. I downloaded the source and rebuild the server for oracle. copied it in place and started. the log shows it connected to oracle. I can not get the web setup to allow oracel config. I only shows PostgreSQL. I copied the php files from the source kit to the http dir. but no luck. I also have edited the zabbix php config. still nothing. I am using 3.2

[vardhasu]

You do need an Oracle Client installation on you zabbix server. That can connect to a remote database. This is a very common setup. So first you need to install the Oracle Client. You can use this article as a simple guide for the client installation.

Hi

Thanks for reply. Already did that.

Regards

Vardhan

[ik_zelf]

You do need an Oracle Client installation on you zabbix server. That can connect to a remote database. This is a very common setup. So first you need to install the Oracle Client. You can use this article as a simple guide for the client installation.

[vardhasu]

Oracle install issues

After downloading and installing 2.4.4 the compilation went OK but the web frontend still did not connect me to the database. The cause of this was:

/etc/sysconfig/httpd that should contain an export for ORACLE_HOME.
export

/etc/sysconfig/httpd:
ORACLE_HOME=/your/oracle/home
export ORACLE_HOME
----------------------------------------
Don't forget the export

What needs to be done for setup to recognize oracle, if Oracle resides on a different node?

[inhayn]

Hello!

I found the same problem with the version 2.4.4 and your solution works great!

Thank you!

[ik_zelf]

After downloading and installing 2.4.4 the compilation went OK but the web frontend still did not connect me to the database. The cause of this was:

/etc/sysconfig/httpd that should contain an export for ORACLE_HOME.
export

/etc/sysconfig/httpd:
ORACLE_HOME=/your/oracle/home
export ORACLE_HOME
----------------------------------------
Don't forget the export

[ik_zelf]

I also added phpinfo, which tells the following for oci:
oci8
OCI8 Support enabled
OCI8 DTrace Support disabled
OCI8 Version 2.0.8
Revision $Id: f04114d4d67cffea4cdc2ed3b7f0229c2caa5016 $
Oracle Run-time Client Library Version 12.1.0.2.0
Oracle Compile-time Version 12.1
Compile-time ORACLE_HOME /u01/app/oracle/12.1.0.2/home1
Libraries Used -Wl,-rpath,/u01/app/oracle/12.1.0.2/home1/lib -L/u01/app/oracle/12.1.0.2/home1/lib -lclntsh

not bad at all but still, it fails.