Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tCyHo-00EsA0-9c for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 09:43:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tCyHl-0041sm-K8 for pgadmin-support@arkaria.postgresql.org; Mon, 18 Nov 2024 09:43:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tCyHl-0041sd-3P for pgadmin-support@lists.postgresql.org; Mon, 18 Nov 2024 09:43:09 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tCyHd-002UjY-5l for pgadmin-support@postgresql.org; Mon, 18 Nov 2024 09:43:07 +0000 Received: by mail-yb1-xb33.google.com with SMTP id 3f1490d57ef6-e0875f1e9edso4093796276.1 for ; Mon, 18 Nov 2024 01:43:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1731922980; x=1732527780; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=z2XIuUh2mAAym5aYoZGQi1wENqEKH82+jvx2FFxcAss=; b=B7jIJXbPPT4AC1tRpkLn9BFdiVtONr9c8lIuO6gYJGEznycvRUa3S8Ck3zk+zIDrYt 3tQgPOUZUlOd2y/EvvwAlXXRv83GdsEP0ZmKy3qETCC3bkmwNXxlwaG7zEBwzoqPADuE 5DcT4UgDKtwijYRt4sFa25iX5kMw6OVkB9No69g+DURj7ndTANl79CltivNwAVBAydZs d0luODPnVVMG/aisMFg3ayeugOv6NGXgjlzUH3Cuuxxsp+/j560aUN/3XtftyR5sbgOj nwKbyriDNb4A8RsWmrljtGvkOFFHY03P0W7Vw44xoaOcJX35ldzunj+qsQKYT2ixnM6x OvMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731922980; x=1732527780; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=z2XIuUh2mAAym5aYoZGQi1wENqEKH82+jvx2FFxcAss=; b=PAkNXwIp0Ln5leiG5soQOcvuWXWXKiVL4Q5h3SIx31zjzcb+FtcpwzuqeYi7uQ7Eq5 4Eor7czHy5pyLjTuMT7YcUlmOBsmiyfl0oNfJFiw01cSM2Z742A3NTkdPgDZghtpvxXU pW2STQWyhQvT7DH+3O1mjiIG42VpFN8hjx2YsOGcDLW8exVOapr4iabaRUHTfJhC7nQG bo8DNBcuID52D8wv79FQtrVfBbH3H047nS6zpQSt6NU4r6+otWq3AUsRWf+P5jQdkq8q gX7OuCvYQXPPbzS/RFHREm5cInFmCfq5C/UMqyGAsIhUJYND3am9+zNvFOYhW5BsEwJC IDlg== X-Gm-Message-State: AOJu0YyQe+5z1NDF4bev2LehbVZ0JoQMIwSBTU4JF9x15PivLWT//nWx nyCqN6BCqLSTObPJFNsOYtasczH1tlndbHezxJEiY7/XCS7JMWm9/tJMejXTaGzdxUjxR4qIS9h szEiVfr4djzxLRXcK2EigWXRVdx4Paf+UWnh1 X-Google-Smtp-Source: AGHT+IGHeOi4u0xpcgPXUqInHCeSebbSdC4Rpb0+65i81w7ogh/GyNL4bWT9UMgN8aD49LyCTGKSE692l5DwynGLwrI= X-Received: by 2002:a05:6902:a87:b0:e38:b1d2:e79f with SMTP id 3f1490d57ef6-e38b1d2f0c1mr123920276.28.1731922980239; Mon, 18 Nov 2024 01:43:00 -0800 (PST) MIME-Version: 1.0 References: <1ca92999-e329-40a8-a388-302f9bb55e2e@gmail.com> <909690a7-3dbc-4f75-97b1-b5829d41df97@gmail.com> <2bf48205-a8ad-49fc-a5d8-ada1bee6573d@gmail.com> <3dd1d051-875a-4d9c-bfee-1753ace8a615@gmail.com> In-Reply-To: From: Khushboo Vashi Date: Mon, 18 Nov 2024 15:12:49 +0530 Message-ID: Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12 To: Surya Widyanto Cc: pgAdmin Support Content-Type: multipart/alternative; boundary="0000000000000416af06272cbed4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000416af06272cbed4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Make sure that your libpq is located at LIBDIR =3D /usr/lib64. This error m= ay 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=E2=80=AFPM Surya Widyanto = wrote: > Hi, > > Below are the output of pg_config on on my AlmaLinux 8 (x64) machine: > > BINDIR =3D /usr/bin > DOCDIR =3D /usr/share/doc/pgsql > HTMLDIR =3D /usr/share/doc/pgsql > INCLUDEDIR =3D /usr/include > PKGINCLUDEDIR =3D /usr/include/pgsql > INCLUDEDIR-SERVER =3D /usr/include/pgsql/server > LIBDIR =3D /usr/lib64 > PKGLIBDIR =3D /usr/lib64/pgsql > LOCALEDIR =3D /usr/share/locale > MANDIR =3D /usr/share/man > SHAREDIR =3D /usr/share/pgsql > SYSCONFDIR =3D /etc/pgsql > PGXS =3D /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk > CONFIGURE =3D '--build=3Dx86_64-redhat-linux-gnu' > '--host=3Dx86_64-redhat-linux-gnu' '--program-prefix=3D' > '--disable-dependency-tracking' '--prefix=3D/usr' '--exec-prefix=3D/usr' > '--bindir=3D/usr/bin' '--sbindir=3D/usr/sbin' '--sysconfdir=3D/etc' > '--datadir=3D/usr/share' '--includedir=3D/usr/include' '--libdir=3D/usr/l= ib64' > '--libexecdir=3D/usr/libexec' '--localstatedir=3D/var' > '--sharedstatedir=3D/var/lib' '--mandir=3D/usr/share/man' > '--infodir=3D/usr/share/info' '--disable-rpath' '--with-openssl' > '--with-gssapi' '--with-includes=3D/usr/include' > '--with-libraries=3D/usr/lib64' '--enable-nls' '--with-ldap' '--with-lz4' > '--with-selinux' '--with-systemd' > '--with-system-tzdata=3D/usr/share/zoneinfo' > 'build_alias=3Dx86_64-redhat-linux-gnu' 'host_alias=3Dx86_64-redhat-linux= -gnu' > 'CFLAGS=3D-O2 -g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOU= RCE=3D2 > -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong > -grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 > -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric > -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' > 'LDFLAGS=3D-Wl,--as-needed' 'CXXFLAGS=3D-O2 -g -pipe -Wall > -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERT= IONS > -fexceptions -fstack-protector-strong -grecord-gcc-switches > -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 > -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric > -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' > 'PKG_CONFIG_PATH=3D:/usr/lib64/pkgconfig:/usr/share/pkgconfig' > 'PYTHON=3D/usr/bin/python3' > CC =3D gcc > CPPFLAGS =3D -D_GNU_SOURCE -I/usr/include > CFLAGS =3D -Wall -Wmissing-prototypes -Wpointer-arith > -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels > -Wmissing-format-attribute -Wimplicit-fallthrough=3D3 -Wcast-function-typ= e > -Wshadow=3Dcompatible-local -Wformat-security -fno-strict-aliasing -fwrap= v > -fexcess-precision=3Dstandard -Wno-format-truncation -Wno-stringop-trunca= tion > -O2 -g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 > -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong > -grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 > -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric > -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection > CFLAGS_SL =3D -fPIC > LDFLAGS =3D -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed > LDFLAGS_EX =3D > LDFLAGS_SL =3D > LIBS =3D -lpgcommon -lpgport -lselinux -llz4 -lssl -lcrypto -lgssapi_krb5 > -lz -lreadline -lpthread -lrt -ldl -lm > VERSION =3D PostgreSQL 17.0 > > Below are the output of pg_config on on my AlmaLinux 9 (x64) machine: > > BINDIR =3D /usr/bin > DOCDIR =3D /usr/share/doc/pgsql > HTMLDIR =3D /usr/share/doc/pgsql > INCLUDEDIR =3D /usr/include > PKGINCLUDEDIR =3D /usr/include/pgsql > INCLUDEDIR-SERVER =3D /usr/include/pgsql/server > LIBDIR =3D /usr/lib64 > PKGLIBDIR =3D /usr/lib64/pgsql > LOCALEDIR =3D /usr/share/locale > MANDIR =3D /usr/share/man > SHAREDIR =3D /usr/share/pgsql > SYSCONFDIR =3D /etc/pgsql > PGXS =3D /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk > CONFIGURE =3D '--build=3Dx86_64-redhat-linux-gnu' > '--host=3Dx86_64-redhat-linux-gnu' '--program-prefix=3D' > '--disable-dependency-tracking' '--prefix=3D/usr' '--exec-prefix=3D/usr' > '--bindir=3D/usr/bin' '--sbindir=3D/usr/sbin' '--sysconfdir=3D/etc' > '--datadir=3D/usr/share' '--includedir=3D/usr/include' '--libdir=3D/usr/l= ib64' > '--libexecdir=3D/usr/libexec' '--localstatedir=3D/var' > '--sharedstatedir=3D/var/lib' '--mandir=3D/usr/share/man' > '--infodir=3D/usr/share/info' '--disable-rpath' '--with-openssl' > '--with-gssapi' '--with-includes=3D/usr/include' > '--with-libraries=3D/usr/lib64' '--enable-nls' '--with-ldap' '--with-lz4' > '--with-selinux' '--with-systemd' > '--with-system-tzdata=3D/usr/share/zoneinfo' > 'build_alias=3Dx86_64-redhat-linux-gnu' 'host_alias=3Dx86_64-redhat-linux= -gnu' > 'CC=3Dgcc' 'CFLAGS=3D-O2 -flto=3Dauto -ffat-lto-objects -fexceptions -g > -grecord-gcc-switches -pipe -Wall -Werror=3Dformat-security > -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS > -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong > -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -march=3Dx86-64-v2 > -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection > -fcf-protection' 'LDFLAGS=3D-Wl,--as-needed' 'CXX=3Dg++' 'CXXFLAGS=3D-O2 > -flto=3Dauto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pip= e > -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 > -Wp,-D_GLIBCXX_ASSERTIONS -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc= 1 > -fstack-protector-strong -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 > -m64 -march=3Dx86-64-v2 -mtune=3Dgeneric -fasynchronous-unwind-tables > -fstack-clash-protection -fcf-protection' > 'PKG_CONFIG_PATH=3D:/usr/lib64/pkgconfig:/usr/share/pkgconfig' > 'PYTHON=3D/usr/bin/python3' > CC =3D gcc > CPPFLAGS =3D -D_GNU_SOURCE -I/usr/include > CFLAGS =3D -Wall -Wmissing-prototypes -Wpointer-arith > -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels > -Wmissing-format-attribute -Wimplicit-fallthrough=3D3 -Wcast-function-typ= e > -Wshadow=3Dcompatible-local -Wformat-security -fno-strict-aliasing -fwrap= v > -fexcess-precision=3Dstandard -Wno-format-truncation -Wno-stringop-trunca= tion > -O2 -flto=3Dauto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches > -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 > -Wp,-D_GLIBCXX_ASSERTIONS -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc= 1 > -fstack-protector-strong -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 = -m64 > -march=3Dx86-64-v2 -mtune=3Dgeneric -fasynchronous-unwind-tables > -fstack-clash-protection -fcf-protection > CFLAGS_SL =3D -fPIC > LDFLAGS =3D -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed > LDFLAGS_EX =3D > LDFLAGS_SL =3D > LIBS =3D -lpgcommon -lpgport -lselinux -llz4 -lssl -lcrypto -lgssapi_krb5 > -lz -lreadline -lm > VERSION =3D PostgreSQL 17.0 > > Regards, > ayrus02 > > > On 18-11-2024 16:26, Khushboo Vashi wrote: > > > > On Mon, Nov 18, 2024 at 2:48=E2=80=AFPM Surya Widyanto 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=E2=80=AFPM Surya Widyanto 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 runnin= g >>> 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=E2=80=AFPM Surya Widyanto >>> 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 >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> Today, I've upgraded my pgAdmin4 version from v8.12 to v8.13 using dn= f >>>>> 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 conta= ins >>>>> 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 >>>>> >>>> >>>> >>> >> > --0000000000000416af06272cbed4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Make sure that your libpq is located at=C2=A0LIBDIR =3D /usr/lib64. This error may occ= ur when you have multiple libpq installed on your system. Also do not forge= t to restart the apache server.

