ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Sapego <isap...@gridgain.com>
Subject Re: ODBC driver issue
Date Wed, 14 Jun 2017 09:10:36 GMT
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 <
riccardo.iacomini@rdslab.com> 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 <isapego@gridgain.com> 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 <
>> riccardo.iacomini@rdslab.com> 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 <isapego@gridgain.com>
>>> 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 <
>>>> riccardo.iacomini@rdslab.com> 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*
>>>>>
>>>>
>>>>
>>>
>>
>

Mime
View raw message