Re: Undefined function pg_connect()
От | Gustavo Amarilla Santacruz |
---|---|
Тема | Re: Undefined function pg_connect() |
Дата | |
Msg-id | e4ea2d811002011654v6b29236bi33119e60691e1e3a@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Undefined function pg_connect() (Gustavo Amarilla Santacruz <gusamasan@gmail.com>) |
Список | pgsql-php |
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?
--
Gustavo Amarilla
¿Reciclaste papel, hoy?
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 <gusamasan@gmail.com> wrote:
Thank you, Chris.
The pg_hba.conf contained: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 identhost all all ::1/128 trust
# 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:
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: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).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.
What does your postgresql pg_hba.conf file look like?--
Gustavo Amarilla
¿Reciclaste papel, hoy?
--
Gustavo Amarilla
¿Reciclaste papel, hoy?
В списке pgsql-php по дате отправления: