Installation Guide

Installation Guide

Introduction

This document describe the environment requirements and the installation steps for the Spago4Q 2.3.2 platform. Spago4Q 2.3.2 is a vertical solution based on the SpagoBI 3.1 suite.

Hardware Requirements

Minimal configuration.

We recommend to use a server with at least a 2 CPU, 3 GHz , 4 GB RAM and a 160 GB hard disk.

For test environment the database can be installed on the same server.

For production environment the database can be installed on another server.

Software Requirements

Here is reported the description of the environment used for the development and test of the Spago4Q platform and, this environment, is the target of the installation steps described in this document. This Spago4Q version is released for MySQL database.

• Spago4Q 2 available from http://www.spago4q.org in the download section
• SpagoBI 2 available from http://www.spagobi.org in the download section
• Java SE JDK 1.5 or 1.6 from http://java.sun.com/javase/downloads
• Apache Tomcat from http://tomcat.apache.org
• MySQL from http://www.mysql.org

• PostgreSQL 8.1 or higher
• Oracle 10g or higher

• Windows XP Server
• MS Windows 7
• Linux RHEL4 - AMD64/Intel64
• Linux RHEL4 - x86
• Linux RHEL5 - AMD64/Intel64
• Linux RHEL5 - x86
• Ubuntu 9.10 or higher

SpagoBI

Spago4Q is based on SpagoBI. The compatible versions are listed in the next table:

Package Components

This chapter describe which are the packages made available for this release and what's on these packages. From the Spago4Q download site the available packages are:

1. Spago4Q-2.3.2-core-20110909.zip - This package contains the main application for extending an already installed

1. Spago4Q-2.3.2-sql-20110909.zip - This package contains all the sql scripts for extending an already installed

1. Spago4Q-2.3.2-quick-install-20110909.zip - This package contains the binaries, database dump and the configuration files used for the quick installation steps.

Quick Install

Step 1

The assumption here is that you have a MySQL database up and running on your local machine and on the default port. Create an account on the database for both SpagoBI and Spago4Q metadata. Create a schema with the same name and give to the user all the grants on this schema.

Step 2

Download the SpagoBI 3.1 package (All-In-One-SpagoBI-3.1-07212011.zip) and unzip it on a folder. For example:

Step 3

Download the package Spago4Q-2.3.2-quick-install-20110909.zip and unzip it in a temporary folder. The contents of this archive are:

• Tomcat-6.0.18: this folder contains all the Spago4Q 2.3.1 binaries and some other files according to the tomcat structure
• quick-install.sql: the MySQL dump file

Be sure to exactly overlap the contents of the SpagoBI tomcat folder and the Spago4Q tomcat folder.

For the Linux user the commands will looks like:

cp -R [tmp folder]/Spago4Q-2.3.2-quick-install/tomcat-6.0.18/conf/* /home/spago4q/apache-tomcat-6.0.18/conf 

cp -R [tmp folder]/Spago4Q-2.3.2-quick-install/tomcat-6.0.18/webapps/* /home/spago4q/apache-tomcat-6.0.18/webapps

Import the database dump file quick-install.sql into the schema defined in Step 1.

Step 4

Start the Tomcat server:

For Linux users check the .sh file are in the correct file format and if it's the case turn them form the windows to the linux format. To do that you can, for example, use the dos2unix utility.

dos2unix -U *.sh

Once the application is started point your favorite browser to:

http://localhost:8080/SpagoBI

and login as:

The installation is completed and the platform has two more users configured: s4qadmin, s4quser.