Pentaho部署文档校验过程中遇到的一些问题和解决对策
1、quartz.EmbeddedQuartzSystemListener发生错误
在./start-pentaho.sh启动BI平台服务器后,访问BI平台(http://192.168.1.227:8080)发生如下异常:
报错信息:
2015-01-27 14:17:08,865 ERROR [org.pentaho.platform.web.hsqldb.HsqlDatabaseStarterBean] HsqlDatabaseStarterBean.ERROR_0006 - The default port of 9001 is already in use. Do you already have HSQLDB running in another process? The HSQLDB Starter cannot continue. 2015-01-27 14:17:23,865 ERROR [org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener] EmbeddedQuartzSystemListener.ERROR_0007_SQLERROR org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (socket creation error) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ··································· 2015-01-27 14:17:23,867 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho 2015-01-27 14:17:23,867 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - 在试图执行启动sequenceorg.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener发生错误 org.pentaho.platform.api.engine.PentahoSystemException: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - 在试图执行启动sequenceorg.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener发生错误 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - 在试图执行启动sequenceorg.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener发生错误 Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - 在试图执行启动sequenceorg.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener发生错误 at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:399) ... 35 more 2015-01-27 14:17:23,868 ERROR [org.pentaho.platform.util.logging.Logger] Error end: |
异常原因:
此异常是因为端口冲突了:pentaho中某服务的端口9001被hadoop集群中某服务占用了。
临时解决方案:
停止hadoop集群,可成功访问BI平台。
2、缺乏数据库更换的相关文档
3、phpMyAdmin - 无法加载 mysql (外链,英语) 扩展,请检查您的 PHP 配置。 - 文档
报错信息:
访问phpMyAdmin时,报错:cannot load MySQL extension, please check PHP Configuration".
无法加载mysql(外链,英语)扩展,请检查您的php配置。
异常原因:
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.
Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.
解决方案:
yum install php-mysql(似乎未解决问题,但是最后意外在谷歌中可以访问http://192.168.1.227/phpmyadmin/了,另外也不知道操作成功是否和修改/etc/php.ini文件有关【我们在/etc/php.ini文件中,做了这样的修改:将display_errors = OFF设置为ON。】。)。
4、PHPmyadmin登录时用户名和密码
用户名:root
密码:123456
也就是mysql数据库的用户名和密码。
另外,附上安装PHPmyadmin的文档:http://blog.csdn.net/u010943460/article/details/42397187