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