Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1brKST-0006zb-Cz for pgadmin-hackers@arkaria.postgresql.org; Tue, 04 Oct 2016 07:48:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1brKSS-0006CB-Sq for pgadmin-hackers@arkaria.postgresql.org; Tue, 04 Oct 2016 07:48:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1brKSE-0005xr-J3 for pgadmin-hackers@postgresql.org; Tue, 04 Oct 2016 07:47:58 +0000 Received: from mail-io0-x22f.google.com ([2607:f8b0:4001:c06::22f]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1brKS9-0000Su-64 for pgadmin-hackers@postgresql.org; Tue, 04 Oct 2016 07:47:57 +0000 Received: by mail-io0-x22f.google.com with SMTP id j37so51136347ioo.3 for ; Tue, 04 Oct 2016 00:47:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=lIcoDYV+ZzHysDg7k7PGMl+qwtRv1YZcNqkBvpdfdnc=; b=brR3HaVEQhOMYg8b/tmGDIqYpzbAZCfbcmVB84J7L3TX3pitLt7LNLMwjDqEWJobxb Qvm6U/zjmcT3vu0Pcp/xVbnyY+OnNso4iLGFESUdV/Ul6zc/DwjAIWf1sBgnIFUIetuP SlPu8e4gBkjCOrL6D0HOcsm7FTS43X2FCrWxDnMFvXf7SpVeT/JsD0UyWHz1igA3ZkQL pg4ccvaNCgMdeYVHDHd3SJYrx8Ow36wyL8v2Ua66x+n3fQLnEjX+Fe8Z1VN5oHEhk86o ZHY5McfDNpKhc1jJeGsI2V4NxHYhVtt8rRuphlZr6ALFD5EibrDSm96/zzC49AglT1JK kUsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=lIcoDYV+ZzHysDg7k7PGMl+qwtRv1YZcNqkBvpdfdnc=; b=QnuHd9x8nZdcBRA3BntnwKXnf85P34wF1um0huBL91fDeC0IKKz0g+UXdYiiYeDd+c 4kGXxuQFA6SWhNunUQVF6roEu8T6NzOTW/VVc93DuV0NlvDDjYGIxYfYDwXk64iz9SFo WFYhhPnX1w5FfIkxwf67nKywa6TZx4FdZx6PqPllu7t/EAs/vcXR5Cq3RZ6pwSIUFhzU tRqSmyhLvkj1gWBIkYD/873LgPC2PZuhvEDEWfZ6zVxYC0C+zP7mFhWvm7+IKYzzv/aI wu2CeETBs+b3bSYA+y5ACMxeqvkizIXark7iftfTYt+fw50B77PDGzC1em5PUSHPJryx hfAA== X-Gm-Message-State: AA6/9RnhnRdMDI8P6au17TPhNIZusdsUZ26Abl/x4qRj1cOrm0DCxI19MYOzAQfB0RZPqnOpLNITraaT5OHU2bWp X-Received: by 10.107.148.211 with SMTP id w202mr2859992iod.135.1475567271839; Tue, 04 Oct 2016 00:47:51 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.25.85 with HTTP; Tue, 4 Oct 2016 00:47:31 -0700 (PDT) In-Reply-To: References: <434b81b8-98f5-92ec-a76a-3e3c82d12e72@thuenen.de> <2fe4e975-687a-86e6-d997-4c1debeaf51d@thuenen.de> From: Ashesh Vashi Date: Tue, 4 Oct 2016 13:17:31 +0530 Message-ID: Subject: Re: Connection to the server has been lost To: Ralph Ryl Cc: pgadmin-hackers , Fahar Abbas Content-Type: multipart/alternative; boundary=001a113fae9614a6d8053e054765 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --001a113fae9614a6d8053e054765 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Tue, Oct 4, 2016 at 1:00 PM, Fahar Abbas wrote: > Please also remember to add pgAdmin-hackers email list for every email in > that case, Development team can respond quickly. > > Dave/Ashesh, > > Please find below the output shared by Ralph. > > Kind Regards, > > > On Tue, Oct 4, 2016 at 12:24 PM, Ralph Ryl wrote: > >> Hi Fahar, >> >> here are the steps I do: >> >> - System: Ubuntu 14.04 >> >> - I create an new server in a servergroup wich is not local >> >> - I enter correct logindata >> >> - if i directly try to connect an error with "bytea_output" appear >> >> - if i save the connection without directly connect it save the connecti= on >> >> - if i doubleclick on the new connection pgadmin ask for the password(no >> matter if i save it) and show an message like "Connection to the server = has >> been lost." >> > Hi Ralph, Looks like - pgAdmin 4 (indirectly the psycopg2 driver) is using very old version of libpq. Can you please upgrade the libpq on the system? I will be able to suggest "how to upgrade on libpq", only if you can give information about the operating system? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* > >> here the last 50 lines from the logfile: >> >> 2016-10-04 09:20:37,847: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:20:37] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:20:42,858: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:20:42] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:20:47,869: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:20:47] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:20:52,879: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:20:52] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:20:57,891: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:20:57] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:02,902: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:02] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:07,912: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:07] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:12,924: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:12] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:16,626: INFO pgadmin: Connection Request for serv= er#4 >> >> 2016-10-04 09:21:16,629: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:16] "POST /browser/server/connect/2/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:17,935: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:17] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:18,188: INFO pgadmin: Connection Request for serv= er#4 >> >> 2016-10-04 09:21:18,211: SQL pgadmin: Execute (scalar) for server = #4 - DB:postgres (Query-id: 8568684): >> >> SET DateStyle=3DISO; >> >> SET client_min_messages=3Dnotice; >> >> SET bytea_output=3Descape; >> >> SET client_encoding=3D'UNICODE'; >> >> 2016-10-04 09:21:18,214: ERROR pgadmin: Failed to execute query (e= xecute_scalar) for the server #4 - DB:postgres (Query-id: 8568684): >> >> Error Message:FEHLER: unbekannter Konfigurationsparameter =C2=BBbytea_o= utput=C2=AB >> >> 2016-10-04 09:21:22,946: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:22] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:27,959: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:27] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:31,139: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:31] "POST /misc/ping HTTP/1.1" 200 - >> >> 2016-10-04 09:21:32,973: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:32] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:37,986: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:37] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:43,001: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:43] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:48,022: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:48] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:53,034: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:53] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:21:58,046: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:21:58] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:03,058: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:03] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:08,068: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:08] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:13,080: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:13] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:18,092: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:18] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:23,105: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:23] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:28,116: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:28] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:33,130: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:33] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:38,142: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:38] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:43,154: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:43] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:48,165: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:48] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:53,176: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:53] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:22:58,186: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:22:58] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:03,196: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:03] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:08,210: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:08] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:13,226: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:13] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:18,236: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:18] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:23,247: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:23] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:28,257: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:28] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:33,267: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:33] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> 2016-10-04 09:23:38,278: INFO werkzeug: 127.0.0.1 - - [04/Oct/2016= 09:23:38] "GET /dashboard/activity/4 HTTP/1.1" 428 - >> >> >> >> And here the output from the running server in the bash: >> >> 2016-10-04 09:21:18,214: ERROR pgadmin: Failed to execute query (execute= _scalar) for the server #4 - DB:postgres (Query-id: 8568684): >> Error Message:FEHLER: unbekannter Konfigurationsparameter =C2=BBbytea_o= utput=C2=AB >> >> Exception in thread Thread-346: >> Traceback (most recent call last): >> File "/usr/lib/python2.7/threading.py", line 810, in __bootstrap_inner >> self.run() >> File "/usr/lib/python2.7/threading.py", line 763, in run >> self.__target(*self.__args, **self.__kwargs) >> File "/usr/lib/python2.7/SocketServer.py", line 596, in process_reques= t_thread >> self.handle_error(request, client_address) >> File "/usr/lib/python2.7/SocketServer.py", line 593, in process_reques= t_thread >> self.finish_request(request, client_address) >> File "/usr/lib/python2.7/SocketServer.py", line 334, in finish_request >> self.RequestHandlerClass(request, client_address, self) >> File "/usr/lib/python2.7/SocketServer.py", line 649, in __init__ >> self.handle() >> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", lin= e 200, in handle >> rv =3D BaseHTTPRequestHandler.handle(self) >> File "/usr/lib/python2.7/BaseHTTPServer.py", line 340, in handle >> self.handle_one_request() >> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", lin= e 235, in handle_one_request >> return self.run_wsgi() >> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", lin= e 177, in run_wsgi >> execute(self.server.app) >> File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", lin= e 165, in execute >> application_iter =3D app(environ, start_response) >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2000,= in __call__ >> return self.wsgi_app(environ, start_response) >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1991,= in wsgi_app >> response =3D self.make_response(self.handle_exception(e)) >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1567,= in handle_exception >> reraise(exc_type, exc_value, tb) >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1988,= in wsgi_app >> response =3D self.full_dispatch_request() >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1641,= in full_dispatch_request >> rv =3D self.handle_user_exception(e) >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1544,= in handle_user_exception >> reraise(exc_type, exc_value, tb) >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1639,= in full_dispatch_request >> rv =3D self.dispatch_request() >> File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1625,= in dispatch_request >> return self.view_functions[rule.endpoint](**req.view_args) >> File "/usr/local/lib/python2.7/dist-packages/flask/views.py", line 84,= in view >> return self.dispatch_request(*args, **kwargs) >> File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/browser/= utils.py", line 235, in dispatch_request >> return method(*args, **kwargs) >> File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/browser/= server_groups/servers/__init__.py", line 829, in connect >> server.id, server.name, errmsg >> UnicodeEncodeError: 'ascii' codec can't encode character u'\xbb' in posi= tion 45: ordinal not in range(128) >> >> >> I hope you can follow me an find my mistake. >> >> Many thanks in advance, >> >> Ralph Ryl >> >> >> >> Am 03.10.2016 um 06:47 schrieb Fahar Abbas: >> >> Hi Ralph, >> >> This issue is not reproducible with remote server. >> >> Can you please share the exact steps and *pgAdmin4.log* file location >> under /home/fahar for Linux and in Windows %AppData% with the team so t= hey >> can investigate the actual problem? >> >> Regards, >> >> >> On Thu, Sep 29, 2016 at 10:42 AM, Ralph Ryl wrote= : >> >>> Dear pgadmin4 Developers, >>> on trying to connect remote postgresql-server, the connection lost. I >>> think the problem is the timeout for the connection. PGAdminIII works >>> for the same server without problems. >>> Maybe you can make an option in settings for the timout. >>> >>> kind regards, >>> >>> Ralph >>> >>> -- >>> Achtung: Das Th=C3=BCnen-Institut hat die Domain gewechselt. >>> Bitte =C3=A4ndern Sie meine Mailadresse in Ihrem Adressbuch! >>> >>> Ralph Ryl >>> Th=C3=BCnen-Institut f=C3=BCr Wald=C3=B6kosysteme / Th=C3=BCnen Institu= te of Forest >>> Ecosystems >>> A.-M=C3=B6ller-Str. 1, Haus 41/42 >>> D-16225 Eberswalde (Germany) >>> >>> Tel: +49 3334 3820-347 <%2B49%203334%203820-347> >>> Fax: +49 3334 3820-354 <%2B49%203334%203820-354> >>> Mail: ralph.ryl@thuenen.de >>> Web: www.thuenen.de >>> >>> >>> >>> >>> -- >>> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgadmin-hackers >>> >> >> >> >> -- >> Syed Fahar Abbas >> Quality Management Group >> >> 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 >> >> >> -- >> Achtung: Das Th=C3=BCnen-Institut hat die Domain gewechselt. >> Bitte =C3=A4ndern Sie meine Mailadresse in Ihrem Adressbuch! >> >> Ralph Ryl >> Th=C3=BCnen-Institut f=C3=BCr Wald=C3=B6kosysteme / Th=C3=BCnen Institut= e of Forest Ecosystems >> A.-M=C3=B6ller-Str. 1, Haus 41/42 >> D-16225 Eberswalde (Germany) >> >> Tel: +49 3334 3820-347 >> Fax: +49 3334 3820-354 >> Mail: ralph.ryl@thuenen.de >> Web: www.thuenen.de >> >> > > > -- > Syed Fahar Abbas > Quality Management Group > > 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 > --001a113fae9614a6d8053e054765 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
On Tue, Oct 4, 2016 at 1:00 PM,= Fahar Abbas <fahar.abbas@enterprisedb.com> wrote= :
Ple= ase also remember to add pgAdmin-hackers email list for every email in that= case, Development team can respond quickly.

Dave/Ashesh,
<= br>
Please find below the output shared by Ralph.

Kind Re= gards,


On Tue, Oct 4, 2016 at 12:24 PM, Ralph Ryl <ralph.ryl@thuenen.de= > wrote:
=20 =20 =20

Hi Fahar,

here are the steps I do:

- System: Ubuntu 14.04

- I create an new server in a servergroup wich is not local

- I enter correct logindata

- if i directly try to connect an error with "bytea_output"= ; appear

- if i save the connection without directly connect it save the connection

- if i doubleclick on the new connection pgadmin ask for the password(no matter if i save it) and show an message like "Connection to the server has been lost."

Hi Ralph,

Looks like - p= gAdmin 4 (indirectly the psycopg2 driver) is using very old version of libp= q.

Can= you please upgrade the libpq on the system?
I will be able to suggest "how to upgrade on libpq", only if yo= u can give information about the operating system?

--

= Thanks & Regards,

Ashesh Vashi
EnterpriseDB I= NDIA:=C2=A0Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


here the last 50 lines from the logfile:

2016-10-04 09:20:37,847: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:20:37] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:20:42,858: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:20:42] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:20:47,869: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:20:47] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:20:52,879: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:20:52] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:20:57,891: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:20:57] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:02,902: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:02] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:07,912: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:07] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:12,924: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:12] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:16,626: INFO=C2=A0=C2=A0 =C2=A0pgadmin:=C2=A0=C2=
=A0 =C2=A0Connection Request for server#4
2016-10-04 09:21:16,629: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:16] "POST /browser/server/c=
onnect/2/4 HTTP/1.1" 428 -
2016-10-04 09:21:17,935: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:17] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:18,188: INFO=C2=A0=C2=A0 =C2=A0pgadmin:=C2=A0=C2=
=A0 =C2=A0Connection Request for server#4
2016-10-04 09:21:18,211: SQL=C2=A0=C2=A0 =C2=A0pgadmin:=C2=A0=C2=
=A0 =C2=A0Execute (scalar) for server #4 - DB:postgres (Query-id: 8568684):=

