So, setting LD_LIBRARY_PATH to /usr/local/lib should definetly help. Are you sure your did everything right? Try the following command (in one line): LD_LIBRARY_PATH=/usr/local/lib ldd /usr/local/lib/libignite-odbc.so
Best Regards, Igor On Wed, Jun 14, 2017 at 10:15 AM, Riccardo Iacomini < [email protected]> wrote: > As asked: > >> >> linux-vdso.so.1 => (0x00007ffca6776000) >> libignite-binary-2.0.0.19668.so.0 => not found >> libodbcinst.so.2 => /usr/lib/x86_64-linux-gnu/libodbcinst.so.2 >> (0x00007fb92ead4000) >> libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 >> (0x00007fb92e751000) >> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fb92e388000) >> libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007fb92e172000) >> libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 >> (0x00007fb92df67000) >> libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 >> (0x00007fb92dd4a000) >> libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fb92da41000) >> /lib64/ld-linux-x86-64.so.2 (0x0000560f6c5b0000) >> libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fb92d83c000) > > > > seems like libignite-binary is not found, but if you look at the directory > listing I previously posted, it should be there. > > > > Riccardo Iacomini > > > *RDSLab* > > On Tue, Jun 13, 2017 at 6:20 PM, Igor Sapego <[email protected]> wrote: > >> Well, try running the following command: >> ldd /usr/local/lib/libignite-odbc.so >> >> This may help us see which library can't be found. >> >> Best Regards, >> Igor >> >> On Tue, Jun 13, 2017 at 6:10 PM, Riccardo Iacomini < >> [email protected]> wrote: >> >>> Thank you for the reply Igor, >>> >>> the error just changed into: >>> >>> *pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open >>>> lib 'Apache Ignite' : file not found (0) (SQLDriverConnect)")* >>> >>> >>> >>> The Ignite Driver seems to be installed. Here's my /etc/odbcinst.ini : >>> >>> [Apache Ignite] >>>> Description=Apache Ignite >>>> Driver=/usr/local/lib/libignite-odbc.so >>>> Setup=/usr/local/lib/libignite-odbc.so >>>> DriverODBCVer=03.00 >>>> FileUsage=0 >>>> UsageCount=3 >>> >>> >>> >>> >>> Riccardo Iacomini >>> >>> >>> *RDSLab* >>> >>> On Tue, Jun 13, 2017 at 4:31 PM, Igor Sapego <[email protected]> >>> wrote: >>> >>>> Hi, >>>> >>>> Try adding /usr/local/lib/ to LD_LIBRARY_PATH evn variable. >>>> >>>> Best Regards, >>>> Igor >>>> >>>> On Tue, Jun 13, 2017 at 4:54 PM, Riccardo Iacomini < >>>> [email protected]> wrote: >>>> >>>>> Hello, >>>>> I am trying to access Ignite 2.0 using the ODBC driver. I've followed the >>>>> guide <https://apacheignite.readme.io/docs/odbc-driver>, and tried to >>>>> access Ignite via Python using the pyodbc module: >>>>> >>>>> >>>>>> *import pyodbc**ignite = pyodbc.connect('DRIVER={Apache >>>>>> Ignite};ADDRESS=localhost:10800;CACHE=cache1')* >>>>> >>>>> >>>>> however I get: >>>>> >>>>> *pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open >>>>>> lib '/usr/local/lib/libignite-odbc.so' : file not found (0) >>>>>> (SQLDriverConnect)")* >>>>> >>>>> >>>>> The library is instead located the path; this is the directory listing >>>>> of */usr/local/lib:* >>>>> >>>>> drwxr-xr-x 5 root root 4096 giu 13 15:26 ./ >>>>>> drwxr-xr-x 12 root root 4096 nov 22 2016 ../ >>>>>> lrwxrwxrwx 1 root root 37 giu 13 15:24 >>>>>> libignite-binary-2.0.0.19668.so.0 -> libignite-binary-2.0.0.19668.s >>>>>> o.0.0.0* >>>>>> -rwxr-xr-x 1 root root 1777000 giu 13 15:24 >>>>>> libignite-binary-2.0.0.19668.so.0.0.0* >>>>>> -rw-r--r-- 1 root root 4617182 giu 13 15:24 >>>>>> libignite-binary.a >>>>>> -rwxr-xr-x 1 root root 1089 giu 13 15:24 >>>>>> libignite-binary.la* >>>>>> lrwxrwxrwx 1 root root 37 giu 13 15:24 >>>>>> libignite-binary.so -> libignite-binary-2.0.0.19668.so.0.0.0* >>>>>> lrwxrwxrwx 1 root root 37 giu 13 15:24 >>>>>> libignite-common-2.0.0.19668.so.0 -> libignite-common-2.0.0.19668.s >>>>>> o.0.0.0* >>>>>> -rwxr-xr-x 1 root root 648856 giu 13 15:24 >>>>>> libignite-common-2.0.0.19668.so.0.0.0* >>>>>> -rw-r--r-- 1 root root 1493756 giu 13 15:24 >>>>>> libignite-common.a >>>>>> -rwxr-xr-x 1 root root 1054 giu 13 15:24 >>>>>> libignite-common.la* >>>>>> lrwxrwxrwx 1 root root 37 giu 13 15:24 >>>>>> libignite-common.so -> libignite-common-2.0.0.19668.so.0.0.0* >>>>>> lrwxrwxrwx 1 root root 35 giu 13 15:24 >>>>>> libignite-odbc-2.0.0.19668.so.0 -> libignite-odbc-2.0.0.19668.so. >>>>>> 0.0.0* >>>>>> -rwxr-xr-x 1 root root 6581160 giu 13 15:24 >>>>>> libignite-odbc-2.0.0.19668.so.0.0.0* >>>>>> -rw-r--r-- 1 root root 18307190 giu 13 15:24 libignite-odbc.a >>>>>> -rwxr-xr-x 1 root root 1121 giu 13 15:24 >>>>>> libignite-odbc.la* >>>>>> lrwxrwxrwx 1 root root 35 giu 13 15:24 >>>>>> libignite-odbc.so -> libignite-odbc-2.0.0.19668.so.0.0.0* >>>>>> -rw-rw-r-- 1 riccardo riccardo 46518354 feb 20 12:53 libntl.a >>>>>> -rwxr-xr-x 1 root root 966 giu 13 15:26 libodbccr.la* >>>>>> lrwxrwxrwx 1 root root 18 giu 13 15:26 libodbccr.so -> >>>>>> libodbccr.so.2.0.0* >>>>>> lrwxrwxrwx 1 root root 18 giu 13 15:26 libodbccr.so.2 >>>>>> -> libodbccr.so.2.0.0* >>>>>> -rwxr-xr-x 1 root root 507264 giu 13 15:26 >>>>>> libodbccr.so.2.0.0* >>>>>> -rwxr-xr-x 1 root root 1015 giu 13 15:26 libodbcinst.la* >>>>>> lrwxrwxrwx 1 root root 20 giu 13 15:26 libodbcinst.so >>>>>> -> libodbcinst.so.2.0.0* >>>>>> lrwxrwxrwx 1 root root 20 giu 13 15:26 >>>>>> libodbcinst.so.2 -> libodbcinst.so.2.0.0* >>>>>> -rwxr-xr-x 1 root root 463392 giu 13 15:26 >>>>>> libodbcinst.so.2.0.0* >>>>>> -rwxr-xr-x 1 root root 991 giu 13 15:26 libodbc.la* >>>>>> lrwxrwxrwx 1 root root 16 giu 13 15:26 libodbc.so -> >>>>>> libodbc.so.2.0.0* >>>>>> lrwxrwxrwx 1 root root 16 giu 13 15:26 libodbc.so.2 -> >>>>>> libodbc.so.2.0.0* >>>>>> -rwxr-xr-x 1 root root 2274544 giu 13 15:26 >>>>>> libodbc.so.2.0.0* >>>>>> drwxrwsr-x 4 root staff 4096 nov 29 2016 python2.7/ >>>>>> drwxrwsr-x 3 root staff 4096 ott 21 2015 python3.5/ >>>>>> drwxr-xr-x 3 root root 4096 giu 12 23:38 site_ruby/ >>>>> >>>>> >>>>> Any suggestion on how to procede? >>>>> >>>>> Thank you >>>>> >>>>> Riccardo Iacomini >>>>> >>>>> >>>>> *RDSLab* >>>>> >>>> >>>> >>> >> >
