Easy Pentaho-Websynergy (Liferay+Glassfish) Integration in Solaris 10

Content

1 Installing Mysql 5
2 Directory Structure
3 Installing Ant
4 Websynergy installation
5 Generating pentaho war for glassfish
6 Creating pentaho datasources in glassfish
7 Getting Pentaho & Liferay up and running Glasfish

1 Mysql 5 Installation


Follow the following Step: Easy Way
Here are the steps:
1. Install the Solaris 10 OS, Solaris Express/Nevada, or OpenSolaris.
2. Make sure your system is networked so that it can reach the Internet and is using a static IP
address. If you need assistance with network configuration, review this documentation: System
Administration Guide: IP Services.
3. Install pkg-get (for that you must need Internet Connection)

To do much of anything you will need pkg-get on your system. Thanks to a few new features in the
pkgadd command you can do this directly from the Blastwave.org site with no need for fancy footwork.
Simply do the following :
# pkgadd -d http://blastwave.network.com/csw/pkg_get.pkg

1. 1. Downloading... ..............25%..............50%..............75%..............100%
      

## Download Complete The following packages are available:

1 CSWpkgget pkg_get - CSW version of automated package download tool (all) 3.8.4 Select package(s)
you wish to process (or 'all' to process all packages). (default: all) ?,??,q:

Processing package instance from pkg_get - CSW
version of automated package download tool(all) 3.8.4 You may use and copy this software without
charge, as you see fit. The software is copyright (C) Philip Brown, Nov 2000-2007 Dont forget to
update /opt/csw/etc/pkg-get.conf with your nearest archive site. (or /etc/opt/csw/pkg-get.conf) The
default site ibiblio.org may or may not be slow for you!

The selected base directory must exist before installation is attempted.
Do you want this directory created now y,n,?,q y

Using as the package base directory.

1. 1. Processing package information.
      ## Processing system information. WARNING: setting mode of to default mode (755)
      WARNING: setting mode of to default mode (755) WARNING: setting mode of /share> to default mode (755) WARNING: setting mode of to default mode (755)
      WARNING: setting mode of to default mode (755) 1 package pathname is
      already properly installed.
      
   2. Verifying disk space requirements.
      

## Checking for conflicts with packages already installed.

1. 1. Checking for setuid/setgid programs. This package contains scripts which will be
      

executed with super-user permission during the process of installing this package. Do you want to
continue with the installation of y,n,? y

Installing pkg_get - CSW version of automated package download tool as
## Installing part 1 of 1. /opt/csw/bin/pkg-get /opt/csw/etc/pkg-get.conf.csw /opt/csw/share/man/man1m
/pkg-get.1m /var/pkg-get/admin-fullauto verifying class
## Executing postinstall script. Installing /opt/csw/etc/pkg-get.conf.csw to pkg-get.conf ****
IMPORTANT **** A default configuration file for pkg-get has been created in /opt/csw/etc/pkg-
get.conf You should edit it to change the 'site' configuration, to point to the most
appropriate mirror for you, from the list at http://www.blastwave.org/mirrors

Installation of was successful. #.
4. We are now ready to install MySQL 5 packages. From a console or xterm window, log in as root and
issue these commands:
# /opt/csw/bin/pkg-get -i mysql5 mysql5client mysql5devel mysql5rt
# /opt/csw/bin/pkg-get -i mysql5test
5. Now let's set up MySQL 5.
A. Create the config file /opt/csw/mysql5/my.cnf, as follows:
Copy one of the my-*.cnf files in /opt/csw/mysql5/share/mysql/ to /opt/csw/mysql5/my.cnf and make any
changes appropriate for your environment, such as enabling InnoDB.
Note that /opt/csw/mysql5/var is a deprecated location for my.cnf. If you are not sure which file to
copy, use my-small.cnf.
B. It is important to set up a MySQL user and group before initializing the database in the next step.
This is done for you by the Blastwave package install script. However, if you are building
MySQL from source, you will need to create a MySQL user and group as follows:
# groupadd mysql
# useradd -c "MySQL Server" -d /dev/null -g mysql -s /bin/false mysql
C. Initialize the MySQL database and fix the permissions:
#cd /opt/csw/mysql5
#./bin/mysql_install_db

chown -R mysql:mysql ./var
Caution: If you skip the chown step above, MySQL will refuse to start.
D. Start MySQL 5. To simply attempt to start the server and see if the above steps were done
correctly, you can issue this command:
# cd /opt/csw/mysql5 ;
# ./mysqld_safe &
E. Please remember to set a password for the MySQL root user!
This should not be the same as your Solaris root user password! To do so, start the server, then issue
the following commands:
To set the local password:
# /opt/csw/mysql5/bin/mysqladmin -u root password 'new-password'
# /opt/csw/mysql5/bin/mysqladmin -u root -h \
password 'new-password'
F. Now login to mysql
# /opt/csw/mysql5/bin/ ./mysql –uroot –p’new-password’

G. To stop mysql server

#pkill mysql

2. The basic structure of Total Project as follows:

-->commonneed (you can give any name)

This is home directory for the project.

-->--> pentaho-solution

Directory contains All the Business Intelligence report.
The basic structure of pentaho-solution directory as follows:

Here the directory contains all the pentaho report.
You can download pentaho-solution from the following link:

http://jaist.dl.sourceforge.net/sourceforge/pentaho/pentaho_solutions-1.6.0.GA.863.zip

-->-->pentaho-bi-dev

The directory ‘pentaho—bi-dev’ contains all the required resources to build the pentaho war for
glassfish.
The directory also contains three other directory as follows:

pentaho-preconfiguredinstall

The directory contains the required porlet jar which needed to build pentaho war file.

To found pentaho-preconfiguredinstall click the following link:

http://nchc.dl.sourceforge.net/sourceforge/pentaho/pentaho_demo_mysql5-1.6.0.GA.863.zip

Pentaho_j2ee_deployments_1.6.0.GA.863-a

The directory ‘pentaho_j2ee_deployments-1.6.0.GA.863-a’ contains all pentaho deployment directory for
building pentaho.

The directory structure:

The directory also contains build.xml file which not shown and when you run the build.xml file then build directory will be created.

The directory contains many others directories that contains resources like jar,classes and others to
build pentaho war file.Here you need to care about two directory 1. pentaho-res and 2. pentaho-
webapp.

pentaho-res>orion>contains a xml file name ‘glassfish-pentaho-ds.xml’ , which contain s jdbc
datasource history . Here your connection pool is plugjamReporting.

pentaho-res>hibernate>mysql>hibernate-cfg.xml , this describe the mysql5 database configuration
history like database user, user password ,connection port.

Pentaho-webapp>WEB-INF>web.xml ,this describe pentaho web configuration summary.You need to change
your server ip address in this file.

To found Pentaho_j2ee_deployments_1.6.0.GA.863-a click the following link:

http://jaist.dl.sourceforge.net/sourceforge/pentaho/pentaho_j2ee_deployments-1.6.0.GA.863-a.zip

Scripts

Scripts>database , contains all required database scripts

-->-->Glassfish

This contains glassfish application server and liferay , also known as websynergy.
You can download websynergy from the following link:

http://download.java.net/portalserver/WebSynergy1.0/CB5/websynergy-gfv2-sunos-x86.jar

3 Ant Installation

download site :

http://mirrors.bdnic.net/apache/ant/binaries/apache-ant-1.7.1-bin.zip
Apache Ant is a software tool for automating software build processes. Ant uses XML to describe the
build process and its dependencies, whereas make has its Makefile format. By default the XML file is
named build.xml. In the plugjam project Ant is required for build the pentaho for deployment into the Liferay and also
need to run setup.xml(After installation of Websynergy).

After Unzip, the Ant it consists of the following directory layout:

Go to commonneed>glassfish and unzip ant using the following command

Commonneed/glassfish# unzip apache-antdirectory/apache-ant-1.7.1-bin.zip


4 Websynergy installation

Inside the glassfish directory install the websynergy. Using the following step

Go to /commonneed/glassfish directory where already have apache-ant-1.7 directory

• run the Websynergy jar using the following command
  

#java –Xmx256m –jar Websynergy.jar

example:

#java –Xmx256m –jar /home/soft/ Websynergy.jar

After this command the jar will be run and the following screen will be appear at the monitor where
accept button is not working. By going the end of license agreement the accept button will be enable
and then click the accept button.

Then the installation process will complete automatically.

Then change directory using the command

#Cd glassfish

the current path is now commonneed/glassfish/glasfish

run the command ‘../ant/bin/ant –f setup.xml’

run the command ./bin/asadmin start-domain
Wait for 1min for glassfish and liferay to initialize.

Browse the E:\commonneed\plugjam\glassfish\glassfish\domains\domain1\config\domain.xml and change line
245 and 246 as follows
-Xms512M
-Xmx512M
because sometimes the operating system does not give 1G space to JVM.


5 Generating a Pentaho war for Glassfish
Download the pentaho_j2ee_deployments-1.6.0.GA.863-a which already mention in the commonneed
structure. Browse the following directory

Commonneed/pentaho-bi-dev/pentaho_j2ee_deployments-1.6.0.GA.863-a

and run the command

#../../glassfish/ant/bin/ant war-pentaho-tomcat-mysql

the pentaho war for glassfish will be created in the following directory

commonneed\pentaho-bi-dev\pentaho_j2ee_deployments-1.6.0.GA.863-a\build\pentaho-wars\tomcat\mysql5

6 Creating Pentaho Datasources in Glassfish

The datasources xml file is located in the following directory:

Commonneed\pentaho-bi-dev\pentaho_j2ee_deployments-1.6.0.GA.863-a\pentaho-res\orion

Now we need to add the glassfish-pentaho-ds.xml file into glassfish using the following command

Commonneed/glassfish/glassfish/bin#./asadmin add-resources commoneed/pentaho-bi-dev/pentaho-
j2ee-deployment/pentaho-res/orion/glassfish-pentaho-ds.xml

**** the glassfish server must need started for the above command if not then use the command asadmin
start-domain then apply the command

for generating the command first we need to browse glassfish/bin directory using command.

example:

glassfish/bin#./asadmin add-resources commonneed\pentaho-bi-dev\pentaho_j2ee_deployments-1.6.0.GA.863- a\pentaho-res\orion\ glassfish-pentaho-ds.xml

7 Getting Pentaho & Liferay up and running in Glassfish

1. Copy pentaho-style.war and sw-style.war into autodeploy directory of glassfish which is located commonneed\glassfish\glassfish\domains\domain1\autodeploy
2. start glassfish on a already setup domain using the command ./asadmin start-domain (the asadmin command located in glassfish/bin directory)
3. open browser and browse http://localhost:8080

4. login to liferay using test@liferay.com/ and password using ‘test’
5. add the Plugin Installer portlet by clicking add application>admin>plugin install >upload and
browse from pentaho_j2ee_deployments-1.6.0.GA.863-a\build\pentaho-wars\tomcat\mysql5 and give a name
and click install

6. Once you do that it will deploy the war and this time it will be successful.
7. stop the glassfish application server using command asdmin stop-domain and start server using
asadmin start-domain command.
8. Login to Liferay and now you will be able to see the pentaho portlet category.

9. click pentaho & click add it will generate new portlet and enjoy.