Re: pgAdmin 4 v8.7 Error - docker distribuition

Hi,

Issue is reproducible with SSL configuration and we found the fix too.
Will let you know when it will be available publicly.

Thanks
Yogesh

On Thu, 30 May 2024, 9:32 pm Edson Richter, <edsonrichter(at)hotmail(dot)com>
wrote:

> After upgrade to latest 8.7 using docker install, got the following stack
> trace, and docker won’t get up.
>
> Reverting to 8.6 works normally.
>
>
>
> [2024-05-30 18:56:31 +0300] [281] [INFO] Booting worker with pid: 281
>
> 2024-05-30 18:56:35,829: INFO pgadmin:
> ########################################################
>
> 2024-05-30 18:56:35,830: INFO pgadmin: Starting pgAdmin 4 v8.7...
>
> 2024-05-30 18:56:35,830: INFO pgadmin:
> ########################################################
>
> 2024-05-30 18:56:35,830: DEBUG pgadmin: Python syspath:
> ['/pgadmin4', '/venv/bin', '/pgadmin4', '/usr/lib/python312.zip',
> '/usr/lib/python3.12', '/usr/lib/python3.12/lib-dynload',
> '/venv/lib/python3.12/site-packages', '/usr/lib/python3.12/site-packages']
>
> 2024-05-30 18:56:37,388: INFO pgadmin: Registering blueprint
> module: <AboutModule 'about'>
>
> 2024-05-30 18:56:37,390: INFO pgadmin: Registering blueprint
> module: <AuthenticateModule 'authenticate'>
>
> 2024-05-30 18:56:37,391: INFO pgadmin: Registering blueprint
> module: <BrowserModule 'browser'>
>
> 2024-05-30 18:56:39,595: INFO pgadmin: Registering blueprint
> module: <DashboardModule 'dashboard'>
>
> 2024-05-30 18:56:39,618: INFO pgadmin: Registering blueprint
> module: <HelpModule 'help'>
>
> 2024-05-30 18:56:39,619: INFO pgadmin: Registering blueprint
> module: <MiscModule 'misc'>
>
> 2024-05-30 18:56:41,285: INFO pgadmin: Registering blueprint
> module: <PreferencesModule 'preferences'>
>
> 2024-05-30 18:56:41,289: INFO pgadmin: Registering blueprint
> module: <PgAdminModule 'redirects'>
>
> 2024-05-30 18:56:41,291: INFO pgadmin: Registering blueprint
> module: <SettingsModule 'settings'>
>
> 2024-05-30 18:56:41,296: INFO pgadmin: Registering blueprint
> module: <ToolsModule 'tools'>
>
> 2024-05-30 18:56:42,449: DEBUG pgadmin: Config server mode: True
>
> 2024-05-30 18:56:42,449: DEBUG pgadmin: Not running under the
> desktop runtime, port: 5050
>
> [2024-05-30 18:56:42 +0300] [281] [ERROR] Exception in worker process
>
> Traceback (most recent call last):
>
> File "/venv/lib/python3.12/site-packages/gunicorn/arbiter.py", line 589,
> in spawn_worker
>
> worker.init_process()
>
> File "/venv/lib/python3.12/site-packages/gunicorn/workers/gthread.py",
> line 92, in init_process
>
> super().init_process()
>
> File "/venv/lib/python3.12/site-packages/gunicorn/workers/base.py", line
> 142, in init_process
>
> self.run()
>
> File "/venv/lib/python3.12/site-packages/gunicorn/workers/gthread.py",
> line 203, in run
>
> callback(key.fileobj)
>
> File "/venv/lib/python3.12/site-packages/gunicorn/workers/gthread.py",
> line 124, in accept
>
> self.enqueue_req(conn)
>
> File "/venv/lib/python3.12/site-packages/gunicorn/workers/gthread.py",
> line 112, in enqueue_req
>
> conn.init()
>
> File "/venv/lib/python3.12/site-packages/gunicorn/workers/gthread.py",
> line 52, in init
>
> self.sock = ssl.wrap_socket(self.sock, server_side=True,
>
> ^^^^^^^^^^^^^^^
>
> AttributeError: module 'ssl' has no attribute 'wrap_socket'
>
> [2024-05-30 18:56:42 +0300] [281] [INFO] Worker exiting (pid: 281)
>
>
>
>
>
> Best regards,
>
>
>
> ER.
>
>
>
> *De:* Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
> *Enviada em:* quinta-feira, 30 de maio de 2024 05:44
> *Para:* pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
> *Assunto:* pgAdmin 4 v8.7 Released
>
>
>
> The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.7.
>
>
>
> This release of pgAdmin 4 includes 19 bug fixes and new features. For more
> details please see the release notes at:
>
>
>
> https://www.pgadmin.org/docs/pgadmin4/8.7/release_notes_8_7.html
>
>
>
> pgAdmin is the leading Open Source graphical management tool for
> PostgreSQL. For more information, please see:
>
>
>
> https://www.pgadmin.org/
>
>
>
> Notable changes in this release include:
>
>
>
> *Features*:
>
> - Added support for the 'Add to macros' feature and fixed various
> usability issues.
> - Added support for executing the query at the cursor position in the
> query tool.
> - Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove
> the use of Accesskey which will allow them to be customized.
> - Added support for viewing PGD Clusters.
> - Enhance the Delete dialog by highlighting the names of the objects
> to be deleted in bold.
> - Added support for platform Ubuntu 24.04 and Fedora 40.
>
>
>
>
>
> *Bugs/Housekeeping*:
>
> - Upgrade react-table from v7 to v8.
> - Ensure that Schema Diff does not indicate a table as different when
> the trigger names are the same but the trigger function body is different.
> - Fixed an issue of the pgAdmin window size increasing each time it
> was reopened.
> - Update the documentation for the preferences dialog and keyboard
> shortcuts.
> - Fixed an issue where pgAdmin fails to start when Ubuntu OS is
> upgraded to a major version.
> - Fixed incorrect highlighting for C-Style escape strings in SQL
> editor.
> - Fixed an issue where the recover password button was enabled even
> when no email was provided.
> - Fixed an issue where resetting the password from the password reset
> link was not working.
>
>
>
> Builds for Windows and macOS are available now, along with a Python Wheel,
>
> Docker Container, RPM, DEB Package, and source code tarball from:
>
> https://www.pgadmin.org/download/
>
>
>
> --
>
> Akshay Joshi
>
> pgAdmin Project
>
>
>