From: EMOTO Masahiko <emo@nifs.ac.jp>
To: pgsql-admin@postgresql.org
Subject: PAM
Date: Wed, 04 Dec 2002 10:59:43 +0900
Message-ID: <87lm361r3k.wl@dgpc1.nifs.ac.jp> (raw)
Does anyone show me a sample of PAM authenticate file?
I want to use pam for client authentication, and I create pg_hba.cnf as,
>host all all 127.0.0.1 255.255.255.255 trust
>host all all 192.168.0.0 255.255.0.0 pam postgresql
and /etc/pam.d/postgresql as
>auth required /lib/security/pam_stack.so service=system-auth
>account required /lib/security/pam_stack.so service=system-auth
I tried to connect to the server, but failed. The messages I received were follows;
>[CLIENT]
>% psql -h dgpc1 db1 -U emo
>Password:
>psql: FATAL: PAM authentication failed for user "emo"
>
>[SERVER]
>DEBUG: reaping dead processes
>DEBUG: child process (pid 15642) exited with exit code 0
>DEBUG: BackendStartup: forked pid=15643 socket=8
>DEBUG: received PAM packet
>LOG: CheckPAMAuth: pam_authenticate failed: 'Authentication failure'
>FATAL: PAM authentication failed for user "emo"
>DEBUG: proc_exit(0)
>DEBUG: shmem_exit(0)
>DEBUG: exit(0)
>DEBUG: reaping dead processes
The user account exists in the database, and I typed the system password.
Environment:
OS : Linux Kernel 2.4.19
PostgreSQL 7.3
By the way, what really I want to do is to configure the server behave like FTP servers;
All the users except the guest (anonymous) requires the password authentication.
The guest user can only read the data, and cannot alter the data.
Are there any solutions to do this?
--- EMOTO Masahiko ---
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: emo@nifs.ac.jp
Subject: Re: PAM
In-Reply-To: <87lm361r3k.wl@dgpc1.nifs.ac.jp>
References: <87lm361r3k.wl@dgpc1.nifs.ac.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox