Thread: Unable to run PGAdmin in Ubuntu 24

Unable to run PGAdmin in Ubuntu 24

From
Steven Adams
Date:
Hello,

I'm using PostgreSQL and PGAdmin on a Ubuntu server.  Both worked when the server was on Ubuntu version 22, but after it was upgraded to 24, PGAdmin started causing an internal server error.  The Apache error log shows this:

[Mon Sep 16 11:24:55.627995 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi (pid=163422): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628053 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi (pid=163422): Exception occurred processing WSGI script '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628970 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] Traceback (most recent call last):
[Mon Sep 16 11:24:55.633940 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/pgAdmin4.wsgi", line 25, in <module>
[Mon Sep 16 11:24:55.633983 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     import config
[Mon Sep 16 11:24:55.634000 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/config.py", line 33, in <module>
[Mon Sep 16 11:24:55.634006 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     from pgadmin.utils import env, IS_WIN, fs_short_path
[Mon Sep 16 11:24:55.634017 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/pgadmin/__init__.py", line 24, in <module>
[Mon Sep 16 11:24:55.634022 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     from flask import Flask, abort, request, current_app, session, url_for
[Mon Sep 16 11:24:55.634045 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] ModuleNotFoundError: No module named 'flask'

I've never seen this sort of error before, so any advice would be appreciated.

Re: Unable to run PGAdmin in Ubuntu 24

From
Aditya Toshniwal
Date:
Hi Steven,

What is your pgAdmin version? You'll have to uninstall and install pgAdmin again.

On Wed, Sep 25, 2024 at 4:54 AM Steven Adams <stevenadams@spiralxllc.com> wrote:
Hello,

I'm using PostgreSQL and PGAdmin on a Ubuntu server.  Both worked when the server was on Ubuntu version 22, but after it was upgraded to 24, PGAdmin started causing an internal server error.  The Apache error log shows this:

[Mon Sep 16 11:24:55.627995 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi (pid=163422): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628053 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi (pid=163422): Exception occurred processing WSGI script '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628970 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] Traceback (most recent call last):
[Mon Sep 16 11:24:55.633940 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/pgAdmin4.wsgi", line 25, in <module>
[Mon Sep 16 11:24:55.633983 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     import config
[Mon Sep 16 11:24:55.634000 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/config.py", line 33, in <module>
[Mon Sep 16 11:24:55.634006 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     from pgadmin.utils import env, IS_WIN, fs_short_path
[Mon Sep 16 11:24:55.634017 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/pgadmin/__init__.py", line 24, in <module>
[Mon Sep 16 11:24:55.634022 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     from flask import Flask, abort, request, current_app, session, url_for
[Mon Sep 16 11:24:55.634045 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] ModuleNotFoundError: No module named 'flask'

I've never seen this sort of error before, so any advice would be appreciated.


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"

Re: Unable to run PGAdmin in Ubuntu 24

From
Aditya Toshniwal
Date:
Hi Steven,

Please try to uninstall first and then install again.

On Thu, Sep 26, 2024 at 4:18 AM Steven Adams <stevenadams@spiralxllc.com> wrote:
I just tried this command:
sudo apt reinstall pgadmin4

It gave me this error:
Reinstallation of pgadmin4 is not possible, it cannot be downloaded.

From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Tuesday, September 24, 2024 11:51 PM
To: Steven Adams <stevenadams@spiralxllc.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: Unable to run PGAdmin in Ubuntu 24
 
Hi Steven,

What is your pgAdmin version? You'll have to uninstall and install pgAdmin again.

On Wed, Sep 25, 2024 at 4:54 AM Steven Adams <stevenadams@spiralxllc.com> wrote:
Hello,

I'm using PostgreSQL and PGAdmin on a Ubuntu server.  Both worked when the server was on Ubuntu version 22, but after it was upgraded to 24, PGAdmin started causing an internal server error.  The Apache error log shows this:

[Mon Sep 16 11:24:55.627995 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi (pid=163422): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628053 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi (pid=163422): Exception occurred processing WSGI script '/usr/pgadmin4/web/pgAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628970 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] Traceback (most recent call last):
[Mon Sep 16 11:24:55.633940 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/pgAdmin4.wsgi", line 25, in <module>
[Mon Sep 16 11:24:55.633983 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     import config
[Mon Sep 16 11:24:55.634000 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/config.py", line 33, in <module>
[Mon Sep 16 11:24:55.634006 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     from pgadmin.utils import env, IS_WIN, fs_short_path
[Mon Sep 16 11:24:55.634017 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]   File "/usr/pgadmin4/web/pgadmin/__init__.py", line 24, in <module>
[Mon Sep 16 11:24:55.634022 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332]     from flask import Flask, abort, request, current_app, session, url_for
[Mon Sep 16 11:24:55.634045 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] ModuleNotFoundError: No module named 'flask'

I've never seen this sort of error before, so any advice would be appreciated.


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"