Hi, Valeriana,
I didn't see you issue the test command of the form:
iodbctest "DSN=xxxx;UID=xxxx;PWD=xxxx"
Have you tried that?
rob
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Valeriana Roncero
Sent: Wed 3/5/2008 5:58 PM
To: gt-user
Subject: [gt-user] idbctest error - RLS installation
Dear all:
I have a problem to configure RLS in my system.
GT 4.0.4, CentOS 4.4, PostgreSQL 8.2.4
[EMAIL PROTECTED] ~]# uname -a
Linux host 2.6.9-42.EL #1 Sat Aug 12 09:17:58 CDT 2006 i686 i686 i386 GNU/Linux
[EMAIL PROTECTED] ~]# getconf GNU_LIBC_VERSION
glibc 2.3.4
------------------------------------
[EMAIL PROTECTED] libiodbc-3.52.5]# ./configure --prefix=/usr/lib
--disable-gtktest --enable-pthreads --disable-gui --with-iodbc-inidir=/etc
iODBC Driver Manager 3.52.5 configuration summary
=================================================
Installation variables
layout default
prefix /usr/lib
exec_prefix ${prefix}
Installation paths
programs ${exec_prefix}/bin
include files ${prefix}/include
libraries ${exec_prefix}/lib
manual pages ${prefix}/man
Configuration files
odbc.ini /etc/odbc.ini
odbcinst.ini /etc/odbcinst.ini
default FILEDSN path /etc/ODBCDataSources
Extensions
ODBC Version 3
GUI Extensions false
ThreadSafe true
Install libodbc.so true
-------------------------------------------------
RPM packages: postgresql-odbc.i386 0:7.3-8.RHEL4.1 and
unixODBC-2.2.11-1.RHEL4.1
[EMAIL PROTECTED] etc]$ rpm -ql unixODBC
/etc/odbc.ini
/etc/odbcinst.ini
/usr/bin/dltest
/usr/bin/isql
/usr/bin/iusql
/usr/bin/odbc_config
/usr/bin/odbcinst
/usr/lib/libboundparam.so.1
/usr/lib/libboundparam.so.1.0.0
/usr/lib/libesoobS.so.1
/usr/lib/libesoobS.so.1.0.0
/usr/lib/libgtrtst.so.1
/usr/lib/libgtrtst.so.1.0.0
/usr/lib/libmimerS.so.1
/usr/lib/libmimerS.so.1.0.0
/usr/lib/libnn.so.1
/usr/lib/libnn.so.1.0.0
/usr/lib/libodbc.so
/usr/lib/libodbc.so.1
/usr/lib/libodbc.so.1.0.0
/usr/lib/libodbccr.so.1
/usr/lib/libodbccr.so.1.0.0
/usr/lib/libodbcdrvcfg1S.so.1
/usr/lib/libodbcdrvcfg1S.so.1.0.0
/usr/lib/libodbcdrvcfg2S.so.1
/usr/lib/libodbcdrvcfg2S.so.1.0.0
/usr/lib/libodbcinst.so.1
/usr/lib/libodbcinst.so.1.0.0
/usr/lib/libodbcminiS.so.1
/usr/lib/libodbcminiS.so.1.0.0
/usr/lib/libodbcmyS.so
/usr/lib/libodbcmyS.so.1
/usr/lib/libodbcmyS.so.1.0.0
/usr/lib/libodbcnnS.so.1
/usr/lib/libodbcnnS.so.1.0.0
/usr/lib/libodbcpsql.so
/usr/lib/libodbcpsql.so.1
/usr/lib/libodbcpsql.so.1.0.0
/usr/lib/libodbcpsql.so.2
/usr/lib/libodbcpsql.so.2.0.0
/usr/lib/libodbcpsqlS.so
/usr/lib/libodbcpsqlS.so.1
/usr/lib/libodbcpsqlS.so.1.0.0
/usr/lib/libodbctxt.so.1
/usr/lib/libodbctxt.so.1.0.0
/usr/lib/libodbctxtS.so.1
/usr/lib/libodbctxtS.so.1.0.0
/usr/lib/liboplodbcS.so.1
/usr/lib/liboplodbcS.so.1.0.0
/usr/lib/liboraodbcS.so.1
/usr/lib/liboraodbcS.so.1.0.0
/usr/lib/libsapdbS.so.1
/usr/lib/libsapdbS.so.1.0.0
/usr/lib/libtdsS.so.1
/usr/lib/libtdsS.so.1.0.0
/usr/lib/libtemplate.so.1
/usr/lib/libtemplate.so.1.0.0
/usr/share/doc/unixODBC-2.2.11
....
---------------------------------------------------------
Environment Variables:
LD_LIBRARY_PATH=/usr/local/pgsql/lib
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=/usr/local/pgsql/man:$MANPATH
PGDATA=/usr/local/pgsql/data
GLOBUS_LOCATION=/usr/local/globus-4.0.4
ANT_HOME=/usr/local/ant/dist
JAVA_HOME=/usr/local/java/jdk1.5.0_11
GLOBUS_IODBC_PATH=/usr/lib
ODBCINIDIR=
ODBCINI=/etc/odbc.ini
CLASSPATH=$CLASSPATH:/usr/local/junit/junit-4.1.jar:/usr/local/junit
PATH=$PATH:$JAVA_HOME/bin:$ANT_HOME/bin:/usr/local/globus-4.0.4/bin:/usr/local/globus-4.0.4/sbin
------------------------------------------------------------------------------------------------
File: odbc.ini
[EMAIL PROTECTED] ~]# cat /etc/odbc.ini
; Digitado em 4 de marco de 2008
; Para o psqlodbc
; Banco de dados LRC e RLI como lrc1000 e rli1000
[ODBC Data Sources]
lrc1000=lrc database
rli1000=rli database
[lrc1000]
Description=LRC database
Driver=/usr/lib/psqlodbc.so
DSN=lrc1000
Servertype=postgres
Servername=host
Database=lrc1000
UserName=globus ;usuario que acessa o banco de dados
ReadOnly=no
[rli1000]
Description=RLI database
Driver=/usr/lib/psqlodbc.so
DSN=rli1000
Servertype=postgres
Servername=host
Database=rli1000
UserName=globus ;usuario que acessa o banco de dados
ReadOnly=no
[Default]
Driver=/usr/lib/psqlodbc.so
Port=5432
----------------------------------------------------------------------------
[EMAIL PROTECTED] etc]$ cd /usr/lib/bin
[EMAIL PROTECTED] bin]$ ./iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0507.0105
Enter ODBC connect string (? shows list):
DSN | Driver
------------------------------------------------------------------------------
lrc1000 | lrc database
rli1000 | rli database
Enter ODBC connect string (? shows list): \q
1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no
default driver specified. Driver could not be loaded (0) SQLSTATE=IM002
1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no
default driver specified. Driver could not be loaded (0) SQLSTATE=IM002
Have a nice day
==> Test with the command strace:
[EMAIL PROTECTED] bin]$ strace -eopen ./iodbctest
open("/usr/local/pgsql/lib/tls/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/local/pgsql/lib/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/usr/local/pgsql/lib/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/local/pgsql/lib/libdl.so.2", O_RDONLY) = 3
open("/usr/local/pgsql/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/tls/i686/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/tls/libc.so.6", O_RDONLY) = 3
open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = 3
iODBC Demonstration program
This program shows an interactive SQL processor
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
Driver Manager: 03.52.0507.0105
Enter ODBC connect string (? shows list):
DSN | Driver
------------------------------------------------------------------------------
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
lrc1000 | lrc database
rli1000 | rli database
Enter ODBC connect string (? shows list): \q
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no
default driver specified. Driver could not be loaded (0) SQLSTATE=IM002
1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no
default driver specified. Driver could not be loaded (0) SQLSTATE=IM002
---------------------------------
But these files aren´t found:
/lib/tls/libc.so.6
/lib/libdl-2.3.4.so
/lib/libdl.so.2
I don´t where can I change the path to iodbctest find them.
======================================================================================
Another test:
[EMAIL PROTECTED] bin]$ strace -eopen ./iodbctest
"dsn=lrc1000;uid=globus;pwd=globus"
open("/usr/local/pgsql/lib/tls/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/local/pgsql/lib/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/usr/local/pgsql/lib/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/usr/local/pgsql/lib/libdl.so.2", O_RDONLY) = 3
open("/usr/local/pgsql/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/tls/i686/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/tls/libc.so.6", O_RDONLY) = 3
open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = 3
iODBC Demonstration program
This program shows an interactive SQL processor
open("/etc/odbc.ini", O_RDONLY) = 3
Driver Manager: 03.52.0507.0105
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbcinst.ini", O_RDONLY) = 3
open("/usr/lib/psqlodbc.so", O_RDONLY) = 3
open("/usr/local/pgsql/lib/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/lib/tls/i686/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/tls/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/i686/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such file
or directory)
open("/usr/lib/tls/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/usr/lib/i686/libodbcinst.so.1", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/usr/lib/libodbcinst.so.1", O_RDONLY) = 3
open("/usr/local/pgsql/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/lib/tls/i686/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/tls/libpthread.so.0", O_RDONLY) = 3
open("/etc/odbcinst.ini", O_RDONLY) = 3
open("/etc/nsswitch.conf", O_RDONLY) = 3
open("/usr/local/pgsql/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such
file or directory)
open("/lib/tls/i686/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/tls/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/i686/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or
directory)
open("/lib/libnss_files.so.2", O_RDONLY) = 3
open("/etc/passwd", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission
denied)
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbcinst.ini", O_RDONLY) = 3
open("/etc/passwd", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission
denied)
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/passwd", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission
denied)
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/localtime", O_RDONLY) = 4
1: SQLDriverConnect = client encoding mismatch (214) SQLSTATE=HY019
Have a nice day.
---------------------------------------------------------
Thanks in advance.
Valeriana G. Roncero
[EMAIL PROTECTED]
Rio de Janeiro - Brazil
