软件版本:Pentaho BIServer 5.0.1-CE
最近在做项目使用Pentaho做BI 后端服务器生成报表和仪表盘,我们自己的系统引用Pentaho BIServer生成的报表和仪表盘(主要将其嵌入我们的系统)。
在以前的版本中在嵌入URL中加入用户名和密码两个参数就可以访问对应的报表或仪表盘了但是Pentaho 5.0.1-ce版这样做无效总是弹出输入用户名和密码的框框真是烦人。
难道在新版本中去掉了这个功能?Google了一圈才发现这是一个Bug在这里有说明
http://jira.pentaho.com/browse/BISERVER-10708
解决方法很简单修改pentaho-solutions\system\applicationContext-spring-security.xml中的filterChainProxy下面配置的filterInvocationDefinitionSource
在/api/**中加入requestParameterProcessingFilter
在/plugin/**中加入requestParameterProcessingFilter
<bean id="filterChainProxy" class="org.springframework.security.util.FilterChainProxy"> <property name="filterInvocationDefinitionSource"> <value> <![CDATA[CONVERT_URL_TO_LOWERCASE_BEFORE_COMPARISON PATTERN_TYPE_APACHE_ANT /webservices/**=securityContextHolderAwareRequestFilterForWS,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,basicProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilterForWS,filterInvocationInterceptorForWS /api/**=securityContextHolderAwareRequestFilterForWS,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,requestParameterProcessingFilter,basicProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilterForWS,filterInvocationInterceptorForWS /plugin/**=securityContextHolderAwareRequestFilterForWS,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,requestParameterProcessingFilter,basicProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilterForWS,filterInvocationInterceptorForWS /**=securityContextHolderAwareRequestFilter,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,httpSessionReuseDetectionFilter,logoutFilter,authenticationProcessingFilter,basicProcessingFilter,requestParameterProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilter,filterInvocationInterceptor]]> </value> </property> </bean>
保存
重启服务器看看效果吧
http://localhost:8083/pentaho/plugin/pentaho-cdf-dd/api/renderer/render?solution=public&path=customer&file=Dashoard.wcdf&root=localhost:8083&userid=admin&password=password
我的博客:http://alenzhai.iteye.com/