[ckan-dev] Starting the datapusher fails with Exception about missing pysqlite2

Johann Höchtl johann.hoechtl at gmail.com
Fri May 9 09:05:21 UTC 2014


Am 09.05.2014 08:56, schrieb Nigel Babu:
> My best guess is that your settings file for datapusher isn't 
> configured correctly.
>
As it turned out it was Python2.7 on Gentoo which comes by default 
without sqlite support. After

USE=sqlite emerge lang-dev/python2.7

the datapusher is working fine now!

> Nigel Babu
> Developer, Open Knowledge
>
>
> On 8 May 2014 19:41, Johann Höchtl <johann.hoechtl at gmail.com 
> <mailto:johann.hoechtl at gmail.com>> wrote:
>
>     Hi,
>
>     I installed the datapusher as a mixture of the development install
>     and the production install as described in
>
>     https://github.com/the42/ckan-virtualisation/blob/master/doc/datapusher.md
>
>     However, when I try to run it, it fails with an Exception
>
>     -:[/usr/lib/ckan/datapusher/src/datapusher]$> python wsgi.py
>     Traceback (most recent call last):
>       File "wsgi.py", line 7, in <module>
>         web.configure()
>       File
>     "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/ckanserviceprovider/web.py",
>     line 65, in configure
>         db.setup_db(app)
>       File
>     "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/ckanserviceprovider/db.py",
>     line 17, in setup_db
>         convert_unicode=True)
>       File
>     "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/engine/__init__.py",
>     line 344, in create_engine
>         return strategy.create(*args, **kwargs)
>       File
>     "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py",
>     line 73, in create
>         dbapi = dialect_cls.dbapi(**dbapi_args)
>       File
>     "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/dialects/sqlite/pysqlite.py",
>     line 297, in dbapi
>         raise e
>     ImportError: No module named pysqlite2
>
>
>
>
>
>     ==> ImportError: No module named pysqlite2
>
>     I have no ownership about the machine this is running (Gentoo
>     box). My assumption is, that a site-package is missing. However
>
>     pip install -r requirements.txt
>     pip install -e .
>
>     ran without issues. I also wonder why sqlalchemy is trying to
>     instantiate sqlite altogether when I thought it should use postgresql?
>
>     Thank you, Johann
>     _______________________________________________
>     ckan-dev mailing list
>     ckan-dev at lists.okfn.org <mailto:ckan-dev at lists.okfn.org>
>     https://lists.okfn.org/mailman/listinfo/ckan-dev
>     Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140509/b7486b34/attachment-0003.html>


More information about the ckan-dev mailing list