CMDBuild Forum

during enable gis

Old Versions
#1

i am new in cmdbuild please help me.  i want to integrate cmdbuild with geoserver but during enable gis in cmdbuild inside 

i already install postgis in my system and also it is running.

setup--->gis  then i get exeception like:

..........................................................

org.cmdbuild.exception.ORMException: ORM_POSTGIS_NOT_FOUND
	at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:60)
	at org.cmdbuild.config.GisProperties.setProperty(GisProperties.java:77)
	at org.cmdbuild.servlets.json.schema.Setup.saveConfiguration(Setup.java:51)
	at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	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:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)
#2

You have to locate in your system a file named postgis.sql (or lwpostgis.sql, it depends on the version of postgis) which contains the sql code for creating postgis functions and the “Geometry” data type. Execute the content of this file on your current cmdbuild database.

 
Kind regards.
 
CMDBuild Team
#3

Previously Tecnoteca wrote:

You have to locate in your system a file named postgis.sql (or lwpostgis.sql, it depends on the version of postgis) which contains the sql code for creating postgis functions and the "Geometry" data type. Execute the content of this file on your current cmdbuild database.
 
Kind regards.
 
CMDBuild Team

 

sir, i am new in cmdbuild

sir, i not able to solve my  problem.......... ,please explain briefly , after execute the contain of this file postgis.sql which located inside  postgres folder,i get same issue ....

i am using cmdbuild version cmdbuild2.0.0 and postgres version postgres2.0.3

#4

Previously Tecnoteca wrote:

You have to locate in your system a file named postgis.sql (or lwpostgis.sql, it depends on the version of postgis) which contains the sql code for creating postgis functions and the "Geometry" data type. Execute the content of this file on your current cmdbuild database.
 
Kind regards.
 
CMDBuild Team

firest thanks for replay.................................

sir, in my file system of postgres 9.0 , there is not any dir which has postgis.sql (lwpostgis.sql) and spatial_ref_sys.sql  please give me solution of this.
 
1 Like
#5

hai,

i am also getting same error , seen your anser ..............

i have exicuted the postgis.sql in cmdbuild database

......still getting same error is ther any other way

 

thanks in advance

#6

Previously bala sidda reddy wrote:

hai,

i am also getting same error , seen your anser ..............

i have exicuted the postgis.sql in cmdbuild database

......still getting same error is ther any other way

 

thanks in advance

I've the same problem.
I've used openmaint-empty-gis.backup
 
Thats all?
#7
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
1 Like