Apache 2 + PHP 5 + Oracle 10 Installation on Redhat OEL 5

[SebD]

Hello,

I've installed on Redhat OEL 5 :
- Apache 2.2.3
- PHP 5.2.3
- Oracle Server 10.2.0.3
- libsqlora8

All the installations are ok.
Separately, Apache, PHP et Oracle are runing.
But when I try to use the PHP/Oracle connection for Zabbix, there is a trouble.

Could someone tell me if forget something in my installation?

Thanks.

Sébastien

[SebD]

Ok I've reconfigure my php and now I have this error :

ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory[/apps/zabbix/upload/zabbix-1.4.1/frontends/php/include/db.inc.php:82]

Error connecting to database

I've verified : The Oracle_Home, type (Oracle), host, port, name, user and password are ok.

Is there someone have any idea where it's come from?

Logs from Apache :
[Mon Oct 15 14:55:37 2007] [crit] (70023)This function has not been implemented on this platform: DBD: driver for [DBDriver unset] not available
Thanks!

Sébastien

[SebD]

Zabbix 1.4.2 and Oracle

Hi,

After some tests working with SebD, the following solutions have been applied :


- > into db.c
l 147 : char *connect = NULL; ( * was missing)
l 149 : sqlo_init(SQLO_OFF, 100, 100) ( instead of(SQLO_OFF,1,100) for connections limitations )
l 565 : //if(!result) return NULL; ( put as a comment )
l 776 : result=DBselectN(sql,1); ( instead of result=DBSelect(sql); )

- > into db.inc.php

from line 30, define your entries for zabbix database
$DB = null;
$DB_TYPE = "ORACLE";
$DB_SERVER = "xxx.xxx.xxx.xxx";
$DB_PORT = "xxxx";
$DB_DATABASE = "ZABBIX";
$DB_USER = "user";
$DB_PASSWORD = "password";

from line 81 ( after adding the previous ones )

case "ORACLE":
//$DB = ocilogon($DB_USER, $DB_PASSWORD, $DB_DATABASE);
$DB = ocilogon($DB_USER, $DB_PASSWORD,
"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=$DB_SER VER)(PORT=$DB_PORT))
(CONNECT_DATA=(SERVICE_NAME=$DB_DATABASE)))");


first line commented out, second uncommented, $DB_PORT put instead of standard 1521 oracle port

- > in database schemas creation
in oracle.sql
some tables and their indexes do not create correctly. The solution was to remove the single quotes to any decimal number set as default in the script

in data.sql
removal of any occuring `
when plsql asks for values of lt, enter &lt, and for gt, enter &gt

in images_oracle.sql
the pictures are located in frontends/php/images/sysmaps/

- > keep an eye on the user rights so zabbix can access oracle

seems that Zabbix is now functionnal, under qualification for the moment.

Frederic.W

[jgordor]

Compilation issue

Hi!

With the c source modification, you have any compilation issues?

Many thanks

[SebD]

Hi!

After few tests, I can say we haven't trouble with Zabbix 1.4.2.
It's running well with the changes of Frederic.

jgordor : we have no bugs in the compilation with this changes.

Sébastien

[jgordor]

Zabbix server don't connect

Thanks SebD,

I was able to compile and install correctly, but now zabbix server is unable to connect to the database (I have 1.1.6 running perfectly).

Any throuths?