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 >>>> >>> >>> >> >
