Manage the Pentaho Server
The Pentaho Server has options that must be set manually, outside of the Administration page of the User Console. You can do any or all of these tasks depending on your needs.
Disable Home perspective widgets
Procedure
Shut down the Pentaho Server, if it is currently running.
If you have not deployed yet, navigate to the /pentaho-platform/user-console/source/org/pentaho/mantle/home/properties/config.properties file.
If you have manually deployed and want to hide widgets at a later time, navigate to the /pentaho-server/tomcat/webapps/pentaho/mantle/home/properties/config.properties file.
Find the line that starts with
disabled-widgets=
and type in the ID of the widget getting-started. You can also disable the Recents and Favorites widgets using the same method, as shown here. Save and close the file.disabled-widgets=getting-started,recents,favorites
Locate the /pentaho-server/tomcat/webapps/pentaho/mantle/home directory and open the index.jsp file with any text editor.
Find this line and comment it out, then save and close the file.
<script language='JavaScript' type='text/javascript' src='http://admin.brightcove.com/js/BrightcoveExperiences.js'></script>
Start the Pentaho Server and log in to the User Console.
Results
Turn autocomplete off for web app login screen
Procedure
Stop the Pentaho Server.
Navigate to the /pentaho-server/tomcat/webapps/pentaho/jsp directory and open the PUCLogin.jsp file with any text editor.
Find the following two sections of text and change the autocomplete entry to off, as shown:
<input id="j_username" name="j_username" type="text" placeholder="" autocomplete="off">
<input id="j_password" name="j_password" type="password" placeholder="" autocomplete="off">
Save and close the PUCLogin.jsp file.
Restart the Pentaho Server.
Results
Remove sample data from the Pentaho Server
Procedure
Stop the Pentaho Server.
Delete the samples.zip file from the /pentaho-server/pentaho-solutions/system/default-content directory.
If you performed a manual WAR build and deployment, then the file path is: /pentaho-server/pentaho-solutions/system.Edit the /pentaho/WEB-INF/web.xml file inside of the deployed pentaho.war.
As laid down by the Pentaho graphical installer and archive packages, this path should be /pentaho-server/tomcat/webapps/pentaho/WEB-INF/web.xml. If you performed a manual WAR build and deployment, then you must adjust the path to fit your configuration.Remove the
hsqldb-databases
section from the /pentaho/WEB-INF/web.xml file:<!-- [BEGIN HSQLDB DATABASES] --> <context-param> <param-name>hsqldb-databases</param-name> <param-value>sampledata@../../data/hsqldb/sampledata</param-value> </context-param> <!-- [END HSQLDB DATABASES] -->
Remove the
hsqldb-starter
section from the /pentaho/WEB-INF/web.xml file:<!-- [BEGIN HSQLDB STARTER] --> <listener> <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class> </listener> <!-- [END HSQLDB STARTER] -->
Remove the
SystemStatusFilter
:NoteThis is not part of the Pentaho samples; it provides error status messages that are only useful for development and testing purposes, and should be removed from a production system.<filter> <filter-name>SystemStatusFilter</filter-name> <filter-class>com.pentaho.ui.servlet.SystemStatusFilter</filter-class> <init-param> <param-name>initFailurePage</param-name> <param-value>InitFailure</param-value> <description>This page is displayed if the PentahoSystem fails to properly initialize.</description> </init-param> </filter>
Remove the filter mapping for the
SystemStatusFilter
:<filter-mapping> <filter-name>SystemStatusFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping>
Save and close the web.xml file.
Delete the /pentaho-server/data/ directory.
This directory does not exist if you installed Pentaho with the installation wizard. It contains a sample database, control scripts for that database, the environment settings it needs to run, and SQL scripts to initialize a new repository.Restart the Pentaho Server.
Log in to the Pentaho User Console with the administrator user name and password and go to the Browse Files page.
In the Folders pane, expand the Public folder and click to highlight the folder containing the Steel Wheels sample data. Click Move to Trash in the Folder Actions pane and confirm the deletion.
Highlight the folder containing the Pentaho Operations Mart sample data. Click Move to Trash in the Folder Actions pane and confirm the deletion.
Results
Enable JPivot in the User Console
Procedure
Stop the Pentaho Server.
Navigate to server/pentaho-server/pentaho-solutions/system/karaf/etc directory and open the plugin.xml file with any text editor.
Add pentaho-marketplace\ to the
featuresBoot
property.Save and close the file.
Delete the Karafe cache directory: server/pentaho-server/pentaho-solutions/system/karaf/caches.
Start the server.
The Marketplace perspective is activated in PUC.In the PUC console select and install the JPivot plugin.
A confirmation box opens informing you that the JPivot plugin was installed successfully.Download the jsf-api-1.1_02.jar file from https://repo1.maven.org/maven2/javax/faces/jsf-api/1.1_02/jsf-api-1.1_02.jar and place it in the server/pentaho-server/tomcat/webapps/pentaho/WEB-INF/lib directory.
CautionBe aware that a security vulnerability exists regarding the jsf-api-1.1_02.jar file. See https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-1285.Restart the server.
Results
Advanced topics
- Customize the Pentaho Server
You can change ports, directories, and other advanced settings.
- Set up a cluster
You can set up web app servers and Pentaho servers into nodes that make up clusters.