On Wed, Feb 22, 2017 at 5:19 PM, Dave Page <dp...@pgadmin.org> wrote:
> So why does it work on my MacOS 10.9 test system? > > Right, the link below says that the library validation starts from 10.10 ( https://developer.apple.com/library/content/documentation/Security/Conceptual/CodeSigningGuide/Procedures/Procedures.html ) 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 > -- Sandeep Thakkar
