zabbix 1.1.4 + oracle 10g (suse 9)

[ZhidkovAN]

Problem with displaying graphs.
I see error in PHP log:
[11-Dec-2006 09:28:18] PHP Warning: ocifetchinto() [<a href='function.ocifetchinto'>function.ocifetchinto </a>]: OCIFetchInto: ORA-24374: define not done before fetch or execute and fetch
in /u/app/apache2/htdocs/zabbix/include/db.inc.php on line 164

Help Please!

[cosmocracy]

Whew... Oracle working!

I had to do a LOT of crazy stuff to get Oracle working.

For the specific error you're getting, I ended up having to recompile PHP4 without any OCI suppoert (--without-oci8) and then manually obtain/compile/deploy the latest version of oci8, which I got from here: http://pecl.php.net/get/oci8-1.2.2.tgz

I was also using the Oracle Instant Client which took some fiddling.

And to get charts working I had to tweak the SQL in frontends/php/include/graphs.inc.php (since Oracle doesn't let you GROUP BY an aliased expression).

I also had to fix frontends/php/include/db.inc.php so that it would connect to Oracle running on something other than localhost.

Now that it appears to be working (whew!) I am very happy though!

[jgordor]

Graphs not showed

Hi cosmocracy,

I'm upgrade from 1.1.1 to 1.1.4 and the graphs are not showed in the frontend (using oracle 10g).

What are your tweaks for make it works?

Thanks in advance
José Luis Gordo Romero