On 11/2/16 8:01 AM, Dave Page wrote:
Hi
On Tuesday, November 1, 2016, Mark Murawski
<markm-li...@intellasoft.net <mailto:markm-li...@intellasoft.net>> wrote:
On 11/01/16 12:58, Mark Murawski wrote:
----------------------------
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/markm/download/pgadmin4/web/pgAdmin4.py", line 46,
in <module>
app = create_app()
File "/home/markm/download/pgadmin4/web/pgadmin/__init__.py",
line 208, in create_app
version = Version.query.filter_by(name='ConfigDB').first()
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/orm/query.py",
line 2659, in first
ret = list(self[0:1])
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/orm/query.py",
line 2457, in __getitem__
return list(res)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/orm/query.py",
line 2761, in __iter__
return self._execute_and_instances(context)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/orm/query.py",
line 2776, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/engine/base.py",
line 914, in execute
return meth(self, multiparams, params)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/sql/elements.py",
line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams,
params)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/engine/base.py",
line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/engine/base.py",
line 1146, in _execute_context
context)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/engine/base.py",
line 1341, in _handle_dbapi_exception
exc_info
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/util/compat.py",
line 202, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/util/compat.py",
line 185, in reraise
raise value.with_traceback(tb)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/engine/base.py",
line 1139, in _execute_context
context)
File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no
such table: version [SQL: 'SELECT version.name
<http://version.name> AS version_name, version.value AS
version_value \nFROM version \nWHERE version.name
<http://version.name> = ?\n LIMIT ? OFFSET ?'] [parameters:
('ConfigDB', 1, 0)]
"Failed to launch the application server, server thread exiting."
Sounds like your earlier attempt created a broken config database. Try
'rm ~/.pgadmin/pgadmin4.db' (or whatever would be appropriate for the
settings you have) and then start pgAdmin again. It should recreate
the database and start up if all is well.
Regards, Dave.
Cool. Deleted the DB and now it started up. Seems to be working now.
Is there a way to import my db connection list from pgadmin3?
I'm sure you already know, in this day and age, users want things to
'just work'. I know pgadmin4 is a young project, but here's a number of
things that will help boost adoption and make for an overall better
experience.
Suggestions so far:
- Update requirements_py3.txt -- django-htmlmin==0.10.0
- Pre or post-make, check for dependencies on virtualenv and all that.
if on debian environment, recommend install of virtualenvwrapper
- Post-build auto setup script for virtualenv
-- Detect default python version based on the qmake results
-- Detect path if possible of virtualenvwrapper based on
host-distro, if path not detected, bail or attempt to download/install
automatically?
-- create virtual env for pgadmin4
-- pip install dependencies for pgadmin4 in the new virtualenv
-- create wrapper script to start pgadmin4 using this new
virtualenv, instruct users to use this for launching app
-- Detect broken database (if core schema parts are missing) and ask
user if it's okay to rebuild
