trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue - Mailing list pgsql-admin

From mlaks
Subject trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue
Date
Msg-id 200304080311.18970.mlaks@bellatlantic.net
Whole thread Raw
Responses Re: trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue  (mlaks <mlaks@bellatlantic.net>)
List pgsql-admin
Hi,
I am trying to do simple adminstration tasks on a postgresql database on
the localhost via my apache server and a cgi-perlscript.
The perlscript by itself works fine and connects to the database as
the user "wustl". It uses Perl DBI to talk to the database.
But it wont work with apache i get error messages on my pg database
such as

bash-2.05a$
FATAL 1:  IDENT authentication failed for user "nobody"

or

FATAL 1:  IDENT authentication failed for user "wustl"
pg_ctl s

whether i use the name "wustl" (the creator of the database) or
"nobody" (in a fit of hubris and insanity i tried ot let "nobody" be a
superuser on postgresql

I cant figure out how to set up the pg_hba.conf file to work.
I have tried using the settings

#####
local   all     ident   sameuser
host    all     127.0.0.1       255.255.255.255 trust
#######

or

#########
local   all     ident   sameuser
host    all     127.0.0.1       255.255.255.255  ident sameuser

#######

the connection string of my perlscript was

my $conn = DBI->connect
    ("DBI:Pg:dbname=LTA_IDB","wustl","")
   or die("Cannot connect: $DBI::errstr");
 $patname = $conn->quote( $patname);

or

my $conn = DBI->connect
    ("DBI:Pg:dbname=LTA_IDB","nobody","")
   or die("Cannot connect: $DBI::errstr");
 $patname = $conn->quote( $patname);

depending upon my try.

thanks

Mitchell Laks


pgsql-admin by date:

Previous
From: "Nikolaus Dilger"
Date:
Subject: Re: Trying to Tunning DB
Next
From: "Mel Jamero"
Date:
Subject: function to determine size of a table (or even row)