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 1tCxio-00EonS-Mj for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 09:07:02 +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 1tCxim-003riP-1I for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 09:07:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tCxil-003riH-LN for pgadmin-support@lists.postgresql.org; Mon, 18 Nov 2024 09:07:00 +0000 Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tCxii-002UWL-OH for pgadmin-support@postgresql.org; Mon, 18 Nov 2024 09:06:58 +0000 Received: by mail-yb1-xb2d.google.com with SMTP id 3f1490d57ef6-e388ff24cfeso870200276.1 for ; Mon, 18 Nov 2024 01:06:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1731920816; x=1732525616; darn=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=QW3zjqyCQN/BHuX3fpfORpXsnsOGJ5nL4oG7xEGHu9M=; b=Tqgda1EzdmU9WWhwGLkrQsRkTRLFr7C9IensYCVG6tvOBgqxHI9Vfpze0W3/6Tldnq 31ldogDsZmSk4lL76/1vG4NI13HaNPsuerQ4VwGW0slltol8MU9RhZQ+IK8dtIX7Xszx n8Oqu/7KRdiZujILbsTV03E7wCRAVR29bUs18bMK1FVOMnUKe+BloGMRZtpjacv8BmjQ tj9SpOt/laFaj6zTm08RDiVh1pW9z9srWeY3mIUE7M7aw5Cwp6Glb+1UJXheuVlfg/zy Sx7D85I8OPccCr3I0zJ9oOj2ww4t4Dvi9Ky/W737ESN4OHnUp8JFI01f6horpyqJ7+Vt rdPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731920816; x=1732525616; 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=QW3zjqyCQN/BHuX3fpfORpXsnsOGJ5nL4oG7xEGHu9M=; b=XiWQLObEm4e06V6AsfT2sJt671GC4jVSwozcxcs8T+xDs4fck2Nmhm+zQ0+nGF3Sef bm2CLHiUK/n6omE2MOwG6f6Y2aKYURVkCOG/YL7kXOn/IJx/fFUhpOPFsSMkKJblp/n2 13LOYeUBLEMnnBl/iOgTiH2x3U24gQOIY2n6nRePFUKzb5SJ6wiKDrMQ43EFqGpnii77 eyqCqc7K+ulhXAUQZ80950K1Sj6Dg0A41Vpgg7W9YuNVEUbKNGPnpKsF/IKuEHlhMiU5 Aa562Y9GJL9bUGIBi1ueM3plfQMRQWAOlPT/dAAM8ELpMN5Dkl8dZGZiyWXaROaTgDz5 XTwQ== X-Gm-Message-State: AOJu0YzEJNSIvWX+w9g6sxD9wGSjD3Bz2AWMIfpzzq3Lt0wH4ysxuYf9 D6g/L5AP9BIJIqPRRBiiw8nqO66kMNFKB+KvCg/6MqH1UaoeD+6ZBeIjFQ1Q4P7Pq4BKFN0Kmy4 RohsUJmunVIr7P0Si6i6arHLxHqGmkeg9un0L X-Google-Smtp-Source: AGHT+IEnkR9Jo7IChaq8lI9ciHQRmeQ3+TONdd07EwStv0v7LhbJfLU4A3kaAckPyvBLZNGcuS4mneWNU6fjGjiHCkM= X-Received: by 2002:a05:6902:240c:b0:e33:1787:bd26 with SMTP id 3f1490d57ef6-e38263d41a2mr7567508276.39.1731920815750; Mon, 18 Nov 2024 01:06:55 -0800 (PST) MIME-Version: 1.0 References: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com> <909690a7-3dbc-4f75-97b1-b5829d41df97@gmail.com> <2bf48205-a8ad-49fc-a5d8-ada1bee6573d@gmail.com> In-Reply-To: <2bf48205-a8ad-49fc-a5d8-ada1bee6573d@gmail.com> From: Khushboo Vashi Date: Mon, 18 Nov 2024 14:36:43 +0530 Message-ID: Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12 To: Surya Widyanto Cc: pgAdmin Support Content-Type: multipart/alternative; boundary="00000000000000a71906272c3d66" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000000a71906272c3d66 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Nov 18, 2024 at 1:13=E2=80=AFPM Surya Widyanto = wrote: > Hi, > > I've upgraded the libpq5 to version 17.0-43PGDG.rhel8 > I've also restart the apache server. > What's the output of `yum list libpq5*` ? > > But the problem still exist. With the same error in log file. > > I've also can confirm that this also happened on my other server running > AlmaLinux 9 (x64). > My other server also has libpq5 with version 17.0-43PGDG.rhel9 and also > running as Web Mode via Apache. > > Regards, > ayrus02 > > On 18-11-2024 14:21, Khushboo Vashi wrote: > > Hi, > > On Mon, Nov 18, 2024 at 12:24=E2=80=AFPM Surya Widyanto wrote: > >> Hi Vashi, >> >> Yes, I can confirm it is installed with version: >> libpq5.x86_64 - v16.3-43PGDG.rhel8 >> > > During the pgAdmin upgrade on your system, the libpq5 should have been > upgraded to the latest (v17), which didn't happen in your case. > Can you please upgrade libpq5 to the latest version? It should fix this > issue. > > Thanks, > Khushboo > >> >> Regards, >> ayrus02 >> >> On 18-11-2024 13:48, Khushboo Vashi wrote: >> >> Is libpq5 installed on your system? >> >> On Mon, Nov 18, 2024 at 12:11=E2=80=AFPM Surya Widyanto >> wrote: >> >>> Hi, >>> >>> Today, I've upgraded my pgAdmin4 version from v8.12 to v8.13 using dnf >>> on AlmaLinux 8. >>> >>> My pgAdmin4 is installed as web mode and accessed via Apache. >>> >>> After upgrading to v8.13, when I access the pgAdmin4 address from web >>> browser, it give an error 500. When I look at the error log, it contain= s >>> the line below: >>> >>> mod_wsgi (pid=3D3535715): Failed to exec Python script file >>> '/usr/pgadmin4/web/pgAdmin4.wsgi'. >>> mod_wsgi (pid=3D3535715): Exception occurred processing WSGI script >>> '/usr/pgadmin4/web/pgAdmin4.wsgi'. >>> Traceback (most recent call last): >>> ImportError: no pq wrapper available. >>> Attempts made: >>> - couldn't import psycopg 'c' implementation: >>> /usr/pgadmin4/venv/lib64/python3.9/site-packages/psycopg_c/ >>> pq.cpython-39-x86_64-linux-gnu.so: undefined symbol: PQchangePassword >>> - couldn't import psycopg 'binary' implementation: No module named >>> 'psycopg_binary' >>> - couldn't import psycopg 'python' implementation: >>> >>> The primary concern is at *undefined symbol: PQchangePassword* >>> >>> Is there any bug or I have do the update wrongly? >>> >>> Regards, >>> ayrus02 >>> >> >> > --00000000000000a71906272c3d66 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Mon, Nov 18, 2024 at 1:13=E2=80=AF= PM Surya Widyanto <ayrus02@gmail.co= m> wrote:
=20 =20 =20
Hi,

