table "qrtz_job_listeners"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:77: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_triggers_pkey" for table "qrtz_triggers"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:89: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_simple_triggers_pkey" for table "qrtz_simple_triggers"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:100: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_cron_triggers_pkey" for table "qrtz_cron_triggers"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:110: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_blob_triggers_pkey" for table "qrtz_blob_triggers"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:120: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_trigger_listeners_pkey" for table "qrtz_trigger_listeners"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:128: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_calendars_pkey" for table "qrtz_calendars"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:135: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_paused_trigger_grps_pkey" for table "qrtz_paused_trigger_grps"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:151: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_fired_triggers_pkey" for table "qrtz_fired_triggers"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:160: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_scheduler_state_pkey" for table "qrtz_scheduler_state"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:166: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_locks_pkey" for table "qrtz_locks"CREATE TABLEINSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1COMMIT~$ psql -p 5432 -f /opt/pentaho/biserver-ce/data/postgresql/create_sample_datasource_postgresql.sqlYou are now connected to database "hibernate" as user "hibuser".BEGININSERT 0 1COMMITVerifique se os bancos foram criados com sucesso.~$ psql -p 5432psql (9.1.0)Type "help" for help.postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+--------------+----------+-------------+-------------+------------------------------- hibernate | hibuser | UTF8 | pt_BR.UTF-8 | pt_BR.UTF-8 | =Tc/hibuser + | | | | | hibuser=CTc/hibuser postgres | postgres | UTF8 | pt_BR.UTF-8 | pt_BR.UTF-8 | quartz | pentaho_user | UTF8 | pt_BR.UTF-8 | pt_BR.UTF-8 | =Tc/pentaho_user + | | | | | pentaho_user=CTc/pentaho_user(3 rows) Backup do sistema de arquivosPare os servicos do Pentaho Administration Console (PUC) e Pentaho Administration Console (PAC). Como e de costume, vamos considerar alguns parametros de posts anteriores, como o path de instalacao a ser utilizado, na pasta "/opt/pentaho/", para refereiciar os procedimentos a seguir.~# cd /opt/pentaho/administration-console~# ./stop-pac.sh &~# cd ../biserver-ce/ ~# ./stop-pentaho.sh & Em seguida, no sistema de arquivos, faca um backup da pasta "biserver-ce".~# cd /opt/pentaho~# cp -r biserver-ce biserver-ce.oriConfiguracoesUtilizando um editor de sua preferencia, altere os arquivos indicados a seguir.- Arquivo: /opt/pentaho/biserver-ce/tomcat/webapps/pentaho/WEB-INF/web.xml Inclua o path do repositorio de solucoes. Alterar de: solution-path Para: solution-path /opt/pentaho/biserver-ce/pentaho-solutionsAltere a url de acesso utilizando o ip do host. Altera de: fully-qualified-server-url http://localhost:8080/pentaho/Para: fully-qualified-server-url http://192.168.1.10:8080/pentaho/Exclua as informacoes de start do hiernate e do quartz no hsqldb, mantendo apenas o sampledata. Alterar de: hsqldb-databases sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartzPara: hsqldb-databases sampledata@../../data/hsqldb/sampledata- Arquivo: /opt/pentaho/biserver-ce/pentaho-solutions/system/applicationContext-spring-security-jdbc.xmlAlterar de: class="org.springframework.jdbc.datasource.DriverManagerDataSource"> org.hsqldb.jdbcDriver" /> value="jdbc:hsqldb:hsql://localhost:9001/hibernate" /> Para: class="org.springframework.jdbc.datasource.DriverManagerDataSource"> org.postgresql.Driver" /> value="jdbc:postgresql://localhost:5432/hibernate" /> - Arquivo: /opt/pentaho/biserver-ce/pentaho-solutions/system/applicationContext-spring-security-hibernate.propertiesAlterar de:jdbc.driver=org.hsqldb.jdbcDriverjdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernatejdbc.username=hibuserjdbc.password=passwordhibernate.dialect=org.hibernate.dialect.HSQLDialectPara:jdbc.driver=org.postgresql.Driverjdbc.url=jdbc:postgresql://localhost:5432/hibernatejdbc.username=hibuserjdbc.password=passwordhibernate.dialect=org.hibernate.dialect.PostgreSQLDialect- Arquivo: /opt/pentaho/biserver-ce/tomcat/webapps/pentaho/META-INF/context.xmlAlterar de: factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="hibuser" password="password" driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/hibernate" validationQuery="select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES" /> factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="pentaho_user" password="password" driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/quartz" validationQuery="select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES"/> Para: factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="hibuser" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/hibernate" /> factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="pentaho_user" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/quartz" />- Arquivo: /opt/pentaho/biserver-ce/tomcat/conf/Catalina/localhost/pentaho.xmlRepita os mesmos procedimentos adotados no arquivo anterior (context.xml).- Arquivo: /opt/pentaho/biserver-ce/pentaho-solutions/system/quartz/quartz.propertiesNa linha 300, alterar de:org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegatePara:org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate- Arquivo: /opt/pentaho/biserver-ce/pentaho-solutions/system/hibernate/hibernate-settings.xmlAlterar de:system/hibernate/hsql.hibernate.cfg.xmlPara:system/hibernate/postgresql.hibernate.cfg.xml- Arquivo: /opt/pentaho/biserver-ce/pentaho-solutions/system/hibernate/postgresql.hibernate.cfg.xmlApenas confira as configuracoes:org.postgresql.Driverjdbc:postgresql://localhost:5432/hibernateorg.hibernate.dialect.PostgreSQLDialecthibuserpassword- Arquivo: /opt/pentaho/biserver-ce/pentaho-solutions/system/simple-jndi/jdbc.propertiesAlterar de:SampleData/type=javax.sql.DataSourceSampleData/driver=org.hsqldb.jdbcDriverSampleData/url=jdbc:hsqldb:hsql://localhost/sampledataSampleData/user=pentaho_userSampleData/password=passwordHibernate/type=javax.sql.DataSourceHibernate/driver=org.hsqldb.jdbcDriverHibernate/url=jdbc:hsqldb:hsql://localhost/hibernateHibernate/user=hibuserHibernate/password=passwordQuartz/type=javax.sql.DataSourceQuartz/driver=org.hsqldb.jdbcDriverQuartz/url=jdbc:hsqldb:hsql://localhost/quartzQuartz/user=pentaho_userQuartz/password=passwordShark/type=javax.sql.DataSourceShark/driver=org.hsqldb.jdbcDriverShark/url=jdbc:hsqldb:hsql://localhost/sharkShark/user=saShark/password=SampleDataAdmin/type=javax.sql.DataSourceSampleDataAdmin/driver=org.hsqldb.jdbcDriverSampleDataAdmin/url=jdbc:hsqldb:hsql://localhost/sampledataSampleDataAdmin/user=pentaho_adminSampleDataAdmin/password=passwordPara:SampleData/type=javax.sql.DataSourceSampleData/driver=org.hsqldb.jdbcDriverSampleData/url=jdbc:hsqldb:hsql://localhost/sampledataSampleData/user=pentaho_userSampleData/password=passwordHibernate/type=javax.sql.DataSourceHibernate/driver=org.postgresql.DriverHibernate/url=jdbc:postgresql://localhost:5432/hibernateHibernate/user=hibuserHibernate/password=passwordQuartz/type=javax.sql.DataSourceQuartz/driver=org.postgresql.DriverQuartz/url=jdbc:postgresql://localhost:5432/quartzQuartz/user=pentaho_userQuartz/password=passwordShark/type=javax.sql.DataSourceShark/driver=org.hsqldb.jdbcDriverShark/url=jdbc:hsqldb:hsql://localhost/sharkShark/user=saShark/password=SampleDataAdmin/type=javax.sql.DataSourceSampleDataAdmin/driver=org.hsqldb.jdbcDriverSampleDataAdmin/url=jdbc:hsqldb:hsql://localhost/sampledataSampleDataAdmin/user=pentaho_adminSampleDataAdmin/password=passwordOpcionalmente, poderao ser alterados nos arquivos, o usuario, senha e porta visando maior seguranca no ambiente, e ate mesmo a utilizacao de um SGDB em host