Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0D8739FB8DD for ; Mon, 9 Jul 2007 22:09:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 99013-07 for ; Mon, 9 Jul 2007 22:08:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 522C89FB8A7 for ; Mon, 9 Jul 2007 22:09:07 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d32so2655385pye for ; Mon, 09 Jul 2007 18:09:05 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=IsxGwJd7bs97XD0O3dGFrKaR7DrcUwoa9otsdhC9KAE0z+JrmpdERop5ystvyrSysw/BUGLx2t0upmYdhR7+whz+Ra/7jZPu9aidAJmX0X/co8qA6Wl4iHaUEOjmH9waD7Igv3aBBFY/HdvdLy5sCY/JBN6ATkdB6qmdn6IUIbo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=tjd1Y9qLNkY/2oJLXOcW21K3GjrlEV9wbMblpIXBs5hNX7THL6hezH/0yvSBV4nIm0BVZ+1Bwm94KppyRP8x0FUJeDC0E/ZNNSuduOI1MXaIhJG/HqU4Bw+2u865SF+agpljDijUfijKPOoYJgi00uHDcrAHm02EeNTA/4Y/K5k= Received: by 10.35.115.18 with SMTP id s18mr7536010pym.1184029745905; Mon, 09 Jul 2007 18:09:05 -0700 (PDT) Received: from ?24.177.122.57? ( [24.177.122.57]) by mx.google.com with ESMTP id 17sm55357457nzo.2007.07.09.18.09.02 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 09 Jul 2007 18:09:03 -0700 (PDT) Message-ID: <4692DC2C.3080903@gmail.com> Date: Mon, 09 Jul 2007 20:09:00 -0500 From: Peter Koczan User-Agent: Thunderbird 2.0.0.4 (X11/20070619) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: local kerberos authentication? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/76 X-Sequence-Number: 26057 Hi all, I would like to, but can't seem to get Kerberos working for local connections. Here are the last few lines of my pg_hba.conf # TYPE DATABASE USER IP-ADDRESS IP_MASK METHOD local all all krb5 hostssl all all 128.105.0.0 255.255.0.0 krb5 hostssl all all 198.133.224.0 255.255.255.0 krb5 Here's what trying to connect got me (first locally, then via the network and SSL). [koczan@mitchell(1)] ~ $ psql postgres psql: FATAL: missing or erroneous pg_hba.conf file HINT: See server log for details. [koczan@mitchell(2)] ~ $ psql -h mitchell -p 5432 postgres psql: FATAL: missing or erroneous pg_hba.conf file HINT: See server log for details. And here are the last few lines of the server log. Jul 9 19:58:16 mitchell postgres[10730]: [2-1] LOG: connection received: host=mitchell.cs.wisc.edu port=53829 Jul 9 19:58:16 mitchell postgres[10730]: [3-1] LOG: missing field in file "/scratch.1/postgres/testing-8.2/pg_hba.conf" at end of line 69 Jul 9 19:58:16 mitchell postgres[10730]: [4-1] FATAL: missing or erroneous pg_hba.conf file Jul 9 19:58:16 mitchell postgres[10730]: [4-2] HINT: See server log for details. Jul 9 19:58:16 mitchell postgres[10731]: [2-1] LOG: connection received: host=mitchell.cs.wisc.edu port=53830 Jul 9 19:58:16 mitchell postgres[10731]: [3-1] LOG: missing field in file "/scratch.1/postgres/testing-8.2/pg_hba.conf" at end of line 69 Jul 9 19:58:16 mitchell postgres[10731]: [4-1] FATAL: missing or erroneous pg_hba.conf file Jul 9 19:58:16 mitchell postgres[10731]: [4-2] HINT: See server log for details. If I change the method to trust, it works, so it looks like krb5 isn't supported for local connections, at least not on the surface. I'd also like to get away from trust authentication because of the wonderful security problems it entails. Has anyone done this? Is this even possible? It's not a huge deal if it can't be done, but I'd like to know. Peter