Обсуждение: Re: pgAdmin 4 v1.1 for macOS

Поиск
Список
Период
Сортировка

Re: pgAdmin 4 v1.1 for macOS

От
Nicolas Jardot
Дата:
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/

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.jardot@dbi-services.com
www.dbi-services.com


From: "Dave Page" <dpage@postgresql.org>
To: "Nicolas Jardot" <nicolas.jardot@dbi-services.com>
Sent: Wednesday, November 9, 2016 10:54:32 AM
Subject: Re: pgAdmin 4 v1.1 for macOS

Hi

Note: please direct any future questions to the pgadmin-support@postgresql.org mailing list.

On Tue, Nov 8, 2016 at 3:02 PM, Nicolas Jardot <nicolas.jardot@dbi-services.com> wrote:
Hi Dave,

I have an issue with pgAdmin 4 v1.1 for macOS.
When I try to start the application, I get a message from macOS saying that the application is damaged and cannot be open.
I can choose between cancel and put the app to the trash (or unmount the image when not installed).

I'm running OS Y Yosemite 10.10.5 on a MacBook Pro Retina (2013).
I don't have the problem with the v1.0 release of pgAdmin.

Can you please check the signature of the downloaded DMG file and pgAdmin4.app? e.g.

piranha:~ dpage$ codesign -dv --verbose=4 pgadmin4-1.1.dmg
Executable=/Users/dpage/git/pgadmin4/dist/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 

piranha:~ dpage$ codesign -dv --verbose=4 /Applications/pgAdmin\ 4.app/
Executable=/Applications/pgAdmin 4.app/Contents/MacOS/pgAdmin4
Identifier=org.pgadmin.pgAdmin4
Format=app bundle with Mach-O thin (x86_64)
CodeDirectory v=20200 size=2132 flags=0x0(none) hashes=61+3 location=embedded
OSPlatform=36
OSSDKVersion=658176
OSVersionMin=657152
Hash type=sha256 size=32
CandidateCDHash sha1=035adc859c622737e25074074b5ed8d813b59b40
CandidateCDHash sha256=e16f1aed764913ce31b645fbd5469b269664d7a2
Hash choices=sha1,sha256
Page size=4096
CDHash=e16f1aed764913ce31b645fbd5469b269664d7a2
Signature size=8936
Authority=Developer ID Application: EnterpriseDB Corporation (26QKX55P9K)
Authority=Developer ID Certification Authority
Authority=Apple Root CA
Timestamp=25 Oct 2016, 10:20:43
Info.plist entries=13
TeamIdentifier=26QKX55P9K
Sealed Resources version=2 rules=13 files=6298
Internal requirements count=1 size=180

If either give an error of any kind instead of output such as the above, then it's likely you have a corrupted download.

Thanks.

--
Dave Page
PostgreSQL Core Team
http://www.postgresql.org/

Re: pgAdmin 4 v1.1 for macOS

От
Dave Page
Дата:
Hi

On Thu, Nov 10, 2016 at 4:20 PM, Nicolas Jardot
<nicolas.jardot@dbi-services.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



Re: pgAdmin 4 v1.1 for macOS

От
Nicolas Jardot
Дата:
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.jardot@dbi-services.com
www.dbi-services.com


From: "Dave Page" <dpage@pgadmin.org>
To: "Nicolas Jardot" <nicolas.jardot@dbi-services.com>
Cc: "pgAdmin Support" <pgadmin-support@postgresql.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.jardot@dbi-services.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