[SOLVED] pysqlite2

2handband · 11-14-2010, 07:17 AM

Can somebody point me towards a Slackware package for pysqlite2?

ortho-orange#42 · 11-14-2010, 07:22 AM

Have you tried any of these: http://www.linuxpackages.net/search_...=pysqlite&ver= ?

2handband · 11-14-2010, 07:32 AM

I need one for AMD64.

2handband · 11-14-2010, 07:40 AM

I went ahead and tried one of those anyway... no go. It installed fine, but the software I'm trying to install that depends on it doesn't recognize it.

ortho-orange#42 · 11-14-2010, 07:47 AM

It might help to know what software you're trying to install that depends on it, how you're installing it (source/pre-compiled binary), and what you mean by "does not recognize it" - do you get an error during installation?

2handband · 11-14-2010, 07:56 AM

I'm trying to install gcompris. When I try to install from the Slackbuilds.org package (after modifying the version # in the slackbuild) I get this:

Code:

patching file configure
Hunk #1 succeeded at 16643 (offset -2935 lines).
can't find file to patch at input line 14
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|--- src/boards/python/admin/module_users.py
|+++ src/boards/python/admin/module_users.py
--------------------------
File to patch:

So I tried compiling from source and get this:

Code:

checking for python module pysqlite2... no
configure: error: *** pysqlite2 missing

ortho-orange#42 · 11-14-2010, 08:19 AM

Is there a reason you need sqlite support? If no, you can use the configuration parameter " --disable-sqlite" Note from configure file -"Turn off sqlite (will disable profile)".

Also, if it is needed, can you import sqlite from python?

from the pysqlite page's troubleshooting section:

Code:

>>> import sqlite
>>> sqlite.version
'1.0.1'
>>> sqlite._sqlite.sqlite_version()
'2.8.16'

running that from python should tell you if python is talking to sqlite.

2handband · 11-14-2010, 08:51 AM

Apparently Python is not talking to sqlite:

Code:

>>> import sqlite
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named sqlite

Sqlite is installed on this box.

ortho-orange#42 · 11-14-2010, 09:21 AM

did you instal pysqllite with the following command?:

Code:

python setup.py build_static install

I was able to install, and test it with this:

Code:

>>> import pysqlite2

that worked (no error), but the "import sqlite" didn't work, so not sure about that.. you may want to try "import pysqlite2" in python...

pysqlite2 is in in the "/usr/lib/python2.X/site-packages" folder, right?

All the gcompris config file does is try to import it by running the "import pysqlite2" in python, so if it's there, it should work..

2handband · 11-14-2010, 09:36 AM

I just installed pysqlite from the packages listed above using the installpkg command. Do I need to reinstall it? As it is I'm getting this:

Code:

>>> import pysqlite2
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named pysqlite2

ortho-orange#42 · 11-14-2010, 09:50 AM

Try the download from here: http://code.google.com/p/pysqlite/downloads/list. I used the latest - 2.6.0

Extract it, and run the python setup command above (I had to be root to do it).

2handband · 11-14-2010, 10:37 AM

That worked great! thanks so much...

ortho-orange#42 · 11-14-2010, 11:01 AM

cool, glad it worked