Re: [pgadmin-support] Mac OS X error for pgAdmin 4.1.2 - Mailing list pgadmin-support

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.vashi@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/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.linkedin.com/in/asheshvashi

On Tue, Feb 21, 2017 at 6:26 PM, matshyeq <matshyeq@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.vashi@enterprisedb.com> wrote:

On Tue, Feb 21, 2017 at 3:15 PM, Dave Page <dpage@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:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.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/pgAdmin4.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/psycopg2/__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/psycopg2/_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/psycopg2/_psycopg.so
  Reason: no suitable image found.  Did find:
/Applications/pgAdmin
4.app/Contents/Resources/venv/lib/python/site-packages/psycopg2/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib:
code signature invalid for '/Applications/pgAdmin
4.app/Contents/Resources/venv/lib/python/site-packages/psycopg2/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib'

/Applications/pgAdmin
4.app/Contents/Resources/venv/lib/python/site-packages/psycopg2/../../../../../../../Contents/Frameworks/libssl.1.0.0.dylib:
code signature invalid for '/Applications/pgAdmin
4.app/Contents/Resources/venv/lib/python/site-packages/psycopg2/../../../../../../../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/Contents/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@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 <matshyeq@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 <dpage@pgadmin.org> wrote:
>>>
>>> Hi
>>>
>>> On Mon, Feb 20, 2017 at 7:43 AM, matshyeq <matshyeq@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