Re: Mac OS X error for pgAdmin 4.1.2

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 <matshyeq(at)gmail(dot)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(dot)thakkar(at)enterprisedb(dot)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 <matshyeq(at)gmail(dot)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(dot)vashi(at)enterprisedb(dot)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 <matshyeq(at)gmail(dot)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(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> On Tue, Feb 21, 2017 at 3:15 PM, Dave Page <dpage(at)pgadmin(dot)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 <dpage(at)pgadmin(dot)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 <matshyeq(at)gmail(dot)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 <dpage(at)pgadmin(dot)org>
>>>>>>> wrote:
>>>>>>> >>>
>>>>>>> >>> Hi
>>>>>>> >>>
>>>>>>> >>> On Mon, Feb 20, 2017 at 7:43 AM, matshyeq <matshyeq(at)gmail(dot)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(at)postgresql(dot)or
>>>>>>> g)
>>>>>>> To make changes to your subscription:
>>>>>>> http://www.postgresql.org/mailpref/pgadmin-support
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>>
>> --
>> Sandeep Thakkar
>>
>>
>>
>>
>>
>

--
Sandeep Thakkar