Re: [pgadmin-support] Final pgAdmin III - v1.22.2 Released

[Dave Page]

On Sun, Nov 20, 2016 at 1:49 AM, Jeff Janes  wrote:
> On Thu, Nov 10, 2016 at 7:55 AM, Dave Page  wrote:
>>
>> I've just pushed a final wrap-up build of pgAdmin III to the download
>> site in source, Windows and Mac OS X formats. You can download it from
>> here:
>>
>> https://www.postgresql.org/ftp/pgadmin3/release/v1.22.2/
>
>
>
> The above download is not listed on the page:
>
> https://www.pgadmin.org/download/windows.php

Oops, I missed all the links :-/. I've pushed a fix now, so they
should show up within an hour.

Thanks.

-- 
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

Re: [pgadmin-support] Bug report

[Dave Page]

Hi

On Sat, Nov 19, 2016 at 7:32 PM, Robert van Geel  wrote:

> Hi,
>
> I have an issue getting pgadmin going.
>
> Version: latest (4.1.1)
> Platform: windows 10
> Configuration: out of the box, just install -> start -> symptom experienced
> Symptom: the screen looks off, like a web page with no css applied or
> something, I added a screenshot below
> Additional information of interest: I installed it as desktop app,
> de-installed, re-installed to the same effect
> I also installed the python package and ran the tool in the browser on
> http://localhost:5050/ there I get a login screen which also seems off. I
> can see in network that browser.css gets a HTTP 303 found with a location
> of http://localhost:5050/login?next=%2Fbrowser%2Fbrowser.css.  When I
> type that in my address bar I get the login screen again. This problem
> occurs in all browsers (Chrome, IE, FF).
>

We've had a couple of reports of this, but have been unable to reproduce
it. This is the first time I've heard of it happening in a server mode
setup though.

Can you please try the following for me?

1) Create/edit a config_local.py file alongside config.py in the python
package installation directory, and include the following:

SERVER_MODE = False
DEBUG = True
CONSOLE_LOG_LEVEL = DEBUG
FILE_LOG_LEVEL = DEBUG

2) Remove %APPDATA%\pgadmin if present.

3) Start pgAdmin from the command line.

4) Clear your browser cache of anything from localhost:5050 and open the
Developer Tools

5) Navigate to http://localhost:5050/

6) Send a copy of the pgAdmin log file and the Network tab from the
Developer Tools (showing all the requests and status codes etc).

Note that setting SERVER_MODE to false is intentional here - pgAdmin will
still run in the browser, but that will disable authentication.

Thanks!


>
> Thank you for your attention.
>
>
>


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

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

Re: [pgadmin-support] Bug report

[Robert van Geel]

Dave,

I'll send you the zip in a private mail, I'm not sure if the log files 
are relevant to other people. I patched the python code to serve 
browser.css without authentication in an attempt to solve this myself, 
but I'm still experiencing the same.


If you want I'm happy to provide you with a teamviewer session.

More information:

I tried another machine, also windows 10, there it works ok, in all 
browsers.


Robert


On 21-11-2016 10:57, Dave Page wrote:

Hi

On Sat, Nov 19, 2016 at 7:32 PM, Robert van Geel > wrote:


Hi,

I have an issue getting pgadmin going.

Version: latest (4.1.1)
Platform: windows 10
Configuration: out of the box, just install -> start -> symptom
experienced
Symptom: the screen looks off, like a web page with no css applied
or something, I added a screenshot below
Additional information of interest: I installed it as desktop app,
de-installed, re-installed to the same effect
I also installed the python package and ran the tool in the
browser on http://localhost:5050/ there I get a login screen which
also seems off. I can see in network that browser.css gets a HTTP
303 found with a location of
http://localhost:5050/login?next=%2Fbrowser%2Fbrowser.css
. When
I type that in my address bar I get the login screen again. This
problem occurs in all browsers (Chrome, IE, FF). 

We've had a couple of reports of this, but have been unable to 
reproduce it. This is the first time I've heard of it happening in a 
server mode setup though.

Can you please try the following for me?
1) Create/edit a config_local.py file alongside config.py in the 
python package installation directory, and include the following:

SERVER_MODE = False
DEBUG = True
CONSOLE_LOG_LEVEL = DEBUG
FILE_LOG_LEVEL = DEBUG
2) Remove %APPDATA%\pgadmin if present.
3) Start pgAdmin from the command line.
4) Clear your browser cache of anything from localhost:5050 and open 
the Developer Tools

5) Navigate to http://localhost:5050/
6) Send a copy of the pgAdmin log file and the Network tab from the 
Developer Tools (showing all the requests and status codes etc).
Note that setting SERVER_MODE to false is intentional here - pgAdmin 
will still run in the browser, but that will disable authentication.

Thanks!

Thank you for your attention.

--
Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake 
EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL 
Company

Re: [pgadmin-support] 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.jar...@dbi-services.com 
www.dbi-services.com 


From: "Dave Page"  
To: "Nicolas Jardot"  
Cc: "pgAdmin Support"  
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 
 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-support] Bug report

[Robert van Geel]

Dave, I've added the main list again in the cc of this mail so people 
finding this post will also know the solution.


