On Tue, Oct 4, 2016 at 1:00 PM, Fahar Abbas <fahar.ab...@enterprisedb.com> 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 <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." >> > 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.enterprisedb.com/> *http://www.linkedin.com/in/asheshvashi* <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 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 >
