Re: Help for PySQLite Install on debian sarge

Gloups, now I think I've more problems than before... When i run the 

>>> test.test() 

I get many errors like this one : 

======================================================================
ERROR: CheckAggrCheckParamInt (pysqlite2.test.userfunctions.AggregateTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/pysqlite2/test/userfunctions.py",                                               line 229, in setUp
    cur.execute("""
Warning: You can only execute one statement at a time.

On 5/24/06, Emmanuel Vaïsse <contact@xxxxxxxxxxx> wrote:

All right, everything works just fine. Thanks you very much.

On 5/24/06, Gerhard Häring <gh@xxxxxxxxxxx > wrote:

Emmanuel Vaïsse wrote:
> Hi,
>
> I've many trouble to install PySQLite on my debian (trough ssh).

Do you have root access?

> The apt-get method doesn't work
> and
> I've got these errors with easy_install :
> In file included from src/module.c:29:
> src/microprotocols.h:55: error: syntax error before '*' token
> src/microprotocols.h:55: warning: function declaration isn't a prototype
> src/module.c: In function `module_complete':
> src/module.c:90: warning: implicit declaration of function
> `sqlite3_complete'
> src/module.c: In function `init_sqlite':
> src/module.c:294: warning: implicit declaration of function
> `sqlite3_libversion'
> src/module.c:294: warning: passing arg 1 of `PyString_FromString' makes
> pointer from integer without a cast
> error: Setup script exited with error: command 'gcc' failed with exit
> status 1
>
> Can someone help me ?  [...]

You don't have the sqlite headers installed. You can fix this as root:

$ apt-get install libsqlite3-dev

If you don't have root access, you will have to download the SQLite3
sources from the SQLite homepage, compile and install them in a custom
location:

$ wget http://www.sqlite.org/sqlite-3.3.5.tar.gz
$ tar xvfz ...
$ cd ...
$ ./configure --prefix=/my/custom/root/

Then in the pysqlite source tree, edit setup.cfg the include and library
paths to point to /my/custom/root/include and /my/custom/root/lib. Then
you should be able to compile pysqlite.

The easy_install method won't work if you have SQLite installed in a
custom location.

Good luck!

-- Gerhard
_______________________________________________
pysqlite mailing list
pysqlite@xxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/pysqlite

_______________________________________________
pysqlite mailing list
pysqlite-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/pysqlite