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

[Surya Widyanto]

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 <ayru...@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
    <ayru...@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
        <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*
        *