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 1tCwQI-00Egx1-VD for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 07:43:50 +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 1tCwQG-003XsB-9v for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 07:43:48 +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 1tCwQF-003Xs3-UP for pgadmin-support@lists.postgresql.org; Mon, 18 Nov 2024 07:43:48 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tCwQD-002TmV-KQ for pgadmin-support@postgresql.org; Mon, 18 Nov 2024 07:43:47 +0000 Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-20c805a0753so34709745ad.0 for ; Sun, 17 Nov 2024 23:43:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1731915824; x=1732520624; darn=postgresql.org; h=in-reply-to:disposition-notification-to:content-language:from :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=y6N3BdIuyjggzaDReykDT9ci2BgSG8BFQg9aHHtxFw0=; b=WojfDQoei0saBiln1m9YfKONMCfuC4sD6trHV0Jxza0zP1Vi9CRovaIt2IELdasMWx 5ebrAFGlAqqpy64QapcZYXgA7BSzGhCsHytPWfFv/9/yKA+HnX/zY125RdKgpvr9ONk6 647+DuU9JkSyy7rxWad/l85NGJJkDGxeG9K4UAuhiISJd2htfVwMpYovJROq/lN149dl 4E1QWTTt4jq/08ZmdWqk1/kYNtA3cRE/9GuCJmw9xlpbwKcPycHueIKLZk3+cTckJO7g b3vgYgd7LyORlIoD96dU1rgFIE1DV4X0p7tqfPLMNAzcEcz7oa1u7fqQqQogWmwnYsLc tllw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731915824; x=1732520624; h=in-reply-to:disposition-notification-to:content-language:from :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=y6N3BdIuyjggzaDReykDT9ci2BgSG8BFQg9aHHtxFw0=; b=hSWCmcJ6EX56nsIPNsU2SAZFmx8Hfi/4tgytHdcRCfehvy8g4tHYqucsU8Djc7ijzQ /5Q2sEXI6LX/DqYUrjOqSNLbtGUIpuz1IzlO83jZ7RuU1wbRBNmByr5QqVBPcvIuyReb yDhZrg0+j8Y1Y/B/t27jSFAtTQvWa+9kkYsrmCG3jKqy+sxLRTyLwlMrVx8PFMWfoRPy J17NROQQJzgkeDPUFEuGYkv/l9ASZkda61b0ctzeLMh5wBOCrc0MXadW/70R4gCppIET 4bEflzU9vL0geyGssW1Jmk+6hvlmzdkMAKZnIhXqK2VgNmFgX91xsoSonKgxQU3ScXKo ngCg== X-Gm-Message-State: AOJu0Yy9K9yFl7veBQpF4An7vWcytZMqmXUn7qG/+WpbEUHB3DWLrxOZ ipi5NVWQJti4QQuv+BETabTQAaGOCV7PsK9BaYxg4jAm0jr3yAsq X-Google-Smtp-Source: AGHT+IHBcUh80qZaWRPkl0WcccaeSTaB+RGZXq8PJpkk6k2AzDomxHTLL5tWLm7/J6TAz78maqLePA== X-Received: by 2002:a17:903:944:b0:211:e9c0:31c6 with SMTP id d9443c01a7336-211e9c0344fmr116264545ad.12.1731915823006; Sun, 17 Nov 2024 23:43:43 -0800 (PST) Received: from [10.0.12.15] ([158.140.184.2]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2120e4373c5sm20523755ad.57.2024.11.17.23.43.41 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 17 Nov 2024 23:43:42 -0800 (PST) Content-Type: multipart/alternative; boundary="------------YZgzP0pXystcv2Pvo7BjHLYB" Message-ID: <2bf48205-a8ad-49fc-a5d8-ada1bee6573d@gmail.com> Date: Mon, 18 Nov 2024 14:43:25 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12 To: Khushboo Vashi Cc: pgAdmin Support References: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com> <909690a7-3dbc-4f75-97b1-b5829d41df97@gmail.com> From: Surya Widyanto Content-Language: en-US Disposition-Notification-To: Surya Widyanto In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------YZgzP0pXystcv2Pvo7BjHLYB Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi, I've upgraded the libpq5 to version 17.0-43PGDG.rhel8 I've also restart the apache server. 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 PM 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 PM 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 contains the line below: >> >> mod_wsgi (pid=3535715): Failed to exec Python script file >> '/usr/pgadmin4/web/pgAdmin4.wsgi'. >> mod_wsgi (pid=3535715): 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* >> * >> > --------------YZgzP0pXystcv2Pvo7BjHLYB Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Hi,

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

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 PM 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 PM Surya Widyanto <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=3535715): Failed to exec Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.
mod_wsgi (pid=3535715): 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



--------------YZgzP0pXystcv2Pvo7BjHLYB--