AdvertPRO - Windows Installation

Step #1: Download Files

AdvertPRO

Please follow the instructions provided to you by e-mail to download AdvertPRO from the Renegade Internet extranet web site.

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.

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:
   • MySQL 4.0: http://www.mysql.com/downloads/mysql-4.0.html
   • MySQL 4.1: http://www.mysql.com/downloads/mysql-4.1.html
   • MySQL 5.0: http://www.mysql.com/downloads/mysql-5.0.html (recommended)
2. Scroll down to the table labeled Windows downloads.
3. Download the Windows (x86) installer.

MySQL Connector/J JDBC Driver

1. Open a browser window to one of the following:
   • MySQL 4.0: http://dev.mysql.com/downloads/connector/j/3.0.html
   • MySQL 4.1: http://dev.mysql.com/downloads/connector/j/3.1.html
   • MySQL 5.0: http://dev.mysql.com/downloads/connector/j/5.0.html (recommended)
2. Download the Source and Binaries (zip) package.

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!

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!

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

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
        

MySQL Service

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

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>
        

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.

Firewall Configuration

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

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!