CMDBuild Forum

Can't create logical database sharkdb

Hi, 

I've managed to install cmdbuild and get it up and running but I'm not able to get shark to work. I've followed the instructions in the manual:

- deployed the war

- Changed cmdbuild's url: org.cmdbuild.ws.url=http://localhost:8080/cmdbuild/

- tested the database with: (shark:shark, workflow:changeme) combinations

- added users to cmdbuild's auth.conf -file

- changed database url: url="jdbc:postgresql://localhost/cmdbuild"

- created the shark schema and changed it's owner to shark

- tomcat is running as root

Server is running Centos 7, with 

java version "1.8.0_25"

Java(TM) SE Runtime Environment (build 1.8.0_25-b17)

Java HotSpot(TM) 64-Bit Server VM (build 25.25-b02, mixed mode)

Apache Tomcat/7.0.54, packaged installaed

Postgresql-9.3

 

Still getting theser errors. I'm out of ideas at the moment. Any help?

2016-06-01 07:06:57,849: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2016-06-01 07:06:57,850: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2016-06-01 07:06:57,850: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2016-06-01 07:06:57,850: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2016-06-01 07:06:58,429: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2016-06-01 07:06:58,429: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

com.lutris.appserver.server.sql.DatabaseManagerException: Could not create logical database sharkdb: java.lang.NullPointerException

        at com.lutris.appserver.server.sql.StandardDatabaseManager.loadLogicalDatabase(Unknown Source)

        at com.lutris.appserver.server.sql.StandardDatabaseManager.<init>(Unknown Source)

        at org.enhydra.shark.utilities.dods.DODSUtilities.init(Unknown Source)

        at org.enhydra.shark.utilities.dods.DODSUtilities.init(Unknown Source)

        at org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin.configureInternal(Unknown Source)

        at org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin.configure(Unknown Source)

        at org.enhydra.shark.assignment.StandardAssignmentManager.configure(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:483)

        at org.enhydra.shark.Shark._conf(Unknown Source)

        at org.enhydra.shark.Shark.configure(Unknown Source)

        at org.enhydra.shark.servlet.SharkInitServlet.init(SharkInitServlet.java:121)

        at javax.servlet.GenericServlet.init(GenericServlet.java:158)

        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)

        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)

        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)

        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1816)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

Caused by: java.lang.NullPointerException

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.initResultSetConcurrency(Unknown Source)

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.initConf(Unknown Source)

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.init(Unknown Source)

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.<init>(Unknown Source)

        ... 34 more

*** Caused by:

java.lang.NullPointerException

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.initResultSetConcurrency(Unknown Source)

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.initConf(Unknown Source)

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.init(Unknown Source)

        at com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.<init>(Unknown Source)

        at com.lutris.appserver.server.sql.StandardDatabaseManager.loadLogicalDatabase(Unknown Source)

        at com.lutris.appserver.server.sql.StandardDatabaseManager.<init>(Unknown Source)

        at org.enhydra.shark.utilities.dods.DODSUtilities.init(Unknown Source)

        at org.enhydra.shark.utilities.dods.DODSUtilities.init(Unknown Source)

        at org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin.configureInternal(Unknown Source)

        at org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin.configure(Unknown Source)

        at org.enhydra.shark.assignment.StandardAssignmentManager.configure(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.init(Unknown Source)

        at org.enhydra.shark.SharkEngineManager.configure(Unknown Source)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:483)

        at org.enhydra.shark.Shark._conf(Unknown Source)

        at org.enhydra.shark.Shark.configure(Unknown Source)

 

Hi, it’s the same behaviour expected when tomcat in not running as root or has some problem connecting to the db.


Also if you are pretty sure please re check:
- the filesystem permission
- the user running tomcat
- the java running tomcat
- the connection to the shark schema: the standard credential are: shark/shark. These should let you enter directly in the schema database (ignoring the public schema)
- workflow/changeme instead is a system user in CMDBuild user by shark to communicate through webservices
 
Let us know if everything seems correct.
 
Best regards,
CMDBuild Team
Hi, 
I completely installed everything from the beginning and that did the trick. 
Not sure what the problem was but now it's working
 
 
Previously Tecnoteca wrote:
Hi, it's the same behaviour expected when tomcat in not running as root or has some problem connecting to the db.

Also if you are pretty sure please re check:
- the filesystem permission
- the user running tomcat
- the java running tomcat
- the connection to the shark schema: the standard credential are: shark/shark. These should let you enter directly in the schema database (ignoring the public schema)
- workflow/changeme instead is a system user in CMDBuild user by shark to communicate through webservices
 
Let us know if everything seems correct.
 
Best regards,
CMDBuild Team