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@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)