From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id EBD6B138334 for ; Wed, 7 Nov 2018 19:31:49 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 8CA45E0932; Wed, 7 Nov 2018 19:31:39 +0000 (UTC) Received: from mail-qk1-f194.google.com (mail-qk1-f194.google.com [209.85.222.194]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 1FADBE08D1 for ; Wed, 7 Nov 2018 19:31:38 +0000 (UTC) Received: by mail-qk1-f194.google.com with SMTP id a132so22549508qkg.1 for ; Wed, 07 Nov 2018 11:31:38 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:subject:to:in-reply-to:message-id :mime-version:content-disposition:content-transfer-encoding; bh=ExLKfBdxrYsnysp2/bdkLZ5MijicIBR4byuo/uAFSiI=; b=kNeJFxBs8lsz6DdJFfSaSmr8gmle0dJ7H6jlXgU9rRXaSorApdhzfCxbUD8ONIjJUs 0CUAcTC18tF0I3J3Ij0CkYYBbxudcWPlmUT3eF8NwpzdvPaWL8kjCgpHPssJQobQ9+RQ AtL7eM/s5PDk2WG7A2lZrj9JkH3NyJ2rKrVgQoX8SK8QeJInScEIeaZH8lgpd0iZjCM+ /44i9Qp5RHsmTj9xJim+n038Y297PWfU/ahyzKON251X+S0B8yrj3FLxI89KWPK5fwKk 8rAQzEjwrz3W42KBzgYLcC92VTgRLBpGIks0HColgmrhsioyAOucXUMVNH7E5v/fsCDq +XyQ== X-Gm-Message-State: AGRZ1gLiBIkk0DoBEwSTON6d6cH8btYV4LS1eEhCXlXLBZkWTG2uFkcv QmH/gSiZgw0TPD0ZaFbBi+WiwnBRxbY= X-Google-Smtp-Source: AJdET5fIVKFgE6Yus0CsYsSTkAz4dN7vX8386shZYug7oG8TIwob7HDG6TOW6ALk2AyDKttncojang== X-Received: by 2002:ac8:548a:: with SMTP id h10mr1602113qtq.15.1541619098029; Wed, 07 Nov 2018 11:31:38 -0800 (PST) Received: from ffortso4 ([2601:188:180:4f46:1ec1:deff:fe62:b72f]) by smtp.gmail.com with ESMTPSA id c45sm1085014qte.66.2018.11.07.11.31.37 for (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Wed, 07 Nov 2018 11:31:37 -0800 (PST) Date: Wed, 07 Nov 2018 14:31:36 -0500 From: Jack Subject: Re: [gentoo-user] Problem executing pgAdmin4 To: gentoo-user@lists.gentoo.org In-Reply-To: <3773074.2eBRju3bLs@main> (from pfrank@gmx.de on Wed Nov 7 10:56:52 2018) X-Mailer: Balsa 2.5.6-70-g55c9d84bf Message-Id: Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; DelSp=Yes; Format=Flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable X-Archives-Salt: ee9028d0-b628-4349-a65f-2c7f66a00449 X-Archives-Hash: 0aac5dbc492f94e51d5fb3c674e414be 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 =20 > 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 =20 > exiting. > > > > > \u0000=E2=9E=91\u0000\u0000\u0000=E6=A6=A0\u1C93=E7=BF=B1\u0000= =EB=A8=80=E1=B0=86=E7=BF=B1 > > > > > > =20 > \u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u000F\u0000\u0000\= u > > > > > > > > 0000=EF=BC=84 > > > > > > =20 > \u09FF=EF=BC=8D=EF=BC=86=CF=BF\uFFFF\u0005\u0A0E=EF=BC=8B=EF=BC=88\u07FE\= uFFFF\uFFFF=EF=BC=82\uFFFF=EF=BC=8C=E6=94=8D=E5=85=87=E9=A1=BB=EA=BE=AD=E6= =87=B0=E4=80=8C=E7=BF=B1\u0000\uEAB > > > > > > > > 0=E1=9C=8A=E7=BF=B1 > > > > > > =20 > \u0000=E3=99=94\uE4C8=E5=B8=9A=EA=BF=A7\u0000\u0000\u0000\u0000\u0000\u00= 00\u0000\u0000=E7=9B=9A=E9=A5=87=E4=A5=9F=E7=92=8A=EA=99=90=E4=80=8C=E7=BF= =B1 > > > > > > =20 > \u0000\uA8C8=E1=9C=89=E7=BF=B1\u0000=E9=AF=A9=EC=8A=84=E9=BC=97=E4=B7=B7\= u0E70=E4=80=8B=E7=BF=B1\u0000=E5=81=88=E4=80=8C=E7=BF=B1\u0000=E2=9C=A0=E5= =BE=B0=E2=BC=AC=E8=98=89=EC=A2=B8=E2=A0=AA=E7=BF=B1\u0000=EA=83=98=E1=9C=8B= =E7=BF=B1\u0000=E2=B7=AC=ED=96=89=E8=86=80=EA=88=8B > > > > > > > > =EA=88=A8=E4=80=8C=E7=BF=B1 > > > > > > =20 > \u0000=E5=9E=80=E1=9C=8B=E7=BF=B1\u0000=E6=B2=A6=E2=BB=8B=E4=8E=9B=E7=B7= =92=EC=A7=90=E2=A0=AA=E7=BF=B1\u0000=E5=9A=A0=E1=9C=8B=E7=BF=B1\u0000=E6=AE= =B5=EA=89=80=EA=92=85=ED=85=A3=E9=81=B0=E2=A0=A4=E7=BF=B1\u0000=E6=92=88=E1= =9C=8B=E7=BF=B1\u0000=E2=BB=B2=E5=B9=95=E7=82=88=EB=A9=95=E8=83=B0=E4=80=8C= =E7=BF=B1\u0000=E6=94=90 > > > > > > > > =E1=9C=8B=E7=BF=B1 > > > > > > =20 > \u0000\uE6A3=E1=93=90=E6=BA=AA=EA=BB=8A=EC=AB=A8=E2=A0=AA=E7=BF=B1\u0000= =E6=96=98=E1=9C=8B=E7=BF=B1\u0000\uF42F=EB=81=92=E4=99=AD=E3=94=8B=E6=98=B0= =E4=80=8C=E7=BF=B1\u0000=E6=98=A0=E1=9C=8B=E7=BF=B1\u0000=E7=9B=B0\uE66A=E2= =8D=B7=EC=BA=AA=E9=99=90=E1=AE=91=E7=BF=B1\ > > > > > > > > u0000 > > > > > > =20 > =EC=A2=B8=E1=9C=8A=E7=BF=B1\u0000=EB=B1=BE=D7=A1=E2=8F=A4=E9=B1=91=EB=A3= =B0=E2=A0=81=E7=BF=B1\u0000=EC=B6=B8=E1=9C=8A=E7=BF=B1\u0000=EA=A2=A6=E8=94= =9E=E8=A0=B9=EA=BE=9E=E3=A8=88=E4=80=90=E7=BF=B1\u0000=EC=B8=88=E1=9C=8A=E7= =BF=B1\u0000\uF20E=E3=A5=91=E4=B6=AB=ED=85=93=EC=9B=80=E2=A1=8C=E7=BF=B1\u0= 000=E9=A5=A0\ > > > > > > > > u1CBB ... > > > > > ----------------------- cut --------------------------- > > > > > > > > > > Selecting "Ok " in the dialog box i get an other tabbed =20 > 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 (=3D "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 - =20 > all > > >> above running as myself, although I get the same results with =20 > 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 =20 > 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). >=20 > I will try the upgrade. >=20 > For documentation purposes i got version 3.0 running using this guide: >=20 > 1. install dev-python/backports and dev-python/backports-csv (masked =20 > !) > 2. extend file /usr/share/pgadmin4/web/config_local.py to contain: > import os > DATA_DIR =3D os.path.realpath(os.path.expanduser(u'~/.pgadmin/')) > LOG_FILE =3D os.path.join(DATA_DIR, 'pgadmin4.log') > SQLITE_PATH =3D os.path.join(DATA_DIR, 'pgadmin4.db') > SESSION_DB_PATH =3D os.path.join(DATA_DIR, 'sessions') > STORAGE_DIR =3D os.path.join(DATA_DIR, 'storage') > SERVER_MODE =3D False > UPGRADE_CHECK_ENABLED =3D False >=20 > 3. start python /usr/share/pgadmin4/web/pgAdmin4.py > 4. point your browser to localhost:5050 >=20 > Hope that helps someone ... >=20 > regards > Petric That seems like a lot of effort, unless you really don't want to emerge =20 a testing version of a package. There is now an ebuild (testing) in =20 the tree for 3.5, and it also requires a testing version of =20 dev-python/psutil. It looks like some version incompatability snuck in =20 with some upgrade of either pgAdmin4 or python. I wonder if selecting =20 a different version of python would work? 3.5 uses localhost:40429, although I suppose that is configurable. In =20 addition, I really had to hunt to figure out how to stop the program. =20 Just closing the web browser does not stop the pgAdmin4 server process =20 - to close that you have to find it in the system tray, and shut it =20 down from there.=