ItmSUITE® - CMS installation

Install CMS server

CMS logo

CMS server collects all the web services to support CMS fat client, RE and PM/SM integration.

Moreover this module will provide the component CMS web client.

DB: creation and initialization

System requirements

Hardware

- CPU Dual Core x64, 2,6 Ghz or more
- 2 GB ram (4GB recommended)
- 1 GB of free disk space

Software

- OS: Windows 2008 R2 Server (recommended), Windows 2003 Server
- MSSQL 2008 R2 (recommended), MSSQL server 2005 std

Installation procedure

This operation requires DB Owner grants on CMS DB

Follow the following steps:

1. Create a new DB instance on DB server engine

2. Execute the following steps (the script are contained in folder 2.Script):

2.1 Create.sql

2.2 Init.sql

After installation script ran, in the table AVER will be present the version of just created CMS DB.

Web server installation

System requirements

Hardware

- CPU Dual Core x64, 2,6 Ghz or more
- 2 GB ram (4GB recommended)
- 1 GB of free disk space

Software

- OS: Windows 2008 R2 Server (recommended), Windows 2003 Server
- IIS 7.0 (recommended) , IIS 6.0
- Framework .NET 4.0

Installation wizard

Installation of CMS server requires Admin privileges on Web server.

Create a folder to install CMS server on Web server.

CMS Server installation folder

Run IIS (Internet Information Services) from Web server administration tools.

[picture]

Create a new Web site in IIS.

[picture]

Set the Site name, the Physical path (this shall be the folder created above) and the Port.

[picture]

At click on Ok the new Web site CMS server will be created.

The Port in above picture (32000) is just an example.

It is essential that the selected Port is not currently used by any other applications.

Unzip the CMS server package. The following folders shall be present:

1.Installer: contains the installation package

2.Script: contains the script to create and initialize the database

3.Doc: contains custom steps related to current version (if there are any)

[picture]

To start the installation process, navigate to the folder 1.Installer and double-click on the file setup.exe (as shown in picture below).

[picture]

If OS on Web server is a windows 2008 server: is required to right click on setup.exe and select "Run as administrator" option.

[picture]

A wizard process will help during the installation of CMS server.

[picture]

Click on Next > button

Select the installation folder created above and the Application pool ASP.NET v4.0 Classic.

[picture]

Click on Next > for 2 times and wait for installation completion.

[picture]

Move into installation folder and localize [Installation Folder] \ CMS \ Web.Config

[picture]

Search the section limited by tag <settings>

[picture]

Insert the IP address or the name of DB server for the attribute with key "db.server".

Insert the user with grant on DB itmSUITE CMS for the attribute with key "db.user".

Insert the password for the attribute key "db.password".

Insert the DB name for the attribute key "db.schema".

The default connection to MS SQL Server is on port 1433: if current DB Engine installation is answering to default port, it is not required to be declared.

If DB Engine installation is not configured on default port: it is required to declare it.

Example: <add key = "db.server" value = "db.server, 1435" />

On IIS 7: select the option Directory Browsing and configure the settings as in following picture. [picture]

And then click on Apply

Upgrade CMS server

DB: upgrade

This operation requires DB Owner grants on CMS DB

Follow the following steps:

1. Execute a backup of CMS DB

2. Execute the update_[versione].sql present in folder 2.Script

After upgrade script ran, in the table AVER will be present the version of just migrated CMS DB.