Content-Type: multipart/alternative;
 boundary="------------jFvzuUinnkccXxJk8Y9igRvV"
Message-ID: <39b49a11-a7e7-4330-9ad8-11fe339a1904@gmail.com>
Date: Mon, 2 Dec 2024 20:00:20 +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>
 <909690a7-3dbc-4f75-97b1-b5829d41df97@gmail.com>
 <CAFOhELdnwePfWjfE7hFB2AkhP5hSojWUFOdL7KySwFKSDYmkqQ@mail.gmail.com>
 <2bf48205-a8ad-49fc-a5d8-ada1bee6573d@gmail.com>
 <CAFOhELeUHU0FX-y7r4dD974DbS=zOTzFSUeAnjVmMbunaXpccw@mail.gmail.com>
 <3dd1d051-875a-4d9c-bfee-1753ace8a615@gmail.com>
 <CAFOhELdERWD_iX18KE204hoeAvu_XR5WoOjqiY0Cphxo2487Bw@mail.gmail.com>
 <fb212ff6-0512-442b-b897-728eff874140@gmail.com>
 <CAFOhELeAd-NamazS_Z1R6m+oGoa1WM8v8jGKHXXGwSrHx7Dk7Q@mail.gmail.com>
From: Surya Widyanto <ayrus02@gmail.com>
Content-Language: en-US
Disposition-Notification-To: Surya Widyanto <ayrus02@gmail.com>
In-Reply-To: 
 <CAFOhELeAd-NamazS_Z1R6m+oGoa1WM8v8jGKHXXGwSrHx7Dk7Q@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/39b49a11-a7e7-4330-9ad8-11fe339a1904%40gmail.com>
Precedence: bulk

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

Hi,

For this problem is it already identified the main problem? is it a bug 
on the new release v8.13?
Is there any hint how to solve the problem? until now, I still cannot 
upgrade to v8.13 because of this problem

Regards,
ayrus02

