Re: Can't install pgadmin4 on linux (flask required) - Mailing list pgadmin-support

From Dave Page
Subject Re: Can't install pgadmin4 on linux (flask required)
Date
Msg-id CA+OCxoz-uKgCA_S7X=8WoOBAwpGCOa8ikVA+3+43xt78DY1AJg@mail.gmail.com
Whole thread Raw
In response to Re: Can't install pgadmin4 on linux (flask required)  (Mark Murawski <markm-lists@intellasoft.net>)
Responses Re: Can't install pgadmin4 on linux (flask required)  (Mark Murawski <markm-lists@intellasoft.net>)
List pgadmin-support
Hi

On Tuesday, November 1, 2016, Mark Murawski <markm-lists@intellasoft.net> wrote:
On 11/01/16 12:58, Mark Murawski wrote:

----------------------------
Now I'm stuck here:
(pgadmin4)markm {~/download/pgadmin4} markm$ pip install -r
requirements_py3.txt
Downloading/unpacking Babel==1.3 (from -r requirements_py3.txt (line 1))
  Downloading Babel-1.3.tar.gz (3.4MB): 3.4MB downloaded
  Running setup.py (path:/tmp/pip-build-a4cvzlez/Babel/setup.py)
egg_info for package Babel

    warning: no previously-included files matching '*' found under
directory 'docs/_build'
    warning: no previously-included files matching '*.pyc' found under
directory 'tests'
    warning: no previously-included files matching '*.pyo' found under
directory 'tests'
Downloading/unpacking beautifulsoup4==4.4.1 (from -r
requirements_py3.txt (line 2))
  Downloading beautifulsoup4-4.4.1-py3-none-any.whl (81kB): 81kB downloaded
Downloading/unpacking blinker==1.3 (from -r requirements_py3.txt (line 3))
  Downloading blinker-1.3.tar.gz (91kB): 91kB downloaded
  Running setup.py (path:/tmp/pip-build-a4cvzlez/blinker/setup.py)
egg_info for package blinker

Downloading/unpacking click==6.6 (from -r requirements_py3.txt (line 4))
  Downloading click-6.6.tar.gz (283kB): 283kB downloaded
  Running setup.py (path:/tmp/pip-build-a4cvzlez/click/setup.py)
egg_info for package click

    warning: no previously-included files matching '*.pyc' found under
directory 'docs'
    warning: no previously-included files matching '*.pyo' found under
directory 'docs'
    warning: no previously-included files matching '*.pyc' found under
directory 'tests'
    warning: no previously-included files matching '*.pyo' found under
directory 'tests'
    warning: no previously-included files matching '*.pyc' found under
directory 'examples'
    warning: no previously-included files matching '*.pyo' found under
directory 'examples'
    no previously-included directories found matching 'docs/_build'
Downloading/unpacking django-htmlmin==0.8.0 (from -r
requirements_py3.txt (line 5))
  Downloading django-htmlmin-0.8.0.tar.gz
  Running setup.py
(path:/tmp/pip-build-a4cvzlez/django-htmlmin/setup.py) egg_info for
package django-htmlmin
    Traceback (most recent call last):
      File "<string>", line 17, in <module>
      File "/tmp/pip-build-a4cvzlez/django-htmlmin/setup.py", line 10,
in <module>
        README = open('README.rst').read()
      File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/encodings/ascii.py",
line 26, in decode
        return codecs.ascii_decode(input, self.errors)[0]
    UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position
5965: ordinal not in range(128)
    Complete output from command python setup.py egg_info:
    Traceback (most recent call last):

  File "<string>", line 17, in <module>

  File "/tmp/pip-build-a4cvzlez/django-htmlmin/setup.py", line 10, in
<module>

    README = open('README.rst').read()

  File
"/home/markm/.virtualenvs/pgadmin4/lib/python3.4/encodings/ascii.py",
line 26, in decode

    return codecs.ascii_decode(input, self.errors)[0]

UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position
5965: ordinal not in range(128)




If you edit requirements_py3.txt and change django-htmlmin, then it will install: django-htmlmin==0.10.0

All requirements are installed successfully in my virtualenv

Now I'm at this spot:
I've edited config.py to set SERVER_MODE=False

(pgadmin4)markm {~/download/pgadmin4} markm$ runtime/pgAdmin4

My Paths are:
/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages
/home/markm/download/pgadmin4/web/pgAdmin4.py

Python path: "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packages"
Python Home:  ""
Webapp path:  "/home/markm/download/pgadmin4/web/pgAdmin4.py"
Traceback (most recent call last):
  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)
sqlite3.OperationalError: no such table: version

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. 


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-support by date:

Previous
From: QUIDOZ Marie-Claude
Date:
Subject: Re: pgAdmin 4 v1.1 Released!
Next
From: Mark Murawski
Date:
Subject: pgAdmin 4 1.1, query error while browsing columns