Re: trouble connecting to Postgresql Database via

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: mlaks <mlaks(at)bellatlantic(dot)net>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: trouble connecting to Postgresql Database via
Date: 2003-04-09 19:56:04
Message-ID: 1049918164.23437.346.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)postgresql(dot)org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris White 2003-04-09 20:22:42 Re: [JDBC] Problems with Large Objects using Postgres 7.2.1
Previous Message Cris 2003-04-09 19:42:17 Index not used,