Possible bug for pam auth in at least 9.6 and 10 rpms on CentOS 7

From: Jesper St John <admin(at)zonezero(dot)se>
To: pgsql-pkg-yum(at)postgresql(dot)org
Subject: Possible bug for pam auth in at least 9.6 and 10 rpms on CentOS 7
Date: 2017-06-08 12:11:52
Message-ID: 4529a5e9d4d40abd2e0df7ab49c94118@zonezero.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

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(at)zonezero(dot)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

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Devrim Gündüz 2017-06-09 10:40:56 Re: Possible bug for pam auth in at least 9.6 and 10 rpms on CentOS 7
Previous Message Laurențiu Nicola 2017-06-06 14:35:31 Re: SFCGAL missing from CentOS 7 repo