Hi, Could you please share config_local.py settings? Which authentication mode are you using?
Thanks, Yogesh Mahajan EnterpriseDB On Tue, Apr 18, 2023 at 7:23 PM Aruna Manivannan <aruna.manivan...@gmail.com> wrote: > Hi Yogesh, > Please find the attached config file which we are using . > The issue which we are facing is exactly the same as it is described in > this thread > <https://github.com/pgadmin-org/pgadmin4/issues/5567#issuecomment-1508777189> > and my team member Eoghan also commented on the same. > > Below are the parameters that were modified according to our needs , rest > were all the same default values only. > > # Number of values to trust for X-Forwarded-For > > PROXY_X_FOR_COUNT = 1 > > # Number of values to trust for X-Forwarded-Proto. > > PROXY_X_PROTO_COUNT = 1 > > # Number of values to trust for X-Forwarded-Host. > > PROXY_X_HOST_COUNT = 1 > > # Number of values to trust for X-Forwarded-Port. > > PROXY_X_PORT_COUNT = 0 > > # Number of values to trust for X-Forwarded-Prefix. > > PROXY_X_PREFIX_COUNT = 0 > > > USER_INACTIVITY_TIMEOUT = 900 > > ENHANCED_COOKIE_PROTECTION = False > > > > Regards, > Arun > > On Tue, Apr 18, 2023 at 7:23 AM Dave Page <dp...@pgadmin.org> wrote: > >> >> >> On Tue, 18 Apr 2023 at 12:08, Yogesh Mahajan < >> yogesh.maha...@enterprisedb.com> wrote: >> >>> Hi, >>> >>> Could you please share your pgAdmin config setting? >>> >> >> FYI, the /misc/ping endpoint is CSRF-exempt. >> >> >>> >>> Thanks, >>> Yogesh Mahajan >>> EnterpriseDB >>> >>> >>> On Fri, Apr 14, 2023 at 8:45 PM Aruna Manivannan < >>> aruna.manivan...@gmail.com> wrote: >>> >>>> Hi Yogesh, >>>> Thanks for your reply. Please find the attached log file. The log >>>> entries keep repeating so given the portion of them. >>>> Sending it to you alone due to security reasons. >>>> FYI we have the parameter ENHANCED_COOKIE_PROTECTION = false to avoid >>>> CSRF token issue, but it seems to be ignored. >>>> Thanks. >>>> >>>> >>>> Regards, >>>> Arun >>>> >>>> On Fri, Apr 14, 2023 at 5:33 AM Yogesh Mahajan < >>>> yogesh.maha...@enterprisedb.com> wrote: >>>> >>>>> Hi, >>>>> >>>>> Could you please complete the logs from the container? I suspect those >>>>> errors are because of CSRF token errors. >>>>> >>>>> >>>>> Thanks, >>>>> Yogesh Mahajan >>>>> EnterpriseDB >>>>> >>>>> >>>>> On Thu, Apr 13, 2023 at 11:04 PM Aruna Manivannan < >>>>> aruna.manivan...@gmail.com> wrote: >>>>> >>>>>> Hi Yogesh / pgadmin-support team, >>>>>> Have set up the liveness probe as suggested by you. However, It is >>>>>> now super helpful. The problem I am facing is though the /misc/ping is >>>>>> giving 200 status, I received complaints from users that they cant access >>>>>> pgadmin. >>>>>> When I checked the logs, I noticed that /sqleditor/status/<some >>>>>> number> is 500 & 503. I guess the number could be session ID or something >>>>>> not sure. Please find the below log message >>>>>> >>>>>> [::ffff:<private_ip_address> - - [13/Apr/2023:16:28:13 +0000] "GET >>>>>> /misc/ping HTTP/1.1" 200 4 "-" "kube-probe/1.24+" >>>>>> ::ffff:<private_ip_address> - - [13/Apr/2023:16:28:13 +0000] "GET >>>>>> /misc/ping HTTP/1.1" 200 4 "-" "kube-probe/1.24+" >>>>>> <public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET >>>>>> /sqleditor/status/4397343 HTTP/1.1" 500 103 " >>>>>> https://pgadmin-url/sqleditor/panel/4397343?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" >>>>>> "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 >>>>>> Firefox/112.0" >>>>>> <public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET >>>>>> /sqleditor/status/9414096 HTTP/1.1" 503 100 " >>>>>> https://pgadmin-url/sqleditor/panel/9414096?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" >>>>>> "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 >>>>>> Firefox/112.0" >>>>>> <public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET >>>>>> /sqleditor/status/9414096 HTTP/1.1" 503 100 " >>>>>> https://pgadmin-url/sqleditor/panel/9414096?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" >>>>>> "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 >>>>>> Firefox/112.0" >>>>>> <public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET >>>>>> /sqleditor/status/9414096 HTTP/1.1" 503 100 " >>>>>> https://pgadmin-url/sqleditor/panel/9414096?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" >>>>>> "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 >>>>>> Firefox/112.0 >>>>>> >>>>>> Later I restarted the pgadmin pod to get rid of this issue. Could you >>>>>> please explain what exactly is happening and how to fix it ? Thanks. >>>>>> >>>>>> Regards, >>>>>> Arun >>>>>> >>>>>> On Tue, Apr 11, 2023 at 10:42 AM Aruna Manivannan < >>>>>> aruna.manivan...@gmail.com> wrote: >>>>>> >>>>>>> Hi Yogesh, >>>>>>> Thanks for your response. Will use it and let you know the result. >>>>>>> Thank you again. >>>>>>> >>>>>>> Regards, >>>>>>> Arun >>>>>>> >>>>>>> On Tue, Apr 11, 2023 at 1:58 AM Yogesh Mahajan < >>>>>>> yogesh.maha...@enterprisedb.com> wrote: >>>>>>> >>>>>>>> Hi Aruna, >>>>>>>> >>>>>>>> You can use 'misc/ping' to monitor health checks. >>>>>>>> E.g. >>>>>>>> >>>>>>>> pgadmin: >>>>>>>> image: dpage/pgadmin4 >>>>>>>> healthcheck: >>>>>>>> test: ["CMD", "wget", "-O", "-", "http://localhost:80/misc/ping";] >>>>>>>> >>>>>>>> >>>>>>>> Thanks, >>>>>>>> Yogesh Mahajan >>>>>>>> EnterpriseDB >>>>>>>> >>>>>>>> >>>>>>>> On Tue, Apr 11, 2023 at 2:20 AM Aruna Manivannan < >>>>>>>> aruna.manivan...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi Team, >>>>>>>>> This is Arun. Could you please help me with setting up a Liveness >>>>>>>>> & Readiness probe for pgadmin4 6.17 which is running in the Kubernetes >>>>>>>>> cluster as Statefulset. I mean, is there any URL endpoint which I can >>>>>>>>> configure to hit? Thanks. >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> Arun >>>>>>>>> >>>>>>>> >> >> -- >> Dave Page >> Blog: https://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EDB: https://www.enterprisedb.com >> >>
