Unable to get Workflow Server Working

[jamie.chalmers3]

Hi,

I am trying to get the Shark workflow server working. I have downloaded the cmdbuild-shark-2.0.3 zip file from the cmdbuild.org download site and loaded the .war file into my webapps on my tomcat6 server.

 

I have changed the context.xml file and the Shark.conf file as recommended by the README. However, despite changing the context.xml file, when I start up tomcat the shark.log file reports that it's still trying to connect to the database with the default values. (see paste below)

2012-12-31 15:55:38,049: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2012-12-31 15:55:38,107: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,109: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,111: GenericPool:getFromPool Error Exception in GenericPool:getFromPool

2012-12-31 15:55:38,295: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2012-12-31 15:55:38,296: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

Could you possibly provide a reason for this and a solution?

Many Thanks,
Jamie Chalmers

[tecnoteca]

Hi Jamie,

 

probably you changed the context.xml within the shark's webapp directory, but the original context.xml was already been copied in the $CATALINA_BASE/conf/Catalina/localhost/ directory. Please check if there is such file in that directory and change it according to your needs.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

I am trying to get the Shark workflow server working. I have downloaded the cmdbuild-shark-2.0.3 zip file from the cmdbuild.org download site and loaded the .war file into my webapps on my tomcat6 server.

 

I have changed the context.xml file and the Shark.conf file as recommended by the README. However, despite changing the context.xml file, when I start up tomcat the shark.log file reports that it's still trying to connect to the database with the default values. (see paste below)

2012-12-31 15:55:38,049: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2012-12-31 15:55:38,107: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,109: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,111: GenericPool:getFromPool Error Exception in GenericPool:getFromPool

2012-12-31 15:55:38,295: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2012-12-31 15:55:38,296: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

Could you possibly provide a reason for this and a solution?

Many Thanks,
Jamie Chalmers

 

[jamie.chalmers3]

Hi,

 

Okay so i've modified the file, however I'm still recieving errors in the shark log, now showing as follows:

 

2013-01-03 16:31:33,850: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-03 16:31:33,923: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2013-01-03 16:31:33,923: 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)

 

I'm not seeing any connection errors within the postgresql logs for that day and catalina.out isn't showing any errors for shark. I'm getting a lot of java unknown source errors in the shark log as above. 

 

Also, should I have a webapp at https://myserver/cmdbuild-shark webapp? When i go to this page I simply get: 

 

AXIS error

 

No service is available at this URL

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi Jamie,

 

probably you changed the context.xml within the shark's webapp directory, but the original context.xml was already been copied in the $CATALINA_BASE/conf/Catalina/localhost/ directory. Please check if there is such file in that directory and change it according to your needs.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

I am trying to get the Shark workflow server working. I have downloaded the cmdbuild-shark-2.0.3 zip file from the cmdbuild.org download site and loaded the .war file into my webapps on my tomcat6 server.

 

I have changed the context.xml file and the Shark.conf file as recommended by the README. However, despite changing the context.xml file, when I start up tomcat the shark.log file reports that it's still trying to connect to the database with the default values. (see paste below)

2012-12-31 15:55:38,049: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2012-12-31 15:55:38,107: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,109: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,111: GenericPool:getFromPool Error Exception in GenericPool:getFromPool

2012-12-31 15:55:38,295: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2012-12-31 15:55:38,296: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

Could you possibly provide a reason for this and a solution?

Many Thanks,
Jamie Chalmers

 

 

[tecnoteca]

Hi Jamie,

 

are you using a system/packaged version of Tomcat? We found an analogue problem when running Shark in the default Tomcat server on Ubuntu. We've got that problem when we were running Tomcat using the default user (tomcat6 in our case) but when we switch to user root all goes fine.

So, in case you are running Tomcat with a non-root user, can you try to change it to root?

 

For the question related to the "AXIS error", it's normal. We does not provide the Shark components related to the user interface.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

 

Okay so i've modified the file, however I'm still recieving errors in the shark log, now showing as follows:

 

2013-01-03 16:31:33,850: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-03 16:31:33,923: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2013-01-03 16:31:33,923: 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)

 

I'm not seeing any connection errors within the postgresql logs for that day and catalina.out isn't showing any errors for shark. I'm getting a lot of java unknown source errors in the shark log as above. 

 

Also, should I have a webapp at https://myserver/cmdbuild-shark webapp? When i go to this page I simply get: 

 

AXIS error

 

No service is available at this URL

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi Jamie,

 

probably you changed the context.xml within the shark's webapp directory, but the original context.xml was already been copied in the $CATALINA_BASE/conf/Catalina/localhost/ directory. Please check if there is such file in that directory and change it according to your needs.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

I am trying to get the Shark workflow server working. I have downloaded the cmdbuild-shark-2.0.3 zip file from the cmdbuild.org download site and loaded the .war file into my webapps on my tomcat6 server.

 

I have changed the context.xml file and the Shark.conf file as recommended by the README. However, despite changing the context.xml file, when I start up tomcat the shark.log file reports that it's still trying to connect to the database with the default values. (see paste below)

2012-12-31 15:55:38,049: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2012-12-31 15:55:38,107: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,109: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,111: GenericPool:getFromPool Error Exception in GenericPool:getFromPool

2012-12-31 15:55:38,295: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2012-12-31 15:55:38,296: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

Could you possibly provide a reason for this and a solution?

Many Thanks,
Jamie Chalmers

 

 

 

[jamie.chalmers3]

Hi Davide,

 

Thanks for the update, I'll elevatethe tomcat users privileges and try again. I'm using the yum installed tomcat 6 from the public CentOS 6,3 repo.

 

Thanks,

Jamie

 

 

 

Previously Tecnoteca wrote:

Hi Jamie,

 

are you using a system/packaged version of Tomcat? We found an analogue problem when running Shark in the default Tomcat server on Ubuntu. We've got that problem when we were running Tomcat using the default user (tomcat6 in our case) but when we switch to user root all goes fine.

So, in case you are running Tomcat with a non-root user, can you try to change it to root?

 

For the question related to the "AXIS error", it's normal. We does not provide the Shark components related to the user interface.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

 

Okay so i've modified the file, however I'm still recieving errors in the shark log, now showing as follows:

 

2013-01-03 16:31:33,850: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-03 16:31:33,923: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2013-01-03 16:31:33,923: 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)

 

I'm not seeing any connection errors within the postgresql logs for that day and catalina.out isn't showing any errors for shark. I'm getting a lot of java unknown source errors in the shark log as above. 

 

Also, should I have a webapp at https://myserver/cmdbuild-shark webapp? When i go to this page I simply get: 

 

AXIS error

 

No service is available at this URL

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi Jamie,

 

probably you changed the context.xml within the shark's webapp directory, but the original context.xml was already been copied in the $CATALINA_BASE/conf/Catalina/localhost/ directory. Please check if there is such file in that directory and change it according to your needs.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

I am trying to get the Shark workflow server working. I have downloaded the cmdbuild-shark-2.0.3 zip file from the cmdbuild.org download site and loaded the .war file into my webapps on my tomcat6 server.

 

I have changed the context.xml file and the Shark.conf file as recommended by the README. However, despite changing the context.xml file, when I start up tomcat the shark.log file reports that it's still trying to connect to the database with the default values. (see paste below)

2012-12-31 15:55:38,049: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2012-12-31 15:55:38,107: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,109: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,111: GenericPool:getFromPool Error Exception in GenericPool:getFromPool

2012-12-31 15:55:38,295: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2012-12-31 15:55:38,296: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

Could you possibly provide a reason for this and a solution?

Many Thanks,
Jamie Chalmers

 

 

 

 

[jamie.chalmers3]

Hi Davide,

 

So i've run both tomcat with elevated privelages and root user. The error I recieve is slightly different from the last as follows:

 

2013-01-04 08:37:09,938: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-04 08:37:09,939: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-04 08:37:09,939: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-04 08:37:09,939: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-04 08:37:09,989: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

java.lang.Error: Failed to make Standard Connection Allocator : com.lutris.appserver.server.sql.standard.StandardConnectionAllocator: null

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

 

So this appears to have resolved part of the issue. However, i'd rather not run tomcat as root or with root privelages.

 

