pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Matthew Dennison <mail@matty-uk.co.uk>
Cc: Rob Sargent <robjsargent@gmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working
Date: Tue, 5 Mar 2024 13:16:38 -0500
Message-ID: <ZedhhoAsKdmSPT7k@tamriel.snowman.net> (raw)
In-Reply-To: <AS2P191MB23274D98B9B313D33B49C51AA75E2@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM>
References: <AS2P191MB2327A6A91D12608E0E3E9403A7552@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM>
	<ZdznbUoY3HjE9qH1@tamriel.snowman.net>
	<AS2P191MB23272C17F525B660638434E4A7582@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM>
	<Zd9pSzNUZyJ64U3a@tamriel.snowman.net>
	<E65D37C9-D2F2-48FE-9B16-534CB32E25F0@matty-uk.co.uk>
	<Zd982SF3w/8sD74o@tamriel.snowman.net>
	<AS2P191MB2327F703E51AC247B35431A2A75F2@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM>
	<32d6a0ce-2c5a-423b-be54-be1d12b4080a@gmail.com>
	<AS2P191MB23274D98B9B313D33B49C51AA75E2@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM>

Greetings,

* Matthew Dennison (mail@matty-uk.co.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

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (11+ messages)

Message-ID: <ZedhhoAsKdmSPT7k@tamriel.snowman.net>
Permalink:  ../ZedhhoAsKdmSPT7k@tamriel.snowman.net/
Also on:    postgresql.org/message-id/ZedhhoAsKdmSPT7k@tamriel.snowman.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: sfrost@snowman.net, mail@matty-uk.co.uk, robjsargent@gmail.com
  Subject: Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working
  In-Reply-To: <ZedhhoAsKdmSPT7k@tamriel.snowman.net>
  References: <AS2P191MB2327A6A91D12608E0E3E9403A7552@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM> <ZdznbUoY3HjE9qH1@tamriel.snowman.net> <AS2P191MB23272C17F525B660638434E4A7582@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM> <Zd9pSzNUZyJ64U3a@tamriel.snowman.net> <E65D37C9-D2F2-48FE-9B16-534CB32E25F0@matty-uk.co.uk> <Zd982SF3w/8sD74o@tamriel.snowman.net> <AS2P191MB2327F703E51AC247B35431A2A75F2@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM> <32d6a0ce-2c5a-423b-be54-be1d12b4080a@gmail.com> <AS2P191MB23274D98B9B313D33B49C51AA75E2@AS2P191MB2327.EURP191.PROD.OUTLOOK.COM> <ZedhhoAsKdmSPT7k@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox