Screen: ShopSite > Orders > Security > Remote Database

Remote Database Configuration

Note:
If you have not already configured ShopSite to use a remote PostgreSQL database, you will see the PostgreSQL Wizard starting screen instead of this screen.

PCI Security Guidelines require merchants who store sensitive information, such as credit cards, to store it on a remote server in an internal network zone (see PCI DSS requirement 1.3,). If you are using a payment service such as PayPal or Google Checkout, or a real-time payment gateway, you can configure ShopSite not to store credit card information. If you process credit cards manually, or if you store credit card information for any other reason, you should use this feature to configure ShopSite to store the sensitive information in a remote PostgreSQL database. You may use this screen to modify settings, or you can click the Remote Wizard button to launch the Remote PostgreSQL Database configuration Wizard.

Use PostgreSQL database for storage of orders Select the Enabled radio button to have ShopSite store sensitive order information using the remote database, or Disabled to have shopsite store the information locally. Once you have started using the remote database, you should avoid unnecessarily switching between using a remote and local database.

PostgreSQL Settings

Use these fields to set or modify the settings ShopSite uses to connect to your remote PostgreSQL database. The initial values for these fields were set when you completed the configuration wizard.
Server Hostname Enter the domain name or IP address of your remote database server in this field.
Server Port Number Enter the port number to use when ShopSite connects to the remote database. The default value, 5432, is the standard port most PostgreSQL databases use.
User Enter the username ShopSite should use when connecting to the remote database.
Password Enter the password for the user account on the remote database. PCI guidelines also require that the password for the database conform to PCI standards (at least seven alphaumeric characters in length, using both letters and numbers).
Database Name Enter the database name ShopSite should use to store orders on the remote database server.

Click Test Connection to have ShopSite test whether or not it can connect to the remote database using the settings on this screen. Click Save to save your current settings and return to the Security Settings screen, or click Cancel to abandon your changes.

ShopSite Help and Resource Center
Last updated: March 01, 2010
Give Feedback

ShopSite Shopping Cart Software