Yet another post



  • Java -

cd ~/dwnl
wget -O
chmod +x
sudo ./
sudo apt-cache search sun
sudo apt-get install sun-java6-jdk

sudo update-alternatives --config java
mv biserver-ce-3.10.0-stable.tar.gz? biserver-ce-3.10.0-stable.tar.gz
gunzip biserver-ce-3.10.0-stable.tar.gz 
mkdir pentaho
cp biserver-ce-3.10.0-stable.tar pentaho/
cd pentaho
tar -xf biserver-ce-3.10.0-stable.tar 

rm biserver-ce-3.10.0-stable.tar

mv pentaho /opt/

root@ec2-46-137-54-126:~/dwnl/pentaho/biserver-ce# java -version
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.10) (6b20-1.9.10-0ubuntu1~10.04.2)
OpenJDK Client VM (build 19.0-b09, mixed mode, sharing)

cd /opt/pentaho/biserver-ce/

sudo ./

root@ec2-46-137-54-126:/opt/pentaho/biserver-ce# sudo ./ 
WARNING: Using java from path
The Pentaho BI Platform now contains a version checker that will notify you
when newer versions of the software are available. The version checker is enabled by default.
For information on what the version checker does, why it is beneficial, and how it works see:
Press Enter to continue, or type cancel or Ctrl-C to prevent the server from starting.
You will only be prompted once with this question.
Using CATALINA_BASE:   /opt/pentaho/biserver-ce/tomcat
Using CATALINA_HOME:   /opt/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /opt/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME:        /usr
Using CLASSPATH:       /opt/pentaho/biserver-ce/tomcat/bin/bootstrap.jar

# change port in biserver-ce/tomcat/conf/server.xml

# open

cd ../administration-console/
root@ec2-46-137-54-126:/opt/pentaho/administration-console# sudo ./ 
WARNING: Using java from path
18:59:04,995 INFO  [JettyServer] Console is starting
18:59:05,047 INFO  [/] org.pentaho.pac.server.BrowserLocaleServlet-7668057: init
18:59:05,048 INFO  [/] org.pentaho.pac.server.DefaultConsoleServlet-22894293: init
18:59:05,048 INFO  [/] org.pentaho.pac.server.PacServiceImpl-13582581: init
18:59:05,048 INFO  [/] org.pentaho.pac.server.SchedulerServiceImpl-5298332: init
18:59:05,048 INFO  [/] org.pentaho.pac.server.SolutionRepositoryServiceImpl-22996593: init
18:59:05,048 INFO  [/] org.pentaho.pac.server.SubscriptionServiceImpl-12926414: init
18:59:05,048 INFO  [/] org.pentaho.pac.server.common.HibernateConfigurationServiceImpl-22710119: init
18:59:05,048 INFO  [/] org.pentaho.pac.server.common.JdbcDriverDiscoveryServiceImpl-8548382: init
18:59:05,078 INFO  [JettyServer] Console is now started. It can be accessed using or

# Edit security group on Scalrt role, open 8099
# open
# Login with admin/password

#= Setup datasource =


Login with admin/password

Chose Database connections -> +

Choose driver

URL: jdbc:mysql://localhost:3306/DATABASE_NAME

#= Development of reports =

Collabtive uses unix timestamps for dates:



Need to change the character set: SET SESSION CHARACTER_SET_RESULTS =latin1;

#= Change Admin password =

Change in Administration web interface

Does not work

java -cp administration-console/lib/jetty-6.1.9.jar:administration-console/lib/jetty-util-6.1.9.jar admin password1