sqlite in 2.7 on redhat 6

[Kushal Kumaran]

Larry Martell <larry.martell at gmail.com> writes:

> On Thu, Jun 15, 2017 at 12:20 PM, Kushal Kumaran <kushal at locationd.net> wrote:
>> Larry Martell <larry.martell at gmail.com> writes:
>>
>>> On Thu, Jun 15, 2017 at 10:35 AM, Peter Otten <__peter__ at web.de> wrote:
>>>> Larry Martell wrote:
>>>>
>>>>>> On linux the system sqlite3 is used.
>>>>>
>>>>> I tried building and installing sqlite from source and that did not
>>>>> solve the problem.
>>>>
>>>> You misunderstood: the problem is not sqlite3 it's that python needs
>>>> sqlite3's header files.
>>>>
>>>>>> Is that a Python version that you compiled yourself?
>>>>>
>>>>> No I installed it with pip install python2.7
>>>>
>>>> I'd never have thought of trying that -- but still: did that download binary
>>>> blobs or did it invoke the C compiler?
>>>
>>> Sorry I mistyped - it wasn't pip it was yum.
>>>
>>
>> Are you sure that is the python you are running?  The python provided by
>> the OS repositories would have installed python at /usr/bin/python
>> (possibly with additional names such as /usr/bin/python2.7).  The
>> exception you posted earlier is looking at files in /usr/local and
>> /opt/rh, neither of which would be searched by the system-installed
>> python by default.
>>
>> It is possible (likely?) that /usr/local/bin is earlier in your $PATH
>> than /usr/bin, which is resulting in some /usr/local/bin/python
>> shadowing the system python.  If so, run the system python with an
>> absolute path like /usr/bin/python and see if you are able to import
>> sqlite3.
>
> /usr/bin/python2.7 is a symlink to /usr/local/bin/python2.7:
>
> $ ls -l /usr/bin/python2.7
>
> lrwxrwxrwx. 1 root root 24 Apr 22  2016 /usr/bin/python2.7 ->
> /usr/local/bin/python2.7
>
> On Redhat 6 the system python is 2.6. You cannot change that as it breaks yum.
>

Then the question is again, how did you install python2.7.  Which yum
repository provided you this kind of python2.7 package?  You should
contact them to check how they've built this python, and whether they
can include sqlite3 in their build.

> /usr/local/bin/ is earlier in my path then /usr/bin. But I used
> python2.7 all the time here and other packages work fine.
>
> What led me down this rabbit hole was that I am trying to use
> pypolibox and that is failing with this traceback:
>
> Traceback (most recent call last):
>   File "/usr/local/bin/pypolibox", line 9, in <module>
>     load_entry_point('pypolibox==1.0.2', 'console_scripts', 'pypolibox')()
>   File "/usr/local/lib/python2.7/site-packages/distribute-0.6.35-py2.7.egg/pkg_resources.py",
> line 343, in load_entry_point
>     return get_distribution(dist).load_entry_point(group, name)
>   File "/usr/local/lib/python2.7/site-packages/distribute-0.6.35-py2.7.egg/pkg_resources.py",
> line 2309, in load_entry_point
>     return ep.load()
>   File "/usr/local/lib/python2.7/site-packages/distribute-0.6.35-py2.7.egg/pkg_resources.py",
> line 2015, in load
>     entry = __import__(self.module_name, globals(),globals(), ['__name__'])
>   File "/usr/local/lib/python2.7/site-packages/pypolibox/pypolibox.py",
> line 13, in <module>
>     from nltk.featstruct import Feature
>   File "/usr/local/lib/python2.7/site-packages/nltk/__init__.py", line
> 137, in <module>
>     from nltk.stem import *
>   File "/usr/local/lib/python2.7/site-packages/nltk/stem/__init__.py",
> line 29, in <module>
>     from nltk.stem.snowball import SnowballStemmer
>   File "/usr/local/lib/python2.7/site-packages/nltk/stem/snowball.py",
> line 26, in <module>
>     from nltk.corpus import stopwords
>   File "/usr/local/lib/python2.7/site-packages/nltk/corpus/__init__.py",
> line 66, in <module>
>     from nltk.corpus.reader import *
>   File "/usr/local/lib/python2.7/site-packages/nltk/corpus/reader/__init__.py",
> line 105, in <module>
>     from nltk.corpus.reader.panlex_lite import *
>   File "/usr/local/lib/python2.7/site-packages/nltk/corpus/reader/panlex_lite.py",
> line 15, in <module>
>     import sqlite3
>   File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
>     from dbapi2 import *
>   File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>
>     from _sqlite3 import *
> ImportError: No module named _sqlite3

Your python was built without sqlite3 support.  If your yum repo
provider is unable to rebuild with sqlite3, you can do so yourself.
Make sure the sqlite-devel package is installed so your python build
will use it.

-- 
regards,
kushal