MIME-Version: 1.0
References: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com>
In-Reply-To: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com>
From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Date: Mon, 18 Nov 2024 12:18:45 +0530
Message-ID: 
 <CAFOhELdyd3yiHHH-wbYn12yD+LFZjua7t==h-L_oLuiUuq2uxQ@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="0000000000007f205306272a4f45"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFOhELdyd3yiHHH-wbYn12yD%2BLFZjua7t%3D%3Dh-L_oLuiUuq2uxQ%40mail.gmail.com>
Precedence: bulk

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

Is libpq5 installed on your system?

On Mon, Nov 18, 2024 at 12:11=E2=80=AFPM 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=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
>

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

<div dir=3D"ltr"><div>Is libpq5 installed on your system?</div><div><br></d=
iv><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:ayru=
s02@gmail.com">ayrus02@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><u></u>

 =20

   =20
 =20
  <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; implementation: No m=
odule
        named &#39;psycopg_binary&#39;<br>
        - couldn&#39;t import psycopg &#39;python&#39; implementation: </fo=
nt><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>

--0000000000007f205306272a4f45--