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 >>>>>>> >>>>>>
