CMDBuild 1.4 and Shark Installation

Tu sei qui: Home › Supporto › Forum › Forum in English › CMDBuild 1.4 and Shark Installation

Vai al livello superiore

CMDBuild 1.4 and Shark Installation

Lasciato da Esteban il 15 dicembre 2011 alle 22:0

Hello, I want install Shark 1.4.0.2 with CMDBuild 1.4.0.2.

CMDBuild runs OK!!! But Shark no.

When install Shark I configured the content.xml with the cmdbuild PostgreSQL database:

<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource
    auth="Container"
    name="UserTransaction"
    type="javax.transaction.UserTransaction"
    jotm.timeout="180"
    factory="org.objectweb.jotm.UserTransactionFactory"/>
   <Resource
   name="sharkdb"
   auth="Container"
   type="javax.sql.DataSource"
   factory="org.objectweb.jndi.DataSourceFactory"
   maxActive="300"
   maxIdle="2"
   maxWait="5000"
   driverClassName="org.postgresql.Driver"
   username="shark"
   password="shark"
   url="jdbc:postgresql://10.6.121.106/cmdbuild"
   defaultAutoCommit="true"
   removeAbandoned="true"
   removeAbandonedTimeout="60"
   logAbandoned="true" />
</Context>

And the Shark.conf:

"#=============================================================================
# SHARK webapp properties
#-----------------------------------------------------------------------------
DatabaseManager.ConfigurationDir=/var/lib/tomcat6/webapps/shark/conf/dods

#=============================================================================
# SHARK CMDBuild properties
#-----------------------------------------------------------------------------
CMDBuild.Groovy.Repository=/var/lib/tomcat6/webapps/shark/script
CMDBuild.WS.EndPoint=http://10.6.121.106:8080/cmdbuild/services/soap/Private
CMDBuild.EndPoint=http://10.6.121.106:8080/cmdbuild/shark/
CMDBuild.WS.MaxConn=100"

But when I want access Shark via CMDBuild, show the next message in details:

org.cmdbuild.exception.CMDBWorkflowException: WF_WAPI_CONNECTION_ERROR
	at org.cmdbuild.exception.CMDBWorkflowException$WorkflowExceptionType.createException(CMDBWorkflowException.java:54)
	at org.cmdbuild.workflow.WorkflowCache.create(WorkflowCache.java:46)
	at org.cmdbuild.workflow.WorkflowCache.getInstance(WorkflowCache.java:35)
	at org.cmdbuild.elements.ProcessTypeImpl.getPackageVersions(ProcessTypeImpl.java:125)
	at org.cmdbuild.servlets.json.schema.ModWorkflow.xpdlInfo(ModWorkflow.java:115)
	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:597)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:55)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)
	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:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)

And in catalina.out:

java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist
        at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:213)
        at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
        at com.lutris.appserver.server.sql.datasource.DataSourceDBConnection.<init>(DataSourceDBConnection.java:93)
        at com.lutris.appserver.server.sql.DataSourceDBConnectionFactory.createConnection(DataSourceDBConnectionFactory.java:31)
        at com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator.createConnection(DataSourceConnectionAllocator.java:454)
        at com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator.allocate(DataSourceConnectionAllocator.java:620)
        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.allocateConnection(StandardLogicalDatabase.java:586)
        at com.lutris.appserver.server.sql.standard.StandardDBTransactionFactory.getTransaction(StandardDBTransactionFactory.java:29)
        at org.enhydra.dods.jta.SyncDBTransactionFactory.getTransaction(SyncDBTransactionFactory.java:110)
        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.createTransaction(StandardLogicalDatabase.java:619)
        at com.lutris.appserver.server.sql.StandardDatabaseManager.createTransaction(StandardDatabaseManager.java:745)
        at org.enhydra.shark.instancepersistence.data.ResourceQuery.<init>(ResourceQuery.java:183)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedResourceObject(DODSPersistentManager.java:3822)
        at org.enhydra.shark.instancepersistence.DODSPersistentManager.restoreResource(DODSPersistentManager.java:1638)
        at org.enhydra.shark.SharkUtilities.getResource(SharkUtilities.java:518)
        at org.enhydra.shark.WAPIImpl.connect(WAPIImpl.java:101)
        at org.enhydra.shark.ws.WAPIWrapper.connect(WAPIWrapper.java:50)
        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:597)
        at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
        at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
        at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
        at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
        at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
        at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)

And in cmdbuild.log:

ERROR 2011-12-15 03:31:03 [jsonrpc ] A org.cmdbuild.exception.CMDBWorkflowException occurred calling method class org.cmdbuild.servlets.json.schema.ModWorkflow.xpdlInfo: WF_WAPI_CONNECTION_ERROR

I dont understand why not found the database =$...

Thanks for your attendance, great job!!!

Re: CMDBuild 1.4 and Shark Installation

Lasciato da Tecnoteca il 16 dicembre 2011 alle 9:59

Hello Esteban,

I suppose you are changing Shark's META-INF/context.xml but Tomcat (sometimes) copies it to its ${tomcat_home}/conf/${service_name}/${webapp_name}.xml (e.g. /opt/tomcat/conf/Catalina/shark.xml).

To solve your problem you should stop Tomcat, remove the copy of the context.xml and restart it. This should be enough.

Paolo

Sviluppato da Ploneboard