Dannon Sales Portal
–
Deployment Plan
Page
1
of
11
The Dannon Company
Dannon Sales Portal
Deployment Plan
Version 1.6
June 19, 2009
Prepared by
Fulcrum Logic Inc.,
636 Morris Turnpike
Short Hills, NJ
-
07078
Dannon Sales Portal
–
Deployment Plan
Page
2
of
11
Contents
1. INTRODUCTIO
N
................................
................................
................................
................................
....
3
1.1.
P
URPOSE OF THE
D
OCUMENT
................................
................................
................................
................
3
1.2.
S
COPE OF THE
D
OCUMENT
................................
................................
................................
....................
3
2. PRE
-
REQUISITES
................................
................................
................................
................................
..
3
3. DEPLOYMENT PLAN
................................
................................
................................
............................
3
4. SCHEDULE
................................
................................
................................
................................
..............
9
5. NOTES
................................
................................
................................
................................
.....................
10
Dannon Sales Portal
–
Deployment Plan
Page
3
of
11
1.
Introduction
1.1.
Purpose of the Document
The purpose of this document is to describe the plan for deployment of Dannon Sales Portal
application on production environment.
1.2.
Scope of the Document
Only deployment plan for Sales
Portal application is covered in this document. Installation plan for
production set up is provided in a separate document.
2.
Pre
-
requisites
The following pre
-
requisites are assumed to have been satisfied for the deployment to start:
Java 5
or later.
Liferay 5.2 on LINUX
Web Browser
A web browser such as Mozilla Firefox 2/3 or Internet Explorer 6/7
Tomcat 6 and Apache 2 for virtual hosting
MySQL5
MYSQL5 database should be setup runn
ing on 3306 port.
3.
Deployment Plan
The main steps involved in the production setup are segregated into five categories:
1.
Database Setup
Download rar files from
ftp.dannon.com
-
/DSP/Deployment/Database folder
Create S
ales Portal specific tables and import data to Sales Portal tables on
dspportal
schema.
o
Execute following .sql file in
dspportal
schema to create sales portal specific
tables. Make sure the liferay is started and run at least once before executing
this sc
ript. (
Note
: The create script considers the default tables of liferay are
existing under
lportal
schema)
“dsp
-
create
-
mysql.sql”
o
Execute the following .sql file in
lportal
schema to delete the old tables that
were created earlier. Skip this step, if you h
ave created the lportal schema and
ran only the “liferay52
-
default
-
tables
-
mysql.sql”.
“delete
-
old
-
tables.sql”
Dannon Sales Portal
–
Deployment Plan
Page
4
of
11
o
Execute following .sql file in
dspportal
schema to insert data into sales portal
specific tables
“migration
-
insert
-
data.sql”
O
Execute following
.sql file in dspportal schema to insert the folders and files
entries into the tables. This sql script will also change the system user to the
default user of already uploaded jackrabbit documents.
“update
-
data
-
migration
-
tables.sql”.
2.
Application Deployment (Linux Environment)
Document Setup
o
Download jackrabbit folder files from DSP/Deployment/Documents folder.
o
Run liferay.sfx.part01.exe, which will unzip .rar files into a single .exe
F
ile
named as liferay.exe.
It will prompt th
e user for a location where the files
needs to be extracted, select the desired output folder (ex: E:
\
DSP)
o
Once the process is completed a file named “liferay.exe” will be created under
the output folder specified previously.
o
Download 7
-
zip tool from
http://www.7
-
zip.org/download.html
7
-
zip is used to compress the files since it provided a better compression ratio
o
Install 7
-
zip
o
After installation is complete, run 7
-
zip File Manager
o
Navigate to liferay.ex
e and click 'Extract'
o
Select the folder where you would need files to be extracted
o
It will extract the files as needed. These files can be copied to desired location
on production
o
Copy the (jackrabbit) folder where documents are downloaded and paste it a
t
desired user home or any other location on Linux
o
Download portal
-
ext.properties from DSP/Deployment/War folder
o
Copy all the lines from the portal
-
ext to TOMCAT_HOME
\
webapps
\
ROOT
\
WEB
-
INF
\
classes
\
portal
-
ext.properties (Create portal
-
ext.properties if it d
oesn’t
exist). This file specifies the database location, file size limit and type for
uploading document and type of announcement type like shelf obsession,
Stonyfield type.
o
Open the file portal
-
ext. If the jackrabbit folder location needs to be set at
di
fferent location than set the property “jcr.jackrabbit.repository.root” to point
to the “liferay/jackrabbit” location or the location where documents are
copied.
o
Add the following line to the same file to change the file storage mechanism
“
dl.hook.impl=co
m.liferay.documentlibrary.util.JCRHook
”, this should be done
because the jackrabbit folder that we have currently was created using Liferay
5.1, In Liferay 5.2 the file storage type was modified. To make the current
liferay to use the File storage type as
that of 5.1 version, we need to add this
entry.
Dannon Sales Portal
–
Deployment Plan
Page
5
of
11
o
Add all the properties for MySQL in the list below,
jdbc.default.driverClassName=
jdbc.default.url=
jdbc.default.username=
jdbc.default.password=
Setup Context
o
In portal
-
ext.propeties present under WEB
-
INF/c
lasses of Liferay application
(considering the Liferay folder name is portal) add a new entry i.e.
portal.ctx=/portal
o
In web.xml present under WEB
-
INF of Liferay application add a new context
param named root_path and value /portal (i.e.)
<context
-
param
>
<param
-
name>root_path</param
-
name>
<param
-
value>/portal</param
-
value>
</context
-
param>
o
Create a new file named "portal.xml" under TOMCAT_HOME/conf/localhost
with the following content
<Context path="/portal" crossContext="true">
<!
--
JAAS
--
>
<Realm
className="org.apache.catalina.realm.JAASRealm"
appName="PortalRealm"
userClassNames="com.liferay.portal.kernel.security.jaas.PortalPrincipal"
roleClassNames="com.liferay.portal.kernel.security.jaas.P
ortalRole"
/>
</Context>
Deploy plug
-
ins
o
Download war files from DSP/Deployment/War folder
o
Delete the old plugins folders named dannon
-
custom
-
portlets, flash
-
portlet,
liferay
-
jefdi
-
theme under webapps folder. Skip this step, if plugins were never
de
ployed.
o
Copy plug
-
in war file to deploy folder of Liferay tomcat bundle.
Dannon Sales Portal
–
Deployment Plan
Page
6
of
11
dsp
-
flash
-
portlet.war for applying the spotlight.
dsp
-
0609
-
theme.war for applying the custom themes.
dsp
-
portlets.war, which consists of all the custom portlets like dsp
-
announcements
, dsp
-
calendar, dsp
-
journal contents, dsp
-
document
-
library.
o
Go to the TOMCAT_HOME/bin and click on startup.sh by executing cmd >> sh
startup.sh
o
Once all the portlets are deployed, the dsp
-
portlets needs to be customized for
the database configuration, Proc
eed to TOMCAT_HOME/webapps/Dannon
-
custom
-
porlets/WEB
-
INF/classes/portlet
-
config.properties and change the
default values to point to Sales Portal schema or change the file directly in the
war file by opening the dsp
-
portlet.war using zip tools and edit the
file /WEB
-
INF/classes/portlet
-
config.properties.
driverClassName=
url=
username=
password=
Once the database configurations are completed the tomcat server needs to be
restarted to so that the portlets are configured with the provided database
configurati
ons.
Organization Setup:
o
Download lar files from DSP/Deployment/Lar. These lar files contain retailsales
and AFH pages.
o
Login as admin
o
Navigate to the Control Panel from the User dock menu and click on
organizations.
o
Click the “add” button on Organization
portlet, enter the organization name as
“Dannon Retail Sales” and click on save button.
o
Repeat steps 3 and 4 for creating AFH organization with only change of name
as “Dannon Away From Home”
o
Click on the View all tab of the organization portlet
o
Click the
“Actions” button aligned with the Dannon Retail Sales organization in
the search list
o
Click on “Manage pages”
o
Click the Export/Import >> Import tab
o
Browse the .lar file and click on Import button.
Leave other settings as default.
o
Repeat steps 6 to 10 for
Dannon Away From Home.
Dannon Sales Portal
–
Deployment Plan
Page
7
of
11
o
Execute this step only after the organizations are created. Retrieve organization
id from database for Dannon Retail Sales and Dannon Away From Home.
o
Fill the template data of “#retailsalesorgid#” and “#afhorgid#” with the
correspond
ing organization ids in.
“update
-
data
-
migration
-
tables for Organization.sql”.
o
Execute “update
-
data
-
migration
-
tables for Organization.sql”.
Organization id can be obtained from Control Panel
-
Organization
–
Actions
-
Edit
-
Group Id
Setup Organization P
ages
o
Click on the View all tab of the organization portlet
o
Click the “Actions” button aligned with the Dannon Retail Sales organization in
the search list
o
Click on “Manage pages”
o
Click on Look and Feel menu. Select dsp
-
0609
-
theme to apply the custom
theme
changes.
o
Go to Retails sales page and perform the following step for performance
scorecard section.
Click on the configuration button
Click Add Web Content button
Enter the Name as: ‘Performance Scorecards’ (case sensitive)
Click on ‘save ‘and ‘approve’ b
utton
Note: The Performance Score Card section needs to be configured since
the article may get expired while we were importing it as a lar file. The
contents are dynamically retrieved from the document library, so we don’t
need any structure or template h
ere.
o
Download brand logos from DSP/Deployment/War/Brand_Product_System.zip
and unzip the file to extract images of brands.
o
Click on Admin tab and navigate to Image Gallery. If Brand_Product_System
folder is not existing then create the folder named as Bra
nd_Product_System.
Add the images inside these folders like
Activia, danactive, lightnfit,
dannon, danimals
and
stonyfield.
o
If an error occurs on archive portlet on brand secondary page follow the
following steps:
Click on the configuration button
Click Ad
d Web Content button
Enter the Name as: BRAND_PRODUCTS_Archives_Activia (case
sensitive)
Click on ‘save’ and ‘approve’ button
Dannon Sales Portal
–
Deployment Plan
Page
8
of
11
Search for BRAND_PRODUCTS_Archives_Activia
Click the link (BRAND_PRODUCTS_Archives_Activia), which appears
after the search.
Simi
larly, configure other 6 brands Archive section
Note: The archive section needs to be reconfigured because the contents
are dynamically fetched from different folders based on the different
brands.
o
For the Corporate Announcement, Click on configuration an
d change the path
to
,
Click on the configure button
Enter the title for the RSS feed to replace the title in the feed if
necessary
Enter the URL for the rss feed in the URL field.
http://rs
s.dannonculture.uswpl.danet/announcements
Repeat steps 1
-
3 for
http://rss.dannonculture.uswpl.danet/newsandpr
Select the option for
Show Feed Title and Show Feed Published Date
Select the no o
f entries to be shown per rss.
Click the save button
o
In AFH Announcements section, click on Configuration of the portlet from the
AFH Home page. Select the view as “Public Private” so that the AFH
announcement’s view is now reflected to the “Public Private
” view.
3.
User Setup
Create User Groups
–
Dannon Retail Sales Admin, Dannon Retail Sales Employee,
Dannon Away From Home Admin, Dannon Away From Home Employee, Stonyfield
Employee, Dannon Employee
Associate users with user groups
4.
Add Stonyfield User: This s
tep is to create users in Liferay.
Login as admin and navigate to Admin Tab
Click on Organization tab under Enterprise Admin Portlet
Click the “Actions” button aligned with the Stonyfield organization in the search list
Click on Add User, fill the details
and click on save button, click on the password link on
the right side of the portlet, fill the details and click on save button.
Go to ‘UserGroups’ tab and associate the user to the corresponding UserGroup by
clicking Action
Assign Members for the corres
ponding UserGroup
Dannon Sales Portal
–
Deployment Plan
Page
9
of
11
5.
Roles and Permissions
Create Organization Roles
-
Dannon Retail Sales Admin, Dannon Retail Sales Employee,
Dannon Away From Home Admin, Dannon Away From Home Employee, Stonyfield
Employee, Dannon Employee
Set Permissions on Roles by clic
king on Actions
Define Permissions
Add Portlet
Permissions, Click on the required Portlet to set the permission, Select the
corresponding permission for individual portlets and submit the changes. Details on this
is provided in a separate document ‘DSP D
efine Role Permissions.xls’
Associate users to organizational roles from Organization Admin portlet and clicking
Actions
Assign User Roles on corresponding Organization
6.
Setting Permissions on a Page
Navigate to user dock menu present next to the welcome m
essage
Select Manage pages
Select the desired page to set the permissions and click on Permissions button
Select the roles for which the page should be visible and click on Submit button
Refer to Pages column of ‘DSP Define Role Permissions.xls’ for detail
ed setup of
permissions on pages
7.
Flash Configuration
Click on configuration link of the Flash Portlet
Click on browse button to select flash file from the document library,
Click on save to apply the changes.
8.
Virtual Hosting Configuration
Refer to Apache
Virtual Hosting.doc for detailed setup
4.
Schedule
Anticipated schedule is depicted below:
Deployment
Start
Finish
Resource
Database Setup
Import data of Liferay default
tables
Fri 6/5/09
Fri 6/5/09
David
Execute script to create sales
portal specif
ic tables and
import data
Fri 6/5/09
Fri 6/5/09
David
Application Deployment
Application Deployment on
Mon 6/8/09
Mon 6/8/09
David
Dannon Sales Portal
–
Deployment Plan
Page
10
of
11
testing environment
Configure application
-
Build
Pages, Import portlets
Tue 6/9/09
Tue 6/17/09
David
Application Depl
oyment &
Configuration on production
environment.
Wed 6/22/09
Wed 6/23/09
David
Configure application
-
Build
Pages, Import portlets
Wed 6/22/09
Wed 6/23/09
David
User Setup
User Set up (Dannon, Retail,
Stonyfield, AFH, External)
-
create user groups
and assign
members
Mon 6/18/09
Wed 6/22/09
David
Permissions
Create Roles
Wed 6/22/09
Wed 6/23/09
David
Set Permissions on Roles
Wed 6/22/09
Wed 6/23/09
David
Associate Roles and User
Groups
Wed 6/22/09
Wed 6/23/09
David
5.
Notes
Migration of documen
ts should be resumed on prod environment.
Content like links, spotlight, documents, images on pages in Sales Portal may need to be
configured
Development is done on windows
Using rar files on Linux
o
Download binary package from official rarlab site:
$ cd /
tmp
$ wget http://www.rarlab.com/rar/rarlinux
-
3.6.0.tar.gz
o
Untar file
$ tar
-
zxvf rarlinux
-
3.6.0.tar.gz
o
Both unrar and rar commands are located in rar sub
-
directory. Just go to rar
directory:
$ cd rar
$ ./unrar
o
Now copy rar and unrar to /bin directory:
# c
p rar unrar /bin
o
Task: To open rar (unpack) file in current directory type command:
$ unrar e file.rar
Please note that replace file.rar filename with your actual filename.
Dannon Sales Portal
–
Deployment Plan
Page
11
of
11
o
Task: List (l) file inside rar archive:
$ unrar l file.rar
o
Task: To extract (x) fil
es with full path type command:
$ unrar x file.rar
Enter the password to open this PDF file:
File name:
-
File size:
-
Title:
-
Author:
-
Subject:
-
Keywords:
-
Creation Date:
-
Modification Date:
-
Creator:
-
PDF Producer:
-
PDF Version:
-
Page Count:
-
Preparing document for printing…
0%
Commentaires 0
Connectez-vous pour poster un commentaire