psqlodbcw.so symbol lookup errors

Поиск
Список
Период
Сортировка
От Talha OZ
Тема psqlodbcw.so symbol lookup errors
Дата
Msg-id CAPDXT+-LZVae-tZT5fC-Z3xtpzWwiZCRQfGrmzqTUqSwm3myqg@mail.gmail.com
обсуждение исходный текст
Список pgsql-odbc
Дерево обсуждения
isql works with the following errors.
stata fails to connect which I believe because of the errors.
how can I fix these errors?
Thanks !


Here is some info about the installed libraries and configuration:

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> 




-Talha

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Washington Leung
Дата:
Сообщение: Re: Local SQL connection PsotgreSQL in cloud
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Pgodbc is thread safe？