Print Page - nxagent 1.2.3.1 and unixodbc on ubuntu 10.10

Title: nxagent 1.2.3.1 and unixodbc on ubuntu 10.10
Post by: aron on September 24, 2012, 06:43:19 PM

Hello

Unfortunately I am experiencing issues getting unixodbc working correctly with nxagentd.

On load it is reporting the following issues;

1-Sep-2012 13:41:56] Subagent "/usr/lib/libnsm_logwatch.so" loaded successfully
[21-Sep-2012 13:41:56] Subagent "Linux" already loaded from module "/usr/local/lib/libnsm_linux.so"
[21-Sep-2012 13:41:56] Subagent "/usr/lib/libnsm_ecs.so" loaded successfully
[21-Sep-2012 13:41:56] Error loading subagent module "/usr/lib/libnsm_odbcquery.so": /usr/lib/libnsm_odbcquery.so: undefined symbol: SQLBindCol
[21-Sep-2012 13:41:57] External parameters providers poller thread will not start
[21-Sep-2012 13:41:57] Trying to bind on 0.0.0.0:4700

I have tested the ODBC deployment using isql and it correctly queries the DSN. Unfortunately I have been unsuccessful in working out if there is a dependancy issue. Version unixODBC 2.2.14. Sorry I am unsure which additional information will be constructive.

Regards

Aron

Title: Re: nxagent 1.2.3.1 and unixodbc on ubuntu 10.10
Post by: Victor Kirhenshtein on September 24, 2012, 06:59:58 PM

Hi!

Did you install agent from deb package or by compiling source? What is the output of

Code Select


ldd /usr/lib/libnsm_odbcquery.so

?

Best regards,
Victor

Title: Re: nxagent 1.2.3.1 and unixodbc on ubuntu 10.10
Post by: aron on September 24, 2012, 09:08:54 PM

Below is from package;

access@ubuntu:~$ sudo ldd /usr/lib/libnsm_odbcquery.so
[sudo] password for access:
linux-gate.so.1 => (0xb7829000)
libnetxms.so.1 => /usr/lib/libnetxms.so.1 (0xb77f3000)
libtre.so.5 => /usr/lib/libtre.so.5 (0xb77e3000)
libexpat.so.1 => /lib/libexpat.so.1 (0xb77bb000)
libz.so.1 => /lib/libz.so.1 (0xb77a6000)
libdl.so.2 => /lib/libdl.so.2 (0xb77a2000)
libcrypto.so.0.9.8 => /lib/libcrypto.so.0.9.8 (0xb7653000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb7639000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb754e000)
libm.so.6 => /lib/libm.so.6 (0xb7527000)
libc.so.6 => /lib/libc.so.6 (0xb73ca000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb73ae000)
/lib/ld-linux.so.2 (0xb782a000)

Below built from the svn trunk;
sudo ./configure --with-agent --with-odbc --prefix=/usr

access@ubuntu:/usr/lib$ sudo ldd /usr/lib/libnsm_odbcquery.so
linux-gate.so.1 => (0xb7840000)
libnetxms.so.1 => /usr/lib/libnetxms.so.1 (0xb7809000)
libdl.so.2 => /lib/libdl.so.2 (0xb7805000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb77ea000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb76ff000)
libm.so.6 => /lib/libm.so.6 (0xb76d9000)
libc.so.6 => /lib/libc.so.6 (0xb757c000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7560000)
libnxexpat.so.1 => /usr/lib/libnxexpat.so.1 (0xb7540000)
libnxtre.so.5 => /usr/lib/libnxtre.so.5 (0xb752f000)
/lib/ld-linux.so.2 (0xb7841000)

[24-Sep-2012 19:07:36] Subagent "/usr/lib/libnsm_ping.so" loaded successfully
[24-Sep-2012 19:07:37] Subagent "/usr/lib/libnsm_logwatch.so" loaded successfully
[24-Sep-2012 19:07:37] Subagent "Linux" already loaded from module "/usr/lib/libnsm_linux.so"
[24-Sep-2012 19:07:37] Subagent "/usr/lib/libnsm_ecs.so" loaded successfully
[24-Sep-2012 19:07:37] Error loading subagent module "/usr/lib/libnsm_odbcquery.so": /usr/lib/libnsm_odbcquery.so: undefined symbol: SQLFetch

Best Regards

Aron

Title: Re: nxagent 1.2.3.1 and unixodbc on ubuntu 10.10
Post by: Victor Kirhenshtein on September 24, 2012, 10:36:46 PM

Hi!

Yes, there was an error in the makefile for odbcquery subagent. Current svn trunk contains fixed version.

Best regards,
Victor

Title: Re: nxagent 1.2.3.1 and unixodbc on ubuntu 10.10
Post by: aron on September 25, 2012, 03:17:35 AM

Hello,

Thank you that has worked :)

Many Thanks

Aron

NetXMS Support Forum

English Support => General Support => Topic started by: aron on September 24, 2012, 06:43:19 PM