nxagent 1.2.3.1 and unixodbc on ubuntu 10.10

[aron]

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

[victor]

Hi!

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

ldd /usr/lib/libnsm_odbcquery.so

?

Best regards,
Victor

[aron]

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

[victor]

Hi!

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

Best regards,
Victor

[aron]

Hello,

Thank you that has worked

Many Thanks

Aron