public inbox for [email protected]
help / color / mirror / Atom feedFrom: Surya Widyanto <[email protected]>
To: Khushboo Vashi <[email protected]>
Cc: pgAdmin Support <[email protected]>
Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12
Date: Wed, 4 Dec 2024 11:54:33 +0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFOhELfw6=hykpDE=Uk4kFh63NEphHmHaQdZaW61wREAsPuPqA@mail.gmail.com>
References: <[email protected]>
<CAFOhELdyd3yiHHH-wbYn12yD+LFZjua7t==h-L_oLuiUuq2uxQ@mail.gmail.com>
<[email protected]>
<CAFOhELdnwePfWjfE7hFB2AkhP5hSojWUFOdL7KySwFKSDYmkqQ@mail.gmail.com>
<[email protected]>
<CAFOhELeUHU0FX-y7r4dD974DbS=zOTzFSUeAnjVmMbunaXpccw@mail.gmail.com>
<[email protected]>
<CAFOhELdERWD_iX18KE204hoeAvu_XR5WoOjqiY0Cphxo2487Bw@mail.gmail.com>
<[email protected]>
<CAFOhELeAd-NamazS_Z1R6m+oGoa1WM8v8jGKHXXGwSrHx7Dk7Q@mail.gmail.com>
<[email protected]>
<CAFOhELfw6=hykpDE=Uk4kFh63NEphHmHaQdZaW61wREAsPuPqA@mail.gmail.com>
Hi,
I've try to move the libpq.so and libpq.so.5 to other locatiom. and
restart the apache httpd.
And the result is still the same, Error 500 on the web.
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:
Regards,
ayrus02
On 03-12-2024 12:33, Khushboo Vashi wrote:
>
>
> On Mon, Dec 2, 2024 at 6:31 PM Surya Widyanto <[email protected]> wrote:
>
> 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
>
> Please try moving libpq.so and libpq.so.5 to the other location and
> keeping only one libpq `/usr/lib64/libpq.so.5.17`.
>
> 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
>> <[email protected]> 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
>>> <[email protected]> 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
>>>> <[email protected]> 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
>>>>> <[email protected]> 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 <[email protected]> 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*
>>>>>> *
>>>>>>
>>>>>
>>>>
>>>
>>
>
Attachments:
[image/png] RROflNiSInadd06d.png (23.5K, 3-RROflNiSInadd06d.png)
download | view image
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Cannot Run pgAdmin4 v8.13 on AlmaLinux 8 after upgrade from v8.12
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox