Обсуждение: Re: pgAdmin 4 v1.1 for macOS
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
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 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.
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
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
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
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
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