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 1tCy28-00Eqoi-Lu for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 09:27:00 +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 1tCy26-003wAV-2u for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 09:26:58 +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 1tCy25-003wAM-Oa for pgadmin-support@lists.postgresql.org; Mon, 18 Nov 2024 09:26:58 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tCy21-002Y3Y-FM for pgadmin-support@postgresql.org; Mon, 18 Nov 2024 09:26:56 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-6ea5003deccso14619197b3.0 for ; Mon, 18 Nov 2024 01:26:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1731922012; x=1732526812; 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=D9V8vi3rLxRlNPTJMZpF9gHHsQS0YGYqRksD7G1hP8k=; b=mpaw08oI//cPaIca427y2soO+HqhH0BwGDj8lZR0RSElssZpR1EwnvGwMYR3rkp0KP ElAbEIQi4psgzDAyMYp1gsD76s7Ks4JEGjlnZEljDOKGxsqenWCsGDibOTDAf2RXs54S 9k7BW9LrdJEVuF44v8ATKqcRg0aUT3zUS6H0YcpSPlMBOD3htKtXWZALmtOktWU2ozA2 rjoj9I4x/tIITUcaXR3C1GHIgeb3dkjN6u0lEIw+f8HCzJe57aHq5jHDYiSR6VPITZ40 tCDPqlqL9T6lEDpzN21fKTk6beyyYHYCUay6VHb/xEZPMcCc31HUVBTmpUg7kGwEUO11 7uZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731922012; x=1732526812; 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=D9V8vi3rLxRlNPTJMZpF9gHHsQS0YGYqRksD7G1hP8k=; b=Bo7KghlLHky2KBdMw7LDtm6ANFMo1g7j7og9iFVXS8ET0kNem6I2IYezpF8WHyEtqW 4JK98LMsvucOWCvIokhJbAkQrW2LixndGJ1O7jE09qh9eQRpo4ht706OIkHf8umZfILm 9gfLxXEQI+subOD8Yg2w55+rMiC5uY3Mh9OOC/hjt/as+bNn4nwG8u1EpxuXd6jamL3s RLV/2j2WZU5eyLvd+uW07YrJHDMIR/iX3e90aqbsZk/1zTJ5ruBclIiHxVd4CCSvHUf6 JzbSMl77VfU3ibS50SnevkzYhL3WHPzp+FMUsKqHqsIxweUjNHM+5gPpmQF6Pu407wE0 MBnw== X-Gm-Message-State: AOJu0YxIFeoAXrlb8bLyaBvmJVwa85aMYesnBqV/8WiTbU/dMQpILe3i umvo9Xc9WKAXpDHtS6i+38ifp7Nh8X5YJQhgvFb52N0EbIrlV356Zm4UoR+FgrYxQlIQCMgX2dQ 99Lw0sDOPgvGui21pq0pzaAEO18uoh5dM/PfFW8AFXTc+n60= X-Google-Smtp-Source: AGHT+IF8yp8XC1+rkklVVTV3G+WheWmBysiQnH2RkZbCAYlr7YcuIlELfWNtcrMuT0/3Q/+jbKOTJ7XybUTVzUj5g14= X-Received: by 2002:a05:6902:70a:b0:e38:7b9d:f27a with SMTP id 3f1490d57ef6-e387b9df76cmr6116384276.9.1731922012536; Mon, 18 Nov 2024 01:26:52 -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> <3dd1d051-875a-4d9c-bfee-1753ace8a615@gmail.com> In-Reply-To: <3dd1d051-875a-4d9c-bfee-1753ace8a615@gmail.com> From: Khushboo Vashi Date: Mon, 18 Nov 2024 14:56:40 +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="0000000000005640f206272c84b0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005640f206272c84b0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Nov 18, 2024 at 2:48=E2=80=AFPM Surya Widyanto = wrote: > Hi, > > Below are the output of *dnf list libpq5** on my AlmaLinux 8 (x64) > machine: > > Last metadata expiration check: 3:28:40 ago on Mon 18 Nov 2024 12:43:19 P= M > WIB. > Installed Packages > libpq5.x86_64 - 17.0-43PGDG.rhel8 - @pgAdmin4 > Available Packages > libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 - pgAdmin4 > libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 - pgdg-common > > This looks fine. What's the output of pg_config ? > And below are the output of *dnf list libpq5** on my AlmaLinux 9 (x64) > machine: > > Last metadata expiration check: 0:38:20 ago on Sen 18 Nov 2024 03:33:43 . > Installed Packages > libpq5.x86_64 - 17.0-43PGDG.rhel9 - @pgdg-common > Available Packages > libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 - pgAdmin4 > libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 - pgdg-common > > Regards, > ayrus02 > On 18-11-2024 16:06, Khushboo Vashi wrote: > > > > 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 contai= ns >>>> 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 >>>> >>> >>> >> > --0000000000005640f206272c84b0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


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

Below are the output of dnf list libpq= 5* on my AlmaLinux 8 (x64) machine:

Last metadata expiration check: 3:28:40 ago on Mon 18 Nov 2024 12:43:19 PM WIB.
Installed Packages
libpq5.x86_64 - 17.0-43PGDG.rhel8 - @pgAdmin4
Available Packages
libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 - pgAdmin4
libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 - pgdg-common

This looks fine.
What&= #39;s the output of pg_config ?=C2=A0
And below are the output of dnf list l= ibpq5* on my AlmaLinux 9 (x64) machine:

Last metadata expiration check: 0:38:20 ago on Sen 18 Nov 2024 03:33:43 .
Installed Packages
libpq5.x86_64 - 17.0-43PGDG.rhel9 - @pgdg-common
Available Packages
libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 - pgAdmin4
libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 - pgdg-common

Regards,
ayrus02

On 18-11-2024 16:06, Khushboo Vashi wrote:
=20


On Mon, Nov 18, 2024 at 1:13=E2=80=AFPM Surya Widyanto <ayrus02@gmail.com> 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 <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 Widy= anto <ayrus02@gmail.com> 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 contains the line below:

mod_wsgi (pid=3D3535715): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi&= #39;.
mod_wsgi (pid=3D3535715): Exception occurred processing WSGI script '/usr/pgadmin4/web/pgAdmin4.wsgi&= #39;.
Traceback (most recent call last): ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c&= #39; 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 'bi= nary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'py= thon' implementation:

The primary concern is at undefined symbol: PQchangePassword

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

Regards,
ayrus02




--0000000000005640f206272c84b0--