On 18-11-2024 16:42, Khushboo Vashi wrote:
> Hi,
>
> Make sure that your libpq is located at LIBDIR = /usr/lib64. This 
> error may occur when you have multiple libpq installed on your system. 
> Also do not forget to restart the apache server.
>
> Thanks,
> Khushboo
>
>
>
> On Mon, Nov 18, 2024 at 3:06 PM Surya Widyanto <ayrus02@gmail.com> wrote:
>
>     Hi,
>
>     Below are the output of pg_config on on my AlmaLinux 8 (x64) machine:
>
>     BINDIR = /usr/bin
>     DOCDIR = /usr/share/doc/pgsql
>     HTMLDIR = /usr/share/doc/pgsql
>     INCLUDEDIR = /usr/include
>     PKGINCLUDEDIR = /usr/include/pgsql
>     INCLUDEDIR-SERVER = /usr/include/pgsql/server
>     LIBDIR = /usr/lib64
>     PKGLIBDIR = /usr/lib64/pgsql
>     LOCALEDIR = /usr/share/locale
>     MANDIR = /usr/share/man
>     SHAREDIR = /usr/share/pgsql
>     SYSCONFDIR = /etc/pgsql
>     PGXS = /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk <http://pgxs.mk>
>     CONFIGURE =  '--build=x86_64-redhat-linux-gnu'
>     '--host=x86_64-redhat-linux-gnu' '--program-prefix='
>     '--disable-dependency-tracking' '--prefix=/usr'
>     '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
>     '--sysconfdir=/etc' '--datadir=/usr/share'
>     '--includedir=/usr/include' '--libdir=/usr/lib64'
>     '--libexecdir=/usr/libexec' '--localstatedir=/var'
>     '--sharedstatedir=/var/lib' '--mandir=/usr/share/man'
>     '--infodir=/usr/share/info' '--disable-rpath' '--with-openssl'
>     '--with-gssapi' '--with-includes=/usr/include'
>     '--with-libraries=/usr/lib64' '--enable-nls' '--with-ldap'
>     '--with-lz4' '--with-selinux' '--with-systemd'
>     '--with-system-tzdata=/usr/share/zoneinfo'
>     'build_alias=x86_64-redhat-linux-gnu'
>     'host_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 -g -pipe -Wall
>     -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
>     -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong
>     -grecord-gcc-switches
>     -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
>     -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic
>     -fasynchronous-unwind-tables -fstack-clash-protection
>     -fcf-protection' 'LDFLAGS=-Wl,--as-needed' 'CXXFLAGS=-O2 -g -pipe
>     -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
>     -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong
>     -grecord-gcc-switches
>     -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
>     -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic
>     -fasynchronous-unwind-tables -fstack-clash-protection
>     -fcf-protection'
>     'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'
>     'PYTHON=/usr/bin/python3'
>     CC = gcc
>     CPPFLAGS = -D_GNU_SOURCE -I/usr/include
>     CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
>     -Wdeclaration-after-statement -Werror=vla -Wendif-labels
>     -Wmissing-format-attribute -Wimplicit-fallthrough=3
>     -Wcast-function-type -Wshadow=compatible-local -Wformat-security
>     -fno-strict-aliasing -fwrapv -fexcess-precision=standard
>     -Wno-format-truncation -Wno-stringop-truncation -O2 -g -pipe -Wall
>     -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
>     -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong
>     -grecord-gcc-switches
>     -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
>     -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic
>     -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection
>     CFLAGS_SL = -fPIC
>     LDFLAGS = -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed
>     LDFLAGS_EX =
>     LDFLAGS_SL =
>     LIBS = -lpgcommon -lpgport -lselinux -llz4 -lssl -lcrypto
>     -lgssapi_krb5 -lz -lreadline -lpthread -lrt -ldl -lm
>     VERSION = PostgreSQL 17.0
>
>     Below are the output of pg_config on on my AlmaLinux 9 (x64) machine:
>
>     BINDIR = /usr/bin
>     DOCDIR = /usr/share/doc/pgsql
>     HTMLDIR = /usr/share/doc/pgsql
>     INCLUDEDIR = /usr/include
>     PKGINCLUDEDIR = /usr/include/pgsql
>     INCLUDEDIR-SERVER = /usr/include/pgsql/server
>     LIBDIR = /usr/lib64
>     PKGLIBDIR = /usr/lib64/pgsql
>     LOCALEDIR = /usr/share/locale
>     MANDIR = /usr/share/man
>     SHAREDIR = /usr/share/pgsql
>     SYSCONFDIR = /etc/pgsql
>     PGXS = /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk <http://pgxs.mk>
>     CONFIGURE =  '--build=x86_64-redhat-linux-gnu'
>     '--host=x86_64-redhat-linux-gnu' '--program-prefix='
>     '--disable-dependency-tracking' '--prefix=/usr'
>     '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
>     '--sysconfdir=/etc' '--datadir=/usr/share'
>     '--includedir=/usr/include' '--libdir=/usr/lib64'
>     '--libexecdir=/usr/libexec' '--localstatedir=/var'
>     '--sharedstatedir=/var/lib' '--mandir=/usr/share/man'
>     '--infodir=/usr/share/info' '--disable-rpath' '--with-openssl'
>     '--with-gssapi' '--with-includes=/usr/include'
>     '--with-libraries=/usr/lib64' '--enable-nls' '--with-ldap'
>     '--with-lz4' '--with-selinux' '--with-systemd'
>     '--with-system-tzdata=/usr/share/zoneinfo'
>     'build_alias=x86_64-redhat-linux-gnu'
>     'host_alias=x86_64-redhat-linux-gnu' 'CC=gcc' 'CFLAGS=-O2
>     -flto=auto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches
>     -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
>     -Wp,-D_GLIBCXX_ASSERTIONS
>     -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
>     -fstack-protector-strong
>     -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64
>     -march=x86-64-v2 -mtune=generic -fasynchronous-unwind-tables
>     -fstack-clash-protection -fcf-protection'
>     'LDFLAGS=-Wl,--as-needed' 'CXX=g++' 'CXXFLAGS=-O2 -flto=auto
>     -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe
>     -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
>     -Wp,-D_GLIBCXX_ASSERTIONS
>     -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
>     -fstack-protector-strong
>     -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1  -m64
>     -march=x86-64-v2 -mtune=generic -fasynchronous-unwind-tables
>     -fstack-clash-protection -fcf-protection'
>     'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'
>     'PYTHON=/usr/bin/python3'
>     CC = gcc
>     CPPFLAGS = -D_GNU_SOURCE -I/usr/include
>     CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
>     -Wdeclaration-after-statement -Werror=vla -Wendif-labels
>     -Wmissing-format-attribute -Wimplicit-fallthrough=3
>     -Wcast-function-type -Wshadow=compatible-local -Wformat-security
>     -fno-strict-aliasing -fwrapv -fexcess-precision=standard
>     -Wno-format-truncation -Wno-stringop-truncation -O2 -flto=auto
>     -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe
>     -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
>     -Wp,-D_GLIBCXX_ASSERTIONS
>     -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
>     -fstack-protector-strong
>     -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64
>     -march=x86-64-v2 -mtune=generic -fasynchronous-unwind-tables
>     -fstack-clash-protection -fcf-protection
>     CFLAGS_SL = -fPIC
>     LDFLAGS = -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed
>     LDFLAGS_EX =
>     LDFLAGS_SL =
>     LIBS = -lpgcommon -lpgport -lselinux -llz4 -lssl -lcrypto
>     -lgssapi_krb5 -lz -lreadline -lm
>     VERSION = PostgreSQL 17.0
>
>     Regards,
>     ayrus02
>
>
>     On 18-11-2024 16:26, Khushboo Vashi wrote:
>>
>>
>>     On Mon, Nov 18, 2024 at 2:48 PM Surya Widyanto
>>     <ayrus02@gmail.com> wrote:
>>
>>         Hi,
>>
>>         Below are the output of *dnf list libpq5** on my AlmaLinux 8
>>         (x64) machine:
>>
>>         Last metadata expiration check: 3:28:40 ago on Mon 18 Nov
>>         2024 12:43:19 PM WIB.
>>         Installed Packages
>>         libpq5.x86_64 - 17.0-43PGDG.rhel8 - @pgAdmin4
>>         Available Packages
>>         libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 - pgAdmin4
>>         libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 - pgdg-common
>>
>>     This looks fine.
>>     What's the output of pg_config ?
>>
>>         And below are the output of *dnf list libpq5** on my
>>         AlmaLinux 9 (x64) machine:
>>
>>         Last metadata expiration check: 0:38:20 ago on Sen 18 Nov
>>         2024 03:33:43 .
>>         Installed Packages
>>         libpq5.x86_64 - 17.0-43PGDG.rhel9 - @pgdg-common
>>         Available Packages
>>         libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 - pgAdmin4
>>         libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 - pgdg-common
>>
>>         Regards,
>>         ayrus02
>>
>>         On 18-11-2024 16:06, Khushboo Vashi wrote:
>>>
>>>
>>>         On Mon, Nov 18, 2024 at 1:13 PM Surya Widyanto
>>>         <ayrus02@gmail.com> wrote:
>>>
>>>             Hi,
>>>
>>>             I've upgraded the libpq5 to version 17.0-43PGDG.rhel8
>>>             I've also restart the apache server.
>>>
>>>
>>>         What's the output of `yum list libpq5*` ?
>>>
>>>
>>>             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
>>>>             <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 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*
>>>>>                     *
>>>>>
>>>>
>>>
>>
>

