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

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 > >: >> >>> 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/pgadmi >>> n4/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/installin >>>> g-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