Re: PgAdmin4 stopped working: "The application server could not be contacted."

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: PgAdmin4 stopped working: "The application server could not be contacted."
Дата
Msg-id CA+OCxowBjrP0u-+-NDdrK69sopSG7eCR1kKwxFeW4xEBCgNzsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PgAdmin4 stopped working: "The application server could not becontacted."  (Johann Spies <jspies@sun.ac.za>)
Список pgadmin-support
Hi

On Wed, Sep 12, 2018 at 10:12 AM, Johann Spies <jspies@sun.ac.za> wrote:
On Wed, Sep 12, 2018 at 09:05:37AM +0100, Dave Page wrote:

> Can you provide logs? You may need to enable logging per
> https://www.pgadmin.org/faq/#8.

The log is complaining about not being able to contact the server on
port 63334 (I am using a ssh tunnel not defined in pgadmin4).

The last part of the log:
---------------------------------------------------------
2018-09-06 11:05:26,060: ERROR  pgadmin:        Could not connected to server(#2) - 'kbase'.
Error: could not connect to server: Connection refused
        Is the server running on host "localhost" (::1) and accepting
        TCP/IP connections on port 63334?
could not connect to server: Connection refused
        Is the server running on host "localhost" (127.0.0.1) and accepting
        TCP/IP connections on port 63334?
-----------------------------------------------------
but on the commandline I can do:
------------------------------------------------------
js@sitasie ~ 11:05:01> psql -h localhost -p 63334 wos
SET

Welcome, my magistrate

psql (10.5 (Debian 10.5-1.pgdg100+1), server 10.4 (Debian 10.4-2.pgdg90+1))
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

localhost js@wos=#
------------------------------------------------------

I'm confused. Your first message said the error was that the application server couldn't be contacted, but this seems to imply that pgAdmin is up and running and the failure is when it's trying to connect to a database server.

Do those log messages occur when pgAdmin is actually trying to start (i.e. maybe pgAdmin is trying to restore a connection at startup, then failing, and the timeout of that is also causing the runtime to timeout when connecting to the app server)? 

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgadmin-support по дате отправления:

Предыдущее
От: Johann Spies
Дата:
Сообщение: Re: PgAdmin4 stopped working: "The application server could not becontacted."
Следующее
От: Vladimir Ryabtsev
Дата:
Сообщение: Re: pgAdmin in Docker: independent users storage