SET DateStyle=3DISO;
SET client_min_messages=3Dnotice;
SET bytea_output=3Descape;
SET client_encoding=3D'UNICODE';
2016-10-04 09:21:18,214: ERROR=C2=A0=C2=A0 =C2=A0pgadmin:=C2=A0=C2=
=A0 =C2=A0Failed to execute query (execute_scalar) for the server #4 - DB:p=
ostgres (Query-id: 8568684):
Error Message:FEHLER:=C2=A0 unbekannter Konfigurationsparameter =
=C2=BBbytea_output=C2=AB
2016-10-04 09:21:22,946: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:22] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:27,959: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:27] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:31,139: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:31] "POST /misc/ping HTTP/1=
.1" 200 -
2016-10-04 09:21:32,973: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:32] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:37,986: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:37] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:43,001: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:43] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:48,022: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:48] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:53,034: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:53] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:21:58,046: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:21:58] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:03,058: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:03] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:08,068: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:08] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:13,080: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:13] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:18,092: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:18] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:23,105: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:23] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:28,116: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:28] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:33,130: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:33] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:38,142: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:38] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:43,154: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:43] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:48,165: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:48] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:53,176: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:53] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:22:58,186: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:22:58] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:03,196: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:03] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:08,210: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:08] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:13,226: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:13] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:18,236: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:18] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:23,247: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:23] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:28,257: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:28] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:33,267: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:33] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -
2016-10-04 09:23:38,278: INFO=C2=A0=C2=A0 =C2=A0werkzeug:=C2=A0=C2=
=A0 =C2=A0127.0.0.1 - - [04/Oct/2016 09:23:38] "GET /dashboard/activit=
y/4 HTTP/1.1" 428 -


