Gacq: Página nueva: = 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 i...

2009-09-13T13:49:16Z

Página nueva: = 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 i...

Página nueva

= 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>
<pre>
<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>
</pre>

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 =
* [http://wiki.pentaho.com/display/PentahoDoc/Manual+Deployment+of+Pentaho Manual Deployment of Pentaho]
* [http://source.pentaho.org/viewvc/svnroot/pentaho-doc/tags/build_1_1_5_512/guides/Pentaho_Advanced_Install_Guide.doc?revision=3&pathrev=250 Pentaho Advanced Install Guide]
* [http://www.pentaho-wiki.com/wiki/HOWTO_Manual-Tomcat-Deployment HOWTO Manual-Tomcat-Deployment]
* [http://wiki.pentaho.com/display/PentahoDoc/Pentaho+Glassfish+Deployment Pentaho Glassfish Deployment]

* [http://wiki.pentaho.com/display/PentahoDoc/01.The+Pentaho+Administration+Console The Pentaho Administration Console]
* [http://wiki.pentaho.com/display/PentahoDoc/Pentaho+Liferay+Integration+Project Pentaho Liferay Integration Project]
* [http://wiki.pentaho.com/display/PentahoDoc/Architecture Architecture]

Pentaho 1.7 - Base installation - Historial de revisiones

Gacq: Página nueva: = 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 i...