AD Authentication PgAdmin Web

[Karsten Lenz (KLE)]

Hello,

We have AD Authentication running, but one Problem, how can we configure 
PgAdmin Web that user names accepted in lower case?

Regards

Karsten Lenz | Consultant OpenInfra
Phone: +41 44 422 96 02 | Mobile: +41 78 799 0146

dbi services, Flurstrasse 30, CH-8048 Zürich
karsten.l...@dbi-services.com
www.dbi-services.com

[signature_371087102]

authentication fail

[Michael Eschweiler]

Hi there,

I am using postgresql 12 on Linux opensuse Leap 15.2.
In 'former times' with my postgresql-db I used pgadmin3. It was nice and
tiny, and I was happy.
Now, with pgadmin4 I am not able to connect to my server. There is no
problem with pgsql nor with knoda even from another computer but with
pgadmin4 I always get an authentication error. In pg_hba.conf I changed
all connections to 'trust' - but no way!
Is there a verbose-mode for pgadmin4 in order to see what is happening?

Thanks in advance.
Best regards,
Michael

By the way: Is there a way to get rid of this annoying nag screen
telling me every time I start pgadmin that there is a new version? My
version came with the distro

Re: authentication fail

[Khushboo Vashi]

Hi,

On Tue, Jan 12, 2021 at 12:39 AM Michael Eschweiler <
michael.eschwei...@web.de> wrote:

> Hi there,
>
> I am using postgresql 12 on Linux opensuse Leap 15.2.
> In 'former times' with my postgresql-db I used pgadmin3. It was nice and
> tiny, and I was happy.
> Now, with pgadmin4 I am not able to connect to my server. There is no
> problem with pgsql nor with knoda even from another computer but with
> pgadmin4 I always get an authentication error. In pg_hba.conf I changed
> all connections to 'trust' - but no way!
> Is there a verbose-mode for pgadmin4 in order to see what is happening?
>
> It should work with pgAdmin as you have no problem with psql.
You can enable logging to check the issue, please refer
https://www.pgadmin.org/faq/#8 to enable it.
Also, you can provide the screen-shot of the error you are getting, so we
can help you.


> Thanks in advance.
> Best regards,
> Michael
>
> By the way: Is there a way to get rid of this annoying nag screen
> telling me every time I start pgadmin that there is a new version? My
> version came with the distro
>
You can disable the version check by setting UPGRADE_CHECK_ENABLED
parameter to False, refer
https://www.pgadmin.org/docs/pgadmin4/4.29/config_py.html for the. same.

Thanks,
Khushboo

Re: AD Authentication PgAdmin Web

[Khushboo Vashi]

Hi,

On Mon, Jan 11, 2021 at 6:41 PM Karsten Lenz (KLE) <
karsten.l...@dbi-services.com> wrote:

> Hello,
>
>
>
> We have AD Authentication running, but one Problem, how can we configure
> PgAdmin Web that user names accepted in lower case?
>
>
>
This issue has already been logged. Ref:
https://redmine.postgresql.org/issues/5836

Thanks,
Khushboo

> Regards
>
>
>
> *Karsten Lenz* | Consultant OpenInfra
>
> Phone: +41 44 422 96 02 | Mobile: +41 78 799 0146
>
> dbi services, Flurstrasse 30, CH-8048 Zürich
>
> karsten.l...@dbi-services.com 
> www.dbi-services.com
>
>
>
> [image: signature_371087102]
>
>
>