Doteasy Tutorials - Scripting

Setting up osCommerce 2.2

osCommerce is an online shop e-commerce solution developed by the open source community. Its feature packed out-of-the-box installation allows store owners to setup, run, and maintain their online stores with minimum effort and with absolutely no costs or license fees involved. It also include support for many popular payment gateways and alternative payment methods.

View Demo: http://www.samplesite.org/osc

This tutorial will guide you through the osCommerce setup and installation process on our servers. It is assumed that your account has support for PHP and MySQL database and that you have already created your database.

To protect your customer information, it is highly recommended that you also have an SSL certificate for data encryption. Click here for more info on SSL certificates. Contact Doteasy to purchase your SSL certificate today.

Part A - Downloading the Script

Download our customized version of the osCommerce 2.2 script. It has been modifed to be compatible with our servers. Click here.

The osCommerce distribution file that you will download is in .zip compressed format. Unpack this archive in a temporary directory on your computer using decompression software.

Part B - Uploading Files to Server

Before you begin, please ensure that you have created your MySQL database on your web server via your Site Administration Panel. View the database creation tutorial.

If your MySQL database is already created, you are ready to upload osCommerce files to the server.

Start your FTP software and connect to your web server

From your osCommerce unpacked files, upload the entire folder and contents of the /catalog folder to the /var/www/html/ location on your server.

Part C - Software Configuration

Access the osCommerce configuration script with your web browser, http://www.yourdomain.com/catalog/install

(Replace yourdomain.com with your domain name)

Click Install.

Please customize the new installation with the following options:

Please enter the database server information:

Database Server:	127.0.0.1
Username:	Doteasy memberID
Password:	database password
Database Name:	database name eg, yourdomain_com_-_db
Persistent Connections:	Uncheck
Session Storage:	Select Database

A test connection made to the database was successful. Click Continue

The database import was successful! Click Continue

Please enter the web server information:

WWW Address:	http://www.yourdomain.com (Replace yourdomain.com with your domain)
Webserver Root Directory:	/var/www/html/catalog/
HTTP Cookie Domain:	www.yourdomain.com
HTTP Cookie Path:	/catalog/
Enable SSL Connections:	check (more info on SSL)

Click Continue.

Please enter the secure web server information:

Secure WWW Address:	https://www.yourdomain.com (Replace yourdomain.com with your domain) (more info on SSL)
Secure Cookie Domain:	www.yourdomain.com
Secure Cookie Path:	/catalog/

Click Continue.

Click Continue to confirm.

Configuration should be successful.

Part D - Security

Your installation directory is located at: /var/www/html/catalog/install. Using your FTP software, please remove this entire directory for security reasons as it is no longer needed.

Change file permission for the file configure.php, located at /var/www/html/catalog/includes/configure.php to 4-4-4 or:

Owner: Allow Read only
Group: Allow Read only
Others: Allow Read only

To change file permissions using CuteFTP, select the file by clicking on it once on the remote system side and then right-click on the file to bring up the option menu and select CHMOD.

To assign the correct file permissions under Owner check Read, under Group check Read, and under Other check Read . The manual value of the permission is 4-4-4.

Use your server Password Protected Directories function to protect your shopping cart admin page. Login to your Site Administration Panel. In the shortcuts area, click Protect Directories (File Manager section).

If you have not done so already, create an HTAccess group, then specify the user or users who belong to the group. You need to create at least one group and add at least one user to that group before you can protect a directory. Click Manage Groups.

Enter Group name and click ADD.

Click Manage Users.

Enter UserName, Password, select group and click Add/Edit.

Click Protect Directories.

Select the directory or folder that you would like to protect. For osCommerce users you need to protect /var/www/html/catalog/admin/. Click .

In the AuthName field, enter 'osCommerce Admin' as the descriptive name for the directory. Click Protect.

An 'X' will appear on the lock icon and the folder is now protected.

Part E - Email Address Configuration

Login to Doteasy Webmail to view your email server host name. After you login to Webmail, the URL address of the Webmail connection will display your email server host name. In this example the email server host name is dpmail01.doteasy.com. Once you have found the host name, you may logout of Webmail and close your browser.

Access your osCommerce admin control panel at http://www.yourdomain.com/catalog/admin. (Replace yourdomain.com with your domain)

Click Configuration.

Select to configure E-mail Address.

Click Edit.

Specify the recipient email address using the following format and replace dpmail01.doteasy.com with your mail server name:

userID%yourdomain.com@dpmail01.doteasy.com

Click update.

Your osCommerce setup is now complete.

View your shopping cart at: http://www.yourdomain.com/catalog

Access your osCommerce Admin Panel at: http://www.yourdomain.com/catalog/admin