pgAdmin 4 commit: Add required HTMLmin version - the Flask-htmlmin pack

[Dave Page]

Add required HTMLmin version - the Flask-htmlmin package doesn't seem to pull 
in the right version.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=bb49d6929335977f7de3bcb12bbb2389352e94b0

Modified Files
--
requirements.txt | 1 +
1 file changed, 1 insertion(+)

Jenkins build is back to normal : pgadmin4-master-python26 #706

[pgAdmin 4 Jenkins]

See 

pgAdmin 4 commit: Fix typo

[Dave Page]

Fix typo

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=8f90b801bdfe7eda84c3cd194ff98c77309e91db

Modified Files
--
requirements.txt | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Build failed in Jenkins: pgadmin4-master-python33 #576

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Add required HTMLmin version - the Flask-htmlmin package doesn't 
seem to

--
Started by user Dave Page
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision bb49d6929335977f7de3bcb12bbb2389352e94b0 (origin/master)
Commit message: "Add required HTMLmin version - the Flask-htmlmin package 
doesn't seem to pull in the right version."
 > git config core.sparsecheckout # timeout=10
 > git checkout -f bb49d6929335977f7de3bcb12bbb2389352e94b0
 > git rev-list 0493b86d4d4e53e5bdfcb08c4b5eb771302a88a9 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.3

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python33] $ /bin/sh -xe /tmp/jenkins353921993913991164.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.3 virtual environment...

Using base prefix '/usr/local/python-3.3'
New python executable in 

Also creating executable in 

Installing setuptools, pip...done.
Running virtualenv with interpreter /usr/local/python-3.3/bin/python3
DEPRECATION: Python 3.3 supported has been deprecated and support for it will 
be dropped in the future. Please upgrade your Python.
Collecting wheel==0.29.0
  Using cached 
https://files.pythonhosted.org/packages/8a/e9/8468cd68b582b06ef554be0b96b59f59779627131aad48f8a5bce4b13450/wheel-0.29.0-py2.py3-none-any.whl
Installing collected packages: wheel
Successfully installed wheel-0.29.0
DEPRECATION: Python 3.3 supported has been deprecated and support for it will 
be dropped in the future. Please upgrade your Python.
Invalid requirement: 'htmlmin==0.1.12 python_version >= '2.7''
Traceback (most recent call last):
  File 
"
 line 93, in __init__
req = REQUIREMENT.parseString(requirement_string)
  File 
"
 line 1632, in parseString
raise exc
  File 
"
 line 1622, in parseString
loc, tokens = self._parse( instring, 0 )
  File 
"
 line 1379, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3395, in parseImpl
loc, exprtokens = e._parse( instring, loc, doActions )
  File 
"
 line 1383, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3183, in parseImpl
raise ParseException(instring, loc, self.errmsg, self)
pip._vendor.pyparsing.ParseException: Expected stringEnd (at char 32), (line:1, 
col:33)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File 
"
 line 252, in from_line
req = Requirement(req)
  File 
"

Build failed in Jenkins: pgadmin4-master-python27 #574

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Add required HTMLmin version - the Flask-htmlmin package doesn't 
seem to

--
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision bb49d6929335977f7de3bcb12bbb2389352e94b0 (origin/master)
Commit message: "Add required HTMLmin version - the Flask-htmlmin package 
doesn't seem to pull in the right version."
 > git config core.sparsecheckout # timeout=10
 > git checkout -f bb49d6929335977f7de3bcb12bbb2389352e94b0
 > git rev-list 0493b86d4d4e53e5bdfcb08c4b5eb771302a88a9 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=2.7

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python27] $ /bin/sh -xe /tmp/jenkins3988895377542599815.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 2.7 virtual environment...

New python executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-2.7/bin/python
Invalid requirement: 'htmlmin==0.1.12 python_version >= '2.7''
Traceback (most recent call last):
  File 
"
 line 252, in from_line
req = Requirement(req)
  File 
"
 line 97, in __init__
requirement_string[e.loc:e.loc + 8]))
InvalidRequirement: Invalid requirement, parse error at "u'python_v'"

ERROR: Failed to install the application requirements.
ERROR: Error detected when running the Python tests.
Build step 'Execute shell' marked build as failure

Build failed in Jenkins: pgadmin4-master-python26 #707

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Add required HTMLmin version - the Flask-htmlmin package doesn't 
seem to

--
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision bb49d6929335977f7de3bcb12bbb2389352e94b0 (origin/master)
Commit message: "Add required HTMLmin version - the Flask-htmlmin package 
doesn't seem to pull in the right version."
 > git config core.sparsecheckout # timeout=10
 > git checkout -f bb49d6929335977f7de3bcb12bbb2389352e94b0
 > git rev-list 0493b86d4d4e53e5bdfcb08c4b5eb771302a88a9 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=2.6

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python26] $ /bin/sh -xe /tmp/jenkins3865215013743178078.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 2.6 virtual environment...

New python executable in 

Installing setuptools, pip...done.
Running virtualenv with interpreter /usr/local/python-2.6/bin/python
DEPRECATION: Python 2.6 is no longer supported by the Python core team, please 
upgrade your Python. A future version of pip will drop support for Python 2.6
Collecting wheel==0.29.0
:339:
 SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name 
Indication) extension to TLS is not available on this platform. This may cause 
the server to present an incorrect TLS certificate, which can cause validation 
failures. You can upgrade to a newer version of Python to solve this. For more 
information, see 
https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
  SNIMissingWarning
:137:
 InsecurePlatformWarning: A true SSLContext object is not available. This 
prevents urllib3 from configuring SSL appropriately and may cause certain SSL 
connections to fail. You can upgrade to a newer version of Python to solve 
this. For more information, see 
https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
  InsecurePlatformWarning
  Using cached 
https://files.pythonhosted.org/packages/8a/e9/8468cd68b582b06ef554be0b96b59f59779627131aad48f8a5bce4b13450/wheel-0.29.0-py2.py3-none-any.whl
Collecting argparse; python_version == "2.6" (from wheel==0.29.0)
:137:
 InsecurePlatformWarning: A true SSLContext object is not available. This 
prevents urllib3 from configuring SSL appropriately and may cause certain SSL 
connections to fail. You can upgrade to a newer version of Python to solve 
this. For more information, see 
https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
  InsecurePlatformWarning
:137:
 InsecurePlatformWarning: A true SSLContext object is not available. This 
prevents urllib3 from configuring SSL appropriately and may cause certain SSL 
connections to fail. You can upgrade to a newer version of Python to solve 
this. For more information, see 
https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
  InsecurePlatformWarning
  Using cached 
https://files.pythonhosted.org/packages/f2/94/3af39d34be01a24a6e65433d19e107099374224905f1e0cc6bbe1fd22a2f/argparse-1.4.0-py2.py3-none-any.whl
Installing collected packages: argparse, wheel
Successfully installed argparse-1.4.0 wheel-0.29.0
You are using pip version 9.0.3, however version 10.0.0 is available.
You should consider upgrading via the 'pip install --upgrade pip' co

Build failed in Jenkins: pgadmin4-master-python34 #564

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Add required HTMLmin version - the Flask-htmlmin package doesn't 
seem to

--
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision bb49d6929335977f7de3bcb12bbb2389352e94b0 (origin/master)
Commit message: "Add required HTMLmin version - the Flask-htmlmin package 
doesn't seem to pull in the right version."
 > git config core.sparsecheckout # timeout=10
 > git checkout -f bb49d6929335977f7de3bcb12bbb2389352e94b0
 > git rev-list 0493b86d4d4e53e5bdfcb08c4b5eb771302a88a9 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.4

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python34] $ /bin/sh -xe /tmp/jenkins5443155667279219871.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.4 virtual environment...

Using base prefix '/usr/local/python-3.4'
New python executable in 

Also creating executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-3.4/bin/python3
Invalid requirement: 'htmlmin==0.1.12 python_version >= '2.7''
Traceback (most recent call last):
  File 
"
 line 93, in __init__
req = REQUIREMENT.parseString(requirement_string)
  File 
"
 line 1632, in parseString
raise exc
  File 
"
 line 1622, in parseString
loc, tokens = self._parse( instring, 0 )
  File 
"
 line 1379, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3395, in parseImpl
loc, exprtokens = e._parse( instring, loc, doActions )
  File 
"
 line 1383, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3183, in parseImpl
