General information
If you have remote website and you need to access website database from iLangL cloud, but access to the database through the port of the database server is forbidden, and only access through HTTP port 80 is allowed, you can use MySQL HTTP tunnel.
You need to deploy tunnel.php script, which is included to the provider package, on the web server, allowed to access to the database server to use HTTP tunneling. The script must be available through the HTTP protocol. You can verify if it is accessible with web browser. Here you can download tunnel.php file http://ilangl.com/downloads/tunnel.zip Preferred place for this script is website root folder. The only requirement to the server is PHP 5 support.
How to check if file deployed and works correctly?
To check that your file is deployed and works correctly you should to enter url to browser where tunnel.php file is located. For example http://<your websute ur>/tunnel.php. In case of success you will get next response
Devart HttpTunnel v1.73 Tunnel script is installed correctly. You can establish connections through the HTTP tunnel. Loging is enabled. Log files are located in the tunnel_files folder, which, in its turn, is located in the temporary folder of the operating system: /tmp/tunnel_files/httptunnel_server.log
How to setup connection via http tunnel?
To establish connection between your website and iLangL cloud using MySQL HTTP Tunnel you should use instruction for Internet Connection except Server name.
For Server name you should use next setting: httptunnel:http://<your website url>/tunnel.php, IP address
where httptunnel - protocol
http://<your website url>/tunnel.php - Url of the tunneling PHP script.
IP address - MySql server IP address
For example, if the script is in the server root, the url can be the following: http://localhost/tunnel.php and MySQL database is located on local environment, you can use IP 127.0.0.1
As a result you should get next result: httptunnel:http://localhost/tunnel.php,127.0.0.1