I found that the shark.war file bundled with the openMAINT download was corrupted and so downloaded another.<\/p>\n
In the later downloaded for the shark file at https:\/\/sourceforge.net\/projects\/cmdbuild\/files\/2.4.3\/shark-cmdbuild-2.4.3.zip\/download <\/strong>the shark-cmdbuild-2.4.3.zip<\/strong> file contains a readme file that states:<\/p>\n Configure shark\/conf\/Shark.conf changing the section at the end of the file<\/em> * “org.cmdbuild.ws.url” should be the root URL of CMDBuild<\/em> In shark\/META-INF\/context.xml change the name of the database, using the name<\/em> Please note that Shark uses the same db of CMDBuild, storing its data inside<\/em> The user of shark in postgres is created by CMDBuild with the following sql<\/em> CREATE ROLE shark LOGIN<\/em> Please note that the last line is absolutely needed when using Shark on<\/em> <\/p>\n When Shark is up and running, configure the workflow module in the Which I did on my VPS systems.<\/p>\n Then I broke one of my localhost versions that had workorders running and started looking at the permissions on PostgreSQL for the Shark Login.<\/p>\n For the one that I followed:<\/p>\n You will see that there are no permissions<\/p>\n Whereas the initial one that I had on my local host had:<\/p>\n <\/p>\n Superuser permissions. As soon as this was changed the workorders work fine. Cogs are the icons next to the process items of Maintenance requests<\/strong> & workorders.<\/strong><\/p>\n So the Readme.txt file basically misleads you<\/strong> to give the opposite of the permissions that you require, but suggests that only the last line is necessary.<\/p>\n Anyway, Happy Days, I now have the Server up and running and I can now:<\/p>\n 1\/ Do Space, Asset & Inventory<\/p>\n 2\/ Do Maintenance Requests & Workorders.<\/p>\n NOTE: There are a couple of misleading things in the video on corrective maintenance process to how it needs to be done.<\/p>\n Check the blog out for workorders to see what the process is.<\/p>\n 3\/ Can explore financial Management module and see what is in store for that.<\/p>\n More on this after I’ve played with it and broken it a few times.<\/p>\n I hope this helps a few of you along.<\/p>\n I had looked on the CMDBuild.org\/ forum and found others with similar issues but only the usual misleading cryptic replies from Tecnoteca on the subject, if they bothered to respond at all. ( I do wonder if they delete some of the forum question\/answers as there seems to be a dearth of information on there.<\/p>\n The way to alter the shark login role is as follows:<\/p>\n When you look at login roles – shark, it will not look as if its changed. Refresh the item and you can see that it has updated<\/p>\n ALTER ROLE shark LOGIN <\/p>\n The errors<\/strong> were pretty much as follows when looking at the C:\/tomcat\/log\/shark.txt file, the below is a portion of the log file:<\/p>\n First there is SharkUtilities -> synchronizing XPDL cache<\/strong><\/p>\n Then following that the last few lines repeat ERROR: permission denied for relation shkresourcestable<\/em><\/strong><\/p>\n Whereas the localhost<\/strong> C:\/tomcat\/log\/shark.txt shows SharkUtilities -> synchronizing XPDL cache <\/strong>and then finishes<\/p>\n So it looks as if there are problems writing to the shark tables. But, as per the CMDBuild Technical Manual (P16) we have changed ownership of this, but still there are permission issues.<\/p>\n ( I noted that the Schema was changed to owned by Shark rather than postgres, but the tables in the shark schema are all still owned by postgres, and changing individual table ownership made no difference at all, it still didn’t work)<\/p>\n","protected":false},"excerpt":{"rendered":" This has been a challenge. It has taken me a couple of weeks to crack, tinkering with it on and off. If you follow the setup for the localhost Link you are almost there. I did this setup on my Amazon AWS EC2 and Contabo servers, but both of them errored out (see errors at […]<\/p>\n","protected":false},"author":1,"featured_media":534,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,9],"tags":[16,112,113,53,54,114],"class_list":["post-529","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-openmaint-assettiger","category-openmaint-setup","tag-amfm-data-management","tag-cafm","tag-cmms","tag-facility-management","tag-facility-operations","tag-iwms"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/om120.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/om120.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=529"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/529\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/534"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n named “CMDBuild Custom Components Settings”:<\/em><\/p>\n
\n * “org.cmdbuild.ws.username” and “org.cmdbuild.ws.password” should refer to<\/em>
\n an existing user in the “serviceusers.privileged” of CMDBuild’s auth.conf<\/em><\/p>\n
\n of the CMDBuild database (ex. url=”jdbc:postgresql:\/\/localhost\/${cmdbuild}”<\/em>
\n should be changed to url=”jdbc:postgresql:\/\/localhost\/cmdbuild” for a<\/em>
\n database named “cmdbuild” in a local PostgreSQL installation).<\/em><\/p>\n
\n the “shark” schema. If you want to restore an empty schema you can run<\/em>
\n ${cmdbuild_home}\/WEB-INF\/sql\/shark_schema\/02_shark_emptydb.sql<\/em><\/p>\n
\n (${cmdbuild_home}\/WEB-INF\/sql\/shark_schema\/01_shark_user.sql)<\/em><\/p>\n
\n ENCRYPTED PASSWORD ‘md5088dfc423ab6e29229aeed8eea5ad290’<\/em>
\n NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;<\/strong><\/em>
\n ALTER ROLE shark SET search_path=pg_default,shark;<\/em><\/p>\n
\n CMDBuild’s database.<\/em><\/p>\n
\nAdministration area.<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/om120.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/om121.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/om125.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/om126.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/09\/om127.jpg\")
<\/p>\n
\nENCRYPTED PASSWORD ‘md5088dfc423ab6e29229aeed8eea5ad290’
\nSUPERUSER INHERIT CREATEDB CREATEROLE;
\nALTER ROLE shark SET search_path=pg_default,shark;<\/p>\nBackground Errors on Server Shark setup<\/h3>\n
\n
\n
\n2017-09-30 19:03:23,592: SharkEngineManager -> Working with ‘org.enhydra.shark.SharkObjectFactoryExt’ implementation of core SharkObjectFactory API
\n2017-09-30 19:03:23,592: SharkEngineManager -> Working with ‘org.enhydra.shark.StandardToolActivityHandler’ implementation of core ToolAgentManager API
\n2017-09-30 19:03:23,592: SharkEngineManager -> Working with ‘org.enhydra.shark.logging.StandardLoggingManager’ implementation of Logging API
\n2017-09-30 19:03:24,061: StandardAssignmentManager -> Working with ‘org.enhydra.shark.usergroup.DODSUserGroupManagerAdmin’ implementation of UserGroup API
\n2017-09-30 19:03:24,139: StandardAssignmentManager -> Working with ‘org.enhydra.shark.partmappersistence.DODSParticipantMappingAdmin’ implementation of ParticipantMapping API
\n2017-09-30 19:03:24,139: SharkEngineManager -> Working with ‘org.enhydra.shark.assignment.StandardAssignmentManager’ implementation of Assignment API
\n2017-09-30 19:03:24,139: Process Cache configured – max. size is 100
\n2017-09-30 19:03:24,139: Resource Cache configured – max. size is 100
\n2017-09-30 19:03:24,139: SharkEngineManager -> Working with ‘org.enhydra.shark.caching.LRUCacheMgr’ implementation of Caching API
\n2017-09-30 19:03:24,827: DODSPersistentManager -> persisting String variables into BLOB for sizes greater than 4000
\n2017-09-30 19:03:24,827: SharkEngineManager -> Working with ‘org.enhydra.shark.instancepersistence.DODSSelectivePersistenceManager’ implementation of InstancePersistence API
\n2017-09-30 19:03:24,827: DODSGlobalPersistenceManager -> persisting String data into BLOB for sizes greater than 4000
\n2017-09-30 19:03:24,827: SharkEngineManager -> Working with ‘org.enhydra.shark.globalpersistence.DODSGlobalPersistenceManager’ implementation of GlobalPersistence API
\n2017-09-30 19:03:26,186: SharkEngineManager -> Working with ‘org.cmdbuild.workflow.CMDBuildEventAuditManager’ implementation of EventAudit API
\n2017-09-30 19:03:26,233: SharkEngineManager -> Working with ‘org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager’ implementation of RepositoryPersistence API
\n2017-09-30 19:03:26,233: SharkEngineManager -> Working with ‘org.enhydra.shark.scripting.StandardScriptingManager’ implementation of Scripting API
\n2017-09-30 19:03:26,233: SharkEngineManager -> Working without Security API implementation – SecurityManager is not specified.
\n2017-09-30 19:03:26,358: StandardToolAgentManager -> Working with ‘org.enhydra.shark.appmappersistence.DODSApplicationMappingAdmin’ implementation of ApplicationMapPersistence API
\n2017-09-30 19:03:26,358: SharkEngineManager -> Working with ‘org.enhydra.shark.toolagent.StandardToolAgentManager’ implementation of ToolAgentManager API
\n2017-09-30 19:03:26,358: SharkEngineManager -> Working without wfEngineInteroperability API implementation – WfEngineInteroperability implementation is not specified.
\n2017-09-30 19:03:26,389: SharkUtilities -> synchronizing XPDL cache<\/strong><\/li>\n<\/ul>\n