raise ParseException(instring, loc, self.errmsg, self)
pip._vendor.pyparsing.ParseException: Expected stringEnd (at char 32), (line:1, 
col:33)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File 
"
 line 252, in from_line
req = Requirement(req)
  File 
"
 line 97, in __init__
requirement_string[e.loc:e.loc + 8]))
pip._vendor.packaging.requirements.InvalidRequirement: Invalid requirement, 
parse error at "'python_v'"

ERROR: Failed to install the application requirements.
ERROR: Error detected when running the Python tests.
Build step 'Execute shell' marked build as failure

Jenkins build is back to normal : pgadmin4-master-python26 #708

[pgAdmin 4 Jenkins]

See 

Jenkins build is back to normal : pgadmin4-master-python36 #570

[pgAdmin 4 Jenkins]

See 

Jenkins build is back to normal : pgadmin4-master-python33 #577

[pgAdmin 4 Jenkins]

See 

Build failed in Jenkins: pgadmin4-master-python35 #573

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Add required HTMLmin version - the Flask-htmlmin package doesn't 
seem to

--
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision bb49d6929335977f7de3bcb12bbb2389352e94b0 (origin/master)
Commit message: "Add required HTMLmin version - the Flask-htmlmin package 
doesn't seem to pull in the right version."
 > git config core.sparsecheckout # timeout=10
 > git checkout -f bb49d6929335977f7de3bcb12bbb2389352e94b0
 > git rev-list 0493b86d4d4e53e5bdfcb08c4b5eb771302a88a9 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.5

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python35] $ /bin/sh -xe /tmp/jenkins6323068944916186106.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.5 virtual environment...

Using base prefix '/usr/local/python-3.5'
New python executable in 

Also creating executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-3.5/bin/python3
Invalid requirement: 'htmlmin==0.1.12 python_version >= '2.7''
Traceback (most recent call last):
  File 
"
 line 93, in __init__
req = REQUIREMENT.parseString(requirement_string)
  File 
"
 line 1632, in parseString
raise exc
  File 
"
 line 1622, in parseString
loc, tokens = self._parse( instring, 0 )
  File 
"
 line 1379, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3395, in parseImpl
loc, exprtokens = e._parse( instring, loc, doActions )
  File 
"
 line 1383, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3183, in parseImpl
raise ParseException(instring, loc, self.errmsg, self)
pip._vendor.pyparsing.ParseException: Expected stringEnd (at char 32), (line:1, 
col:33)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File 
"
 line 252, in from_line
req = Requirement(req)
  File 
"
 line 97, in __init__
requirement_string[e.loc:e.loc + 8]))
pip._vendor.packaging.requirements.InvalidRequirement: Invalid requirement, 
parse error at "'python_v'"

ERROR: Failed to install the application requirements.
ERROR: Error detected when running the Python tests.
Build step 'Execute shell' marked build as failure

Build failed in Jenkins: pgadmin4-master-python36 #569

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Add required HTMLmin version - the Flask-htmlmin package doesn't 
seem to

--
Started by user Dave Page
Started by an SCM change
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building in workspace 

 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url git://git.postgresql.org/git/pgadmin4.git # 
 > timeout=10
Cleaning workspace
 > git rev-parse --verify HEAD # timeout=10
Resetting working tree
 > git reset --hard # timeout=10
 > git clean -fdx # timeout=10
Fetching upstream changes from git://git.postgresql.org/git/pgadmin4.git
 > git --version # timeout=10
 > git fetch --tags --progress git://git.postgresql.org/git/pgadmin4.git 
 > +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision bb49d6929335977f7de3bcb12bbb2389352e94b0 (origin/master)
Commit message: "Add required HTMLmin version - the Flask-htmlmin package 
doesn't seem to pull in the right version."
 > git config core.sparsecheckout # timeout=10
 > git checkout -f bb49d6929335977f7de3bcb12bbb2389352e94b0
 > git rev-list 0493b86d4d4e53e5bdfcb08c4b5eb771302a88a9 # timeout=10
[EnvInject] - Executing scripts and injecting environment variables after the 
SCM step.
[EnvInject] - Injecting as environment variables the properties content 
PYTHON_VERSION=3.6

[EnvInject] - Variables injected successfully.
[pgadmin4-master-python36] $ /bin/sh -xe /tmp/jenkins607549499648778902.sh
+ 
EXECUTING: Create pgAdmin config

EXECUTING: Python tests

Creating Python 3.6 virtual environment...

Using base prefix '/usr/local/python-3.6'
New python executable in 

Also creating executable in 

Installing setuptools, pip, wheel...done.
Running virtualenv with interpreter /usr/local/python-3.6/bin/python3
Invalid requirement: 'htmlmin==0.1.12 python_version >= '2.7''
Traceback (most recent call last):
  File 
"
 line 93, in __init__
req = REQUIREMENT.parseString(requirement_string)
  File 
"
 line 1632, in parseString
raise exc
  File 
"
 line 1622, in parseString
loc, tokens = self._parse( instring, 0 )
  File 
"
 line 1379, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3395, in parseImpl
loc, exprtokens = e._parse( instring, loc, doActions )
  File 
"
 line 1383, in _parseNoCache
loc,tokens = self.parseImpl( instring, preloc, doActions )
  File 
"
 line 3183, in parseImpl
raise ParseException(instring, loc, self.errmsg, self)
pip._vendor.pyparsing.ParseException: Expected stringEnd (at char 32), (line:1, 
col:33)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File 
"
 line 252, in from_line
req = Requirement(req)
  File 
"
 line 97, in __init__
requirement_string[e.loc:e.loc + 8]))
pip._vendor.packaging.requirements.InvalidRequirement: Invalid requirement, 
parse error at "'python_v'"

ERROR: Failed to install the application requirements.
ERROR: Error detected when running the Python tests.
Build step 'Execute shell' marked build as failure

Jenkins build is back to normal : pgadmin4-master-python34 #565

[pgAdmin 4 Jenkins]

See 

Jenkins build is back to normal : pgadmin4-master-python27 #575

[pgAdmin 4 Jenkins]

See 

Jenkins build is back to normal : pgadmin4-master-python35 #574

[pgAdmin 4 Jenkins]

See 

Re: pgAdmin 3.0 builds

[Christoph Berg]

Re: Dave Page 2018-04-16 

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

Christoph

Re: pgAdmin 3.0 builds

[Dave Page]

On Tue, Apr 17, 2018 at 3:23 PM, Christoph Berg  wrote:

> Re: Dave Page 2018-04-16  7e...@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.
>

\o/

Many thanks!

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

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

Re: pgAdmin 3.0 builds

[Chris Marx]

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?

Chris-

On Tue, Apr 17, 2018 at 10:25 AM, Dave Page  wrote:

>
>
> On Tue, Apr 17, 2018 at 3:23 PM, Christoph Berg  wrote:
>
>> Re: Dave Page 2018-04-16 > 7e...@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.
>>
>
> \o/
>
> Many thanks!
>
> --
> 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

Re: pgAdmin 3.0 builds

[Dave Page]

On Tue, Apr 17, 2018 at 3:58 PM, Chris Marx  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

Re: pgAdmin 3.0 builds

[Chris Marx]

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

>
>
> On Tue, Apr 17, 2018 at 3:58 PM, Chris Marx  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

Re: pgAdmin 3.0 builds

[Dave Page]

On Tue, Apr 17, 2018 at 4:40 PM, Chris Marx  wrote:

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

It's the very first item:


   - The desktop runtime now runs as a system tray application and utilises
   the browser on the system to display pgAdmin. This resolves numerous bugs
   and issues caused by QtWebKit/QtWebEngine.



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

Click the icon in the system tray and you can configure, exit or open new
windows from there.


>
> On Tue, Apr 17, 2018 at 11:29 AM, Dave Page  wrote:
>
>>
>>
>> On Tue, Apr 17, 2018 at 3:58 PM, Chris Marx  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
>
>


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

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

Re: pgAdmin 3.0 builds

[Devrim Gündüz]

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

signature.asc
Description: This is a digitally signed message part

Re: pgAdmin 3.0 builds

[Chris Marx]

@dpage Ok, wow, I did read that, but I didn't read it as "only utilizes"
the browser, this is a huge change for everyone in my office, and no one
caught that message in the release notes. Also, on a mac, it's not called
the "system tray", which probably adds to the confusion for all us mac
users here, the icon shows up in the "menu bar" - https://support.apple.com/
kb/PH25077?locale=en_US

