Re: Mac OS X error for pgAdmin 4.1.2

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)org
>>>>>> )
>>>>>> To make changes to your subscription:
>>>>>> http://www.postgresql.org/mailpref/pgadmin-support
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
>
> --
> Sandeep Thakkar
>
>
>
>
>