Zabbix Oracle and libsqlora8

[simonuk1]

I am hoping someone will be able to help me out with this problem.

I have compliled libsqlora8 as follows:

./configure --with-oraclehome=/u01/app/oracle/product/1020 --enable-64bit prefix=/usr/local/libsqlora8-2.3.3


This has compiled ok and I can connect to my oracle database using the exampled in the download directory.

I then configured zabbix 1.6.5 as follows:

./configure --enable-agent --enable-server --enable-proxy --with-net-snmp --with-jabber --with-libcurl --with-jabber --with-oracle=/usr/local/libsqlora8-2.3.3

Which gave back :

checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
........
checking for atoll... yes
checking for getopt_long... yes
checking for Oracle support... yes
checking for function PQserverVersion()... no
checking for ZABBIX server database selection... ok
checking for pkg-config... /usr/bin/pkg-config
checking pkg-config is at least version 0.9.0... yes
checking for IKSEMEL... yes
checking for getaddrinfo... yes
checking for gawk... (cached) gawk
checking for curl-config... /usr/bin/curl-config
checking for the version of libcurl... 7.15.5
checking for libcurl >= version 7.13.1... yes
checking for main in -lcurl... yes
checking whether libcurl is usable... yes
checking for curl_free... yes
checking for net-snmp-config... /usr/bin/net-snmp-config
checking for main in -lnetsnmp ... yes
checking for localname in struct snmp_session... yes
checking for architecture... ok (linux-gnu)
checking for the kernel version... 2.6 family (2.6.18-128.1.6.el5)
configure: creating ./config.status
config.status: creating Makefile
config.status: creating create/Makefile
config.status: creating misc/Makefile
config.status: creating src/Makefile
config.status: creating src/libs/Makefile
config.status: creating src/libs/zbxlog/Makefile
config.status: creating src/libs/zbxcrypto/Makefile
config.status: creating src/libs/zbxconf/Makefile
config.status: creating src/libs/zbxdbcache/Makefile
config.status: creating src/libs/zbxdbhigh/Makefile
config.status: creating src/libs/zbxemail/Makefile
config.status: creating src/libs/zbxsysinfo/Makefile
config.status: creating src/libs/zbxsms/Makefile
config.status: creating src/libs/zbxjabber/Makefile
config.status: creating src/libs/zbxcommon/Makefile
config.status: creating src/libs/zbxsysinfo/common/Makefile
config.status: creating src/libs/zbxsysinfo/simple/Makefile
config.status: creating src/libs/zbxsysinfo/linux/Makefile
config.status: creating src/libs/zbxsysinfo/aix/Makefile
config.status: creating src/libs/zbxsysinfo/freebsd/Makefile
config.status: creating src/libs/zbxsysinfo/hpux/Makefile
config.status: creating src/libs/zbxsysinfo/openbsd/Makefile
config.status: creating src/libs/zbxsysinfo/osx/Makefile
config.status: creating src/libs/zbxsysinfo/solaris/Makefile
config.status: creating src/libs/zbxsysinfo/osf/Makefile
config.status: creating src/libs/zbxsysinfo/netbsd/Makefile
config.status: creating src/libs/zbxsysinfo/unknown/Makefile
config.status: creating src/libs/zbxnix/Makefile
config.status: creating src/libs/zbxplugin/Makefile
config.status: creating src/libs/zbxsys/Makefile
config.status: creating src/libs/zbxcomms/Makefile
config.status: creating src/libs/zbxdb/Makefile
config.status: creating src/libs/zbxjson/Makefile
config.status: creating src/libs/zbxserver/Makefile
config.status: creating src/libs/zbxicmpping/Makefile
config.status: creating src/zabbix_agent/Makefile
config.status: creating src/zabbix_get/Makefile
config.status: creating src/zabbix_sender/Makefile
config.status: creating src/zabbix_server/Makefile
config.status: creating src/zabbix_server/alerter/Makefile
config.status: creating src/zabbix_server/dbsyncer/Makefile
config.status: creating src/zabbix_server/discoverer/Makefile
config.status: creating src/zabbix_server/housekeeper/Makefile
config.status: creating src/zabbix_server/httppoller/Makefile
config.status: creating src/zabbix_server/nodewatcher/Makefile
config.status: creating src/zabbix_server/pinger/Makefile
config.status: creating src/zabbix_server/poller/Makefile
config.status: creating src/zabbix_server/timer/Makefile
config.status: creating src/zabbix_server/trapper/Makefile
config.status: creating src/zabbix_server/utils/Makefile
config.status: creating src/zabbix_server/watchdog/Makefile
config.status: creating src/zabbix_server/escalator/Makefile
config.status: creating src/zabbix_proxy/Makefile
config.status: creating src/zabbix_proxy/heart/Makefile
config.status: creating src/zabbix_proxy/housekeeper/Makefile
config.status: creating src/zabbix_proxy/proxyconfig/Makefile
config.status: creating src/zabbix_proxy/datasender/Makefile
config.status: creating upgrades/Makefile
config.status: creating include/config.h
config.status: include/config.h is unchanged
config.status: executing depfiles commands


Configuration:

