php VPN

[zorgi]

Hi all

I am not sure how to approach to this problem. There is a database on some server on the local network. Database is only available through VPN. Now there is a need for this database to be available through internet connection but without moving it, as it will still be updated in the same way through VPN. My only problem is connecting to this database. Any ideas?

Thanks

[dlite922]

configure your firewall so that you can access the database from the internet.

ie 0.0.0.0:3306 would forward to your MySQL database.

Othewise for PHP to access it the server that PHP is running on needs to do the VPN connection itself.

What you can do is have PHP do a command call like exec() and launch the VPN connection. You will not need any special PHP code, PHP can access it just like if that database server was in the local network (That's in fact the definition of Virtual Private Network).

You can have PHP close the VPN connection via command line (if you have a VPN client that works through command line).

If it's not possible to create the VPN connection via command line, and therefore through PHP. You need to manually log on to the computer and initialize the VPN connection. This would not be bad if your PHP application is known to run at specific time or is run manually, such as a script.

Let me know if any questions,





Dan

[zengxiaoyan]

Hello,I am inserested in you project,but I really don't know how to "have PHP do a command call like exec() and launch the VPN connection."Just like use PHP to make a program to launch the VPN connection on the time? Can you give me the code? My email is "[e-mail]" .Thanks.

[dlite922]

there is no "code".

1. Get familiar with the command line (I miss the days when I had to say this less)

2. Find a VPN client that you can execute from the command line
(http://www.google.com/search?source=...ne+vpn+&aqi=g4) need I say more

3. Put that command into an exec() call.

Retry connecting.



Dan