TW: pgAdmin4 broken
Hi, pgAdmin4, the graphical tool to manage postgres databases, seems to be broken since some time. The application hangs at 'starting pgAdmin4 server' until it times out: test@localhost:/> pgAdmin4 QCoreApplication::applicationFilePath: Please instantiate the QApplication object first QCoreApplication::applicationFilePath: Please instantiate the QApplication object first Semaphore name: "pgadmin4-test-3ed67051214d25124b2c63f3117290d1-sema" Shared memory segment name: "pgadmin4-test-3ed67051214d25124b2c63f3117290d1- shmem" Python path: "/usr/lib/python3.8/site-packages:/usr/lib64/python3.8/site- packages" Python Home: "" Webapp path: "/usr/lib/python3.8/site-packages/pgadmin4-web/pgAdmin4.py" Failed to connect to the server: "Connection refused" - request URL: "http:// 127.0.0.1:44629/misc/ping?key=065c433d-2777-4257-8429-3ca5c1c2d93a" . Anyone got it working? Bugreport to this: https://bugzilla.opensuse.org/show_bug.cgi?id=1189205 Cheers Axel
On Mon, Aug 30, 2021 at 7:45 PM Axel Braun <docb@opensuse.org> wrote:
Hi,
pgAdmin4, the graphical tool to manage postgres databases, seems to be broken since some time.
The application hangs at 'starting pgAdmin4 server' until it times out:
test@localhost:/> pgAdmin4 QCoreApplication::applicationFilePath: Please instantiate the QApplication object first QCoreApplication::applicationFilePath: Please instantiate the QApplication object first Semaphore name: "pgadmin4-test-3ed67051214d25124b2c63f3117290d1-sema" Shared memory segment name: "pgadmin4-test-3ed67051214d25124b2c63f3117290d1- shmem" Python path: "/usr/lib/python3.8/site-packages:/usr/lib64/python3.8/site- packages" Python Home: "" Webapp path: "/usr/lib/python3.8/site-packages/pgadmin4-web/pgAdmin4.py" Failed to connect to the server: "Connection refused" - request URL: "http:// 127.0.0.1:44629/misc/ping?key=065c433d-2777-4257-8429-3ca5c1c2d93a" .
Anyone got it working?
Bugreport to this: https://bugzilla.opensuse.org/show_bug.cgi?id=1189205
Cheers Axel
Hi Axel, I can make it work, after several trials and reading the arch bbs (https://bbs.archlinux.org/viewtopic.php?id=266423). Seems that the several python packages don't match with the pgadmin4-4.30 (version in TW oss repo) requirement. I need to downgrade several python packages, and install it using pip python-flask==1.1.2-4 python-flask-security-too==3.3.3-3 python-psycopg2==2.8.6-4 python-wtforms==2.2.1-10 pip install it to /usr/local/lib/python3.8/site-packages instead of /usr/lib/python3.8/site/packages. Also it put the flask under /usr/local/bin. So you need to configure the python path also for /usr/local/bin and /usr/local/lib/python3.8/site-packages on pgadmin4 configuration. I will add this info into your bug report. Maybe easier for me to install dbeaver, but I always love to use pgadmin :-) Best, -- Edwin
Hi Edwin, Am Mittwoch, 1. September 2021, 19:02:21 CEST schrieb medwinz: ....
Anyone got it working?
Bugreport to this: https://bugzilla.opensuse.org/show_bug.cgi?id=1189205
I can make it work, after several trials and reading the arch bbs (https://bbs.archlinux.org/viewtopic.php?id=266423). Seems that the several python packages don't match with the pgadmin4-4.30 (version in TW oss repo) requirement. I need to downgrade several python packages, and install it using pip
python-flask==1.1.2-4 python-flask-security-too==3.3.3-3 python-psycopg2==2.8.6-4 python-wtforms==2.2.1-10
pip install it to /usr/local/lib/python3.8/site-packages instead of /usr/lib/python3.8/site/packages. Also it put the flask under /usr/local/bin. So you need to configure the python path also for /usr/local/bin and /usr/local/lib/python3.8/site-packages on pgadmin4 configuration.
I will add this info into your bug report.
Thanks for your analysis. That may explain why it works in Leap 15.3, but not in TW I guess an upgrade to current version 5.6 may help? Version 4.30 in TW looks somewhat outdated....
Maybe easier for me to install dbeaver, but I always love to use pgadmin :-)
Will look a it! Thanks Axel
participants (2)
-
Axel Braun
-
medwinz