Re: Undefined function pg_connect() - Mailing list pgsql-php

From Gustavo Amarilla Santacruz
Subject Re: Undefined function pg_connect()
Date
Msg-id e4ea2d811002011651i451f7939q8eb0a34d4b38d5be@mail.gmail.com
Whole thread Raw
In response to Re: Undefined function pg_connect()  (Chris <dmagick@gmail.com>)
Responses Re: Undefined function pg_connect()  (Gustavo Amarilla Santacruz <gusamasan@gmail.com>)
List pgsql-php
Thank you, Chris.

The pg_hba.conf contained:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                                 trust
# IPv4 local connections:
host    all         all         127.0.0.1 255.255.255.0 trust
# IPv6 local connections:
host    all         all         ::1/128               ident


Before, i modified to:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                                 trust
# IPv4 local connections:
host    all         all         127.0.0.1 255.255.255.0 trust
# IPv6 local connections:
host    all         all         ::1/128               trust


Then i can login me. But, how i Know that apache is using IPV6 connections?


On Mon, Feb 1, 2010 at 9:13 PM, Chris <dmagick@gmail.com> wrote:
Gustavo Amarilla Santacruz wrote:
Thank you, all.

I had access to the SELinux->Boolean; next, i check the option:

 "Allow HTTPD scripts and modules to connect to databases over the network".


Then, a new message was displayed:

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "gestock" .......


I can login with gestock data (user/password) through the postgresql psql tool. But from apache i can not.

It's not using the password, it's just checking the username to see if you're logged in as 'gestock' (but 'apache' is not 'gestock', hence the error).

What does your postgresql pg_hba.conf file look like?


--
Postgresql & php tutorials
http://www.designmagick.com/




--
Gustavo Amarilla

¿Reciclaste papel, hoy?

pgsql-php by date:

Previous
From: Chris
Date:
Subject: Re: Undefined function pg_connect()
Next
From: Gustavo Amarilla Santacruz
Date:
Subject: Re: Undefined function pg_connect()