dhis2-users team mailing list archive

[Ameen Mohamed <ameen@xxxxxxxxx>]

Hi

You can confirm if postgis extension is created on the db by executing
"select postgis_full_version();" and check if you get a response.

If you are getting the error even after you have confirmed postgis
creation, then please double check your db connection parameters. The db
url / username / password might be incorrect.

Also please be informed that Launchpad is officially closed. Please post
questions, comments, discussions, etc on the DHIS2 Community of Practice.

community.dhis2.org

Best regards,
Ameen


On Wed, Dec 5, 2018 at 8:45 AM Sohel Sarder <sohel.sarder@xxxxxxxxx> wrote:

> 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
>>
> _______________________________________________
> 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
>