NetXMS Support Forum

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

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

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

Hi!

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

Best regards,
Victor

Hello,

Thank you that has worked

Many Thanks

Aron