--------------jFvzuUinnkccXxJk8Y9igRvV
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,<br>
      <br>
      For this problem is it already identified the main problem? is it
      a bug on the new release v8.13?<br>
      Is there any hint how to solve the problem? until now, I still
      cannot upgrade to v8.13 because of this problem</div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">Regards,<br>
      ayrus02<br>
      <br>
      On 18-11-2024 16:42, Khushboo Vashi wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAFOhELeAd-NamazS_Z1R6m+oGoa1WM8v8jGKHXXGwSrHx7Dk7Q@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Hi,
        <div><br>
        </div>
        <div><span style="font-family:arial,sans-serif">Make sure that
            your libpq is located at </span><span
            style="font-family:arial,sans-serif">LIBDIR = /usr/lib64.
            This error may occur when you have multiple libpq installed
            on your system. Also do not forget to restart the apache
            server.</span></div>
        <div><font face="arial, sans-serif"><br>
          </font></div>
        <div><font face="arial, sans-serif">Thanks,</font></div>
        <div><font face="arial, sans-serif">Khushboo<br>
          </font>
          <div><br>
          </div>
          <div><span style="font-family:monospace"><br>
            </span></div>
        </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Mon, Nov 18, 2024 at
          3:06 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>
            <div>Hi,<br>
            </div>
            <div><br>
            </div>
            <div>Below are the output of pg_config on on my AlmaLinux 8
              (x64) machine:
              <div><br>
              </div>
            </div>
            <div><font face="monospace">BINDIR = /usr/bin<br>
                DOCDIR = /usr/share/doc/pgsql<br>
                HTMLDIR = /usr/share/doc/pgsql<br>
                INCLUDEDIR = /usr/include<br>
                PKGINCLUDEDIR = /usr/include/pgsql<br>
                INCLUDEDIR-SERVER = /usr/include/pgsql/server<br>
                LIBDIR = /usr/lib64<br>
                PKGLIBDIR = /usr/lib64/pgsql<br>
                LOCALEDIR = /usr/share/locale<br>
                MANDIR = /usr/share/man<br>
                SHAREDIR = /usr/share/pgsql<br>
                SYSCONFDIR = /etc/pgsql<br>
                PGXS = /usr/lib64/pgsql/pgxs/src/makefiles/<a
                  href="http://pgxs.mk" target="_blank"
                  moz-do-not-send="true">pgxs.mk</a><br>
                CONFIGURE =  '--build=x86_64-redhat-linux-gnu'
                '--host=x86_64-redhat-linux-gnu' '--program-prefix='
                '--disable-dependency-tracking' '--prefix=/usr'
                '--exec-prefix=/usr' '--bindir=/usr/bin'
                '--sbindir=/usr/sbin' '--sysconfdir=/etc'
                '--datadir=/usr/share' '--includedir=/usr/include'
                '--libdir=/usr/lib64' '--libexecdir=/usr/libexec'
                '--localstatedir=/var' '--sharedstatedir=/var/lib'
                '--mandir=/usr/share/man' '--infodir=/usr/share/info'
                '--disable-rpath' '--with-openssl' '--with-gssapi'
                '--with-includes=/usr/include'
                '--with-libraries=/usr/lib64' '--enable-nls'
                '--with-ldap' '--with-lz4' '--with-selinux'
                '--with-systemd'
                '--with-system-tzdata=/usr/share/zoneinfo'
                'build_alias=x86_64-redhat-linux-gnu'
                'host_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 -g
                -pipe -Wall -Werror=format-security
                -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS
                -fexceptions -fstack-protector-strong
                -grecord-gcc-switches
                -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
                -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64
                -mtune=generic -fasynchronous-unwind-tables
                -fstack-clash-protection -fcf-protection'
                'LDFLAGS=-Wl,--as-needed' 'CXXFLAGS=-O2 -g -pipe -Wall
                -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
                -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions
                -fstack-protector-strong -grecord-gcc-switches
                -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
                -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64
                -mtune=generic -fasynchronous-unwind-tables
                -fstack-clash-protection -fcf-protection'
                'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'
                'PYTHON=/usr/bin/python3'<br>
                CC = gcc<br>
                CPPFLAGS = -D_GNU_SOURCE -I/usr/include<br>
                CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
                -Wdeclaration-after-statement -Werror=vla -Wendif-labels
                -Wmissing-format-attribute -Wimplicit-fallthrough=3
                -Wcast-function-type -Wshadow=compatible-local
                -Wformat-security -fno-strict-aliasing -fwrapv
                -fexcess-precision=standard -Wno-format-truncation
                -Wno-stringop-truncation -O2 -g -pipe -Wall
                -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
                -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions
                -fstack-protector-strong -grecord-gcc-switches
                -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
                -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64
                -mtune=generic -fasynchronous-unwind-tables
                -fstack-clash-protection -fcf-protection<br>
                CFLAGS_SL = -fPIC<br>
                LDFLAGS = -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed<br>
                LDFLAGS_EX =<br>
                LDFLAGS_SL =<br>
                LIBS = -lpgcommon -lpgport -lselinux -llz4 -lssl
                -lcrypto -lgssapi_krb5 -lz -lreadline -lpthread -lrt
                -ldl -lm<br>
                VERSION = PostgreSQL 17.0<br>
              </font><br>
              Below are the output of pg_config on on my AlmaLinux 9
              (x64) machine:</div>
            <div><br>
            </div>
            <div><font face="monospace">BINDIR = /usr/bin<br>
                DOCDIR = /usr/share/doc/pgsql<br>
                HTMLDIR = /usr/share/doc/pgsql<br>
                INCLUDEDIR = /usr/include<br>
                PKGINCLUDEDIR = /usr/include/pgsql<br>
                INCLUDEDIR-SERVER = /usr/include/pgsql/server<br>
                LIBDIR = /usr/lib64<br>
                PKGLIBDIR = /usr/lib64/pgsql<br>
                LOCALEDIR = /usr/share/locale<br>
                MANDIR = /usr/share/man<br>
                SHAREDIR = /usr/share/pgsql<br>
                SYSCONFDIR = /etc/pgsql<br>
                PGXS = /usr/lib64/pgsql/pgxs/src/makefiles/<a
                  href="http://pgxs.mk" target="_blank"
                  moz-do-not-send="true">pgxs.mk</a><br>
                CONFIGURE =  '--build=x86_64-redhat-linux-gnu'
                '--host=x86_64-redhat-linux-gnu' '--program-prefix='
                '--disable-dependency-tracking' '--prefix=/usr'
                '--exec-prefix=/usr' '--bindir=/usr/bin'
                '--sbindir=/usr/sbin' '--sysconfdir=/etc'
                '--datadir=/usr/share' '--includedir=/usr/include'
                '--libdir=/usr/lib64' '--libexecdir=/usr/libexec'
                '--localstatedir=/var' '--sharedstatedir=/var/lib'
                '--mandir=/usr/share/man' '--infodir=/usr/share/info'
                '--disable-rpath' '--with-openssl' '--with-gssapi'
                '--with-includes=/usr/include'
                '--with-libraries=/usr/lib64' '--enable-nls'
                '--with-ldap' '--with-lz4' '--with-selinux'
                '--with-systemd'
                '--with-system-tzdata=/usr/share/zoneinfo'
                'build_alias=x86_64-redhat-linux-gnu'
                'host_alias=x86_64-redhat-linux-gnu' 'CC=gcc'
                'CFLAGS=-O2 -flto=auto -ffat-lto-objects -fexceptions -g
                -grecord-gcc-switches -pipe -Wall
                -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
                -Wp,-D_GLIBCXX_ASSERTIONS
                -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
                -fstack-protector-strong
                -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64
                -march=x86-64-v2 -mtune=generic
                -fasynchronous-unwind-tables -fstack-clash-protection
                -fcf-protection' 'LDFLAGS=-Wl,--as-needed' 'CXX=g++'
                'CXXFLAGS=-O2 -flto=auto -ffat-lto-objects -fexceptions
                -g -grecord-gcc-switches -pipe -Wall
                -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
                -Wp,-D_GLIBCXX_ASSERTIONS
                -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
                -fstack-protector-strong
                -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1  -m64
                -march=x86-64-v2 -mtune=generic
                -fasynchronous-unwind-tables -fstack-clash-protection
                -fcf-protection'
                'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'
                'PYTHON=/usr/bin/python3'<br>
                CC = gcc<br>
                CPPFLAGS = -D_GNU_SOURCE -I/usr/include<br>
                CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
                -Wdeclaration-after-statement -Werror=vla -Wendif-labels
                -Wmissing-format-attribute -Wimplicit-fallthrough=3
                -Wcast-function-type -Wshadow=compatible-local
                -Wformat-security -fno-strict-aliasing -fwrapv
                -fexcess-precision=standard -Wno-format-truncation
                -Wno-stringop-truncation -O2 -flto=auto
                -ffat-lto-objects -fexceptions -g -grecord-gcc-switches
                -pipe -Wall -Werror=format-security
                -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS
                -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
                -fstack-protector-strong
                -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64
                -march=x86-64-v2 -mtune=generic
                -fasynchronous-unwind-tables -fstack-clash-protection
                -fcf-protection<br>
                CFLAGS_SL = -fPIC<br>
                LDFLAGS = -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed<br>
                LDFLAGS_EX =<br>
                LDFLAGS_SL =<br>
                LIBS = -lpgcommon -lpgport -lselinux -llz4 -lssl
                -lcrypto -lgssapi_krb5 -lz -lreadline -lm<br>
              </font><font face="monospace">VERSION = PostgreSQL 17.0</font></div>
            <div><font face="monospace"><br>
              </font></div>
            <div>Regards,</div>
            <div>ayrus02<br>
            </div>
            <div><br>
            </div>
            <div><br>
            </div>
            <div>On 18-11-2024 16:26, Khushboo Vashi wrote:<br>
            </div>
            <blockquote type="cite">
              <div dir="ltr">
                <div dir="ltr"><br>
                </div>
                <br>
                <div class="gmail_quote">
                  <div dir="ltr" class="gmail_attr">On Mon, Nov 18, 2024
                    at 2:48 PM Surya Widyanto &lt;<a
                      href="mailto:ayrus02@gmail.com" target="_blank"
                      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>
                      <div>Hi,</div>
                      <div><br>
                      </div>
                      <div>Below are the output of <b><font
                            face="monospace">dnf list libpq5*</font></b>
                        on my AlmaLinux 8 (x64) machine:</div>
                      <div><br>
                      </div>
                      <div><font face="monospace">Last metadata
                          expiration check: 3:28:40 ago on Mon 18 Nov
                          2024 12:43:19 PM WIB.<br>
                          Installed Packages<br>
                          libpq5.x86_64 - 17.0-43PGDG.rhel8 - @pgAdmin4<br>
                          Available Packages<br>
                          libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 -
                          pgAdmin4<br>
                          libpq5-devel.x86_64 - 17.0-43PGDG.rhel8 -
                          pgdg-common</font><br>
                      </div>
                      <div><br>
                      </div>
                    </div>
                  </blockquote>
                  <div>This looks fine.</div>
                  <div>What's the output of pg_config ? </div>
                  <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
                    <div>
                      <div> </div>
                      <div>And below are the output of <b><font
                            face="monospace">dnf list libpq5*</font></b>
                        on my AlmaLinux 9 (x64) machine:</div>
                      <div><br>
                      </div>
                      <div><font face="monospace">Last metadata
                          expiration check: 0:38:20 ago on Sen 18 Nov
                          2024 03:33:43 .<br>
                          Installed Packages<br>
                          libpq5.x86_64 - 17.0-43PGDG.rhel9 -
                          @pgdg-common<br>
                          Available Packages<br>
                          libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 -
                          pgAdmin4<br>
                          libpq5-devel.x86_64 - 17.0-43PGDG.rhel9 -
                          pgdg-common</font><br>
                        <br>
                      </div>
                      <p>Regards,<br>
                        ayrus02</p>
                      <div>On 18-11-2024 16:06, Khushboo Vashi wrote:<br>
                      </div>
                      <blockquote type="cite">
                        <div dir="ltr">
                          <div dir="ltr"><br>
                          </div>
                          <br>
                          <div class="gmail_quote">
                            <div dir="ltr" class="gmail_attr">On Mon,
                              Nov 18, 2024 at 1:13 PM Surya Widyanto
                              &lt;<a href="mailto:ayrus02@gmail.com"
                                target="_blank" 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>
                                <div>Hi,<br>
                                  <br>
                                  I've upgraded the libpq5 to version
                                  17.0-43PGDG.rhel8<br>
                                  I've also restart the apache server.<br>
                                </div>
                              </div>
                            </blockquote>
                            <div><br>
                            </div>
                            <div>What's the output of `yum list libpq5*`
                              ?</div>
                            <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
                              <div>
                                <div> <br>
                                  But the problem still exist. With the
                                  same error in log file.<br>
                                  <br>
                                  I've also can confirm that this also
                                  happened on my other server running
                                  AlmaLinux 9 (x64).<br>
                                  My other server also has libpq5 with
                                  version 17.0-43PGDG.rhel9 and also
                                  running as Web Mode via Apache.</div>
                                <div><br>
                                </div>
                                <div>Regards,</div>
                                <div>ayrus02<br>
                                </div>
                                <div><br>
                                </div>
                                <div>On 18-11-2024 14:21, Khushboo Vashi
                                  wrote:<br>
                                </div>
                                <blockquote type="cite">
                                  <div dir="ltr">
                                    <div>Hi,</div>
                                    <br>
                                    <div class="gmail_quote">
                                      <div dir="ltr" class="gmail_attr">On
                                        Mon, Nov 18, 2024 at 12:24 PM
                                        Surya Widyanto &lt;<a
href="mailto:ayrus02@gmail.com" target="_blank" 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>
                                          <div>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>
                                      </blockquote>
                                      <div><br>
                                      </div>
                                      <div>During the pgAdmin upgrade on
                                        your system, the libpq5 should
                                        have been upgraded to the latest
                                        (v17), which didn't happen in
                                        your case.</div>
                                      <div>Can you please upgrade libpq5
                                        to the latest version? It should
                                        fix this issue.</div>
                                      <div><br>
                                      </div>
                                      <div>Thanks,</div>
                                      <div>Khushboo</div>
                                      <blockquote class="gmail_quote"
style="margin: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="cite">
                                            <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" target="_blank" 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>
                                        </div>
                                      </blockquote>
                                    </div>
                                  </div>
                                </blockquote>
                                <p><br>
                                </p>
                              </div>
                            </blockquote>
                          </div>
                        </div>
                      </blockquote>
                      <p><br>
                      </p>
                    </div>
                  </blockquote>
                </div>
              </div>
            </blockquote>
            <p><br>
            </p>
          </div>
        </blockquote>
      </div>
    </blockquote>
    <p><br>
    </p>
  </body>
</html>

--------------jFvzuUinnkccXxJk8Y9igRvV--