Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhZLN-00CBZ0-Ag for pgsql-general@arkaria.postgresql.org; Tue, 05 Mar 2024 18:16:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rhZLL-001ZRg-Pj for pgsql-general@arkaria.postgresql.org; Tue, 05 Mar 2024 18:16:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhZLL-001ZRY-4S for pgsql-general@lists.postgresql.org; Tue, 05 Mar 2024 18:16:47 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhZLI-002wAY-91 for pgsql-general@lists.postgresql.org; Tue, 05 Mar 2024 18:16:46 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 7D8335F7B7; Tue, 5 Mar 2024 13:16:38 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=snowman.net; s=dkim; t=1709662598; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=PHgtL7AuvNXYm8aBp+v4rmzZij7q3W+2aFXgbmXDPGY=; b=S1lqb2qteErazjDp0amCD1d4BZjp7u3BBvszUrk3n7hh8aRS2fBKQI7OULf6v6Td2wXx+v HnffN+cGkJThaFhghItr52EqU9LWO/b9SXTAGwfcCA5hHM9pV8zgQsCvDHaUPwdJCc+jvj AK0BWP90itU3nT/2HDqpaPKB+05TXcg= Date: Tue, 5 Mar 2024 13:16:38 -0500 From: Stephen Frost To: Matthew Dennison Cc: Rob Sargent , "pgsql-general@lists.postgresql.org" Subject: Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working Message-ID: References: <32d6a0ce-2c5a-423b-be54-be1d12b4080a@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="aDM59jz4kvXL3C1V" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.1.4 (2021-12-11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --aDM59jz4kvXL3C1V Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Matthew Dennison (mail@matty-uk.co.uk) wrote: > Host file looks like: >=20 > 127.0.0.1 localhost hostname hostname.mydomain.net > ::1 localhost hostname hostname.mydomain.net > 10.204.50.65 hostname hostname.mydomain.net >=20 > 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=E2=80=99= 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 ser= ver 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 --aDM59jz4kvXL3C1V Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmXnYYMACgkQ7WyKOINH ZFV0CBAAru9yYdBKLMj1wuVOm1FmXD+8DNfBowZ3Y3vB6DS3XcBXKif7Gy5BgWUb lUXxzx0tE9zvgL44Bha87TUF+p+NmkfcooDdvL3WLJgg/1sWngvM1uC3nFrWg9eP ziF3Bv60hMO/sLBQPjGEif6PFAVIG/Vl4fhCCByqNAO0Lwj1atE3+4pmGxinAvvg rJWbVp/6qskC+RCZcKarYuTdS1dBTtOEBxnx1Ab9p8mDi52VarLuH7Hrfw7Hg8Hi 4iqJhkf2tZfXO16EF04zt98hh/h7HDa6oHkgKhSbFLNMYzQAS5c39YQxdWzd2N3C EIHev8ZZfB75+n7Az+tJzogx/ogCLCKqIxAKxOHBpYS1NcDSW4vxSChRKNVAGG4m 8nSHq3h4+1iCWKkjvenE3mgbmvY5lbZHMyX8beVGnf5Ula+BvqAXlIX6MZAIXZI0 QLkh6HETEkpvTOP2k2zVy84aeiSV3EeCrt6GKIMbAXm3ZqaBU8EIfpGwM9esnKpR /GCoAnhlIvhj2tdS4aXBYyC2RraPSZSTPVDb60dMNBMMYAtxusf8NK5oG/IXEYoy zoDBAMupk6JS7AgyAdp1iNnQRLDDDm6qequxDKqq5O9tvSY9dZCmJXMcIsiz2nPa RV79rIhaQLkyZclwcdUXOdA/rhKqyMxJ5zZrHCiKASUCiY1/p3c= =04Xl -----END PGP SIGNATURE----- --aDM59jz4kvXL3C1V--