BUG #8114: Peer authentication in cgi-perl - Mailing list pgsql-bugs

From support@securenetterm.com
Subject BUG #8114: Peer authentication in cgi-perl
Date
Msg-id E1UV83m-0001Fj-2r@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8114: Peer authentication in cgi-perl  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8114
Logged by:          Kenneth Robinette
Email address:      support@securenetterm.com
PostgreSQL version: 9.1.0
Operating system:   Ubuntu 12.04.2
Description:        =


I am having the same problem described in:
     5.1.0.14.2.20020213180151.04bd2250@pop.ntlworld.com =


The cgi-script I am using works on a CentOS 6.4 system using PostgreSQL
version 8.4 and several older centos/redhat systems.  The pg_hba.conf and
postgresql.conf are setup the same on all systems.

When trying to connect On the Ubuntu 12.04.2 system, the database connect is
aborted.  The following messages are in the postgresql-9.1-main.log.  The
real username has been replaced by xxxxxxxx:

2013-04-24 16:23:18 CDT LOG:  provided user name (xxxxxxxx) and
authenticated user name (www-data) do not match
2013-04-24 16:23:18 CDT FATAL:  Peer authentication failed for user
"xxxxxxxx"

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #8091: No permissions on the table file causing recovery failure
Next
From: John R Pierce
Date:
Subject: Re: BUG #8114: Peer authentication in cgi-perl