... CATALINA_OPTS=-Dsun.jnu.encoding=UTF-8 -Dfile.encoding=UTF-8 -Xms... ...
... CATALINA_OPTS="-Dsun.jnu.encoding=UTF-8 -Dfile.encoding=UTF-8 -Xms... ...
cd biserver-ce-4.8.0/biserver-ce/tomcat/conf
sslProtocols="TLSv1, TLSv1.1, TLSv1.2"
<Connector port="443" protocol="HTTP/1.1" SSLEnabled="true"
maxThreads="150" scheme="https" secure="true"
sslProtocols="TLSv1, TLSv1.1, TLSv1.2"/>
<?xml version="1.0" encoding="UTF-8"?> <Context path="/pentaho" docbase="webapps/pentaho/"> <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="hibuser" password="password" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521/XE" validationQuery="select 1 from dual" /> <Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="quartz" password="password" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521/XE" validationQuery="select 1 from dual"/> </Context>
<!-- [BEGIN HSQLDB DATABASES] -->
<context-param>
<param-name>hsqldb-databases</param-name>
<param-value>sampledata@../../data/hsqldb/sampledata</param-value>
</context-param>
<!-- [END HSQLDB DATABASES] -->
<?xml version='1.0' encoding='utf-8'?>
<settings>
<!--config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file-->
<config-file>system/hibernate/oracle10g.hibernate.cfg.xml</config-file>
</settings>
jdbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521/XE jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
... <param name="tablespace" value="PENTAHO_TABLESPACE"/> ...
<property name="hibernate.c3p0.acquire_increment">3</property> <property name="hibernate.c3p0.idle_test_period">14400</property> <property name="hibernate.c3p0.max_size">75</property> <property name="hibernate.c3p0.max_statements">0</property> <property name="hibernate.c3p0.timeout">25200</property> <property name="hibernate.c3p0.preferredTestQuery">select 1</property> <property name="hibernate.c3p0.testConnectionOnCheckout">true</property>
bash ctools-installer.sh -s /cygdrive/c/pentaho/biserver-ce-X.X.X/biserver-ce/pentaho-solutions -w /cygdrive/c/pentaho/biserver-ce-X.X.X/biserver-ce/tomcat/webapps/pentahoNOTA: en Cygwin las unidades de disco duro se representan como /cygdrive/letraUnidad, por ejemplo para el comando anterior /cygdrive/c/... hace referencia a c:\...
bash ctools-installer.sh -s /usr/pentaho/biserver-ce-X.X.X/biserver-ce/pentaho-solutions -w /usr/pentaho/biserver-ce-X.X.X/biserver-ce/tomcat/webapps/pentaho
java.lang.NoClassDefFoundError: org/apache/fop/configuration/Configuration com.tonbeller.jpivot.print.PrintServlet.init(PrintServlet.java:71) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) java.lang.Thread.run(Thread.java:662)
org.pentaho.reporting.libraries.resourceloader.ResourceCreationException: Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=layout.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@1c1d051, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=::Include-parser}=true, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=::Report}=org.pentaho.reporting.engine.classic.core.MasterReport={name="Graficos", type="master-report"}, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@1f864b, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=property-expansion}=false}, parent=ResourceKey{schema=pentaho, identifier=curso-bi-pentaho/ReporteGraficos.prpt, factoryParameters={}, parent=null}}
org.pentaho.reporting.libraries.xmlns.parser.ParseException: Unable to assign property 'categoricalAxisMessageFormat' to expression 'null' [Location: Line=56 Column=73]
<!-- ... -->
<property name="chartWidth">0</property>
<!--property name="categoricalAxisMessageFormat">{0}</property-->
<property name="rangeMaximum">1.0</property>
<!-- ... -->
|
Web Ad Hoc Query and Reporting has been replaced by the new Interactive Reporting client. It is provided as a convenience but will no longer be enhanced or offically supported by Pentaho. |
|
|
JPivot has been replaced by Pentaho Analyzer. It is provided as a convenience but will no longer be enhanced or offically supported by Pentaho. |
<!--<td valign="middle" id="waqrDeprecatedAlert" style="padding-right: 5px">
<table width="580px" style="background-color: #fffdd5; border-style: solid; border-color: #dcb114; border-width= 1px; font: normal .85em Tahoma, 'Trebuchet MS', Arial">
<tr>
<td>
<img src="images/warning.png"/>
</td>
<td>
Web Ad Hoc Query and Reporting has been replaced by the new Interactive Reporting client.<br/>
It is provided as a convenience but will no longer be enhanced or offically supported by Pentaho.
</td>
</tr>
</table>
</td>-->
<!--<div id="deprecatedWarning" style="margin: auto; width: 100%">
<table width="580px" align="center" style="background-color: #fffdd5; border-style: solid; border-color: #dcb114; border-width= 1px; font: normal .85em Tahoma, 'Trebuchet MS', Arial">
<tr>
<td>
<img src="./jpivot/navi/warning.png"/>
</td>
<td>
JPivot has been replaced by Pentaho Analyzer.<br/>
It is provided as a convenience but will no longer be enhanced or offically supported by Pentaho.
</td>
</tr>
</table>
</div>-->
#deprecatedWarning {
display: none;
}
<?xml version="1.0"?> <publisher-config> <publisher-password>password</publisher-password> </publisher-config>
<email-smtp>
<properties>
<!-- This is the address of your SMTP email server for sending email. e.g. smtp.pentaho.org -->
<mail.smtp.host>smtp.gmail.com</mail.smtp.host>
<!-- This is the port of your SMTP email server. Usually this is 25. For GMail this is 587 -->
<mail.smtp.port>587</mail.smtp.port>
<!-- The transport for accessing the email server. Usually this is smtp. For GMail this is smtps -->
<mail.transport.protocol>smtps</mail.transport.protocol>
<!-- Usually this is 'false'. For GMail it is 'true' -->
<mail.smtp.starttls.enable>true</mail.smtp.starttls.enable>
<!-- Set to true if the email server requires the sender to authenticate -->
<mail.smtp.auth>true</mail.smtp.auth>
<!-- This is true if the email server requires an SSL connection. Usally 'false'. For GMail this is 'true' -->
<mail.smtp.ssl>true</mail.smtp.ssl>
<!-- Run Email Send Test -->
<mail.run.send.test>true</mail.run.send.test>
<!-- For GMail this is 'false' -->
<mail.smtp.quitwait>false</mail.smtp.quitwait>
</properties>
<!-- The is the address or your POP3 email server for receiving email. e.g. pop.pentaho.org -->
<!-- It is currently not used -->
<mail.pop3></mail.pop3>
<!-- This is the default 'from' address that emails from the Pentaho BI Platform will appear to come from e.g. joe.pentaho@pentaho.org -->
<mail.from.default>ingmmurillo.capacitacion@gmail.com</mail.from.default>
<!-- This is the user id used to connect to the email server for sending email
It is only required if email-authenticate is set to true
This is never sent or shown to anyone -->
<mail.userid>ingmmurillo.capacitacion</mail.userid>
<!-- This is the password used to connect to the email server for sending email
It is only required if email-authenticate is set to true
This is never sent or shown to anyone -->
<mail.password>........</mail.password>
</email-smtp>
\i create_repository_postgresql.sql password \i create_sample_datasource_postgresql.sql \connect postgres postgres sa \i create_quartz_postgresql.sql password
<?xml version="1.0" encoding="UTF-8"?> <Context path="/pentaho" docbase="webapps/pentaho/"> <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="hibuser" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://127.0.0.1:5432/hibernate" validationQuery="select version();" /> <Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="pentaho_user" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://127.0.0.1:5432/quartz" validationQuery="select version();"/> </Context>
<?xml version='1.0' encoding='utf-8'?>
<settings>
<!--config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file-->
<config-file>system/hibernate/postgresql.hibernate.cfg.xml</config-file>
<managed>false</managed>
</settings>
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springsource.org/dtd/spring-beans.dtd"> <beans> <!--...--> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="org.postgresql.Driver" /> <property name="url" value="jdbc:postgresql://127.0.0.1:5432/hibernate" /> <property name="username" value="hibuser" /> <property name="password" value="password" /> </bean> <!--...--> </beans>
jdbc.driver=org.postgresql.Driver jdbc.url=jdbc:postgresql://127.0.0.1:5432/hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect