Re: Can't install pgadmin4 on linux (flask required)

On 11/2/16 8:01 AM, Dave Page wrote:
> Hi
>
> On Tuesday, November 1, 2016, Mark Murawski
> <markm-lists(at)intellasoft(dot)net <mailto:markm-lists(at)intellasoft(dot)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