From: | mlaks <mlaks(at)bellatlantic(dot)net> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue |
Date: | 2003-04-08 11:39:42 |
Message-ID: | 200304080739.42135.mlaks@bellatlantic.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-04-08 12:37:34 | Re: Date Format |
Previous Message | Erwin Ambrosch | 2003-04-08 11:37:35 | Re: DATESTYLE setting |