public inbox for [email protected]  
help / color / mirror / Atom feed
From: Surya Widyanto <[email protected]>
To: Khushboo Vashi <[email protected]>
Cc: pgAdmin Support <[email protected]>
Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12
Date: Mon, 18 Nov 2024 16:18:07 +0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFOhELeUHU0FX-y7r4dD974DbS=zOTzFSUeAnjVmMbunaXpccw@mail.gmail.com>
References: <[email protected]>
	<CAFOhELdyd3yiHHH-wbYn12yD+LFZjua7t==h-L_oLuiUuq2uxQ@mail.gmail.com>
	<[email protected]>
	<CAFOhELdnwePfWjfE7hFB2AkhP5hSojWUFOdL7KySwFKSDYmkqQ@mail.gmail.com>
	<[email protected]>
	<CAFOhELeUHU0FX-y7r4dD974DbS=zOTzFSUeAnjVmMbunaXpccw@mail.gmail.com>

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 
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

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 PM Surya Widyanto <[email protected]> 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 PM Surya Widyanto
>>     <[email protected]> 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
>>>         <[email protected]> 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
>>>             <http://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*
>>>             *
>>>
>>
>


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox