pgAdmin translation (Ukrainian language)

2022-04-14 Thread Bogdan 
Hello here,I want to add/support Ukrainian language for pgAdmin.Please confirm that it will be added from your side.Thank you in advance.--Best regards,Bogdan Kobets

Re: pgAdmin Docker container: specify web URL path prefix?

2022-04-14 Thread Glen Bakeman 
For anyone watching this: I've made an issue 
 to track updating the docs. 
If someone can give me the OK I'll go and get it done.


Glen

On 4/13/2022 11:40 AM, Glen Bakeman wrote:


Of course! My docker labels are as follows:

- "traefik.http.routers.pgadmin4.rule=Host(`host.example.com`) && 
PathPrefix(`/pgadmin4`)"

- "traefik.http.routers.pgadmin4.tls=true"

This assumes that the chosen name for the instance is "pgadmin4", 
which is entirely up the user. The Host portion was necessary because 
Traefik will complain otherwise about a lack of specificity in the 
rule. I also added the .tls line since Traefik will only forward 
insecure requests without it (not sure why yet). Otherwise, Traefik is 
able to automatically identify the necessary port on the service to 
communicate with. I added the SCRIPT_NAME environment variable which 
seemed to be the key I was missing.


Thanks again for your help,

Glen

On 4/12/2022 10:19 PM, Yogesh Mahajan wrote:

Glad to hear it!
Can you please share what additional steps are required?

Thanks,
Yogesh Mahajan
EnterpriseDB


On Wed, Apr 13, 2022 at 7:49 AM Glen Bakeman  wrote:

Yogesh,

Not only was my DuckDuckGo-fu failing me, I didn't even get to
the bottom of the page...

I had to make a few small tweaks since I'm on Traefikv2, but I'd
be happy to update the documentation. Thank you for putting me in
the right direction!

Glen

On 4/11/2022 9:11 PM, Yogesh Mahajan wrote:

Hi Glen,

Please refer to the last point at this

web-page for hosting pgadmin4 under subdirectory with Traefik.
Here is example when pgadmin4 is hosted under /pgadmin4/
docker run --name"pgadmin4"  \
 -e"PGADMIN_DEFAULT_EMAIL=u...@domain.com"  \
 -e"PGADMIN_DEFAULT_PASSWORD=SuperSecret"  \
 -e"SCRIPT_NAME=/pgadmin4"  \
 -l"traefik.frontend.rule=PathPrefix:/pgadmin4"  \
 -d dpage/pgadmin4

Thanks,
Yogesh Mahajan
EnterpriseDB


On Tue, Apr 12, 2022 at 6:23 AM Glen Bakeman 
wrote:

Hi everyone,

I'm getting into containerized hosting, and I'd like to
setup the
pgAdmin docker container with a reverse proxy (Traefik).
Traefik
supports Path Prefix proxying for services (i.e, I'd like to
access
pgAdmin at host.example.com/pgadmin/
). The issue seems to be that
pgAdmin automatically rewrites requests to
host.example.com/login , which
breaks the proxy.

I can't seem to find any options that allow us to specify
the web path
pgAdmin uses, from the perspective of configuring the docker
container.
Can anyone please confirm this?

Thanks in advance,

Glen

Re: pgAdmin Docker container: specify web URL path prefix?

2022-04-14 Thread Glen Bakeman 

Of course! My docker labels are as follows:

- "traefik.http.routers.pgadmin4.rule=Host(`host.example.com`) && 
PathPrefix(`/pgadmin4`)"

- "traefik.http.routers.pgadmin4.tls=true"

This assumes that the chosen name for the instance is "pgadmin4", which 
is entirely up the user. The Host portion was necessary because Traefik 
will complain otherwise about a lack of specificity in the rule. I also 
added the .tls line since Traefik will only forward insecure requests 
without it (not sure why yet). Otherwise, Traefik is able to 
automatically identify the necessary port on the service to communicate 
with. I added the SCRIPT_NAME environment variable which seemed to be 
the key I was missing.


Thanks again for your help,

Glen

On 4/12/2022 10:19 PM, Yogesh Mahajan wrote:

Glad to hear it!
Can you please share what additional steps are required?

Thanks,
Yogesh Mahajan
EnterpriseDB


On Wed, Apr 13, 2022 at 7:49 AM Glen Bakeman  wrote:

Yogesh,

Not only was my DuckDuckGo-fu failing me, I didn't even get to the
bottom of the page...

I had to make a few small tweaks since I'm on Traefikv2, but I'd
be happy to update the documentation. Thank you for putting me in
the right direction!

Glen

On 4/11/2022 9:11 PM, Yogesh Mahajan wrote:

Hi Glen,

Please refer to the last point at this

web-page for hosting pgadmin4 under subdirectory with Traefik.
Here is example when pgadmin4 is hosted under /pgadmin4/
docker run --name"pgadmin4"  \
 -e"PGADMIN_DEFAULT_EMAIL=u...@domain.com"  \
 -e"PGADMIN_DEFAULT_PASSWORD=SuperSecret"  \
 -e"SCRIPT_NAME=/pgadmin4"  \
 -l"traefik.frontend.rule=PathPrefix:/pgadmin4"  \
 -d dpage/pgadmin4

Thanks,
Yogesh Mahajan
EnterpriseDB


On Tue, Apr 12, 2022 at 6:23 AM Glen Bakeman 
wrote:

Hi everyone,

I'm getting into containerized hosting, and I'd like to setup
the
pgAdmin docker container with a reverse proxy (Traefik). Traefik
supports Path Prefix proxying for services (i.e, I'd like to
access
pgAdmin at host.example.com/pgadmin/
). The issue seems to be that
pgAdmin automatically rewrites requests to
host.example.com/login , which
breaks the proxy.

I can't seem to find any options that allow us to specify the
web path
pgAdmin uses, from the perspective of configuring the docker
container.
Can anyone please confirm this?

Thanks in advance,

Glen

Azure AD authentication using app registration

2022-04-14 Thread Asmita Thapliyal 
Hello!

I don't see Azure AD authentication using app registration is available for
pgadmin4. I see other authentication mechanisms via LDAP, OAUTH2 and
kerberos.
Could you let me know if there is a possibility of enabling it?

Regards,
Asmita

Re: Azure AD authentication using app registration

2022-04-14 Thread Dave Page 
Hi

On Thu, 14 Apr 2022 at 09:35, Asmita Thapliyal 
wrote:

> Hello!
>
> I don't see Azure AD authentication using app registration is
> available for pgadmin4. I see other authentication mechanisms via LDAP,
> OAUTH2 and kerberos.
> Could you let me know if there is a possibility of enabling it?
>

We don't support Azure AD auth, and currently have no plans to add it.
You're welcome to add a feature request at
https://redmine.postgresql.org/projects/pgadmin4/issues, but it's unlikely
any of the regular developers will work on it in the near future.

However, you can (in theory - I've never tested it) use Azure Active
Directory Domain Services to allow applications to authenticate using
Kerberos. See
https://techcommunity.microsoft.com/t5/itops-talk-blog/deep-dive-how-azure-ad-kerberos-works/ba-p/3070889


-- 
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

Re: pgAdmin translation (Ukrainian language)

2022-04-14 Thread Akshay Joshi 
Hi Bogdan

Please go through the links below to add support for a new language.

https://www.pgadmin.org/development/translations/
https://www.pgadmin.org/docs/pgadmin4/development/translations.html

On Thu, Apr 14, 2022 at 2:04 PM Bogdan  wrote:

> Hello here,
>
> I want to add/support Ukrainian language for pgAdmin.
>

> Please confirm that it will be added from your side.
>

   We can add it.

>
> Thank you in advance.
>
> --
> Best regards,
> Bogdan Kobets
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*