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@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 AS version_name, version.value AS version_value \nFROM version \nWHERE 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