Postgresql 8.4 pam

From: Jakub Gołębiewski <jakub21(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgresql 8.4 pam
Date: 2009-09-29 12:57:11
Message-ID: af853b910909290557h3f1996c6he2aac80c0cc08646@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm trying to configure authentication to postgresql 8.4 on FreeBSD Current
with pam, but when I restart the server I can't login into database using
pam authentication.

My pg_hba.conf looks:
local all all md5
host all all 192.168.1.0/24 pam
pamservice=/etc/pam.d/postgres

and my file in pam.d directory looks:

auth sufficient pam_opie.so no_warn
no_fake_prompts
auth requisite pam_opieaccess.so no_warn allow_local
auth required pam_unix.so no_warn
try_first_pass

account required pam_login_access.so
account required pam_unix.so

session required pam_permit.so

password required pam_unix.so no_warn
try_first_pass

when i try to connetc from remote host I get information: psql: FATAL: PAM
authentication failed for user "golebiej"

in postgres log I see that packter wiht password came to server but it
dosen't authenticate me

ep 29 16:55:09 postgres[1215]: [686-1] DEBUG: forked new backend, pid=1297
socket=8
Sep 29 16:55:09 postgres[1297]: [686-1] LOG: connection received:
host=192.168.1.24 port=15150
Sep 29 16:55:09 postgres[1297]: [687-1] DEBUG: received password packet
Sep 29 16:55:09 postgres[1297]: [688-1] LOG: pam_authenticate failed:
authentication error
Sep 29 16:55:09 postgres[1297]: [689-1] FATAL: PAM authentication failed
for user "golebiej"
Sep 29 16:55:09 postgres[1297]: [690-1] DEBUG: shmem_exit(1): 0 callbacks
to make
Sep 29 16:55:09 postgres[1297]: [691-1] DEBUG: proc_exit(1): 1 callbacks
to make
Sep 29 16:55:09 postgres[1297]: [692-1] DEBUG: exit(1)
Sep 29 16:55:09 postgres[1297]: [693-1] DEBUG: shmem_exit(-1): 0 callbacks
to make
Sep 29 16:55:09 postgres[1297]: [694-1] DEBUG: proc_exit(-1): 0 callbacks
to make
Sep 29 16:55:09 postgres[1215]: [687-1] DEBUG: reaping dead processes
Sep 29 16:55:09 postgres[1215]: [688-1] DEBUG: server process (PID 1297)
exited with exit code 1

Is anybody can help me solve this problem?

Best regards,
Kuba

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-09-29 14:30:43 Re: Postgresql 8.4 pam
Previous Message Tom Lane 2009-09-28 20:20:49 Re: Data problem - error "invalid attribute number # for <tablename>"