|
Contents
Index
<< Previous
Next >>
PDF
HTTP Tunnel
|
|
What is a HTTP tunnel and how does it work?
| Some ISPs permit access to the MySQL database only from the Web server due to reasons of security. This means MySQL-Front cannot access the database normally (error: Access denied).
|
| This problem can be circumvented with the use of so-called HTTP tunnel.
|
| Install the PHP script libMySQL.php (attached with the program) on the Web server (via FTP upload f.e.). Then select the connection type "HTTP tunnel" within the session and specify the respective HTTP URL of this libMySQL.php script on your web server.
|
| MySQL-Front converts the database query into an HTTP request and sends this request to the PHP script on the Web server. (The script can access the database since it is, same as the other scripts, located on the Web server.) The PHP script then converts the reply of the database and sends it as the HTTP result back to MySQL-Front.
|
Important note:
| Since PHP doesn't support to use resources in sessions each single database request opens a new database process and close them after receiving the single response. Because of this by using the HTTP Tunnel the database is not be able to remember any session settings like variables, rollback or something like this.
|
See also:
|
|
