Re: Mac OS X error for pgAdmin 4.1.2

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/
> psycopg2/_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
>>>>
>>>
>>>
>>
>