Re: pgadmin4 in Cloud Foundry

[Tom C]

Hello,

I was able to successfully load pgadmin4 into CF with a different docker
image.

docker image: fenglc/pgadmin4

-Tom

On Thu, Apr 19, 2018 at 9:52 PM, Tom C  wrote:

> Hello,
>
> I am able to run pgadmin4 in a Docker Container. I have been trying to
> take the same docker image and run it as a Cloud Foundry Docker enabled
> app. My problem is this Docker image requires certificates and private key
> mapped to a Docker volume as explained here
> https://hub.docker.com/r/dpage/pgadmin4/
>
> I can't pass these files into the Docker container when it's hosted in
> Cloud Foundry. Is there a way to pass the cert and key in as environment
> variables instead?
>
> Thanks.
>
> -Tom
>
>

Re: pgadmin4.3 - login failure

[Cherio]

Please take a look at the issue I filed a few days ago labelled "v4 3.0
connection issues, notices is readonly", it is related
https://www.postgresql.org/message-id/CAKHqFkK%3DAm5JBrdxmaFW92PQAf0m5QNsT2TGj7EJ2fBRgfAHrA%40mail.gmail.com

On Fri, Apr 20, 2018 at 7:59 AM frankgard <
frank.von.postgresql@familie-gard.de> wrote:

> Hi Tony,
>
> according to  this Stackoverflow post
> <
> https://stackoverflow.com/questions/49919149/unable-to-connect-to-postgresql-with-pgadmin4-readonly-attribute-error>
>
> , the error seems to be caused by a too old psycopg2 library. Perhaps you
> can upgrade to v2.7, or just comment out line 313 of
> /usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py as some
> kind of "dirty hack", but be aware that I don't know the "deeper
> consequences" of doing so.
>
> Hope this helps.
>
> Cheers,
> Frank.
>
>
>
> --
> Sent from:
> http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html
>
>

Re: pgadmin4.3 - login failure

[Dave Page]

On Fri, Apr 20, 2018 at 1:13 PM, Dave Page  wrote:

> I've asked the Debian/Ubuntu package maintainer to look into this.
>

And he tells me that updated packages will be published to the mirrors
shortly.


>
> On Fri, Apr 20, 2018 at 10:23 AM, frankgard  familie-gard.de> wrote:
>
>> Hi Tony,
>>
>> according to  this Stackoverflow post
>> > ect-to-postgresql-with-pgadmin4-readonly-attribute-error>
>> , the error seems to be caused by a too old psycopg2 library. Perhaps you
>> can upgrade to v2.7, or just comment out line 313 of
>> /usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py as
>> some
>> kind of "dirty hack", but be aware that I don't know the "deeper
>> consequences" of doing so.
>>
>> Hope this helps.
>>
>> Cheers,
>> Frank.
>>
>>
>>
>> --
>> Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support
>> -f2191615.html
>>
>>
>
>
> --
> 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: pgadmin4 in Cloud Foundry

[Robert Eckhardt]

Tom,

Are you just trying to get something up on CF or are you trying to make it
a 'proper' CF app?

Currently we build pgAdmin in CF multiple times a day, however, we aren't
building the proper server application we are only building the desktop app
in the cloud. We'd be happy to show you what we are doing if you'd like to
play around with it and perhaps make a more proper deployment.

If you're just looking for something that works you can throw up a docker
container and run pgAdmin in that.

-- Rob

On Fri, Apr 20, 2018 at 6:04 AM, Dave Cramer  wrote:

>
>
> On 20 April 2018 at 06:02, Murtuza Zabuawala  enterprisedb.com> wrote:
>
>> Hi,
>>
>> Right now it is not possible to pass cert and key via variables.
>> Please create a feature request for the same HERE
>> 
>>
>>
> Alternatively you can just use.
>
> https://github.com/CrunchyData/crunchy-containers/blob/master/
> centos7/10/Dockerfile.pgadmin4.centos7
>
>
> Dave Cramer
>

Re: pgadmin4.3 - login failure

[Dave Page]

I've asked the Debian/Ubuntu package maintainer to look into this.

On Fri, Apr 20, 2018 at 10:23 AM, frankgard <
frank.von.postgresql@familie-gard.de> wrote:

