MIME-Version: 1.0
References: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com>
 <CAFOhELdyd3yiHHH-wbYn12yD+LFZjua7t==h-L_oLuiUuq2uxQ@mail.gmail.com>
 <909690a7-3dbc-4f75-97b1-b5829d41df97@gmail.com>
In-Reply-To: <909690a7-3dbc-4f75-97b1-b5829d41df97@gmail.com>
From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Date: Mon, 18 Nov 2024 12:51:41 +0530
Message-ID: 
 <CAFOhELdnwePfWjfE7hFB2AkhP5hSojWUFOdL7KySwFKSDYmkqQ@mail.gmail.com>
Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12
To: Surya Widyanto <ayrus02@gmail.com>
Cc: pgAdmin Support <pgadmin-support@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000049750206272ac590"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFOhELdnwePfWjfE7hFB2AkhP5hSojWUFOdL7KySwFKSDYmkqQ%40mail.gmail.com>
Precedence: bulk

--00000000000049750206272ac590
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

On Mon, Nov 18, 2024 at 12:24=E2=80=AFPM Surya Widyanto <ayrus02@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=E2=80=AFPM Surya Widyanto <ayrus02@gmail.co=
m> wrote:
>
>> Hi,
>>
>> Today, I've upgraded my pgAdmin4 version from v8.12 to v8.13 using dnf o=
n
>> 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=3D3535715): Failed to exec Python script file
>> '/usr/pgadmin4/web/pgAdmin4.wsgi'.
>> mod_wsgi (pid=3D3535715): 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
>>
>
>

--00000000000049750206272ac590
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><br><div class=3D"gmail_quote"><div dir=3D"l=
tr" class=3D"gmail_attr">On Mon, Nov 18, 2024 at 12:24=E2=80=AFPM Surya Wid=
yanto &lt;<a href=3D"mailto:ayrus02@gmail.com">ayrus02@gmail.com</a>&gt; wr=
ote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>

 =20
   =20
 =20
  <div>
    <div>Hi Vashi,<br>
      <br>
      Yes, I can confirm it is installed with version:<br>
      <font face=3D"monospace">libpq5.x86_64 - v16.3-43PGDG.rhel8</font></d=
iv></div></blockquote><div><br></div><div>During the pgAdmin upgrade on you=
r system, the libpq5 should have been upgraded to the latest (v17), which d=
idn&#39;t happen in your case.</div><div>Can you please upgrade libpq5 to t=
he latest version? It should fix this issue.</div><div><br></div><div>Thank=
s,</div><div>Khushboo</div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
"><div>
    <div><br>
    </div>
    <div>Regards,</div>
    <div>ayrus02<br>
    </div>
    <div><br>
    </div>
    <div>On 18-11-2024 13:48, Khushboo Vashi
      wrote:<br>
    </div>
    <blockquote type=3D"cite">
     =20
      <div dir=3D"ltr">
        <div>Is libpq5 installed on your system?</div>
        <div><br>
        </div>
        <div class=3D"gmail_quote">
          <div dir=3D"ltr" class=3D"gmail_attr">On Mon, Nov 18, 2024 at
            12:11=E2=80=AFPM Surya Widyanto &lt;<a href=3D"mailto:ayrus02@g=
mail.com" target=3D"_blank">ayrus02@gmail.com</a>&gt;
            wrote:<br>
          </div>
          <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div>
              <p>Hi,</p>
              <p>Today, I&#39;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=3D"monospace">mod_wsgi (pid=3D3535715): Failed
                  to exec Python script file
                  &#39;/usr/pgadmin4/web/pgAdmin4.wsgi&#39;.<br>
                  mod_wsgi (pid=3D3535715): Exception occurred processing
                  WSGI script &#39;/usr/pgadmin4/web/pgAdmin4.wsgi&#39;.<br=
>
                  Traceback (most recent call last):<br>
                  ImportError: no pq wrapper available.<br>
                  Attempts made:<br>
                  - couldn&#39;t import psycopg &#39;c&#39; implementation:
/usr/pgadmin4/venv/lib64/python3.9/site-packages/psycopg_c/<a href=3D"http:=
//pq.cpython-39-x86_64-linux-gnu.so" target=3D"_blank">pq.cpython-39-x86_64=
-linux-gnu.so</a>:
                  undefined symbol: PQchangePassword<br>
                  - couldn&#39;t import psycopg &#39;binary&#39; implementa=
tion: No
                  module named &#39;psycopg_binary&#39;<br>
                  - couldn&#39;t import psycopg &#39;python&#39; implementa=
tion: </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>
  </div>

</blockquote></div></div>

--00000000000049750206272ac590--