Search Postgresql Archives

Re: Unable to connect to PostgreSQL server via PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



El jue, 09-08-2007 a las 14:51 +0000, John Coulthard escribió:
> Hi
> 
> I'm trying to set up a new webserver running php and pgsql.  PHP was 
> connecting to postgres but I needed to install the php-gd module and now I 
> get the error...
> 
> "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 &quot;localhost&quot; and accepting\n\tTCP/IP 
> connections on port 5432?"
> 
> .... and I'm at a loss can anyone tell me why it's not connecting?
> 
> Thanks
> 
> This bit's I know are...
> http://xyala.cap.ed.ac.uk/php_info.php  say's php's configured for pgsql
> 
> [#@xyala]# telnet localhost 5432
> Trying 127.0.0.1...
> Connected to localhost.localdomain (127.0.0.1).
> Escape character is '^]'.
> Connection closed by foreign host.
> [#@xyala]#
> 
> 
> [#@xyala]# less /var/lib/pgsql/data/pg_hba.conf
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> 
> # "local" is for Unix domain socket connections only
> #local   all         all                               ident sameuser
> local   all         all                               trust
> # IPv4 local connections:
> #host    all         all         127.0.0.1/32          ident sameuser
> host    all         all         127.0.0.1/32          trust
> # IPv6 local connections:
> #host    all         all         ::1/128               ident sameuser
> host    all         all         ::1/128               trust
> 
> [#@xyala]# grep 'listen' /var/lib/pgsql/data/postgresql.conf
> # "pg_ctl reload". Some settings, such as listen_address, require
> #listen_addresses = 'localhost' # what IP interface(s) to listen on;
> listen_addresses = '*'
> [#@xyala]#
> 
> [#@xyala]# less /etc/php.d/pgsql.ini
> ; Enable pgsql extension module
> extension=pgsql.so
> 
> the server I'm going to replace is running the same versions of PHP and 
> postgres http://zeldia.cap.ed.ac.uk/php_info.php
> The /etc/php.ini files on the two machines are the same and the 
> /var/lib/pgsql/data/postgresql.conf files are only different because I've 
> set listen_addresses = '*' on the new server (xyala) to see if I can make it 
> work.
> 
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE! 
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


show your php source code for help you.


-- 
Regards,

Julio Cesar Sánchez González
www.sistemasyconectividad.com.mx
blog: http://darkavngr.blogspot.com

---
Ahora me he convertido en la muerte, destructora de mundos.
Soy la Muerte que se lleva todo, la fuente de las cosas que vendran.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux