wamp bundle installation guide for ccsuitewamp+bundle...installation & configuration install the...

WAMP Bundle installation guide for CCSuite 2016-08-19

Table of Contents The CCSuite WAMP bundle ........................................................................................................................... 3

Software needed: .......................................................................................................................................... 3

Installation & Configuration .......................................................................................................................... 4

Install the CCSuite bundle.......................................................................................................................... 4

Environment variables ............................................................................................................................... 6

Configuration files ..................................................................................................................................... 8

Configuration file for Apache .................................................................................................................... 8

Configuration file for FCGID....................................................................................................................... 8

Configuration file for PHP .......................................................................................................................... 8

Configuration file for APM ......................................................................................................................... 8

Configuration file for FCGID....................................................................................................................... 9

Visual C++ Redistributable for Visual Studio 2012 installation ............................................................... 10

CCSuite license file ................................................................................................................................... 11

Install Apache service .............................................................................................................................. 11

Uninstall Apache service .......................................................................................................................... 12

Install MySQL service ............................................................................................................................... 12

Uninstall MySQL service .......................................................................................................................... 13

Create the MySQL database .................................................................................................................... 14

Restart the web server ............................................................................................................................ 15

After all the configurations are done restart the server. ........................................................................ 15

Initializing the database ........................................................................................................................... 15

Schedule e-mail notification job (only for APM) ..................................................................................... 16

Test the web server ................................................................................................................................. 19

Operational Notes ........................................................................................................................................... 20

Backup ......................................................................................................................................................... 20

Log files ........................................................................................................................................................ 20

The CCSuite WAMP bundle The CCSuite WAMP bundle is at the moment only available for 64 bit windows.

Software needed: 1. CCSuite WAMP bundle

2. CCSuite PHP application

Can be downloaded from https://acsol-docs.s3.amazonaws.com/current_version.html

3. Visual C++ Redistributable for Visual Studio 2012.

http://www.microsoft.com/en-us/download/details.aspx?id=30679

Filename: vcredist_x64.exe

Filename: vcredist_x86.exe

4. A CCSuite license file

Contact Ciber Compliance Solution Center (CCSC) if you have not received this.

IMPORTANT: The software used in the bundle is 64 bit where available. Some components only exist for 32

bit, but work fine together with the 64 bit applications.

https://acsol-docs.s3.amazonaws.com/current_version.html

http://www.microsoft.com/en-us/download/details.aspx?id=30679

Installation & Configuration

Install the CCSuite bundle

All the software used for the CCSuite web server is placed in a single folder which needs to be unzipped

manually. Keeping all the software in a common folder makes it easier to maintain in the long run.

Furthermore the bundle assumes a D: drive is available. If you want to place the software in another folder

than the D: drive, you will have to maintain the references to the software in all the configuration files. This

will be explained later in this guide.

Unzipping the Bundle in the D: drive will create the following folder structure:

Install the CCSuite application

Download the file “ccs-<version>-<build>-php56.zip”. The zip file contains a folder named as the CCSuite

version e.g. “5.0.6”. Extract the contents of this folder into the folder D:\CCS\CCSuite\ so the result will look

similar to this:

Environment variables

Create the following system environment variables. The paths must be changed if the bundle is installed in

another location than the default location.

Create new system variables that point to the 2 following configuration file folders

PHP_APM_INI_PATH = D:\CCS\conf

PHPRC = D:\CCS\PHP\conf

Add the path to the PHP executables “D:\CCS\PHP” to the system variable “Path”.

Configuration files

There are five configuration files that are used by the server. All the files have been maintained to ensure

the bundle can run out of the box. These settings can be changed to accommodate your environment and

policies.

Configuration file for Apache

The configuration file is here “D:\CCS\Apache24\conf\httpd.conf”. The most important settings are

encapsulated by comments like:

# CCS-begin Parameter = value to be changed # CCS-end

The following parameters need to be changed:

ServerAdmin ServerName

There can be other parameters that must be maintained, so review the configuration file and change the

parameters to suit your needs.

Configuration file for FCGID

The configuration file is here “D:\CCS\Apache24\conf\extra\fcgi_php.conf”. The most important settings

are encapsulated by comments like:




Configuration file for PHP

The configuration file is here “D:\CCS\PHP\conf\php.ini”. The most important settings are encapsulated by

comments like:

; CCS-begin Parameter = value to be changed ; CCS-end



Configuration file for APM

The configuration file is here “D:\CCS\conf\apm.ini”.

Configuration file for FCGID

The configuration file is here “D:\CCS\MySQL\my.ini”. The most important settings are encapsulated by

comments like:




Visual C++ Redistributable for Visual Studio 2012 installation

The Visual C++ Redistributable Packages install runtime components that are required to run C++

applications built with Visual Studio 2012.

Important: Both the x86 and the x64 versions have to be installed

CCSuite license file

Place the delivered license file with the zl filetype and place it in the directory “D:\CCS\conf”

Install Apache service

Install Apache as a service. Open a command window in the folder “D:\CCS\Apache24\bin\” and execute

the following command.

httpd.exe -k install

Start the service Apache2.4 in the Computer Management Console

Uninstall Apache service

If you want to uninstall the service at a later time, open a command window in the folder

“D:\CCS\Apache24\bin\” and execute the following command.

httpd.exe -k uninstall

Install MySQL service

Install MySQL as a service. Open a command prompt in the folder “D:\CCS\MySQL\bin” and execute the

following command.

mysqld --install MySQL --defaults-file=D:\CCS\MySQL\my.ini

Start the service MySQL in the Computer Management Console

Uninstall MySQL service

If you want to uninstall the service at a later time, open a command window in the folder

“D:\CCS\MySQL\bin\” and execute the following command to stop the service:

NET STOP MySQL

Then execute the following command to remove the service:

mysqld –remove MySQL

Create the MySQL database

Log on to the database. Open a command prompt in the folder “D:\CCS\MySQL\bin” and execute the

following command.

mysql --host=localhost --user=root

Choose a username and password for use by the web application when connecting to the database. This should not be the MySQL root user. The username and password must be entered in the apm.ini file described in the Configuration File section. Execute the following commands to create the database, replacing <user> and <password> with the chosen username and password. Important: The <user> must be named eg. apm@localhost and not only apm.

create database apm;

use apm;

create user <user> identified by '<password>';

Important: record this username/password combination for later use.

GRANT ALL ON apm.* to <user>;

GRANT FILE ON *.* TO <user>;

The database schema will be populated as part of the application installation.

Note: Consider setting the password of the user root in the database

Restart the web server

After all the configurations are done restart the server.

Initializing the database

To initialize the CCS database, Open a command prompt in the folder “D:\CCS\CCSuite”, then type the following: php.exe cli_db_install.php --action UPDATE > update.log

Important: Only run this command once. The results are saved to a file. If you run this command twice the file is overwritten with the new result. Important: Inspect the update.log file to ensure that it does not contain any errors. If any errors are found, please send the log file to CCSC support team for analysis.

Schedule e-mail notification job (only for APM)

In order to enable the APM to send e-mail notifications, you must also schedule the notification script

to run at suitable intervals, e.g. every 5 minutes. This can be accomplished using any scheduler e.g.

Windows Task Scheduler.

The time intervals are set to approx. 5 minutes

The required command is the full path to php.exe, e.g.

D:\CCS\PHP\php.exe

The argument string is “cli_issue_notification.php --language=EN”, where EN (English) may be

replaced with the code of your preferred language.

The working directory must be the path where you install the APM web application (containing the

script “cli_issue_notification.php”) e.g.

D:\CCS\CCSuite\

Test the web server

Using the web browser on the web server, access the URL http://localhost/. If everything is working,

you should see a page similar to the following:

The next step is to ensure the SAP systems can logon to the web server

Operational Notes

Backup It is important to ensure that frequent consistent backups of the MySQL database are maintained. We

recommend taking a daily backup using e.g. the mysqldump utility.

There is no need to take backups of the ICE database, because the data here is replicated from the MySQL

database.

Log files Apache and PHP log files can get extremely large. It is important to archive or delete these log files

periodically to ensure the best possible application performance.

wamp bundle installation guide for ccsuitewamp+bundle...installation & configuration install the...

Documents