On Tue, Apr 17, 2018 at 11:48 AM, Devrim Gündüz  wrote:

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



-- 
-- 
Chris Marx
ZevRoss - Know Your Data
Data Science & Spatial Analysis
New website: www.zevross.com
Ithaca, NY

GSoC-Improvements in my Ideas for Geospatial Query Viewer for pgAdmin4

[Rahul Soshte]

Hi,

I had earlier proposed to use 'Layers' functionality where a query
containing PostGIS Geometry/Geography will be converted to a Seperate Layer
for the MapView while building a GeoSpatial Query Viewer.

My Proposal Link,


https://docs.google.com/document/d/1WN3FPpLudNNXLWQgGlP91yDAMe7D0DC8gTBhdyrI_aw/edit

I recently came across a Redmine ticket whose link is given as follows.
https://redmine.postgresql.org/issues/1407

Which is a  Feature #1407 which was added about 2 years ago
Which mentions
1)Switching between the resultset grid and the MapView.
2)A parser in Javascript
3)Using OpenLayers

Considering the above points I would like to Improve the idea further by
not going ahead with the "Layer Functionality" but with the following
procedure and thus decreasing the ambiguity in the way of achieving  the
goal of the project,

1) Addition of a Panel for MapView in the resultset grid



2) pgAdmin4 uses a library called jQuery-contextMenu.
For rendering a geometry column user will able select the column,User will
open a contextMenu like in this image.


He will have option of 'Render in MapView'
Now when we switch to the MapView Panel we can see the ouput.

Also in the MapView Panel we can give the options of selecting the
particular geometry/geography columns the User want to Render.

3)After deciding on the columns to render, the data will be converted to
GeoJSON format by using JavaScript and Ajax.

This data will be displayed using OpenLayers in the MapView Panel.

This I feel is doable , achievable within a span of 3 month(Refer GSoC
Timeline) along with Testing of the code.

Regards,
Rahul Soshte ( Hunter )

Re: GSoC-Improvements in my Ideas for Geospatial Query Viewer for pgAdmin4

[Victoria Rautenbach]

Dear Rahul

Thank you for the email and looking into the project a bit more. As you
know, the projects proposals are still being reviewed and the results will
be published by Google on 23 April. Thanks again for submitting a project
proposal and the enthusiasm.

Regards
Victoria



On Tue, Apr 17, 2018 at 6:28 PM, Rahul Soshte 
wrote:

> Hi,
>
> I had earlier proposed to use 'Layers' functionality where a query
> containing PostGIS Geometry/Geography will be converted to a Seperate Layer
> for the MapView while building a GeoSpatial Query Viewer.
>
> My Proposal Link,
>
> 
> https://docs.google.com/document/d/1WN3FPpLudNNXLWQgGlP91yDAMe7D0
> DC8gTBhdyrI_aw/edit
>
> I recently came across a Redmine ticket whose link is given as follows.
> https://redmine.postgresql.org/issues/1407
>
> Which is a  Feature #1407 which was added about 2 years ago
> Which mentions
> 1)Switching between the resultset grid and the MapView.
> 2)A parser in Javascript
> 3)Using OpenLayers
>
> Considering the above points I would like to Improve the idea further by
> not going ahead with the "Layer Functionality" but with the following
> procedure and thus decreasing the ambiguity in the way of achieving  the
> goal of the project,
>
> 1) Addition of a Panel for MapView in the resultset grid
>
>
>
> 2) pgAdmin4 uses a library called jQuery-contextMenu.
> For rendering a geometry column user will able select the column,User will
> open a contextMenu like in this image.
>
>
> He will have option of 'Render in MapView'
> Now when we switch to the MapView Panel we can see the ouput.
>
> Also in the MapView Panel we can give the options of selecting the
> particular geometry/geography columns the User want to Render.
>
> 3)After deciding on the columns to render, the data will be converted to
> GeoJSON format by using JavaScript and Ajax.
>
> This data will be displayed using OpenLayers in the MapView Panel.
>
> This I feel is doable , achievable within a span of 3 month(Refer GSoC
> Timeline) along with Testing of the code.
>
> Regards,
> Rahul Soshte ( Hunter )
>
>
>
>