Requirement
1. postgres
2. All-In-One-SpagoBI-5.0-01102014
3. SpagoBIStudio_5.0.0_win32_23102014
4. postgres-dbscript-5.0.0_15092014
5. database any one oracle/sqlserver/mysql (i am using sqlserver)
6. apache tomcat 7
7. java jdk
go step by step
1. extract apache tomcat to some folder
2. extract All-In-One-SpagoBI-5.0-01102014.zip to folder and move to folder
e:\SpagoBI-Server-5.0-16092014\webapps\* cut or copy all spago engines to E:\apache-tomcat-7.0.61\webapps\*
3. move all library jar file from spago lib folder to apache tomcat
SpagoBI-Server-5.0-16092014\lib\* to apache-tomcat-7.0.61\lib\*
4. Move postgres and sqljdbc driver to "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\lib\" as well as at "apache-tomcat-7.0.61\lib\*"
5. we will going to create the spago repository on POSTGRES db, (i am not prefer sqlserver for spago repository.. for my case it throws lot of unresolved errors)
so for this we need to execute script from zip file "postgres-dbscript-5.0.0_15092014"
-create database "spagobi"
- execute script:
"PG_Create", "pg_create_quartz_schema"
6. modify server.xml file:
add below text under "GlobalNamingResources" tag.
<Environment name="spagobi_resource_path" type="java.lang.String" value="${catalina.base}/resources"/>
<Environment name="spagobi_sso_class" type="java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService"/>
<Environment name="spagobi_service_url" type="java.lang.String" value="http://localhost:8080/SpagoBI"/>
<Environment name="spagobi_host_url" type="java.lang.String" value="http://localhost:8080"/>
<Resource name="jdbc/spagobi"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgressql.Driver"
url="jdbc:postgressql://localhost:5432/spagobi"
username="postgres"
password="postgres"
maxActive="20"
maxIdle="10"
maxWait="-1"/>
7. Remove code from server.xml file
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
8. Modify context.xml
remove context tag and replace with below code
<Context docBase="SpagoBIProject" path="/SpagoBI" privileged="true" reloadable="true" source="org.eclipse.jst.j2ee.server:SpagoBIProject">
<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_host_url" name="spagobi_host_url" type="java.lang.String"/>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
</Context>
9. Now need to modify files at path: "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\"
10. modify file "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\hibernate.cfg.xml"
remove HSQLdialect from file <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
and add postgres dialect <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property> (at line number 17)
11. modify file "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\jbpm.hibernate.cfg"
Add postgres dialect at line number 19
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
12. modify "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\quartz.properties" file
Comment line number 31 (using #) for HSQL delegate
uncomment line number 37 for POSTGRESDelegate
i.e.
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
13. Dont forget to create enviornment variable of JAVA_HOME [upto path java-jdk] and path entry upto "bin" folder.
14. Set variable "JAVA_OPTS" in "catalina.bat" file
open file and add below line just above the line "rem Execute Java with the applicable properties"
set "JAVA_OPTS=%JAVA_OPTS% -Xms2048m -Xmx2048m -XX:PermSize=512m -XX:MaxPermSize=512m"