Thanks,
Khushboo



On Mo= n, Nov 18, 2024 at 3:06=E2=80=AFPM Surya Widyanto <ayrus02@gmail.com> wrote:
=20 =20 =20
Hi,

Below are the output of pg_config on on my AlmaLinux 8 (x64) machine:

BINDIR =3D /usr/bin
DOCDIR =3D /usr/share/doc/pgsql
HTMLDIR =3D /usr/share/doc/pgsql
INCLUDEDIR =3D /usr/include
PKGINCLUDEDIR =3D /usr/include/pgsql
INCLUDEDIR-SERVER =3D /usr/include/pgsql/server
LIBDIR =3D /usr/lib64
PKGLIBDIR =3D /usr/lib64/pgsql
LOCALEDIR =3D /usr/share/locale
MANDIR =3D /usr/share/man
SHAREDIR =3D /usr/share/pgsql
SYSCONFDIR =3D /etc/pgsql
PGXS =3D /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk
CONFIGURE =3D=C2=A0 '--build=3Dx86_64-redhat-linux-gnu' '--host=3Dx86_64-redhat-linux-gnu' '--program-prefix=3D= ' '--disable-dependency-tracking' '--prefix=3D/usr' '--exec-prefix=3D/usr' '--bindir=3D/usr/bin' '-= -sbindir=3D/usr/sbin' '--sysconfdir=3D/etc' '--datadir=3D/usr/share' '--includedir=3D/usr/include' '--libdir=3D/usr/lib64= 9; '--libexecdir=3D/usr/libexec' '--localstatedir=3D/var&#= 39; '--sharedstatedir=3D/var/lib' '--mandir=3D/usr/share/ma= n' '--infodir=3D/usr/share/info' '--disable-rpath' = 9;--with-openssl' '--with-gssapi' '--with-includes=3D/usr/include' '--with-libraries=3D/usr/lib64' '--enable-nls' '= ;--with-ldap' '--with-lz4' '--with-selinux' '--with-systemd&#= 39; '--with-system-tzdata=3D/usr/share/zoneinfo' 'build_alias=3Dx86_64-redhat-linux-gnu' 'host_alias=3Dx86_64-redhat-linux-gnu' 'CFLAGS=3D-O2 -g= -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'LDFLAGS=3D-Wl,--as-needed' 'CXXFLAGS=3D-O2 -g -pipe -W= all -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'PKG_CONFIG_PATH=3D:/usr/lib64/pkgconfig:/usr/share/pkgconfig&#= 39; 'PYTHON=3D/usr/bin/python3'
CC =3D gcc
CPPFLAGS =3D -D_GNU_SOURCE -I/usr/include
CFLAGS =3D -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3D3 -Wcast-function-type -Wshadow=3Dcompatible-local -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstandard -Wno-format-truncation -Wno-stringop-truncation -O2 -g -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection
CFLAGS_SL =3D -fPIC
LDFLAGS =3D -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed
LDFLAGS_EX =3D
LDFLAGS_SL =3D
LIBS =3D -lpgcommon -lpgport -lselinux -llz4 -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lpthread -lrt -ldl -lm
VERSION =3D PostgreSQL 17.0

Below are the output of pg_config on on my AlmaLinux 9 (x64) machine:

BINDIR =3D /usr/bin
DOCDIR =3D /usr/share/doc/pgsql
HTMLDIR =3D /usr/share/doc/pgsql
INCLUDEDIR =3D /usr/include
PKGINCLUDEDIR =3D /usr/include/pgsql
INCLUDEDIR-SERVER =3D /usr/include/pgsql/server
LIBDIR =3D /usr/lib64
PKGLIBDIR =3D /usr/lib64/pgsql
LOCALEDIR =3D /usr/share/locale
MANDIR =3D /usr/share/man
SHAREDIR =3D /usr/share/pgsql
SYSCONFDIR =3D /etc/pgsql
PGXS =3D /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk
CONFIGURE =3D=C2=A0 '--build=3Dx86_64-redhat-linux-gnu' '--host=3Dx86_64-redhat-linux-gnu' '--program-prefix=3D= ' '--disable-dependency-tracking' '--prefix=3D/usr' '--exec-prefix=3D/usr' '--bindir=3D/usr/bin' '-= -sbindir=3D/usr/sbin' '--sysconfdir=3D/etc' '--datadir=3D/usr/share' '--includedir=3D/usr/include' '--libdir=3D/usr/lib64= 9; '--libexecdir=3D/usr/libexec' '--localstatedir=3D/var&#= 39; '--sharedstatedir=3D/var/lib' '--mandir=3D/usr/share/ma= n' '--infodir=3D/usr/share/info' '--disable-rpath' = 9;--with-openssl' '--with-gssapi' '--with-includes=3D/usr/include' '--with-libraries=3D/usr/lib64' '--enable-nls' '= ;--with-ldap' '--with-lz4' '--with-selinux' '--with-systemd&#= 39; '--with-system-tzdata=3D/usr/share/zoneinfo' 'build_alias=3Dx86_64-redhat-linux-gnu' 'host_alias=3Dx86_64-redhat-linux-gnu' 'CC=3Dgcc' &= #39;CFLAGS=3D-O2 -flto=3Dauto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -march=3Dx86-64-v2 -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'LDFLAGS=3D-Wl,--as-needed' 'CXX=3Dg++' 'CXXFLA= GS=3D-O2 -flto=3Dauto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1=C2=A0 -m64 -march=3Dx86-64-v2 -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'PKG_CONFIG_PATH=3D:/usr/lib64/pkgconfig:/usr/share/pkgconfig&#= 39; 'PYTHON=3D/usr/bin/python3'
CC =3D gcc
CPPFLAGS =3D -D_GNU_SOURCE -I/usr/include
CFLAGS =3D -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3D3 -Wcast-function-type -Wshadow=3Dcompatible-local -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstandard -Wno-format-truncation -Wno-stringop-truncation -O2 -flto=3Dauto -ffat-lto-objects -fexceptions -g -grecord-gcc-switches -pipe -Wall -Werror=3Dformat-security -Wp,-D_FORTIFY_SOURCE=3D2 -Wp,-D_GLIBCXX_ASSERTIONS -specs=3D/usr/lib/rpm/redhat/redhat-hardened-cc1 -fstack-protector-strong -specs=3D/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -march=3Dx86-64-v2 -mtune=3Dgeneric -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection
CFLAGS_SL =3D -fPIC
LDFLAGS =3D -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed
LDFLAGS_EX =3D
LDFLAGS_SL =3D
LIBS =3D -lpgcommon -lpgport -lselinux -llz4 -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lm
VERSION =3D PostgreSQL 17.0

Regards,
ayrus02


On 18-11-2024 16:26, Khushboo Vashi wrote:
=20


On Mon, Nov 18, 2024 at 2:48=E2=80=AFPM 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 ?=C2=A0
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=E2=80=AFPM 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=E2=80=AFPM Surya Widy= anto <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 Sury= a 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/pgAd= min4.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





--0000000000000416af06272cbed4--