| From: | Josh Berkus <josh(at)agliodbs(dot)com> | 
|---|---|
| To: | Richard Ray <rray1(at)netdoor(dot)com>, pgsql-novice(at)postgresql(dot)org | 
| Subject: | Re: Setting up PAM authentication | 
| Date: | 2002-10-08 20:26:01 | 
| Message-ID: | 200210081326.01585.josh@agliodbs.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
Richard,
> I'm trying to setup PAM authentication for PostgreSQL. I compiled with PAM 
> and configured pg_hba.conf:
> host       test        10.3.62.251   255.255.255.255    pam
> 
> When I try to connect I get:
> psql: FATAL 1:  PAM authentication failed for user "postgres"
> 
> The log shows:
> CheckPAMAuth: pam_authenticate failed: 'No account present for user'
> FATAL 1:  PAM authentication failed for user "postgres"
You need to set up a PAM module for Postgresql.   I can't explain how to do 
this, though, especially on HP-UX; try consulting a Unix manual about 
configuring PAM.
Also, are you certain that HP-UX uses PAM?
-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Giles Lean | 2002-10-08 21:30:39 | Re: hiding normalization with views | 
| Previous Message | Randy Neumann | 2002-10-08 20:06:57 | Re: hiding normalization with views |