From: Bill Moran <wmoran@potentialtech.com>
To: Andrew McMillan <andrew@morphoss.com>
Cc: Ireneusz.Tarnowski@pwr.wroc.pl
Cc: pgsql-php@postgresql.org
Subject: Re: problem with connection to remote server
Date: Thu, 28 Jan 2010 07:43:00 -0500
Message-ID: <20100128074300.59a4591d.wmoran@potentialtech.com> (raw)
In-Reply-To: <1264672955.25189.256.camel@happy.home.mcmillan.net.nz>
References: <72b0d9d047b1.4b616c3d@pwr.wroc.pl>
<1264672955.25189.256.camel@happy.home.mcmillan.net.nz>
In response to Andrew McMillan <andrew@morphoss.com>:
> On Thu, 2010-01-28 at 10:51 +0100, Ireneusz Tarnowski wrote:
> > Hi,
> >
> > I have some PHP application and 2 postgreSQL remote servers.
> > All servers are runing under Solaris 10.
> >
> > I can connect from application to one postgresql server and all work
> > fine. I have to move database to second server. I export/import data.
> > Check all data inside database - OK. I can't connect from php
> > application into second postgresql server.
> >
> > I test if it possible to connect using psql -h remote_server and I
> > can connect. I check firewall's ... but I can connect between
> > application serwer and postgresql server using CMD (psql). Only PHP
> > application can't connect. Otherside ... the PHP application works
> > fine with first postgresql server (and PHP configuration supports
> > psql).
> >
> > I compared TCP packets and it looks like the application and server
> > drop connection after first 2 packets (ACK).
>
> The place to look for error messages is in the PostgreSQL server log. I
> would bet that it is rejecting the connection because the source ip/user
> are different.
>
> When you connect from the command-line it is probably using ident
> information and that connection is being allowed, but the PHP
> application will be running as the webserver user and will need
> different credentials.
>
> Check your pg_hba.conf file on the server and adjust it to let the
> desired connection happen.
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.
--
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, andrew@morphoss.com, Ireneusz.Tarnowski@pwr.wroc.pl
Subject: Re: problem with connection to remote server
In-Reply-To: <20100128074300.59a4591d.wmoran@potentialtech.com>
References: <72b0d9d047b1.4b616c3d@pwr.wroc.pl> <1264672955.25189.256.camel@happy.home.mcmillan.net.nz> <20100128074300.59a4591d.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