Clodoaldo Pinto worte: -->-----Mensagem original----- -->De: pgsql-general-owner@xxxxxxxxxxxxxx -->[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Em nome de -->Clodoaldo Pinto -->Enviada em: segunda-feira, 3 de julho de 2006 12:13 -->Para: pgsql-general postgresql.org -->Assunto: Re: [GENERAL] php can't connect to postgresql server --> --> -->2006/7/3, Clodoaldo Pinto <clodoaldo.pinto@xxxxxxxxx>: -->> php can't connect to postgresql server -->> -->> php error log message: -->> -->> PHP Warning: pg_connect() [<a -->> href='function.pg-connect'>function.pg-connect</a>]: -->Unable to connect -->> to PostgreSQL server: could not connect to server: Permission -->> denied\n\tIs the server running on host "127.0.0.1" and -->> accepting\n\tTCP/IP connections on port 5432? -->> -->> php connection string: -->> -->> $conn_string = "hostaddr=127.0.0.1 port=5432 dbname=dbname -->> user=username password=password"; -->> -->> Also tried host=localhost -->> -->> pg_hba: -->> -->> host dbname username 127.0.0.1/32 md5 -->> -->> I can connect as that user with psql: -->> -->> $ psql -h localhost -U username dbname -->> Password for user username: -->> Welcome to psql 8.1.4, the PostgreSQL interactive terminal. -->> -->> This same setup works in another server running 8.0. Differences: -->> -->> old server | new server -->> FC3 | FC5 -->> php 4.3.11 | php 5.1.4 -->> httpd 2.0 | httpd 2.2 -->> -->> What else should I check? I am out of ideas. --> -->The same script running from another server can connect to -->the new server using this pg_hba entry: -->host dbname usename xx.xx.xxx.xx/32 md5 --> -->Clodoaldo postgresql.conf --> listen_addresses = '*' ---- >This is any ip. pg_hba.conf --> # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 This is the configuration that i choose when install postgresql in windows xp. Try this. Alejandro Michelin Salomon Porto Alegre Brasil
