| From: | mlaks <mlaks(at)bellatlantic(dot)net> | 
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> | 
| Subject: | trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue | 
| Date: | 2003-04-08 07:11:18 | 
| Message-ID: | 200304080311.18970.mlaks@bellatlantic.net | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mel Jamero | 2003-04-08 08:26:29 | function to determine size of a table (or even row) | 
| Previous Message | SHOBHA HALDONKAR | 2003-04-08 06:03:58 | deadlock detection |