Any suggestions on the above error? 

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi Jamie,

 

are you using a system/packaged version of Tomcat? We found an analogue problem when running Shark in the default Tomcat server on Ubuntu. We've got that problem when we were running Tomcat using the default user (tomcat6 in our case) but when we switch to user root all goes fine.

So, in case you are running Tomcat with a non-root user, can you try to change it to root?

 

For the question related to the "AXIS error", it's normal. We does not provide the Shark components related to the user interface.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

 

Okay so i've modified the file, however I'm still recieving errors in the shark log, now showing as follows:

 

2013-01-03 16:31:33,850: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-03 16:31:33,923: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2013-01-03 16:31:33,923: 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)

 

I'm not seeing any connection errors within the postgresql logs for that day and catalina.out isn't showing any errors for shark. I'm getting a lot of java unknown source errors in the shark log as above. 

 

Also, should I have a webapp at https://myserver/cmdbuild-shark webapp? When i go to this page I simply get: 

 

AXIS error

 

No service is available at this URL

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi Jamie,

 

probably you changed the context.xml within the shark's webapp directory, but the original context.xml was already been copied in the $CATALINA_BASE/conf/Catalina/localhost/ directory. Please check if there is such file in that directory and change it according to your needs.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

I am trying to get the Shark workflow server working. I have downloaded the cmdbuild-shark-2.0.3 zip file from the cmdbuild.org download site and loaded the .war file into my webapps on my tomcat6 server.

 

I have changed the context.xml file and the Shark.conf file as recommended by the README. However, despite changing the context.xml file, when I start up tomcat the shark.log file reports that it's still trying to connect to the database with the default values. (see paste below)

2012-12-31 15:55:38,049: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2012-12-31 15:55:38,107: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,109: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,111: GenericPool:getFromPool Error Exception in GenericPool:getFromPool

2012-12-31 15:55:38,295: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2012-12-31 15:55:38,296: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

Could you possibly provide a reason for this and a solution?

Many Thanks,
Jamie Chalmers

 

 

 

 

[jamie.chalmers3]

Hi,

 

Okay so further to this with tomcat started I can see what connections are open to the databases for each of my instances.

 

Shark is configured to use the shark role in postgres however when i check the database activity, it's showing no users connected as shark.

 

Should I see a constant connection using shark role to the database? or will this fail if the application failed to load all components?

 

Thanks,
Jamie

 

Previously Tecnoteca wrote:

Hi Jamie,

 

are you using a system/packaged version of Tomcat? We found an analogue problem when running Shark in the default Tomcat server on Ubuntu. We've got that problem when we were running Tomcat using the default user (tomcat6 in our case) but when we switch to user root all goes fine.

So, in case you are running Tomcat with a non-root user, can you try to change it to root?

 

For the question related to the "AXIS error", it's normal. We does not provide the Shark components related to the user interface.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

 

Okay so i've modified the file, however I'm still recieving errors in the shark log, now showing as follows:

 

2013-01-03 16:31:33,850: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-03 16:31:33,851: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-03 16:31:33,923: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2013-01-03 16:31:33,923: 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)

 

I'm not seeing any connection errors within the postgresql logs for that day and catalina.out isn't showing any errors for shark. I'm getting a lot of java unknown source errors in the shark log as above. 

 

Also, should I have a webapp at https://myserver/cmdbuild-shark webapp? When i go to this page I simply get: 

 

AXIS error

 

No service is available at this URL

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi Jamie,

 

probably you changed the context.xml within the shark's webapp directory, but the original context.xml was already been copied in the $CATALINA_BASE/conf/Catalina/localhost/ directory. Please check if there is such file in that directory and change it according to your needs.

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Hi,

I am trying to get the Shark workflow server working. I have downloaded the cmdbuild-shark-2.0.3 zip file from the cmdbuild.org download site and loaded the .war file into my webapps on my tomcat6 server.

 

I have changed the context.xml file and the Shark.conf file as recommended by the README. However, despite changing the context.xml file, when I start up tomcat the shark.log file reports that it's still trying to connect to the database with the default values. (see paste below)

2012-12-31 15:55:38,049: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2012-12-31 15:55:38,107: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,109: Error Exception in GenericPool:start java.sql.SQLException: Cannot get connection for URL jdbc:postgresql://localhost/${cmdbuild} : FATAL: database "${cmdbuild}" does not exist

2012-12-31 15:55:38,111: GenericPool:getFromPool Error Exception in GenericPool:getFromPool

2012-12-31 15:55:38,295: StandardAssignmentManager -> Can't work - Problems while configuring UserGroupManager!

2012-12-31 15:55:38,296: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

Could you possibly provide a reason for this and a solution?

Many Thanks,
Jamie Chalmers

 

 

 

 

[jamie.chalmers3]

Hi,

 

Any update to this?

 

Cheers,

Jamie

[tecnoteca]

Hi,

the shark aplication has always a connection pool connected to the database using the user "shark".
For example the following command will show the current pool:

 

>ps aux | grep shark

 

postgres 18398  0.0  0.1 127652  4408 ?        Ss   Jan04   0:00 postgres: shark cmdbuild-test 127.0.0.1(38683) idle                                                                     

postgres 25148  0.0  0.1 127652  4388 ?        Ss   Jan02   0:00 postgres: shark cmdbuild 127.0.0.1(60496) idle                                                                          

postgres 28505  0.0  0.1 127652  4144 ?        Ss   11:58   0:00 postgres: shark cmdbuild 127.0.0.1(50785) idle                                                                          

postgres 28736  0.0  0.1 127652  4396 ?        Ss   12:01   0:00 postgres: shark cmdbuild-test 127.0.0.1(50791) idle                                                                     

postgres 28747  0.0  0.1 127652  4128 ?        Ss   12:03   0:00 postgres: shark cmdbuild 127.0.0.1(50794) idle                                                                          

postgres 28764  0.0  0.1 127652  4396 ?        Ss   12:06   0:00 postgres: shark cmdbuild-test 127.0.0.1(50800) idle 

 

By the way, if you are not using shark you will not see any active transaction in postgres.

 

I hope that this answer will clear your doubts.

 

Best regards,

Lisa

[jamie.chalmers3]

Thanks Lisa. I was checking this in terms of activity on the database itself as opposed to resources on the system, but either shows that shark isn't running.

 

When I grep the process list I don't get anything relating to shark, which takes me back to the errors I received in the shark.log previously.

 

For clarification, I'll repost this again:

 

Latest error from shark.log when tomcat has started:

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-08 16:01:55,383: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

java.lang.Error: Failed to make Standard Connection Allocator : com.lutris.appserver.server.sql.standard.StandardConnectionAllocator: null

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

 

Some details about my server:

CentOS 6.3

2.5.32-279.11.1.el6 Kernel

Tomcat 6 (now configured to run as root)

Shark version which is included with cmdbuild2.0.3.

Connects to my test database on postgres, don't receive any DB connection errors.

 

Any Suggestions as to why I'm receiving this error when tomcat starts?

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi,

the shark aplication has always a connection pool connected to the database using the user "shark".
For example the following command will show the current pool:

 

>ps aux | grep shark

 

postgres 18398  0.0  0.1 127652  4408 ?        Ss   Jan04   0:00 postgres: shark cmdbuild-test 127.0.0.1(38683) idle                                                                     

postgres 25148  0.0  0.1 127652  4388 ?        Ss   Jan02   0:00 postgres: shark cmdbuild 127.0.0.1(60496) idle                                                                          

postgres 28505  0.0  0.1 127652  4144 ?        Ss   11:58   0:00 postgres: shark cmdbuild 127.0.0.1(50785) idle                                                                          

postgres 28736  0.0  0.1 127652  4396 ?        Ss   12:01   0:00 postgres: shark cmdbuild-test 127.0.0.1(50791) idle                                                                     

postgres 28747  0.0  0.1 127652  4128 ?        Ss   12:03   0:00 postgres: shark cmdbuild 127.0.0.1(50794) idle                                                                          

postgres 28764  0.0  0.1 127652  4396 ?        Ss   12:06   0:00 postgres: shark cmdbuild-test 127.0.0.1(50800) idle 

 

By the way, if you are not using shark you will not see any active transaction in postgres.

 

I hope that this answer will clear your doubts.

 

Best regards,

Lisa

 

[tecnoteca]

Hi Jamie,

 

just a question: are you still running the Tomcat instance where Shark is running with the root user? If not, what's happening if you do it?

 

Best regards.

 

Davide

 

Previously Jamie wrote:

Thanks Lisa. I was checking this in terms of activity on the database itself as opposed to resources on the system, but either shows that shark isn't running.

 

When I grep the process list I don't get anything relating to shark, which takes me back to the errors I received in the shark.log previously.

 

For clarification, I'll repost this again:

 

Latest error from shark.log when tomcat has started:

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.CallbackUtil' implementation of core CallbackUtilities API

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.SharkObjectFactoryExt' implementation of core SharkObjectFactory API

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.StandardToolActivityHandler' implementation of core ToolAgentManager API

2013-01-08 16:01:55,334: SharkEngineManager -> Working with 'org.enhydra.shark.logging.StandardLoggingManager' implementation of Logging API

2013-01-08 16:01:55,383: SharkEngineManager -> Can't work - Problems while configuring AssignmentManager!

java.lang.Error: Failed to make Standard Connection Allocator : com.lutris.appserver.server.sql.standard.StandardConnectionAllocator: null

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

 

Some details about my server:

CentOS 6.3

2.5.32-279.11.1.el6 Kernel

Tomcat 6 (now configured to run as root)

Shark version which is included with cmdbuild2.0.3.

Connects to my test database on postgres, don't receive any DB connection errors.

 

Any Suggestions as to why I'm receiving this error when tomcat starts?

 

Thanks,

Jamie

 

Previously Tecnoteca wrote:

Hi,

the shark aplication has always a connection pool connected to the database using the user "shark".
For example the following command will show the current pool:

 

>ps aux | grep shark

 

postgres 18398  0.0  0.1 127652  4408 ?        Ss   Jan04   0:00 postgres: shark cmdbuild-test 127.0.0.1(38683) idle                                                                     

postgres 25148  0.0  0.1 127652  4388 ?        Ss   Jan02   0:00 postgres: shark cmdbuild 127.0.0.1(60496) idle                                                                          

postgres 28505  0.0  0.1 127652  4144 ?        Ss   11:58   0:00 postgres: shark cmdbuild 127.0.0.1(50785) idle                                                                          

postgres 28736  0.0  0.1 127652  4396 ?        Ss   12:01   0:00 postgres: shark cmdbuild-test 127.0.0.1(50791) idle                                                                     

postgres 28747  0.0  0.1 127652  4128 ?        Ss   12:03   0:00 postgres: shark cmdbuild 127.0.0.1(50794) idle                                                                          

postgres 28764  0.0  0.1 127652  4396 ?        Ss   12:06   0:00 postgres: shark cmdbuild-test 127.0.0.1(50800) idle 

 

By the way, if you are not using shark you will not see any active transaction in postgres.

 

I hope that this answer will clear your doubts.

 

Best regards,

Lisa

 

 

[jamie.chalmers3]

Hi,

 

Currently I'm running tomcat shark instance as root user. Previously I was running cmdbuild 2.0.0 however have now upgraded to 2.0.3 (thought I was already running 2.0.3).

 

Shark is also on 2.0.3. I believe Shark is configured correctly, despite the error i'm getting in the Shark log as I can now see connections to the database pool when checking my processes.

 

However, I'm still unable to get CMDBuild to talk to Shark correctly.

 

Could you confirm what credentials I require to enter into the Username / Password section of the Workflow page when configuring CMDBuild.

 

Is it

 

1. Shark Database Credentials

2. Credentials of the workflow user (set out in auth.conf)

3. Credentials of Shark (set out in Shark.conf)

 

Or something else?

 

Thanks,

Jamie

 

Note: Still getting java lang null pointer exception when trying to create process classes after enabling workflow.

[tecnoteca]

Neither of these, the password is the shark application password.

Please leave the default values:

 

user=admin

password=enhydra

 

Best regards,

Lisa

[jamie.chalmers3]

Thanks Lisa,

 

I've also got my catalina.out log when the TWS server starts:

 

