Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1stK0Y-00FIPF-89 for pgadmin-support@arkaria.postgresql.org; Wed, 25 Sep 2024 04:52:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1stK0X-002yIA-3A for pgadmin-support@arkaria.postgresql.org; Wed, 25 Sep 2024 04:52:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1stK0W-002yI2-PE for pgadmin-support@lists.postgresql.org; Wed, 25 Sep 2024 04:52:08 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1stK0N-000xbm-Dj for pgadmin-support@lists.postgresql.org; Wed, 25 Sep 2024 04:52:06 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-27beb2496f4so2566601fac.1 for ; Tue, 24 Sep 2024 21:52:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1727239919; x=1727844719; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=g/3sBSuIUsHAca3mGo+/qot5zzCT/IRXi5LVr+v24TU=; b=Dcv+YdhKkekNjB6i3FSRCav7qDfISWOaT4t8K2gdKEdJDEgHsg3eHArK1JEm4CvJNE sHW3+8l7YeZBeC0i49P1TCYkSdR/9AwHk9rc89WP89W3iVpEKwPJ+8mJs/ZDH/CmWR4q 5Kml4bBJ4VjlQrjmzGGSBrdw4NFPr+tc/DJfW1tAxV3PFsFHy828kL/+ISGFykWKV637 zmP80z1jBKf5+FPY2Ee3MtKcSFX3JPiyHYf5hg5VNyGXLAivqEEAwT8wnvRQzf/RDxTf DtJaNSE/41Fj2Bx1gP+zfYAiSwS3Wyqgzmr+7YNeFt0SVleKq56lZEC8NQ9j63clZVBl buIg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727239919; x=1727844719; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=g/3sBSuIUsHAca3mGo+/qot5zzCT/IRXi5LVr+v24TU=; b=bp0uIlzPvc+grgWpVHgSwxor3WULeNIQN9KMiOwGuTzWXSiKGmKuJcbLm9mLoKVVMq AESe2DCqXLLfA+SuyplbBsdc1XGkZCLtlNz8GpgW5ETA1EVmpZTPhWJ9/Y/0GnRvMFrC KYtUk+wiql2qkkSqKVU4v5yg/UXTm4Qg/WBh9Bkhq2V0j/g96ZV6AWUtBVkozxLoBVve SKsp1KJWNm7CG30L6P8M84KiD/2ublK3TBihuOonyM6WDrtU2O9D/Wr5Rs3Orkci03Uk HzJyA2UTby6Viz2qz2lK2EmXLHxHswKDgu4XLL3w8dIH5HNXnf50394afCeyyF24PSq9 vKOA== X-Gm-Message-State: AOJu0YxHBaUZk0NsB8VHoTkVT6Kaz+GiASiALXEc/eGL4peHA2X89Ls3 PXSM9OMHK8XhMhRqcAr/r01bcfLKPShEWRI2W7pyyshSjyI6z6NzXVwRH/CHSUhb2OJyjOMj7ue vu0sjzx8kCVeDY5Mjzg9FiXRl8pc6c1+aukvE X-Google-Smtp-Source: AGHT+IFOr6vfcOlxSxqQECMvxF0LG2gAtQ5EuSAAXcvt7Bs5Mtl8QmCsHAg2E2eZoj8+9ANSahN0jynk3PJMj+d7CD0= X-Received: by 2002:a05:6870:14d0:b0:277:c113:5b26 with SMTP id 586e51a60fabf-286e12b8902mr1284279fac.7.1727239918708; Tue, 24 Sep 2024 21:51:58 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 25 Sep 2024 10:21:22 +0530 Message-ID: Subject: Re: Unable to run PGAdmin in Ubuntu 24 To: Steven Adams Cc: "pgadmin-support@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000cc059b0622ea612e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cc059b0622ea612e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Steven, What is your pgAdmin version? You'll have to uninstall and install pgAdmin again. On Wed, Sep 25, 2024 at 4:54=E2=80=AFAM Steven Adams wrote: > Hello, > > I'm using PostgreSQL and PGAdmin on a Ubuntu server. Both worked when th= e > 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 thi= s: > > [Mon Sep 16 11:24:55.627995 2024] [wsgi:error] [pid 163422] [remote > 127.0.0.1:37332] mod_wsgi (pid=3D163422): Failed to exec Python script fi= le > '/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=3D163422): 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 > > [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 > > [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 > [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. > --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --000000000000cc059b0622ea612e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Steven,

What is your pgAdmin version? You'll h= ave to uninstall and install pgAdmin again.

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

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

[Mon Sep 16 11:24:55.627995 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi= (pid=3D163422): Failed to exec Python script file '/usr/pgadmin4/web/p= gAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628053 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] mod_wsgi= (pid=3D163422): Exception occurred processing WSGI script '/usr/pgadmi= n4/web/pgAdmin4.wsgi'.
[Mon Sep 16 11:24:55.628970 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] Tracebac= k (most recent call last):
[Mon Sep 16 11:24:55.633940 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] =C2=A0 F= ile "/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] =C2=A0 = =C2=A0 import config
[Mon Sep 16 11:24:55.634000 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] =C2=A0 F= ile "/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] =C2=A0 = =C2=A0 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] =C2=A0 F= ile "/usr/pgadmin4/web/pgadmin/__init__.py", line 24, in <modu= le>
[Mon Sep 16 11:24:55.634022 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] =C2=A0 = =C2=A0 from flask import Flask, abort, request, current_app, session, url_f= or
[Mon Sep 16 11:24:55.634045 2024] [wsgi:error] [pid 163422] [remote 127.0.0.1:37332] ModuleNo= tFoundError: No module named 'flask'

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


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Sr. Software Architect=C2=A0| enterprisedb.com