No matter how I change the netxmsd.conf file I get some variation of:
# /usr/bin/nxdbmgr init /usr/share/netxms/sql/dbinit_mysql.sql
NetXMS Database Manager Version 1.2.1
Unable to load and initialize database driver "/usr/lib/libnxddr_mysql.so"
I have tried the following for the driver line:
DBDriver = /usr/lib/libnxddr_mysql.so
DBDriver = mysql.ddr
DBDriver = /usr/lib/netxms/dbdrv/mysql.ddr
All of them produce a varion of the unable to load message based on the driver name.
I can login to MySQL server using:
# mysql -h localhost -u netxms -p netxms
This is basically a fresh / patched installation of 64 bit Ubuntu 12.04 and then added the following packages:
apt-get install libssl0.9.8 libtre5 libreadline5 mysql-server mysql-client
dpkg -i base
dpkg -i agent
dpkg -i server
dpkg -i server-mysql
It is definitely related to the library though. If I change the config to use the sqlite library then everything runs fine. Of course do not want to use this, so need the mysql solution. Will probably try downloading and installing library from source.
Stuck, please help.
Can you show me please output of
ldd /usr/lib/libnxddr_mysql.so
?
Best regards,
Victor
Here it is:
# ldd /usr/lib/libnxddr_mysql.so
linux-vdso.so.1 => (0x00007fffa33d8000)
libnetxms.so.1 => /usr/lib/libnetxms.so.1 (0x00007fa5e1d9a000)
libmysqlclient.so.16 => not found
libtre.so.5 => /usr/lib/libtre.so.5 (0x00007fa5e1b89000)
libexpat.so.1 => /lib/x86_64-linux-gnu/libexpat.so.1 (0x00007fa5e195f000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fa5e1748000)
libreadline.so.5 => /lib/x86_64-linux-gnu/libreadline.so.5 (0x00007fa5e1509000)
libncurses.so.5 => /lib/x86_64-linux-gnu/libncurses.so.5 (0x00007fa5e12e8000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fa5e10e4000)
libcrypto.so.0.9.8 => /lib/x86_64-linux-gnu/libcrypto.so.0.9.8 (0x00007fa5e0d56000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fa5e0b39000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007fa5e0839000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fa5e053e000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fa5e0181000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007fa5dff6b000)
libtinfo.so.5 => /lib/x86_64-linux-gnu/libtinfo.so.5 (0x00007fa5dfd43000)
/lib64/ld-linux-x86-64.so.2 (0x00007fa5e21d5000)
which of course shows no link to the libmysqlclient (18 is current for 12.04). I ran the following command:
ln -s /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0 /usr/lib/x86_64-linux-gnu/libmysqlclient.so.16
I was then able to properly use the MySQL driver and load the database! Thanks for the push in the right direction. This tool looks awesome and I cannot wait to play with it more.