Content-Type: multipart/alternative;
 boundary="------------HP14Cigb71B2Ol8r7YdLPyXD"
Message-ID: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com>
Date: Mon, 18 Nov 2024 13:41:25 +0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgAdmin Support <pgadmin-support@postgresql.org>
From: Surya Widyanto <ayrus02@gmail.com>
Content-Language: en-US
Subject: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12
Disposition-Notification-To: Surya Widyanto <ayrus02@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/1ca92999-e329-40a8-a388-302f9bb55e2e%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------HP14Cigb71B2Ol8r7YdLPyXD
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------HP14Cigb71B2Ol8r7YdLPyXD
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hi,</p>
    <p>Today, I've upgraded my pgAdmin4 version from v8.12 to v8.13
      using dnf on AlmaLinux 8.</p>
    <p>My pgAdmin4 is installed as web mode and accessed via Apache.</p>
    <p>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:</p>
    <p><font face="monospace">mod_wsgi (pid=3535715): Failed to exec
        Python script file '/usr/pgadmin4/web/pgAdmin4.wsgi'.<br>
        mod_wsgi (pid=3535715): Exception occurred processing WSGI
        script '/usr/pgadmin4/web/pgAdmin4.wsgi'.<br>
        Traceback (most recent call last):<br>
        ImportError: no pq wrapper available.<br>
        Attempts made:<br>
        - 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<br>
        - couldn't import psycopg 'binary' implementation: No module
        named 'psycopg_binary'<br>
        - couldn't import psycopg 'python' implementation: </font><br>
    </p>
    <p>The primary concern is at <b>undefined symbol: PQchangePassword</b></p>
    <p>Is there any bug or I have do the update wrongly?<b><br>
      </b></p>
    <p>Regards,<br>
      ayrus02<b><br>
      </b></p>
  </body>
</html>

--------------HP14Cigb71B2Ol8r7YdLPyXD--