Hello,
I'm trying to re-install dhis+openhealth and I have this errors:
in attachment there are my config. files
* INFO 11:29:48,125 Reading datasource config file from
datasources.xml,
file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/datasources.xml
(MondrianOlapQueryProcessor.java [Thread-1])
4-nov-2008 11.29.49 org.apache.catalina.core.StandardContext listenerStart
GRAVE: Exception sending context initialized event to listener instance
of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'simpleOlapDiscoverRequest' defined in URL
[file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/routes.xml]:
Cannot resolve reference to bean 'olapQueryProcessor' while setting bean
property 'handler'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'olapQueryProcessor' defined in URL
[file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/application.xml]:
Invocation of init method failed; nested exception is
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse
results error
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'olapQueryProcessor' defined in URL
[file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/application.xml]:
Invocation of init method failed; nested exception is
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse
results error
Caused by: mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover
unparse results error
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2081)
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:132)
at
intl.who.openhealth.olap.service.MondrianOlapQueryProcessor.executeXmlaQuery(MondrianOlapQueryProcessor.java:483)
at
intl.who.openhealth.olap.service.MondrianOlapQueryProcessor.executeDiscoverQuery(MondrianOlapQueryProcessor.java:394)
at
intl.who.openhealth.olap.service.MondrianOlapQueryProcessor.init(MondrianOlapQueryProcessor.java:145)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1241)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1206)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:428)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1100)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:862)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:424)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal
error: Error while creating SQL dialect
at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
at mondrian.olap.Util.newInternal(Util.java:1083)
at mondrian.rolap.sql.SqlQuery$Dialect.create(SqlQuery.java:664)
at mondrian.rolap.RolapSchema.getDialect(RolapSchema.java:342)
at mondrian.rolap.RolapStar.<init>(RolapStar.java:168)
at mondrian.rolap.RolapSchema.makeRolapStar(RolapSchema.java:1491)
at mondrian.rolap.RolapSchema.access$500(RolapSchema.java:76)
at
mondrian.rolap.RolapSchema$RolapStarRegistry.getOrCreateStar(RolapSchema.java:1512)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:108)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:168)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:401)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:300)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:213)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:76)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:835)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:657)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:148)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:79)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:122)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:87)
at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2165)
at
mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populate(RowsetDefinition.java:3641)
at mondrian.xmla.Rowset.unparse(Rowset.java:148)
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2076)
... 54 more
Caused by: org.postgresql.util.PSQLException: FATAL: password
authentication failed for user "dhis"
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:275)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at mondrian.rolap.sql.SqlQuery$Dialect.create(SqlQuery.java:661)
... 75 more
4-nov-2008 11.29.49 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
4-nov-2008 11.29.49 org.apache.catalina.core.StandardContext start
GRAVE: Context [/openhealth-fp] startup failed due to previous errors
4-nov-2008 11.29.49 org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
4-nov-2008 11.29.50 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
4-nov-2008 11.29.50 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
4-nov-2008 11.29.51 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8180
4-nov-2008 11.29.51 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8109
4-nov-2008 11.29.51 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/219 config=null
4-nov-2008 11.29.51 org.apache.catalina.startup.Catalina start
INFO: Server startup in 49553 ms
Trí Trần Thanh ha scritto:
5432 is port defaults. that why you didn't see port number in postgres
URL. but if change default port , you must declare port number in url.
Ex:
jdbc:postgresql://199.199.199.199 <http://199.199.199.199>*:5433*/dhis2
2008/10/27 Fabio D'Ovidio <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>
Knut Staring ha scritto:
> On Thu, Oct 23, 2008 at 9:33 AM, Fabio D'Ovidio
> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>>
wrote:
>
> Hello!
>
> Knut Staring ha scritto:
> >
> > From here:
http://www.hisp.info/confluence/display/REP/Home it
> > seems ok
> > but how can I test it on my server?
> >
> >
> > I will make it available to you. Very busy today and tomorrow,
> but at
> > least by this weekend.
>
> Thank you very much for that! I'll wait :-)
> Anyway, what about this installer?
>
http://www.hisp.info/~oysts/DHIS2OH-2.0-windows-installer.exe
<http://www.hisp.info/%7Eoysts/DHIS2OH-2.0-windows-installer.exe>
>
<http://www.hisp.info/%7Eoysts/DHIS2OH-2.0-windows-installer.exe>
>
>
> Actually, that one should work. What problems did you experience
with it?
Well, the problems are related to pgsql installtion (I suppose). In
fact, I have an already PostgreSQL installation on my server on port
5432. The installer cames with a postgresql.conf on 5432 port. So I
changed it to 5433 port. Ok, it works! When trying to deploy DHIS2
it is
ok (without data). When I try to deploy openhealth it doesn't work
HTTP Status 404 - /openhealth-fp/
------------------------------------------------------------------------
*type* Status report
*message* _/openhealth-fp/_
*description* _The requested resource (/openhealth-fp/) is not
available._
------------------------------------------------------------------------
Apache Tomcat/6.0.14
In order to INSERT sample data in PGSQL, where can I download
sample sql
script?
Thank you !
--
Fabio D'Ovidio
Geospatial solutions
INOVA s.r.l.
Web : http://www.inovaos.it
Tel.: 081 197 57 600
mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
_______________________________________________
Dhis-users mailing list
[email protected] <mailto:[email protected]>
http://www.hisp.info/mailman/listinfo/dhis-users
--
Tran Thanh Tri
HISP Viet Nam
+84903670967
------------------------------------------------------------------------
_______________________________________________
Dhis-users mailing list
[email protected]
http://www.hisp.info/mailman/listinfo/dhis-users
--
Fabio D'Ovidio
Geospatial solutions
INOVA s.r.l.
Web : http://www.inovaos.it
Tel.: 081 197 57 600
mail: [EMAIL PROTECTED]
database.driverClassName=org.postgresql.Driver
database.url=jdbc:postgresql://localhost:5433/openhealth
database.username=openhealth
database.password=
# Hibernate specific properties
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.show_sql=true
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans";
xmlns:p="http://www.springframework.org/schema/p";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:util="http://www.springframework.org/schema/util";
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd";>
<description>Configuration for openhealth-fp application</description>
<!-- OLAP -->
<bean id="simpleOlap" class="intl.who.openhealth.olap.SimpleOlap">
<property name="olapQueryProcessor" ref="olapQueryProcessor"/>
</bean>
<bean id="olapQueryProcessor" class="intl.who.openhealth.olap.service.MondrianOlapQueryProcessor" init-method="init" >
<property name="dataSources" value="datasources.xml"/>
<property name="cache" ref="cache"/>
</bean>
<!-- Reporting -->
<bean id="phuMorbidityReport" class="intl.who.openhealth.reporting.MorbidityPhuReport" init-method="init">
<property name="reportTemplate" value="report.jrxml"/>
<property name="locationHierarchyName" value="Location"/>
</bean>
<bean id="printedMapReport" class="intl.who.openhealth.reporting.PrintedMapReport" init-method="init">
<property name="reportTemplate" value="print_map_report.jrxml"/>
</bean>
<!-- Mapping -->
<bean id="chloroplethMapRequestGenerator" class="intl.who.openhealth.mapping.chloropleth.ChloroplethMapRequestGenerator">
<property name="colorMap" ref="choloroplethColorMap"/>
</bean>
<bean id="choloroplethColorMap" class="intl.who.openhealth.mapping.chloropleth.ChloroplethColorMap">
<property name="colorMapProperties" value="greenColorMap.properties"/>
</bean>
<bean id="chloroplethMapLayerGenerator" class="intl.who.openhealth.mapping.chloropleth.ChloroplethMapLayerGenerator">
<property name="baseSldUrl" value="/map/sld/chloropleth"/>
<property name="baseLegendUrl" value="/map/legend/chloropleth"/>
<property name="locationToLayerMap" ref="locationToLayerMap"/>
<property name="locationToGeocodedPropertyNameMap" ref="locationToGeocodedPropertyNameMap"/>
</bean>
<bean id="mapTileRequestHandler" class="intl.who.openhealth.mapping.MapTileRequestHandler">
<property name="layerUrls">
<map>
<!-- generic static layers -->
<entry key="sat" value="http://onearth.jpl.nasa.gov/wms.cgi?layers=BMNG"/>
<entry key="elevation" value="http://onearth.jpl.nasa.gov/wms.cgi?layers=srtmplus"/>
<!-- to allow for offline borders
<entry key="political" value="http://labs.metacarta.com/cgi-bin/mapserv?map=/www/labs/map/vmap0.map&layers=basic"/>
-->
<entry key="political" value="http://localhost:8180/geoserver/wms?layers=who:WorldCountries2006"/>
<entry key="placenames" value="http://labs.metacarta.com/wms/vmap0?layers=clabel,statelabel,ctylabel"/>
<!-- to allow for offline borders
<entry key="minimap" value="http://www2.demis.nl/mapserver/Request.asp?layers=Bathymetry,Countries,Topography,Hillshading,Borders"/>
-->
<entry key="minimap" value="http://localhost:8180/geoserver/wms?layers=who:WorldCountries2006"/>
<!-- who specific layers -->
<entry key="who:world" value="http://localhost:8180/geoserver/wms?layers=who:WorldCountries2006"/>
<entry key="who:admin0" value="http://localhost:8180/geoserver/wms?layers=who:admin0"/>
<entry key="who:admin1" value="http://localhost:8180/geoserver/wms?layers=who:admin1"/>
<entry key="who:admin2" value="http://localhost:8180/geoserver/wms?layers=who:admin2"/>
<entry key="who:admin3" value="http://localhost:8180/geoserver/wms?layers=who:admin3"/>
<entry key="who:zm_adm1" value="http://localhost:8180/geoserver/wms?layers=who:zm_adm1"/>
<entry key="who:zm_adm2" value="http://localhost:8180/geoserver/wms?layers=who:zm_adm2"/>
<entry key="who:zm_adm3" value="http://localhost:8180/geoserver/wms?layers=who:zm_adm3"/>
<entry key="who:zm_adm4" value="http://localhost:8180/geoserver/wms?layers=who:zm_adm4"/>
<!-- modifications by Phil for Zambia, modified roads to point to ZM layer
<entry key="roads" value="http://localhost:8180/geoserver/wms?layers=who:main_roads"/>
<entry key="clinics" value="http://localhost:8180/geoserver/wms?layers=who:clinics"/>
added who:world,zm_adm1,zm_adm4,zm_roads,zm_lakes,HFC_GPC_ZAMBIA for clinics
-->
<entry key="roads" value="http://localhost:8180/geoserver/wms?layers=who:zm_roads"/>
<entry key="lakes" value="http://localhost:8180/geoserver/wms?layers=who:zm_lakes"/>
<entry key="clinics" value="http://localhost:8180/geoserver/wms?layers=who:HFC_GPS_ZAMBIA"/>
</map>
</property>
</bean>
<!-- Data import -->
<bean id="dataImportService" class="intl.who.openhealth.olap.service.dataimport.PoiDataImportService">
<property name="repository" ref="repository"/>
</bean>
<!-- Help -->
<bean id="uiHelper" class="intl.who.openhealth.web.helper.UIHelper">
<property name="cache" ref="cache"/>
</bean>
<bean id="dataImportFileHelper" class="intl.who.openhealth.web.helper.DataImportFileHelper">
<property name="dataImportService" ref="dataImportService"/>
</bean>
<bean id="dataEntryHelper" class="intl.who.openhealth.web.helper.DataEntryHelper" init-method="init">
<property name="locationHierarchyName" value="Location"/>
<property name="dataEntryService" ref="dataEntryService"/>
</bean>
<!-- Data entry -->
<bean id="dataEntryService" class="intl.who.openhealth.olap.service.dataentry.SimpleDataEntryService">
<property name="repository" ref="repository"/>
</bean>
<!-- Util -->
<bean id="cacheManager" class="intl.who.openhealth.util.CacheManager">
<property name="osCache" ref="cacheAdministrator"/>
</bean>
<bean id="cacheAdministrator" class="com.opensymphony.oscache.general.GeneralCacheAdministrator" destroy-method="destroy"/>
<bean id="cache" factory-bean="cacheAdministrator" factory-method="getCache"/>
</beans>
<Schema name="OpenHealth">
<Cube name="data_ou4">
<Table name="aggregateddatavalue" />
<Dimension name="Location" foreignKey="organisationunitid">
<Hierarchy hasAll="false" primaryKey="ou4id">
<Table name="view_ou4" />
<Level name="OrgUnit1" column="ou1geo" captionColumn="ou1short" type="String" uniqueMembers="true" />
<Level name="OrgUnit2" column="ou2geo" captionColumn="ou2short" type="String" uniqueMembers="true" />
<Level name="OrgUnit3" column="ou3geo" captionColumn="ou3short" type="String" uniqueMembers="true" />
<Level name="OrgUnit4" column="ou4short" type="String" uniqueMembers="true" />
</Hierarchy>
</Dimension>
<Dimension name="Dataelement" foreignKey="dataelementid" >
<Hierarchy hasAll="false" primaryKey="dataelementid">
<Table name="view_dataelement" />
<Level name="Dataelement" column="shortname" type="String" uniqueMembers="true" />
</Hierarchy>
</Dimension>
<Dimension name="Period" foreignKey="periodid">
<Hierarchy hasAll="true" primaryKey="periodid">
<Table name="view_period"/>
<Level name="Year" column="year" type="Integer" uniqueMembers="true"/>
<Level name="Month" column="monthname" type="String" uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Measure name="Datavalue" column="value" aggregator="sum" datatype="Numeric" />
</Cube>
<Cube name="ind_ou3">
<Table name="aggregatedindicatorvalue" />
<Dimension name="Location" foreignKey="organisationunitid">
<Hierarchy hasAll="false" primaryKey="ou3id">
<Table name="view_ou3" />
<Level name="OrgUnit1" column="ou1geo" captionColumn="ou1short" type="String" uniqueMembers="true" />
<Level name="OrgUnit2" column="ou2geo" captionColumn="ou2short" type="String" uniqueMembers="true" />
<Level name="OrgUnit3" column="ou3geo" captionColumn="ou3short" type="String" uniqueMembers="true" />
</Hierarchy>
</Dimension>
<Dimension name="Indicator" foreignKey="indicatorid" >
<Hierarchy hasAll="false" primaryKey="indicatorid">
<Table name="view_indicator" />
<Level name="Indicator" column="shortname" type="String" uniqueMembers="true" />
</Hierarchy>
</Dimension>
<Dimension name="Period" foreignKey="periodid">
<Hierarchy hasAll="true" primaryKey="periodid">
<Table name="view_period"/>
<Level name="Year" column="year" type="Integer" uniqueMembers="true"/>
<Level name="Month" column="monthname" type="String" uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Measure name="IndValue" column="value" aggregator="avg" datatype="Numeric" />
</Cube>
</Schema>
<?xml version="1.0" encoding="UTF-8"?>
<DataSources>
<DataSource>
<DataSourceName>OpenHealthData</DataSourceName>
<DataSourceDescription>OpenHealth Test Data</DataSourceDescription>
<URL>http://localhost:8080/openhealth-fp/xmla</URL>
<DataSourceInfo>Provider=mondrian;
Jdbc=jdbc:postgresql:5433//localhost/dhis2; JdbcDrivers=org.postgresql.Driver;
JdbcUser=dhis; JdbcPassword=; PoolNeeded=true</DataSourceInfo>
<!--
<DataSourceInfo>Provider=mondrian; Jdbc=jdbc:mysql://localhost/dhis2_sample; JdbcDrivers=com.mysql.jdbc.Driver; JdbcUser=dhis; JdbcPassword=; PoolNeeded=true</DataSourceInfo>
-->
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="OpenHealth">
<Definition>cubes.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans";
xmlns:p="http://www.springframework.org/schema/p";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:util="http://www.springframework.org/schema/util";
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd";>
<description>Configuration for mapping from the location hierarchy to layers and geocoded property names</description>
<util:map id="locationToLayerMap">
<entry key="[Location].[(All)]" value="who:admin0"/>
<entry key="[Location].[OrgUnit1]" value="who:admin0"/>
<entry key="[Location].[Province]" value="who:admin1"/>
<entry key="[Location].[OrgUnit2]" value="who:zm_adm1"/>
<entry key="[Location].[OrgUnit3]" value="who:zm_adm2"/>
<entry key="[Location].[OrgUnit4]" value="who:zm_adm3"/>
</util:map>
<util:map id="locationToGeocodedPropertyNameMap">
<entry key="[Location].[(All)]" value="LVLID"/>
<entry key="[Location].[OrgUnit1]" value="LVLID"/>
<entry key="[Location].[Province]" value="LVLID"/>
<entry key="[Location].[OrgUnit2]" value="LVLID"/>
<entry key="[Location].[OrgUnit3]" value="LVLID"/>
</util:map>
</beans>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";
version="2.4">
<display-name>WHO OpenHealth Functional Prototype</display-name>
<context-param>
<param-name>connectString</param-name>
<param-value>
Provider=mondrian;
Jdbc=jdbc:postgresql:5433//localhost/openhealth;
JdbcDrivers=org.postgresql.Driver; JdbcUser=openhealth;
JdbcPassword=openhealth;
PoolNeeded=true;
</param-value>
</context-param>
<context-param>
<param-name>namespace</param-name>
<param-value>whofp</param-value>
</context-param>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>
classpath*:tequila.xml,
classpath*:domain.xml,
classpath*:mapping.xml,
classpath*:routes.xml,
classpath*:persist.xml,
classpath*:application.xml
</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
<servlet>
<servlet-name>MondrianXmlaServlet</servlet-name>
<servlet-class>
mondrian.xmla.impl.DefaultXmlaServlet
</servlet-class>
</servlet>
<servlet>
<servlet-name>tequila</servlet-name>
<servlet-class>
org.springframework.web.servlet.DispatcherServlet
</servlet-class>
<init-param>
<param-name>namespace</param-name>
<param-value>tequila-springMVC</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>tequila</servlet-name>
<url-pattern>/prototype/*</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>MondrianXmlaServlet</servlet-name>
<url-pattern>/xmla</url-pattern>
</servlet-mapping>
</web-app>
hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis2
hibernate.connection.username = dhis
hibernate.connection.password =
hibernate.hbm2ddl.auto = update
_______________________________________________
Dhis-users mailing list
[email protected]
http://www.hisp.info/mailman/listinfo/dhis-users
