Installing ShopSite Enterprise

ShopSite Enterprise is a high-end solution for merchants wanting to run a database server such as MySQL or MariaDB. Enterprise can be installed on your 64-bit Linux server; the only tools required are a Web browser and SFTP/FTPS and shell (SSH) access to your server.

Warning:

Whenever connecting to your server for administrative purposes (such as installing or upgrading ShopSite), you should use a secure connection. Telnet and standard FTP are both unencrypted connections, and could be intercepted. Always use a secure connection, such as SSH for shell connections, and FTP over SSH or SFTP for file transfers.

Overview

The process of installing ShopSite Enterprise is very similar to installing standard ShopSite for Pro, Manager or Starter stores except that additional steps are needed for the database server. To begin, follow the standard ShopSite installation instructions for Preparation, Obtaining Installation Files, and Uploading the files. After comnpleting these sections you are ready to Setup the Database Server.

Setup Database Server

ShopSite Enterprise supports either MySQL or MariaDB database servers. Once you have a working version of either database server do the following:

create an empty MySQL/MariaDB database

create a MySQL/MariaDB user with password

copy ss_removehtml.so (from the install directory) into MySQL/MariaDB'ss plugin directory (this is typically located in /usr/lib64/mysql/plugin). Then create link to the file using:

   CREATE FUNCTION ss_removehtml RETURNS STRING SONAME 'ss_removehtml.so';

To see if Create worked run:

   SELECT * FROM mysql.func WHERE name = "ss_removehtml";

Make note of the MySQL/MariaDB URL and port # or if localhost the Socket File path and name for use when you later run wwwinstall.cgi

Turn on MySQL error logging (optional but might be needed to help trouble-shoot later). Add this line to data/cr.aa:

   mysql_log_error: 1

This will log SQL statement errors into data/mysql_error.log with the Error and the offending sql query.

Finish Installation

standard ShopSite installation instructions

Fill in the appropriate information that you noted when you set up the initial database or table. Then complete the other installation prompts as documented here.