pentaho8.1安装

2021-05-14 17:01:08 浏览数 (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

本文来源0day__,由javajgs_com转载发布,观点不代表Java架构师必看的立场,转载请标明来源出处

0 人点赞