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
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
The full trace
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