So why does it work on my MacOS 10.9 test system? On Wed, Feb 22, 2017 at 11:15 AM, Sandeep Thakkar < sandeep.thak...@enterprisedb.com> wrote:
> 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/libs >> sl.1.0.0.dylib >> >> Executable=/Applications/pgAdmin 4.app/Contents/Frameworks/libs >> sl.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/QtCo >> re.framework/Versions/5/QtCore >> >> Executable=/Applications/pgAdmin 4.app/Contents/Frameworks/QtCo >> re.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/psyco >> pg2/_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-support@postgresql.org) >>>>>>>> To make changes to your subscription: >>>>>>>> http://www.postgresql.org/mailpref/pgadmin-support >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >>> >>> -- >>> Sandeep Thakkar >>> >>> >>> >>> >>> >> > > > -- > Sandeep Thakkar > > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
