Build and Deploy Pentaho

Build Pentaho as follows:

1. Checkout the necessary sources from subversion:
   1. mkdir pentaho-dev
   2. cd pentaho-dev
   3. svn co http://code.dimagi.com/svn/Gather/pentaho/pentaho/branches/1.7 pentaho (Checkout Pentaho core code)
   4. svn co http://code.dimagi.com/svn/Gather/pentaho/pentaho-data/trunk pentaho-data (Checkout pentaho data source)
   5. svn co http://code.dimagi.com/svn/Gather/pentaho/pentaho-solutions/trunk pentaho-solutions (Checkout pentaho solutions directory)
   6. svn co http://code.dimagi.com/svn/Gather/pentaho/pentaho-style/trunk pentaho-style (Checkout pentaho styles)
   7. svn co svn://source.pentaho.org/svnroot/legacy/pentaho-preconfiguredinstall/branches/1.7 pentaho-preconfiguredinstall (dependency for pentaho build script)
   8. svn co svn://source.pentaho.org/svnroot/legacy/pentaho-tomcat/branches/1.7 pentaho-tomcat (dependency for pentaho build script)

2. Configure build properties
   1. Add a file called override.properties to the /pentaho directory.
   2. Add a line to override.properties that says javac.path=<path_to_javac>, where <path_to_javac> is the actual path on your machine to the java compiler (Remember to use forward slashes in Windows - e.g., C:/Program Files/Java/jdk1.6.0_05/bin/javac)

3. Configure the /pentaho/server/pentaho/webapp/WEB-INF/web.xml file
   1. Look the following tag and replace pentaho-solutions with the full path to the pentaho solutions directory that you checked out above.

        <context-param>
          <param-name>solution-path</param-name>
          <param-value>pentaho-solutions</param-value>
        </context-param>
      

   2. Look the following tag and replace localhost:8080 with the host:port of your Tomcat server if different.

        <context-param>
          <param-name>base-url</param-name>
          <param-value>http://localhost:8080/pentaho/</param-value>
        </context-param>
      

4. Build
   1. From the /pentaho directory, run ant war-pentaho-tomcat-hsqldb
      • This will populate war files in /build/pentaho-wars/. The only war you want from here, however is /build/pentaho-wars/tomcat/hsqldb/pentaho.war
   2. From the /pentaho-style directory, run mvn package
      • This will create /pentaho-style/target/pentaho-style.war

Deploy Pentaho

GATHER currently deploys pentaho to Tomcat. The following instructions worked under Tomcat 5.5:

1. Stop Tomcat.
2. Copy /pentaho-data/lib/hsqldb.jar to <TOMCAT_HOME>/common/lib
3. Edit the <TOMCAT_HOME>/conf/server.xml file, and add the following resource under the <GlobalNamingResources>...</GlobalNamingResources> tag:

   <Resource name="jdbc/gather"
                 auth="Container"
                 type="javax.sql.DataSource"
                 maxActive="10" 
                 maxIdle="5"
                 maxWait="5000"
                 username="sa"
                 password=""
                 factory="org.apache.commons.dbcp.BasicDataSourceFactory"
                 driverClassName="org.hsqldb.jdbcDriver"
                 url="jdbc:hsqldb:hsql://localhost/gather" />
   

4. Add /pentaho/build/pentaho-wars/tomcat/hsqldb/pentaho.war and /pentaho-style/target/pentaho-style.war to the <TOMCAT_HOME>/webapps directory
5. Make sure the data source is running (run either pentaho-data/start_hypersonic.sh or pentaho-data/start_hypersonic.bat)
6. Start Tomcat.

References

•  Manual Deployment of Pentaho
•  Exploring the build.xml (pentaho)