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
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>" |