From: Bill Moran <wmoran@potentialtech.com>
To: Ireneusz.Tarnowski@pwr.wroc.pl
Cc: Andrew McMillan <andrew@morphoss.com>
Cc: pgsql-php@postgresql.org
Subject: Re: problem with connection to remote server
Date: Thu, 28 Jan 2010 08:46:47 -0500
Message-ID: <20100128084647.4c0ad114.wmoran@potentialtech.com> (raw)
In-Reply-To: <73a0d649417f.4b61a0de@pwr.wroc.pl>
References: <72b0d9d047b1.4b616c3d@pwr.wroc.pl>
<1264672955.25189.256.camel@happy.home.mcmillan.net.nz>
<20100128074300.59a4591d.wmoran@potentialtech.com>
<73a0d649417f.4b61a0de@pwr.wroc.pl>
In response to Ireneusz Tarnowski <Ireneusz.Tarnowski@pwr.wroc.pl>:
> > In addition to this, PHP will give some pretty useful error messages when
> > it can't connect. If you're not seeing those, then you should adjust
> > your application logic to log them, it will make your life a lot easier.
> > If they don't clearly define the problem, post them here ... I (and
> > others like me) have seen them enough to know what they indicate.
>
> I have warning:
>
> Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: No such file or directory Is the server running on host "XX.XX.XX.XX" and accepting TCP/IP connections on port 5432? in /export/sun1000/XXXXXXX/public_html/dbtest.php on line 10
>
> And nothing more. Postgresql log, apache error log and php error log write nothing about this connection.
This is usually the result of a network problem. hba problems are usually
reported as such by PHP. I would first 2x check the obvious ... did you
mistype the IP or hostname in the connection string? Check firewall logs
to ensure it's not being blocked by something. Run tcpdump on the server
to see if it's getting the syn packets.
--
Bill Moran
http://www.potentialtech.comhttp://people.collaborativefusion.com/~wmoran/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: wmoran@potentialtech.com, Ireneusz.Tarnowski@pwr.wroc.pl, andrew@morphoss.com
Subject: Re: problem with connection to remote server
In-Reply-To: <20100128084647.4c0ad114.wmoran@potentialtech.com>
References: <72b0d9d047b1.4b616c3d@pwr.wroc.pl> <1264672955.25189.256.camel@happy.home.mcmillan.net.nz> <20100128074300.59a4591d.wmoran@potentialtech.com> <73a0d649417f.4b61a0de@pwr.wroc.pl> <20100128084647.4c0ad114.wmoran@potentialtech.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox