-
15. Re: JBOSS AS 7.1.1 + Pentaho
Mauricio, Adriano obrigado pela ajuda.
Segui o tutorial do Mauricio e consegui levantar o JBoss com o Pentaho. Estou um pouco enrolado mas assim que der eu posto aqui tudo o que fiz, abraços!
-
16. Re: JBOSS AS 7.1.1 + Pentaho
Oi Mário,
Parabéns cara
Nuss meu eu apanhei tanto que fiquei até cansado rsrsrs quando der um tempo ai mostra pra gente como ficou!
Grande Abraço
-
17. Re: JBOSS AS 7.1.1 + Pentaho
e aí Mário.. conta pra gente como foi que você resolveu... abraço!!
-
18. Re: JBOSS AS 7.1.1 + Pentaho
Fala galera, peço desculpas pela demora, segue todos os passos que tomei...
=======================
Pre
=======================
Verificar local do Java
Setar variáveis JAVA_HOME e PENTAHO_JAVA_HOME para este local
Instalar ant
Setar variável ANT_HOME para o local de instalação do ant
Incluir $ANT_HOME/bin no PATH
=======================
Configurar JBoss
=======================
=======================
Configurando Oracle
=======================
Executar os scripts localizados /biserver-manual-ce/pentaho-res/jboss/datasources/oracle10g no banco Oracle que servirá de repositório.
Entre cada script, reconecte como SYSDBA.
cd /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/
vi applicationContext-spring-security-hibernate.properties
Altere para as linhas abaixo, certificando que os dados de conexão e a senha estão ajustados corretamente.
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@192.168.1.0:1521:<INSTANCIA>
jdbc.username=hibuser
jdbc.password=password
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
vi applicationContext-spring-security-jdbc.xml
Alterar as linhas
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url"
value="jdbc:hsqldb:hsql://localhost:9001/hibernate" />
Pelas linhas
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="url"
value="jdbc:oracle:thin:@192.168.1.0:1521:<INSTANCIA>" />
Verificando a string de conexão, acima, e a senha do usuário hibuser nas linhas seguintes.
cd /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/hibernate
vi oracle10g.hibernate.cfg.xml
Altere os dados de conexão para algo similar ao abaixo e a senha, se necessário.
<property name="connection.url">jdbc:oracle:thin:@192.168.1.0:1521:<INSTANCIA></property>
cd /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/quartz
vi quartz.properties
Troque a linha
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
Pela linha
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
Altere a propriedade jndiName de Quartz para jboss/datasources/Quartz
cd /usr/local/pentaho/biserver-manual-ce/custom-pentaho-webapp/WEB-INF
mkdir lib
cd /usr/local/pentaho/biserver-manual-ce/pentaho-third-party/
cp quartz-oracle-1.5.2.jar /usr/local/pentaho/biserver-manual-ce/custom-pentaho-webapp/WEB-INF/lib
cd /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/dialects/oracle10g
cp -i audit_sql.xml /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system
vi /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/audit_sql.xml
Alterar o nome JNDI de Hibernate para jboss/datasources/Hibernate
O ant não respeita a propriedade db=oracle10g, por isso é necessário editar o arquivo a seguir
cd /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/hibernate
vi hibernate-settings.xml
Trocar a linha
<config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file>
Pela linha
<config-file>system/hibernate/oracle10g.hibernate.cfg.xml</config-file>
=======================
Remover Xalan
=======================
Em função de incompatibilidade com o xalan distribuído com o Jboss
rm /usr/local/pentaho/biserver-manual-ce/pentaho-third-party/xalan-2.6.0.jar
rm /usr/local/pentaho/biserver-manual-ce/pentaho-webapp/WEB-INF/tld/portlet.tld
===========================
Ajustar caminho do pentaho
===========================
Caminho que será utilizado para as soluções Pentaho
cd /usr/local/pentaho/biserver-manual-ce/pentaho-webapp/WEB-INF
vi web.xml
Na seção abaixo, o valor do parâmetro por default está vazio. Alterar para o caminho acima, seguido de pentaho-solutions.
<context-param>
<param-name>solution-path</param-name>
<param-value>/usr/local/pentaho/biserver-manual-ce/pentaho-solutions</param-value>
</context-param>
Na seção abaixo, garanta que o IP e porta sejam aqueles habilitados pelo JBoss:
<context-param>
<param-name>fully-qualified-server-url</param-name>
<param-value>http://192.168.1.1:8080/pentaho/</param-value>
</context-param>
Na seção resource-ref referente ao Quartz, acrescentar a linha
<lookup-name>java:jboss/datasources/Quartz</lookup-name>
Na seção resource-ref referente ao Hibernate, acrescentar a linha
<lookup-name>java:jboss/datasources/Hibernate</lookup-name>
Adicionar as linhas abaixo
<servlet>
<servlet-name>ThemeServlet</servlet-name>
<servlet-class>org.pentaho.platform.web.servlet.ThemeServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ThemeServlet</servlet-name>
<url-pattern>/js/themes.js</url-pattern>
</servlet-mapping>
vi /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/data-access/settings.xml
Altere a propriedade data-access-staging-jndi de Hibernate para jboss/datasources/Hibernate
==============================
Criar o modules no jboss 6
==============================
cd /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/modules/com/oracle/ojdbc6/main/
criar o arquivo modules.xml com o conteudo abaixo
vi module.xml
<module xmlns="urn:jboss:module:1.1" name="com.oracle.ojdbc6">
<resources>
<resource-root path="ojdbc6.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
cp /midias/ojdbc6.jar /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/modules/com/oracle/ojdbc6/main/
cp /midias/ojdbc6.jar /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments
cp /midias/ojdbc6.jar /usr/local/pentaho/biserver-manual-ce/custom-pentaho-webapp/WEB-INF/lib/
===========================
Remoção dos Samples
===========================
cd /usr/local/pentaho/biserver-manual-ce/pentaho-solutions/system/olap
dos2unix datasources.xml
vi datasources.xml
Remover as seções abaixo:
<Catalog name="SteelWheels">
<DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>
<Definition>solution:steel-wheels/analysis/steelwheels.mondrian.xml</Definition>
</Catalog>
<Catalog name="SampleData">
<DataSourceInfo>Provider=mondrian;DataSource=SampleData</DataSourceInfo>
<Definition>solution:steel-wheels/analysis/SampleData.mondrian.xml</Definition>
</Catalog>
====================================
Configurar IPs de acesso no Jboss
====================================
vi /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/configuration/standalone.xml
Trocar as linhas
<interfaces>
<interface name="management">
<inet-address value="${jboss.bind.address.management:0.0.0.0}"/>
</interface>
<interface name="public">
<inet-address value="${jboss.bind.address:0.0.0.0}"/>
</interface>
<!-- TODO - only show this if the jacorb subsystem is added -->
<interface name="unsecure">
<!--
~ Used for IIOP sockets in the standard configuration.
~ To secure JacORB you need to setup SSL
-->
<inet-address value="${jboss.bind.address.unsecure:127.0.0.1}"/>
</interface>
</interfaces>
Pelas
<interfaces>
<interface name="management">
<any-address/>
</interface>
<interface name="public">
<any-address/>
</interface>
<interface name="unsecure">
<any-address/>
</interface>
</interfaces>
===========================
Configurar o datasource
===========================
vi /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/configuration/standalone.xml
trocar a tag <subsystem xmlns="urn:jboss:domain:datasources:1.1"> pela tag abaixo
<subsystem xmlns="urn:jboss:domain:datasources:1.0">
<datasources>
<datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<datasource jta="true" jndi-name="java:jboss/datasources/Hibernate" pool-name="HibernateDS" enabled="true" use-java-context="true" use-ccm="true">
<connection-url>jdbc:oracle:thin:@192.168.1.0:1521:<INSTANCIA></connection-url>
<driver>oracle</driver>
<pool>
<prefill>true</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>hibuser</user-name>
<password>password</password>
</security>
</datasource>
<datasource jta="true" jndi-name="java:jboss/datasources/Quartz" pool-name="QuartzDS" enabled="true" use-java-context="true" use-ccm="true">
<connection-url>jdbc:oracle:thin:@192.168.1.0:1521:<INSTANCIA></connection-url>
<driver>oracle</driver>
<pool>
<prefill>true</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>quartz</user-name>
<password>password</password>
</security>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="oracle" module="com.oracle.ojdbc6">
<xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
===========================
Build do Pentaho
===========================
vi /usr/local/pentaho/biserver-manual-ce/pentaho-webapp/WEB-INF/jboss-web.xml
trocar a linha
<jndi-name>java:/Quartz</jndi-name>
pela
<jndi-name>java:jboss/datasources/Quartz</jndi-name>
troca a linha
<jndi-name>java:/Hibernate</jndi-name>
pela
<jndi-name>java:jboss/datasources/Hibernate</jndi-name>
cd /usr/local/pentaho/biserver-manual-ce
rm -Rf build
ant war-pentaho-jboss -Ddb=oracle10g -logfile pentaho-build.txt
===========================
Deploy do Pentaho
===========================
rm -Rf /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho.war
mkdir -p /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho.war
rm -Rf /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho-style.war
mkdir -p /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho-style.war
cp /usr/local/pentaho/biserver-manual-ce/build/pentaho-wars/jboss/no-portal/pentaho.war /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho.war
cp /usr/local/pentaho/biserver-manual-ce/build/pentaho-wars/pentaho-style.war /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho-style.war
cd /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho.war
unzip pentaho.war
rm pentaho.war
cd /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho-style.war
unzip pentaho-style.war
rm pentaho-style.war
cd /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/
touch pentaho.war pentaho.war.dodeploy
touch pentaho-style.war pentaho-style.war.dodeploy
----------------------------------------------
================================================
Instalação do Admin Console
================================================
Extrair a pasta administration-console da distribuição Pentaho de comunidade não manual.
cd /administration-console
Inserir o drive na configuração do adminsitrator-console
mkdir /midias/ojdbc6.jar /usr/local/pentaho/administration-console/jdbc
vi start-pac.sh
Acrescentar um espaço em branco no final da primeira linha: #!/bin/sh
vi stop-pac.sh
Acrescentar um espaço em branco no final da primeira linha: #!/bin/sh
Na linha abaixo, acrescentar o caminho resource/config, senão a classe não encontra o log4j
THE_CLASSPATH="$DIR_REL:$DIR_REL/resource/config:$DIR_REL/resource:$DIR_REL/bin:$DIR_REL/classes:$DIR_REL/lib"
dos2unix start-pac.sh
dos2unix stop-pac.sh
dos2unix set-pentaho-env.sh
===============================================
Deploy do Admin Console
===============================================
Ele espera encontrar o jre embaixo do biserver-ce, então:
cd /usr/local/pentaho/biserver-manual-ce
ln -s /usr/java/jdk1.6.0_41 jre
cd /usr/local/pentaho/administration-console/resource/config
vi console.properties
Alterar as portas de start e stop, para o padrão do cliente, verificando antes se elas estão livres com netstat -nlptu | grep <porta>
console.start.port.number=8188
console.stop.port.number=8133
vi console.xml
Alterar as duas linhas abaixo. Os dois caminhos foram configurados na instalação do Pentaho
<solution-path>/usr/local/pentaho/biserver-manual-ce/pentaho-solutions</solution-path>
<war-path>/usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/standalone/deployments/pentaho.war</war-path>
Subir o Jboss
cd /usr/local/jboss/jboss-EAP-6.0.1/jboss-eap-6.0/bin
./standalone.sh
Subir Admin Console
Obs: abrir outra seção SH
cd /usr/local/pentaho/administration-console
./start-pac.sh
Usuario/Senha Admin console
admin/password
-
19. Re: JBOSS AS 7.1.1 + Pentaho
que massa meu brother! parabéns!
e obrigado por compartilhar conosco!
abração!
Adriano Schmidt
-