Thread: pgAdmin 3.0 builds

The pgAdmin 3.0 builds are at https://developer.pgadmin.org/~dpage/v3.0/.

Barring any show-stopper issues, these are what will be released on Thursday.

As a reminder to packagers:

- This release removes dependencies on QtWebKit and/or QtWebEngine, and uses the users default browser instead.

- Gnome 3.26 or above will require the TopIcons Plus extension to be installed (or an equivalent). Ubuntu already seems to have this, per my testing. Fedora does not.

A future release will resolve this last issue one way or another, but that's a lot of work.

Thanks.

--

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

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

Hi Dave,

On Tue, Apr 10, 2018 at 4:21 PM, Dave Page <dpage@pgadmin.org> wrote:

The pgAdmin 3.0 builds are at https://developer.pgadmin.org/~dpage/v3.0/.

Barring any show-stopper issues, these are what will be released on Thursday.

As a reminder to packagers:

- This release removes dependencies on QtWebKit and/or QtWebEngine, and uses the users default browser instead.

Will take care of this.

 

- Gnome 3.26 or above will require the TopIcons Plus extension to be installed (or an equivalent). Ubuntu already seems to have this, per my testing. Fedora does not.

Are you expecting the pgAdmin package should install this extension if the desktop session is GNOME && it's version is >=3.26? 

Hi Dave,

I am still able to reproduce pgadmin4 crash issue on Windows 07 64 and Windows 2012 R2 64 on fresh VMs:

https://redmine.postgresql.org/issues/3227

Yes Akshay is not able to reproduce this issue on VMWare Fusion 6.0.6 while Khushboo is facing same issue on Windows 07 64.

I am using VMware Fusion 10 version and facing issue on Windows 2012 and Windows 07 64 bit.

Kindly suggest, how i can proceed further on this, should we document this?

On Tue, Apr 10, 2018 at 4:55 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 12:54 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi Dave,

I am still able to reproduce pgadmin4 crash issue on Windows 07 64 and Windows 2012 R2 64 on fresh VMs:

https://redmine.postgresql.org/issues/3227

Did you ever correlate it to VMware versions as I asked last week? 

--

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

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

--

Fahar Abbas

QMG

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com

On Tue, Apr 10, 2018 at 1:02 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Yes Akshay is not able to reproduce this issue on VMWare Fusion 6.0.6 while Khushboo is facing same issue on Windows 07 64.

I am using VMware Fusion 10 version and facing issue on Windows 2012 and Windows 07 64 bit.

I also cannot reproduce it in Windows 10, Windows 7 or Windows 2008r2 on VMware Fusion 8.5.10.

Can anyone else test on Windows please?

 

Kindly suggest, how i can proceed further on this, should we document this?

Ignore it for now. I'm far from convinced that it's not something odd with your VMs.

 

On Tue, Apr 10, 2018 at 4:55 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 12:54 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi Dave,

I am still able to reproduce pgadmin4 crash issue on Windows 07 64 and Windows 2012 R2 64 on fresh VMs:

https://redmine.postgresql.org/issues/3227

Did you ever correlate it to VMware versions as I asked last week? 

--

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

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

--

Fahar Abbas

QMG

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com

--

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

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

Hi,

On Tue, Apr 10, 2018 at 5:44 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 1:02 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Yes Akshay is not able to reproduce this issue on VMWare Fusion 6.0.6 while Khushboo is facing same issue on Windows 07 64.

I am using VMware Fusion 10 version and facing issue on Windows 2012 and Windows 07 64 bit.

I also cannot reproduce it in Windows 10, Windows 7 or Windows 2008r2 on VMware Fusion 8.5.10.

Can anyone else test on Windows please?

 

Working fine on my windows 10.

 

Kindly suggest, how i can proceed further on this, should we document this?

Ignore it for now. I'm far from convinced that it's not something odd with your VMs.

 

On Tue, Apr 10, 2018 at 4:55 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 12:54 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi Dave,

I am still able to reproduce pgadmin4 crash issue on Windows 07 64 and Windows 2012 R2 64 on fresh VMs:

https://redmine.postgresql.org/issues/3227

Did you ever correlate it to VMware versions as I asked last week? 

--

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

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

--

Fahar Abbas

QMG

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com

--

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

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

Hi Neel,

On Tue, Apr 10, 2018 at 5:43 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:

Hi,

On Tue, Apr 10, 2018 at 5:44 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 1:02 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Yes Akshay is not able to reproduce this issue on VMWare Fusion 6.0.6 while Khushboo is facing same issue on Windows 07 64.

I am using VMware Fusion 10 version and facing issue on Windows 2012 and Windows 07 64 bit.

I also cannot reproduce it in Windows 10, Windows 7 or Windows 2008r2 on VMware Fusion 8.5.10.

Can anyone else test on Windows please?

 

Working fine on my windows 10.

This issue is not reproducible on Windows 10, can you please check this on fresh VM of windows 2012 R2 64 and Windows 07 64 bit?

 

Kindly suggest, how i can proceed further on this, should we document this?

Ignore it for now. I'm far from convinced that it's not something odd with your VMs.

 

On Tue, Apr 10, 2018 at 4:55 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 12:54 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi Dave,

I am still able to reproduce pgadmin4 crash issue on Windows 07 64 and Windows 2012 R2 64 on fresh VMs:

https://redmine.postgresql.org/issues/3227

Did you ever correlate it to VMware versions as I asked last week? 

--

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

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

--

Fahar Abbas

QMG

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com

--

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

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

--

Fahar Abbas

QMG

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com

On Tue, Apr 10, 2018 at 6:15 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi Neel,

On Tue, Apr 10, 2018 at 5:43 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:

Hi,

On Tue, Apr 10, 2018 at 5:44 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 1:02 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Yes Akshay is not able to reproduce this issue on VMWare Fusion 6.0.6 while Khushboo is facing same issue on Windows 07 64.

I am using VMware Fusion 10 version and facing issue on Windows 2012 and Windows 07 64 bit.

I also cannot reproduce it in Windows 10, Windows 7 or Windows 2008r2 on VMware Fusion 8.5.10.

Can anyone else test on Windows please?

 

Working fine on my windows 10.

This issue is not reproducible on Windows 10, can you please check this on fresh VM of windows 2012 R2 64 and Windows 07 64 bit?

As usual not working for me on Windows 7 64 bit.  

On Tue, Apr 10, 2018 at 2:36 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

On Tue, Apr 10, 2018 at 6:15 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi Neel,

On Tue, Apr 10, 2018 at 5:43 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:

Hi,

On Tue, Apr 10, 2018 at 5:44 PM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 10, 2018 at 1:02 PM, Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Yes Akshay is not able to reproduce this issue on VMWare Fusion 6.0.6 while Khushboo is facing same issue on Windows 07 64.

I am using VMware Fusion 10 version and facing issue on Windows 2012 and Windows 07 64 bit.

I also cannot reproduce it in Windows 10, Windows 7 or Windows 2008r2 on VMware Fusion 8.5.10.

Can anyone else test on Windows please?

 

Working fine on my windows 10.

This issue is not reproducible on Windows 10, can you please check this on fresh VM of windows 2012 R2 64 and Windows 07 64 bit?

As usual not working for me on Windows 7 64 bit.  

I downloaded fresh ISOs of Windows 7 64bit and Windows 2012r2 64bit from MSDN, and installed them both in VMware Fusion 8.5.10. Each had 4GB RAM and 2 CPU cores assigned, otherwise default configs. I did not use Easy Install, to ensure that no VMware Tools got installed (thus leaving Windows completely clean).

- On Windows 7, IE crashed when loading pgAdmin. No great surprise - that version is very old and won't work anyway. Installed Chrome and all is good.

- On Windows 2012r2, IE didn't crash, but as expected couldn't display pgAdmin anyway. Installed Chrome and all is good.

 

--

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

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

Hi,

