[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

José Luis Murcia Esquiva
Hi,

I have an VPS with CentOS 7 x64 Finale. It came with unixODBC x64 package installed (for managing VPS's mysql). It came with perl x64, too.

Now I need to connect to a SQL Server R2 database. I was able to do it with FreeTDS and unixODBC (both x64) through isql. But, since my final goal is to connect that database to WebGUI (a perl-based CMS which has its own 32-bit perl), I must do the same in 32-bit.

So, I've installed (using yum) the following:
unixODBC-2.2.14-14.el6.i686
freetds-0.91-2.el6.i686 <- I deleted the previous x64 version

mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 <- it came with the VPS
plesk-php56-odbc-5.6.16-centos6.15120116.x86_64 <- it came with the VPS
unixODBC-2.2.14-14.el6.x86_64 <- it came with the VPS

file /usr/bin/odbcinst <- tells it's a 64-bit executable
file /usr/local/bin/odbcinst <- tells it's a 64-bit executable

Output for odbcinst -j
unixODBC 2.3.4
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

/usr/local/etc/odbcinst.ini

[ODBC]
Trace=Yes
TraceFile=/tmp/sql.log
ForceTrace=Yes

[FreeTDS]
Description=v0.95.73
Driver=/usr/lib/libtdsodbc.so.0.0.0
UsageCount=1

/usr/local/etc/odbc.ini
[DSN]
Description=DNS description
Driver=/usr/lib/libtdsodbc.so.0.0.0
Server=XX.XX.XX.XX
Database=myDatabase
Port=1433 #sql server default port
TDS_Version=7.3

Output for ldd /usr/lib/libtdsodbc.so.0.0.0
linux-gate.so.1 =>  (0xb77a1000)
libodbcinst.so.2 => /usr/lib/libodbcinst.so.2 (0xb7729000)
libgssapi_krb5.so.2 => /lib/libgssapi_krb5.so.2 (0xb76de000)
libgnutls.so.26 => /usr/lib/libgnutls.so.26 (0xb7632000)
librt.so.1 => /lib/librt.so.1 (0xb7629000)
libgcrypt.so.11 => /lib/libgcrypt.so.11 (0xb75ac000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb7591000)
libc.so.6 => /lib/libc.so.6 (0xb73fa000)
libltdl.so.7 => /usr/lib/libltdl.so.7 (0xb73f0000)
libkrb5.so.3 => /lib/libkrb5.so.3 (0xb7313000)
libk5crypto.so.3 => /lib/libk5crypto.so.3 (0xb72e8000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0xb72e2000)
libkrb5support.so.0 => /lib/libkrb5support.so.0 (0xb72d6000)
libdl.so.2 => /lib/libdl.so.2 (0xb72d1000)
libkeyutils.so.1 => /lib/libkeyutils.so.1 (0xb72cd000)
libresolv.so.2 => /lib/libresolv.so.2 (0xb72b3000)
libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0xb72a0000)
libz.so.1 => /lib/libz.so.1 (0xb728c000)
/lib/ld-linux.so.2 (0xb77a2000)
libgpg-error.so.0 => /lib/libgpg-error.so.0 (0xb7287000)
libselinux.so.1 => /lib/libselinux.so.1 (0xb7268000)

Output for  echo$LD_LIBRARY_PATH
:/usr/lib/

isql DSN -v
Returns the error displayer at the subject field of this e-mail.

What am I missing?
Thanks in advance.
Regards

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

Nick Gorham-2
On 11/12/15 13:06, José Luis Murcia Esquiva wrote:

> Hi,
>
> I have an VPS with CentOS 7 x64 Finale. It came with unixODBC x64
> package installed (for managing VPS's mysql). It came with perl x64, too.
>
> Now I need to connect to a SQL Server R2 database. I was able to do it
> with FreeTDS and unixODBC (both x64) through isql. But, since my final
> goal is to connect that database to WebGUI (a perl-based CMS which has
> its own 32-bit perl), I must do the same in 32-bit.
>
> So, I've installed (using yum) the following:
> unixODBC-2.2.14-14.el6.i686
> freetds-0.91-2.el6.i686 <- I deleted the previous x64 version
>
> mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 <- it came with the VPS
> plesk-php56-odbc-5.6.16-centos6.15120116.x86_64 <- it came with the VPS
> unixODBC-2.2.14-14.el6.x86_64 <- it came with the VPS
>
> file /usr/bin/odbcinst <- tells it's a 64-bit executable
> file /usr/local/bin/odbcinst <- tells it's a 64-bit executable

Well, you will need a 32 bit unixODBC at the least.

--
Nick
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

José Luis Murcia Esquiva
Already installed unixODBC-2.2.14-14.el6.i686



2015-12-11 14:44 GMT+01:00 Nick Gorham <[hidden email]>:
On 11/12/15 13:06, José Luis Murcia Esquiva wrote:
Hi,

I have an VPS with CentOS 7 x64 Finale. It came with unixODBC x64 package installed (for managing VPS's mysql). It came with perl x64, too.

Now I need to connect to a SQL Server R2 database. I was able to do it with FreeTDS and unixODBC (both x64) through isql. But, since my final goal is to connect that database to WebGUI (a perl-based CMS which has its own 32-bit perl), I must do the same in 32-bit.

So, I've installed (using yum) the following:
unixODBC-2.2.14-14.el6.i686
freetds-0.91-2.el6.i686 <- I deleted the previous x64 version

mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 <- it came with the VPS
plesk-php56-odbc-5.6.16-centos6.15120116.x86_64 <- it came with the VPS
unixODBC-2.2.14-14.el6.x86_64 <- it came with the VPS

file /usr/bin/odbcinst <- tells it's a 64-bit executable
file /usr/local/bin/odbcinst <- tells it's a 64-bit executable

Well, you will need a 32 bit unixODBC at the least.

--
Nick
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

Nick Gorham-2
On 11/12/15 13:47, José Luis Murcia Esquiva wrote:
> Already installed unixODBC-2.2.14-14.el6.i686

Well, you need to find where its installed and use that,

> file /usr/bin/odbcinst <- tells it's a 64-bit executable

Would indicate its not been replaced.

--
Nick
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

José Luis Murcia Esquiva
The x64 version came with the VPS. The problem is that I can't get rid of it because it's used bu the VPS to manage its connections with mysql.

I need a way to use the i686 version (which I know it's installed). I know it's such a weird thing... :/

2015-12-11 14:51 GMT+01:00 Nick Gorham <[hidden email]>:
On 11/12/15 13:47, José Luis Murcia Esquiva wrote:
Already installed unixODBC-2.2.14-14.el6.i686

Well, you need to find where its installed and use that,

file /usr/bin/odbcinst <- tells it's a 64-bit executable

Would indicate its not been replaced.


--
Nick
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

Nick Gorham-2
On 11/12/15 13:56, José Luis Murcia Esquiva wrote:
> The x64 version came with the VPS. The problem is that I can't get rid
> of it because it's used bu the VPS to manage its connections with mysql.
>
> I need a way to use the i686 version (which I know it's installed). I
> know it's such a weird thing... :/

Setting PATH and LD_LIBRARY_PATH is probably the solution

--
Nick
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

José Luis Murcia Esquiva
Output for  echo$LD_LIBRARY_PATH
:/usr/lib/

It's already set. It would be helpful to execute the isql provided by the i686 package

2015-12-11 15:00 GMT+01:00 Nick Gorham <[hidden email]>:
On 11/12/15 13:56, José Luis Murcia Esquiva wrote:
The x64 version came with the VPS. The problem is that I can't get rid of it because it's used bu the VPS to manage its connections with mysql.

I need a way to use the i686 version (which I know it's installed). I know it's such a weird thing... :/

Setting PATH and LD_LIBRARY_PATH is probably the solution


--
Nick
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

Nick Gorham-2
On 11/12/15 18:34, José Luis Murcia Esquiva wrote:
Output for  echo$LD_LIBRARY_PATH
:/usr/lib/


Yes, you need to set PATH so it finds the 32 bit isql first, and LD_LIBRARY_PATH so it finds the 32 bit libs first.

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

José Luis Murcia Esquiva
Still only able to connect through x64...

This is the output for the command  env
HOSTNAME=my.hostname.com
TERM=cygwin
SHELL=/bin/bash
HISTSIZE=1000
SSH_CLIENT= mySSHClient
SSH_TTY=/dev/pts/0
USER=root
LD_LIBRARY_PATH=/usr/local/lib  <- Also tried /usr/lib
LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
MAIL=/var/spool/mail/root
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/lib/:/root/bin
PWD=/data/wre/prereqs/bin
LANG=C
HISTCONTROL=ignoredups
SHLVL=1
HOME=/root
LOGNAME=root
CVS_RSH=ssh
SSH_CONNECTION= mySSHConnection
LESSOPEN=||/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES=1
_=/bin/env
OLDPWD=/usr/lib64



2015-12-11 22:16 GMT+01:00 Nick Gorham <[hidden email]>:
On 11/12/15 18:34, José Luis Murcia Esquiva wrote:
Output for  echo$LD_LIBRARY_PATH
:/usr/lib/


Yes, you need to set PATH so it finds the 32 bit isql first, and LD_LIBRARY_PATH so it finds the 32 bit libs first.

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support



_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0.0.0' : file not found

Nick Gorham-2
On 14/12/15 13:10, José Luis Murcia Esquiva wrote:
> Still only able to connect through x64...

Its not strictly a unixODBC problem, you need to setup your system so
that the 32 bit isql will load the 32 bit unixODBC libs, then when it
loads the 32 bit driver, the driver can find what 32 bit libs it needs.

Use ldd to see what it all depends on and whats missing

ldd /path/to/32bit/isql

ldd /path/to/32bit/driver.so

If needed use strace to see what libs its actually loading at run time.

--
Nick
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support