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.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: pgadmin4.3 - login failure

[Derek Ealy]

I am also having problems logging in since upgrading to pgAdmin4 3.0. Mine
are more like those found in this bug:
https://redmine.postgresql.org/issues/3297

I also tried using the docker image, but that was even worse, it says that
my local postgres server isn't accepting connections. Or if I try to access
our dev instance I get a popup box saying "Please log in to access this
page"

I guess I'm gonna have to revert back to v2.1

On Wed, Apr 18, 2018 at 3:07 AM, Tony Bazeley  wrote:

> On attempting to login to the database server I get an error message
> "readonly attribute" - see log entry below
>
> I'm using postgresql 9.6 on Ubuntu 16.04.4 LTS,  installed on a single
> user workstation using trust authentication on 127.0.0.1
> pgadmin 4.3 installed using apt from the postgresql repository
>
> No problems with pgadmin3 or pgadmin 4.21
>
> Any thoughts on how to proceed would be much appreciated
>
> Thanks
>
> Tony
>
>
>
>
> 2018-04-18 19:10:59,709: ERRORpgadmin:readonly attribute
> Traceback (most recent call last):
>   File 
> "/usr/share/pgadmin4/web/pgadmin/browser/server_groups/servers/__init__.py",
> line 972, in connect
> server_types=ServerType.types()
>   File "/usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py",
> line 313, in connect
> pg_conn.notices = deque([], self.ASYNC_NOTICE_MAXLENGTH)
> AttributeError: readonly attribute
>
>


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

pgadmin4.3 - login failure

[Tony Bazeley]

  
  
On attempting to login to the database server I get an error
  message "readonly attribute" - see log entry below
I'm using postgresql 9.6 on Ubuntu 16.04.4 LTS,  installed on a
  single user workstation using trust authentication on 127.0.0.1
  pgadmin 4.3 installed using apt from the postgresql repository
No problems with pgadmin3 or pgadmin 4.21
Any thoughts on how to proceed would be much appreciated
Thanks
Tony







2018-04-18 19:10:59,709: ERROR    pgadmin:    readonly
attribute
  Traceback (most recent call last):
    File
"/usr/share/pgadmin4/web/pgadmin/browser/server_groups/servers/__init__.py",
line 972, in connect
      server_types=ServerType.types()
    File
"/usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py",
line 313, in connect
      pg_conn.notices = deque([],
self.ASYNC_NOTICE_MAXLENGTH)
  AttributeError: readonly attribute