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 по дате отправления: