Re: pgAdmin 4 v1.1 for macOS

Hi,

I don't have wget on my Mac. I tried to download the file directly using curl.
The dmg file still appears not signed but now pgAdmin starts. I don't know how codesign works but I don't have same CDHash than you but now the application is working.
Thanks for your support.

MBP-NIJ-02:Downloads nij$ curl -O https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.1/macos/pgadmin4-1.1.dmg

% Total % Received % Xferd Average Speed Time Time Time Current

Dload Upload Total Spent Left Speed

100 69.9M 100 69.9M 0 0 3785k 0 0:00:18 0:00:18 --:--:-- 5591k

MBP-NIJ-02:Downloads nij$ codesign -dv --verbose=4 pgadmin4-1.1.dmg

pgadmin4-1.1.dmg: code object is not signed at all

MBP-NIJ-02:Downloads nij$ shasum pgadmin4-1.1.dmg

8e698b51c9526b0ee6a16f911f44fea3676b859f pgadmin4-1.1.dmg

MBP-NIJ-02:Downloads nij$ codesign -dv --verbose=4 /Applications/pgAdmin\ 4.app/

Executable=/Applications/pgAdmin 4.app/Contents/MacOS/pgAdmin4

Identifier=org.pgadmin.pgAdmin4

Format=bundle with Mach-O thin (x86_64)

CodeDirectory v=20200 size=1364 flags=0x0(none) hashes=61+3 location=embedded

Hash type=sha1 size=20

CDHash=035adc859c622737e25074074b5ed8d813b59b40

Signature size=8936

Authority=Developer ID Application: EnterpriseDB Corporation (26QKX55P9K)

Authority=Developer ID Certification Authority

Authority=Apple Root CA

Timestamp=25 oct. 2016 11:20:43

Info.plist entries=13

TeamIdentifier=26QKX55P9K

Sealed Resources version=2 rules=13 files=6298

Internal requirements count=1 size=180

Best Regards,

Nicolas
---------
Nicolas Jardot | Senior Consultant | Oracle Certified Professional – Database 11g and 12c | ITIL Foundations v3 certified
Phone: +41 32 422 96 00 | Mobile: +41 79 835 02 95 | Fax: +41 32 422 96 15
dbi services, Voltastrasse 104, CH-4056 Basel
nicolas(dot)jardot(at)dbi-services(dot)com
www.dbi-services.com

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: "Nicolas Jardot" <nicolas(dot)jardot(at)dbi-services(dot)com>
Cc: "pgAdmin Support" <pgadmin-support(at)postgresql(dot)org>
Sent: Thursday, November 10, 2016 6:04:26 PM
Subject: Re: [pgadmin-support] pgAdmin 4 v1.1 for macOS

Hi

On Thu, Nov 10, 2016 at 4:20 PM, Nicolas Jardot
<nicolas(dot)jardot(at)dbi-services(dot)com> wrote:
> Hi,
>
> Sorry for the direct email.
> I checked the signature for both dmg file and the application package.
>
> For the dmg file, It says "code object not signed at all".
> The signature for the .app is definitively different.
>
> I tried to download again the disk image from another browser (Chrome
> instead of Safari) but it's the same.
> Is it possible to check that the file on the FTP is the correct one?
>
> I downloaded the file from :
> https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.1/macos/pgadmin4-1.1.dmg
> The link comes from the official web page:
> https://www.postgresql.org/ftp/pgadmin3/pgadmin4/v1.1/macos/

It looks fine to me. Maybe there's a cache between you and the
download server that has a broken copy?

piranha:~ dpage$ mkdir tmp
piranha:~ dpage$ cd tmp
piranha:tmp dpage$ wget
https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.1/macos/pgadmin4-1.1.dmg
--2016-11-10 17:00:40--
https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.1/macos/pgadmin4-1.1.dmg
Resolving ftp.postgresql.org (ftp.postgresql.org) 87.238.57.227,
217.196.149.55, 204.145.124.244, ...
Connecting to ftp.postgresql.org
(ftp.postgresql.org)|87.238.57.227|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 73391750 (70M) [application/x-apple-diskimage]
Saving to: ‘pgadmin4-1.1.dmg’

pgadmin4-1.1.dmg
100%[=======================================================================================>]
69.99M 621KB/s in 2m 2s

2016-11-10 17:02:43 (588 KB/s) - ‘pgadmin4-1.1.dmg’ saved [73391750/73391750]

piranha:tmp dpage$ codesign -dv --verbose=4 pgadmin4-1.1.dmg
Executable=/Users/dpage/tmp/pgadmin4-1.1.dmg
Identifier=pgadmin4-1
Format=disk image
CodeDirectory v=20200 size=298 flags=0x0(none) hashes=1+6 location=embedded
Hash type=sha256 size=32
CandidateCDHash sha256=c320443b5b37a897bf1192af0450b90fe1317d52
Hash choices=sha256
Page size=none
CDHash=c320443b5b37a897bf1192af0450b90fe1317d52
Signature size=8885
Authority=Developer ID Application: EnterpriseDB Corporation (26QKX55P9K)
Authority=Developer ID Certification Authority
Authority=Apple Root CA
Timestamp=25 Oct 2016, 10:21:06
Info.plist=not bound
TeamIdentifier=26QKX55P9K
Sealed Resources=none
Internal requirements count=1 size=172

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company