Yes, I've set the env variable, globally in /etc/environment. Just for completeness, I am running Ubuntu 16.04.
Best Riccardo Iacomini *RDSLab* On Wed, Jun 14, 2017 at 1:02 PM, Igor Sapego <[email protected]> wrote: > Do you set LD_LIBRARY_PATH to /usr/local/lib? If 'yes' then > can you describe in details how you do that? This may help > to identify an issue. > > Best Regards, > Igor > > On Wed, Jun 14, 2017 at 12:30 PM, Riccardo Iacomini < > [email protected]> wrote: > >> Hello Igor, >> I double checked the documentation and went over the steps again to be >> sure everything is ok. I tried running your command, that's the output: >> >> linux-vdso.so.1 => (0x00007fff75dd6000) >>> libignite-binary-2.0.0.19668.so.0 => >>> /usr/local/lib/libignite-binary-2.0.0.19668.so.0 >>> (0x00007f40e5349000) >>> libodbcinst.so.2 => /usr/local/lib/libodbcinst.so.2 (0x00007f40e5134000) >>> libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 >>> (0x00007f40e4d8a000) >>> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f40e49c1000) >>> libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 >>> (0x00007f40e47ab000) >>> libignite-common-2.0.0.19668.so.0 => >>> /usr/local/lib/libignite-common-2.0.0.19668.so.0 >>> (0x00007f40e4594000) >>> libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 >>> (0x00007f40e438a000) >>> libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 >>> (0x00007f40e416d000) >>> libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f40e3e63000) >>> /lib64/ld-linux-x86-64.so.2 (0x0000555643691000) >>> libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f40e3c5f000) >> >> >> >> however, I still get the same error from python: >> >> *pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open >>> lib 'Apache Ignite' : file not found (0) (SQLDriverConnect)")* >> >> >> >> Best >> >> Riccardo Iacomini >> >> >> *RDSLab* >> >> On Wed, Jun 14, 2017 at 11:10 AM, Igor Sapego <[email protected]> >> wrote: >> >>> 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.so.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.so.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* >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >
