dhis2-users team mailing list archive

[Sohel Sarder <sohel.sarder@xxxxxxxxx>]

Hi,
>From pgadmin4 or CLI interface run the following command in your DB,
CREATE EXTENSION postgis;

Then restart your database and tomcat. Hope this would help you.

Thanks,
Sohel Sarder

On Wed, Dec 5, 2018 at 1:15 PM 林晓东 <lin_xd@xxxxxxx> wrote:

> hi,all
>
>   I have created the postgis extension,   stil error :
>
> * WARN  2018-12-05 14:56:52,604 A C3P0Registry mbean is already
> registered. This probably means that an application using c3p0 was
> undeployed, but not all PooledDataSources were closed prior to
> undeployment. This may lead to resource leaks over time. Please take care
> to close all PooledDataSources. (Slf4jMLog.java [localhost-startStop-2])
> * INFO  2018-12-05 14:56:54,275 Hibernate configuration loaded: dialect:
> 'org.hisp.dhis.hibernate.dialect.DhisPostgresDialect', region factory:
> 'org.hibernate.cache.ehcache.EhCacheRegionFactory', connection pool max
> size: 80 (DefaultHibernateConfigurationProvider.java
> [localhost-startStop-2])
> * ERROR 2018-12-05 14:56:54,730 Postgis extension is not installed.
> Execute "CREATE EXTENSION postgis;" as a superuser and start the
> application again. (HibernateDatabaseInfoProvider.java
> [localhost-startStop-2])
> * WARN  2018-12-05 14:56:54,731 Exception encountered during context
> initialization - cancelling refresh attempt:
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'databaseInfoProvider' defined in URL
> [jar:file:/home/wcrmyy2017/tomcat534-1/webapps/dhis/WEB-INF/lib/dhis-support-system-2.32-SNAPSHOT.jar!/META-INF/dhis/beans.xml]:
> Invocation of init method failed; nested exception is
> java.lang.IllegalStateException: Postgis extension is not installed.
> Execute "CREATE EXTENSION postgis;" as a superuser and start the
> application again. (AbstractApplicationContext.java [localhost-startStop-2])
> * ERROR 2018-12-05 14:56:54,741 Context initialization failed
> (ContextLoader.java [localhost-startStop-2])
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'databaseInfoProvider' defined in URL
> [jar:file:/home/wcrmyy2017/tomcat534-1/webapps/dhis/WEB-INF/lib/dhis-support-system-2.32-SNAPSHOT.jar!/META-INF/dhis/beans.xml]:
> Invocation of init method failed; nested exception is
> java.lang.IllegalStateException: Postgis extension is not installed.
> Execute "CREATE EXTENSION postgis;" as a superuser and start the
> application again.
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1631)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
>         at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
>         at
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
>         at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
>         at
> org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
>         at
> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
>
>
> Thanks.
> --
> 此致
>
> easy
>
> 莫愁前路无知己，天下谁人不识君。
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>