How to : Configure pentaho on jboss 4 ,5 or 6

Pentaho configration on jboss 

1. Download and unpack Download the necessary files from http://sourceforge.net/projects/pentaho/files
2. biserver-ce-3.9.zip(win) or tar (Linux)
3. biserver-manual-ce-3.9.zip(win) or tar (Linux)
4. download and install ant
5. set class path of ant in environment (windows)
6. set class path in Linux using .profile file

Unpack the zip/tar files.
after extracting you will get two directories: biserver-ce and biserver-manual-ce.

1. Build customized war file In order to build an war file that is customized for Jboss/MySQL, go to the biserver-manual-ce folder. Run "ant -p" to view the project help information. The build targets are shown. Build the JBoss/MySQL target without portal: "ant war-pentaho-jboss-mysql-no-portal". This results in the file build/pentaho-ears/jboss/no-portal/mysql5/pentaho.war.
2. download jboss-4.2.1.GA or 5.1
3. deploy pentaho.war file in deploy directory …\jboss4\jboss-4.2.1.GA\server\default\deploy
4. deoloy pentaho style war in deploy directoy (0ptional)
5. Download it from http://sourceforge.net/projects/pentaho/files)
6. copy pentaho-solution from manual deployment in ….\jboss-4.2.1.GA\
7. open web.xml from ….\jboss4\jboss-4.2.1.GA\server\default\deploy\pentaho.war\WEB-INF
8. edit line number 10 and put absolute path of solution folder
9. solutionpath should look like..
10. solution-path

….\jboss4\jboss-4.2.1.GA\biserver-ce\pentaho-solutions

1. Paste mysql jar file in

…..\jboss4\jboss-4.2.1.GA\lib 11.Create User in mysql database root identified by password password
12.And run all db script manually
13.Give execute permition to all file
14.Start jboss …..batch or shell (.bat or .sh)
15.Request http://localhost:8080/pentaho/Login from web browser
Detail configuration
Change databse and dialect in following files
1)hibernate-settings.xml …biserver-ce\pentaho-solutions\system\hibernate\hibernate-settings.xml
2)applicationContext-spring-security-hibernate.properties …. biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.properties
3)change in systemListeners.xml Comment versionCheckerSystemListener in pentaho-solutions\system\systemListeners.xml
mail me in case of any issue







Download DB script:
http://forums.pentaho.com/showthread.php?91682-pentaho-configration-on-jboss-4-or-5