Re: How to select the source ip address for a connection to the database server - Mailing list pgsql-php

From Dustin Butler
Subject Re: How to select the source ip address for a connection to the database server
Date
Msg-id 20090903133221.9ED9D80C90C@webmail.intrcomm.net
Whole thread Raw
List pgsql-php
I've done this with outgoing connections for port 25 and 80.  Have to be root though and affects the entire server.  I
usediptables and SNAT (source address translation) 

iptables -I POSTROUTING -t nat -p tcp --dport 80 -o eth1 -j SNAT --to-source xxx.xx.xxx.xx

This probably won't go to list not sure why I can't post yet

Dustin Butler
Intrcomm Technology

Skype: dustinbutler


------ Original Message ------
From: dimitris.sakellarios@telesuite.gr
Date: Wed, 02 Sep 2009 20:23:18 +0300
To: pgsql-php@postgresql.org
Subject: [PHP] How to select the source ip address for a connection to the    database server



   Hi,

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

   The server hosting PHP+psql�client�has 1 physical network
interfaces with multiple�subinterfaces using different IPs.

   One of those IP�is dedicated to my domain, but it is not servers
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
use-select my domains IP address as source�to connect to the remote
databases.

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

   At the moment all my attempts to connect to the database�make use
of�servers default interface IP as source.

   Thanks in advance for your help.

pgsql-php by date:

Previous
From: Greg Stark
Date:
Subject: Re: How to select the source ip address for a connection to the database server
Next
From: "Dimitris Sakellarios"
Date:
Subject: Re: How to select the source ip address for a connection to the database server