Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A2CBF9FB1F8 for ; Tue, 10 Jul 2007 07:15:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 49046-08 for ; Tue, 10 Jul 2007 07:14:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from tamriel.snowman.net (tamriel.snowman.net [72.66.115.51]) by postgresql.org (Postfix) with ESMTP id 4D6389FB58C for ; Tue, 10 Jul 2007 07:14:58 -0300 (ADT) Received: by tamriel.snowman.net (Postfix, from userid 1000) id EEA978411D; Tue, 10 Jul 2007 06:14:56 -0400 (EDT) Date: Tue, 10 Jul 2007 06:14:56 -0400 From: Stephen Frost To: Peter Koczan Cc: pgsql-admin@postgresql.org Subject: Re: local kerberos authentication? Message-ID: <20070710101456.GZ4887@tamriel.snowman.net> Mail-Followup-To: Peter Koczan , pgsql-admin@postgresql.org References: <4692DC2C.3080903@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="3C3ZMpwu25Mtx3MN" Content-Disposition: inline In-Reply-To: <4692DC2C.3080903@gmail.com> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.6.21-2-amd64 (x86_64) X-Uptime: 06:10:58 up 8 days, 19:35, 14 users, load average: 0.11, 0.13, 0.09 User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/81 X-Sequence-Number: 26062 --3C3ZMpwu25Mtx3MN Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Peter Koczan (pjkoczan@gmail.com) wrote: > If I change the method to trust, it works, so it looks like krb5 isn't=20 > supported for local connections, at least not on the surface. I'd also li= ke=20 > to get away from trust authentication because of the wonderful security= =20 > problems it entails. 'local' in this case means 'unix socket'. Kerberos does a reverse-DNS lookup on the IP address it's going to connect to in order to figure out what service princ to ask the KDC for. That doesn't work for unix sockets. > Has anyone done this? Is this even possible? It's not a huge deal if it= =20 > can't be done, but I'd like to know. Can't be done as far as I'm aware because Kerberos doesn't know what princ to use. I'm not sure if any of the Kerberos folks have really looked into making it work, it might be possible to just use the fqdn or some such. You might google around for 'kerberos over unix sockets' or ask folks on the Kerberos lists. Thanks, Stephen --3C3ZMpwu25Mtx3MN Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGk1wgrzgMPqB3kigRAn42AJ4qvedQuJAlxn31vvj7OfdDMqKdtwCggIFq LXV4Yrwk0yrsz8XLRSL4eyM= =SApV -----END PGP SIGNATURE----- --3C3ZMpwu25Mtx3MN--