> Hi Tony,
>
> according to  this Stackoverflow post
>  connect-to-postgresql-with-pgadmin4-readonly-attribute-error>
> , the error seems to be caused by a too old psycopg2 library. Perhaps you
> can upgrade to v2.7, or just comment out line 313 of
> /usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py as
> some
> kind of "dirty hack", but be aware that I don't know the "deeper
> consequences" of doing so.
>
> Hope this helps.
>
> Cheers,
> Frank.
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-
> support-f2191615.html
>
>


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

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

Re: pgadmin4.3 - login failure

[frankgard]

Hi Tony,

according to  this Stackoverflow post

 
, the error seems to be caused by a too old psycopg2 library. Perhaps you
can upgrade to v2.7, or just comment out line 313 of
/usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py as some
kind of "dirty hack", but be aware that I don't know the "deeper
consequences" of doing so.

Hope this helps.

Cheers,
Frank.



--
Sent from: 
http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: Bugs in pgAdmin4 3

[Murtuza Zabuawala]

Yes that's a bug & already logged @
https://redmine.postgresql.org/issues/3290
​

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Fri, Apr 20, 2018 at 4:25 PM, Алексей Целищев 
wrote:

> Version3.0
> Python Version2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC
> v.1500 32 bit (Intel)]
> Flask Version0.12.2
> Application ModeDesktop
>
>
> 1. I cant open SQL of any trigger function: Internal errors in right
> botton corner.
> 2. If i tap on error window with error i cant close - screen -
> https://s.mail.ru/3vWb/UUNvP351X
> 3. there is no relation between table -> triggers -> trigger -> function
> of trigger like in pgAdmin3 - screen - https://s.mail.ru/Chw6/RJXDin7Zx
>
>

Bugs in pgAdmin4 3

[Алексей Целищев]

 Version3.0
Python Version2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC
v.1500 32 bit (Intel)]
Flask Version0.12.2
Application ModeDesktop


1. I cant open SQL of any trigger function: Internal errors in right botton
corner.
2. If i tap on error window with error i cant close - screen -
https://s.mail.ru/3vWb/UUNvP351X
3. there is no relation between table -> triggers -> trigger -> function of
trigger like in pgAdmin3 - screen - https://s.mail.ru/Chw6/RJXDin7Zx

Re: pgadmin4 in Cloud Foundry

[Dave Cramer]

On 20 April 2018 at 06:02, Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> Hi,
>
> Right now it is not possible to pass cert and key via variables.
> Please create a feature request for the same HERE
> 
>
>
Alternatively you can just use.

https://github.com/CrunchyData/crunchy-containers/blob/master/centos7/10/Dockerfile.pgadmin4.centos7


Dave Cramer

Re: My pgAdmin is broken

[Dave Page]

I've updated the wheel on the download site to fix this. As an upgrade
wouldn't fix existing installations, I just fixed it without bumping the
version number. For users that have already installed, uninstalling
pycrypto and pycryptodome and then reinstalling pycrypto is the correct fix.

On Thu, Apr 19, 2018 at 5:59 PM, Derek Ealy 
wrote:

