Call: services\/json\/schema\/setup\/saveconfiguration<\/em> But the steps below may speed up others attempting to get it going.<\/p>\n Information on the process<\/strong><\/p>\n First, getting the right packages. I have postGIS 2.2 installed, see first blog on setting up<\/a>. It recommends this package.<\/p>\n Next it suggests Geoserver 2.8.3 in the same list of requirements. Ensure you have the WAR file and not the .exe file (my fist iterative mistake).<\/p>\n Here for Geoserver 2.8.3 page<\/a> and WAR download here<\/a>.<\/p>\n The references for this exercise are from CMDBuild Manuals, you can find them here:<\/a><\/p>\n On the CMDBuild forum I found the following:<\/p>\n The Problem<\/strong> <\/em><\/p>\n Hi There – I have downloaded and installed Geoserver as per Technical Manual page 48, have deleted all preinstalled workspaces and created a new one. How ever when I try and enable GIS i get the following error: PostGIS not installed.<\/em><\/p>\n From Tecnoteca<\/strong> <\/em><\/p>\n the problem concerns the PostGIS spatial database. Have you followed the correct procedure to restore them (http:\/\/www.cmdbuild.org\/file\/manuali\/technical-manual-in-english page 8) ? CMDBuild Team <\/em><\/p>\n From <http:\/\/www.cmdbuild.org\/forum\/forum-for-advanced-cmdbuild-users\/78829857?b_start=0#863640488> <\/em><\/p>\n Also<\/em><\/strong><\/p>\n Hi Andrea, when you restore of a databse containing a gis schema (as the openmaint-empty-gis.backup) you must follow the procedure explained at page 8 of CMDBuild Technical Manual (http:\/\/www.cmdbuild.org\/file\/manuali\/technical-manual-in-english). Basically you need to create a new database, create the gis schema, create the gis functions and then perform the restore of the backup. Hope this helps! Kind regards CMDBuild Team <\/em><\/p>\n From <http:\/\/www.cmdbuild.org\/forum\/forum-in-english\/902594555?b_start=0#6284086><\/em><\/p>\n From the User Manual:<\/p>\n From Page 8 of Technical Manual:<\/strong><\/p>\n <\/p>\n If you have to restore an existing database (using for example the \u201cpsql\u201d tool):<\/em><\/strong><\/p>\n $ psql … cmdbuild<\/em><\/p>\n Web site of reference: http:\/\/www.postgresql.org\/<\/a><\/em><\/p>\n Before you start messing with this part of the process, make a backup of your database. Its not a bad idea to make a backup of your whole setup actually.<\/p>\n To make a backup of your database, right click on the database (item 1 in image 2 below) and click on backup. Find a nice safe place to put this.<\/p>\n As I have 4 instances of openMAINT running (2 localhost\/2 vps) I get a bit casual about this, but you shouldn’t. OpenMAINT is like a leach and sucks hours of your time away, so try and minimise this.<\/p>\n From the above I have to go back to my original setup and 1\/ drop any GIS schemas in my Postgres Database<\/p>\n check to see that the original GIS Schema is set correctly , items 1 to 6 above, then upload the empty gis database which came with the openmaint file.<\/p>\n So the first thing you need to do is fire up your Postgrs database, if there is a gis schema already there, delete it.<\/p>\n I found, if there were functions (and I think preliminary ones has (3) then they are associated with the schema and it will not let you just DROP the schema, you need to use drop\/cascade and this deletes the functions , tables and schema. (see numbers 5 & 6)<\/p>\n When testing, if there was a gis schema already there, I just renamed it by right clicking on the schema and editing name in the properties.<\/p>\n So, after going through items 1 to 6 above you create a blank schema called gis.<\/p>\n Next you restore the openmaint-1.1-empty-gis.backup <\/strong>file by right clicking on the database you are using , in the diagram above it is item 1. “om”.<\/p>\n This seemed to have left my openmaint & shark databases intact and only updated the gis schema.<\/p>\n As you can see above, if you query the new table created (note also there are 53 functions now associated with this schema), there is a single spacial reference, which is what is required from the user manual.<\/p>\n I also just installed the Geoserver 2.8.3.war<\/strong> file in the C:\\alfresco\\tomcat\\webapps directory and then ran the bat start file to start tomcat.<\/p>\n Login : admin<\/strong><\/p>\n Pasword: geoserver<\/strong><\/p>\n As soon as its started and gone through the whole process, you need to stop Tomcat and remove the Geoserver 2.8.3.war<\/strong> file .<\/p>\n You should now have a newly created geoserver directory in the webapps directory.<\/p>\n So, start tomcat again and go to your browser localhost:8080 and when tomcat starts, go to Manager App and you will see the geoserver running.<\/p>\n Click on the geoserver name on the left and it will take you to the geoserver page<\/p>\n Go to the workspaces and create a new workspace, I called mine omgis.<\/p>\n Now we have these items up and running, we should be able to get the openMAINT setup, so fire up openMAINT as your superadmin person and go into the Data Manager Module.<\/p>\n And that is as far as I have got so far.<\/p>\n I have looked on the CMDBuild forum page and used Google Translate for the italian comments, but no success so far.<\/p>\n A couple of things I haven’t tried yet.<\/p>\n 1\/ Restore my original Database, blow away any GIS schemas in it.<\/p>\n Create a new database and restore the openmaint-1.1-empty-gis.backup <\/strong>file to that.<\/p>\n Then try and Backup the GIS schema and restore that in my original Database.<\/p>\n 2\/ Looking on my Demo VPS on Amazon, it looks like the openmaint-1.1-demo.backup<\/strong> file also has the gis schema in it too. So maybe some testing on that one to see if I can get the postGIS working there. (Update, this instance has exactly the same error as above)<\/p>\n 3\/ As usual, rather than just loading up parts in openMAINT and using, you have to delve into all the components to figure out what is happening.<\/p>\n I decided to look at the GIS ( Geographic Information System) component of OpenMAINT. I decided to test this initially on my PC. To date, I have not been able to activate the GIS component. I am stuck with the following error: Call: services\/json\/schema\/setup\/saveconfiguration ————————————————— Error: org.cmdbuild.exception.ORMException: ORM_POSTGIS_NOT_FOUND at org.cmdbuild.exception.ORMException But the steps below may […]<\/p>\n","protected":false},"author":1,"featured_media":1295,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7,9],"tags":[16,112,113,53,54,114],"class_list":["post-1290","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-maps","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\/12\/om-01.png","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-01.png","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\/1290","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=1290"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/1290\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/1295"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n —————————————————<\/em>
\n Error: org.cmdbuild.exception.ORMException: ORM_POSTGIS_NOT_FOUND<\/em>
\n at org.cmdbuild.exception.ORMException<\/em><\/p>\n\n
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-01.png\")
<\/p>\n\n
\n
Make a Backup of your Database before you start<\/h3>\n
Setting up the GIS Schema<\/h3>\n
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-03.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-02.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-04.png\")
<\/p>\nSetting up Geoserver<\/h3>\n
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-05.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-06.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-07.png\")
<\/p>\nOpenMaint setup<\/h3>\n
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-08.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2017\/12\/om-09.png\")
<\/p>\nSee part 2<\/a> for the next episode<\/h3>\n","protected":false},"excerpt":{"rendered":"