JBossDeveloper

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!

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