Thread: Unable to run PGAdmin in Ubuntu 24
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.
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
"Don't Complain about Heat, Plant a TREE"
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 pgadmin4It 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 24Hi 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"Don't Complain about Heat, Plant a TREE"
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"