Skip site navigation (1) Skip section navigation (2)

enterprisedb package and pam on debian

From: Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: enterprisedb package and pam on debian
Date: 2012-04-16 08:17:10
Message-ID: CAPGEe=573RS_bvCQckboGm62Ow+C+1hVhcgythAOsiVpFDe6Xw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hiho,

I'm running the package 9.0.7 from enterprisedb and have some problems
getting the pam module to work on debian.

pam basically works - i just configured a more secure password policy.

the enterprisedb package has pam support included. at least i see with ldd
that i knows the pam library.

the postgres service is named postgres so i created a file
/etc/pam.d/postgres and added the lines

      auth       required     pam_stack.so service=system-auth
      account    required     pam_stack.so service=system-auth

i found in another mail thread.
I also tried to copy files from other predefined services like sudo or
login.

the error is always:
root:/etc/pam.d# psql -U testuser postgres
psql.bin: FATAL:  PAM authentication failed for user "testuser"

the line in pg_hba.conf is
# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD
local   postgres             testuser
pam

any idea what's wrong here?
or does anybody have a good how-to?

thanks,
Uwe

pgsql-admin by date

Next:From: Albe LaurenzDate: 2012-04-16 08:31:09
Subject: Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen?
Previous:From: Frank LanitzDate: 2012-04-16 04:57:17
Subject: Re: Recreate primary key without dropping foreign keys?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group