Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12

On Mon, Nov 18, 2024 at 2:48 PM Surya Widyanto <ayrus02(at)gmail(dot)com> 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 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'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 PM Surya Widyanto <ayrus02(at)gmail(dot)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 PM Surya Widyanto <ayrus02(at)gmail(dot)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(at)gmail(dot)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
>>>>
>>>
>>>
>>
>