[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Messages posted by: khen.spw
Forum Index » Profile for khen.spw » Messages posted by khen.spw
Author Message
Hello

You can use several technics to execute R scripts, for excample to run a datamining algorithm.

A methode:
1 Developpe your R script
2 execute it using system access from spagoBI run documents or by passt a javascript code into spagobi document
(see in Spagobi forum ho add java script code in spagobi document)

B methode:
1.developpe a Talend Job (it's an ETL) integrated a component System run , to execute tour R script
2.export Talend Job to Spagobi server
3. schedule the Job run process into Spagobi Server

(see in Spago forum hos to run ETL process into spagobi for more details)

Hoppe this helps you
to be more clear

if I develop a report in ireport using hibernate connection and hql query?

How can I intgrate an other hibernate configuration to use it with the old hibernate connection used by spagobi to connect to Spagobi260 database.

I this case we use to hibernate connections definition.

can some one help me to integrate to hibernate defintion in spagobi 260 platform

thanks evry body.
Spagobi server use hebernate to connect to a database, my quation is :

Can spagobi platform use hebernate configuration in stade of jdbc connection in jrxml report ?




in this version spagobi is managed by exo platform;

otherwise, users and groups are managed by exo databases; if you would like to administrate them outside exo you need to know more on exo DB that you created it on you server, this the first step.


I deployed SpagoBI on Jboss server but there are some bugs
that prevented the proper fonctonnement of platform.

- Jboss Version: 4.2.3 GA
- DB server Mysql 5.1.0
- Spagobi 2.6.0

I created a new database with SpagoBI 2.6.0 scripts

I tested the platform and database with SpagoBI 2.6.0 + tomcat 6 it works very well.

But with jboss the platform generates some errors:

I configured and installed under jboss the next context.war

Spagobi.war
SpagoBIAccessibilityEngine.war
SpagoBICommonJEngine.war
SpagoBIJasperReportEngine.war
SpagoBIJPaloEngine.war
SpagoBIJPivotEngine.war
SpagoBIQbeEngine.war

User authentication managed with openldap server;

I start Jboss server and login with BiAdmin, at this step all works good.

But ....

When I select from biadmin menu next options it generates errors:

- Management engines, data sources and data set:

the following error iw shown on webpage and on jboss console:

it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'ENGINE_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5079) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:777) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.engines.config.service.ListEnginesModule.getList(ListEnginesModule.java:49) at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.engines.config.service.ListEnginesModule.getList(ListEnginesModule.java:49) at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619)
Parent not avalaible



- Lovs Management

it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'LOV_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5079) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:777) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.behaviouralmodel.lov.service.ListLovsModule.getList(ListLovsModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.behaviouralmodel.lov.service.ListLovsModule.getList(ListLovsModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619)
Parent not avalaible


- Constraints management

it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'CHECK_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5079) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:777) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.behaviouralmodel.check.service.ListPredefinedChecksModule.getList(ListPredefinedChecksModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.behaviouralmodel.check.service.ListPredefinedChecksModule.getList(ListPredefinedChecksModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619)
Parent not avalaible


- Analytical drivers management

it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'CHECK_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5079) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getObject(WrappedResultSet.java:777) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.behaviouralmodel.check.service.ListPredefinedChecksModule.getList(ListPredefinedChecksModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.behaviouralmodel.check.service.ListPredefinedChecksModule.getList(ListPredefinedChecksModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619)
Parent not avalaible


Please what can be the problem?

thank you.
A help steps about How deploy Openldap with Spagobi server

1) Openldap configuration

1.1) sldap.conf and users.ldif config

it is important to use a plain password in sldap.conf file because spagobi can't decrypt passwords other then whos wrypted with efaultCipher java;class.

I consider that you installed an open ldap server to support spagobi groups and users.

This is an extract of sldap.conf file:
...
suffix "dc=khen_pc,dc=com"
rootdn "cn=Manager,dc=khen_pc,dc=com"
rootpw spagobiworld
...

1.2) An exemple of ldif file (users.ldif) to create groups or users:

==========================================
dn: dc=khen_pc,dc=com
objectClass: top
objectClass: dcObject
objectClass: organization
dc: khen_pc
o: khen_pc.com

dn: cn=admin,dc=khen_pc,dc=com
objectClass: simpleSecurityObject
objectClass: organizationalRole
cn: admin
description: LDAP administrator
userPassword:: e2NyeXB0fVAxWGVuT0Z5MkR3N28=

dn: ou=People,dc=khen_pc,dc=com
objectClass: organizationalUnit
objectClass: top
ou: People

dn: cn=root,dc=khen_pc,dc=com
objectClass: organizationalRole
cn: root

dn: cn=biadmin,ou=People,dc=khen_pc,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: biadmin
description: /spagobi/admin
ou: ou= /spagobi/admin,ou=Group,dc=khen_pc,dc=com
sn: biadmin
telephoneNumber: 00331445566
title: Dot.
userPassword:: YmlhZG1pbg==

dn: cn=bidev,ou=People,dc=khen_pc,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: bidev
description: /spagobi/dev
ou: ou=/spagobi/dev,ou=Group,dc=khen_pc,dc=com
sn: bidev
title: Dot.
userPassword:: YmlkZXY=

dn: cn=biuser,ou=People,dc=khen_pc,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: biuser
description: /spagobi/user
ou: ou=/spagobi/user,ou=Group,dc=khen_pc,dc=com
sn: biuser
title: Dot.
userPassword:: Yml1c2Vy

dn: cn=bitest,ou=People,dc=khen_pc,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: bitest
description: /spagobi/test
ou: ou=/spagobi/test,ou=Group,dc=khen_pc,dc=com
sn: bitest
title: Dot.
userPassword:: Yml0ZXN0

dn: ou=Group,dc=khen_pc,dc=com
objectClass: top
objectClass: organizationalUnit
ou: Group

dn: ou=/spagobi/admin,ou=Group,dc=khen_pc,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/admin
ou: /spagobi/admin

dn: ou=/spagobi/dev,ou=Group,dc=khen_pc,dc=com
objectClass: organizationalUnit
objectClass: top
description: ou=/spagobi/dev
ou: /spagobi/dev

dn: ou=/spagobi/test,ou=Group,dc=khen_pc,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/test
ou: /spagobi/test

dn: ou=/spagobi/user,ou=Group,dc=khen_pc,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/user
ou: /spagobi/user

========================================



2) Spagobi configuration

2.1) Encrypt password with DefaultCipher:

move to folder (tomcat)\webapps\SpagoBI\WEB-INF\lib

run next line:
java -cp ./spago-core-2.2.0.jar;./commons-codec-1.3.jar it.eng.spago.security.DefaultCipher encrypt spagobiworld
encrypted [8e0c280140f49893d8b9e474a198feb8]

copy only 8e0c280140f49893d8b9e474a198feb8 in ldap_authorization.xml as crypted password

with Linux:
java -cp ./spago-core-2.2.0.jar:./commons-codec-1.3.jar it.eng.spago.security.DefaultCipher encrypt spagobiworld

2.2) prepare ldap_authorization.xml file
located in folder: (tomcat)\webapps\SpagoBI\WEB-INF\conf\webapp
...
<LDAP_AUTHORIZATIONS default="FALSE">
<CONFIG>
<USER_DN>cn=*,ou=People,dc=khen_pc,dc=com</USER_DN>
<ADMIN_USER>cn=admin,dc=khen_pc,dc=com</ADMIN_USER>
<ADMIN_PSW>8e0c280140f49893d8b9e474a198feb8</ADMIN_PSW>
<ATTRIBUTES_ID name="nome">description</ATTRIBUTES_ID>
<ATTRIBUTES_ID name="cognome">sn</ATTRIBUTES_ID>
<ATTRIBUTES_ID name="userId">cn</ATTRIBUTES_ID>
<HOST>localhost</HOST>
<PORT>389</PORT>
<OBJECTCLASS>person</OBJECTCLASS>
<SEARCH_ROOT>ou=People,dc=khen_pc,dc=com</SEARCH_ROOT>
<OU_ATTRIBUTE>ou</OU_ATTRIBUTE>
<SEARCH_ROOT_GROUP>OU=Group,dc=khen_pc,dc=com</SEARCH_ROOT_GROUP>
<OBJECTCLASS_GROUP>organizationalUnit</OBJECTCLASS_GROUP>
<ATTRIBUTES_ID_GROUP>description</ATTRIBUTES_ID_GROUP>
<ATTRIBUTES_ID_GROUP>OU</ATTRIBUTES_ID_GROUP>
</CONFIG>
</LDAP_AUTHORIZATIONS>


2.3) prepare spagobi.xml file:
located in folder: (tomcat)\webapps\SpagoBI\WEB-INF\conf\config

activate the ldap xml group in spagobi.xml
....
<!-- Web security Provider (LDAP) -->

<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.LdapSecurityProviderInit</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.LdapSecurityProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.LdapUserProfileFactoryImpl" />
<ROLE-NAME-PATTERN-FILTER>.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>

....


and desactivate xthe xml authentification like this :

....
<!-- START-XML -->
<!--
<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.InternalSecurityInitializer</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.InternalSecurityInfoProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.InternalSecurityServiceSupplierImpl" />
<ROLE-NAME-PATTERN-FILTER>.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>
-->
<!-- STOP-XML -->

....


3) you can use an external software to administrate users and groups in openldap server:

JXplorer is a frindly program to administrate an openldap server.

after download it and install the program : http://sourceforge.net/projects/jxplorer/

fill info about your openldap sever login:
for exemple:
IP server : localhost
Port: 389
Protocol: ldap_v3
DN:dc=talend,dc=com
user DN: cn=admin,dc=khen_pc,dc=com
password: spagobiworld

and so

Don't forget to read : http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/User+management
....

I hope this litle guide will every body.

All my thanks to Samueleorso and Bernabei.
A)
I tryed the next line dosn't works rigth

C:\tdqportal\webapps\tdqportal\WEB-INF\lib>java -cp ./spago-core-2.2.0.jar;./commons-codec-1.3.jar it.eng.spago.security.DefaultCipher.encrypt secret
Exception in thread "main" java.lang.NoClassDefFoundError: it/eng/spago/security/DefaultCipher/encrypt
Caused by: java.lang.ClassNotFoundException: it.eng.spago.security.DefaultCipher.encrypt
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: it.eng.spago.security.DefaultCipher.encrypt. Program will exit.



but this one can generate a password:

java -cp ./spago-core-2.2.0.jar;./commons-codec-1.3.jar it.eng.spago.security.DefaultCipher encrypt secret
encrypted [6ddbcdd70d086e75bdc121b16bd23f03]

I must separate DefaultCipher encrypt and replace : with ; as commands separator in windows.

any way

=========================================================


I used this password 6ddbcdd70d086e75bdc121b16bd23f03

in ldap_authorization.xml

<LDAP_AUTHORIZATIONS default="FALSE">
<CONFIG>
<USER_DN>cn=*,ou=People,dc=spagobi,dc=com</USER_DN>
<ADMIN_USER>cn=Manager,dc=spagobi,dc=com</ADMIN_USER>
<ADMIN_PSW>6ddbcdd70d086e75bdc121b16bd23f03</ADMIN_PSW>
<ATTRIBUTES_ID name="nome">description</ATTRIBUTES_ID>
<ATTRIBUTES_ID name="cognome">sn</ATTRIBUTES_ID>
<ATTRIBUTES_ID name="userId">cn</ATTRIBUTES_ID>
<HOST>192.168.10.11</HOST>
<PORT>389</PORT>
<OBJECTCLASS>person</OBJECTCLASS>
<SEARCH_ROOT>ou=People,dc=spagobi,dc=com</SEARCH_ROOT>
<OU_ATTRIBUTE>memberOf</OU_ATTRIBUTE>
<SEARCH_ROOT_GROUP>OU=Group,dc=spagobi,dc=com</SEARCH_ROOT_GROUP>
<OBJECTCLASS_GROUP>organizationalUnit</OBJECTCLASS_GROUP>
<ATTRIBUTES_ID_GROUP>description</ATTRIBUTES_ID_GROUP>
<ATTRIBUTES_ID_GROUP>OU</ATTRIBUTES_ID_GROUP>
</CONFIG>
</LDAP_AUTHORIZATIONS>

in ldap config file i changed Manager password as

rootpw 6ddbcdd70d086e75bdc121b16bd23f03


But my quation is, what kind of encryption should i select with LDAP authentification (when login with Manager : plain, MD5, SMD5, SHA or SSHA) that it works with it.eng.spago.security.DefaultCipher.





I'll try to change passwords with those generated with

java -cp ./spago-core-2.2.0.jar:./commons-codec-1.3.jar it.eng.spago.security.DefaultCipher.encrypt [YOUR_PASSWORD]

I generate password with ldpadpassword utilty;

but when run spagobi server it can access to ldap server and ead informations from, the problem it can't compose roles!
Hi,

I configured SpagoBI 2.6.0 to use OpenLDAP for user authentication as BIADMIN, BIUSER ... respecting configuration of ldap_authorization.xml and spagobi.xml files proposed in the spagobi wiki.

can you help me solve this problem especially since the directory access is successful but SpagoBI can not read roles from the directory.

other infos about spagobi configuration:


=============================================
spagobi.log:

main] 29 juil. 2010 12:35:00,801 ERROR it.eng.spagobi.security.RoleSynchronizer.synchronize:120 - An exception has occurred
java.lang.NullPointerException
at it.eng.spagobi.security.LDAPConnector.createConnection(LDAPConnector.java:137)
at it.eng.spagobi.security.LDAPConnector.getAllGroups(LDAPConnector.java:342)
at it.eng.spagobi.security.LdapSecurityProviderImpl.getRoles(LdapSecurityProviderImpl.java:71)
at it.eng.spagobi.security.RoleSynchronizer.synchronize(RoleSynchronizer.java:94)
at it.eng.spagobi.security.init.SecurityInitializer.init(SecurityInitializer.java:82)
at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:49
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)




====================================
spagobi.xml


<?xml version="1.0" encoding="ISO-8859-1"?>
<SPAGOBI>

<!-- ********************* START MODE CONFIGURATION ************************ -->
<!-- START-WEB -->
<SPAGOBI-MODE mode="WEB"/>
<!-- END-WEB -->

<HOME>
<BANNER view="true" />
<FOOTER view="false" />
</HOME>

<!-- START-PORTLET
<SPAGOBI-MODE mode="PORTLET"/>
END-PORTLET -->

<!-- ********************* END MODE CONFIGURATION ************************** -->

<!-- defines the max dimension (in bytes) of a document template when uploading it into document detail page -->
<TEMPLATE_MAX_SIZE>5242880</TEMPLATE_MAX_SIZE>

<!-- ********************* START MENU CONFIGURATION ************************ -->
<!-- Property 'mode' defines the style of menu:
- 'ALL_TOP': all the menu voices are on the top of page
- 'ALL_LEFT': all the menu voices are on the left of the page
- 'TOP_LEFT': the first level is on the top, while others levels are on the left of the page
AT THE TIME BEING, ONLY ALL_TOP WORKS PROPERLY
-->
<MENU mode="ALL_TOP" viewExtra="YES" pathTracked="false"/>


<!-- ********************* END MENU CONFIGURATION ************************** -->


<!-- ********************* START SECURITY CONFIGURATION ************************ -->



<!-- START-XML -->
<!--
<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.InternalSecurityInitializer</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.InternalSecurityInfoProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.InternalSecurityServiceSupplierImpl" />
<ROLE-NAME-PATTERN-FILTER>.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>
-->
<!-- STOP-XML -->


<!-- Web security Provider (LDAP) -->

<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.LdapSecurityProviderInit</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.LdapSecurityProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.LdapUserProfileFactoryImpl" />
<ROLE-NAME-PATTERN-FILTER>.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>


<!-- Exo security Provider -->
<!--
<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.ExoPortalSecurityProviderInit</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.ExoSecurityProviderImpl">
<CONFIG>
<NAME_PORTAL_APPLICATION>@portal.context@</NAME_PORTAL_APPLICATION>
</CONFIG>
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.ExoUserProfileImpl">
</USER-PROFILE-FACTORY-CLASS>
<ROLE-NAME-PATTERN-FILTER>/spagobi/.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>
-->

<!-- START-LIFERAY

<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.LiferayPortalSecurityProviderInit</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.LiferaySecurityInfoProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.LiferaySecurityServiceSupplierImpl">
</USER-PROFILE-FACTORY-CLASS>
<WS_SERVICE url="localhost:58080/tunnel-web/secure/axis/" username="bruno" password="bruno"/>
<ROLE-NAME-PATTERN-FILTER>/spagobi/.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
<PROFILE_ATTRIBUTES>
<ATTRIBUTE name="NAME" default="" source="NAME" />
<ATTRIBUTE name="SURNAME" default="" source="SURNAME" />
<ATTRIBUTE name="USER_ID" default="" source="USER_ID" />
<ATTRIBUTE name="E_MAIL" default="" source="E_MAIL" />
</PROFILE_ATTRIBUTES>
<ROLES>
<ROLE name="/spagobi/admin" desc="/spagobi/admin" />
<ROLE name="/spagobi/dev" desc="/spagobi/dev" />
<ROLE name="/spagobi/test" desc="/spagobi/test" />
<ROLE name="/spagobi/modeladmin" desc="/spagobi/modeladmin" />
<ROLE name="/spagobi/user" desc="/spagobi/user" />
</ROLES>
</SECURITY>
END-LIFERAY -->

<!-- ********************* END SECURITY CONFIGURATION ************************** -->


<!-- ********************* START DATABASE CONFIGURATION ************************ -->

<!-- SPAGOBI HIBERNATE PERSISTENCE CONFIGURATTION -->
<!-- PostgresSQL -->
<!-- hibernate.cfg.postgres.xml -->
<!-- MySQL: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.mysql.xml -->
<!-- Oracle: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.ora.xml-->
<!-- Hsqldb: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.hsql.xml -->
<!-- SqlServer: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.sqlserver.xml -->
<!-- Ingres: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.ingres.xml -->

<HIBERNATE-CFGFILE>hibernate.cfg.mysql.xml</HIBERNATE-CFGFILE>

<!-- ********************* END DATABASE CONFIGURATION ************************ -->


<!-- ********************* START GENERAL CONFIGURATION ************************ -->


<!--
Date format for communications with the server (both on sending and receiving); format attribute is for server side services, see java.text.SimpleDateFormat for details,
while extJsFormat is for ExtJs client, that use another standard, see http://extjs.com/deploy/dev/docs/.
IF YOU CHANGE ONE FORMAT YOU MUST CHANGE THE OTHER ONE ACCORDINGLY.
-->
<DATE-FORMAT-SERVER format="dd/MM/yyyy" extJsFormat="d/m/Y" />

<!--
Date format used while displaying dates according to user current locale.
Format attribute is for old presentation mechanism, see java.text.SimpleDateFormat for details,
while extJsFormat is for ExtJs client, that use another standard, see http://extjs.com/deploy/dev/docs/.
IF YOU CHANGE ONE FORMAT YOU MUST CHANGE THE OTHER ONE ACCORDINGLY.
-->
<DATE-FORMAT-IT_IT format="dd/MM/yyyy" extJsFormat="d/m/Y"/>
<DATE-FORMAT-EN_US format="MM/dd/yyyy" extJsFormat="m/d/Y"/>
<DATE-FORMAT-FR_FR format="dd/MM/yyyy" extJsFormat="d/m/Y"/>
<DATE-FORMAT-ES_ES format="dd/MM/yyyy" extJsFormat="d/m/Y"/>
<TIMESTAMP-FORMAT format="dd/MM/yyyy hh:mm:ss" extJsFormat="d/m/Y H:i:s"/>

<!-- Date visual format if language is not found-->
<DATE-FORMAT format="dd/MM/yyyy" extJsFormat="d/m/Y"/>


<!-- True If you want to log user actions in DB table sbi_activity_monitoring-->
<DB_LOG value="false" />
<!-- TimeStamp Format of SpagoBI DB-->
<!-- PostgresSQL: Uncomment the row below and edit the file to provide Db timestamp info -->
<!-- yyyy-MM-dd HH:mm:ss -->
<!-- MySQL: (Default) -->
<!-- yyyy-MM-dd HH:mm:ss -->
<!-- Oracle: Uncomment the row below and edit the file to provide Db timestamp info -->
<!-- dd-MMM-yy HH:mm:ss-->
<!-- Hsqldb: Uncomment the row below and edit the file to provide Db timestamp info -->
<!-- yyyy-MM-dd HH:mm:ss -->
<DB-TIMESTAMP-FORMAT format="yyyy-MM-dd HH:mm:ss" />



<THEMES>
<THEME name="sbi_default" default="true" view_name="default" ext_theme="xtheme-gray.css" />
<!-- <THEME name="other_theme" default="false" view_name="other" /> -->
</THEMES>

<SESSION_PARAMETERS_MANAGER enabled="false" />

<LOOKUP numberRows = "20" />


<SPAGOBI_CONTEXT>/SpagoBI</SPAGOBI_CONTEXT>

<SPAGOBI_HOST_JNDI>java://comp/env/spagobi_host_url</SPAGOBI_HOST_JNDI>

<RESOURCE_PATH_JNDI_NAME>java://comp/env/spagobi_resource_path</RESOURCE_PATH_JNDI_NAME>

<!-- The URL to FORWARD to when session has expired -->
<SESSION_EXPIRED_URL>/WEB-INF/jsp/commons/sessionExpired.jsp</SESSION_EXPIRED_URL>

<SPAGO_ADAPTERHTTP_URL>/servlet/AdapterHTTP</SPAGO_ADAPTERHTTP_URL>

<PORTLET_EDIT_MODE_ROLES>
<ROLE name="/spagobi/admin" />
</PORTLET_EDIT_MODE_ROLES>

<LANGUAGE_SUPPORTED>
<LANGUAGE default="false" language="it" country="IT" />
<LANGUAGE default="true" language="en" country="US" />
<LANGUAGE default="false" language="fr" country="FR" />
<LANGUAGE default="false" language="es" country="ES" />
</LANGUAGE_SUPPORTED>


<SCRIPT_LANGUAGE_SUPPORTED>
<SCRIPT_LANGUAGE default="true"
name="groovy"
engineclass="org.codehaus.groovy.bsf.GroovyEngine"
identifier="groovy"
shortidentifier="gy"
predefinedScriptFile="predefinedGroovyScript.groovy"/>
<SCRIPT_LANGUAGE default="false"
name="javascript"
identifier="javascript"
shortidentifier="js"
predefinedScriptFile="predefinedJavascriptScript.js"/>
</SCRIPT_LANGUAGE_SUPPORTED>


<TREE_INITIALIZATION>
<TREE_INITIAL_STRUCTURE>
<NODE code="Functionalities" name="Functionalities"
description="Functionalities" parentPath="" codeType="LOW_FUNCT" />
<!--
<NODE code="SystemFunctionalities" name="System Functionalities"
description="System Functionalities" parentPath="/Functionalities" codeType="LOW_FUNCT" />
-->
</TREE_INITIAL_STRUCTURE>
</TREE_INITIALIZATION>
<INDEX_INITIALIZATION>
<INDEX jndiResourcePath="java://comp/env/spagobi_resource_path" name="//idx" />
</INDEX_INITIALIZATION>
<INTERNAL_PROFILING_INITIALIZER passwordAbilitated="false">
<DEFAULT_USERS>
<USER userId="biadmin" password="biadmin" fullName="SpagoBI Administrator">
<ATTRIBUTE name="email" value="admin@eng.it" />
<ATTRIBUTE name="name" value="SpagoBI Administrator" />
<ROLE name="/spagobi/admin"/>
</USER>
<USER userId="biuser" password="biuser" fullName="SpagoBI User">
<ATTRIBUTE name="name" value="SpagoBI User" />
<ROLE name="/spagobi/user"/>
</USER>
<USER userId="bitest" password="bitest" fullName="SpagoBI Test User">
<ATTRIBUTE name="name" value="SpagoBI TestUser" />
<ROLE name="/spagobi/test"/>
</USER>
<USER userId="bidev" password="bidev" fullName="SpagoBI Developer">
<ATTRIBUTE name="name" value="SpagoBI Developer" />
<ROLE name="/spagobi/dev"/>
</USER>
<USER userId="user1" password="user1" fullName="SpagoBI User1">
<ATTRIBUTE name="name" value="SpagoBI1" />
<ATTRIBUTE name="surname" value="user1" />
<ATTRIBUTE name="email" value="user1@yahoo.com" />
<ROLE name="/spagobi/user"/>
</USER>
</DEFAULT_USERS>
<DEFAULT_ATTRIBUTES>
<ATTRIBUTE name="name" description="name" />
<ATTRIBUTE name="surname" description="surname" />
<ATTRIBUTE name="address" description="address" />
<ATTRIBUTE name="birth_date" description="birth date" />
<ATTRIBUTE name="email" description="email" />
</DEFAULT_ATTRIBUTES>
<DEFAULT_ROLES>
<ROLE roleName="/spagobi/dev" description="/spagobi/dev" roleTypeCD="DEV_ROLE"/>
<ROLE roleName="/spagobi/test" description="/spagobi/test" roleTypeCD="TEST_ROLE"/>
<ROLE roleName="/spagobi/user" description="/spagobi/user" roleTypeCD="USER"/>
<ROLE roleName="/spagobi/admin" description="/spagobi/admin" roleTypeCD="ADMIN" />
<ROLE roleName="/spagobi/modeladmin" description="/spagobi/modeladmin" roleTypeCD="MODEL_ADMIN" />
</DEFAULT_ROLES>
</INTERNAL_PROFILING_INITIALIZER>

</SPAGOBI>


====================================================
ldap_authorizations.xml


<?xml version="1.0" encoding="ISO-8859-1"?>
<LDAP_AUTHORIZATIONS default="FALSE">
<CONFIG>
<USER_DN>cn=*,ou=People,dc=spagobi,dc=com</USER_DN>
<ADMIN_USER>cn=Manager,dc=spagobi,dc=com</ADMIN_USER>
<ADMIN_PSW>{SSHA}d7pO5yQ0bg3aHfCmQyiqHBWMmh8AK3nG</ADMIN_PSW>
<ATTRIBUTES_ID name="nome">description</ATTRIBUTES_ID>
<ATTRIBUTES_ID name="cognome">sn</ATTRIBUTES_ID>
<ATTRIBUTES_ID name="userId">cn</ATTRIBUTES_ID>
<HOST>192.168.10.11</HOST>
<PORT>389</PORT>
<OBJECTCLASS>person</OBJECTCLASS>
<SEARCH_ROOT>ou=People,dc=spagobi,dc=com</SEARCH_ROOT>
<OU_ATTRIBUTE>memberOf</OU_ATTRIBUTE>
<SEARCH_ROOT_GROUP>CN=Group,dc=spagobi,dc=com</SEARCH_ROOT_GROUP>
<OBJECTCLASS_GROUP>organizationalUnit</OBJECTCLASS_GROUP>
<ATTRIBUTES_ID_GROUP>description</ATTRIBUTES_ID_GROUP>
<ATTRIBUTES_ID_GROUP>CN</ATTRIBUTES_ID_GROUP>
</CONFIG>

</LDAP_AUTHORIZATIONS>


====================================================

LDIF file extracted from openldap server

version: 1
dn: dc=spagobi,dc=com
objectClass: top
objectClass: dcObject
objectClass: organization
dc: spagobi
description: Spagobi
o: Spagobi

dn: cn=Manager,dc=spagobi,dc=com
objectClass: organizationalRole
cn: Manager

dn: cn=root,dc=spagobi,dc=com
objectClass: organizationalRole
cn: root

dn: ou=People,dc=spagobi,dc=com
objectClass: top
objectClass: organizationalUnit
ou: People

dn: cn=bidev,ou=People,dc=spagobi,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: bidev
description: /spagobi/dev
ou: ou=/spagobi/dev,ou=Group,dc=spagobi,dc=com
sn: bidev
title: Dot.
userPassword:: YmlkZXY=

dn: cn=biuser,ou=People,dc=spagobi,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: biuser
description: /spagobi/user
ou: ou=/spagobi/user,ou=Group,dc=spagobi,dc=com
sn: biuser
title: Dot.
userPassword:: Yml1c2Vy

dn: cn=bitest,ou=People,dc=spagobi,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: bitest
description: /spagobibi/test
ou: ou=/spagobi/test,ou=Group,dc=spagobi,dc=com
sn: bitest
title: Dot.
userPassword:: Yml0ZXN0

dn: cn=biadmin,ou=People,dc=spagobi,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: biadmin
description: /spagobi/biadmin
ou: ou=/spagobi/admin, ou=Group,dc=spagobi,dc=com
sn: biadmin
title: Dot.
userPassword:: YmlhZG1pbg==

dn: cn=user2,ou=People,dc=spagobi,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: user2
description: /spagobi/user2
ou: ou=/spagobi/user, ou=Group,dc=spagobi,dc=com
sn: user2
title: Dot.
userPassword:: dGRx

dn: cn=user1,ou=People,dc=spagobi,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: user1
description: /spagobi/user1
ou: ou=/spagobi/user, ou=Group,dc=spagobi,dc=com
sn: user1
title: Dot.
userPassword:: dGRx

dn: cn=bam,ou=People,dc=spagobi,dc=com
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: bam
description: bam
ou: ou=/spagobi/user, ou=Group,dc=spagobi,dc=com
sn: bam
title: Dot.
userPassword:: YmFt

dn: ou=Group,dc=spagobi,dc=com
objectClass: top
objectClass: organizationalUnit
description: Group
ou: Group

dn: ou=/spagobi/modeladmin,ou=Group,dc=spagobi,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/modeladmin
ou: /spagobi/modeladmin

dn: ou=/spagobi/admin,ou=Group,dc=spagobi,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/admin
ou: /spagobi/admin

dn: ou=/spagobi/dev,ou=Group,dc=spagobi,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/de
ou: /spagobi/dev

dn: ou=/spagobi/user,ou=Group,dc=spagobi,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/user
ou: /spagobi/user

dn: ou=/spagobi/test,ou=Group,dc=spagobi,dc=com
objectClass: organizationalUnit
objectClass: top
description: /spagobi/test
ou: /spagobi/test



Thank you every one;
this a copy a spagobi.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<SPAGOBI>

<!-- ********************* START MODE CONFIGURATION ************************ -->
<!-- START-WEB -->
<SPAGOBI-MODE mode="WEB"/>
<!-- END-WEB -->

<HOME>
<BANNER view="true" />
<FOOTER view="true" />
</HOME>

<!-- START-PORTLET
<SPAGOBI-MODE mode="PORTLET"/>
END-PORTLET -->

<!-- ********************* END MODE CONFIGURATION ************************** -->

<!-- defines the max dimension (in bytes) of a document template when uploading it into document detail page -->
<TEMPLATE_MAX_SIZE>5242880</TEMPLATE_MAX_SIZE>

<!-- ********************* START MENU CONFIGURATION ************************ -->
<!-- Property 'mode' defines the style of menu:
- 'ALL_TOP': all the menu voices are on the top of page
- 'ALL_LEFT': all the menu voices are on the left of the page
- 'TOP_LEFT': the first level is on the top, while others levels are on the left of the page
AT THE TIME BEING, ONLY ALL_TOP WORKS PROPERLY
-->
<MENU mode="ALL_TOP" viewExtra="YES" pathTracked="false"/>


<!-- ********************* END MENU CONFIGURATION ************************** -->


<!-- ********************* START SECURITY CONFIGURATION ************************ -->



<!-- START-XML -->

<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.InternalSecurityInitializer</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.InternalSecurityInfoProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.InternalSecurityServiceSupplierImpl" />
<ROLE-NAME-PATTERN-FILTER>spagobi.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>

<!-- STOP-XML -->


<!-- Web security Provider (LDAP) -->
<!--
<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.LdapSecurityProviderInit</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.LdapSecurityProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.LdapUserProfileFactoryImpl" />
<ROLE-NAME-PATTERN-FILTER>.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>
-->

<!-- Exo security Provider -->
<!--
<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.ExoPortalSecurityProviderInit</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.ExoSecurityProviderImpl">
<CONFIG>
<NAME_PORTAL_APPLICATION>@portal.context@</NAME_PORTAL_APPLICATION>
</CONFIG>
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.ExoUserProfileImpl">
</USER-PROFILE-FACTORY-CLASS>
<ROLE-NAME-PATTERN-FILTER>/spagobi/.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
</SECURITY>
-->

<!-- START-LIFERAY

<SECURITY>
<PORTAL-SECURITY-INIT-CLASS>it.eng.spagobi.security.init.LiferayPortalSecurityProviderInit</PORTAL-SECURITY-INIT-CLASS>
<PORTAL-SECURITY-CLASS className="it.eng.spagobi.security.LiferaySecurityInfoProviderImpl">
<CONFIG />
</PORTAL-SECURITY-CLASS>
<USER-PROFILE-FACTORY-CLASS className="it.eng.spagobi.security.LiferaySecurityServiceSupplierImpl">
</USER-PROFILE-FACTORY-CLASS>
<WS_SERVICE url="localhost:58080/tunnel-web/secure/axis/" username="bruno" password="bruno"/>
<ROLE-NAME-PATTERN-FILTER>/spagobi/.*</ROLE-NAME-PATTERN-FILTER>
<ROLE-TYPE-PATTERNS>
<ADMIN-PATTERN>/spagobi/admin</ADMIN-PATTERN>
<DEV_ROLE-PATTERN>/spagobi/dev</DEV_ROLE-PATTERN>
<TEST_ROLE-PATTERN>/spagobi/test</TEST_ROLE-PATTERN>
<MODEL_ADMIN-PATTERN>/spagobi/modeladmin</MODEL_ADMIN-PATTERN>
</ROLE-TYPE-PATTERNS>
<PROFILE_ATTRIBUTES>
<ATTRIBUTE name="NAME" default="" source="NAME" />
<ATTRIBUTE name="SURNAME" default="" source="SURNAME" />
<ATTRIBUTE name="USER_ID" default="" source="USER_ID" />
<ATTRIBUTE name="E_MAIL" default="" source="E_MAIL" />
</PROFILE_ATTRIBUTES>
<ROLES>
<ROLE name="/spagobi/admin" desc="/spagobi/admin" />
<ROLE name="/spagobi/dev" desc="/spagobi/dev" />
<ROLE name="/spagobi/test" desc="/spagobi/test" />
<ROLE name="/spagobi/modeladmin" desc="/spagobi/modeladmin" />
<ROLE name="/spagobi/user" desc="/spagobi/user" />
</ROLES>
</SECURITY>
END-LIFERAY -->

<!-- ********************* END SECURITY CONFIGURATION ************************** -->


<!-- ********************* START DATABASE CONFIGURATION ************************ -->

<!-- SPAGOBI HIBERNATE PERSISTENCE CONFIGURATTION -->
<!-- PostgresSQL -->
<!-- hibernate.cfg.postgres.xml -->
<!-- MySQL: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.mysql.xml -->
<!-- Oracle: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.ora.xml-->
<!-- Hsqldb: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.hsql.xml -->
<!-- SqlServer: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.sqlserver.xml -->
<!-- Ingres: Uncomment the row below and edit the file to provide connection info -->
<!-- hibernate.cfg.ingres.xml -->

<HIBERNATE-CFGFILE>hibernate.cfg.mysql.xml</HIBERNATE-CFGFILE>

<!-- ********************* END DATABASE CONFIGURATION ************************ -->


<!-- ********************* START GENERAL CONFIGURATION ************************ -->


<!--
Date format for communications with the server (both on sending and receiving); format attribute is for server side services, see java.text.SimpleDateFormat for details,
while extJsFormat is for ExtJs client, that use another standard, see http://extjs.com/deploy/dev/docs/.
IF YOU CHANGE ONE FORMAT YOU MUST CHANGE THE OTHER ONE ACCORDINGLY.
-->
<DATE-FORMAT-SERVER format="dd/MM/yyyy" extJsFormat="d/m/Y" />

<!--
Date format used while displaying dates according to user current locale.
Format attribute is for old presentation mechanism, see java.text.SimpleDateFormat for details,
while extJsFormat is for ExtJs client, that use another standard, see http://extjs.com/deploy/dev/docs/.
IF YOU CHANGE ONE FORMAT YOU MUST CHANGE THE OTHER ONE ACCORDINGLY.
-->
<DATE-FORMAT-IT_IT format="dd/MM/yyyy" extJsFormat="d/m/Y"/>
<DATE-FORMAT-EN_US format="MM/dd/yyyy" extJsFormat="m/d/Y"/>
<DATE-FORMAT-FR_FR format="dd/MM/yyyy" extJsFormat="d/m/Y"/>
<DATE-FORMAT-ES_ES format="dd/MM/yyyy" extJsFormat="d/m/Y"/>
<TIMESTAMP-FORMAT format="dd/MM/yyyy hh:mm:ss" extJsFormat="d/m/Y H:i:s"/>

<!-- Date visual format if language is not found-->
<DATE-FORMAT format="dd/MM/yyyy" extJsFormat="d/m/Y"/>


<!-- True If you want to log user actions in DB table sbi_activity_monitoring-->
<DB_LOG value="false" />
<!-- TimeStamp Format of SpagoBI DB-->
<!-- PostgresSQL: Uncomment the row below and edit the file to provide Db timestamp info -->
<!-- yyyy-MM-dd HH:mm:ss -->
<!-- MySQL: (Default) -->
<!-- yyyy-MM-dd HH:mm:ss -->
<!-- Oracle: Uncomment the row below and edit the file to provide Db timestamp info -->
<!-- dd-MMM-yy HH:mm:ss-->
<!-- Hsqldb: Uncomment the row below and edit the file to provide Db timestamp info -->
<!-- yyyy-MM-dd HH:mm:ss -->
<DB-TIMESTAMP-FORMAT format="yyyy-MM-dd HH:mm:ss" />

<THEMES>
<THEME name="sbi_default" default="true" view_name="default" ext_theme="xtheme-gray.css" />
<!-- <THEME name="other_theme" default="false" view_name="other" /> -->
</THEMES>

<SESSION_PARAMETERS_MANAGER enabled="false" />

<LOOKUP numberRows = "20" />


<SPAGOBI_CONTEXT>/SpagoBI</SPAGOBI_CONTEXT>

<SPAGOBI_HOST_JNDI>java://comp/env/spagobi_host_url</SPAGOBI_HOST_JNDI>

<RESOURCE_PATH_JNDI_NAME>java://comp/env/spagobi_resource_path</RESOURCE_PATH_JNDI_NAME>

<!-- The URL to FORWARD to when session has expired -->
<SESSION_EXPIRED_URL>/WEB-INF/jsp/commons/sessionExpired.jsp</SESSION_EXPIRED_URL>

<SPAGO_ADAPTERHTTP_URL>/servlet/AdapterHTTP</SPAGO_ADAPTERHTTP_URL>

<PORTLET_EDIT_MODE_ROLES>
<ROLE name="/spagobi/admin" />
</PORTLET_EDIT_MODE_ROLES>

<LANGUAGE_SUPPORTED>
<LANGUAGE default="false" language="it" country="IT" />
<LANGUAGE default="true" language="en" country="US" />
<LANGUAGE default="false" language="fr" country="FR" />
<LANGUAGE default="false" language="es" country="ES" />
</LANGUAGE_SUPPORTED>


<SCRIPT_LANGUAGE_SUPPORTED>
<SCRIPT_LANGUAGE default="true"
name="groovy"
engineclass="org.codehaus.groovy.bsf.GroovyEngine"
identifier="groovy"
shortidentifier="gy"
predefinedScriptFile="predefinedGroovyScript.groovy"/>
<SCRIPT_LANGUAGE default="false"
name="javascript"
identifier="javascript"
shortidentifier="js"
predefinedScriptFile="predefinedJavascriptScript.js"/>
</SCRIPT_LANGUAGE_SUPPORTED>


<TREE_INITIALIZATION>
<TREE_INITIAL_STRUCTURE>
<NODE code="Functionalities" name="Functionalities"
description="Functionalities" parentPath="" codeType="LOW_FUNCT" />
<!--
<NODE code="SystemFunctionalities" name="System Functionalities"
description="System Functionalities" parentPath="/Functionalities" codeType="LOW_FUNCT" />
-->
</TREE_INITIAL_STRUCTURE>
</TREE_INITIALIZATION>
<INDEX_INITIALIZATION>
<INDEX jndiResourcePath="java://comp/env/spagobi_resource_path" name="//idx" />
</INDEX_INITIALIZATION>
<INTERNAL_PROFILING_INITIALIZER passwordAbilitated="false">
<DEFAULT_USERS>
<USER userId="biadmin" password="biadmin" fullName="SpagoBI Administrator">
<ATTRIBUTE name="email" value="admin@eng.it" />
<ATTRIBUTE name="name" value="SpagoBI Administrator" />
<ROLE name="/spagobi/admin"/>
</USER>
<USER userId="bam" password="bam" fullName="Bam User">
<ATTRIBUTE name="name" value="Bam User" />
<ROLE name="/spagobi/bam"/>
</USER>
</DEFAULT_USERS>
<DEFAULT_ATTRIBUTES>
<ATTRIBUTE name="name" description="name" />
<ATTRIBUTE name="surname" description="surname" />
<ATTRIBUTE name="address" description="address" />
<ATTRIBUTE name="birth_date" description="birth date" />
<ATTRIBUTE name="email" description="email" />
</DEFAULT_ATTRIBUTES>
<DEFAULT_ROLES>
<ROLE roleName="/spagobi/tdq/admin" description="/spagobi/tdq/admin" roleTypeCD="ADMIN"/>
<ROLE roleName="/spagobi/tdq/user" description="/spagobi/tdq/user" roleTypeCD="USER"/>
<ROLE roleName="/spagobi/bam" description="/spagobi/bam" roleTypeCD="USER" />
</DEFAULT_ROLES>
</INTERNAL_PROFILING_INITIALIZER>

</SPAGOBI>
I resolved the problem of validation of a new user after migrate database of spagobi2.4.0 to spagobi 2.6.0 and apply the mysql scripts ( migrate from 2.4.0 to 2.5.0 and from 2.5.0 to 2.6.0)

before starting server I done next steps:

I suppressed all users and roles declared in spagobi.xml

I modify engin_config.xml of Jasperreport engin by adding db connexion name

after starting server, I refeshed all analytical drivers / Lov to include all rols exists

After adding a new user, and login with, I can execute All BI documents.

Thank you.

Thank you Antonnela for your answer.

at first step of migration I used mysql scripts to migrate my old DB from 2.4 to 2.5 and from 2.5 to 2.6, all was good menu voices, documents, lov ...

I lunch the server TOMCAT 6.0.24 with Java 1.6.0.??

but when I added a new user in same privileges roles as an old user,
and use it to visualize documents, I access to doc parameters and excute it,

but the next error message is shown in place of document (jasperreport) and the same report
An error has occurred. Retry later.
If the problems persists, contact the system administrator.

?
I tryed de migrate from Spagobi 2.4.0 to Spagobi 2.6.0 flowing next steps:

a- export platforme from spagobi 2.4.0 using import/export option from admin account to an achive file
b- add new roles in spagobi 2.6.0 (same roles as Spagobi 2.5.0 DB)
c- import data from achive file to Spagobi 2.6.0 (at this step all it's OK)
d- all documents, dashboard, lovs are exported
c- I can execute documents from admin or developer account

But I'v several probelms when I try to execute documents from users account:

1 - Menu options are not exported, How can'I exporte Menu composition from Spagobi 2.4.0 to Spagobi 2.6.0 ?

2 - When I test Connections created from Resources> Data source I'v no message indicats if the data source is well configured or not ?

3 - After migration I add Menu option to test if migrated documents can be used by users, only old users can execute documents,
otherwise when I add new user from Profile management > user management and fixe all options about roles, the new user can not execute any document (old doc or new doc). I'v an error message shown on the screen:

An error has occurred. Retry later.
If the problems persists, contact the system administrator.

and in logs file of Spagobi.log or localhost.log there no info about this error.

Need Help to Migrate all options from Spagobi 2.4.0 to 2.6.0

Thanks
 
Forum Index » Profile for khen.spw » Messages posted by khen.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team