Thread: trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue

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

Hi i also enabled
tcpip_socket = true
in the postgresql.conf file as well, and did a pg_ctl reload or pg_ctl
stop/pg_ctl start to no avail :(.
i am running redhat 7.3 with the default postgresql install of
postgresql-7.2.1-5.

thank you
mitchell
On Tuesday 08 April 2003 03:11 am, you wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

You've not given us all the information, since if you set your
pg_hba.conf to use "trust" based authentication, you wont get a "FATAL:
IDENT" type error message. Go back to trust, restart your database, try
and connect and post back if it doesn't work.  If it does work, check
the docs RE: setting up IDENT authentication. IIRC your going to need a
password supplied in your perl code, and I didn't see one...

Robert Treat

On Tue, 2003-04-08 at 07:39, mlaks wrote:
> Hi i also enabled
> tcpip_socket = true
> in the postgresql.conf file as well, and did a pg_ctl reload or pg_ctl
> stop/pg_ctl start to no avail :(.
> i am running redhat 7.3 with the default postgresql install of
> postgresql-7.2.1-5.
>
> thank you
> mitchell
> On Tuesday 08 April 2003 03:11 am, you wrote:
> > 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
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)