spagobi server installation v3

SpagoBI 3 - InstallationAngelo Bernabei2011/06/20 16:49

spagobi_server - SpagoBI 3 - Installation

- last modified by Angelo Bernabei on 2011/06/20 16:49

Table of ContentsInstall JDK .............................................................................................................................................................................. 3Install Tomcat ......................................................................................................................................................................... 3Install SpagoBI Metadata DB ................................................................................................................................................ 3Deploy SpagoBI WebApplication on Tomcat ....................................................................................................................... 3Configure SpagoBI ................................................................................................................................................................. 4

Edit server.xml ..................................................................................................................................................................... 4Set Up Data Source ............................................................................................................................................................. 4Set up Environment variables .............................................................................................................................................. 4Context /SpagoBI ................................................................................................................................................................. 5Context /SpagoBI*Engine .................................................................................................................................................... 5Thread Manager ................................................................................................................................................................... 5

Some additional Libraries ...................................................................................................................................................... 5Run & Test... .......................................................................................................................................................................... 6



• Install JDK• Install Tomcat• Install SpagoBI Metadata DB• Deploy SpagoBI WebApplication on Tomcat• Configure SpagoBI

° Edit server.xml° Set Up Data Source° Set up Environment variables

· Environment variable: resource-path· Environment variable: spagobi-sso-class· Environment variables: spagobi-service-url· Environment variables: spagobi-host-url

° Context /SpagoBI° Context /SpagoBI*Engine° Thread Manager

• Some additional Libraries• Run & Test...

These are the steps to install SpagoBI:

Install JDK

If you haven't installed JVM ( 1.5 or 1.6 )in your computer, you have to download it from SUN site and install it.

Install Tomcat

Download Tomcat 6.0.18 from http://tomcat.apache.org/download-60.cgi and unzip apache-tomcat-6.0.18.zip.To test if the installation is correct, you have to:

• try to double-click on apache-tomcat-6.0.18/bin/startup.bat• Open Browser to http://localhost:8080• You should be able to see the "Tom cat"

Install SpagoBI Metadata DB

SpagoBI use a schema to store some information about configuration, document template, etc...You have to create this schema using a SQL script according to your DBMS Type ( Oracle... MySQL .. etc...): you canfind available scripts in "Scripts db" package of SpagoBI Server release. Those released files may contain, apart from .sqlscritps, a README.txt file and patches to be applied to SpagoBI Server: in this case you have to follow the instructions ofREADME.txt after having deployed SpagoBI war files as explained here below.

For example, in MySql you have to open "MySql Query Browser" and execute this file:

• MySQL-create.sql• MySQL-create-quartz-schema.sql

And to recreate Foodmart you have to open "MySql Administrator" and execute an import of foodmart DB.Remember to change the MySQL File dimension ( my.ini)

Deploy SpagoBI WebApplication on Tomcat

Copy all WAR in WEBAPP Folder of Tomcat, run Tomcat with startup.bat.This operation extracts all WAR files and allows you to edit the configuration files.

Don't worry if Tomcat writes some type of error in console or log files

http://tomcat.apache.org/download-60.cgi

http://localhost:8080



Configure SpagoBI

And now you have to edit some configurations file.

Edit server.xml

This is the main configuration file of Tomcat and in this file we have to

• Set up DataSource• Set up Environment variables

From the version *2.3* the context information are embedded in *META-INF/context.xml*, these files are alreadyincluded in all packages.

If you don't use the 6.0.18 version of Tomcat you have to check in [ http://www.apache.org ] how these configurationsare made.

Set Up Data Source

To add a new Data Source you have to insert this fragment of XML under

<GlobalNamingResources>

<Resource auth= "Container" driverClassName= "com.mysql.jdbc.Driver" maxActive= "20" maxIdle= "10" maxWait= "-1" name= "jdbc/spagobi" password= "root" type= "javax.sql.DataSource" url= "jdbc:mysql://localhost/spagobi"username= "root" /><Resource auth= "Container" driverClassName= "com.mysql.jdbc.Driver" maxActive= "20" maxIdle= "10" maxWait= "-1" name= "jdbc/foodmart" password= "root" type= "javax.sql.DataSource" url= "jdbc:mysql://localhost/foodmart"username= "root" />

The first is the Connection poll for SpagoBI metadata and the second is the Connection pool for Foodmart ( the DWH fordemos )The JDBC driver must be presented in the folder lib

Set up Environment variables

To add a new Variable you have to insert this fragment of XML under

<GlobalNamingResources>

<Environment name= "<VARIABLE-NAME>" type= "java.lang.String" value= "<VARIABLE-VALUE>" />

Remember to insert in each Context the resource-link:

<ResourceLink global= "<VARIABLE-NAME>" name= "<VARIABLE-NAME>" type= "java.lang.String" />

Environment variable: resource-path

<Environment name= "spagobi-resource-path" type= "java.lang.String" value= "C:\spagobi2.0\resources" />

SpagoBI Server uses this path to read some resources like:

• QBE DataMart• Mondrian XML schema• Talend JOB• Image included in report• HTML file

Remember to create this PATH !!!!!

Environment variable: spagobi-sso-class

<Environment name= "spagobi-sso-class" type= "java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService" />

These classes implements the interaction between SpagoBI and the SSO system.

• it.eng.spagobi.services.common.FakeSsoService(NO SSO)• it.eng.spagobi.services.cas.CasSsoService ( CAS 2.0 )

http://www.apache.org



• it.eng.spagobi.services.cas.CasSsoServiceNoProxy( CAS 2.0 , without WebService Security )• it.eng.spagobi.services.cas.CasSsoService3 ( CAS 3.0 )• it.eng.spagobi.services.cas.CasSsoService3NoProxy ( CAS 3.0, without WebService Security )

Environment variables: spagobi-service-url<Environment name= "spagobi-service-url" type= "java.lang.String" value= "http://localhost:8080/SpagoBI" />

This URL is only for back-end serviceYou have to change this value if SpagoBI core and some Engines are not installed in the same server

Environment variables: spagobi-host-url<Environment name= "spagobi-host-url" type= "java.lang.String" value= "http://localhost:8080" />

This URL is used to produce some address in html.This is useful if there is a proxy server between the SpagoBI Server and the Browser

Context /SpagoBI

These context information are embedded in META-INF/context.xml, but you can insert this xml in server.xml if youprefere.

<Context docBase= "SpagoBI" path= "/SpagoBI" privileged= "true" reloadable= "true" > <ResourceLink global= "jdbc/spagobi" name= "jdbc/spagobi" type= "javax.sql.DataSource" /> <ResourceLink global= "jdbc/foodmart" name= "jdbc/foodmart" type= "javax.sql.DataSource" /> <ResourceLink global= "spagobi-resource-path" name= "spagobi-resource-path" type= "java.lang.String" /> <ResourceLink global= "spagobi-sso-class" name= "spagobi-sso-class" type= "java.lang.String" /> <ResourceLink global= "spagobi-host-url" name= "spagobi-host-url" type= "java.lang.String" /></Context>

You have to define /SpagoBI Context, this configuration depends on the Tomcat version ( check on [ http://www.apache.org ] )

Context /SpagoBI*Engine

These context information are true for all ENGINE and are embedded in META-INF/context.xml, but you can insert thisxml in server.xml if you prefere.

<Context docBase= "SpagoBIJasperReportEngine" path= "/SpagoBIJasperReportEngine" privileged= "true" reloadable="false" ><ResourceLink global= "jdbc/foodmart" name= "jdbc/foodmart" type= "javax.sql.DataSource" /><ResourceLink global= "jdbc/spagobi" name= "jdbc/spagobi" type= "javax.sql.DataSource" /> <ResourceLink global= "spagobi-resource-path" name= "spagobi_resource-path" type= "java.lang.String" /> <ResourceLink global= "spagobi-sso-class" name= "spagobi-sso-class" type= "java.lang.String" /> <ResourceLink global= "spagobi-service-url" name= "spagobi-service-url" type= "java.lang.String" /></Context>

Thread Manager

SpagoBI uses a Thread manager in off-line activities to:

• Execute Talend JOB• Execute Process ( CommonJ Engine )

It's possible to configure the number of thread, in server.xml you have to put:

<Resource auth= "Container" factory= "de.myfoo.commonj.work.FooWorkManagerFactory" maxThreads= "5" name= "wm/SpagoWorkManager" type= "commonj.work.WorkManager" />

*Important*: you have to put this resource link in /SpagoBITalendEngine and /SpagoBICommonJEngineContext: <ResourceLink global= "wm/SpagoWorkManager" name= "wm/SpagoWorkManager" type="jcommonj.work.WorkManager" />

Some additional Libraries

Each SpagoBI WebApplication contains all required libraries to run, for the resources defined in server.xml you have toinclude these libraries in /LIB folder.





• commonj-twm.jar• concurrent.jar• mysql-connector-java-3.1.13-bin.jar• foo-commonj.jar• some required libraries for JDBC Drivers.

You can find these libraries in source distribution or All-In-One-SpagoBI-3.x.x-apache-tomcat-6.0.18-xxxx.zip

Run & Test...

Open Browser : [ http://localhost:8080/SpagoBI ]

You can use this users:

• biadmin• bitest• bimodel• bidev• biuser

The password and username are the same.

http://localhost:8080/SpagoBI

spagobi server installation v3

Documents