pgAdmin4 Server does not create SQLite tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin4 Server does not create SQLite tables
Date: 2016-10-10 00:04:59
Message-ID: e70e5e23-b70f-8d0e-01e6-a5cc80a10f85@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Attempting to access pgAdmin4 from HTTP I get a "500 server error".
Consulting the logs, I see:

[Sun Oct 09 23:48:16.337065 2016] [wsgi:error] [pid 4689] [remote
98.246.109.153:200] sqlalchemy.exc.OperationalError:
(sqlite3.OperationalError) no such table: version [SQL: 'SELECT
version.name AS version_name, version.value AS version_value \\nFROM
version \\nWHERE version.name = ?\\n LIMIT ? OFFSET ?'] [parameters:
('ConfigDB', 1, 0)]

And indeed looking into the SQLite database at
/usr/share/httpd/.pgadmin/pgadmin.db, there are no tables:

[root(at)ip-172-31-34-8 .pgadmin]# sqlite3 pgadmin4.db
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> .tables
sqlite> select * from ConfigDB;
Error: no such table: ConfigDB

So apparently whatever process is supposed to create the SQLite tables
is failing without logging it. Or just not being executed.

pgadmin4 1.0, installed on Fedora24, from yum.postgresql.org packages.
Being used as the sole web application under httpd.

--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Josh Berkus 2016-10-10 00:09:11 Re: pgAdmin4 Server does not create SQLite tables
Previous Message Atilio Medina 2016-10-09 23:47:38 Re: PgAdmin4 is not usable when installed from RPMs on Fedora linux