Pentaho BI Server 安装过程简述

http://akbarahmed.com/2012/05/12/install-pentaho-bi-server-4-5-on-windows-7-x64/

http://stackoverflow.com/questions/24357241/how-do-i-install-pentaho-bi-ce-on-windows

? ? ? ? 为了安装这个东西，可真是折腾坏了我，前前后后好几天，终于今天安装成功了，今天把安装过程简单说一下，强调一下其中遇到的问题，希望可以帮助后来的小伙伴。

? ? ? ? 其实安装还是很简单的，首先在Pentaho的官方位置下载社区版的server，下载了之后，解压到一个文件夹就可以了，之后需要安装JDK，小伙伴注意了，这是个坑啊，java8是不支持的，所以需要安装java7才可以，然后就是配置环境变量PATH,JAVA_HOME,PENTAHO_HAVA_HOME,都需要配置，之后，可以在DOS下面测试一下：java -version,如果可以看到java版本，并且和你指定的路径是一样的，就是安装好了。具体的安装步骤可以查看上面列出的参考资料，同时将资料粘贴如下。

--------------------------------------------------------------------------------------------------------------------------------

Install Java

Your steps may vary slightly as I had an older version of the JDK installed. However,the gist is “just click Next till your done”.

1. Download the Java JDK fromhttp://www.oracle.com/technetwork/java/javase/downloads/index.html.
2. After downloading,double-click the installer,which will be named something like: (the name of your file may vary depending on which version you have downloaded)
3. Click?Next.
4. Click?Next. Wait for the installation to finish.
5. Click?Next. Wait for the JRE installation to finish.
6. Click?Continue.
7. Click?Next?to start the JavaFX SDK Setup.
8. Click?Next.
9. Click?Close.

Add Java to your PATH

You should now have the Java SDK installed into something like (your exact path may vary based on the version):

C:Program FilesJavajdk1.7.0_04bin

1. Click?Start.
2. Right-click on?Computer,click?Properties.
3. In the left pane,click?Advanced system settings.
4. Select the?Advanced?tab,then click?Environment Variables…
5. In?System Variables,?scroll till you find?Path.
6. Select?Path,click?Edit…
7. Add the Java bin folder to? your path by appending?;C:Program FilesJavajdk1.7.0_04bin?to the end of the Path?Variable Value.
8. Click?OK.
9. Click?New…
10. In?Variable name,enter: PENTAHO_JAVA_HOME
11. In?Variable value,enter: C:Program FilesJavajdk1.7.0_04
12. Click?OK.
13. Click?OK.
14. Click?OK.

As last step check that your path is set correctly.

1. Open Powershell.
2. Type?java -version.
3. Then type?javac -version.
4. For each command above,you should see the correct Java version? (for me its 1.7.0_04)
5. Open a command prompt.
6. Type?echo %PENTAHO_JAVA_HOME%
7. You should see the following as output: C:Program FilesJavajdk1.7.0_04

Note:

If you want to show the value of PENTAHO_JAVA_HOME in PowerShell,then enter:

Get-Childitem env:PENTAHO_JAVA_HOME

Note:

I had to reboot to get this to work.

Install Pentaho BI Server

Now that we have Java installed we can get on with our main task of installing the Pentaho BI Server.

1. Download the Pentaho BI Server fromhttp://wiki.pentaho.com/display/COM/Latest+Stable+Builds. I’m using the current stable build which is?biserver-ce-4.5.0-stable.zip.
2. Open Windows Explorer and create new folder:?C:Program FilesPentaho.
3. Unzip?biserver-ce-4.5.0-stable.zip.
4. Next,copy the?biserver-ce?and?administration-console?folder into?C:Program FilesPentaho.

Update the Permissions to allow the server to be run as a developer’s regular user (i.e. not Administrator)

1. In Windows Explorer,navigate to?C:Program Files.
2. Right-click the?Pentaho?folder,click?Properties.
3. Select the?Security?tab,click?Edit.
4. Click?Add.
5. Enter the developer’s username,then click?OK.
6. In the?Allow?column,check?Full control.
7. Click?OK.
8. Click?OK.

Start the Pentaho Server

I am not going to cover automatic startup of the Pentaho Server on Windows because my assumption is that some developers choose to run Pentaho on Windows,but that product deployments

1. Open Windows Explorer to?C:Program FilesPentahobiserver-ce.
2. Double-click?start-pentaho.bat.
3. If the?Windows Security Alert?dialog box pops up,then click?Allow access.

Hint:

I recommend that you resize the command window that displays the Tomcat messages. This will make it easier to read messages that are output by Tomcat.

• In the top left corner of the Window,click the Java icon.
• Click Properties.
• Select the Layout tab.
• Set the?Width?= 120
• Set the?Height?= 45
• Click?OK.

Login to the Pentaho User Console

1. Open a web browser to?http://localhost:8080.
2. Click?Evaluation Login?and select a user type to login as.

Login to the Pentaho Administration Console

1. Open Windows Explorer to?C:Program FilesPentahoadministration-console.
2. Double-click?start-pac.bat.
3. Open a web browser to?http://localhost:8099.
4. Enter a?User Name?of?admin.
5. Enter a?Password?of?password.
6. Click?Log In.

That’s it. The core Pentaho BI server is installed and ready for development. However,a good next step is to change the database that Pentaho uses,but we’ll leave that for another post.

------------------------------------------------------------------------------------------------------------------------------------------

There are 3 things you have to take care of:

1. When running on windows,it is easy to run into Windows' path-length limitation. This then will break the jar-loading which in return gives you random errors as the Tomcat server cannot find the classes contained in these jars. So when you install,do not install it deep into a directory,keep it at the root of your disk. From hard experience,I now always install it in DRIVE:Pentaho

2. The Server will not run without the system database. If your logs show you a Quartz-Error,or a Hibernate error,then your HSQL database is not running. In the download,you'll find a "data" directory. Start the "start-hypersonic.bat" before you start the main Pentaho server.

3. Pentaho does not run with Java 8. There seem to be some incompatible changes in the JDK and I have not been able to actually start it up correctly. You have to use JDK 1.7 to be successful. ALso make sure that your JAVA_HOME or PENTAHO_JAVA_HOME points to the correct JDK.

   The Pentaho bat files try to locate a Java installation automatically,and without explicitly setting these environment variables,any JDK may be picked up at random. Usually that is the last JDK that has been installed or updated. So to be safe,lock down the JDK by setting these variables (via Control Panel-> System -> Advanced System Settings -> Environment Variables)