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

Can't install pgadmin4 on linux (flask required)

From
Mark Murawski
Date:
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!




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

From
Dave Page
Date:
Hi

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%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

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

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

From
Mark Murawski
Date:
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)




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

From
Mark Murawski
Date:
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."




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

From
Dave Page
Date:
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

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

From
Mark Murawski
Date:
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

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

From
Dave Page
Date:
Hi

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-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.

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