Editing OpenEMM 2013 installation

This document will guide you through some necessary steps, which are needed to  update OpenEMM to latest version

#cd /home
#mv openemm openemm.bk
#mysqldump -uroot -proot123 openemm > backup.sql
#drop database openemm

OpenEMM's web container Tomcat requires the installation of SEJDK 7 not the GNU version of Java! If Sun's Java SE SDK 7 is not included in your distribution and has not been installed yet,
you have to install it by yourself.

1. Install java

Open this link in browser (java.oracle.com) and visit the download section, subsection Java
SE (Standard Edition). Download the tarball (*.tar.gz) of the latest Java SE JDK 7 (Java Development Kit).

#mkdir /opt/openemm
#cp jdk-7u25-linux-i586.tar.gz /opt/openemm
#cd /opt/openemm
#tar -xvzf jdk-7u25-linux-i586.tar.gz
#mkdir -p java
#cd jdk1.7.0_25
#mv * /opt/openemm/java

Then run this command to check java is working or not...

#/opt/openemm/java/bin/java -version

You should get output similar to the following:

java version "1.7.0_25"
Java(TM) SE Runtime Environment (build 1.7.0_25-b15)
Java HotSpot(TM) Server VM (build 23.25-b01, mixed mode)

2. Install tomcat

Download the latest binary distribution of release 6 from http://tomcat.apache.org. The core package is sufficient. The examples here use Tomcat 6.0.32 – you should adapt them to the latest version of Tomcat 6 as needed

#mkdir /opt/openemm/tomcat
#cp apache-tomcat-6.0.32.tar.gz /opt/openemm
#cd /opt/openemm
#tar -zxvf apache-tomcat-6.0.32.tar.gz
#cd apache-tomcat*****
#mv * /opt/openemm/tomcat

3.Installation of OpenEMM 2013

Get the latest version of the OpenEMM binary code from

http://sourceforge.net/projects/openemm/files/latest/download

#cd /home
#mv openemm openemm-2013
#ln -s openemm-2013 openemm

Change to OpenEMM's directory and unpack the OpenEMM tar.gz. Do not forget option "p" for the tar command, because
some files need to have owner and group set to root or special permissions which are preset in the tar.gz

#cd /home/openemm
#tar xzvpf /tmp/OpenEMM-2013-bin.tar.gz
#mkdir -p /usr/share/doc/OpenEMM-2013
#mv USR_SHARE/* /usr/share/doc/OpenEMM-2013
#rm -r USR_SHARE
#chown -R openemm:openemm /home/openemm

4. Read Access to Maillog

OpenEMM requires read access to the log file /var/log/maillog.open file /etc/logrotate.d/syslog and add the following line after the line sharedscripts

#vim /etc/logrotate.d/syslog
create 0604
#chmod 604 /var/log/maillog
#ln -s /var/log/mail.log /var/log/maillog

5.Initialize/Update the OpenEMM and the OpenEMM CMS Database

#/etc/init.d/mysqld restart
#cd /usr/share/doc/OpenEMM-2013
#mysqladmin -u root -proot123 create openemm_cms
#mysql -u root -p openemm_cms < openemm_cms-2013.sql
#mysqladmin -u root -proot123 create openemm

If you plan to use the redirection service of OpenEMM, open file openemm-2013.sql with a text editor like edit or vim & find and replace the string
#vim openemm-2013.sql 
http://news1.tetra-campaign.in:8080
:wq
#mysql -u root -p openemm < openemm-2013.sql

6.Start and Stop OpenEMM

#cd /home/openemm
#vim .bash_profile
PATH=$PATH:$HOME/bin:/opt/openemm/java/bin
JAVA_HOME=/opt/openemm/java
:wq
#su - openemm
#openemm.sh start ( To start the service)
#openemm.sh stop  ( To stop the service)

7.Test

Open this weburl  news1.tetra-campaign.in in browser. And login with below credentials

Username: admin
Password: openemm