Thread: psqlodbcw.so symbol lookup errors
installed postgresql-devel-8.1.23-1.el5_6.1.x86_64.rpm
(note if I try to ./configure --with-libpq=/usr/lib64/libpq it fails with specified pg_config not found although it is in /usr/bin/)
installed psqlodbc-08.04.0200 from source
[toz@~]$ /usr/lib/libiodbc<TAB>
libiodbcinst.so.2 libiodbcinst.so.2.1.18 libiodbc.so.2 libiodbc.so.2.1.18
[toz@~]$ /usr/lib/libodbc<TAB>
libodbccr.so libodbcdrvcfg2S.so.1 libodbcminiS.so.1.0.0 libodbcpsql.so libodbcpsqlS.so.1.0.0
libodbccr.so.1 libodbcdrvcfg2S.so.1.0.0 libodbcmyS.so libodbcpsql.so.1 libodbc.so
libodbccr.so.1.0.0 libodbcinst.so libodbcmyS.so.1 libodbcpsql.so.1.0.0 libodbc.so.1
libodbcdrvcfg1S.so libodbcinst.so.1 libodbcmyS.so.1.0.0 libodbcpsql.so.2 libodbc.so.1.0.0
libodbcdrvcfg1S.so.1 libodbcinst.so.1.0.0 libodbcnnS.so libodbcpsql.so.2.0.0 libodbctxtS.so
libodbcdrvcfg1S.so.1.0.0 libodbcminiS.so libodbcnnS.so.1 libodbcpsqlS.so libodbctxtS.so.1
libodbcdrvcfg2S.so libodbcminiS.so.1 libodbcnnS.so.1.0.0 libodbcpsqlS.so.1 libodbctxtS.so.1.0.0
---------------------------------------
[toz@~]$ /usr/lib64/libodbc<64>
libodbccr.so libodbcdrvcfg2S.so.1 libodbcminiS.so.1.0.0 libodbcpsql.so libodbcpsqlS.so.1.0.0
libodbccr.so.1 libodbcdrvcfg2S.so.1.0.0 libodbcmyS.so libodbcpsql.so.1 libodbc.so
libodbccr.so.1.0.0 libodbcinst.so libodbcmyS.so.1 libodbcpsql.so.1.0.0 libodbc.so.1
libodbcdrvcfg1S.so libodbcinst.so.1 libodbcmyS.so.1.0.0 libodbcpsql.so.2 libodbc.so.1.0.0
libodbcdrvcfg1S.so.1 libodbcinst.so.1.0.0 libodbcnnS.so libodbcpsql.so.2.0.0 libodbctxtS.so
libodbcdrvcfg1S.so.1.0.0 libodbcminiS.so libodbcnnS.so.1 libodbcpsqlS.so libodbctxtS.so.1
libodbcdrvcfg2S.so libodbcminiS.so.1 libodbcnnS.so.1.0.0 libodbcpsqlS.so.1 libodbctxtS.so.1.0.0
---------------------------------------
[toz@~]$ cat /etc/odbc.ini
[ODBC Data Sources]
PostgreSQL = PostgreSQL
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/local/lib/psqlodbcw.so
Database = wellness
[ODBC]
InstallDir=/usr/local/lib
[Default]
Driver = /usr/lib64/libodbcpsql.so
---------------------------------------
[toz@~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.7 (Tikanga)
---------------------------------------
[~]$ cat .bash_profile
export ODBCSYSINI=/etc
export ODBCINI=/etc/odbc.ini
export LD_LIBRARY_PATH=/usr/local/lib
---------------------------------------
[psqlodbc-08.04.0200]$ LD_DEBUG=libs isql PostgreSQL
30006: find library=libodbc.so.1 [0]; searching
30006: search path=/usr/local/lib/tls/x86_64:/usr/local/lib/tls:/usr/local/lib/x86_64:/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/tls/x86_64/libodbc.so.1
30006: trying file=/usr/local/lib/tls/libodbc.so.1
30006: trying file=/usr/local/lib/x86_64/libodbc.so.1
30006: trying file=/usr/local/lib/libodbc.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/usr/lib64/libodbc.so.1
30006:
30006: find library=libodbcinst.so.1 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libodbcinst.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/usr/lib64/libodbcinst.so.1
30006:
30006: find library=libdl.so.2 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libdl.so.2
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libdl.so.2
30006:
30006: find library=libpthread.so.0 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libpthread.so.0
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libpthread.so.0
30006:
30006: find library=libc.so.6 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libc.so.6
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libc.so.6
30006:
30006:
30006: prelink checking: ok
30006:
30006: calling init: /lib64/libpthread.so.0
30006:
30006:
30006: calling init: /lib64/libc.so.6
30006:
30006:
30006: calling init: /lib64/libdl.so.2
30006:
30006:
30006: calling init: /usr/lib64/libodbcinst.so.1
30006:
30006:
30006: calling init: /usr/lib64/libodbc.so.1
30006:
30006:
30006: initialize program: isql
30006:
30006:
30006: transferring control: isql
30006:
30006: find library=libnss_files.so.2 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libnss_files.so.2
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libnss_files.so.2
30006:
30006:
30006: calling init: /lib64/libnss_files.so.2
30006:
30006:
30006: calling init: /usr/lib64/gconv/ISO8859-1.so
30006:
30006: /usr/lib64/gconv/ISO8859-1.so: error: symbol lookup error: undefined symbol: gconv_end (fatal)
30006: find library=libssl.so.6 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libssl.so.6
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libssl.so.6
30006:
30006: find library=libpq.so.4 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libpq.so.4
30006: search cache=/etc/ld.so.cache
30006: trying file=/usr/lib64/libpq.so.4
30006:
30006: find library=libgssapi_krb5.so.2 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libgssapi_krb5.so.2
30006: search cache=/etc/ld.so.cache
30006: trying file=/usr/lib64/libgssapi_krb5.so.2
30006:
30006: find library=libkrb5.so.3 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libkrb5.so.3
30006: search cache=/etc/ld.so.cache
30006: trying file=/usr/lib64/libkrb5.so.3
30006:
30006: find library=libcom_err.so.2 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libcom_err.so.2
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libcom_err.so.2
30006:
30006: find library=libk5crypto.so.3 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libk5crypto.so.3
30006: search cache=/etc/ld.so.cache
30006: trying file=/usr/lib64/libk5crypto.so.3
30006:
30006: find library=libcrypto.so.6 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libcrypto.so.6
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libcrypto.so.6
30006:
30006: find library=libz.so.1 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libz.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libz.so.1
30006:
30006: find library=libcrypt.so.1 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libcrypt.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libcrypt.so.1
30006:
30006: find library=libresolv.so.2 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libresolv.so.2
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libresolv.so.2
30006:
30006: find library=libnsl.so.1 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libnsl.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libnsl.so.1
30006:
30006: find library=libkrb5support.so.0 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libkrb5support.so.0
30006: search cache=/etc/ld.so.cache
30006: trying file=/usr/lib64/libkrb5support.so.0
30006:
30006: find library=libkeyutils.so.1 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libkeyutils.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libkeyutils.so.1
30006:
30006: find library=libselinux.so.1 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libselinux.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libselinux.so.1
30006:
30006: find library=libsepol.so.1 [0]; searching
30006: search path=/usr/local/lib (LD_LIBRARY_PATH)
30006: trying file=/usr/local/lib/libsepol.so.1
30006: search cache=/etc/ld.so.cache
30006: trying file=/lib64/libsepol.so.1
30006:
30006:
30006: calling init: /lib64/libsepol.so.1
30006:
30006:
30006: calling init: /lib64/libselinux.so.1
30006:
30006:
30006: calling init: /lib64/libkeyutils.so.1
30006:
30006:
30006: calling init: /lib64/libresolv.so.2
30006:
30006:
30006: calling init: /usr/lib64/libkrb5support.so.0
30006:
30006:
30006: calling init: /lib64/libnsl.so.1
30006:
30006:
30006: calling init: /lib64/libcrypt.so.1
30006:
30006:
30006: calling init: /lib64/libz.so.1
30006:
30006:
30006: calling init: /lib64/libcrypto.so.6
30006:
30006:
30006: calling init: /usr/lib64/libk5crypto.so.3
30006:
30006:
30006: calling init: /lib64/libcom_err.so.2
30006:
30006:
30006: calling init: /usr/lib64/libkrb5.so.3
30006:
30006:
30006: calling init: /usr/lib64/libgssapi_krb5.so.2
30006:
30006:
30006: calling init: /lib64/libssl.so.6
30006:
30006:
30006: calling init: /usr/lib64/libpq.so.4
30006:
30006:
30006: calling init: /usr/local/lib/psqlodbcw.so
30006:
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDriverLoad (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDriverUnload (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLAllocConnect (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLAllocEnv (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLAllocStmt (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLAllocHandleStd (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLBrowseConnectA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLColAttributeA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLColAttributes (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLColAttributesA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLColAttributesW (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLColumnPrivilegesA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLColumnsA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLConnectA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDataSourcesA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDescribeColA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDriverConnectA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDrivers (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDriversA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLDriversW (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLError (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLErrorA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLErrorW (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLExecDirectA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLForeignKeysA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLFreeEnv (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLFreeConnect (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetConnectAttrA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetConnectOption (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetConnectOptionA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetConnectOptionW (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetCursorNameA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetDescFieldA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetDescRecA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetDescRecW (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetDiagFieldA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetInfoA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetStmtAttrA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetStmtOption (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetTypeInfoA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLNativeSqlA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLParamOptions (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLPrepareA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLPrimaryKeysA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLProcedureColumnsA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLProceduresA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetConnectAttrA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetConnectOption (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetConnectOptionA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetConnectOptionW (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetCursorNameA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetDescFieldA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetScrollOptions (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetStmtAttrA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSetStmtOption (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLSpecialColumnsA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLStatisticsA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLTablePrivilegesA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLTablesA (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLTransact (fatal)
30006: /usr/local/lib/psqlodbcw.so: error: symbol lookup error: undefined symbol: SQLGetDiagRecA (fatal)
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>