Re: [pgadmin-support] 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@gmail.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.thakkar@enterprisedb.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/libssl.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@gmail.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.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

--

Sandeep Thakkar

--

Sandeep Thakkar