Your comment:

>Can you please run the registry editor on Windows, and check the value 
of the following key?

>
>HKEY_CLASSES_ROOT\.css\Content Type
>
>It should be "text/css" (without the quotes).

Indeed, it was text/plain. I changed it to text/css, then restarted 
pgAdmin4. Lo and behold, that helped !


Weird, I vaguely remember Werkzeug (or Flask?) having its own hardcoded 
mapping for mime-types but aparantly they get read from here.


You're class!

Robert


On 21-11-2016 10:57, Dave Page wrote:

Hi

On Sat, Nov 19, 2016 at 7:32 PM, Robert van Geel > wrote:


Hi,

I have an issue getting pgadmin going.

Version: latest (4.1.1)
Platform: windows 10
Configuration: out of the box, just install -> start -> symptom
experienced
Symptom: the screen looks off, like a web page with no css applied
or something, I added a screenshot below
Additional information of interest: I installed it as desktop app,
de-installed, re-installed to the same effect
I also installed the python package and ran the tool in the
browser on http://localhost:5050/ there I get a login screen which
also seems off. I can see in network that browser.css gets a HTTP
303 found with a location of
http://localhost:5050/login?next=%2Fbrowser%2Fbrowser.css
. When
I type that in my address bar I get the login screen again. This
problem occurs in all browsers (Chrome, IE, FF). 

We've had a couple of reports of this, but have been unable to 
reproduce it. This is the first time I've heard of it happening in a 
server mode setup though.

Can you please try the following for me?
1) Create/edit a config_local.py file alongside config.py in the 
python package installation directory, and include the following:

SERVER_MODE = False
DEBUG = True
CONSOLE_LOG_LEVEL = DEBUG
FILE_LOG_LEVEL = DEBUG
2) Remove %APPDATA%\pgadmin if present.
3) Start pgAdmin from the command line.
4) Clear your browser cache of anything from localhost:5050 and open 
the Developer Tools

5) Navigate to http://localhost:5050/
6) Send a copy of the pgAdmin log file and the Network tab from the 
Developer Tools (showing all the requests and status codes etc).
Note that setting SERVER_MODE to false is intentional here - pgAdmin 
will still run in the browser, but that will disable authentication.

Thanks!

Thank you for your attention.

--
Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake 
EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL 
Company

Re: [pgadmin-support] Bug report

[Dave Page]

Hi

On Mon, Nov 21, 2016 at 3:46 PM, Robert van Geel  wrote:

> Dave, I've added the main list again in the cc of this mail so people
> finding this post will also know the solution.
>
> Your comment:
> >Can you please run the registry editor on Windows, and check the value of
> the following key?
> >
> >HKEY_CLASSES_ROOT\.css\Content Type
> >
> >It should be "text/css" (without the quotes).
>
> Indeed, it was text/plain. I changed it to text/css, then restarted
> pgAdmin4. Lo and behold, that helped !
>

Awesome :-)

> Weird, I vaguely remember Werkzeug (or Flask?) having its own hardcoded
> mapping for mime-types but aparantly they get read from here.
>
I believe it does for non-Windows platforms.

> You're class!
>
:-). Thanks for helping figure this one out!


> Robert
>
> On 21-11-2016 10:57, Dave Page wrote:
>
> Hi
>
> On Sat, Nov 19, 2016 at 7:32 PM, Robert van Geel 
> wrote:
>
>> Hi,
>>
>> I have an issue getting pgadmin going.
>>
>> Version: latest (4.1.1)
>> Platform: windows 10
>> Configuration: out of the box, just install -> start -> symptom
>> experienced
>> Symptom: the screen looks off, like a web page with no css applied or
>> something, I added a screenshot below
>> Additional information of interest: I installed it as desktop app,
>> de-installed, re-installed to the same effect
>> I also installed the python package and ran the tool in the browser on
>> http://localhost:5050/ there I get a login screen which also seems off.
>> I can see in network that browser.css gets a HTTP 303 found with a location
>> of http://localhost:5050/login?next=%2Fbrowser%2Fbrowser.css.  When I
>> type that in my address bar I get the login screen again. This problem
>> occurs in all browsers (Chrome, IE, FF).
>>
> We've had a couple of reports of this, but have been unable to reproduce
> it. This is the first time I've heard of it happening in a server mode
> setup though.
> Can you please try the following for me?
> 1) Create/edit a config_local.py file alongside config.py in the python
> package installation directory, and include the following:
> SERVER_MODE = False
> DEBUG = True
> CONSOLE_LOG_LEVEL = DEBUG
> FILE_LOG_LEVEL = DEBUG
> 2) Remove %APPDATA%\pgadmin if present.
> 3) Start pgAdmin from the command line.
> 4) Clear your browser cache of anything from localhost:5050 and open the
> Developer Tools
> 5) Navigate to http://localhost:5050/
> 6) Send a copy of the pgAdmin log file and the Network tab from the
> Developer Tools (showing all the requests and status codes etc).
> Note that setting SERVER_MODE to false is intentional here - pgAdmin will
> still run in the browser, but that will disable authentication.
> Thanks!
>
>
>> Thank you for your attention.
>>
> --
> 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