Added by Marc Batchelor, last edited by Fábio de Salles on Apr 11, 2008  (view change) show comment

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

The Pre-Configured Install is designed to run standalone on a single machine using http://localhost:8080/pentaho as the base URL. If you do not need access to the server from other computers, you can skip the "Running as a server" step.

Running as a server

Modify web.xml

To allow other computers to access the Pentaho BI Platform, the base URL must be set in the web.xml file

  1. Locate the web.xml file, its default location is: pentaho-demo/jboss/server/default/deploy/pentaho.war/WEB-INF
  2. Open web.xml in an XML or text editor.
  3. Set the param-value of the context parameter base-url with the URL for the server. The URL should have the DNS Name or IP address of the machine, the port default 8080 and the context pentaho. If you want to change the port that the server uses, see the Advanced Install Guide.

The final result should look like:

<context-param>
  <param-name>base-url</param-name>
  <param-value>http://myserver.pentaho.org:8080/pentaho</param-value>
</context-param>

Modify start-pentaho.(bat|sh)

Beginning with Pentaho BI Server 1.6-RC2 and later, an extra step is required in order to access the server from other hosts. Set the JBoss bind address by editing start-pentaho.(bat|sh). Add the -b parameter. More documentation for this parameter can be found on the JBoss wiki.

start-pentaho.bat included with zip

@echo on
setlocal
set PENTAHO_PATH=%~dp0
set JAVA_HOME=%PENTAHO_PATH%jre
set PATH=%PENTAHO_PATH%jre\bin;%PATH%;
cd jboss\bin
start run -b myserver.pentaho.org < lines.txt

start-pentaho.sh included with gz

#!/bin/sh
cd jboss/bin
sh run.sh -b myserver.pentaho.org

start-pentaho.bat included with exe installer

@echo "C:\pentaho\bi-server\jboss\bin\run.bat" -b myserver.pentaho.org ^< lines.txt > "C:\pentaho\bi-server\jboss\bin\wrapper.bat"

Or you could also add the -D parameter: in the above snippets, replace the "-b myserver.pentaho.org" for "-Djboss.bind.address=YOUR.IP.GOES.HERE". This will change JBoss binding address and you will need to edit only web.xml to point to the same IP. However, this is a quick & dirty fix, for it breaks the shutdown scripts. As you can simply kill the server, it might help when a fast fix is needed to help things get going.

Modify stop-pentaho.(bat|sh)

If you added the -b parameter to start-pentaho.(bat|sh), you'll also need to make the following modification to stop-pentaho.(bat|sh).

stop-pentaho.bat

@echo on
cd data
start stop_hypersonic.bat
cd ..\jboss\bin
shutdown -S -s myserver.pentaho.org< lines.txt
exit

stop-pentaho.sh

cd data
./stop_hypersonic.sh &
cd ../jboss/bin
./shutdown.sh -S -s myserver.pentaho.org

Thanks a lot !

 How to modify start-pentaho.(bat|sh) helps me to solve my problem. I didn't know this new step before reading your post.

 I'm sure it will help a lot of people

Comment: Posted by Michaël Duran at Oct 03, 2007 11:01

Thanks... for this tip

Comment: Posted by Anonymous at Oct 11, 2007 02:10

Thanks a lot..

Comment: Posted by gangadhara at Oct 11, 2007 02:11

Now I am able to access the server remotely but when I try to stop it with stop-pentaho.sh I am getting Exceptions and the server is not stopping. Do I need to modify stop-pentaho.sh as well?

Thanks!

Comment: Posted by Anonymous at Oct 24, 2007 14:49

I found one answer on my previous question about required modifications at stop-pentaho.sh.

./shutdown.sh -S -s <server IP Address or name>

Is this the correct way?

Thanks!

Comment: Posted by Anonymous at Oct 24, 2007 15:00

The -s parameter has been added to the documentation. Thank you.

Comment: Posted by Mat Lowery at Oct 25, 2007 09:32

The start-pentaho.bat file that ships with the windows installer looks nothing like the abovesample.  Can someone update this information?

It calls several other files based on the parameters supplied.  I assume that this is because the installer created a windows service?

Comment: Posted by Andrew Grohe at Nov 19, 2007 18:03

sd

Comment: Posted by Anonymous at Dec 02, 2007 12:58

Can anyone explain what to change in in the latest version of start/stop pentaho.bat ? thanks.

Comment: Posted by Anonymous at Dec 04, 2007 11:03

I have modified the web.xml without any problem, but the start-pentaho.bat that I have is completely different than the one here. Could anyone please update this? What should I do to be able to access to the pentaho server remotely?

Comment: Posted by Anonymous at Dec 06, 2007 09:46

Could someone update this with the latest version because it looks totally different from above.

Thanks.

Comment: Posted by Anonymous at Dec 14, 2007 07:21

Yes, the latest version of pentaho is different from the above stated files.

I just replaced all my start/stop bat/sh files with the above corresponding codes and with a few changes ...

web.xml   <context-param>

           <param-name>base-url</param-name>

           <param-value>http://systemname:8080/pentaho</param-value>

   </context-param> start-pentaho.bat

@echo on
setlocal
set PENTAHO_PATH=%~dp0
set JAVA_HOME=%PENTAHO_PATH%jre
set PATH=%PENTAHO_PATH%jre\bin;%PATH%;
cd jboss\bin
start run -b systemname < lines.txt

start-pentaho.sh

#!/bin/sh
cd jboss/bin
sh run.sh -b systemname

stop-pentaho.bat

@echo on
cd data
start stop_hypersonic.bat
cd ..\jboss\bin
shutdown -S -s systemname< lines.txt
exit

stop-pentaho.sh

cd data
./stop_hypersonic.sh &
cd ../jboss/bin
./shutdown.sh -S -s systemname



Comment: Posted by Anonymous at Dec 26, 2007 01:23

This configuration doesnt work at all with 1.6 GA Pentaho BI Suite.

Comment: Posted by Anonymous at Jan 16, 2008 03:00

Agreed, this documentation is horribly outdated (as is much of the other documentation in the BI suite.) This small issue is keeping us from deploying ANY of our new reports, so it would be great if someone could get to updating these things.

Comment: Posted by Anonymous at Jan 18, 2008 19:13

Agreed, this documentation is horribly outdated (as is much of the other documentation in the BI suite.) This small issue is keeping us from deploying ANY of our new reports, so it would be great if someone could get to updating these things.

Comment: Posted by Anonymous at Jan 18, 2008 19:15

QuotedThanks a lot !

 How to modify start-pentaho.(bat|sh) helps me to solve my problem. I didn't know this new step before reading your post.

 I'm sure it will help a lot of people

This is your solution, I've just read it and I believe it could work, I'll test it today :

http://forums.pentaho.org/showpost.php?p=177005&postcount=7

Good luck !

Comment: Posted by Michaël Duran at Jan 22, 2008 13:04 Updated by Michaël Duran

the start-pentaho.bat included with exe installer
@echo "C:\pentaho\bi-server\jboss\bin\run.bat" -b myserver.pentaho.org ^< lines.txt > "C:\pentaho\bi-server\jboss\bin\wrapper.bat"
is not working for me. I still cant make pentaho run as server.

 Am I the only one having this problem???

With the version pentaho_demo_hsqldb-1.6.0-RC2.820, I just change the web.xml file and the start-pentaho.bat as described here, and works PERFECTLY, no problems! but the one with the EXE installer has been a NIGHTMARE for me for months!  

Comment: Posted by Anonymous at Feb 21, 2008 08:43

surely <lines.txt is not correct the > must be going the wrong way if its for logging purposes.

Comment: Posted by Anonymous at Feb 28, 2008 16:30

I have the same problem and I solve it. Open server.xml in pentaho\bi-server\jboss\server\default\deploy\jboss-web.deployer  . There is a line <Connector port="8080" address=..... Change it to <Connector port="8080" address="your.ip".........

Comment: Posted by Ivan Georgiev at Mar 14, 2008 13:00

Thank you Ivan. Modifying server.xml solved my problem accessing pentaho as server.

Comment: Posted by Anonymous at Apr 16, 2008 09:33

Existing feature request for a configuration tool: http://jira.pentaho.com/browse/BISERVER-206

Comment: Posted by Scot E. Wilcoxon at Jun 03, 2008 17:41

The lines.txt redirection isn't for output, it is for input. It's providing carriage-returns to the process so you don't have to "Press Any Key To Continue".

Comment: Posted by Marc Batchelor at Jul 08, 2008 10:38

I have modify the files as describe :

  • Pentaho\bi-server\jboss\server\default\deploy\pentaho.war\WEB-INF\web.xml :
    <context-param>
        <param-name>base-url</param-name>
        <param-value>http://tmgbkp02:8080/pentaho/</param-value>
      </context-param>
    
  • Pentaho\start-pentaho.bat :
    @echo "F:\Pentaho\bi-server\jboss\bin\run.bat" -b tmgbkp02 ^< lines.txt > "F:\Pentaho\bi-server\jboss\bin\wrapper.bat"
    
  • Pentaho\stop-pentaho.bat :
    @echo "F:\Pentaho\bi-server\jboss\bin\shutdown.bat" -s tmgbkp02 -H0 ^< lines.txt > "F:\Pentaho\bi-server\jboss\bin\wrapper.bat"
    

At this point the web server doesn't respond on the http://tmgbkp02:8080 URL but always on the http://127.0.0.1:8080. As tell by Ivan Georgiev, I have modify the server.xml file like this :

  • pentaho\bi-server\jboss\server\default\deploy\jboss-web.deployer\server.xml :
    <!-- <Connector port="8080" address="${jboss.bind.address}"-->
    <Connector port="8080" address="tmgbkp02"   
             maxThreads="250" maxHttpHeaderSize="8192"
             emptySessionPath="true" protocol="HTTP/1.1"
             enableLookups="false" redirectPort="8443" acceptCount="100"
             connectionTimeout="20000" disableUploadTimeout="true" URIEncoding="UTF-8" />
            
    <!-- <Connector port="38011" address="${jboss.bind.address}" protocol="AJP/1.3"
             emptySessionPath="true" enableLookups="false" redirectPort="8443" /> -->
         <Connector port="38011" address="tmgbkp02" protocol="AJP/1.3"
             emptySessionPath="true" enableLookups="false" redirectPort="8443" />
    

    Ok, now the server is responding on the http://tmgbkp02:8080 and work fine. But i think that it will be better to set the variable jboss.bind.address instead of replacing them. So my questions :

  • where can i set the variable jboss.bind.address ?

Regards

Hubert

Comment: Posted by Hubert at Sep 03, 2008 05:21 Updated by Hubert

Hi,

I know it's kind of late (serveral months late  ) but I want to thank you very much! You saved my life 

Comment: Posted by nevaeh samy at May 19, 2009 09:16

How about pentaho BI 3.0?

I think it use tomcat instead of jboss. Without doing anything, I can access it from remote machine, but some examples didn't work.

 If some one knows solution, please let me know.

Thanks.

Comment: Posted by brightlee6 at Sep 01, 2009 12:39

Hi All,

My Pentaho version is 4.1.2

I am tired of doing all the things mentioned above but still I am not able to make my system as Server.

Someone please guide me the steps how to make my system as server so that I can access it remotely. In my machine I have Tomcat. I do not have jboss.

Also please guide me, after making my system as server, how to access through other system.

Please help me as I am very new to Pentaho.

Thanks

Atul

Comment: Posted by Atul Goel at Sep 30, 2012 03:11

I am also using Tomcat in place of Jboss. How can I configure this. I am getting following  error

1. HTTP/1.1 404 Not Found  error. Database connection refused.

2. Unable to refresh security information: The call failed on the server; see server log for details.

3. Unable to refresh database connection list: PacService.ERROR_0023 - Failed to get a Data Source: Cannot open connection

PLEASE Help

Regards,

Pankaj

Comment: Posted by pankaj kumar at Jun 23, 2013 20:58