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 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.

Note:

Transmitting credit card data wirelessly is not recommended. If, however, it is necessary to do so, PCI compliance dictates that the the wireless network complies with PCI DSS Requirements 1.2.3, 2.1.1, and 4.1.1. In short, the network must be secured using the appropriate firewalls and must use an encryption protocol stronger than WEP. See the specific sections for more information.

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.

Note:

The PostgreSQL database must be configured for Latin1 encoding.

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: January 03, 2014
Give Feedback

ShopSite Shopping Cart Software