OpenEMM e-mail & marketing automation Files

IMPORTANT INFORMATION FOR RELEASE 2015
=========================================
Please install Java JDK 8 for OpenEMM 2015 R2 or later, because JDK 7 is no longer
supported for free by Oracle.


IMPORTANT GENERAL INFORMATION
=============================
Before starting an update, make a backup of your database first:
$> mysqldump -aCceQx --hex-blob --routines --triggers -u root -p -r /home/openemm/openemm-db.sql openemm
$> mysqldump -aCceQx --hex-blob --routines --triggers -u root -p -r /home/openemm/openemm_cms-db.sql openemm-cms

If you used the online update of OpenEMM to upgrade to this version, please
read file UPDATE.txt in this directory to finish the update process manually.

If you want to upgrade OpenEMM manually, please read the section below.

If you want to install OpenEMM from scratch we strongly recommend to download
and consult the extensive OpenEMM Install and Administration Guide (PDF format)
to avoid problems.

If you use Windows, an online update is not possible. Please read the Windows
Install Guide for information on how to install and update OpenEMM.


OpenEMM QUICK UPDATE GUIDE for Red Hat and compatible Linux distributions
=========================================================================
1. Download binary tarball to directory /tmp from web address
   http://sourceforge.net/projects/openemm/files/

2. Stop the old OpenEMM and rename the old OpenEMM directory
$> su - openemm
$> openemm.sh stop
$> exit
$> cd /home
$> mv openemm openemm_backup

3. Create the new OpenEMM directory
$> mkdir openemm
$> chown -R openemm:openemm openemm
$> cd openemm

4. Untar OpenEMM tarball as root
$> tar -xvzpf /tmp/OpenEMM-2015_R3-bin.tar.gz
   (please do not forget option "p"!)

5. Copy content for /usr/share/doc
$> mkdir -p /usr/share/doc/OpenEMM-2015_R3
$> mv USR_SHARE/* /usr/share/doc/OpenEMM-2015_R3
$> rm -rf USR_SHARE

6. Replace the generic string "http://localhost:8080" with the domain name of
   your server (like "http://www.domain.com:8080") in these files:
   - /usr/share/doc/OpenEMM-2015/openemm-2015.sql
   - /home/openemm/webapps/openemm/WEB-INF/classes/emm.properties
   - /home/openemm/webapps/openemm/WEB-INF/classes/cms.properties
   - /home/openemm/webapps/openemm-ws/WEB-INF/classes/emm.properties
   - /home/openemm/webapps/openemm-ws/WEB-INF/classes/emm-ws.properties

7. Copy the modifications you made to the "old" files emm.properties and
   cms.properties (found in /home/openemm_backup/webapps/openemm/WEB-INF/classes/)
   to the new files, but leave the value of parameter ckpath unchanged.

8. Start MySQL DBMS and update the OpenEMM DB and CMS DB
   (depending on the version which you update from you have to update the
    databases step by step through executing the corresponding SQL files
    in the right order - please see OpenEMM Install Guide for details)
$> /etc/init.d/mysqld start
$> mysql -u root -p openemm < /usr/share/doc/OpenEMM-2015_R3/update_openemm-...
$> mysql -u root -p openemm < /usr/share/doc/OpenEMM-2015_R3/update_openemm-...
   For the update from 6.2 to 2011 you only have to process file
   update_openemm-6.2-2011_RC1.sql.
   For the update from 2011 to 2013 you only have to process file
   update_openemm-2011-2013.sql.

9. Make sure that an Oracle Java SDK is installed at /opt/openemm/java and
   Apache Tomcat is installed at /opt/openemm/tomcat. See OpenEMM Install
   Guide chapter 3 (Java) and chapter 4 (Tomcat) for details.

10. Launch OpenEMM
$> su - openemm
$> openemm.sh start
$> exit


DOWNGRADING OPENEMM
===================
if you want to downgrade OpenEMM to a version before 2015, you have to re-insert
a dropped column into table admin_tbl with this SQL statement:

ALTER table admin_tbl ADD COLUMN preferred_list_size smallint(5) unsigned NOT NULL default '20';

However, this works only unless you have saved a target group with OpenEMM
2015. Because OpenEMM 2015 uses a different format for serialization, OpenEMM
2013 would no longer be able to read this format. Therefore, you really should
make a backup of your database before updating!

If you want to downgrade OpenEMM to a version before 6.2 you have to synchro-
nize table 'customer_1_tbl_seq' with 'customer_1_tbl' before launching the old
version of OpenEMM, because 'customer_1_tbl_seq' is no longer used beginning
with OpenEMM 6.2. Start MySQL, enter the command to 'update customer_1_tbl_seq'
and leave MySQL:
$> mysql -u root -p openemm
mysql> INSERT INTO `customer_1_tbl_seq` (`customer_id`) SELECT max(`customer_id`) FROM `customer_1_tbl`;
mysql> quit


OPENEMM FILES
=============
MySQL OpenEMM CMS database dump:
/usr/share/doc/OpenEMM-2015/openemm_cms-2015.sql

MySQL OpenEMM CMS demo database dump:
/usr/share/doc/OpenEMM-2015/openemm_demo-cms-2015.sql

OpenEMM Change Log:
/usr/share/doc/OpenEMM-2015/CHANGELOG.txt

OpenEMM License:
/usr/share/doc/OpenEMM-2015/LICENSE.txt

ThirdPartyLicenses:
/usr/share/doc/OpenEMM-2015/ThirdPartyLicenses/

MySQL OpenEMM database dump:
/usr/share/doc/OpenEMM-2015/openemm-2015.sql

MySQL database update (from OpenEMM a.b.c to x.y.z)
/usr/share/doc/OpenEMM-2015/update_openemm-a.b.c-x.y.z.sql
(File update_openemm-2013_RC2-2013.sql is only needed by users who installed
 a release candidate of OpenEMM 2013.)

System info for OpenEMM online update feature:
/usr/share/doc/OpenEMM-2015/empty-updates.txt

Script which is executed by OpenEMM's online update
after the upgrade to the current version:
/usr/share/doc/OpenEMM-2015/upgrade-postproc.sh

MySQL Database Conversion Script to convert the whole database
to UTF-8 character set (if you want to use OpenEMM beyond the
5.4.0 release, you must once convert your database):
/home/openemm/bin/openemm-charset-convert.sh


MISCELLANEOUS
=============
Website:    http://www.openemm.org
Twitter:    http://www.twitter.com/openemm
Support:    http://www.openemm.org/support.html
Facebook:   http://www.facebook.com/openemm
Newsletter: http://www.openemm.org/newsletter.html
Maintainer: Martin Aschoff (maschoff AT os-inside DOT org)

OpenEMM uses the Open Source Initiative Approved License "Common Public
Attribution License 1.0 (CPAL)". Open Source Initiative Approved is a
trademark of the Open Source Initiative.

Copyright (c) 2006-2016 AGNITAS AG, Munich, Germany