AdvertPRO - Linux Installation

Prerequisites

Linux Distributions

There are many different distributions of Linux based operating systems. Every distribution has its own recommended way of installing and configuring packages. Some parts of these instructions assume that you are working with a Linux distribution that has RPM support, which includes the popular CentOS and Red Hat Linux. For other distributions, you may need to refer to their specific Java and MySQL installation instructions.

Apache HTTPD

If you are running Apache HTTPD to host other web sites or applications on the same server as AdvertPRO is going to be installed on, please follow these alternate instructions for configuring Apache Tomcat to connect with Apache HTTPD using the mod_proxy_ajp module: Apache + mod_proxy_ajp + Tomcat Installation

Nginx

If you are running Nginx to host other web sites or applications on the same server as AdvertPRO is going to be installed on, please follow these alternate instructions for configuring Apache Tomcat to connect with Nginx using the ey_balancer module: Nginx + ey_balancer + Tomcat 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://www.oracle.com/technetwork/java/javase/downloads/
2. Click on the Java Download graphic for Java Platform (JDK).
3. Click on the Accept License Agreement radio button on the next page.
4. Then click on the RPM download link for Linux x86 if you have a 32-bit system or Linux x64 if you have a 64-bit system.

Java Libraries

1. Download the JavaMail 1.4 library from http://www.oracle.com/technetwork/java/javamail-1-4-140512.html.
2. Download the JAF 1.1 library from http://www.oracle.com/technetwork/java/jaf11-139815.html.

MySQL Database Server

In most cases your distribution of Linux probably already has MySQL included with it. We recommend using that version of MySQL rather than trying to remove it and install a different version. The reason being that the developer of your distribution has certified that version of MySQL to be stable with it.

For users of CentOS or Red Hat Linux downloading and installing MySQL is as easy as running the following command:

yum install mysql mysql-server

If you use a different version of Linux or prefer to manually download MySQL and install it you may obtain it using the following instructions.

1. Open a browser window to: http://dev.mysql.com/downloads/mysql/
2. Select your version of Linux for the Platform.
3. Download the following MySQL 5.5.x packages making sure to choose (x86, 32-bit) packages for 32-bit systems or if you have a 64-bit system instead choose the (x86, 64-bit) packages:
   • MySQL-client (RPM)
   • MySQL-devel (RPM)
   • MySQL-server (RPM)
   • MySQL-shared (RPM)
   • MySQL-shared-compat (RPM)

MySQL Connector/J JDBC Driver

1. Open a browser window to one of the following, depending on your chosen version of MySQL:
   • MySQL 5.5: http://dev.mysql.com/downloads/connector/j/5.1.html
   • MySQL 5.1: http://dev.mysql.com/downloads/connector/j/5.1.html
   • MySQL 5.0: http://dev.mysql.com/downloads/connector/j/5.0.html
   • MySQL 4.1: http://dev.mysql.com/downloads/connector/j/4.1.html
   • MySQL 4.0: http://dev.mysql.com/downloads/connector/j/4.0.html
2. Download the TAR Archive package.

Apache Tomcat Server

1. Open a browser window to: http://tomcat.apache.org/download-70.cgi
2. Scroll down to the listing for Tomcat 7.0.x.
3. Download the Binary Distribution labeled Core: tar.gz.

Step #2: Installation

Java Development Kit

32-bit

rpm -i jdk-{version}-linux-i586.rpm

64-bit

rpm -i jdk-{version}-linux-x64.rpm

MySQL Database Server

rpm -i MySQL-server-community-{version}.x86_64.rpm
rpm -i MySQL-client-community-{version}.x86_64.rpm
rpm -i MySQL-devel-community-{version}.x86_64.rpm
rpm -i MySQL-shared-community-{version}.x86_64.rpm
rpm -i MySQL-shared-compat-{version}.x86_64.rpm

Apache Tomcat Server

mv apache-tomcat-{version}.tar.gz /usr/local
cd /usr/local
tar -xzvf apache-tomcat-{version}.tar.gz
mv apache-tomcat-{version} tomcat
rm -rf apache-tomcat-{version}.tar.gz
cd tomcat
chmod 755 bin/*.sh
cd webapps
rm -rf *
mkdir ROOT

Apache Tomcat APR Library

yum install apr-devel
yum install gcc
yum install make
yum install zlib-devel
cd /usr/local/tomcat/bin
tar -xzf tomcat-native.tar.gz
cd tomcat-native*
cd jni/native
./configure --with-java-home=/usr/java/latest --with-apr=/usr/bin/apr-1-config --with-ssl=no
make
make install

Java Libraries

unzip javamail-{version}.zip
cp javamail-{version}/mail.jar /usr/local/tomcat/lib/mail.jar
unzip jaf-{version}.zip
cp jaf-{version}/activation.jar /usr/local/tomcat/lib/activation.jar

MySQL Connector/J JDBC Driver

tar -xzvf mysql-connector-java-{version}.tar.gz
cd mysql-connector-java-{version}
cp mysql-connector-java-{version}-bin.jar /usr/local/tomcat/lib/mysql.jar

AdvertPRO

cp advertpro-{version}.war /usr/local/tomcat/webapps/ROOT
cd /usr/local/tomcat/webapps/ROOT
/usr/java/latest/bin/jar -xf advertpro-{version}.war
rm -f advertpro-{version}.war

Step #3: Configuration

Environment Variables

export JAVA_HOME=/usr/java/latest
export PATH=$PATH:$JAVA_HOME/bin

MySQL Settings

Replace the entire contents of the /etc/my.cnf with the following recommended configuration:

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /var/lib/mysql
default-character-set=utf8
skip-external-locking
max_connections = 384
key_buffer_size = 64M
table_open_cache = 256
thread_cache_size = 8
bulk_insert_buffer_size = 16M
join_buffer_size = 1M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
sort_buffer_size = 4M
max_allowed_packet = 16M
max_heap_table_size = 32M
tmp_table_size = 32M
query_alloc_block_size = 16384
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
myisam_sort_buffer_size = 64M
server-id = 1
symbolic-links = 0

[mysql.server]
basedir = /var/lib
user = mysql

[mysqld_safe]
err-log = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid

[mysqldump]
max_allowed_packet = 16M
quick

[mysql]
default-character-set=utf8
no-auto-rehash

[isamchk]
key_buffer = 128M
read_buffer = 2M
write_buffer = 2M
sort_buffer = 128M

[myisamchk]
key_buffer = 128M
read_buffer = 2M
write_buffer = 2M
sort_buffer = 128M

[mysqlhotcopy]
interactive-timeout
        

Apache Tomcat Environment

Edit /usr/local/tomcat/bin/catalina.sh and add the following after the comments/instructions at the top.

# Tomcat Home.
CATALINA_HOME="/usr/local/tomcat"

# Java Home.
JAVA_HOME="/usr/java/latest"

#
# Change -Xms and -Xms if necessary to allocate more or less memory.
# It is important that they have the same value for optimal performance.
# Note that on some operating systems you may need to increase the value of
# -Xss to 512k or higher (do not exceed 1024k) if you experience stability
# problems or start seeing stack overflow exceptions in your application
# server logs.
#
# If you've changed -Xms and -Xms, you should change -XX:NewSize and
# -XX:MaxNewSize to have values equal to half of the -Xms and -Xmx
# values.
#
# Suggested values based on available physical server memory (RAM):
#
#  2 GB RAM    -Xms1024m     -Xmx1024m     -XX:NewSize=512m     -XX:MaxNewSize=512m
#  4 GB RAM    -Xms2048m     -Xmx2048m     -XX:NewSize=1024m    -XX:MaxNewSize=1024m
#  8 GB RAM    -Xms4096m     -Xmx4096m     -XX:NewSize=2048m    -XX:MaxNewSize=2048m
# 16 GB RAM    -Xms8192m     -Xmx8192m     -XX:NewSize=4096m    -XX:MaxNewSize=4096m
# 32 GB RAM    -Xms16384m    -Xmx16384m    -XX:NewSize=8192m    -XX:MaxNewSize=8192m
#
CATALINA_OPTS="$CATALINA_OPTS -server -Xms512m -Xmx512m -Xss256k -XX:+DisableExplicitGC"
CATALINA_OPTS="$CATALINA_OPTS -XX:NewSize=256m -XX:MaxNewSize=256m"

#
# If you're using a multi processor system, uncomment the following
# options and set the value of -XX:ParallelGCThreads equal to the
# number of processors that are in your system.
#
#CATALINA_OPTS="$CATALINA_OPTS -XX:+UseParNewGC -XX:ParallelGCThreads=4"
#CATALINA_OPTS="$CATALINA_OPTS -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=80"
#CATALINA_OPTS="$CATALINA_OPTS -XX:SurvivorRatio=128 -XX:MaxTenuringThreshold=0"

#
# APR Connector JNI Library
#
CATALINA_OPTS="$CATALINA_OPTS -Djava.library.path=/usr/local/apr/lib"

#
# Uncomment the following options to help debug garbage collection
# related performance problems.
#
#CATALINA_OPTS="$CATALINA_OPTS -verbose:gc -Xloggc:/usr/local/tomcat/logs/gc.txt -XX:+PrintGCDetails"

#
# Java Options.
#
JAVA_OPTS="$JAVA_OPTS -Djava.awt.headless=true -Dsun.net.inetaddr.ttl=28800 -Dsun.net.inetaddr.negative.ttl=60"

#
# Raise open file limit and stack size.
#
ulimit -n 524288
ulimit -s 2048

Apache Tomcat Settings

Edit the /usr/local/tomcat/conf/logging.properties file and change the following log handlers from INFO to SEVERE level:

1catalina.org.apache.juli.FileHandler.level = SEVERE
2localhost.org.apache.juli.FileHandler.level = SEVERE
3manager.org.apache.juli.FileHandler.level = SEVERE
4host-manager.org.apache.juli.FileHandler.level = SEVERE
java.util.logging.ConsoleHandler.level = SEVERE

Replace the entire contents of the /usr/local/tomcat/conf/server.xml with the following recommended configuration:

<?xml version="1.0" encoding="utf-8"?>

<Server port="8005" shutdown="SHUTDOWN">

  <Listener className="org.apache.catalina.core.AprLifecycleListener" SSLEngine="off" />
  <Listener className="org.apache.catalina.core.JasperListener" />
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />

  <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 name="Catalina">

    <Connector protocol="org.apache.coyote.http11.Http11AprProtocol"
               acceptCount="128"
               connectionTimeout="10000"
               disableUploadTimeout="false"
               enableLookups="false"
               maxKeepAliveRequests="100"
               keepAliveTimeout="15000"
               maxThreads="512"
               pollTime="2000"
               pollerSize="2048"
               useSendfile="true"
               sendfileSize="1024"
               port="80"
               redirectPort="443"
               URIEncoding="UTF-8"/>

    <Engine defaultHost="localhost" name="Catalina">

      <Host name="localhost" appBase="webapps" unpackWARs="true">

        <Context docBase="ROOT" path="" privileged="false" swallowOutput="true" />

      </Host>

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

    </Engine>

  </Service>

</Server>
        

Apache Tomcat Startup

Create /etc/rc.d/init.d/tomcat using the following recommended settings.

#!/bin/bash
#
# Startup script for the Tomcat Web Server
#
# chkconfig: 345 92 16
# description: Tomcat is a World Wide Web server.  It is used to serve \
#              HTML, JSP, and servlets, and CGI if needed.
# processname: java

CATALINA_HOME=/usr/local/tomcat

case "$1" in
  start)
        rm -rf $CATALINA_HOME/work
        mkdir $CATALINA_HOME/work
        $CATALINA_HOME/bin/startup.sh
        ;;
  restart)
        $CATALINA_HOME/bin/shutdown.sh
        sleep 45
        killall -9 java
        sleep 2
        rm -rf $CATALINA_HOME/work
        mkdir $CATALINA_HOME/work
        $CATALINA_HOME/bin/startup.sh
        ;;
  stop)
        $CATALINA_HOME/bin/shutdown.sh
        sleep 45
        killall -9 java
        sleep 2
        ;;
  *)
        echo $"Usage: tomcat {start|restart|stop}"
        exit 1
esac

exit 0
        

Run Level Configuration

chmod 755 /etc/rc.d/init.d/mysqld
/sbin/chkconfig --add mysqld
/sbin/chkconfig --level 2345 mysqld on
/sbin/chkconfig --list mysqld
chmod 755 /etc/rc.d/init.d/tomcat
/sbin/chkconfig --add tomcat
/sbin/chkconfig --level 345 tomcat on
/sbin/chkconfig --list tomcat

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

/etc/rc.d/init.d/mysql start

Apache Tomcat Server

/etc/rc.d/init.d/tomcat start

Step #5: Finishing Up

MySQL Database

Log in to the MySQL client of your choosing and execute the following SQL queries to create the AdvertPRO database and user to access it.

CREATE DATABASE advertpro;
GRANT ALL PRIVILEGES ON advertpro.* TO advertpro@"localhost" IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON advertpro.* TO advertpro@"localhost.localdomain" IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Keep in mind that the database will be created using the default MySQL character set, which is specified by the character_set_system option in the my.cnf configuration file. For older versions of MySQL the option is named character_set instead. By default MySQL uses the Latin1 character set, so if you wish to use UTF-8 to support non-Latin1 characters create the MySQL database using this command unless you already changed the default MySQL character set to UTF-8:

CREATE DATABASE advertpro CHARACTER SET utf8 COLLATE utf8_general_ci;

When the AdvertPRO setup utility asks you for the JDBC URL you should changed it to specify that you want to use UTF-8 unless again you already changed the default MySQL character set to UTF-8 as the driver will always use the default MySQL character set regardless of the character set of your database:

jdbc:mysql://localhost:3306/advertpro?useUnicode=true&characterEncoding=UTF-8

GeoIP Database

If you have purchased the GeoIP Country or GeoIP City database, you should install that prior to running the AdvertPRO setup utility.

1. GeoIP Country Installation
2. GeoIP City Installation

There are also free versions of GeoIP Country and City that you can download for evaluation purposes, but you should bear in mind that they are not as accurate as the paid versions!

AdvertPRO Setup

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