public inbox for [email protected]  
help / color / mirror / Atom feed
Connection to the server has been lost
4+ messages / 3 participants
[nested] [flat]

* Connection to the server has been lost
@ 2016-09-29 05:42  Ralph Ryl <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Ralph Ryl @ 2016-09-29 05:42 UTC (permalink / raw)
  To: pgadmin-hackers

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
Fax:  +49 3334 3820-354
Mail: [email protected]
Web:  www.thuenen.de 




-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Connection to the server has been lost
@ 2016-10-03 04:47  Fahar Abbas <[email protected]>
  parent: Ralph Ryl <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Fahar Abbas @ 2016-10-03 04:47 UTC (permalink / raw)
  To: Ralph Ryl <[email protected]>; +Cc: pgadmin-hackers

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 <[email protected]> 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
> Fax:  +49 3334 3820-354
> Mail: [email protected]
> Web:  www.thuenen.de
>
>
>
>
> --
> Sent via pgadmin-hackers mailing list ([email protected])
> 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


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Connection to the server has been lost
@ 2016-10-04 07:30  Fahar Abbas <[email protected]>
  parent: Fahar Abbas <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Fahar Abbas @ 2016-10-04 07:30 UTC (permalink / raw)
  To: Ralph Ryl <[email protected]>; pgadmin-hackers

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 <[email protected]> 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 <[email protected]> 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: [email protected]
>> Web:  www.thuenen.de
>>
>>
>>
>>
>> --
>> Sent via pgadmin-hackers mailing list ([email protected])
>> 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: [email protected]
> 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


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Connection to the server has been lost
@ 2016-10-04 07:47  Ashesh Vashi <[email protected]>
  parent: Fahar Abbas <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Ashesh Vashi @ 2016-10-04 07:47 UTC (permalink / raw)
  To: Ralph Ryl <[email protected]>; +Cc: pgadmin-hackers; Fahar Abbas <[email protected]>

On Tue, Oct 4, 2016 at 1:00 PM, Fahar Abbas <[email protected]>
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 <[email protected]> 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 <[email protected]> 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: [email protected]
>>> Web:  www.thuenen.de
>>>
>>>
>>>
>>>
>>> --
>>> Sent via pgadmin-hackers mailing list ([email protected])
>>> 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: [email protected]
>> 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
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2016-10-04 07:47 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-09-29 05:42 Connection to the server has been lost Ralph Ryl <[email protected]>
2016-10-03 04:47 ` Fahar Abbas <[email protected]>
2016-10-04 07:30   ` Fahar Abbas <[email protected]>
2016-10-04 07:47     ` Ashesh Vashi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox