linking to an internal ip via external ip

rodb · 02-03-2004, 03:44 AM

Hi

I have an ADSL line to a linux box (RH9). If I want to connect remotely to a database on that box I use the connection string

165.165.xxx.xxx/mypath/my_database - this works fine.

But if the database is on another linux box on the LAN - what syntax should I use to point to the database?

I have tried

165.165.xxx.xxx:192.168.xxx.xxx:/mypath/my_database

This does not work.

If I am on the LAN I can connect to my database via

192.168.xxx.xxx:/mypath/my_database

Thanks

Rod

nielchiano · 02-03-2004, 04:02 AM

You'll have to know what port(s) are used to access that db.
Eg: for HTTP transfers that port would be TCP/80.

Once you know that, you'll have to configure your gateway box (the one connected to both, LAN and internet) to forward all packets for port xxx to that specific LAN client.

try 'man iptables'
the syntax should be something like

Code:

iptables -A prerouting -p tcp --dport 80 -j DNAT 192.168.xxx.xxx

and maybe:

Code:

iptables -A FORWARD -p tcp --dport -j ACCEPT

Note: in this way you can only have 1 such db-server. If you need more, you'll have to ask some more IP's with your ISP.