forked from ronoaldo/openemm
-
Notifications
You must be signed in to change notification settings - Fork 0
/
README.txt
159 lines (122 loc) · 6.09 KB
/
README.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
IMPORTANT INFORMATION FOR RELEASE 2015
=========================================
Please install Java JDK 8 for OpenEMM 2015 R2, because JDK 7 is no longer
supported for free by Oracle.
IMPORTANT GENERAL INFORMATION
=============================
Before any 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_R2-bin.tar.gz
(please do not forget option "p"!)
5. Copy content for /usr/share/doc
$> mkdir -p /usr/share/doc/OpenEMM-2015_R2
$> mv USR_SHARE/* /usr/share/doc/OpenEMM-2015_R2
$> 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_R2/update_openemm-...
$> mysql -u root -p openemm < /usr/share/doc/OpenEMM-2015_R2/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-2015 AGNITAS AG, Munich, Germany