Hi, Valeriana,
I don't see anything wrong with your setup to indicate why iodbctest->psqlodbc isn't working. I do know from troubleshooting odbc issues that there are combinations of managers and drivers that simply don't work. I have compiled a lot of updated documentation on odbc/database troubleshooting for the GT4.2 release which is relevant to you. You can find that here: http://www.globus.org/toolkit/docs/development/4.2-drafts/data/rls/admin/rls-admin-installing.html Another suggestion would be to upgrade your installation to GT4.0.5 and use the embedded database that now ships with RLS. It comes with the ODBC and Database libraries, so you don't have to configure as much. I think this would be the simplest approach. Rob From: Valeriana Roncero [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2008 9:17 AM To: [email protected]; Robert Schuler Subject: RE: [gt-user] idbctest error - RLS installation Hi Rob, Thanks for tour attention. Yes, but the error is the same: [EMAIL PROTECTED] bin]$ /usr/lib/bin/iodbctest "dsn=lrc1000;uid=globus;pwd=globus" iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0507.0105 1: SQLDriverConnect = client encoding mismatch (214) SQLSTATE=HY019 Have a nice day. With strace command: [EMAIL PROTECTED] bin]$ strace -eopen /usr/lib/bin/iodbctest "dsn=lrc1000;uid=globus;pwd=globus" open("/usr/local/globus-4.0.4/lib/tls/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/local/globus-4.0.4/lib/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/local/globus-4.0.4/lib/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/local/globus-4.0.4/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/tls/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/libdl.so.2", O_RDONLY) = 3 open("/usr/local/globus-4.0.4/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/globus-4.0.4/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/globus-4.0.4/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/globus-4.0.4/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 ... 1: SQLDriverConnect = client encoding mismatch (214) SQLSTATE=HY019 Have a nice day. [EMAIL PROTECTED] bin]$ ----------------------------------------------------- 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 Valeriana G. Roncero [EMAIL PROTECTED] Rio de Jaeiro - Brazil
