pgAdmin4 Server does not create SQLite tables
От | Josh Berkus |
---|---|
Тема | pgAdmin4 Server does not create SQLite tables |
Дата | |
Msg-id | e70e5e23-b70f-8d0e-01e6-a5cc80a10f85@agliodbs.com обсуждение исходный текст |
Список | 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@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)
В списке pgadmin-support по дате отправления: