Customers
SQLite Code Factory online Help
Prev  |
Return to chapter overview | Next  |
Editing connection properties
Code Factory allows you to connect to a database directly, or via Secure Shell (SSH) tunnel (MySQL, Firebird, PostgreSQL), or using HTTP tunnel (MySQL, SQLite, PostgreSQL).
Direct connection
Set the required connection properties in the respective boxes.
SSH tunnel connection
To establish connection to intermediate SSH server and forward all commands through the secure tunnel, check the corresponding radio button, set connection properties as indicated above for direct connection, and use Configure SSH options link to open SSH Options window. Check the Connect through the Secure Shell (SSH) tunnel option and type the SSH connection properties in the respective boxes there.
Note: Host name always should be set relatively to the SSH server. For example, if both of target and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.
HTTP tunnel connection (The slowest way. It's recommended to use the connection mode if the others are impossible.)
To connect to a remote server using a PHP script, select I have to use HTTP tunneling radio button, enter the script URL, and specify database connection properties as indicated above for direct connection. In case using of a proxy server use Configure proxy server link to open Proxy server options window and specify the proxy server connection parameters.
Note: To connect to remote server in this way, upload the connection PHP script to your website. The scripts are named mysql_tunnel.php, pgsql_tunnel.php and sqlite_tunnel.php for MySQL, PostgreSQL and SQLite accordingly and can be found under the corresponding installation folder.
Note: You are actually connecting to your database through the PHP script on the server, so in most cases the host/server name is "localhost" unless the target server is not installed on the same server as the Web server.
You can test the connection before the profile is created. Just use test script using default browser link to open connection script in your browser, enter all the required connection parameters and use Test connection button.
| Prev |
Return to chapter overview | Next |
