Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 0E2DC2E0054 for ; Thu, 17 Apr 2008 13:40:28 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96367-06 for ; Thu, 17 Apr 2008 13:40:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.237]) by developer.postgresql.org (Postfix) with ESMTP id 991B12E0044 for ; Thu, 17 Apr 2008 13:40:24 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 76so134258wra.10 for ; Thu, 17 Apr 2008 09:40:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=SuJfEXTRf6svVSuW/MbY0hqo6ClzmUpALmWEBaZzTSk=; b=esRhVFA0bSeus543KHb3E2x59y7VxrwmQZa139/Blq3SbhpUXpqa/1j2ENJQO8TbPvJXfDHSu+ZheFbXPfgJL7dqc/nJYIsk21meQDFqYocfmim21rB+1nM3TPRll+1A4vGznBIyLyiQPEpE9wSXGdK7UWiAh/t1nWwSr05eAzM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=vPn/88rBP3T+z+mlbhoqWObBCSReC729R4SNRKntleqQu8X0cq6zl0YLLH2ExXEEa5RNAdxEPbp6hnIzfUe6dzmjmTVnJ93VdqLfytFCJhOTnSvheuAgWF4EiwgADIfwTFUCYVwLvamGXbFv13PGm1HZi0Xadi5PANmZwz+U9DY= Received: by 10.114.159.1 with SMTP id h1mr1714503wae.147.1208450422395; Thu, 17 Apr 2008 09:40:22 -0700 (PDT) Received: by 10.114.199.20 with HTTP; Thu, 17 Apr 2008 09:40:22 -0700 (PDT) Message-ID: <4544e0330804170940j45035b17s42071d7b2358ae80@mail.gmail.com> Date: Thu, 17 Apr 2008 11:40:22 -0500 From: "Peter Koczan" To: "pgsql-admin@postgresql.org" Subject: PG 8.3 and kerberos failures MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/178 X-Sequence-Number: 28942 Hi all, I just upgraded one of my servers and I'm having a bit of trouble getting some of the kerberos authentication bits working. Specifically, any Kerberos instance run out of a v5srvtab doesn't work so well. Using stashed tickets or normal principals worked fine. Gritty details follow. Peter Here are details from the specific v5srvtab's... [root@sensei postgres]# klist -k -t /etc/v5srvtab.wsbackup Keytab name: FILE:/etc/v5srvtab.wsbackup KVNO Timestamp Principal ---- ----------------- -------------------------------------------------------- 13 12/20/07 15:56:11 wsbackup/sensei.cs.wisc.edu@CS.WISC.EDU [root@sensei postgres]# klist -k -t /etc/v5srvtab Keytab name: FILE:/etc/v5srvtab KVNO Timestamp Principal ---- ----------------- -------------------------------------------------------- 13 12/20/07 15:56:11 host/sensei.cs.wisc.edu@CS.WISC.EDU 13 12/20/07 15:56:11 rcmd/sensei.cs.wisc.edu@CS.WISC.EDU 13 12/20/07 15:56:11 telnet/sensei.cs.wisc.edu@CS.WISC.EDU 13 12/20/07 15:56:11 ftp/sensei.cs.wisc.edu@CS.WISC.EDU 13 12/20/07 15:56:11 pop/sensei.cs.wisc.edu@CS.WISC.EDU 13 12/20/07 15:56:11 wsbackup/sensei.cs.wisc.edu@CS.WISC.EDU 12 12/20/07 15:56:11 auth/sensei.cs.wisc.edu@CS.WISC.EDU 8 12/20/07 15:56:11 postgres/sensei.cs.wisc.edu@CS.WISC.EDU Here's the error from the syslog... Apr 17 11:18:39 sensei postgres[4486]: [3-1] LOG: connection received: host=mitchell.cs.wisc.edu port=56925 Apr 17 11:18:39 sensei postgres[4486]: [4-1] LOG: unexpected Kerberos user name received from client (received "wsbackup", expected "wsbackup/mitchell.cs.wisc.edu") Apr 17 11:18:39 sensei postgres[4486]: [5-1] FATAL: Kerberos 5 authentication failed for user "wsbackup" Apr 17 11:18:39 sensei postgres[4488]: [3-1] LOG: connection received: host=mitchell.cs.wisc.edu port=56926 Apr 17 11:18:39 sensei postgres[4488]: [4-1] FATAL: no pg_hba.conf entry for host "128.105.207.19", user "wsbackup", database "sushi", SSL off Here's the relevant bit from my pg_hba.conf. For compatibility, I'm using krb5 instead of gss until everything is upgraded from 8.2. If using gss authentication will work, please let me know. hostssl all all 128.105.0.0/16 krb5 hostssl all all 198.133.224.0/24 krb5 And from postgresql.conf... # - Security & Authentication - #authentication_timeout = 1min # 1s-600s ssl = on # (change requires restart) #ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # Allowed SSL ciphers # (change requires restart) #password_encryption = on krb_realm = 'CS.WISC.EDU' #db_user_namespace = off # Kerberos and GSSAPI krb_server_keyfile = '/etc/v5srvtab.postgres' # (change requires restart) #krb_srvname = 'postgres' # (change requires restart, kerberos onl y) #krb_server_hostname = '' # empty string matches any keytab entry # (change requires restart, kerberos onl y) #krb_caseins_users = off # (change requires restart)