pentaho8.1安装

本文主要介绍pentaho8.1的安装过程，重点介绍pentaho-server的安装。

针对pentaho在线上使用必须使用mysql作为数据源，我们本次就以mysql作为数据源。

下载地址：https://community.hitachivantara.com/docs/DOC-1009931-downloads

好，下面上货。

1、下载后有这些文件(能够直接解压缩执行，其中pentaho-server需要配置)

pentaho-server

pdi --pentaho data intergration

prd -- pentaho report desiginer

 

2、把pentaho-解压到/usr/local/petaho中

3、安装mysql（略）

4、修改pentaho的数据源到mysql，默认不是mysql的，需要修改。参考下面的文章（需要注意的是在创建表的时候尽量使用utf8）

https://help.pentaho.com/Documentation/8.1/Setup/Installation/Archive/MySQL_Repository

 

脚本位置（程序是通过压缩包解压后得到的）：

/usr/local/pentaho/pentaho-server/data/mysql5

需要注意的是创建三张表的时候需要把表的默认字符类型修改为utf8

 

5、注意需要修改文件pentaho-solutions/system/systemListener.xml(否则启动报错)

systemListener.xml

<!--<bean id="pooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener" />-->

<!--<bean id="nonPooledDataSourceSystemListener"

class="org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener"/>-->

<!--<bean id="dynamicallyPooledDataSourceSystemListener" class="org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener" />-->

 

6、使用命令启动

./start-pentaho.sh

 

7、查看tomcat/logs/pentaho.log是否有异常输出

例如输出如下：

*******************************************************************************

*** Karaf Instance Number: 1 at /usr/local/pentaho/pentaho-server/pentaho-s ***

*** olutions/system/karaf/caches/default/data-1 ***

*** Karaf Port:8802 ***

*** OSGI Service Port:9051 ***

*** JMX RMI Registry Port:11099 ***

*** RMI Server Port:44445 ***

*******************************************************************************

2018-11-03 18:02:17,682 DEBUG [org.pentaho.di.core.vfs.ConcurrentFileSystemManager] Using "/usr/local/pentaho/pentaho-server/tomcat/temp/vfs_cache" as temporary files store.

2018-11-03 18:02:17,738 DEBUG [org.pentaho.di.core.vfs.ConcurrentFileSystemManager] Skipping provider "org.apache.commons.vfs2.provider.webdav.WebdavFileProvider" because required class "org.apache.jackrabbit.webdav.client.methods.DavMethod" is not available.

2018-11-03 18:02:39,621 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.

2018-11-03 18:03:09,625 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.

2018-11-03 18:03:20,156 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] The system has finished initializing.

2018-11-03 18:03:20,158 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] The system has finished initializing.

 

然后我们访问

http://localhost:8080/pentaho

 

 

默认用户名密码为

用户名：admin

密码：password