Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1brKBp-0005AP-2f for pgadmin-hackers@arkaria.postgresql.org; Tue, 04 Oct 2016 07:31:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1brKBo-0001II-Go for pgadmin-hackers@arkaria.postgresql.org; Tue, 04 Oct 2016 07:31:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1brKBn-0001I4-71 for pgadmin-hackers@postgresql.org; Tue, 04 Oct 2016 07:30:59 +0000 Received: from mail-lf0-x231.google.com ([2a00:1450:4010:c07::231]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1brKBf-000839-DF for pgadmin-hackers@postgresql.org; Tue, 04 Oct 2016 07:30:58 +0000 Received: by mail-lf0-x231.google.com with SMTP id b81so55286097lfe.1 for ; Tue, 04 Oct 2016 00:30:50 -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; bh=QdO1bMaiFYoxmN1F9p+mc9dSxroPPgwXA0bWPOmuB6M=; b=1E2VCnJant+A+MKLTBVaB0IsbfH++X4fB8X7RaXB7dDxY0Fu5qnw5vuh94NqwYJkKt 0Gdp2xAsDRnh18gNBMHSToI1HLZn7phXgWllETRDS07JiJu96UX1MwhT8geGr1cGANMK 8G8IhChX8W4n9WbNdMh6QNPf6vqDJ5W1PkYTYOugDjSzsVVVI9bD5f1NZSxyS7wD52Tb 81j8NSenO0f/ntYrLHJKET0pFQ3nM4VPEqjqOjvtkIqVjivRAWFAqCvKpOQCGQJjllbM AvTqdPzAbBoxRlsWiZgDanc6/+uIF/GSmKwpv1buAAK7xe5WNX95QQfif5QxTt3NjIrF nDFg== 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; bh=QdO1bMaiFYoxmN1F9p+mc9dSxroPPgwXA0bWPOmuB6M=; b=Ct/sF8cdb8dBlDy24oJg7X+tnR9f/Um01dtD6cefd/YGNqkYqrXapNtppslhB0eb+B vJScper2SSwerbbHB1SXaFu9N71A/XieQNkyDFjLYxb1ItaTUas34XNXzEPQ9oElF42M 9kNvS+rvx/n7VdRunKDmPK6QZQ4Nxst7rWjIGUSG8bopAX8zqXMrQL7+vUqdT7yU3WKF a85F53CxDkKG0YiMk54z/sFqPyix8CSXgowutD2U9Vh+i9MQecLUFF1N76DX1ig30IuT 8w8fop94y6dcMp5+QQTk1Hk6uaD+HeeFaxti4HkcjOfmiycZNxE2YqAHNNBnbRIYSw4o UqCQ== X-Gm-Message-State: AA6/9RnjVClVieWCwxTPs33BO0fkLriPx0Dut/Thss/y1JI8mrCSxbC+kmGSCncMJWWJ4ykhFnPdRdZKm/UOOD5N X-Received: by 10.25.190.69 with SMTP id o66mr241027lff.109.1475566250327; Tue, 04 Oct 2016 00:30:50 -0700 (PDT) MIME-Version: 1.0 Received: by 10.25.92.219 with HTTP; Tue, 4 Oct 2016 00:30:49 -0700 (PDT) In-Reply-To: <2fe4e975-687a-86e6-d997-4c1debeaf51d@thuenen.de> References: <434b81b8-98f5-92ec-a76a-3e3c82d12e72@thuenen.de> <2fe4e975-687a-86e6-d997-4c1debeaf51d@thuenen.de> From: Fahar Abbas Date: Tue, 4 Oct 2016 12:30:49 +0500 Message-ID: Subject: Re: Connection to the server has been lost To: Ralph Ryl , pgadmin-hackers Content-Type: multipart/alternative; boundary=94eb2c1a1e0a319707053e050a17 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 --94eb2c1a1e0a319707053e050a17 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 connectio= n > > - 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 h= as > been lost." > > > 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 serve= r#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 serve= r#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 (ex= ecute_scalar) for the server #4 - DB:postgres (Query-id: 8568684): > > Error Message:FEHLER: unbekannter Konfigurationsparameter =C2=BBbytea_ou= tput=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_ou= tput=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_request= _thread > self.handle_error(request, client_address) > File "/usr/lib/python2.7/SocketServer.py", line 593, in process_request= _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", 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.py", line= 235, in handle_one_request > return self.run_wsgi() > File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line= 177, in run_wsgi > execute(self.server.app) > File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", 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", line 84, = in view > return self.dispatch_request(*args, **kwargs) > File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/browser/u= tils.py", line 235, in dispatch_request > return method(*args, **kwargs) > File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgadmin/browser/s= erver_groups/servers/__init__.py", line 829, in connect > server.id, server.name, errmsg > UnicodeEncodeError: 'ascii' codec can't encode character u'\xbb' in posit= ion 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 th= ey > 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 Institut= e 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 Institute= 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 > > --=20 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 --94eb2c1a1e0a319707053e050a17 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Please also remember to add pgAdmin-hackers= email list for every email in that case, Development team can respond quic= kly.

Dave/Ashesh,

Please find below the output sh= ared by Ralph.

Kind Regards,


On Tue, Oct 4, 2016 at 12:24 PM, Ralp= h 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."


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/serv=
ing.py", 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/serv=
ing.py", line 235, in handle_one_request
    return self.run_wsgi()
  File "/usr/local/lib/python2.7/dist-packages/werkzeug/serv=
ing.py", line 177, in run_wsgi
    execute(self.server.app)
  File "/usr/local/lib/python2.7/dist-packages/werkzeug/serv=
ing.py", 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/pgad=
min/browser/utils.py", line 235, in dispatch_request
    return method(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/pgadmin4/pgad=
min/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 



--
--94eb2c1a1e0a319707053e050a17--