Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Matthew Dennison <mail(at)matty-uk(dot)co(dot)uk>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working
Date: 2024-03-05 18:16:38
Message-ID: ZedhhoAsKdmSPT7k@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Matthew Dennison (mail(at)matty-uk(dot)co(dot)uk) wrote:
> Host file looks like:
>
> 127.0.0.1 localhost hostname hostname.mydomain.net
> ::1 localhost hostname hostname.mydomain.net
> 10.204.50.65 hostname hostname.mydomain.net
>
> I also tried commenting out the ::1 line, but the issue moved to 127.0.0.1, commented that out and the issue moved to the IP. I really don’t get it. However, when I finally realised it was a localised issue (after days) I was able to move forward. No idea why it will not work on the server itself, but it is something I can live with.

Once you got it to just the IP, it was trying to look up 'hostname' not
'hostname.mydomain.net' in the KDC, I suspect, since that's first.
Might be interesting to try it with:

10.204.50.65 hostname.mydomain.net hostname

instead.

I've no doubt that it can be made to work if we get the DNS bits sorted.

Thanks!

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message grimy.outshine830 2024-03-05 18:21:33 Re: pgBadger: Cannot find any log entries from systemd-journald
Previous Message Brecht De Rooms 2024-03-05 12:21:01 Re: CTEs and concurrency