From: | Bogdan Yakovenko <bogdan(dot)yakovenko(at)serverbee(dot)net> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | pgadmin4 - session timeout problem in browser |
Date: | 2018-11-19 20:25:43 |
Message-ID: | CADrmJRWbv3F6bC=T2zdmNqTh3Ac+nLao5AwZYcpuvm4KsmLqPw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all!
I use latest 3.5 version of *pgadmin4* as GKE docker service to working
with Google Cloud SQL (Postgres 9.6).
I always get random resetting browser session after connection to db and
get message that I need login again.
Tried to do workaround from this post:
https://superuser.com/a/729261
but after adding `.pg_service.conf` to /root directory (pgadmin4 is running
from root in container) I didn't see any changes with random logouts.
The problem seems same as after manually removing cookie from my browser.
Also I noticed that after random logout expires date of *pga4_session* cookie
is always changing to *1969-12-31T23:59:59.000Z *but before set to same
value as in config - 1 day.
I tried enable *debug* mode but it not gave me any answer: ```
2018-11-19 19:24:58,615: SQL pgadmin: Execute (dict) for server #1 -
DB:db_dev (Query-id: 1254648):
/*pga4dash*/
SELECT
(SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
2018-11-19 19:24:58,937: INFO werkzeug: 10.4.0.1 - - [19/Nov/2018 19:24:58]
"GET /dashboard/ti_stats/1 HTTP/1.1" 200 -
2018-11-19 19:24:59,045: INFO werkzeug: 10.4.0.1 - - [19/Nov/2018 19:24:59]
"GET /dashboard/tps_stats/1 HTTP/1.1" 200 -
2018-11-19 19:24:59,045: INFO werkzeug: 10.4.0.1 - - [19/Nov/2018 19:24:59]
"GET /dashboard/to_stats/1 HTTP/1.1" 200 -
2018-11-19 19:24:59,153: INFO werkzeug: 10.4.0.1 - - [19/Nov/2018 19:24:59]
"GET /dashboard/bio_stats/1 HTTP/1.1" 200 -
2018-11-19 19:24:59,153: INFO werkzeug: 10.4.0.1 - - [19/Nov/2018 19:24:59]
"GET /dashboard/session_stats/1 HTTP/1.1" 200 -
2018-11-19 19:24:59,541: SQL pgadmin: Execute (dict) for server #1 -
DB:db_dev (Query-id: 830434):
/*pga4dash*/
SELECT
(SELECT count(*) FROM pg_stat_activity) AS "Total",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'active') AS
"Active",
(SELECT count(*) FROM pg_stat_activity WHERE state = 'idle') AS "Idle"
2018-11-19 19:24:59,650: INFO werkzeug: 10.4.0.1 - - [19/Nov/2018 19:24:59]
"GET /dashboard/session_stats/1 HTTP/1.1" 200 -
2018-11-19 19:24:59,805: SQL pgadmin: Execute (dict) for server #1 -
DB:db_dev (Query-id: 6400046):
/*pga4dash*/
SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
2018-11-19 19:24:59,808: SQL pgadmin: Execute (dict) for server #1 -
DB:db_dev (Query-id: 9964067):
/*pga4dash*/
SELECT
(SELECT sum(blks_read) FROM pg_stat_database) AS "Reads",
(SELECT sum(blks_hit) FROM pg_stat_database) AS "Hits"
2018-11-19 19:24:59,809: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:24:59] "GET /dashboard/tps_stats/1 HTTP/1.1" 302 -
2018-11-19 19:24:59,839: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:24:59] "GET /dashboard/ti_stats/1 HTTP/1.1" 401 -
2018-11-19 19:25:00,035: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:00] "GET /dashboard/bio_stats/1 HTTP/1.1" 200 -
2018-11-19 19:25:00,036: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:00] "GET /dashboard/to_stats/1 HTTP/1.1" 200 -
2018-11-19 19:25:00,590: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:00] "GET /dashboard/session_stats/1 HTTP/1.1" 401 -
2018-11-19 19:25:00,596: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:00] "GET /dashboard/tps_stats/1 HTTP/1.1" 401 -
2018-11-19 19:25:00,601: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:00] "GET /dashboard/ti_stats/1 HTTP/1.1" 401 -
2018-11-19 19:25:00,607: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:00] "GET /dashboard/to_stats/1 HTTP/1.1" 401 -
2018-11-19 19:25:00,668: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:00] "GET /dashboard/bio_stats/1 HTTP/1.1" 401 -
2018-11-19 19:25:01,590: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:01] "GET /dashboard/session_stats/1 HTTP/1.1" 401 -
2018-11-19 19:25:01,597: INFO werkzeug: 10.156.0.6 - - [19/Nov/2018
19:25:01] "GET /dashboard/tps_stats/1 HTTP/1.1" 401 -
```
After some time it just stay without authorization as in log above.
Could anyone help me to find workaround, please?
Any suggestions in this situation?
Thank you in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrey Zhidenkov | 2018-11-20 03:58:43 | Can long-running VACUUM be interrupted? |
Previous Message | Achilleas Mantzios | 2018-11-19 19:03:49 | Re: logging aql queries only one table or tables of one scheme |