English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I am developing an application which has to contact a system through internet. I have tested the application in my office LAN. but actually aimed to make it work in internet.

I don't know how to test my application in internet environment.

My application has to connect the database system which has already installed in 192.168.2.8(Its my office's LAN IP).

My office have internet connection with static ip and also a router for our LAN.

In LAN we have 10 systems IP ranging from 192.168.2.1 to 192.168.2.10.

How to configure my LAN so that my application(which runs in a computer which is out side of my office) will be able to connect to the database which has installed in one of my office system?

Can anyone give idea about it?

Regards,
Purusothaman A

2007-05-25 23:53:54 · 3 answers · asked by Chennai BOY 1 in Computers & Internet Computer Networking

My database is postgresql which uses port 5432.

And router is LinkSys Wireless G broadband router - 802.11g which is also a cisco product.

2007-05-26 00:30:47 · update #1

3 answers

You need a port address translation on your internet router for the external IP through to the port the database is listening on at 192.168.2.8

I don't know what sort of database it is or what router you are using, but assuming it's MySQL which runs on 3306 and a Cisco router which runs IOS, and using 66.94.244.13 as an example internet IP you would enter on the router

ip nat inside source static 192.168.2.8 66.94.234.13 eq 3306

If you have a bs home-grade router you will find a "port translation" option on it's web config page somewhere, enter the port number and LAN ip of your database server.

2007-05-26 00:11:45 · answer #1 · answered by Elomis 5 · 0 0

You have a static IP feeding the office router. You wish to access the pc with LAN IP 192.168.2.2 from the internet.

If your router supports port forwarding, open a port in the router and forward the port to LAN IP 192.168.2.2. Check the router manual for port forwarding. Caution! Anyone who enters the static IP followed by : and then by the open port can enter so put in some password and user name on the pc to keep freeloaders off.

Also you can install PC Anywhere on the lan pc and use PC Anywhere client on the remote pc and access.

You can replace the router with one that supports VPN and establish a VPN if you want. This is the most secure way.

2007-05-26 02:00:10 · answer #2 · answered by GTB 7 · 0 0

You will need to configure the router to port forward the Internet traffic to the .8 address on the LAN (you need to know which database you are using to find out what ports it uses so you can forward the correct ports)

Usually you can find out what ports are necessary from the Database suppliers web site.

You could (not recommended at all no way) put the database server as the DMZ in the router (that forwards ALL inbound internet traffic to the database server) this is dangerous since that machine is the sitting on the web with no ports being blocked at all. (You need to be sure that server has really good firewall and virus protection as well as really secure passwords etc.)

2007-05-26 00:08:13 · answer #3 · answered by Tracy L 7 · 0 0

fedest.com, questions and answers