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)
|
List | pgadmin-support |
Hi
On Tuesday, November 1, 2016, Mark Murawski <markm-lists@intellasoft.net> wrote:
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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-package s
/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-packag es/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-packag es/sqlalchemy/orm/query.py", line 2659, in first
ret = list(self[0:1])
File "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packag es/sqlalchemy/orm/query.py", line 2457, in __getitem__
return list(res)
File "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packag es/sqlalchemy/orm/query.py", line 2761, in __iter__
return self._execute_and_instances(context)
File "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packag es/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-packag es/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-packag es/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packag es/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packag es/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packag es/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-packag es/sqlalchemy/util/compat.py", line 185, in reraise
raise value.with_traceback(tb)
File "/home/markm/.virtualenvs/pgadmin4/lib/python3.4/site-packag es/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
pgadmin-support by date: