Installazione di Pentaho Business Intelligence Server in Debian
Jump to navigation
Jump to search
Installazione Java
- Installare:
sudo apt-get install sun-java6-bin sun-java6-jre sun-java6-jdk
- Settare come default
sudo update-java-alternatives -s java-6-sun
- Verificare:
java -version
java version "1.6.0_26" Java(TM) SE Runtime Environment (build 1.6.0_26-b03) Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)
- Impostare JAVA_HOME:
echo "JAVA_HOME=/usr/lib/jvm/java-6-sun" | sudo tee -a /etc/environment
- Sloggarsi e riloggarsi,e verificare:
echo $JAVA_HOME
/usr/lib/jvm/java-6-sun
Installazione MySql
- Installare come da manuale
Installazione Pentaho
- Creare directory installazione, e scaricare:
sudo mkdir /opt/pentaho cd /opt/pentaho/ sudo wget "http://switch.dl.sourceforge.net/project/pentaho/Business%20Intelligence%20Server/3.10.0-stable/biserver-ce-3.10.0-stable.tar.gz
- VERIFICARE, SEMBRA NON NECESSARIO": Applicare il patch per Jpivot
sudo mv biserver-ce/tomcat/webapps/pentaho/WEB-INF/lib/jpivot-1.8.0-100420.jar biserver-ce/tomcat/webapps/pentaho/WEB-INF/lib/jpivot-1.8.0-100420.jar.bak sudo wget "http://www.stratebi.es/todobi/Ene12/jpivot-1.8.0-100420.jar" -O biserver-ce/tomcat/webapps/pentaho/WEB-INF/lib/jpivot-1.8.0-100420.jar
- Abilitare l'utilizzo HEADLESS per JFreeChart, aggiungendo "-Djava.awt.headless=true":
sudoedit /opt/pentaho/biserver-ce/start-pentaho.sh
export CATALINA_OPTS="-Xms256m -Xmx768m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djava.awt.headless=true"
- Se non lo si aggiunge, all'apertura di un report/analisi, si ottiene l'errore:
Could not initialize class org.jfree.chart.JFreeChart
- Avviare il server:
cd /opt/pentaho/biserver-ce sudo ./start-pentaho.sh
joe/password
- Se non funziona, vedere i logfiles:
/opt/pentaho/biserver-ce/tomcat/logs/pentaho.log /opt/pentaho/biserver-ce/tomcat/logs/catalina.out
- Per fermare il server
sudo ./stop-pentaho.sh
Riferimenti
- Complete Pentaho Installation on Ubuntu, Part 1 | Interesting IT Tip's
- Ubuntu Linux Install Sun Java Development Kit ( JDK ) and Java Runtime Environment ( JRE )
- Using Headless Mode in the Java SE Platform
- Pentaho BI configuration and tutorial
- Pentaho BI Server 3.5 - MySQL, PostgreSQL and Oracle for Windows & Linux Tutorial
- Analyse This - The Trials and Tribulations of an Australian Pentaho User
- Pentaho - Projects - Analyse This
- Pentaho 3.7.0 Linux and MySQL - Google Docs
- Pentaho | Interesting IT Tip's