Skip site navigation (1) Skip section navigation (2)

Re: Undefined function pg_connect()

From: Chris <dmagick(at)gmail(dot)com>
To: Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com>
Cc: Bill Moran <wmoran(at)potentialtech(dot)com>, pgsql-php(at)postgresql(dot)org
Subject: Re: Undefined function pg_connect()
Date: 2010-02-02 00:13:33
Message-ID: 4B676E2D.5060903@gmail.com (view raw or flat)
Thread:
Lists: pgsql-php
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/


In response to

Responses

pgsql-php by date

Next:From: Gustavo Amarilla SantacruzDate: 2010-02-02 00:51:00
Subject: Re: Undefined function pg_connect()
Previous:From: Gustavo Amarilla SantacruzDate: 2010-02-02 00:03:34
Subject: Re: Undefined function pg_connect()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group