So, if you see the libssl library is signed with SHA256 algorithm which probably is not understood by MacOS 10.10. I found a related article @ http://www.discretecosine.com/index-html-2/
That means the build was done on higher version of MacOS and to fix this, the code should be rebuild with "-mmacosx-version-min=10.9" compiler/linker flags. On Wed, Feb 22, 2017 at 3:40 PM, matshyeq <matsh...@gmail.com> wrote: > Hi Sandeep, > > Please see below: > > ○ → codesign -vvvd /Applications/pgAdmin\ 4.app/Contents/Frameworks/ > libssl.1.0.0.dylib > > Executable=/Applications/pgAdmin 4.app/Contents/Frameworks/ > libssl.1.0.0.dylib > > Identifier=libssl.1 > > Format=Mach-O thin (x86_64) > > CodeDirectory v=20200 size=3336 flags=0x0(none) hashes=100+2 > location=embedded > > Hash type=sha256 size=32 > > CDHash=658db12e24c9bc952fcbaed53d2d66c785e890fa > > Signature size=8886 > > Authority=Developer ID Application: EnterpriseDB Corporation (26QKX55P9K) > > Authority=Developer ID Certification Authority > > Authority=Apple Root CA > > Timestamp=10 Feb 2017 10:42:09 > > Info.plist=not bound > > TeamIdentifier=26QKX55P9K > > Sealed Resources=none > > Internal requirements count=1 size=168 > > ○ → codesign -vvvd /Applications/pgAdmin\ 4.app/Contents/Frameworks/ > QtCore.framework/Versions/5/QtCore > > Executable=/Applications/pgAdmin 4.app/Contents/Frameworks/ > QtCore.framework/Versions/5/QtCore > > Identifier=org.qt-project.Qt.QtCore > > Format=bundle with Mach-O thin (x86_64) > > CodeDirectory v=20200 size=29648 flags=0x0(none) hashes=1475+3 > location=embedded > > Hash type=sha1 size=20 > > CDHash=2848273fdc5c8d0eb57084f40a53e0d989ce3a99 > > Signature size=8935 > > Authority=Developer ID Application: EnterpriseDB Corporation (26QKX55P9K) > > Authority=Developer ID Certification Authority > > Authority=Apple Root CA > > Timestamp=10 Feb 2017 10:42:10 > > Info.plist entries=8 > > TeamIdentifier=26QKX55P9K > > Sealed Resources version=2 rules=13 files=1 > > Internal requirements count=1 size=184 > > > ○ → codesign -vvvd /Applications/pgAdmin\ 4.app/Contents/Resources/venv/ > lib/python/site-packages/psycopg2/_psycopg.so > > /Applications/pgAdmin 4.app/Contents/Resources/venv/ > lib/python/site-packages/psycopg2/_psycopg.so: code object is not signed > at all > > ○ → ls -l /Applications/pgAdmin\ 4.app/Contents/Resources/venv/ > lib/python/site-packages/psycopg2/_psycopg.so > > -rwxr-xr-x@ 1 maciek admin 376120 10 Feb 10:42 /Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/ > psycopg2/_psycopg.so > > Thank you, > Kind Regards > ~Maciek > > On 22 February 2017 at 05:47, Sandeep Thakkar < > sandeep.thak...@enterprisedb.com> wrote: > >> I see you are running the pgAdmin app on 10.10.5. Is it built on the same >> MacOS version? I suspect this is related to SHA algorithm. What's the >> output for the following: >> >> $ codesign -vvvd /Applications/pgAdmin\ 4.app/Contents/Frameworks/libs >> sl.1.0.0.dylib >> $ codesign -vvvd /Applications/pgAdmin\ 4.app/Contents/Frameworks/QtCo >> re.framework/Versions/5/QtCore >> $ codesign -vvvd /Applications/pgAdmin\ 4.app/Contents/Resources/venv/ >> lib/python/site-packages/psycopg2/_psycopg.so >> >> On Wed, Feb 22, 2017 at 12:07 AM, matshyeq <matsh...@gmail.com> wrote: >> >>> Hi Ashesh, >>> >>> Here it is: >>> >>> ○ → otool -L "/Applications/pgAdmin 4.app/Contents/Resources/venv/ >>> lib/python/site-packages/psycopg2/_psycopg.so" >>> >>> /Applications/pgAdmin 4.app/Contents/Resources/venv/ >>> lib/python/site-packages/psycopg2/_psycopg.so: >>> >>> @loader_path/../../../../../../../Contents/Frameworks/libpq.5.dylib >>> (compatibility version 5.0.0, current version 5.9.0) >>> >>> @loader_path/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib >>> (compatibility version 1.0.0, current version 1.0.0) >>> >>> @loader_path/../../../../../../../Contents/Frameworks/libcrypto.1.0.0.dylib >>> (compatibility version 1.0.0, current version 1.0.0) >>> >>> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version >>> 1238.0.0) >>> >>> >>> ○ → otool -L "/Applications/pgAdmin 4.app/Contents/Frameworks/libp >>> q.5.dylib" >>> >>> /Applications/pgAdmin 4.app/Contents/Frameworks/libpq.5.dylib: >>> >>> /usr/local/pgsql-9.6/lib/libpq.5.dylib (compatibility version 5.0.0, >>> current version 5.9.0) >>> >>> @loader_path/../../Contents/Frameworks/libssl.1.0.0.dylib >>> (compatibility version 1.0.0, current version 1.0.0) >>> >>> @loader_path/../../Contents/Frameworks/libcrypto.1.0.0.dylib >>> (compatibility version 1.0.0, current version 1.0.0) >>> >>> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version >>> 1238.0.0) >>> >>> >>> ○ → otool -L "/Applications/pgAdmin 4.app/Contents/Frameworks/libs >>> sl.1.0.0.dylib" >>> >>> /Applications/pgAdmin 4.app/Contents/Frameworks/libssl.1.0.0.dylib: >>> >>> libssl.1.0.0.dylib (compatibility version 1.0.0, current version 1.0.0) >>> >>> @loader_path/../../Contents/Frameworks/libcrypto.1.0.0.dylib >>> (compatibility version 1.0.0, current version 1.0.0) >>> >>> @loader_path/../../Contents/Frameworks/libz.1.dylib (compatibility >>> version 1.0.0, current version 1.2.8) >>> >>> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version >>> 1238.0.0) >>> >>> Thank you, >>> Kind Regards >>> ~Maciek >>> >>> On 21 February 2017 at 14:22, Ashesh Vashi < >>> ashesh.va...@enterprisedb.com> wrote: >>> >>>> Can you please run the following command for me? >>>> otool -L "/Users/asheshvashi/Applications/pgAdmin >>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>> pg2/_psycopg.so" >>>> otool -L "/Users/asheshvashi/Applications/pgAdmin >>>> 4.app/Contents/Frameworks/libpq.5.dylib" >>>> otool -L "/Users/asheshvashi/Applications/pgAdmin >>>> 4.app/Contents/Frameworks/libssl.1.0.0.dylib" >>>> >>>> -- >>>> >>>> Thanks & Regards, >>>> >>>> Ashesh Vashi >>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company >>>> <http://www.enterprisedb.com> >>>> >>>> >>>> *http://www.linkedin.com/in/asheshvashi* >>>> <http://www.linkedin.com/in/asheshvashi> >>>> >>>> On Tue, Feb 21, 2017 at 6:26 PM, matshyeq <matsh...@gmail.com> wrote: >>>> >>>>> ○ → codesign --verbose --verify /Applications/pgAdmin\ >>>>> 4.app/Contents/Frameworks/libssl.1.0.0.dylib >>>>> /Applications/pgAdmin 4.app/Contents/Frameworks/libssl.1.0.0.dylib: >>>>> valid on disk >>>>> /Applications/pgAdmin 4.app/Contents/Frameworks/libssl.1.0.0.dylib: >>>>> satisfies its Designated Requirement >>>>> >>>>> Thank you, >>>>> Kind Regards >>>>> ~Maciek >>>>> >>>>> On 21 February 2017 at 12:36, Ashesh Vashi < >>>>> ashesh.va...@enterprisedb.com> wrote: >>>>> >>>>>> On Tue, Feb 21, 2017 at 3:15 PM, Dave Page <dp...@pgadmin.org> wrote: >>>>>> >>>>>>> Argh, darn mailer. Here's the output: >>>>>>> >>>>>>> maciek in /Applications/pgAdmin 4.app/Contents/MacOS >>>>>>> ○ → ./pgAdmin4 >>>>>>> Python path: "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages:/Syst >>>>>>> em/Library/Frameworks/Python.framework/Versions/2.7/lib/pyth >>>>>>> on2.7/lib-dynload:/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python" >>>>>>> Python Home: "/Applications/pgAdmin 4.app/Contents/Resources/venv" >>>>>>> Webapp path: "/Applications/pgAdmin 4.app/Contents/Resources/web/p >>>>>>> gAdmin4.py" >>>>>>> Traceback (most recent call last): >>>>>>> File "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/web/pgAdmin4.py", line 46, in <module> >>>>>>> app = create_app() >>>>>>> File "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/web/pgadmin/__init__.py", line 266, in >>>>>>> create_app >>>>>>> driver.init_app(app) >>>>>>> File "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/web/pgadmin/utils/driver/__init__.py", line >>>>>>> 40, in init_app >>>>>>> DriverRegistry.load_drivers() >>>>>>> File "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/web/pgadmin/utils/driver/registry.py", line >>>>>>> 88, in load_drivers >>>>>>> module = import_module(module_name) >>>>>>> File "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/importlib/__init__.py", >>>>>>> line >>>>>>> 37, in import_module >>>>>>> __import__(name) >>>>>>> File "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/web/pgadmin/utils/driver/psycopg2/_ >>>>>>> _init__.py", >>>>>>> line 23, in <module> >>>>>>> import psycopg2 >>>>>>> File "/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>>>>> pg2/__init__.py", >>>>>>> line 50, in <module> >>>>>>> from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, >>>>>>> ROWID >>>>>>> ImportError: dlopen(/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>>>>> pg2/_psycopg.so, >>>>>>> 2): Library not loaded: >>>>>>> @loader_path/../../../../../../../Contents/Frameworks/libssl >>>>>>> .1.0.0.dylib >>>>>>> Referenced from: /Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>>>>> pg2/_psycopg.so >>>>>>> Reason: no suitable image found. Did find: >>>>>>> /Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>>>>> pg2/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib: >>>>>>> code signature invalid for '/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>>>>> pg2/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib' >>>>>>> >>>>>>> /Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>>>>> pg2/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib: >>>>>>> code signature invalid for '/Applications/pgAdmin >>>>>>> 4.app/Contents/Resources/venv/lib/python/site-packages/psyco >>>>>>> pg2/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib' >>>>>>> >>>>>> Looks the bundled libssl is not valid. >>>>>> >>>>>> Can you verify it? >>>>>> i.e. >>>>>> codesign --verbose --verify /Applications/pgAdmin 4.app/Conte >>>>>> nts/Frameworks/libssl.1.0.0.dylib >>>>>> >>>>>> -- Thanks, >>>>>> Ashesh Vashi >>>>>> >>>>>>> >>>>>>> /usr/lib/libssl.1.0.0.dylib: code signature invalid for >>>>>>> '/usr/lib/libssl.1.0.0.dylib' >>>>>>> >>>>>>> Initial connection failed. Retrying in 2 seconds. >>>>>>> Initial connection failed. Retrying in 3 seconds. >>>>>>> Initial connection failed. Retrying in 4 seconds. >>>>>>> Initial connection failed after multiple attempts. Aborting. >>>>>>> >>>>>>> >>>>>>> On Tue, Feb 21, 2017 at 9:44 AM, Dave Page <dp...@pgadmin.org> >>>>>>> wrote: >>>>>>> > I don't know then I'm afraid. Ashesh, any idea what's going on? >>>>>>> Maciek >>>>>>> > is seeing the error below, however the signature on the app bundle >>>>>>> > verifies OK: >>>>>>> > >>>>>>> > >>>>>>> > On Tue, Feb 21, 2017 at 6:44 AM, matshyeq <matsh...@gmail.com> >>>>>>> wrote: >>>>>>> >> Hi Dave, >>>>>>> >> >>>>>>> >> I did as you told. No joy ;( >>>>>>> >> >>>>>>> >> Thank you, >>>>>>> >> Kind Regards >>>>>>> >> ~Maciek >>>>>>> >> >>>>>>> >> On 20 February 2017 at 10:48, Dave Page <dp...@pgadmin.org> >>>>>>> wrote: >>>>>>> >>> >>>>>>> >>> Hi >>>>>>> >>> >>>>>>> >>> On Mon, Feb 20, 2017 at 7:43 AM, matshyeq <matsh...@gmail.com> >>>>>>> wrote: >>>>>>> >>> > Hi Dave, >>>>>>> >>> > >>>>>>> >>> > Not sure what you meant. I've overwritten app from DMG - same >>>>>>> result :( >>>>>>> >>> >>>>>>> >>> I mean delete the existing app, then copy it again from the DMG. >>>>>>> Don't >>>>>>> >>> copy a new version over the old one (as that might merge the two >>>>>>> >>> versions, as appbundles are really just a directory structure >>>>>>> full of >>>>>>> >>> files). >>>>>>> >>> >>>>>>> >>> -- >>>>>>> >>> Dave Page >>>>>>> >>> Blog: http://pgsnake.blogspot.com >>>>>>> >>> Twitter: @pgsnake >>>>>>> >>> >>>>>>> >>> EnterpriseDB UK: http://www.enterprisedb.com >>>>>>> >>> The Enterprise PostgreSQL Company >>>>>>> >> >>>>>>> >> >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > -- >>>>>>> > Dave Page >>>>>>> > Blog: http://pgsnake.blogspot.com >>>>>>> > Twitter: @pgsnake >>>>>>> > >>>>>>> > EnterpriseDB UK: http://www.enterprisedb.com >>>>>>> > The Enterprise PostgreSQL Company >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Dave Page >>>>>>> Blog: http://pgsnake.blogspot.com >>>>>>> Twitter: @pgsnake >>>>>>> >>>>>>> EnterpriseDB UK: http://www.enterprisedb.com >>>>>>> The Enterprise PostgreSQL Company >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Sent via pgadmin-support mailing list (pgadmin-supp...@postgresql.or >>>>>>> g) >>>>>>> To make changes to your subscription: >>>>>>> http://www.postgresql.org/mailpref/pgadmin-support >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >> >> -- >> Sandeep Thakkar >> >> >> >> >> > -- Sandeep Thakkar
