pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgadmin4 - session timeout problem in browser 2+ messages / 2 participants [nested] [flat]
* pgadmin4 - session timeout problem in browser @ 2018-11-19 20:25 Bogdan Yakovenko <bogdan.yakovenko@serverbee.net> 0 siblings, 1 reply; 2+ messages in thread From: Bogdan Yakovenko @ 2018-11-19 20:25 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgadmin4 - session timeout problem in browser @ 2018-11-20 09:37 Stéphane KANSCHINE <stephane@hexack.fr> parent: Bogdan Yakovenko <bogdan.yakovenko@serverbee.net> 0 siblings, 0 replies; 2+ messages in thread From: Stéphane KANSCHINE @ 2018-11-20 09:37 UTC (permalink / raw) To: Bogdan Yakovenko <bogdan.yakovenko@serverbee.net>; +Cc: pgsql-admin@lists.postgresql.org Le lun. 19 nov., vers 21:25, Bogdan Yakovenko exprimait : > Hi all! Hi, > 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. Please use the dedicated mailing list, as mentioned on pgadmin website: https://www.pgadmin.org/support/ Regards, -- Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./ ＠ stephane@hexack.fr +33 6 64 31 72 52 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-11-20 09:37 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-11-19 20:25 pgadmin4 - session timeout problem in browser Bogdan Yakovenko <bogdan.yakovenko@serverbee.net> 2018-11-20 09:37 ` Stéphane KANSCHINE <stephane@hexack.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox