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 <ayru...@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 > 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 > 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 <ayru...@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 <ayru...@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 <ayru...@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 <ayru...@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: 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 >>>>> >>>> >>>> >>> >> >
