PHP MySQL Bridge Connection Settings
With Store Manager for Magento being installed on the PC, you have to connect to Magento database disposed at the web server in order to view and process your web shop data. The software allows you to reach database resorting to direct, bringe or direct through HTTP tunnel connection.
If you use bridge connection, you actually work with local copy of store database which is being created after you click on Get Data from Web (Ctrl+G) button accessible in Tools section of Store Manager. Correspondingly, changes you have implemented (renewed existing data or added new) will not be displayed at the front-end until they are posted. In such a way, you are obliged to accomplish Post Changes to Web (Ctrl+P) operation.
If you find this type of database connection more favourable and convenient you can choose it for online store management. In order to access data via bridge you have to designate necessary settings manually or use special connection wizard.
Configure Bridge Connection Manually
On condition that you opt for manual method of connection configuring, required details should be inputted in Preferences (F12) -> Database Connection.
Although, first of all the newest version of PHP MySQL Bridge should be downloaded. The file is accessible in Service folder placed in C:\Program Files\eMagicOne\Store Manager for Magento. There you will find default login details. These values should be changed in order to ensure security of your connection. Once you have implemented the alterations, copy bridge.php file to store root directory using FTP client.
Having switched to Database Connection tab in Preferences and opted for PHP Bridge connection type, you should designate the following details:
- Bridge URL - provide Bridge URL in this field, what looks likehttp://www.mystore.com/bridge.php, where http://www.mystore.com is your store URL
- Login and Password - input login details you have provided in bridge.php file
- Local database name - in this field you should provide name of local database. After all the details are configured, check whether connection works pressing Test PHP Bridge connection button
Automate Connection Setup Using Wizard
Another method to establish bridge connection to Magento store database is to use Connection wizard, available in the same Preferences (F12) -> Database Connection window. Once connection utility is launched you are supposed to proceed with several actions:
- Initial wizard page offers two modes of store connection designating. Choose Advanced Mode since it provides the possibility to indicate what exactly connection type you want to set up.
- Succeeding step of connection wizard asks you to opt for suitable action - create new store connection or modify existing one.
- FTP details should be provided in forthcoming window. You are to input server address, username, password and choose root directory.
- Afterwards you have to specify website URL. Use Test Store URL button to verify URL provided.
- As it has been mentioned, this method of connection configuring lets you decide on Magento database connection type. Choose respectively bridge connection in this window.
- Bridge login and password will be designated within the following window.
- Click on Next button and you will be automatically transferred to the next window. Here you will find bridge URL and local database name. Test connection using corresponding button available below in this window.
- After you verify that connection is successful move to subsequent window of connection wizard and designate configuration name.
- Bridge connection settings - bridge URL, database name, login, etc will be displayed in the last wizard window.
While you connect to your store via bridge, you work permanently with database created locally. Each time you have to retrieve database and post alterations afterwards. It is possible to manually input all the details required for bridge connection to be configured or rely upon Connection Wizard.
Read documentation and find out detailed step-by-step instructions on how to configure other types of database connection with Connection Wizard -