Re: BUG #8114: Peer authentication in cgi-perl

On 4/24/2013 3:21 PM, support(at)securenetterm(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8114
> Logged by: Kenneth Robinette
> Email address:support(at)securenetterm(dot)com
> PostgreSQL version: 9.1.0
> Operating system: Ubuntu 12.04.2
> Description:
>
> I am having the same problem described in:
> 5(dot)1(dot)0(dot)14(dot)2(dot)20020213180151(dot)04bd2250(at)pop(dot)ntlworld(dot)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"

this isn't a bug, you can't use 'peer' (formerly known as ident
sameuser) authentication to connect as a different role than your system
username, unless you create an 'indent map'.

you perhaps moved your 'same postgresql.conf and pg_hba.conf' files to
the wrong place on ubuntu? debian/ubuntu put the config files under
/etc/postgresql/.....

also, there have been changes in the various config files between 8.4
and 9.1 such that copying the file from the older system might not run
optimally on the newer.

--
john r pierce 37N 122W
somewhere on the middle of the left coast