Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 286091337BD9 for ; Fri, 1 Oct 2010 18:51:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 78452-01-3 for ; Fri, 1 Oct 2010 21:51:26 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web39702.mail.mud.yahoo.com (web39702.mail.mud.yahoo.com [209.191.106.48]) by mail.postgresql.org (Postfix) with SMTP id C74BC1337BAB for ; Fri, 1 Oct 2010 18:50:39 -0300 (ADT) Received: (qmail 6994 invoked by uid 60001); 1 Oct 2010 21:50:38 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1285969838; bh=2S3RywVxquHutt77F2OrkTmiDgmdp8d5z9UPy+jybPg=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=kRLnan99YSw7MKRqFHIJoV+E2CkbNg0+/5fuCDw1nMOlJcfXzVbqZy+4oGCvDmj2se36Ap0Yu7zm/gs65zpA5SLV3BtZOMFVMaWR6Qd0vRJgQ2rR28nVLk7nzceXNyIlQo/eOt5ms2pF5Wbxcu/rD0AXtZCV4L9ukDza2Q/IPLU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=MRqbzo+0zuO2DvHt3UGWARydfOU+Z6ThckAHkRn5xD4Vi8E7DebIKcoQOdw7apjC0ciwC3qdhoBYSsCpUsvHF49JnLE0MjwpH0AJIa1G8v2HFOqHCzTWMsTusP3RKnnUQ7BiW4aDyRTxhrQBTZid8/7YGoMFjQ7kozu0F/e5RfY=; Message-ID: <550788.6989.qm@web39702.mail.mud.yahoo.com> X-YMail-OSG: 3cc1Qe8VM1kHHZ0prZZVol52AvDYwgNObnJZgnojKpClooY gSp5KUHoBBogApFwBwY6e9Vt6kkO_q3dSX5ehVFmOwWikRzaqfdb8kVAMXXs 5qbK2iUI87Cq8BFDKuhY0YseGZfaato3SCaPrKHXKhQGawPOrQkPj7lH9e2H I0zKrB9mHubPrhHiwapCj_GAUPGM69Wh4UpO.Feiou0Zc6ZL70LwsD90Fc91 mcwQMaCPH3XEhRdG1nnfeFBbhQX77sSYjDT1fRABAHwh5qE2MvF1UQVUE6x4 0VUKj3alZZt80yWTTN9FtENR0RYs- Received: from [64.126.29.122] by web39702.mail.mud.yahoo.com via HTTP; Fri, 01 Oct 2010 14:50:38 PDT X-Mailer: YahooMailClassic/11.4.9 YahooMailWebService/0.8.105.279950 Date: Fri, 1 Oct 2010 14:50:38 -0700 (PDT) From: Bob Lunney Subject: GSS for both Windows and Linux To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/20 X-Sequence-Number: 35761 Is it possible to have clients authenticate via Kerberos to a PG 8.4 server running on linux from both linux and windows hosts? I have authentication working (using GSSAPI) between the linux clients and the server. I'd like to use the Windows binary install (which already has GSSAPI compiled in) against the linux-based database server. o Do I need to have separate AD principals for the Windows clients or is it possible for Windows clients to get a ticket granting ticket from the linux-based KDC? o How do I combine the linux and Windows keytab files the server needs to authenticate if separate principals are required? o Since Windows (mis)uses "POSTGRES" and linux uses "postgres" for the service name, do I need to force either one to use the other's service name, since the database server can only use one version? Any pointers will be appreciated. I've scoured Google but can't find the missing piece of information I need to get Windows clients working. Thanks in advance! Bob Lunney