Re: How to select the source ip address for a connection to the database server

View: New views
1 Messages — Rating Filter:   Alert me  

Re: How to select the source ip address for a connection to the database server

by dustinb :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I've done this with outgoing connections for port 25 and 80.  Have to be root though and affects the entire server.  I used iptables 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@...
Date: Wed, 02 Sep 2009 20:23:18 +0300
To: pgsql-php@...
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.

--
Sent via pgsql-php mailing list (pgsql-php@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php