Fairmont Raffles Hotels International Inc. (FRHI)

salmonbrisketSoftware and s/w Development

Nov 2, 2013 (4 years and 2 months ago)

107 views

Fairmont Raffles Hotels International Inc. (FRHI)




Fairmont.com Deployment Guide





Third Parties:

You may
NOT

distribute this document, or any part thereof, to individuals not
directly involved in the project, and without th
e prior knowledge and
approvals of the Fairmont Raffles Hotels International Inc. Technology
Management Team. This material is considered CONFIDENTIAL TO FAIRMONT
RAFFLES HOTELS INTERNATIONAL INC., as described and protected under the
relevant Non
-
Disclosu
re Agreement.





















© 2007 Fairmont Raffles Hotels International Inc. All rights reserved.


The information contained in this document represents the current view of Fairmont Raffles Hotels International Inc.
(Company) on the issues discussed

as of the date of publication. Because the Company must respond to changing
market conditions, it should not be interpreted to be a commitment on the part of the Company, and the Company
cannot guarantee the accuracy of any information presented after the

date of publication.


This document is for informational purposes only.
THE COMPANY MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN
THIS DOCUMENT.



Confidential

2



Version & Revision Information


Document Properties

Item

Details

Document Title

Fairmont.Com Deployment Guide

Author

FRHI Technology Services

Creation Date

September

0
5
, 2007

Last Updated

September 06
, 2007

File Name

Fairmont_Com_Deployment_Guide_
V1.0

Version

V1.0




Change Record

Date

Author

Version

Change Reference

September 0
6
, 2007

Gireesh Kumar

1.0

In
itial Document
















Reviewers

Name

Version
Approved

Position

Date Approved

David Zhang

1.0

Con
sultant
,

Technology Services,

Fairmont Raffles Hotels
International Inc.

September 06, 2007

Balaji Subramanian


1.0

Supervisor
,

Applications
Opera
tions
, Fairmont Raffles Hotels
International Inc.

September 06, 2007

Marjorie Wrightson






Manager, eCommerce Systems
,

Fairmont Raffles Hotels
International Inc.




Michael Rodger






Director Application Development,
Fairmont Raffles Hotels
Internati
onal Inc.











Confidential

3



Table of Contents


1 Executive Summary

________________________________
_________________

4

2 Technologies Overview

________________________________
______________

4

3 Fairmont.com installation Procedures

________________________________

5

3.1 Database Servers
________________________________
__________________

5

3.2 MCMS Server 2002

________________________________
________________

6

3.3 Fairmont.com CMS Application setup

________________________________
_

6

3.4 SPS Content Indexes and Content Sources Setup

_______________________

7

3.5 Interfaces to OCRS & WBE through Web Services

_______________________

8

3.6 Fairmont.com Friendly URL setup

________________________________
___

9

Appendix A

________________________________
__________________________

10


















Confidential

4



1 Executive Summary


The Fairmont.com web site was developed using Microsoft .Net 2.0 framework
with Microsoft Content Management Server 2002 SP2 (MCMS 2002) for content
management and Microsoft SQL Server 2005 (MS SQL 2005)
as it’s back
-
end
database.


This web site communicates with 2 external Oracle systems (Opera Central
Reservation System


OCRS and Web Booking Engine


WBE) through web
services.

SharePoint Portal Server 2003 (SPS) w
as used to

provide the search
engine for

Faimont.com.


2 Technologies
Overview


The following table provides a general overview of the
system environment:



Development Framework
and IDE

Microsoft .Net Framework 2.0 and Visual Studio 2005

Security

Pages
are

capable of being rendered via HTTP/H
TTPS

Cache

.NET page caching

Load Balance/Redundancy


Refer to Appendix A for a schematic illustrating the solution.

Language
, Scripts and
Markups

ASP.Net
,

C#

.NET, JavaScript, HTML/DHTML, XML



Content Management

Clustered Microsoft CMS 2002 (Service

Pack 2)

Database


Clustered MS SQL Server 2005


64 bit edition (Service Pack 1)

Operating System/ Web
Server

Clustered Windows 2003, IIS 6


State Management


State
management is accomplished

via Microsoft CMS 2002 database
session management

CMS use
r authentication

Active Directory
is

used for authentication, permissions and roles








Confidential

5



The following figure depicts the architectural view of the Fairmont.com system
environment.






3 Fairmont.com
installation
Procedures

3.
1

Database Servers


Fairm
ont.com was built on the following database servers:


MS SQL Server 2005
DB Name

Description

MCMS

MCMS Database

FairmontWeb

Fairmont.com custom database

ASPState

Fairmont.com session state database

(SPSConfig)

Sharepoint config database

(SPSContent)

S
harepoint content database

Confidential

6



The following is the i
nstallation Procedures for the above listed

Fairmont.com

databases
:



1.

MCMS:

a.

This
database

will be
created automatically when MCMS

2002

is
installed.

b.

Unzip

Fairmont_
MCMS.Zip file.

c.

Import the following data
output files
C
hannel.
sdo and
R
esource
s
.sdo into this database through CMS site manager.


2.

FairmontWeb:

a.

U
nzip Fairmont_
FairmontWeb
.Zip file
.

b.

Run the FairmontWeb_Script.sql
s
cript file t
o create the
FairmontWeb database

and the related objects
.

c.

Import the

data from the dat
a

files attached.


3.

ASPS
t
ate:

Create this database for Fairmont.com session state
management.


4.

SPSConfig & SPSContent:

These databases

will be created automatically
when SPS is installed.


Note: The SPSConfig & SPSContent database name ca
n be different in
different
environment
s

based on the
ir

SPS installation preferences.




3.2 MCMS Server 2002


1.

Install MCMS Server 2002 Service Pack 2


2.

Run all the hot patches available for this product.


Note: The hot patch installation is vital for MCM
S 2002 SP 2 to work well with
Visual Studio 2005.


3.3 Fairmont.com CMS Application setup


1.

Create deployment folder and copy all files in

Fairmont_DotNet_Solution.Zip package
to it.

2.

Create a virtual folder for Fairmont.Web.CMSApplication in internet
infor
mation server (IIS)

3.

Add the following

machine key

that used by
Encryption/Decryption
algorithm

to you machine.config
Confidential

7



(C:
\
WINDOWS
\
Microsoft.NET
\
Framework
\
v2.0.50727
\
CONFIG) at the end
just before </system.web>


<machineKey
validationKey="D1FA66E8FEF9E7200
125FE1F598DB09D01AC8AB22D5ACB4455B8C
DB16C74F30E"
decryptionKey="9ACAD20D1F46EB87F87F2EF46023697D3094906F1D460C88"
validation="SHA1" decryption="AES"/>


4.

Ensure the validationKey and decryptionKey attributes are set as in the
example above.


5.

Ensure the brows
ercap.ini file from the deployment package exists in
the following location: C:
\
WINDOWS
\
system32
\
inetsrv
\



3.4 SPS Content Indexes and Content Sources Setup


1.

Open the Sharepoint portal site <site name> and login as Sharepoint
Admin.


2.

Click ‘Site Settings”
.


3.

Click “Configure Search and Index”.


4.

Enable Advanced Search Administration Mode if necessary.


5.

Create 8 search Indexes using following settings.


Index Name

Source Group

Description

Index file location

EN_FA

EN_FA

EN_FA Content Index

(Default)

EN_FA_H
otels

EN_FA_Hotels

EN_FA Hotels Content
Index

(Default)

EN_FA_News

EN_FA_News

EN_FA News Content Index

(Default)

EN_FA_Packages

EN_FA_Packages

EN_FA Packages Content
Index

(Default)

FR_FA

FR_FA

FR_FA Content Index

(Default)

FR_FA_Hotels

FR_FA_Hotels

FR
_FA Hotels Content
Index

(Default)

FR_FA_News

FR_FA_News

FR_FA News Content Index

(Default)

FR_FA_Packages

FR_FA_Packages

FR_FA Packages Content
Index

(Default)







Confidential

8



6.

Create 8 content sources by following settings


Description

Content
Index

Url

Source
G
roup

Page
Dept

Site
hops

EN_FA
Content

EN_FA

http://<pub site name>

EN_FA

this site

This
site

EN_FA
Hotels
Content

EN_FA_Ho
tels

http://<pub site
name>/Fairmont.Web.CMSAp
plication/aspx/propertyindex
.aspx?brand=EN_FA

EN_FA_Hotel
s

1

0

EN_FA
News
Content

EN
_FA_Ne
ws

http://<pub site
name>/Fairmont.Web.CMSAp
plication/aspx/newsindex.as
px?brand=EN_FA

EN_FA_News

1

0

EN_FA
Packages
Content

EN_FA_Pa
ckages

http://<pub site
name>/Fairmont.Web.CMSAp
plication/aspx/packageindex
.aspx?brand=EN_FA

EN_FA_Packa
ges

1

0

FR_F
A
Content

FR_FA

http://<pub site name>

FR_FA

this site

This
site

FR_FA
Hotels
Content

FR_FA_Ho
tels

http://<pub site
name>/Fairmont.Web.CMSAp
plication/aspx/propertyindex
.aspx?brand=FR_FA

FR_FA_Hotels

1

0

FR_FA
News
Content

FR_FA_Ne
ws

http://<pub site
name
>/Fairmont.Web.CMSAp
plication/aspx/newsindex.as
px?brand=FR_FA

FR_FA_News

1

0

FR_FA
Packages
Content

FR_FA_Pa
ckages

http://<pub site
name>/Fairmont.Web.CMSAp
plication/aspx/packageindex
.aspx?brand=FR_FA

FR_FA_Packa
ges

1

0


3.5
Interfaces

to OCRS & WBE thro
ugh Web Services


1.

The following web services can be used to talk to OCRS and WBE
systems.


a.

<add key="AvailabilityWS"
value="http://webservices.uat.fairmont.com/OWS_WS/5.1/Availability.asmx"
/>


b.

<add key="ReservationWS"
value="http://webservices.uat.fairmo
nt.com/OWS_WS/5.1/Reservation.asmx"
/>


c.

<add key="ReservationExtWS"
value="http://webservices.uat.fairmont.com/CRWSS/1.0/Reservation/Reservat
ion.asmx" />

Confidential

9




d.

<add key="MatchExtWS"
value="http://webservices.uat.fairmont.com/CRWSS/1.0/MFCR_DX.asmx" />


e.

<add key
="MembershipWS"
value="http://webservices.uat.fairmont.com/OWS_WS/5.1/Membership.asmx"
/>


f.

<add key="InformationWS"
value="http://webservices.uat.fairmont.com/OWS_WS/5.1/Information.asmx"
/>


g.

<add key="FPCProfileWS"
value="http://webservices.uat.fairmont.c
om/FPCWSS/1.1/FPCProfileHandler.a
smx" />


2.

The above web services are hosted on Fairmont
UAT
servers.



3.

To gain access to these web services please provide the
range of IP
address from your network that will require access

to

this system.


3.6 Fairmont.co
m Friendly URL setup


1.

Unzip Fairmont_URL.zip.


2.

Copy the FriendlyURL.dll to IIS server

and add this dll to the virtual
directory’s "ISAPI Filters" tab.


3.

Run the FriendlyURL_Dev.reg file to register the above dll.


4.

Modify the registry settings with the appr
opriate connection string
parameters.

















Confidential

10



Appendix A