Re: How to set Liveness & Readiness probe for pgadmin running in Kubernetes

Hi,

Could you please share your pgAdmin config setting?

Thanks,
Yogesh Mahajan
EnterpriseDB

On Fri, Apr 14, 2023 at 8:45 PM Aruna Manivannan <aruna(dot)manivannan(at)gmail(dot)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(dot)mahajan(at)enterprisedb(dot)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(dot)manivannan(at)gmail(dot)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(dot)manivannan(at)gmail(dot)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(dot)mahajan(at)enterprisedb(dot)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(dot)manivannan(at)gmail(dot)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
>>>>>>
>>>>>