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

Hi

On Tuesday, November 1, 2016, Mark Murawski <markm-lists(at)intellasoft(dot)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-packag
> es"
> 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-packag
> es/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-packag
> es/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-packag
> es/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