[Pywps-dev] pywps demo: Service error: (sqlite3.OperationalError) unable to open database file

[Jorge Mendes de Jesus]

Hi Martin

Are you using master branch or develop ?

J.

On Mon, Oct 16, 2017 at 10:43 AM, Martin Landa <landa.martin at gmail.com>
wrote:

> Hi,
>
> pywps-demo is failing on computer (Ubuntu 16.04LTS):
>
> http://127.0.0.1:5000/wps?service=wps&&version=1.0.0&
> request=execute&identifier=say_hello&datainputs=name=slunce
>
> ends with
>
> Service error: (sqlite3.OperationalError) unable to open database file
>
> Debug:
>
> 2017-10-16 10:37:54,026] [DEBUG]
> file=/usr/local/lib/python3.5/dist-packages/pywps/dblog.py line=163
> module=dblog function=get_session Initializing database connection
> 2017-10-16 10:37:54,027] [ERROR]
> file=/usr/local/lib/python3.5/dist-packages/pywps/exceptions.py
> line=45 module=exceptions function=__init__ Exception: code: 400,
> locator: Service error: (sqlite3.OperationalError) unable to open
> database file, description:
> Traceback (most recent call last):
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/base.py",
> line 2147, in _wrap_pool_connect
>     return fn()
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
> line 387, in connect
>     return _ConnectionFairy._checkout(self)
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
> line 766, in _checkout
>     fairy = _ConnectionRecord.checkout(pool)
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
> line 516, in checkout
>     rec = pool._do_get()
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
> line 1229, in _do_get
>     return self._create_connection()
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
> line 333, in _create_connection
>     return _ConnectionRecord(self)
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
> line 461, in __init__
>     self.__connect(first_connect_check=True)
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/pool.py",
> line 651, in __connect
>     connection = pool._invoke_creator(self)
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/
> engine/strategies.py",
> line 105, in connect
>     return dialect.connect(*cargs, **cparams)
>   File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/
> engine/default.py",
> line 393, in connect
>     return self.dbapi.connect(*cargs, **cparams)
> sqlite3.OperationalError: unable to open database file
>
> Strangely `logs/pywps-logs.sqlite3` is created, table `pywps_requests`
> contains records, but `pywps_stored requests` is empty.
>
> No modification in configuration has been done. Any idea what could be
> wrong?
>
> Martin
>
> --
> Martin Landa
> http://geo.fsv.cvut.cz/gwiki/Landa
> http://gismentors.cz/mentors/landa
> _______________________________________________
> pywps-dev mailing list
> pywps-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/pywps-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pywps-dev/attachments/20171016/120bf30f/attachment.html>