Solutions : Site Management : Database Maintenance

Database Maintenance
Installation and Usage

FILENAME: dm.html

PURPOSE: Describes Database Maintenance dependencies, requirements, installation and usage.

DEPENDENCIES:

cm.pl - Configuration Management configuration and common logic modules (see: cm.html)
jhzcs.pl - JHZ-CS configuration and common logic modules (see: jhzcs.html)
IID (Item Information Dataset)
An RDBMS SQL database installed and configured

REQUIREMENTS:

Logic Modules

dm.pl - common configuration and logic module

PACKING (PARTS) LIST

INSTALLATION:

CONFIGURATION SETTINGS:

IMPORTANT! There are specific installation and configuration instructions contained in "cm.html" pertaining to "cm.pl" that must be successfully completed in order to permit this product to successfully perform its functions.

Locate the following line of code shown below in "dm.pl" and modify as described.

require "/home/cust/yourdomainname/www/cgi-bin/cm/cm.pl";

Change the content between quotes in the "require" statement "/home/cust/yourdomainname/www/cgi-bin/cm/cm.pl" to correctly point to the absolute path of "cm.pl" on the web server.

Locate the following section of code in "dm.pl" and modify as described below:

############################################################
#
#    CONFIGURATION SECTION - START
#

$debug = 1;

$DBMcgidir = $cgibin_base."cm/dm";

#    PLATFORM
#    examples:
#        Windows use "DOS"
#        UNIX/Linux/MacOSX use "UNIX"
$platform = "UNIX";

#    PLATFORM SPECIFIC DRIECTORY LIST COMMAND
#    examples:
#        DOS command is "dir"
#        UNIX/Linux/MacOSX command is "ls"
$platformdirlistcmd  = "ls ";

#    PROTECTED DATA ITEMS
$DONT_UPDATE{customer_info}   = 1;
$DONT_UPDATE{customer_hist}   = 1;
$DONT_UPDATE{tracking}        = 1;

$DONT_ALTER{customer_info}    = 1;
$DONT_ALTER{customer_hist}    = 1;

$DONT_DROP{customer_info}     = 1;
$DONT_DROP{customer_hist}     = 1;
$DONT_DROP{tracking}          = 1;

$DONT_DELETEDATA{customer_info}   = 1;
$DONT_DELETEDATA{customer_hist}   = 1;
$DONT_DELETEDATA{tracking}        = 1;

#
#    CONFIGURATION SECTION - END
#
############################################################

1. Comment the following line:
   

   $debug = 1;

   using the PERL comment character # as follows:

   #$debug = 1;

2. If not using the default install locations, change the content between quotes in value assigned to "$DBMcgidir" to correctly point to the subdirectory path relative to "$cgibin_base" defined in "jhzcs.pl" where "dm.cgi" is to be installed.
3. Change the value between quotes assigned to "$platform" to reflect the web server operating system; see embedded instructions.
4. Change the value between quotes assigned to "$platformdirlistcmd" to reflect the web server operating system command for displaying a directory list; see embedded instructions.
5. The items contained under

   #	PROTECTED DATA ITEMS

   reflect database tables that are dynamically generated and are not to be modifiable using the DB Maintenance functions. These items should not be changed unless otherwise instructed by JHZ-CS.

USAGE:

After having successfully completed the installation instructions above, DB Maintenance should be ready for use.

Invoke DB Maintenance by specifying its URL using your web browser.

http://www.yourdomain.com/cgi-bin/cm/dm/dm.cgi
	

A brief description of each function and its commands is displayed when DB Maintenance starts up. The available functions are listed at the top of the page. Whena function is clicked the function's commands are displayed in the left column. When a command is clicked the initiation page for that command is displayed. Follow the instructions provided on each page.

The first time you run DB Maintenance it will be necessary to establish the database parameters and define the default database tables. Use the Database function's Initialize command to perform this operation. Following the instructions provided on the Initialize command page.

To use the other functions of DB Maintenance, view the various function and command descriptions displayed while running DB Maintenance.