And here the output from the running server in the bash:

2016-10-04 09:21:18,214: ERROR	pgadmin:	Failed to execute query (e=
xecute_scalar) for the server #4 - DB:postgres (Query-id: 8568684):
Error Message:FEHLER:  unbekannter Konfigurationsparameter =C2=BBbytea_outp=
ut=C2=AB

Exception in thread Thread-346:
Traceback (most recent call last):
  File "/usr/lib/python2.7/threading.py", line 810, in __boo=
tstrap_inner
    self.run()
  File "/usr/lib/python2.7/threading.py", line 763, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/usr/lib/python2.7/SocketServer.py", line 596, in pr=
ocess_request_thread
    self.handle_error(request, client_address)
  File "/usr/lib/python2.7/SocketServer.py", line 593, in pr=
ocess_request_thread
    self.finish_request(request, client_address)
  File "/usr/lib/python2.7/SocketServer.py", line 334, in fi=
nish_request
    self.RequestHandlerClass(request, client_address, self)
  File "/usr/lib/python2.7/SocketServer.py", line 649, in __=
init__
    self.handle()
  File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.p=
y", line 200, in handle
    rv =3D BaseHTTPRequestHandler.handle(self)
  File "/usr/lib/python2.7/BaseHTTPServer.py", line 340, in =