Together Workflow Server 4.4-1

SharkEngineManager -> Shark engine is being initialized ...

2013.01.11 13:44:46: databaseManager,ERROR: [main] Failed to make Connection Allocator :com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator creating StandardConnectionAllocator instead

2013.01.11 13:44:46: databaseManager,CRITICAL: [main] Failed to make Standard Connection Allocator : com.lutris.appserver.server.sql.standard.StandardConnectionAllocator: : null

2013.01.11 13:44:46: databaseManager,CRITICAL+ java.lang.reflect.InvocationTargetException

 

In addition, I can see shark appears to be up and running:

 

postgres 29126 28381  0 12:51 ?        00:00:00 postgres: shark postgres xxx.xxx.xxx.xxx(53038) idle

postgres 29127 28381  0 12:51 ?        00:00:00 postgres: shark CMDB_DEV xxx.xxx.xxx.xxx(53039) idle

 

Thanks,

Jamie

[jamie.chalmers3]

I have another log called DatabaseManager.log which has written out the following lines in relation to this issue:

 

2013.01.11 15:42:49: databaseManager,CRITICAL+ Caused by: com.lutris.util.ConfigException: Bad DatabaseManager.DB.sharkdb.Connection section defined in config file.

2013.01.11 15:42:49: databaseManager,CRITICAL+  at com.lutris.appserver.server.sql.standard.StandardConnectionAllocator.<init>(Unknown Source)

2013.01.11 15:42:49: databaseManager,CRITICAL+  ... 52 more

2013.01.11 15:47:22: databaseManager,ERROR: [main] Failed to make Connection Allocator :com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator creating StandardConnectionAllocator instead

2013.01.11 15:47:22: databaseManager,CRITICAL: [main] Failed to make Standard Connection Allocator : com.lutris.appserver.server.sql.standard.StandardConnectionAllocator: : null

2013.01.11 15:47:22: databaseManager,CRITICAL+ java.lang.reflect.InvocationTargetException

 

What caught my eye was the first line stating that the parameter set there was bad? Currently it's set as follows:

 

DatabaseManager.DB.sharkdb.Connection.DataSourceName=jndi:sharkdb

 

Is this correct? Do I need any pre-requisites to use JNDI and if so, what?

 

Thanks,

Jamie

[tecnoteca]

Could you please execute this command:

ps aux | grep -i catalina 

and send us the results?

 

Thanks,

Lisa

[dmitry.any]

Any update on this item?

I have the same problem on 2.0.4

 

Best regards,

Dmitry

[tecnoteca]

Dmitry could you specify better you problem and your config (which are your java, tomcat, os, shark,  versions)?

Mostly this problem is solved by running tomcat with  root.

 

Previously Dmitry wrote:

Any update on this item?

I have the same problem on 2.0.4

 

Best regards,

Dmitry

 

[dmitry.any]

Hi

 

Indeed, running with TOMCAT_USER="root" and TOMCAT_GROUP="root" in tomcat.conf solves this problem.

But I don't think that running tomcat with superuser privileges is good and secure way.

How can I locate which permissions or privileges is not enough for tomcat user?

 

java - 1.6.0_24

tomcat - 6.0.24

os - rhel 2.6.32-279.el6.x86_64

shark - i don't know how to check shark version number, it was downloaded from cmdbuild.org as shark-cmdbuild-2.0.4.zip

Any config or log files needed for analysis?

 

Best regards,

Dmitry

 

Previously Tecnoteca wrote:

Dmitry could you specify better you problem and your config (which are your java, tomcat, os, shark,  versions)?

Mostly this problem is solved by running tomcat with  root.

 

Previously Dmitry wrote:

Any update on this item?

I have the same problem on 2.0.4

 

Best regards,

Dmitry

 

 

[jackey.jackey]

需要修改连个文件的url:

cd /kingdee/tomcat/conf/Catalina/localhost/

vim cmdbuild-shark-server.xml

url="jdbc:postgresql://localhost:5432/cmdbuild"

 

 

cd /kingdee/tomcat/webapps/cmdbuild-shark-server/META-INF/

vim context.xm

url="jdbc:postgresql://localhost:5432/cmdbuild"