Re: Installing pgAdmin 4 in Runtime Mode (stand alone) in Linux

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 <module>
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 <module>
import psycopg2
File
"/home/rich/virtualenvs/pgadmin4/lib/python3.5/site-packages/psycopg2/__init__.py",
line 50, in <module>
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 <fsluiter(at)gmail(dot)com> 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 <fsluiter(at)gmail(dot)com>:
>
>> 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(dot)greenwood(at)gmail(dot)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/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 <module>
>>> import config
>>> File "/home/rich/pgadmin4-2.0/web/config.py", line 30, in <module>
>>> 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
>>> <module>
>>> 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 <fsluiter(at)gmail(dot)com> 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