Re: no server connected, again -solved-?-

From: jh276 <jh276(at)gmx(dot)de>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: no server connected, again -solved-?-
Date: 2023-06-06 13:50:19
Message-ID: 663a22fa-f24b-ef6e-83e0-3bae95049278@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

After Akshays announcement about 7.3 I updated from 7.2 to 7.3 and ...

... it is working now without any changes.

We will see how long this will last!

J.

Am 06.06.23 um 14:10 schrieb jh276:
>
> it's a 7.2
>
> I recently found the config database. It is a little confusing since
> we have data under /usr/pgadmin4,  ~/.config.pgadmin4, and ~/.pgadmin
> to consider.
>
>
> The logging  ~/.pgadmin/pgadmin4.log gives
>
>
> 2023-06-06 14:03:35,190: WARNING        werkzeug:       WebSocket
> transport not available. Install simple-websocket for improved
> performance.
> 2023-06-06 14:03:35,190: WARNING        werkzeug:       Werkzeug
> appears to be used in a production deployment. Consider switching to a
> production web serve
> r instead.
>
> if I am right, such entries are not coming up, if I start pgadmin with
> active config_local.py.
>
>
>
> Am 06.06.23 um 13:56 schrieb Khushboo Vashi:
>>
>>
>> On Tue, Jun 6, 2023 at 5:22 PM jh276 <jh276(at)gmx(dot)de> wrote:
>>
>> Hi,
>>
>>
>> it seems that my issues with pgadmin are not solved. I will try
>> to give
>> a short but suitable description what I have done and what to
>> issue is
>>
>> Which version of pgAdmin installed?
>>
>>
>> 1) Kubunti 23.04 freshly installed
>>
>> 2) pgadmin repo added and installed, only desktop no web client
>>
>> 3) pgadmin started, main password entered and two remote server
>> connected. No issues so far!
>>
>> 4) pgadmin closed
>>
>>
>> 5) installing other applications and setting up OS
>>
>>
>> this was a few days ago, and today
>>
>> 1) pgadmin started, no prompt for main password
>>
>> 2) expanding server entries fails. The wait cursor is cycling
>> (for ever,
>> no time out).
>>
>> 3) restart pgadmin. Server entries cannot be deleted. Nothing happens
>>
>> 4) created config_local.py with following content as recommended
>> in the
>> docs for logging
>>
>>
>> --snipp--
>>
>> import logging
>>
>> CONSOLE_LOG_LEVEL = logging.DEBUG
>> FILE_LOG_LEVEL = logging.DEBUG
>>
>> # Log format.
>> CONSOLE_LOG_FORMAT = '%(asctime)s:
>> %(levelname)s\t%(name)s:\t%(message)s'
>> FILE_LOG_FORMAT = '%(asctime)s:
>> %(levelname)s\t%(name)s:\t%(message)s'
>>
>> # Log file name
>> LOG_FILE = '/var/log/pgadmin4.log'
>> --snapp--
>>
>>
>> 5) restarted pgadmin. Splash screen ("Waiting for pgAdmin4 to start
>> ...") hangs, after a while ("taking longer as usual" and "almost
>> there")
>> I get an error window with "The pgAdmin4 server could not be
>> contacted"
>> and a list of my environmental variables.
>>
>> 6) config_local.py removed and pgadmin comes up again. But still no
>> chance to open server entries or to do any stuff
>>
>>
>> Facts:
>>
>> This is the second Kubuntu install with that kind of issues. Any
>> reinstall (Kubuntu and/or pgadmin) is not solving anything
>>
>> During first launch of pgadmin I can add and connect servers, can
>> send
>> queries, .... After that first launch something is broken
>>
>> remote servers are available via psql .
>>
>> also the local postgresql server entry shows same behavior in pgadmin
>>
>> I am clueless, I only can guess that there is a crosscontamination by
>> other apps.
>>
>>
>>
>> Any advice?
>>
>>
>> further questions: where are the config stored. I am asking about the
>> server entries and their properties to delete them by hand.
>>
>>
>> Joachim
>>
>>
>>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Adrian Klaver 2023-06-06 14:50:35 Re: No prompt for setting up a master password
Previous Message Akshay Joshi 2023-06-06 13:15:57 pgAdmin 4 v7.3 Released