I've upgraded the libpq5 to version 17.0-43PGDG.rhel8
I've also restart the apache server.
=

What's the output of `yum list libpq5*` ?

But the problem still exist. With the same error in log file.

I've also can confirm that this also happened on my other server running AlmaLinux 9 (x64).
My other server also has libpq5 with version 17.0-43PGDG.rhel9 and also running as Web Mode via Apache.

Regards,
ayrus02

On 18-11-2024 14:21, Khushboo Vashi wrote:
=20
Hi,

On Mon, Nov 18, 2024 at 12:24=E2=80=AFPM Surya Widyanto <ayrus02@gmail.com> wrote:
Hi Vashi,

Yes, I can confirm it is installed with version:
libpq5.x86_64 - v16.3-43PGDG.rhel8

During the pgAdmin upgrade on your system, the libpq5 should have been upgraded to the latest (v17), which didn't happen in your case.
Can you please upgrade libpq5 to the latest version? It should fix this issue.

Thanks,
Khushboo

Regards,
ayrus02

On 18-11-2024 13:48, Khushboo Vashi wrote:
Is libpq5 installed on your system?

On Mon, Nov 18, 2024 at 12:11=E2=80=AFPM Surya Widyanto <ayrus02@gmail.com> wrote:

Hi,

Today, I've upgraded my pgAdmin4 version fro= m v8.12 to v8.13 using dnf on AlmaLinux 8.

My pgAdmin4 is installed as web mode and accessed via Apache.

After upgrading to v8.13, when I access the pgAdmin4 address from web browser, it give an error 500. When I look at the error log, it contains the line below:

mod_wsgi (pid=3D3535715): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.=
mod_wsgi (pid=3D3535715): Exception occurred processing WSGI script '/usr/pgadmin4/web/pgAdmin4.wsgi'.
Traceback (most recent call last):
ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: /usr/pgadmin4/venv/lib64/python3.9/site-packages/psycopg_c/pq.cpython-39-x86_64= -linux-gnu.so: undefined symbol: PQchangePassword
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation:

The primary concern is at undefined symbol: PQchangePassword

Is there any bug or I have do the update wrongly?

Regards,
ayrus02



--00000000000000a71906272c3d66--