Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7F641632D69 for ; Wed, 2 Sep 2009 15:51:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 44562-09 for ; Wed, 2 Sep 2009 18:51:21 +0000 (UTC) X-Greylist: delayed 01:27:48.456053 by SQLgrey-1.7.6 Received: from zeus.netdynamics.gr (zeus.netdynamics.gr [76.76.12.11]) by mail.postgresql.org (Postfix) with ESMTP id 5730A632753 for ; Wed, 2 Sep 2009 15:51:23 -0300 (ADT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=telesuite.gr; h=Message-ID:Date:From:To:Subject:MIME-Version:Content-Type:Content-Transfer-Encoding:User-Agent:X-Antivirus-Scanner:X-Source:X-Source-Args:X-Source-Dir; b=E6VCH08MKJpMVnXYa86NtuUpy/u3i/KAMyW3TCsN1mmeuI16eq43xfYgOnlA+lRC0vEyyyXrld2h/3W+ib4gnKes25KyjmqYmlaNRP1eT1Oozc6hn7V8QzmvBXjmf0sv; Received: from localhost ([127.0.0.1]) by zeus.netdynamics.gr with esmtpa (Exim 4.69) (envelope-from ) id 1MitYE-00088C-Ot; Wed, 02 Sep 2009 20:23:18 +0300 Received: from 83.235.183.180 ([83.235.183.180]) by zeus.netdynamics.gr (Horde MIME library) with HTTP; Wed, 02 Sep 2009 20:23:18 +0300 Message-ID: <20090902202318.hp0bplmn4kkc48k0@zeus.netdynamics.gr> Date: Wed, 02 Sep 2009 20:23:18 +0300 From: dimitris.sakellarios@telesuite.gr To: pgsql-php@postgresql.org Subject: How to select the source ip address for a connection to the database server MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_4s20ksne6uio" Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.1.6) X-Antivirus-Scanner: Clean mail though you should still use an Antivirus X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - zeus.netdynamics.gr X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - telesuite.gr X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.398 tagged_above=-10 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001, MIME_QP_LONG_LINE=1.396 X-Spam-Level: * X-Archive-Number: 200909/1 X-Sequence-Number: 4059 This message is in MIME format. --=_4s20ksne6uio Content-Type: text/plain; charset=ISO-8859-7; DelSp="Yes"; format="flowed" Content-Description: =?iso-8859-7?b?zojOus60zr/Pg863IA==?= =?iso-8859-7?b?zrzOt869z43OvM6xz4TOv8+CIA==?= =?iso-8859-7?b?zrzOtSA=?= =?iso-8859-7?b?zrrOsc64zrHPgc+MIA==?= =?iso-8859-7?b?zrrOtc6vzrzOtc69zr8=?= Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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. --=_4s20ksne6uio Content-Type: text/html; charset=ISO-8859-7 Content-Description: HTML =?utf-8?b?zpXOus60zr/Pg863IA==?= =?utf-8?b?z4TOv8+FIA==?= =?utf-8?b?zrzOt869zq7OvM6xz4TOv8+C?= Content-Disposition: inline Content-Transfer-Encoding: quoted-printable

Hi,

I am currently=A0working with PHP5+PGSQL = 8.2.13 and i have the following problem to solve and i need your help.

The server hosti= ng PHP+psql=A0client=A0has 1 physical network interfaces with multiple=A0subint= erfaces using different IPs.

One of t= hose IP=A0is dedicated to my domain, but it is not servers default IP address sin= ce i share the server.

So the prob= lem that i need to solve is how am i going to be able to use-select my domains IP add= ress as source=A0to connect to the remote databases.

Is there any configuration to settle default source IP the client= will use?

At the moment all my att= empts to connect to the database=A0make use of=A0servers default interface IP as source.

Thanks in advance for= your help.

--=_4s20ksne6uio--