CMDBuild Forum

Error:postGis

Old Versions
#1

Hi,

I have installed PostGis 1.5.2 with PostgreSQl 8.3 but I have this error: PostGis not installed.

The details are:

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.GeneratedMethodAccessor46.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	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:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)



How can I solve?
Any ideas?

Rossy
#2

Hi Rossella,

 
even if you have PostGIS installed, the database probably hasn't got those function defined (as written on the installation chapter of PostGIS itself). Assuming that...
  • the database name is cmdbuild, the username is postgres and you are working on the same machine
  • postgis is installed in /opt/postgresql/8.3/share/postgresql/contrib/postgis-1.5
...this is the best practice to create those functions in the separate "gis" schema:
 
$ psql -U postgres -h localhost cmdbuild
cmdbuild=# CREATE SCHEMA gis;
cmdbuild=# SET SEARCH_PATH TO gis, public;
cmdbuild=# \i /opt/postgresql/8.3/share/postgresql/contrib/postgis-1.5/postgis.sql
cmdbuild=# \i /opt/postgresql/8.3/share/postgresql/contrib/postgis-1.5/spatial_ref_sys.sql
cmdbuild=# ALTER DATABASE cmdbuild SET
search_path="$user", public, gis;
 
Paolo
 
1 Like