handle
    self.handle_one_request()
  File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.p=
y", line 235, in handle_one_request
    return self.run_wsgi()
  File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.p=
y", line 177, in run_wsgi
    execute(self.server.app)
  File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.p=
y", line 165, in execute
    application_iter =3D app(environ, start_response)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 2000, in __call__
    return self.wsgi_app(environ, start_response)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 1991, in wsgi_app
    response =3D self.make_response(self.handle_exception(e))
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 1567, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 1988, in wsgi_app
    response =3D self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 1641, in full_dispatch_request
    rv =3D self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 1544, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 1639, in full_dispatch_request
    rv =3D self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py"=
, line 1625, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python2.7/dist-packages/flask/views.py&quo=
t;, line 84, in view
    return self.dispatch_request(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/<=
wbr>browser/utils.py", line 235, in dispatch_request
    return method(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/<=
wbr>browser/server_groups/servers/__init__.py", line 829, in conn=
ect
    server.id, server.name, errmsg
UnicodeEncodeError: 'ascii' codec can't encode character u'=
\xbb' in position 45: ordinal not in range(128)
I hope you can follow me an find my mistake.

Many thanks in advance,

Ralph Ryl



Am 03.10.2016 um 06:47 schrieb Fahar Abbas:
Hi Ralph,

This issue is not reproducible with remote server.

Can you please share the exact steps and pgAdmin4.log file location under /home/fahar=C2=A0 for Linux and in Windows %AppData% with the team so they can investigate the actual problem?

Regards,


On Thu, Sep 29, 2016 at 10:42 AM, Ralph Ryl <ralph.ryl@thuenen.de> wrote:
Dear pgadmin4 Developers,
on trying to connect remote postgresql-server, the connection lost. I
think the problem is the timeout for the connection. PGAdminIII works
for the same server without problems.
Maybe you can make an option in settings for the timout.

kind regards,

Ralph

--
Achtung: Das Th=C3=BCnen-Institut hat die Domain gewechselt. Bitte =C3=A4ndern Sie meine Mailadresse in Ihrem Adressbuch!
Ralph Ryl
Th=C3=BCnen-Institut f=C3=BCr Wald=C3=B6kosysteme / Th=C3=BCnen= Institute of Forest Ecosystems
A.-M=C3=B6ller-Str. 1, Haus 41/42
D-16225 Eberswalde (Germany)

Tel:=C2=A0 +49 3334 3820-347
Fax:=C2=A0 +49 3334 3820-354
Mail: ralph.ryl@thuenen.de
Web:=C2=A0 www.thuenen.de




--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.= org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



--
Syed Fahar Abbas
Quality Management Group

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

--=20
Achtung: Das Th=C3=BCnen-Institut hat die Domain gewechselt.
Bitte =C3=A4ndern Sie meine Mailadresse in Ihrem Adressbuch!

Ralph Ryl
Th=C3=BCnen-Institut f=C3=BCr Wald=C3=B6kosysteme / Th=C3=BCnen Institute o=
f Forest Ecosystems
A.-M=C3=B6ller-Str. 1, Haus 41/42
D-16225 Eberswalde (Germany)

Tel:  +49 3334 3820-347
Fax:  +49 3334 3820-354
Mail: ralph.ryl@t=
huenen.de
Web:  www.thuenen.de

--001a113fae9614a6d8053e054765--