Re: Mac OS X error for pgAdmin 4.1.2

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/
QtCore.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/
> libpq.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/
> libssl.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