Content-Type: multipart/alternative;
 boundary="------------pq2MIe1bbtCfBw2YkYDkCHaO"
Message-ID: <909690a7-3dbc-4f75-97b1-b5829d41df97@gmail.com>
Date: Mon, 18 Nov 2024 13:54:35 +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 <khushboo.vashi@enterprisedb.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
References: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com>
 <CAFOhELdyd3yiHHH-wbYn12yD+LFZjua7t==h-L_oLuiUuq2uxQ@mail.gmail.com>
From: Surya Widyanto <ayrus02@gmail.com>
Content-Language: en-US
Disposition-Notification-To: Surya Widyanto <ayrus02@gmail.com>
In-Reply-To: 
 <CAFOhELdyd3yiHHH-wbYn12yD+LFZjua7t==h-L_oLuiUuq2uxQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/909690a7-3dbc-4f75-97b1-b5829d41df97%40gmail.com>
Precedence: bulk

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

Hi Vashi,

Yes, I can confirm it is installed with version:
libpq5.x86_64 - v16.3-43PGDG.rhel8

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

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

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Hi Vashi,<br>
      <br>
      Yes, I can confirm it is installed with version:<br>
      <font face="monospace">libpq5.x86_64 - v16.3-43PGDG.rhel8</font></div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">Regards,</div>
    <div class="moz-cite-prefix">ayrus02<br>
    </div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">On 18-11-2024 13:48, Khushboo Vashi
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAFOhELdyd3yiHHH-wbYn12yD+LFZjua7t==h-L_oLuiUuq2uxQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>Is libpq5 installed on your system?</div>
        <div><br>
        </div>
        <div class="gmail_quote">
          <div dir="ltr" class="gmail_attr">On Mon, Nov 18, 2024 at
            12:11 PM Surya Widyanto &lt;<a
              href="mailto:ayrus02@gmail.com" moz-do-not-send="true"
              class="moz-txt-link-freetext">ayrus02@gmail.com</a>&gt;
            wrote:<br>
          </div>
          <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div>
              <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/<a
                    href="http://pq.cpython-39-x86_64-linux-gnu.so"
                    target="_blank" moz-do-not-send="true">pq.cpython-39-x86_64-linux-gnu.so</a>:
                  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>
            </div>
          </blockquote>
        </div>
      </div>
    </blockquote>
    <p><br>
    </p>
  </body>
</html>

--------------pq2MIe1bbtCfBw2YkYDkCHaO--