Re: Undefined function pg_connect()
Gustavo Amarilla Santacruz <[email protected]> Mon, 1 Feb 2010 21:54:33 -0300
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <[email protected]> |
I am sorry. Please, ommit the previous post. The correct post is the following: Thank you, Chris. The pg_hba.conf file contained this: # 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 After, i modified it 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 from php scripts. But, how i Know that apache is using IPV6 connections? On Mon, Feb 1, 2010 at 9:51 PM, Gustavo Amarilla Santacruz < [email protected]> wrote: > 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 <[email protected]> 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? > -- Gustavo Amarilla ¿Reciclaste papel, hoy?