Thread: Can't install pgadmin4 on linux (flask required)
Hi, So I followed all the instructions so far with pgadmin4 1.1 Debian Jessie Qt5 5.3.2-2 Python 3.4 3.4.2-1 All the requirements are met: markm {/home/markm/download/pgadmin4-1.1} root# pip3 install -r requirements_py3.txt Requirement already satisfied (use --upgrade to upgrade): Babel==1.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 1)) Requirement already satisfied (use --upgrade to upgrade): beautifulsoup4==4.4.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 2)) Requirement already satisfied (use --upgrade to upgrade): blinker==1.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 3)) Requirement already satisfied (use --upgrade to upgrade): click==6.6 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 4)) Requirement already satisfied (use --upgrade to upgrade): django-htmlmin==0.10.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 5)) Requirement already satisfied (use --upgrade to upgrade): extras==0.0.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 6)) Requirement already satisfied (use --upgrade to upgrade): fixtures==2.0.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 7)) Requirement already satisfied (use --upgrade to upgrade): Flask==0.11.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 8)) Requirement already satisfied (use --upgrade to upgrade): Flask-Babel==0.11.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 9)) Requirement already satisfied (use --upgrade to upgrade): Flask-Gravatar==0.4.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 10)) Requirement already satisfied (use --upgrade to upgrade): Flask-Login==0.3.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 11)) Requirement already satisfied (use --upgrade to upgrade): Flask-Mail==0.9.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 12)) Requirement already satisfied (use --upgrade to upgrade): Flask-Principal==0.4.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 13)) Requirement already satisfied (use --upgrade to upgrade): Flask-Security==1.7.5 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 14)) Requirement already satisfied (use --upgrade to upgrade): Flask-SQLAlchemy==2.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 15)) Requirement already satisfied (use --upgrade to upgrade): Flask-WTF==0.12 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 16)) Requirement already satisfied (use --upgrade to upgrade): html5lib==1.0b3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 17)) Requirement already satisfied (use --upgrade to upgrade): itsdangerous==0.24 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 18)) Requirement already satisfied (use --upgrade to upgrade): Jinja2==2.7.3 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 19)) Requirement already satisfied (use --upgrade to upgrade): linecache2==1.0.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 20)) Requirement already satisfied (use --upgrade to upgrade): MarkupSafe==0.23 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 21)) Requirement already satisfied (use --upgrade to upgrade): passlib==1.6.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 22)) Requirement already satisfied (use --upgrade to upgrade): pbr==1.9.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 23)) Requirement already satisfied (use --upgrade to upgrade): psycopg2==2.6.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 24)) Requirement already satisfied (use --upgrade to upgrade): pycrypto==2.6.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 25)) Requirement already satisfied (use --upgrade to upgrade): pyrsistent==0.11.13 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 26)) Requirement already satisfied (use --upgrade to upgrade): python-dateutil==2.5.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 27)) Requirement already satisfied (use --upgrade to upgrade): python-mimeparse==1.5.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 28)) Requirement already satisfied (use --upgrade to upgrade): pytz==2014.10 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 29)) Requirement already satisfied (use --upgrade to upgrade): simplejson==3.6.5 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 30)) Requirement already satisfied (use --upgrade to upgrade): six==1.9.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 31)) Requirement already satisfied (use --upgrade to upgrade): speaklater==1.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 32)) Requirement already satisfied (use --upgrade to upgrade): SQLAlchemy==1.0.14 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 33)) Requirement already satisfied (use --upgrade to upgrade): testscenarios==0.5.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 34)) Requirement already satisfied (use --upgrade to upgrade): testtools==2.0.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 35)) Requirement already satisfied (use --upgrade to upgrade): traceback2==1.4.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 36)) Requirement already satisfied (use --upgrade to upgrade): unittest2==1.1.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 37)) Requirement already satisfied (use --upgrade to upgrade): Werkzeug==0.9.6 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 38)) Requirement already satisfied (use --upgrade to upgrade): WTForms==2.0.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 39)) Requirement already satisfied (use --upgrade to upgrade): sqlparse==0.1.19 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 40)) Cleaning up.. Build is successful: markm {download/pgadmin4-1.1/runtime} root# qmake Project MESSAGE: Building for QT5+... Project MESSAGE: Building for Linux/Mac... Project MESSAGE: Using /usr/bin/python-config Project MESSAGE: Python3 detected. # make ... completely clean make, let me know if you want this output ./pgadmin4 Python path: "" Python Home: "" Webapp path: "/home/markm/download/pgadmin4-1.1/web/pgAdmin4.py" Traceback (most recent call last): File "/homemarkm/download/pgadmin4-1.1/web/pgAdmin4.py", line 24, in <module> from pgadmin import create_app File "/home/markm/download/pgadmin4-1.1/web/pgadmin/__init__.py", line 17, in <module> from flask import Flask, abort, request, current_app ImportError: No module named 'flask' "Failed to launch the application server, server thread exiting." ------------------------------------------------------------------- I get a dialog box asking for a python path and an application path it's prepopulated with: python path: /usr/bin/python3.4 application path: /home/markm/download/pgadmin4-1.0-rc1/web/pgAdmin4.py Flask is a module that is currenty available according to pip pip list | grep -i flask Flask (0.11.1) Flask-Babel (0.11.1) Flask-Gravatar (0.4.2) Flask-Login (0.3.2) Flask-Mail (0.9.1) Flask-Principal (0.4.0) Flask-Script (0.6.7) Flask-Security (1.7.5) Flask-SQLAlchemy (2.1) Flask-WTF (0.12) I'm very very very stuck here. I found this post: https://www.postgresql.org/message-id/CACCA4P0jygzKLHUXz%3DS%2By-P%2B3QdW2t%2BQBG-2%2BWbf5GvE4-E53g%40mail.gmail.com I tried the recommended export PYTHONPATH="/usr/local/lib/python3.4/dist-packages" which is where flack and friends are installed... to no avail Help!
Hi
On Sunday, October 30, 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 Sunday, October 30, 2016, Mark Murawski <markm-lists@intellasoft.net> wrote:
Hi,
So I followed all the instructions so far with pgadmin4 1.1
Debian Jessie
Qt5 5.3.2-2
Python 3.4 3.4.2-1
All the requirements are met:
markm {/home/markm/download/pgadmin4-1.1} root# pip3 install -r requirements_py3.txt
Requirement already satisfied (use --upgrade to upgrade): Babel==1.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 1))
Requirement already satisfied (use --upgrade to upgrade): beautifulsoup4==4.4.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 2))
Requirement already satisfied (use --upgrade to upgrade): blinker==1.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 3))
Requirement already satisfied (use --upgrade to upgrade): click==6.6 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 4))
Requirement already satisfied (use --upgrade to upgrade): django-htmlmin==0.10.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 5))
Requirement already satisfied (use --upgrade to upgrade): extras==0.0.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 6))
Requirement already satisfied (use --upgrade to upgrade): fixtures==2.0.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 7))
Requirement already satisfied (use --upgrade to upgrade): Flask==0.11.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 8))
Requirement already satisfied (use --upgrade to upgrade): Flask-Babel==0.11.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 9))
Requirement already satisfied (use --upgrade to upgrade): Flask-Gravatar==0.4.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 10))
Requirement already satisfied (use --upgrade to upgrade): Flask-Login==0.3.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 11))
Requirement already satisfied (use --upgrade to upgrade): Flask-Mail==0.9.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 12))
Requirement already satisfied (use --upgrade to upgrade): Flask-Principal==0.4.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 13))
Requirement already satisfied (use --upgrade to upgrade): Flask-Security==1.7.5 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 14))
Requirement already satisfied (use --upgrade to upgrade): Flask-SQLAlchemy==2.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 15))
Requirement already satisfied (use --upgrade to upgrade): Flask-WTF==0.12 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 16))
Requirement already satisfied (use --upgrade to upgrade): html5lib==1.0b3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 17))
Requirement already satisfied (use --upgrade to upgrade): itsdangerous==0.24 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 18))
Requirement already satisfied (use --upgrade to upgrade): Jinja2==2.7.3 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 19))
Requirement already satisfied (use --upgrade to upgrade): linecache2==1.0.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 20))
Requirement already satisfied (use --upgrade to upgrade): MarkupSafe==0.23 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 21))
Requirement already satisfied (use --upgrade to upgrade): passlib==1.6.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 22))
Requirement already satisfied (use --upgrade to upgrade): pbr==1.9.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 23))
Requirement already satisfied (use --upgrade to upgrade): psycopg2==2.6.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 24))
Requirement already satisfied (use --upgrade to upgrade): pycrypto==2.6.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 25))
Requirement already satisfied (use --upgrade to upgrade): pyrsistent==0.11.13 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 26))
Requirement already satisfied (use --upgrade to upgrade): python-dateutil==2.5.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 27))
Requirement already satisfied (use --upgrade to upgrade): python-mimeparse==1.5.1 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 28))
Requirement already satisfied (use --upgrade to upgrade): pytz==2014.10 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 29))
Requirement already satisfied (use --upgrade to upgrade): simplejson==3.6.5 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 30))
Requirement already satisfied (use --upgrade to upgrade): six==1.9.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 31))
Requirement already satisfied (use --upgrade to upgrade): speaklater==1.3 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 32))
Requirement already satisfied (use --upgrade to upgrade): SQLAlchemy==1.0.14 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 33))
Requirement already satisfied (use --upgrade to upgrade): testscenarios==0.5.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 34))
Requirement already satisfied (use --upgrade to upgrade): testtools==2.0.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 35))
Requirement already satisfied (use --upgrade to upgrade): traceback2==1.4.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 36))
Requirement already satisfied (use --upgrade to upgrade): unittest2==1.1.0 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 37))
Requirement already satisfied (use --upgrade to upgrade): Werkzeug==0.9.6 in /usr/lib/python3/dist-packages (from -r requirements_py3.txt (line 38))
Requirement already satisfied (use --upgrade to upgrade): WTForms==2.0.2 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 39))
Requirement already satisfied (use --upgrade to upgrade): sqlparse==0.1.19 in /usr/local/lib/python3.4/dist-packages (from -r requirements_py3.txt (line 40))
Cleaning up..
Build is successful:
markm {download/pgadmin4-1.1/runtime} root# qmake
Project MESSAGE: Building for QT5+...
Project MESSAGE: Building for Linux/Mac...
Project MESSAGE: Using /usr/bin/python-config
Project MESSAGE: Python3 detected.
# make
... completely clean make, let me know if you want this output
./pgadmin4
Python path: ""
Python Home: ""
Webapp path: "/home/markm/download/pgadmin4-1.1/web/pgAdmin4.py"
Traceback (most recent call last):
File "/homemarkm/download/pgadmin4-1.1/web/pgAdmin4.py", line 24, in <module>
from pgadmin import create_app
File "/home/markm/download/pgadmin4-1.1/web/pgadmin/__init__.py", line 17, in <module>
from flask import Flask, abort, request, current_app
ImportError: No module named 'flask'
"Failed to launch the application server, server thread exiting."
------------------------------------------------------------ -------
I get a dialog box asking for a python path and an application path
it's prepopulated with:
python path: /usr/bin/python3.4
application path: /home/markm/download/pgadmin4-1.0-rc1/web/pgAdmin4.py
Flask is a module that is currenty available according to pip
pip list | grep -i flask
Flask (0.11.1)
Flask-Babel (0.11.1)
Flask-Gravatar (0.4.2)
Flask-Login (0.3.2)
Flask-Mail (0.9.1)
Flask-Principal (0.4.0)
Flask-Script (0.6.7)
Flask-Security (1.7.5)
Flask-SQLAlchemy (2.1)
Flask-WTF (0.12)
I'm very very very stuck here.
I found this post: https://www.postgresql.org/message-id/CACCA4P0jygzKLHUXz%3DS %2By-P%2B3QdW2t%2BQBG-2%2BWbf5 GvE4-E53g%40mail.gmail.com
I tried the recommended export PYTHONPATH="/usr/local/lib/python3.4/dist-packages" which is where flack and friends are installed... to no avail
That email is really quite old - we ignore PYTHONPATH these days (otherwise, if the user has it set for other purposes, it can break pgAdmin).
I made some significant updates to the README last week, which you should review - particularly the part about configuring the runtime (and probably the bit about using a Python virtual env, not the system environment).
In a nutshell, you need to figure out the right path to put in the dialogue that pops up, then hit OK and try again (I've drafted a patch to make that nicer from 1.2 onwards). It's probably the site-packages directory you need, not dist-packages; it should contain the packages that pip installed like Flask. On my machine here, in my pgadmin4-py3 virtual env, the correct path is ~/.virtualenvs/pgadmin4-py3/lib/python3.3/site-packages/.
It'll obviously be different for you, so adjust to suit. If it then complains about other things not being present, you may need to add another path - but we won't know that until you try.
Regards, Dave
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On 10/30/16 13:13, Dave Page wrote: > That email is really quite old - we ignore PYTHONPATH these days > (otherwise, if the user has it set for other purposes, it can break > pgAdmin). > > I made some significant updates to the README last week, which you > should review - particularly the part about configuring the runtime (and > probably the bit about using a Python virtual env, not the system > environment). > > In a nutshell, you need to figure out the right path to put in the > dialogue that pops up, then hit OK and try again (I've drafted a patch > to make that nicer from 1.2 onwards). It's probably the site-packages > directory you need, not dist-packages; it should contain the packages > that pip installed like Flask. On my machine here, in my pgadmin4-py3 > virtual env, the correct path > is ~/.virtualenvs/pgadmin4-py3/lib/python3.3/site-packages/. > > It'll obviously be different for you, so adjust to suit. If it then > complains about other things not being present, you may need to add > another path - but we won't know that until you try. > > Regards, Dave > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > I pulled the git for pgadmin4 and I'm following the new README on debian jessie (python 3.4) root# pip install virtualenv virtualenv-wrapper Downloading/unpacking virtualenv Downloading virtualenv-15.0.3-py2.py3-none-any.whl (3.5MB): 3.5MB downloaded Downloading/unpacking virtualenv-wrapper Could not find any downloads that satisfy the requirement virtualenv-wrapper Cleaning up... No distributions at all found for virtualenv-wrapper Storing debug log for failure in /root/.pip/pip.log Here's the pip.log Downloading/unpacking virtualenv-wrapper Getting page https://pypi.python.org/simple/virtualenv-wrapper/ Could not fetchURL https://pypi.python.org/simple/virtualenv-wrapper/: 404 Client Error: Not Found Will skip URL https://pypi.python.org/simple/virtualenv-wrapper/ when looking for download links for virtualenv-wrapper Getting page https://pypi.python.org/simple/ URLs to search for versionsfor virtualenv-wrapper: * https://pypi.python.org/simple/virtualenv-wrapper/ Getting page https://pypi.python.org/simple/virtualenv-wrapper/ Could not fetch URL https://pypi.python.org/simple/virtualenv-wrapper/: 404 Client Error: Not Found Will skip URL https://pypi.python.org/simple/virtualenv-wrapper/ when looking for download links for virtualenv-wrapper Could not find any downloads that satisfy the requirement virtualenv-wrapper Cleaning up... No distributions at all found for virtualenv-wrapper Although I did find a debian package for this.. README should probably include this as an option. root# apt-get install virtualenvwrapper ...snip... Setting up python-stevedore (0.14.1-1) ... Setting up python-virtualenv (1.11.6+ds-1) ... Setting up virtualenv-clone (0.2.5-1) ... Setting up virtualenvwrapper (4.3.1-2) ... And then of course the path would be different: source /usr/share/virtualenvwrapper/virtualenvwrapper.sh $ mkvirtualenv pgadmin4 Running virtualenv with interpreter /usr/bin/python3.4 Using base prefix '/usr' New python executable in pgadmin4/bin/python3.4 Also creating executable in pgadmin4/bin/python Installing setuptools, pip...done. As related to step 5... In my git checkout there is no $PGADMIN4_SRC/web/config_local.py. I do have $PGADMIN4_SRC/web/config.py though ---------------------------- 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 decodebyte 0xc3 in position 5965: ordinal not in range(128) Complete output from command python setup.py egg_info: Traceback (most recentcall 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)
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."
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
On 11/2/16 8:01 AM, Dave Page wrote:
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
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-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.
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
Hi
On Wednesday, November 2, 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 Wednesday, November 2, 2016, Mark Murawski <markm-lists@intellasoft.net> wrote:
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-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.p y", 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.
Great. FYI, I just committed a change to better detect and handle issues where the config database isn't properly created.
Is there a way to import my db connection list from pgadmin3?
No, sorry.
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
Yeah, I'd like to figure out how to automatically check the environment at startup. It wouldn't be tied to make - we don't really want users to have to deal with that at all, but would rather have packages built.
- 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
Most of that should really be handled by packagers - it's very system/distro specific and would be quite difficult for us to automate.
-- Detect broken database (if core schema parts are missing) and ask user if it's okay to rebuild
That's essentially what I just committed. If the config database seems to be broken, it will move it out of the way (telling you where it put it) and ask you to restart pgAdmin to recreate it. Fully automating that is somewhat non-trivial, and not really worth the effort for such a corner case.
Thanks, Dave.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company