Re: [pysqlite] failed installation

On 21/01/09 Gerhard H?ring said:

> Yep. Apparently your *SQLite* was compiled with nonstandard settings. 
> pysqlite doesn't like that - it assumes SQLite was not compiled with any 
> --disable-this-feature or --disable-that-feature.

Yeah, that's Gentoo for you.

I suppose I could build my own sqlite with default options and build pysqlite
against that...

> A quick solution is that you open src/connection.c and remove these lines:
> 
> #if SQLITE_VERSION_NUMBER >= 3003008
> #define HAVE_LOAD_EXTENSION
> #endif
> 
> This will lead to HAVE_LOAD_EXTENSION not being defined and the 
> extension loading code of pysqlite not being compiled.

Trying that now. 

This is ugly...

msoulier@anton:...mp/pysqlite-2.5.1$ ~/work/msl8/bin/python setup.py install
running install
running build
running build_py
running build_ext
running install_lib
copying build/lib.linux-i686-2.3/pysqlite2/_sqlite.so ->
/home/msoulier/work/msl8/lib/python2.3/site-packages/pysqlite2
byte-compiling
/home/msoulier/work/msl8/lib/python2.3/site-packages/pysqlite2/test/py25tests.py
to py25tests.pyc
  File
"/home/msoulier/work/msl8/lib/python2.3/site-packages/pysqlite2/test/py25tests.py",
line 48
    with self.con:
            ^
SyntaxError: invalid syntax
running install_data

Shouldn't py25tests only run on python 2.5+?

Hmm. Doesn't seem to help my problem.

msoulier@anton:...mp/pysqlite-2.5.1$ ~/work/msl8/bin/python                 
Python 2.3.7 (#1, Jan 19 2009, 22:14:23) 
[GCC 4.1.2 (Gentoo 4.1.2 p1.1)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from pysqlite2 import dbapi2 as sqlite
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "pysqlite2/dbapi2.py", line 27, in ?
    from pysqlite2._sqlite import *
ImportError: No module named _sqlite

Mike
-- 
Michael P. Soulier <[email protected]>
"Any intelligent fool can make things bigger and more complex... It takes a
touch of genius - and a lot of courage to move in the opposite direction."
--Albert Einstein

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)

iD8DBQFJd56gKGqCc1vIvggRAmzdAJ0S8xgll5j431EbgMdpZSnm9go4GQCfcTtk
QT7VfC2/6Od4iqYDzetafHQ=
=7xQV
-----END PGP SIGNATURE-----