<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-847186562383339762</id><updated>2024-09-14T19:17:58.643-07:00</updated><title type='text'>Pentaho - Unable to connect to BI Server</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://unabletoconnecttobiserver.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/847186562383339762/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://unabletoconnecttobiserver.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/06731273299234474960</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>1</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-847186562383339762.post-7718127801011802569</id><published>2010-07-07T09:34:00.000-07:00</published><updated>2010-07-07T09:36:21.626-07:00</updated><title type='text'>Pentaho - Unable to connect to BI Server (windows)</title><content type='html'>&lt;div style=&quot;background-color: orange;&quot;&gt;Issue: &lt;/div&gt;When you change the web settings (Base URL) configuration from the Enterprise Console from localhost to &lt;server name=&quot;&quot;&gt; and restart the enterprise console you got an error as Unable to connect to BI server. &lt;br /&gt;
&lt;span style=&quot;background-color: lime;&quot;&gt;Solution:&lt;/span&gt;&lt;br /&gt;
You have to make changes on two files. Here is the location of the files:&lt;br /&gt;
• Web.xml File Location: D:\Program Files\pentaho\server\biserver-ee\tomcat\webapps\pentaho\WEB-INF\&lt;br /&gt;
• Hosts file location: D:\WINDOWS\system32\drivers\etc\&lt;br /&gt;
Go to Web.xml File&lt;br /&gt;
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. &lt;br /&gt;
You don’t have to make any change here. Go to line 99&lt;br /&gt;
&lt;context-param&gt;&lt;br /&gt;
&lt;param-name&gt;base-url&lt;/param-name&gt;&lt;param-value&gt;http://Faridul.cpxinteractive.com:18080/pentaho/&lt;/param-value&gt;&lt;/context-param&gt;&lt;br /&gt;
&lt;context-param&gt;&lt;br /&gt;
&lt;param-name&gt;locale-language&lt;/param-name&gt;You need to change/add your IP address here on the highlighted. By default it is 127.0.0.1&lt;br /&gt;
&lt;br /&gt;
&lt;filter&gt;&lt;br /&gt;
&lt;filter-name&gt;Proxy Trusting Filter&lt;/filter-name&gt;&lt;br /&gt;
&lt;filter-class&gt;org.pentaho.platform.web.http.filters.ProxyTrustingFilter&lt;/filter-class&gt;&lt;br /&gt;
&lt;init-param&gt;&lt;br /&gt;
&lt;param-name&gt;TrustedIpAddrs&lt;/param-name&gt;&lt;param-value&gt;127.0.0.1&lt;/param-value&gt;&lt;span style=&quot;background-color: #7f6000;&quot;&gt;-&amp;gt; Change this Or&lt;/span&gt;&lt;br /&gt;
&lt;param-value&gt;127.0.0.1, 172.16.0.50&lt;/param-value&gt;-&lt;span style=&quot;background-color: #bf9000;&quot;&gt;&amp;gt;add you IP address here “,” seperated&lt;/span&gt;&lt;br /&gt;
&lt;description&gt;Comma separated list of IP addresses of a trusted hosts.&lt;/description&gt;&lt;br /&gt;
&lt;/init-param&gt;&lt;br /&gt;
&lt;/filter&gt;&lt;br /&gt;
Go to HOSTS File &lt;br /&gt;
Open the file on notepad. Notice the highlighted line. &lt;br /&gt;
# For example:&lt;br /&gt;
#      102.54.94.97     rhino.acme.com          # source server&lt;br /&gt;
#       38.25.63.10     x.acme.com              # x client host&lt;br /&gt;
#71.210.88.2 mypentahoserver.com&lt;br /&gt;
127.0.0.1       localhost&amp;nbsp; &lt;span style=&quot;background-color: #bf9000;&quot;&gt;Change/Comment out this OR &lt;/span&gt;&lt;br /&gt;
172.16.0.50 Faridul.cpxinteractive.com&amp;nbsp; &lt;span style=&quot;background-color: #7f6000; color: black;&quot;&gt;Add this line&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;/context-param&gt;&lt;/server&gt;</content><link rel='replies' type='application/atom+xml' href='http://unabletoconnecttobiserver.blogspot.com/feeds/7718127801011802569/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://unabletoconnecttobiserver.blogspot.com/2010/07/pentaho-unable-to-connect-to-bi-server.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/847186562383339762/posts/default/7718127801011802569'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/847186562383339762/posts/default/7718127801011802569'/><link rel='alternate' type='text/html' href='http://unabletoconnecttobiserver.blogspot.com/2010/07/pentaho-unable-to-connect-to-bi-server.html' title='Pentaho - Unable to connect to BI Server (windows)'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/06731273299234474960</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>