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 <ralph....@thuenen.de> 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 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 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 server#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 server#4 > > 2016-10-04 09:21:18,211: SQL pgadmin: Execute (scalar) for server #4 - > DB:postgres (Query-id: 8568684): > > SET DateStyle=ISO; > > SET client_min_messages=notice; > > SET bytea_output=escape; > > SET client_encoding='UNICODE'; > > 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 »bytea_output« > > 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 »bytea_output« > > 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 = 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 = 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 = 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 = self.full_dispatch_request() > File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1641, in > full_dispatch_request > rv = 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 = 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 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 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....@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ünen-Institut hat die Domain gewechselt. >> Bitte ändern Sie meine Mailadresse in Ihrem Adressbuch! >> >> Ralph Ryl >> Thünen-Institut für Waldökosysteme / Thünen Institute of Forest Ecosystems >> A.-Möller-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....@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ünen-Institut hat die Domain gewechselt. > Bitte ändern Sie meine Mailadresse in Ihrem Adressbuch! > > Ralph Ryl > Thünen-Institut für Waldökosysteme / Thünen Institute of Forest Ecosystems > A.-Möller-Str. 1, Haus 41/42 > D-16225 Eberswalde (Germany) > > Tel: +49 3334 3820-347 > Fax: +49 3334 3820-354 > Mail: ralph....@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
