AdvertPRO 3.7 Installation Guide

AdvertPRO 3.7 Installation Guide

Introduction
This installation guide will walk you through the process of installing AdvertPRO 3.7. Before you attempt to install AdvertPRO 3.7 it should be noted that these instructions assume your are somewhat familiar with making minor changes to a Perl script, upload files using FTP, and setting permissions on files and directories. In addition, you may also need to create and setup an SQL database if you do not already have one that you can use. If you are not familiar with any one of these things, you should consider paying to have AdvertPRO 3.7 installed for you.

Please be aware that if you have a previous installation of AdvertPRO 3.7, this installation process will wipe out your previous installation. To keep the information in your database intact from a previous installation, you should refer to the instructions in the Upgrade Guide instead.

Remember, if you run into problems or don't understand something, you can always turn to our Knowledge Base and Support Forum. If you prefer to e-mail the AdvertPRO Support Team, you can of course send e-mail to us at support@advertpro.com too.

Hardware Requirements
AdvertPRO does not have any hardware requirements, however we do recommend that your hardware meets or exceeds the criteria below for optimal performance:

Hardware Component	Minimum	Recommended
Processor	Pentium III 550	Pentium III 700+
Memory	128 MB	256 MB+
Hard Disk	EIDE	SCSI

Software Requirements
AdvertPRO has several required and optional software dependencies. We recommend that your system software meets the following criteria for optimal performance:

Software Component	Required?
Perl 5+	Yes
MySQL 3.22+	Yes
Apache mod_fastcgi	No
Apache mod_perl	No
Benchmark	Yes
DBD::mysql	Yes
DBI	Yes
FCGI	No
LWP::Simple	Yes
Net::SMTP	No
Socket	Yes

Before You Start
Before you begin installing AdvertPRO, there are a few things that you need to do first. You should first make sure that your system has all of the required and optional software that you are going to need installed. Once you have made sure that your system has at least the required software installed, next you should setup your database. Setting up your database includes creating a database for AdvertPRO to use and setting up a username and password for AdvertPRO to use to connect to the database.

The following links may be of use to you when installing the required and optional software and also setting up your database.

Perl Help
- Downloading Perl modules
- Installing Perl modules

FastCGI Help
- Downloading mod_fastcgi
- Installing mod_fastcgi
- Optimizing performance

MySQL Help
- Downloading MySQL
- Installing MySQL
- Configuring MySQL
- Creating a MySQL database
- Create a MySQL user

Getting Started
Now that you are ready to begin installing AdvertPRO, simply follow the following steps in order:

1. File Structure
2. Script Configuration *
3. Configuration File *
4. File Uploading
5. Program Configuration

* If your AdvertPRO 3.7 package was pre-configured you can skip step #2 and step #3.

File Structure
The figure below is a graphical representation of the file structure that is used by AdvertPRO. The file structure is broken down into two parts. The first part of the file structure, which is the structure on the left below, contains all non-program files. The second part of the file structure, which is the other structure on the right below, contains all of the actual program files.

Script Configuration
Before you begin configuring any scripts, you need to make sure that you use a proper text editor to edit the scripts first. We recommend that you use either Windows Notepad, TextPad, UltraEdit, emacs, or vi to edit the scripts. You should not use an editor that applies any type of formatting at all.

In this step you will be modifying all of the scripts that have a .pl or .fpl extension. You will find these files are located in the /cgi-bin/advertpro and /cgi-bin/advertpro/admin directories.The following figure is a graphical representation of what you will see when you open each of these scripts. The lines have been numbered along the left hand side for your convenience.

The first line in all of these files is #!/usr/bin/perl -w by default. This line should be changed to point to the Perl 5 executable on your system if it is installed in a different location. If you do not know what the path to Perl 5 is on your system, contact your hosting company or system administrator and ask them.

The next change that you need to make to all of these files requires that you know where you are going to be installing AdvertPRO on your system. This change will be made on line number thirty-seven in the figure above, however the line number may vary by a few lines in each of the scripts. In all of these files, the line is use lib '/path/to/cgi-bin/advertpro/library'; by default. You will need to change the /path/to/cgi-bin/advertpro/library portion, which is displayed in light blue in the figure above, to point to the location of the /cgi-bin/advertpro/library directory on your system.

Configuration File
In this step you will be modifying the Config.pm file that contains the configuration settings for AdvertPRO. You will find this file is located in the /cgi-bin/advertpro/library/AdvertPRO directory. The following figure is a graphical representation of what you will see when you open this file. The lines have been numbered along the left hand side for your convenience.

When you have located the above section of the Config.pm file, you will need to make several changes. Please keep in mind that we only recommend changing the section of the Config.pm file that is shown in the figure above. The entire Config.pm file is not shown in the figure above because we do not recommend that you modify the rest of the file by hand. You absolutely should not edit anything above or below the comments that tell you not to edit anything above or below them.

The changes that you need to make to the Config.pm file require that you know where you are going to be installing AdvertPRO on your system. You will also need to know some information about your SQL database. This information includes the name of the actual database, the username and password to access it, and the hostname and port to access it through.

In order to make the changes to the Config.pm file, you need to know what each of the variables in the file represent. The descriptions of each of the variables in the table below will help you to make the necessary changes.

Variable Name	Description
LICENSE	The license key that was sent to you when you purchased AdvertPRO.
DOMAIN	The domain name that you will access AdvertPRO through.
SCRIPTS_PATH	The full system path to your /cgi-bin/advertpro directory.
SCRIPTS_URL	The URL of your /cgi-bin/advertpro directory.
SCRIPTS_URI	The URI of your /cgi-bin/advertpro directory.
SCRIPTS_EXT	The file extension that is used with your scripts. You probably don't need to change this unless you are running AdvertPRO under mod_fastcgi.
HTML_PATH	The full system path to your /advertpro directory.
HTML_URL	The URL of your /advertpro directory.
DATABASE_SOFTWARE	The SQL database software that you are using with AdvertPRO.
DATABASE_URL	The Database URL that you use to connect to your SQL database. The following syntax should be used for the Database URL: DBI:driver:database:host:port The driver is the name of the DBI driver that you are using for your database software. The database is the name of your SQL database. The host is the hostname of the system that your SQL software is installed on. And the port is the port number that your SQL software is running on.
DATABASE_USERNAME	This is the username that you use to connect to your SQL database.
DATABASE_PASSWORD	This is the password that you use to connect to your SQL database.
LANGUAGE	Allows you to choose a different language for the Control Panels.
CACHE	If you are running AdvertPRO under mod_perl or mod_fastcgi, this will greatly improve performance by keeping data in memory and database connections open constantly. Please be aware that if you choose to enable caching of data, a delay is introduced for changes to take effect. Whenever you create, edit, or delete any advertiser, banner, campaign, group, publisher, or region, those changes can take up to the amount of time you've set the CACHE_REFRESH variable to. However, if you need the extra performance, this is generally not a problem.
CACHE_REFRESH	Allows you to specify how long, in minutes, data that is cached in memory will stay in memory.

File Uploading
You are now ready to upload the AdvertPRO files to your web server. You will most likely need to go to your Document Root and upload the files there. Please be aware that it is very important that you make sure to upload all of the .cgi, .fcgi, .fpl, .pl, .pm, .html, and .txt files in ASCII mode rather than Binary mode. You should only use Binary mode to upload the .gif image files.

Below is the file structure you should end up with once you have uploaded all of the files. In addition, some files require that you set permissions on them using the chmod command. Any files that require special permissions have been marked below with the permissions they require.

