本文主要介绍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架构师必看的立场,转载请标明来源出处