Detected OS: linux-gnu
Install path: /usr/local
Compilation arch: linux

Compiler: gcc
Compiler flags: -g -O2 -I/usr/local/libsqlora8-2.3.3/include -I/usr/local/libsqlora8-2.3.3/lib/libsqlora8/include -I/usr/include/rpm -I/usr/local/include -I/usr/include/gdbm -I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE -I. -I/usr/include/net-snmp

Enable server: yes
With database: Oracle
WEB Monitoring via: cURL
Native Jabber: yes
SNMP: net-snmp
IPMI: no
Linker flags: -L/usr/local/libsqlora8-2.3.3/lib -lsqlora8 -liksemel -L/usr/kerberos/lib64 -lcurl -ldl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz -L/usr/lib64 -L/usr/lib64 -lnetsnmp -lcrypto -lm -L/usr/lib64/lib -lwrap -lcrypto -L/usr/lib64 -L/usr/lib64 -lnetsnmp -lcrypto -lm -L/usr/lib64/lib -lwrap -lcrypto
Libraries: -lm -lresolv -liksemel -lcurl -lnetsnmp

Enable proxy: yes
With database: Oracle
WEB Monitoring via: cURL
SNMP: net-snmp
IPMI: no
Linker flags: -L/usr/local/libsqlora8-2.3.3/lib -lsqlora8 -L/usr/kerberos/lib64 -lcurl -ldl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz -L/usr/lib64 -L/usr/lib64 -lnetsnmp -lcrypto -lm -L/usr/lib64/lib -lwrap -lcrypto -L/usr/lib64 -L/usr/lib64 -lnetsnmp -lcrypto -lm -L/usr/lib64/lib -lwrap -lcrypto
Libraries: -lm -lresolv -lcurl -lnetsnmp

Enable agent: yes
Linker flags:
Libraries: -lm -lresolv

LDAP support: no
IPv6 support: no

************************************************** *********
* Now run 'make install' *
* *
* Thank you for using ZABBIX! *
* <http://www.zabbix.com> *
************************************************** *********

When i do a service zabbix_server start , I get

Starting zabbix_server: /usr/local/sbin/zabbix_server: error while loading shared libraries: libsqlora8-2.3.so.0: cannot open shared object file: No such file or directory

The libsqlora8 directory shows:

LDSHSZABAPP01: root: /usr/local/libsqlora8-2.3.3/lib >

total 504
-rw-r--r-- 1 root root 0 Jul 1 17:33 libsqlora.log
drwxrwxrwx 3 zabbix root 4096 Jul 1 14:30 libsqlora8
lrwxrwxrwx 1 zabbix root 23 Jul 1 14:30 libsqlora8-2.3.so.0 -> libsqlora8-2.3.so.0.2.1
-rwxrwxrwx 1 zabbix root 182354 Jul 1 14:30 libsqlora8-2.3.so.0.2.1
-rwxrwxrwx 1 zabbix root 309728 Jul 1 14:30 libsqlora8.a
-rwxrwxrwx 1 zabbix root 917 Jul 1 14:30 libsqlora8.la
lrwxrwxrwx 1 zabbix root 23 Jul 1 14:30 libsqlora8.so -> libsqlora8-2.3.so.0.2.1
drwxrwxrwx 2 zabbix root 4096 Jul 1 14:30 pkgconfig

Anyone have any idea what I have done wrong or what exactly zabbix is trying to access ?

Thanks

Simon

[dotneft]

libsqlora:
./configure --enable-64bit && make && make install
without prefix install in /usr/local/lib/lib

and zabbix --with-oracle=/usr/local

[simonuk1]

thanks dotneft,
I still get the same error when i start up with service command but not when i run direct from sbin executable, also get server log file that way.
So getting closer!
Not sure about the server conf file for oracle?
Also having to install oci8 to get front end to work, you had any experience with that, not sure if have to change the php code to get it working!?
Any help would be much appreciated
A

[jquast]

You failed to mention your operating system. That information is very important in the context of dynamic linking.

Starting zabbix_server: /usr/local/sbin/zabbix_server: error while loading shared libraries: libsqlora8-2.3.so.0: cannot open shared object file: No such file or directory

On load, the OS is failing to locate the libsqlora8-2.3.so.0 file. On solaris, there is a search path for the runtime linker you can inspect using crle (configure runtime linking environment)

bash-3.00$ crle

Configuration file [version 4]: /var/ld/ld.config
Default Library Path (ELF): /lib:/usr/lib:/usr/local/lib:/usr/sfw/lib:/applications/mysql/mysql-5.0.67/lib/mysql
Trusted Directories (ELF): /lib/secure:/usr/lib/secure (system default)

Command line:
crle -c /var/ld/ld.config -l /lib:/usr/lib:/usr/local/lib:/usr/sfw/lib

If I wanted to add /usr/local/libsqlora8-2.3.3/lib to this search path, I would type:

bash-3.00$ crle -c /var/ld/ld.config -l /lib:/usr/lib:/usr/local/lib:/usr/sfw/lib:/usr/local/libsqlora8-2.3.3/lib

Linux and BSD have similar problems, and other solutions. Check the manual for ldd and the tools or config files in the SEE ALSO section.