Re: [gentoo-user] Problem executing pgAdmin4

[Jack]

On 2018.11.07 10:56, Petric Frank wrote:
> Am Dienstag, 6. November 2018, 21:24:37 CET schrieb Jack:
> > On 2018.11.06 00:19, Petric Frank wrote:
> > > Am Dienstag, 6. November 2018, 01:00:04 CET schrieb Jack:
> > > > On 2018.11.05 14:21, Petric Frank wrote:
> > >>> pgadmin3 is masked now. So i installed pgadmin4 (current stable
> > >>> verion 3.0).  Installed w/o problems.
> > >>>
> > > > > But when executing it (in a terminal window) i get a dialog
> box
> > >
> > > saying
> > >
> > > > >   An error occurred initialising the application server:
> > > > >   An error occurred initialising the application server:
> > > > >   %1
> > > > >
> > > > > and the terminal window is filled pagewise with
> > > > > ----------------------- cut ---------------------------
> > > > > Python path:  "/usr/lib64/python3.6/site-packages"
> > > > > Python Home:  ""
> > > > > Webapp path:  "/usr/share/pgadmin4/web/pgAdmin4.py"
> > > > > "Failed to launch the application server, server thread
> exiting.
> > > > > \u0000➑\u0000\u0000\u0000榠\u1C93翱\u0000먀ᰆ翱
> > >
> > >
> \u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u000F\u0000\u0000\u
> > >
> > > > > 0000＄
> > >
> > >
> \u09FF－＆Ͽ\uFFFF\u0005\u0A0E＋（\u07FE\uFFFF\uFFFF＂\uFFFF，攍兇须꾭懰䀌翱\u0000\uEAB
> > >
> > > > > 0ᜊ翱
> > >
> > >
> \u0000㙔\uE4C8帚꿧\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000盚饇䥟璊Ꙑ䀌翱
> > >
> > >
> \u0000\uA8C8ᜉ翱\u0000鯩슄鼗䷷\u0E70䀋翱\u0000偈䀌翱\u0000✠徰⼬蘉좸⠪翱\u0000ꃘᜋ翱\u0000ⷬ행膀ꈋ
> > >
> > > > > ꈨ䀌翱
> > >
> > >
> \u0000垀ᜋ翱\u0000沦⻋䎛緒짐⠪翱\u0000嚠ᜋ翱\u0000段ꉀꒅ텣遰⠤翱\u0000撈ᜋ翱\u0000⻲幕炈멕胰䀌翱\u0000攐
> > >
> > > > > ᜋ翱
> > >
> > >
> \u0000\uE6A3ᓐ溪껊쫨⠪翱\u0000斘ᜋ翱\u0000\uF42F끒䙭㔋昰䀌翱\u0000映ᜋ翱\u0000盰\uE66A⍷캪限ᮑ翱\
> > >
> > > > > u0000
> > >
> > >
> 좸ᜊ翱\u0000뱾ס⏤鱑룰⠁翱\u0000춸ᜊ翱\u0000ꢦ蔞蠹꾞㨈䀐翱\u0000츈ᜊ翱\u0000\uF20E㥑䶫텓움⡌翱\u0000饠\
> > >
> > > > > u1CBB ...
> > > > > ----------------------- cut ---------------------------
> > > > >
> > > > > Selecting "Ok " in the dialog box i get an other tabbed
> dialog box
> > > > > asking for
> > > > > a browser command (currently empty) and Python paths (preset
> > >
> > > values
> > >
> > > > > seem ok).
> > > > >
> > > > > Entering "/usr/bin/firefox %URL%" as browser command does not
> > >
> > > change
> > >
> > > > > anything.
> > > > >
> > > > > Any hints ?
> > > > >
> > > > > Info:
> > > > >   Kernel 4.14.65 (Gentoo)
> > > > >   KDE Plasma (kde-plasma/plasma-meta-5.13.5)
> > > > >   Memory 16 G
> > > > >   Apache installed but not running
> > > > >   Browsers konqueror and firefox available
> > > > >   pgadmin3 still installed
> > > > >   Python 2.7, 3.6 and 3.5 installed (= "eselect python list"
> > >
> > > output)
> > >
> > > > > regards
> > > > >
> > > > >   Petric
> > > >
> > > > Interesting.  I only get
> > > > -------------
> > > > Python path:  "/usr/lib64/python3.6/site-packages"
> > > > Python Home:  ""
> > > > Webapp path:  "/usr/share/pgadmin4/web/pgAdmin4.py"
> > > > ------------
> > >>
> > >> And then a popup that says  "The application server could not be
> > >> contacted."
> > >>
> > >> This is with eselect postgresql set to either 9.6 or 10.  Also -
> all
> > >> above running as myself, although I get the same results with
> root
> > >> or postgres.  It looks like although I have 10 installed, I never
> > >> initialized it, although 9.6 should work OK.
> > >>
> > >> I'm now emerging the test version of pgAdmin4 to see if it makes
> any
> > >> difference.
> > >>
> > > > Jack
> > >
> > > Hello Jack,
> > >
> > > if i remove the .pgadmin directory in my home i get - after a long
> > > wait a dialog box saying  The application server could not be
> > > contacted.
> > >
> > > In the terminal it prints:
> > > -------------------------- cut ------------------------------
> > > Python path:  "/usr/lib64/python3.6/site-packages"
> > > Python Home:  ""
> > > Webapp path:  "/usr/share/pgadmin4/web/pgAdmin4.py"
> > > NOTE: Configuring authentication for DESKTOP mode.
> > > -------------------------- cut ------------------------------
> > >
> > > Starting pgAdmin4 again i get the output and dialogs i wrote
> > > initially in this thread.
> >
> > I installed pgadmin4-3.4-r1 and it works.  3.5 has been released
> > (https://www.pgadmin.org/) so I filed a version bump request
> > (https://bugs.gentoo.org/670556).
>
> I will try the upgrade.
>
> For documentation purposes i got version 3.0 running using this guide:
>
> 1. install dev-python/backports and dev-python/backports-csv (masked
> !)
> 2. extend file /usr/share/pgadmin4/web/config_local.py to contain:
>     import os
>     DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))
>     LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')
>     SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')
>     SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
>     STORAGE_DIR = os.path.join(DATA_DIR, 'storage')
>     SERVER_MODE = False
>     UPGRADE_CHECK_ENABLED = False
>
> 3. start python /usr/share/pgadmin4/web/pgAdmin4.py
> 4. point your browser to localhost:5050
>
> Hope that helps someone ...
>
> regards
>   Petric
That seems like a lot of effort, unless you really don't want to emerge  
a testing version of a package.  There is now an ebuild (testing) in  
the tree for 3.5, and it also requires a testing version of  
dev-python/psutil.  It looks like some version incompatability snuck in  
with some upgrade of either pgAdmin4 or python.  I wonder if selecting  
a different version of python would work?

3.5 uses localhost:40429, although I suppose that is configurable.  In  
addition, I really had to hunt to figure out how to stop the program.   
Just closing the web browser does not stop the pgAdmin4 server process  
- to close that you have to find it in the system tray, and shut it  
down from there.