Skip to content

After upgrading from pgAdmin 4 v9.15 to v9.16 Pgadmin fails with "Could not contact Server" #10151

Description

@anitagraham

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug
After updating from v9.15 to v9.16, opening pgAdmin takes a long time and eventually fails with The pgAdmin 4 server could not be contacted:, and a window of trace information - see Error message section.

pgAdmin 4 9.15 was working as usual.

Error message
The key message seems to be

'/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' not valid for use in process: mapped file has no cdhash, completely unsigned? Code has to be at least ad-hoc signed.)

The full trace

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgAdmin4.py", line 38, in <module>
    import config
  File "/Applications/pgAdmin 4.app/Contents/Resources/web/config.py", line 33, in <module>
    from pgadmin.utils import env, IS_WIN, fs_short_path
  File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/__init__.py", line 46, in <module>
    from pgadmin.utils.session import create_session_interface, pga_unauthorised
  File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/session.py", line 35, in <module>
    from cryptography.fernet import Fernet, InvalidToken
  File "/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/cryptography/fernet.py", line 15, in <module>
    from cryptography.exceptions import InvalidSignature
  File "/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/cryptography/exceptions.py", line 9, in <module>
    from cryptography.hazmat.bindings._rust import exceptions as rust_exceptions
ImportError: dlopen(/Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/cryptography/hazmat/bindings/_rust.abi3.so, 0x0002): Library not loaded: /usr/local/opt/openssl@3/lib/libssl.3.dylib
  Referenced from: <7B82453A-6A52-3497-ADC5-B6AE67F1C00B> /Applications/pgAdmin 4.app/Contents/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/cryptography/hazmat/bindings/_rust.abi3.so
  Reason: tried: '/usr/local/opt/openssl@3/lib/libssl.3.dylib' (code signature in <D5103B82-540A-3D04-9B22-8E453EC24EBB> '/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' not valid for use in process: mapped file has no cdhash, completely unsigned? Code has to be at least ad-hoc signed.), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/opt/openssl@3/lib/libssl.3.dylib' (no such file), '/usr/local/opt/openssl@3/lib/libssl.3.dylib' (code signature in <D5103B82-540A-3D04-9B22-8E453EC24EBB> '/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' not valid for use in process: mapped file has no cdhash, completely unsigned? Code has to be at least ad-hoc signed.), '/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' (code signature in <D5103B82-540A-3D04-9B22-8E453EC24EBB> '/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' not valid for use in process: mapped file has no cdhash, completely unsigned? Code has to be at least ad-hoc signed.), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' (no such file), '/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' (code signature in <D5103B82-540A-3D04-9B22-8E453EC24EBB> '/usr/local/Cellar/openssl@3/3.5.2/lib/libssl.3.dylib' not valid for use in process: mapped file has no cdhash, completely unsigned? Code has to be at least ad-hoc signed.)

Desktop (please complete the following information):
ProductName: macOS
ProductVersion: 15.7.7
BuildVersion: 24G720

Question
Is openssl v3 the problem? What are the implications of upgrading openssl to v4?

thanks, Anita Graham

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions