Wednesday, July 7, 2010

Pentaho - Unable to connect to BI Server (windows)

Issue:
When you change the web settings (Base URL) configuration from the Enterprise Console from localhost to and restart the enterprise console you got an error as Unable to connect to BI server.
Solution:
You have to make changes on two files. Here is the location of the files:
• Web.xml File Location: D:\Program Files\pentaho\server\biserver-ee\tomcat\webapps\pentaho\WEB-INF\
• Hosts file location: D:\WINDOWS\system32\drivers\etc\
Go to Web.xml File
When you change the Base URL from localhost to your server name (Faridul.cpxinteractive.com) it actually made the change to a XML file. Around line 15 you will notice that whatever name you have changed earlier is reflecting here.
You don’t have to make any change here. Go to line 99

base-urlhttp://Faridul.cpxinteractive.com:18080/pentaho/


locale-languageYou need to change/add your IP address here on the highlighted. By default it is 127.0.0.1


Proxy Trusting Filter
org.pentaho.platform.web.http.filters.ProxyTrustingFilter

TrustedIpAddrs127.0.0.1-> Change this Or
127.0.0.1, 172.16.0.50->add you IP address here “,” seperated
Comma separated list of IP addresses of a trusted hosts.


Go to HOSTS File
Open the file on notepad. Notice the highlighted line.
# For example:
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
#71.210.88.2 mypentahoserver.com
127.0.0.1 localhost  Change/Comment out this OR
172.16.0.50 Faridul.cpxinteractive.com  Add this line