Pentaho 1.7 - Base installation

Instalación de software base

Java JDK

Versión mínima: 1.5 Versión instalada: 1.5.0_14

De acuerdo a las políticas se instalo este paquete manualmente.

Directorio de instalación: /opt/jdk1.5.0_14

Otras configuraciones:

* Se creo un link simbólico jdk1.5 referenciando a /opt/jdk1.5.0_14
* En /etc/profile se agrego en $PATH la ruta /opt/jdk1.5/bin
* En /etc/profile se agrego la variable JAVA_HOME con la ruta /opt/jdk1.5
* En /etc/environment se agrego la variable JAVA_HOME con la ruta /opt/jdk1.5

Tomcat

(Instalación manual)

Versión mínima: 5.5

Versión instalada: apache-tomcat-5.5.26

Ant

Versión mínima: 1.6.2

Versión instalada: 1.6.5-6 (Debian package)

MySQL

Versión mínima: 5.x

Versión instalada: 5.0.32-7etch5 (Debian package)

Instalación Pentaho

Instalación de libreria de Java para conexión con MySQL

apt-get install libmysql-java
cp /usr/share/java/mysql-connector-java-5.0.4.jar /opt/tomcat/common/lib/

Bajar software

wget http://internode.dl.sourceforge.net/sourceforge/pentaho/pentaho_j2ee_deployments-1.7.1.zip
wget http://internode.dl.sourceforge.net/sourceforge/pentaho/pentaho_solutions-1.7.1.zip
wget http://source.pentaho.org/svnroot/legacy/pentaho-data/branches/1.7/mysql5/SampleDataDump_MySql.sql

Abrir pentaho_j2ee_deployments-1.7.1.zip en un directorio temporal y ejecutar dentro del directorio creado

ant zip-pentaho-style-war
ant zip-pentaho-steel-wheels-style-war
ant zip-pentaho-portal-layout-war
ant war-pentaho-tomcat-mysql

Desde el directorio creado build copiar a /opt/tomcat/webapps

• pentaho-portal-layout.war
• pentaho-style.war
• pentaho.war
• sw-style.war

Abrir pentaho_solutions-1.7.1.zip en /opt/pentaho/pentaho-solutions Arreglar permisos:

chown -R tomcat:tomcat /opt/pentaho

Crear los usuarios de Pentaho en MySQL

create user 'pentaho_user'@'localhost';
create user 'pentaho_admin'@localhost;
create user 'hibuser'@localhost;
set password for 'hibuser'@'localhost' = PASSWORD('password');
set password for 'pentaho_user'@'localhost' = PASSWORD('password');
set password for 'pentaho_admin'@'localhost' = PASSWORD('password');
flush privileges;

Cargar base de datos

cat SampleDataDump_MySql.sql | mysql -uroot -p

Cambiar en /opt/tomcat/webapps/pentaho/WEB-INF/web.xml

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

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

Agregar a /opt/tomcat/conf/server.xml antes de </host>

 <Context path="/pentaho" docbase="webapps/pentaho/">
 <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false"/>
 <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="hibuser" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/hibernate" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/SampleData" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/quartz" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/Shark" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/shark" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/SampleDataAdmin" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/solution1" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/solution2" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/solution3" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/solution4" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/solution5" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/datasource1" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/datasource2" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/datasource3" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/datasource4" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
 <Resource name="jdbc/datasource5" auth="Container" type="javax.sql.DataSource" maxActive="20"
   maxIdle="5" maxWait="10000" username="pentaho_user" password="password" validationQuery="Select 1"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost/sampledata" testOnBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="10000"
   maxEvictableIdleTimeMillis="60000"/>
  </Context>

Configurar Hibernate en

/opt/tomcat/webapps/pentaho/WEB-INF/classes/hibernate.cfg.xml

Configurar password de publicación:

/opt/pentaho/pentaho-solutions/system/publisher_config.xml

Referencias

• Manual Deployment of Pentaho
• Pentaho Advanced Install Guide
• HOWTO Manual-Tomcat-Deployment
• Pentaho Glassfish Deployment

• The Pentaho Administration Console
• Pentaho Liferay Integration Project
• Architecture