trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue
| От | mlaks |
|---|---|
| Тема | trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue |
| Дата | |
| Msg-id | 200304080311.18970.mlaks@bellatlantic.net обсуждение исходный текст |
| Ответы |
Re: trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue
|
| Список | 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 по дате отправления: