Online Documentation for SQL Manager for MySQL

HTTP tunneling options


HTTP tunneling is a connection type, when connection and data transmit between program and MySQL server is  implemented by HTTP/HTTPS protocols. Such connection type can be used when MySQL host is located on the web hosting provider's remote server and direct TCP/IP connection to this host is denied on the security grounds, but there is a "local" MySQL account that can be used in scripts (PHP, ASP etc.) or in PHPMyAdmin. HTTP connection uses port #80, which is also used for common work of web-browser. HTTP server (eg. Apache) and PHP with MySQL extension must be installed on the remote host. As a rule this software is offered by all hosting providers that allot hosting on Linux-based servers.

 

To create HTTP-tunnel you need to upload emsproxy.php script (included to program pack) to your webserver. Our program uses this script for transferring data through HTTP. The uploaded script file must be accessible on a URL address (for example in the directory with other scripts). If your webserver meets all the requirements listed above and the script was copied correctly then on opening the 'http://<your_webserver_name>/emsproxy.php' page you will see: 'EmsProxy v1.31' (version can be different). To register a database with HTTP connection you need to define the following parameters in Register Database Wizard:

 

URL

Address where emsproxy.php script file is located (e.g. http://mywebserver/emsproxy.php).

 

Appendix - HTTP tunneling options

 

Script implements connection to MySQL server using authorization information defined in SQL Manager. Script also gets all further queries from SQL Manager to perform and to send results back to SQL Manager. Script itself (as opposed to SSH-server) doesn't require authorization. Thereby, to create an HTTP-tunnel you need only MySQL account. Host from which the connection to my sql is performed is a host, where HTTP-server is running. Basically (in most of common configurations of provided hosts) it's 'localhost' (i.e. HTTP-server and MySQL host are running on the same machine).

 

What if URL requires additional authorization? If it is a common website or proxy authorization (i.e. window with login/password form appears on opening URL-address) then the window requesting authorization info appears in SQL Manager when trying to connect to the database. Additional authorization can be caused by redirection to HTML-page requesting password and saving data to cookie are. Such cases are not supported.