Standard Installation (In-Process)

This guide covers AuctionWorx Shared Installation. Shared Installation mode allows an AuctionWorx Web Application to run on a web server alongside other Web Applications and/or other installations of AuctionWorx. The major components of the installation are as follows:

Microsoft Windows Server

AuctionWorx runs on Microsoft Windows Server 2008 or newer.

Microsoft SQL Server

A Microsoft SQL 2008 or higher database is required. The database must support Full-Text Indexing which is an optionally installed component of Microsoft SQL Server.

Microsoft Internet Information Server (IIS)

The AuctionWorx site runs under IIS 7.0 or newer.

Web Files

The following are integral file system components of any AuctionWorx installation:

Other Requirements

AuctionWorx requires Microsoft .NET Framework Version 4.5.1. Access to an SMTP server is also required for AuctionWorx to send emails.

 

Installation Steps

In the following instructions reference is made to “Full Permission” and “Read-Only Permission.” What this means can vary depending on what versions of Windows and IIS you are running. “Full Permission” refers to the web site’s ability to write files or write to files. “Read-Only Permission” refers to the web site’s ability to read files. Your environment may vary depending on whether you allow anonymous access to your AuctionWorx installation. Consult your administrator or web hosting company if necessary.

1. Create a Microsoft SQL database. It should be assigned a user with Database Owner Privileges (db_owner aka dbo). Microsoft Full-Text Indexing must also be installed with the SQL Server.

2. The SQL folder in your installation package contains the AuctionWorx database scripts. Execute the database script, “AuctionWorx.sql,” against the database you created in step 1. Optionally, and subsequent to “AuctionWorx.sql,” you may also execute the default categories script, “AuctionWorx_AddCategories.sql,” to populate default categories.

   Note: Be Advised, the default categories script will take a while to execute as it optimizes category hierarchies for the 25,000+ categories it contains.

3. Copy the contents of the Web folder from the installation package to the Web Root of the new AuctionWorx installation. This folder requires Read-Only Permissions.

4. Within the Web Root, you must assign Full Permission to the \Content\images\Logos folder. Although your site's administrator(s) will upload logos; the Worker Process is what actually writes them to the file system.

5. Within the Web Root, you must assign Full Permission to the \Content\listingImages folder. Although your site's users will upload listing images; the Worker Process is what actually writes them to the file system.

6. Within the Web Root, you must assign Full Permission to the \Content\images\Banners folder. Although your site's administrator(s) will upload banner(s); the Worker Process is what actually writes them to the file system.

7. Edit the connection string in the web.config file, now located in your Web Root, to refer to the database you created in step 1.

8. Edit the “LicenseKey” setting in the web.config file, to contain your provided license key. Your license key should not be shared with anyone.

9. Edit the following section of the web.config file to refer to your email server (if login is not required, remove the username and password attributes):

<mailSettings>

<smtp>

<network host="yoursmtpserver" userName="username" password="secret" port="25"/>

</smtp>

</mailSettings>

10. Edit the robots.txt file, now located in your Web Root, un-comment the last line, and replace [YourDomainName] with the correct value.

Example: Sitemap: http://www.MyAuctionSite.com/sitemap.xml

11. The default administrator login for your new installation of AuctionWorx is username “admin” and password “admin1234”

12. Login to the site to change the administrator’s password:

    1. Click “Sign In” in the upper right-hand corner

    2. Login as the administrator with username “admin” and password “admin1234”

    3. Click “My Account” in the top horizontal navigation bar

    4. Click “Password” under “Account” in the left navigation bar

    5. Complete the form to change the administrator’s password

Using SSL

It is recommended that you use an SSL certificate to encrypt communications on sensitive pages of your installation. After you've installed an appropriate SSL certificate, perform the following steps:

1. Login to the site as an administrator and access the "Admin Control Panel."
2. Under "Site Preferences / Setup," set the "URL" and "Secure URL" properties appropriately.
3. Set the "EnableSSL" setting in the web.config file to "true". Once you do this, the above URL settings will be enforced.

Note: Only set “EnableSSL” to “true” after you have set the “URL” and “Secure URL” properties from step 2 properly or you may not be able to access the site.

Optional Database Maintenance

It is recommended that you perform regular maintenance on your database to optimize performance.

Included with AuctionWorx is an “RWX_ADM_OptimizeDatabase” stored procedure that you can run on demand or schedule as a SQL job. This procedure is minimal in that it will rebuild all indexes, update all statistics, and update usages (regardless of whether a rebuild/update is necessary).

While this stored procedure is executing, tables will be locked, so it should be run during periods of least activity. If your workflow cannot tolerate table locks at any time, please consult your database administrator for an alternate solution.