incomplete sqlite3 module in python-2.7.2 package (Slitaz 4.0)

SliTaz Forum » English Support » Live and installation

incomplete sqlite3 module in python-2.7.2 package (Slitaz 4.0)

(25 posts) (4 voices)

Started 11 years ago by pipein
Latest reply from pipein
This topic is resolved

Tags:

No tags yet.

12 Next »

pipein

offline
Member

Hi,

It seems that the python 2.7.2 package for SliTaz 4.0 (and Cooking as at 5-June-2012) is missing the _sqlite3.so file from /usr/lib/python2.7/sqlite3

This could be the result of compiling python without the sqlite3-dev package installed for the sqlite3.h header file.

The python package receipt for SliTaz 4.0 lists sqlite in the DEPENDS line, but does not list sqlite-dev in the BUILD_DEPENDS line. i.e.
# SliTaz package receipt.
PACKAGE="python" VERSION="2.7.2" ... DEPENDS="openssl bzlib readline sqlite zlib ncursesw" BUILD_DEPENDS="openssl-dev bzip2-dev readline-dev ncursesw-dev" ...

Same thing in the python package receipt from Cooking (12-April-2012)
# SliTaz package receipt.
PACKAGE="python" VERSION="2.7.2" ... DEPENDS="openssl bzlib readline sqlite zlib ncursesw" BUILD_DEPENDS="openssl-dev bzip2-dev readline-dev ncursesw-dev tcl-dev \ tk-dev" ...

The latest Cook log for the python package (12-April-2012) says at the end of the compile stage:
... Python build finished, but the necessary bits to build these modules were not found: _bsddb _sqlite3 bsddb185 dbm sunaudiodev ...

Perhaps this could explain the python error ImportError: No module named _sqlite3 people have encountered.

Posted 11 years ago #
pipein

offline
Member

I added sqlite-dev to the BUILD_DEPENDS line in a copy of the python package receipt, then I used that receipt to cook a new python package locally on my machine. The resulting package has identical files to the official package, plus this additional file:
/usr/lib/python2.7/lib-dynload/_sqlite3.so

(so the _sqlite3.so file doesn't belong in /usr/lib/python2.7/sqlite3/ as suggested in the previous post)

It seems to be working fine so far and there are no more occurences of ImportError: No module named _sqlite3 here.

Posted 11 years ago #
Trixar_za

offline
Key Master

Providing the package would be nice - alternatively just providing the missing file might be smaller and an easier fix.

Posted 11 years ago #
bxscle

offline
Member

@pipein & @Trixar_za: can you post link or attach that new package python2.7 or sqlite3.so file, please?

Posted 11 years ago #
Trixar_za

offline
Key Master

I found one more missing build dependency that is needed: db-dev - In the end you're just left with the last 2, dbm and sunaudiodev, not being built. Incidentally, I compiled from scratch too, so I have a working version that includes tk/tcl support too.

Posted 11 years ago #
Trixar_za

offline
Key Master

Yet another untested package that may or may not work: http://www.trixarian.net/downloads/python-fix.tazpkg - Enjoy ;)

Posted 11 years ago #
pipein

offline
Member

@Trixar_za
Good work on the other missing dependency. I half-looked at other dependencies too but I was really only after sqlite so far (and am trying to keep everything small without breaking anything... insert feeble excuse #212 here...).

Really, SliTaz is fantastic for its size (actually, regardless of its size) and we all should be thankful of the effort that has gone in.

I thought posting a package (the very first one I'd Cooked... great tools!) might not be much help without a better eye cast over it. I've attached the _sqlite3.so file though and have tested this within an install of the official python-2.7.2.tazpkg from SliTaz 4.0. The testing has been limited to the testall.py suite in the python package, as well as using some python based applications.

The results from testall.py (with and without _sqlite3.so) are at the bottom of this post for comparison. Only difference is +1 on the "tests OK" and -1 on "tests skipped" as sqlite now passes.

@bxscle
the _sqlite3.so file is attached and should be located like this:
/usr/lib/python2.7/lib-dynload/_sqlite3.so

I have only tested this in SliTaz 4.0 with the standard python-2.7.2.tazpkg.

testall.py results
standard python-2.7.2.tazpkg
343 tests OK. 2 tests failed: test_argparse test_httpservers 42 tests skipped: test_aepack test_al test_applesingle test_bsddb test_bsddb185 test_bsddb3 test_cd test_cl test_codecmaps_cn test_codecmaps_hk test_codecmaps_jp test_codecmaps_kr test_codecmaps_tw test_curses test_dbm test_gdb test_gdbm test_gl test_imgfile test_kqueue test_linuxaudiodev test_macos test_macostools test_msilib test_ossaudiodev test_py3kwarn test_scriptpackages test_smtpnet test_socketserver test_sqlite test_startfile test_sunaudiodev test_tcl test_timeout test_tk test_ttk_guionly test_ttk_textonly test_urllib2net test_urllibnet test_winreg test_winsound test_zipfile64 9 skips unexpected on linux2: test_bsddb test_bsddb3 test_dbm test_gdb test_gdbm test_tcl test_tk test_ttk_guionly test_ttk_textonly

testall.py results
standard python-2.7.2.tazpkg
344 tests OK. 2 tests failed: test_argparse test_httpservers 41 tests skipped: test_aepack test_al test_applesingle test_bsddb test_bsddb185 test_bsddb3 test_cd test_cl test_codecmaps_cn test_codecmaps_hk test_codecmaps_jp test_codecmaps_kr test_codecmaps_tw test_curses test_dbm test_gdb test_gdbm test_gl test_imgfile test_kqueue test_linuxaudiodev test_macos test_macostools test_msilib test_ossaudiodev test_py3kwarn test_scriptpackages test_smtpnet test_socketserver test_startfile test_sunaudiodev test_tcl test_timeout test_tk test_ttk_guionly test_ttk_textonly test_urllib2net test_urllibnet test_winreg test_winsound test_zipfile64 9 skips unexpected on linux2: test_bsddb test_bsddb3 test_dbm test_gdb test_gdbm test_tcl test_tk test_ttk_guionly test_ttk_textonly

Posted 11 years ago #
pipein

offline
Member

@self - oops

of course in the previous post the heading for the second set of testall.py result should say:

testall.py results
standard python-2.7.2.tazpkg PLUS _sqlite3.so

Posted 11 years ago #
bxscle

offline
Member

Great work guys! Big thank you ... bleachbit is working now ... :D

Posted 11 years ago #
Trixar_za

offline
Key Master

I'll take that as confirmation that the _sqlite3.so part of http://www.trixarian.net/downloads/python-fix.tazpkg works. Now somebody just has to confirm that the Tk interface works too ;) Possibly by trying PySolFC, which is a awesome Card Game collection that runs out of the box on any system with Python installed :P

Posted 11 years ago #
pipein

offline
Member

@Trixar_za
Didn't initially realise your package was a "delta" only. Completely obvious now.

Haven't tested it apart from running the testall.py suite against it, (merged with standard python package).

Sqlite passed (214 tests OK).
Tcl passed (20 tests OK).
tk passed (3 tests OK).
ttk_textonly passed (13 test OK).
ttk_guionly (57 tests OK, 1 failure) - failure on test_widgets.py

The lib-tk tests come from the standard python package, not your package, so I don't know if thats related.

Also, in the receipt, did you mean to include sqlite3 in the DEPENDS line... instead of the standard sqlite tazpkg?

Posted 11 years ago #
Trixar_za

offline
Key Master

Actually lib-tk does come with my package, but I may have stripped the tests. And yeah, I meant to make to the dependency sqlite and not sqlite3. I'll fix it now

Posted 11 years ago #
Trixar_za

offline
Key Master

The dependency error in http://www.trixarian.net/downloads/python-fix.tazpkg should be fixed now :P

Posted 11 years ago #
pipein

offline
Member

@Trixar_za

you have stripped the tests from lib-tk in your package.

Posted 11 years ago #
Trixar_za

offline
Key Master

The tests folder within lib-tk. By default this is stripped in the SliTaz package for Python to save space. It's not really needed by average users because it's mostly just examples.

BTW, you can get PySolFC @ http://pysolfc.sourceforge.net/ - which should a more extensive test.

Posted 11 years ago #

RSS feed for this topic

12 Next »

Reply »

You must log in to post.