On Wed, 2018-04-11 at 09:17 +0100, Dave Page wrote:
> Nice work Fahar - I can reproduce the problem now!

Will we still release tomorrow? I also need some time to find a solution for
the setuptools issue on RHEL 7 and RHEL 6.

New builds are at https://developer.pgadmin.org/~dpage/v3.0-2/.

These fix the Windows crash that Fahar found (which happened if the user had a space in their usename), and fix password encryption/decryption under Python 3. 

Apologies for the inconvenience again. I still hope to release tomorrow, but let me know if that's not enough time and I can do Friday instead.

On Wed, Apr 11, 2018 at 1:39 PM, Dave Page <dpage@pgadmin.org> wrote:

All,

As you've probably seen, there were show-stopper issues with these builds unfortunately. I'm just testing the last fix, and will create new builds ASAP and follow up here.

Apologies for the inconvenience.

On Tue, Apr 10, 2018 at 11:51 AM, Dave Page <dpage@pgadmin.org> wrote:

The pgAdmin 3.0 builds are at https://developer.pgadmin.org/~dpage/v3.0/.

Barring any show-stopper issues, these are what will be released on Thursday.

As a reminder to packagers:

- This release removes dependencies on QtWebKit and/or QtWebEngine, and uses the users default browser instead.

- Gnome 3.26 or above will require the TopIcons Plus extension to be installed (or an equivalent). Ubuntu already seems to have this, per my testing. Fedora does not.

A future release will resolve this last issue one way or another, but that's a lot of work.

Thanks.

--

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

Re: Dave Page 2018-04-11 <CA+OCxoxVsHpmYz0rXAq+E5+3GXoHW0oiTv-ha4_ssn+23A0D3w@mail.gmail.com>
> New builds are at https://developer.pgadmin.org/~dpage/v3.0-2/.
>
> These fix the Windows crash that Fahar found (which happened if the user
> had a space in their usename), and fix password encryption/decryption under
> Python 3.
>
> Apologies for the inconvenience again. I still hope to release tomorrow,
> but let me know if that's not enough time and I can do Friday instead.

I won't be able to create the Debian packages this week because I'm at
pgconf.de.

> >> - This release removes dependencies on QtWebKit and/or QtWebEngine, and
> >> uses the users default browser instead.

This would need more testing anyway.

> >> - Gnome 3.26 or above will require the TopIcons Plus extension to be
> >> installed (or an equivalent). Ubuntu already seems to have this, per my
> >> testing. Fedora does not.

Hmm. This seems to be very desktop specific. What if the user isn't
using Gnome at all?

Hi Dave,

Did you remove the folder with the builds?

What is the git SHA from which the release is going to be created from?

Thanks

Joao

On Thu, Apr 12, 2018 at 4:08 AM Dave Page <dpage@pgadmin.org> wrote:

Hi

On Wed, Apr 11, 2018 at 6:08 PM, Christoph Berg <myon@debian.org> wrote:

Re: Dave Page 2018-04-11 <CA+OCxoxVsHpmYz0rXAq+E5+3GXoHW0oiTv-ha4_ssn+23A0D3w@mail.gmail.com>
> New builds are at https://developer.pgadmin.org/~dpage/v3.0-2/.
>
> These fix the Windows crash that Fahar found (which happened if the user
> had a space in their usename), and fix password encryption/decryption under
> Python 3.
>
> Apologies for the inconvenience again. I still hope to release tomorrow,
> but let me know if that's not enough time and I can do Friday instead.

I won't be able to create the Debian packages this week because I'm at
pgconf.de.

No problem.

 

> >> - This release removes dependencies on QtWebKit and/or QtWebEngine, and
> >> uses the users default browser instead.

This would need more testing anyway.

Should be pretty straightforward - in RPM terms it's a one-line change to remove a "Requires" line from the spec file. Updates to the other dependency packages will almost certainly take a lot more time unfortunately.

 

> >> - Gnome 3.26 or above will require the TopIcons Plus extension to be
> >> installed (or an equivalent). Ubuntu already seems to have this, per my
> >> testing. Fedora does not.

Hmm. This seems to be very desktop specific. What if the user isn't
using Gnome at all?

From my research, Gnome seems to be the only window manager where this is an issue (it seems to be quite a controversial change). We will be working on a better, more permanent solution in the future, however that's a lot of effort, and not something we could hold up 3.0 for.

Thanks. 

--

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

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

Re: Dave Page 2018-04-16 <CA+OCxoxQdTWbGYNjEd2dRePuwWzMSQw4ynfuJ4PfCvdB=7EwNA@mail.gmail.com>
> > The python part is causing headaches - the move from flask-babel to
> > flask-babelex is hurting because that's not available in Debian, and
> > the move as such is controversial:
> > https://github.com/mattupstate/flask-security/issues/715
>
> Hmm, we had to update as flask_babel isn’t working with modern versions of
> Babel.
>
> > At the moment this looks like a huge time sink to package.
>
> Can flask_babelex be built as a private package and installed in the
> pgAdmin web/ directory? That’s what Devrim does with a bunch of the dips
> for the RPMs.

That part turned out to be easier than I had thought. I had already
packaged babelex because it's a dependency of flask-security 3.0.0,
but never uploaded it because flask-security 1.7.5 seemed good enough.
Done now.

flask-security 3.0.0 has the additional problem that it wants
python-speaklater, but that seems to be dead upstream and got removed
from Debian years (?) ago, so I think we'll stay with 1.7.5 for now.

Packages for pgadmin4 3.0 will appear on the mirrors in about one hour.

Hi, 

On Mac Sierra (10.12.5), v3 doesn't even launch, unless I happen to have Chrome open (my default browser), and then it launches in browser mode. Is this what's supposed to happen with the new version?

Ok, interesting, that didn't make it to the notable section of the release notes (https://www.pgadmin.org/), I'd say rather that's rather notable.

Not that I know it's supposed to be opening in browser, I can see that it isn't opening because the pgadmin process is still running, even though I closed the chrome tab. But since there's no application process present, I see no way to quit the application except by killing the process manually....

On Tue, Apr 17, 2018 at 11:29 AM, Dave Page <dpage@pgadmin.org> wrote:

On Tue, Apr 17, 2018 at 3:58 PM, Chris Marx <chris@zevross.com> wrote:

Hi, 

On Mac Sierra (10.12.5), v3 doesn't even launch, unless I happen to have Chrome open (my default browser), and then it launches in browser mode. Is this what's supposed to happen with the new version?

It's supposed to launch in the browser. My work machines are running 10.12.5, and it works on them. Can you see anything in the system logs etc. that might indicate why it's not starting the browser?

 

--

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

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

--

-- 

Chris Marx

ZevRoss - Know Your Data

Data Science & Spatial Analysis

New website: www.zevross.com

Ithaca, NY

Hi Christoph,

On Tue, 2018-04-17 at 16:23 +0200, Christoph Berg wrote:
> Packages for pgadmin4 3.0 will appear on the mirrors in about one hour.

Great!

Just a FYI -- I am about add two new subpackages to pgAdmin4 RPMs:

- pgadmin4-desktop-common
- pgadmin4-desktop-gnome

I aimed to split desktop components into their subpackages, in order to:

* For "server-only" users, do not require qt libraries.
* For desktop users: Require topicons only on GNOME

Just in case you want to do the same.

Regards,

-
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Devrim Gündüz 2018-04-17 <1523980128.1745.33.camel@gunduz.org>
> Just a FYI -- I am about add two new subpackages to pgAdmin4 RPMs:
>
> - pgadmin4-desktop-common
> - pgadmin4-desktop-gnome
>
> I aimed to split desktop components into their subpackages, in order to:
>
> * For "server-only" users, do not require qt libraries.
> * For desktop users: Require topicons only on GNOME

I have yet to understand why a Qt application needs some gnome package
installed. Until someone can point out a problem with not doing
anything special on the distributions we support, I'll just ignore the
problem.