Customers
MaxDB Data Wizard online Help
Prev  |
Return to chapter overview | Next  |
Setting connection properties
Set the connection properties in the respective boxes: user name, port number, and password to connect to MaxDB server you need.
Use the Test Connect button to test the connection properties you have specified. The operation will return a message box with the operation result.
You can also specify different connection parameters for the database server and generated PHP scripts.
Latest versions of Data Wizard for MySQL, PostgreSQL Data Wizard and SQLite Data Wizard allow you to connect to a database directly, or via Secure Shell (SSH) tunnel, or using HTTP tunnel. On the database profile creation you should firstly select the way of the connection.
Direct connection
Just set the connection properties in the respective boxes: host, user, database, etc.
SSH tunnel connection
To establish connection to intermediate SSH server and forward all MaxDB 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 that MaxDB host name always should be set relatively to the SSH server. For example, if both of MaxDB 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.)
Note: To connect to remote MaxDB in this way, you should first of all upload the <> script to the destination site. The script can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\MaxDB Data Wizard.
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: You are actually connecting to MySQL through the PHP script on the server, so in most cases the host/server name is "localhost" unless the MySQL 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 the connection information (host, user, password, port), and database name and use Test connection button. Click Get Database List to view available databases.
| Prev |
Return to chapter overview | Next |
