any update in sharing my query ? On Wed, Apr 19, 2023 at 11:28 PM Anitha P <85ani...@gmail.com> wrote:
> Hello All, > I have question about authentication same like AD groups in SQL server > database. (db1 => ad group => reader or writer to specific schema) > Is it possible in postgresql with similar structure using pg_ldap_sync? > > Regards, > Anitha P. > > On Tue, Apr 18, 2023 at 4:38 PM Yogesh Mahajan < > yogesh.maha...@enterprisedb.com> wrote: > >> 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.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 >>>>>>>> >>>>>>>
