Thread: no server connected, again
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 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
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
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
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.
On Tue, Jun 6, 2023 at 5:22 PM jh276 <jh276@gmx.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 isWhich 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
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.
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@gmx.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 isWhich 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