From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-php@postgresql.org
Subject: Re: How to select the source ip address for a connection to the database server
Date: 7 Sep 2009 10:40:21 GMT
Message-ID: <h82nul$dpv$5@reversiblemaps.ath.cx> (raw)
References: <20090902202318.hp0bplmn4kkc48k0@zeus.netdynamics.gr>
On 2009-09-02, dimitris.sakellarios@telesuite.gr <dimitris.sakellarios@telesuite.gr> wrote:
>
> Hi,
>
> I am currently=A0working with PHP5+PGSQL 8.2.13 and i have the =20
> following problem to solve and i need your help.
>
> The server hosting PHP+psql=A0client=A0has 1 physical network =20
> interfaces with multiple=A0subinterfaces using different IPs.
>
> One of those IP=A0is dedicated to my domain, but it is not servers =20
> default IP address since i share the server.
>
> So the problem that i need to solve is how am i going to be able to =20
> use-select my domains IP address as source=A0to connect to the remote =20
> databases.
>
> Is there any configuration to settle default source IP the client will us=
> e?
>
> At the moment all my attempts to connect to the database=A0make use =20
> of=A0servers default interface IP as source.
>
> Thanks in advance for your help.
easiest way it probably by setting a routing rule, you need
root/adimnistrator to do this.
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: jasen@xnet.co.nz
Subject: Re: How to select the source ip address for a connection to the database server
In-Reply-To: <h82nul$dpv$5@reversiblemaps.ath.cx>
References: <20090902202318.hp0bplmn4kkc48k0@zeus.netdynamics.gr> <h82nul$dpv$5@reversiblemaps.ath.cx>
* 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