Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dIwIR-0003Ne-Pf for pgsql-pkg-yum@arkaria.postgresql.org; Thu, 08 Jun 2017 12:12:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dIwIQ-0000QF-IH for pgsql-pkg-yum@arkaria.postgresql.org; Thu, 08 Jun 2017 12:12:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dIwIQ-0000Q5-6B for pgsql-pkg-yum@postgresql.org; Thu, 08 Jun 2017 12:12:14 +0000 Received: from [46.21.97.138] (helo=mail.zonezero.se) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dIwII-0006Oh-VU for pgsql-pkg-yum@postgresql.org; Thu, 08 Jun 2017 12:12:12 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.zonezero.se (Postfix) with ESMTP id 7DEA014B9FE for ; Thu, 8 Jun 2017 14:12:05 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mail.zonezero.se Authentication-Results: mail.zonezero.se (amavisd-new); dkim=pass header.i=@zonezero.se Received: from mail.zonezero.se ([127.0.0.1]) by localhost (mail.zonezero.se [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id EFDcY6hNB13t for ; Thu, 8 Jun 2017 14:11:52 +0200 (CEST) Received: from webmail.zonezero.se (localhost [127.0.0.1]) by mail.zonezero.se (Postfix) with ESMTP id 7A6ED14B78F for ; Thu, 8 Jun 2017 14:11:52 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=zonezero.se; s=zonezero.se; t=1496923912; bh=H9bwPW1hddu7+FEjxkwkzoqq5RmXWIPU6UCoMeimP30=; h=Date:From:To:Subject:From; b=RMrVvGG0HimgsufuYn/CnVATmZ8NXk+efKkKcMn+0lVBydictD5MldMx/lgpIBqDD lA0Vda+T1lEvx1y38SPqqWdPFmqTZ21vZF8whnYtrjAUF8qKicr6MVaSwfNP2QjdcI 1Yvcf45N9Nt0rNk27kcPxGBIDhRPUJYhIEgkXfpI= MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Thu, 08 Jun 2017 14:11:52 +0200 From: Jesper St John To: pgsql-pkg-yum@postgresql.org Subject: Possible bug for pam auth in at least 9.6 and 10 rpms on CentOS 7 Message-ID: <4529a5e9d4d40abd2e0df7ab49c94118@zonezero.se> X-Sender: admin@zonezero.se User-Agent: Roundcube Webmail/1.1.0 X-Host-Lookup-Failed: Reverse DNS lookup failed for 46.21.97.138 (failed) X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-pkg-yum Precedence: bulk Sender: pgsql-pkg-yum-owner@postgresql.org When installing postgresql-server package, it puts a file in /etc/pam.d/ called postgresql%{majorversion}. Postgres source says this (src/backend/libpq/auth.c): #define PGSQL_PAM_SERVICE "postgresql" /* Service name passed to PAM */ That creates the need to create a new file named /etc/pam.d/postgresql to make pam auth work for me. I've tested this with both 9.6 and 10 beta on CentOS 7 latest. Best regards, Jesper St John admin@zonezero.se Suggested patch below: diff --git a/rpm/redhat/10/postgresql/master/postgresql-10.spec b/rpm/redhat/10/postgresql/master/postgresql-10.spec index d6e53b0c..32542462 100644 --- a/rpm/redhat/10/postgresql/master/postgresql-10.spec +++ b/rpm/redhat/10/postgresql/master/postgresql-10.spec @@ -781,7 +781,7 @@ install -m 755 %{sname}.init %{buildroot}%{_initrddir}/%{sname}-%{pgmajorversion %if %pam install -d %{buildroot}/etc/pam.d -install -m 644 %{SOURCE14} %{buildroot}/etc/pam.d/%{sname}%{pgmajorversion} +install -m 644 %{SOURCE14} %{buildroot}/etc/pam.d/%{sname} %endif # Create the directory for sockets. @@ -1231,7 +1231,7 @@ fi %config(noreplace) %{_initrddir}/%{sname}-%{pgmajorversion} %endif %if %pam -%config(noreplace) /etc/pam.d/%{sname}%{pgmajorversion} +%config(noreplace) /etc/pam.d/%{sname} %endif %attr (755,root,root) %dir /etc/sysconfig/pgsql %{pgbaseinstdir}/bin/initdb -- Sent via pgsql-pkg-yum mailing list (pgsql-pkg-yum@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-pkg-yum