/advertpro	..
../backup	rwx rwx rwx <777>
../banners	rwx rwx rwx <777>
..../100x100	rwx rwx rwx <777>
..../120x240	rwx rwx rwx <777>
..../120x60	rwx rwx rwx <777>
..../120x600	rwx rwx rwx <777>
..../120x90	rwx rwx rwx <777>
..../125x125	rwx rwx rwx <777>
..../160x600	rwx rwx rwx <777>
..../180x150	rwx rwx rwx <777>
..../234x60	rwx rwx rwx <777>
..../240x400	rwx rwx rwx <777>
..../250x250	rwx rwx rwx <777>
..../300x250	rwx rwx rwx <777>
..../336x280	rwx rwx rwx <777>
..../392x72	rwx rwx rwx <777>
..../468x60	rwx rwx rwx <777>
..../88x31	rwx rwx rwx <777>
..../other	rwx rwx rwx <777>
../docs	..
../etc	rwx rwx rwx <777>
../exports	rwx rwx rwx <777>
../images	..
..../admin	..
..../advertiser	..
..../publisher	..
../templates	..
..../english	..
....../admin	..
....../advertiser	..
....../help	..
....../misc	..
....../publisher	..
....../statistics	..
......../advertiser	..
......../export	..
......../publisher
../test	..
..	..
/cgi-bin	..
../advertpro	..
..../admin	..
....../admin.pl	rwx r-x r-x <755>
..../library	..
....../AdvertPRO	..
......../Admin	..
........../Advertiser	..
........../Publisher	..
........../Statistics	..
......../Cache	..
........../Campaign	..
......../Utility	..
......../Config.pm	rwx rwx rwx <777>
..../plugins	..
..../advertisers.cgi	rwx r-x r-x <755>
..../advertisers.fcgi	rwx r-x r-x <755>
..../advertisers.fpl	rwx r-x r-x <755>
..../advertisers.pl	rwx r-x r-x <755>
..../banners.cgi	rwx r-x r-x <755>
..../banners.fcgi	rwx r-x r-x <755>
..../banners.fpl	rwx r-x r-x <755>
..../banners.pl	rwx r-x r-x <755>
..../bimg.cgi	rwx r-x r-x <755>
..../bimg.fcgi	rwx r-x r-x <755>
..../bimg.fpl	rwx r-x r-x <755>
..../bimg.pl	rwx r-x r-x <755>
..../blink.cgi	rwx r-x r-x <755>
..../blink.fcgi	rwx r-x r-x <755>
..../blink.fpl	rwx r-x r-x <755>
..../blink.pl	rwx r-x r-x <755>
..../publishers.cgi	rwx r-x r-x <755>
..../publishers.fcgi	rwx r-x r-x <755>
..../publishers.fpl	rwx r-x r-x <755>
..../publishers.pl	rwx r-x r-x <755>
..../remote.cgi	rwx r-x r-x <755>
..../remote.fcgi	rwx r-x r-x <755>
..../remote.fpl	rwx r-x r-x <755>
..../remote.pl	rwx r-x r-x <755>
..../test.pl	rwx r-x r-x <755>

Program Configuration
In this step you will finish configuring AdvertPRO to run on your web server.

The first thing you need to do is open up admin.pl (file extension may be different depending on your configuration!) by typing in the URL to it in your web browser. If you have properly followed the previous steps, you should see the Administrator Control Panel load up. If you receive any error messages, you most likely made a mistake in one of the previous steps. Providing that you do receive any error messages, you will need to login to AdvertPRO. By default, the password is set to password.

Next, you will want to click on Maintenance in the menu at the top of the screen. You should now see a good number of options that will allow you to configure and customize AdvertPRO to your liking. When you are done making changes, press the Save Changes button at the bottom of the page. This will save your changes and load your new configuration.

Next, you will want to click on Create Tables in the menu to the left. When the table creation utility loads up, follow the instructions on the screen to create the database tables that AdvertPRO uses.

That's it! You have successfully completed the installation of AdvertPRO.