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
