Re: Installing pgAdmin 4 in Runtime Mode (stand alone) in Linux - Mailing list pgadmin-support

Hi Rich, This was another error resulting as an after effect from the formatting error on our blog. The python2 and python3 libraries got mixed up while building pgAdmin 4. Can you try and redo the whole process again? First make sure the virtual environment is not active and remove both the virtual environment and the pgAdmin4 directories: deactivate sudo rm -rf ~/virtualenvs/ sudo rm -rf ~/pgadmin4-2.0/ sudo rm -rf ~/.config/pgadmin/ sudo rm -rf ~/.pgadmin/ now follow the steps at https://humandata.associates/blog/data-engineering/installing-pgadmin-4-runtime-mode I hope everything will work now, please let us know! Best, Victor Op do 23 nov. 2017 om 20:12 schreef Richard Greenwood < richard.greenwood@gmail.com>: > Hi Floris, > > Thanks for the reply. I believe that I'm closer but still not quite there > yet: > > $~/pgadmin4-2.0/runtime/pgAdmin4 > Python path: > "/home/rich/virtualenvs/pgadmin4/lib/python3.5/site-packages/" > Python Home: "" > Webapp path: "/home/rich/pgadmin4-2.0/web/pgAdmin4.py" > Traceback (most recent call last): > File "/home/rich/pgadmin4-2.0/web/pgAdmin4.py", line 67, in > app = create_app() > File "/home/rich/pgadmin4-2.0/web/pgadmin/__init__.py", line 343, in > create_app > driver.init_app(app) > File "/home/rich/pgadmin4-2.0/web/pgadmin/utils/driver/__init__.py", > line 40, in init_app > DriverRegistry.load_drivers() > File "/home/rich/pgadmin4-2.0/web/pgadmin/utils/driver/registry.py", > line 88, in load_drivers > module = import_module(module_name) > File "/usr/lib/python2.7/importlib/__init__.py", line 37, in > import_module > __import__(name) > File > "/home/rich/pgadmin4-2.0/web/pgadmin/utils/driver/psycopg2/__init__.py", > line 23, in > import psycopg2 > File > "/home/rich/virtualenvs/pgadmin4/lib/python3.5/site-packages/psycopg2/__init__.py", > line 50, in > from psycopg2._psycopg import ( # noqa > ImportError: No module named _psycopg > > If I'm reading that correctly then I'm missing psycopg. I did "locate > psycopg" and it shows up under /usr/lib/python2.7/ > Might it be that I'm missing it for Python3? Sorry, I don't know Python. > > Thanks, > Rich > > > On Thu, Nov 23, 2017 at 8:25 AM, F.Sluiter wrote: > >> Oops made the same mistake twice: this is the new python setup: >> Can you please remove the virtualenvs folder: >> >> rm -rf ~/virtualenvs >> >> And than redo the updated "Python setup": >> >> pip3 install virtualenv >> >> mkdir ~/virtualenvs/ >> >> virtualenv -p python3 ~/virtualenvs/pgadmin4/ >> >> source ~/virtualenvs/pgadmin4/bin/activate >> >> That should do it: >> >> ~/pgadmin4-2.0/runtime/pgAdmin4 >> >> 2017-11-23 16:23 GMT+01:00 F.Sluiter : >> >>> Hi Rich, >>> Thx for trying! Sorry but this was a formatting error in our write up >>> which caused the python path to become mangled. We corrected that now so it >>> should be ok for . >>> Now to fix it for you: >>> Can you please remove the virtualenvs folder: >>> >>> rm -rf ~/virtualenvs >>> >>> And than redo the updated "Python setup": >>> >>> pip3 install virtualenv >>> >>> mkdir ~/virtualenvs/ >>> >>> cd ~/virtualenvs/ >>> >>> virtualenv -p python3 >>> >>> pgadmin4 source pgadmin4/bin/activate >>> >>> pip3 install -r ~/pgadmin4-2.0/requirements.txt >>> >>> That should do it: >>> >>> ~/pgadmin4-2.0/runtime/pgAdmin4 >>> >>> Note that the first time it reports a few errors when creating the local >>> config database, but those should go away the next time you start. >>> Let us know if it worked, or if you encounter more errors! >>> >>> Cheers, >>> Floris >>> >>> 2017-11-23 16:01 GMT+01:00 Richard Greenwood < >>> richard.greenwood@gmail.com>: >>> >>>> Thanks for the write up. I've been using "Local Mode" and look forward >>>> to trying the runtime. I ran into a couple problems following your >>>> instructions. They are probably quite minor, but I am not a Python guy so I >>>> have no clue as to how to fix the problems. >>>> virtualenv -p python3 gives error: >>>> Already using interpreter /usr/bin/python3 >>>> You must provide a DEST_DIR >>>> So I tried virtualenv -p python3 ~/virtualenvs/ which at least doesn't >>>> throw an error but I have no idea if that's correct. >>>> >>>> And finally, the moment of truth: >>>> $~/pgadmin4-2.0/runtime/pgAdmin4 >>>> Python path: >>>> "/home/rich/virtualenvs/pgadmin4/lib/python3.5/site-packages/" >>>> Python Home: "" >>>> Webapp path: "/home/rich/pgadmin4-2.0/web/pgAdmin4.py" >>>> Traceback (most recent call last): >>>> File "/home/rich/pgadmin4-2.0/web/pgAdmin4.py", line 34, in >>>> import config >>>> File "/home/rich/pgadmin4-2.0/web/config.py", line 30, in >>>> from pgadmin.utils import env, IS_PY2, IS_WIN, fs_short_path >>>> File "/home/rich/pgadmin4-2.0/web/pgadmin/__init__.py", line 17, in >>>> >>>> from flask import Flask, abort, request, current_app, session, >>>> url_for >>>> ImportError: No module named flask >>>> >>>> Rich >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Thu, Nov 23, 2017 at 5:46 AM, F.Sluiter wrote: >>>> >>>>> As it was not very clearly documented anywhere, we would like to share >>>>> how best to install PGadmin 4 on linux Mint and Ubuntu 16.04 in a virtual >>>>> environment as a stand alone desktop application (without the use of a >>>>> browser!). >>>>> >>>>> PgAdmin 4 can be run in three ways: >>>>> >>>>> - Server Mode in a web interface >>>>> - Local Mode in a web interface >>>>> - Local Mode in a standalone/runtime environment >>>>> The difference between the web interface and the runtime environment, >>>>> is that for the first you require to work from a browser. Whereas with the >>>>> runtime environments it runs as any other application on your desktop. This >>>>> is achieved by using Qt5, which creates a wrapper of the application. This >>>>> is a feature provided by the pgAdmin 4 team. However, on Ubuntu it wasn't >>>>> pre-build. Installing PgAdmin 4 for a runtime environment is a bit more >>>>> tricky than the other two, mostly because up until now it was not very well >>>>> documented. Especially it was unclear which dependencies it has on Ubuntu >>>>> and which options it needs at startup. After following this guide, you >>>>> will be able to run pgAdmin 4 in any of the three options on Ubuntu 16.04, >>>>> Linux Mint, or other Debian flavours. >>>>> >>>>> Please find the installation guide here: >>>>> >>>>> https://humandata.associates/blog/data-engineering/installing-pgadmin-4-runtime-mode >>>>> >>>>> Hopefully someone can add the information to the pgadmin documentation >>>>> and even better turn this into one (or 3) debian packages... >>>>> >>>>> >>>> >>>> >>>> -- >>>> Richard W. Greenwood, PLS >>>> www.greenwoodmap.com >>>> >>> >>> >> > > > -- > Richard W. Greenwood, PLS > www.greenwoodmap.com >