Download free 14 days trial version of Store Manager for Magento now
This section describes how to setup HTTP Tunnel connection in Store Manager for Magento.
HTTP tunnel is an alternative way of connecting to your database which possesses the advantages of both direct and bridge connection.
This type of connection is useful if you don’t have direct access to MySQL database. Also, you don’t need to do POST \ GET operations to synchronize data with your store, all changes will be reflected in real-time.
To configure HTTP Tunnel connection, follow a few steps listed below:
C:\Program Files\eMagicOne\Store Manager for Magento
and find directory "Service" there. Inside this directory you can find sm_tunnel.php
file.folder -> app folder -> etc folder
and find there local.xml file.Find the following lines:
<host><![CDATA[mywebsite.com]]></host>
<username><![CDATA[name]]></username> //here your User Name (login) is defined
<password><![CDATA[pass]]></password> //here your password is defined
<dbname><![CDATA[remote_database]]></dbname> //here your database name is defined
4. In your Store Manager, open Preferences -> Actions -> Create new configuration and then put the name of the configuration or press the appropriate button next to the 'Store name' field.
5. Select checkbox "Direct connection through HTTP Tunnel"
6. Specify Remote Database Connection Settings:
7. Use the [Test Connection] button to verify if all settings are correct and connection to your remote database is possible.
8. Click [OK] to save this entry, close Preferences and to connect to your database, or click [Cancel] to discard this entry.
Since the latest release of Store Manager you can specify the version of SSL by using the drop-down list and select/unselect SNI field in the Advanced Settings area, as shown below: