Re: PostgreSQL GSSAPI Windows AD

2023-05-26 Thread Jean-Philippe Chenel
6 mai 2023 12:09 À : Jean-Philippe Chenel Objet : Re: PostgreSQL GSSAPI Windows AD Hi, are you sure that there is no other ad account mapped to the postgres/ubuntu.ad.corp@ad.corp.com<mailto:ubuntu.ad.corp@ad.corp.com> principal ? Also you should check that the kvnos of both your

PostgreSQL GSSAPI Windows AD

2023-05-25 Thread Jean-Philippe Chenel
Hi, I've recently updated from PostgreSQL 9.6 to 14 and also ubuntu 16.04 to 22.04. I've made all the installation required for postgresql to connect in GSSAPI authentication to a Windows domain. Something is going wrong and I don't know why. When I change the mapped user password from

Re: Both side privileges

2020-07-14 Thread Jean-Philippe Chenel
Thank for your answer David. This is what I'll do. De : David G. Johnston Envoyé : 13 juillet 2020 19:46 À : Jean-Philippe Chenel Cc : pgsql-general@lists.postgresql.org Objet : Re: Both side privileges On Mon, Jul 13, 2020 at 4:42 PM Jean-Philippe Chenel

Both side privileges

2020-07-13 Thread Jean-Philippe Chenel
Hi, I try to give userA privileges on userB objects and same thing to the userB, giving privileges on userA objects. Grant userB to userA; —ok Grant userA to userB; —error: role userB is already member of role userA How can I do that? With best regards,

RE: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-29 Thread Jean-Philippe Chenel
phen Frost Envoyé : 29 avril 2019 13:35 À : Jean-Philippe Chenel Cc : pgsql-general@lists.postgresql.org Objet : Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam Greetings, * Jean-Philippe Chenel (jp.che...@live.ca) wrote: > If I understand, the mappin

RE: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-29 Thread Jean-Philippe Chenel
Dear Stephen, If I understand, the mapping can be done in the pg_ident.conf file ? Thank you very much for your workaround, Jean-Philippe De : Stephen Frost Envoyé : 29 avril 2019 10:22 À : Jean-Philippe Chenel Cc : pgsql-general@lists.postgresql.org Objet

9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-26 Thread Jean-Philippe Chenel
Hi, Currently, when I make select version(), this version is installed. PostgreSQL 9.6.9 on x86_64-pc-linux-gnu (Ubuntu 9.6.9-2.pgdg16.04+1), compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9) 5.4.0 20160609, 64-bit The database is running on the installation of Ubuntu 16.04 x64 I've

RE: PostgreSQL (linux) configuration with GSSAPI to a Windows domain

2019-03-01 Thread Jean-Philippe Chenel
very well from the clients! Also, I've enabled the krb_caseins_users parameter and the time synchronization to the AD. With best regards, De : Stephen Frost Envoyé : 1 mars 2019 11:54 À : Jean-Philippe Chenel Cc : pgsql-general@lists.postgresql.org Objet : Re

PostgreSQL (linux) configuration with GSSAPI to a Windows domain

2019-02-28 Thread Jean-Philippe Chenel
I'm trying to configure authentication between PostgreSQL database server on linux and Windows Active Directory. First part of configuration is working but when I'm trying to authenticate from Windows client, it is not working with message: Can't obtain database list from the server. SSPI