Compiling Zabbix for Oracle

[coop]

Hey folks, compiling for Oracle 10g. Got the libsqlora8, net-snmp, and curl compiled fine. Using the config line:

./configure --enable-server --with-oracle=/usr/local --with-net-snmp=/opt/freeware/bin/net-snmp-config --with-libcurl=/usr/local/bin/curl-config

The configure runs fine and the Make Install runs quite a ways through the process until it stops on this output....

ld: 0711-317 ERROR: Undefined symbol: .sqlo_close
ld: 0711-317 ERROR: Undefined symbol: .sqlo_open
ld: 0711-317 ERROR: Undefined symbol: .sqlo_geterror
ld: 0711-317 ERROR: Undefined symbol: .sqlo_fetch
ld: 0711-317 ERROR: Undefined symbol: .sqlo_values
ld: 0711-317 ERROR: Undefined symbol: .sqlo_exec
ld: 0711-317 ERROR: Undefined symbol: .sqlo_init
ld: 0711-317 ERROR: Undefined symbol: .sqlo_connect
ld: 0711-317 ERROR: Undefined symbol: .sqlo_set_autocommit
ld: 0711-317 ERROR: Undefined symbol: .sqlo_finish
ld: 0711-317 ERROR: Undefined symbol: .sqlo_alloc_lob_desc
ld: 0711-317 ERROR: Undefined symbol: .sqlo_prepare
ld: 0711-317 ERROR: Undefined symbol: .sqlo_bind_by_pos
ld: 0711-317 ERROR: Undefined symbol: .sqlo_free_lob_desc
ld: 0711-317 ERROR: Undefined symbol: .sqlo_execute
ld: 0711-317 ERROR: Undefined symbol: .sqlo_lob_write_buffer
ld: 0711-317 ERROR: Undefined symbol: .sqlo_commit
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
collect2: ld returned 8 exit status
make: 1254-004 The error code from the last command is 1.

Can anyone help with this? Anyone else using Oracle for their DB?

[coop]

Managed to get my libsqlora8 problems fixed. Can anyone help with the compile issues above?

Starting to wonder if Zabbix really supports Oracle...

[coop]

If anyone is interested, I have finally managed to get Zabbix Server compiled and running on AIX 5.3 with a Oracle 10g database. It was an enormous pain the you-know-where but it is running. Would be happy to provide info if anyone is interested in the entire process.

But judging by the response my questions got I'm going to guess I'm an exception to the rule with this environment combo....

The compile problem was due to Libsqlora8 and it being improperly compiled. Libsqlora8 configure script does not appear to properly support the AIX environment. The configure script uses the -m32 and -m64 switches to differentiate between 32bit and 64bit environments. The problem as far as I could find is that these switches apply to the x86 world and are not supported by AIX. I had to mod the configure script to use -mpowerpc and -mpowerpc64 instead of -m32 and -m64. There may be a far better solution out there, but this fixed by compile issue on libsqlora8, which allowed Zabbix to compile fine.

Final Libsqlora8 config line:
./configure --with-oraclehome=/oracle/app/oracle/10.2 --prefix=/usr/local/libsqlora8

Final Zabbix config line:
./configure --enable-server --with-oracle=/usr/local --with-net-snmp=/opt/freeware/bin/net-snmp-config --with-libcurl=/usr/local/bin/curl-config

Cheers!