AdvertPRO - Windows Installation

Step #1: Download Files

AdvertPRO

  1. Open a browser window to: https://services.renegadeinternet.com/download/
  2. Enter your Customer ID and E-mail Address into the form.
  3. Select the operating system your server is running from the Platform list box.
  4. Select the Install package for a clean installation from the Package list box.
  5. Click on the Download Package button to proceed.
  6. Check your e-mail and you should receive an e-mail with a download link within a few minutes.

Java Development Kit

  1. Open a browser window to: http://java.sun.com/j2se/downloads/index.html
  2. Click on the Previous Releases at the top of the page.
  3. Click on the J2SE 5.0 Downloads link at the top of the page.
  4. Click on the Download button to the right of JDK 5.0 Update 15 near the middle of the page.
  5. Accept the license agreement and continue.
  6. Download the Windows Offline Installation, Multi-language for the Windows Platform.

Note Note

J2SE 1.4.0, 1.4.1, and 1.4.2 are also supported, however we recommend using J2SE 5.0 (1.5.0) for new installations.

Java Libraries

  1. Download the JavaMail 1.4 library from http://java.sun.com/products/javamail/downloads/index.html.
  2. Download the JAF 1.1 library from http://java.sun.com/javase/technologies/desktop/javabeans/jaf/downloads/index.html.

MySQL Database Server

  1. Open a browser window to one of the following:
  2. Scroll down to the table labeled Windows downloads.
  3. Download the Windows (x86) installer.

Note Note

» We fully support the MySQL 4.0, 4.1 and 5.0 series, however we recommend using MySQL 5.0 for new installations.

» The older MySQL 3.23 series is also supported, but it's not recommended for new installations.

» We do not recommend using the MySQL 5.1 series as it is not stable or production quality and as such it is not supported.

MySQL Connector/J JDBC Driver

  1. Open a browser window to one of the following:
  2. Download the Source and Binaries (zip) package.

Note Note

The driver for MySQL 4.0 is also compatible with the older MySQL 3.23.

Apache Tomcat Server

  1. Open a browser window to: http://tomcat.apache.org/download-55.cgi
  2. Scroll down to the listing for Tomcat 5.5.26.
  3. Download the Binary Distribution labeled Core: Windows Executable.

Step #2: Installation

Java Development Kit

  1. Run the jdk-1_5_0_<version>-windows-i586-p.exe executable that you downloaded in Step #1.
  2. When prompted for the installation directory, you should enter: C:/Java/1.5.0_<version> -- do not enter a directory name with spaces!

Note Note

You will find more complete installation instructions here: http://java.sun.com/j2se/1.5.0/install-windows.html

MySQL Database Server

  1. Unzip the mysql-<version>-win.zip file that you downloaded in Step #1.
  2. Run the Setup.exe executable that is contained the unzipped files.
  3. When prompted for the installation directory, you should enter: C:/MySQL -- do not enter a directory name with spaces!

Note Note

You will find more complete installation instructions here: http://dev.mysql.com/doc/mysql/en/windows-installation.html

Apache Tomcat Server

  1. Run the apache-tomcat-<version>.exe executable that you downloaded in Step #1.
  2. When prompted for the installation directory, you should enter: C:/Tomcat -- do not enter a directory name with spaces!
  3. You should choose to do a Full installation in order to install the Windows service to start Tomcat automatically when Windows starts.

Java Libraries

unzip javamail-<version>.zip
copy javamail-<version>/mail.jar C:/Tomcat/common/lib/mail.jar
unzip jaf-<version>.zip
copy jaf-<version>/activation.jar C:/Tomcat/common/lib/activation.jar

MySQL Connector/J JDBC Driver

unzip mysql-connector-java-<version>.zip
cd mysql-connector-java-<version>
copy mysql-connector-java-<version>-bin.jar C:/Tomcat/common/lib/mysql.jar

Warning Warning

Do not use the mysql-connector-java-<version>-bin-g.jar version of the driver! It is a DEBUG version of the driver and is very slow.

AdvertPRO

copy advertpro-<version>.war C:/Tomcat/webapps/advertpro.war

Step #3: Configuration

Environment Variables

  1. Right click on My Computer
  2. Choose the Properties option.
  3. Click on the Advanced tab and then click on the Environment Variables... button.
  4. Add a new System Variable named JAVA_HOME with a value of C:/Java/1.5.0_<version>.

MySQL Settings

Edit C:/my.cnf and use the following as a template.

[client]
port = 3306

[mysqld]
bind-address = 127.0.0.1
basedir = C:/MySQL
datadir = C:/MySQL/data
port = 3306
skip-locking
set-variable    = max_connections=384
set-variable    = key_buffer=64M
set-variable    = table_cache=256
set-variable    = sort_buffer=4M
set-variable    = record_buffer=1M
set-variable    = max_allowed_packet=16M
set-variable    = myisam_sort_buffer_size=64M
set-variable    = thread_cache=8
server-id       = 1
old_passwords   = 1

[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout
        

Note Note

These settings are for MySQL 5.0.x (and also compatible with MySQL 4.1.x), which is the version we recommend using. If you are using an older version of MySQL, please contact technical support for configuration guidance if needed.

MySQL Service

C:/MySQL/bin/mysqld-nt --install MySQL --defaults-file=C:\my.cnf

Note Note

At this point, you will probably also want to edit the MySQL service through the contorl panel and configure it to startup automatically when the system boots and also restart automatically if any failures are detected.

Apache Tomcat Settings

Edit C:/Tomcat/conf/server.xml and use the following as a template.

<Server className="org.apache.catalina.core.StandardServer"
        debug="0"
        port="8005"
        shutdown="SHUTDOWN">

  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
            debug="0"/>

  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
            debug="0"/>

  <Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"
            debug="0"/>

  <GlobalNamingResources>
    <Resource name="UserDatabase"
              auth="Container"
              type="org.apache.catalina.UserDatabase"
              description="User database that can be updated and saved"
              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname="conf/tomcat-users.xml"/>
  </GlobalNamingResources>

  <Service className="org.apache.catalina.core.StandardService"
           debug="0"
           name="Catalina">

    <!--
      You cannot run both Apache or IIS and Tomcat on the same ports!
    -->
    <Connector acceptCount="128"
               bufferSize="2048"
               className="org.apache.coyote.tomcat5.CoyoteConnector"
               compression="off"
               connectionLinger="-1"
               connectionTimeout="30000"
               debug="0"
               disableUploadTimeout="false"
               enableLookups="false"
               maxKeepAliveRequests="0"
               maxHttpHeaderSize="8192"
               maxThreads="512"
               maxSpareThreads="480"
               minSpareThreads="32"
               port="80"
               redirectPort="443"
               URIEncoding="UTF-8"/>

    <!--
      Uncomment the following for isapi_redirect or mod_jk
    -->
    <!--
    <Connector acceptCount="128"
              className="org.apache.coyote.tomcat5.CoyoteConnector"
              debug="0"
              enableLookups="false"
              maxThreads="384"
              maxSpareThreads="48"
              minSpareThreads="16"
              port="8009"
              protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"
              protocol="AJP/1.3"
              redirectPort="8443"
              URIEncoding="UTF-8"
              useURIValidationHack="false"/>
    -->

    <Engine className="org.apache.catalina.core.StandardEngine"
            debug="0"
            defaultHost="localhost"
            mapperClass="org.apache.catalina.core.StandardEngineMapper"
            name="Catalina">

      <Host className="org.apache.catalina.core.StandardHost"
            appBase="webapps"
            autoDeploy="true"
            debug="0"
            name="localhost"
            unpackWARS="true"
            xmlValidation="false"
            xmlNamespaceAware="false">

        <Context charsetMapperClass="org.apache.catalina.util.CharsetMapper"
                 cookies="true"
                 crossContext="false"
                 debug="0"
                 docBase="ROOT"
                 mapperClass="org.apache.catalina.core.StandardContextMapper"
                 path=""
                 privileged="false"
                 reloadable="false"
                 swallowOutput="true"
                 useNaming="true"
                 wrapperClass="org.apache.catalina.core.StandardWrapper"/>

        <Context charsetMapperClass="org.apache.catalina.util.CharsetMapper"
                 cookies="true"
                 crossContext="false"
                 debug="0"
                 docBase="advertpro"
                 mapperClass="org.apache.catalina.core.StandardContextMapper"
                 path="/advertpro"
                 privileged="false"
                 reloadable="false"
                 swallowOutput="true"
                 useNaming="true"
                 wrapperClass="org.apache.catalina.core.StandardWrapper"/>

      </Host>

      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
             debug="0"
             resourceName="UserDatabase"/>

    </Engine>

  </Service>

</Server>
        

Note Note

These settings are for Tomcat 5.5.x, which is the version we recommend using. If you are using an older version of Tomcat, please contact technical support for configuration guidance if needed.

Apache Tomcat Service

  1. Go to Start -> Run and execute: C:/Tomcat/bin/tomcat5w.exe //ES//Tomcat5
  2. Click on the Java tab.
  3. Enter a value of at least 128 in the Initial Memory Pool field and then enter the same value in the Maximum Memory Pool field.
  4. Then enter a value of 128 in the Thread Stack Size field.

Note Note

» At this point, you will probably also want to edit the Tomcat service through the control panel and configure it to startup automatically when the system boots and also restart automatically if any failures are detected.

» It is also necessary to make the Tomcat service dependant on the MySQL service to ensure they are started in the correct order. This can be done by editing the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tomcat5 registry key and adding a new Multi-String Value to it named DependOnService with a value of MySQL, assuming of course that's what you've named the MySQL service.

Firewall Configuration

AdvertPRO needs the following ports to be open in your firewall in order to function properly:

Port NumberProtocolAllow InputAllow OutputClient/Source AddressDestination AddressUsed By
25TCPYesYesAnyAnySMTP
80TCPYesYesAnyAnyHTTP
443TCPYesYesAnyAnyHTTPS
3306TCPYesYeslocalhostlocalhostMySQL
9000TCPNoYeslocalhostwebsvc1.advertpro.com
websvc2.advertpro.com
AdvertPRO
9001TCPNoYeslocalhostwebsvc1.advertpro.com
websvc2.advertpro.com
AdvertPRO
9002TCPNoYeslocalhostwebsvc1.advertpro.com
websvc2.advertpro.com
AdvertPRO
9003TCPNoYeslocalhostwebsvc1.advertpro.com
websvc2.advertpro.com
AdvertPRO
9004TCPNoYeslocalhostwebsvc1.advertpro.com
websvc2.advertpro.com
AdvertPRO
9005TCPNoYeslocalhostwebsvc1.advertpro.com
websvc2.advertpro.com
AdvertPRO

Failure to open the aforementioned ports in your firewall will cause the AdvertPRO setup utility to abort.

Step #4: Startup

MySQL Database Server

Start the MySQL service through the Control Panel.

Apache Tomcat Server

Start the Tomcat service through the Control Panel.

Step #5: Finishing Up

AdvertPRO

  1. Open a browser window to: http://www.yoursite.com/advertpro/servlet/setup
  2. Follow the setup utility instructions.
  3. Make sure to follow the post-install instructions too!

Note Note

» This step assumes that you've already created a MySQL database and user for AdvertPRO.

» If you have purchased the GeoIP Country or City modules, you should place the database you downloaded in C:/Tomcat/webapps/advertpro/modules named GeoIPCountry.dat or GeoIPCity.dat, depending on which edition you actually purchased before running the setup utility.

» It may take about 30 seconds from the time your start Apache Tomcat for it to automatically deploy AdvertPRO.