> Well then thanks to Kushboo also
>
> On Thu, Apr 19, 2018 at 9:09 AM, Isaias Sanchez <
> isaias.sanche...@gmail.com> wrote:
>
>> The solution was thanks to Khushboo Vashi 'cause I reported this issue
>> yesterday.
>>
>> https://redmine.postgresql.org/issues/3296
>> Let us know if it works for you.
>>
>>
>> Derek Ealy wrote on 04/19/2018 04:04 PM:
>>
>> Allriiigghht Isaias!!
>>
>> Man thanks, I was so freakin' annoyed at this upgrade not working and how
>> frustrating recovering from it was. I'm glad you figured out what the
>> problem was, I had never even heard of pycrypto before to day.
>>
>> Awesomesauce
>>
>> On Thu, Apr 19, 2018 at 8:57 AM, Isaias Sanchez <
>> isaias.sanche...@gmail.com> wrote:
>>
>>> I also had this problem, but the issue is some incompatibilities in
>>> pycryptodome and pycrypto:
>>>
>>> 1. Install v3.0:
>>>
>>> pip install ./pgadmin4-3.0-py2.py3-none-any.whl
>>>
>>> 2. Unistall pycryptodome:
>>>
>>> pip uninstall pycryptodome
>>>
>>> 3. Uninstall/Install pgcrypto:
>>>
>>> pip uninstall pycrypto
>>>
>>> pip3 install pycrypto
>>>
>>> 4. Start pgadmin4:
>>>
>>> python /usr/local/lib/python/site-packages/pgadmin4/pgAdmin4.py &
>>>
>>> Go to: http://127.0.0.1:5050
>>>
>>> After that v3.0 works just fine.
>>>
>>> Cheers,
>>>
>>> Isaias S.
>>> Derek Ealy wrote on 04/19/2018 03:18 PM:
>>>
>>> A couple of days ago I tried upgrading to v3.0. This never worked for
>>> me. Normally I activate the python environment and then install the latest
>>> wheel file to upgrade. I was never able to login successfully on v3.0.
>>>
>>> So I gave up and tried to go back to v2.1, again I did so by
>>> reinstalling the v2.1 wheel file. However afterwards I can't launch
>>> pgAdmin. I get this error message:
>>>
>>> alembic.util.exc.CommandError: Can't locate revision identified by
>>> '50aad68f99c2'
>>>
>>> I've now burned several hours on trying to fix this. What is the best
>>> way to at least get back to a working system with v2.1? In the future is
>>> there some better way to upgrade or revert to a previous version when
>>> things go wrong?
>>>
>>> Thanks, Derek
>>>
>>> --
>>> dme
>>>
>>>
>>> *Derek Ealy*
>>> Sr. Software Architect
>>>
>>> NovaWurks, Inc.
>>> 10772 Noel Street
>>> Los Alamitos, CA 90720
>>> P: 562.340.6270 <562.340.6270%20x%20700>
>>> F: 877.353.7537
>>> C: 310.936.4070 <801.319.4613>
>>>
>>> www.novawurks.com
>>> 
>>> CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company
>>> confidential information proprietary to NovaWurks Corporation or its
>>> customers and may be confidential, legally privileged, and protected by
>>> law. If you are not the intended recipient you may not use, disclose,
>>> distribute, copy, print, or rely on this e-mail. If you have received this
>>> transmission in error please notify the sender and destroy the original
>>> transmission and its attachments without reading or saving. Thank you.
>>>
>>>
>>>
>>
>>
>> --
>> dme
>>
>>
>> *Derek Ealy*
>> Sr. Software Architect
>>
>> NovaWurks, Inc.
>> 10772 Noel Street
>> Los Alamitos, CA 90720
>> P: 562.340.6270 <562.340.6270%20x%20700>
>> F: 877.353.7537
>> C: 310.936.4070 <801.319.4613>
>>
>> www.novawurks.com
>> 
>> CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company
>> confidential information proprietary to NovaWurks Corporation or its
>> customers and may be confidential, legally privileged, and protected by
>> law. If you are not the intended recipient you may not use, disclose,
>> distribute, copy, print, or rely on this e-mail. If you have received this
>> transmission in error please notify the sender and destroy the original
>> transmission and its attachments without reading or saving. Thank you.
>>
>>
>>
>
>
> --
> dme
>
>
> *Derek Ealy*
> Sr. Software Architect
>
> NovaWurks, Inc.
> 10772 Noel Street
> 
> Los Alamitos, CA 90720
> 
> P: 562.340.6270 <562.340.6270%20x%20700>
> F: 877.353.7537
> C: 310.936.4070 <801.319.4613>
>
> www.novawurks.com
> 
> CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company
> confidential information proprietary to NovaWurks Corporation or its
> customers and may be confidential, legally privileged, and protected by
> law. If you are not the intended recipient you may not use, disclose,
> distribute, copy, print, or rely on this e-mail. If you have received this
> 

Re: pgadmin4 in Cloud Foundry

[Murtuza Zabuawala]

Hi,

Right now it is not possible to pass cert and key via variables.
Please create a feature request for the same HERE


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Fri, Apr 20, 2018 at 7:22 AM, Tom C  wrote:

> Hello,
>
> I am able to run pgadmin4 in a Docker Container. I have been trying to
> take the same docker image and run it as a Cloud Foundry Docker enabled
> app. My problem is this Docker image requires certificates and private key
> mapped to a Docker volume as explained here
> https://hub.docker.com/r/dpage/pgadmin4/
>
> I can't pass these files into the Docker container when it's hosted in
> Cloud Foundry. Is there a way to pass the cert and key in as environment
> variables instead?
>
> Thanks.
>
> -Tom
>
>