dhis2-users team mailing list archive

[stephocay@xxxxxxxxx]

Dear Moses,

I think it is all about configuring the hibernate.properties file: this time (MySQL) drivers has to be pointed out. There is a Readme on Github If I remember, clearly specifying the formatting

Then go to manage Ur databases, Create Database (dhis2), create a user (dhis) with password (dhisUserPass), Grant all rights except the Administrative ones., assign user dhis to database dhis2.

Set the above information on the hibernate.properties file.

Follow the other steps U use on deploying on PostgreSQL,

Restart tomcat (after copying ROOT.war) or so....

Please let me know if that is NOT Clear....

Thank
Sent from my BlackBerry® smartphone provided by Airtel Uganda.

-----Original Message-----
From: Moses Marimo <marimo@xxxxxxxxx>
Sender: "Dhis2-users"
	<dhis2-users-bounces+stephocay=gmail.com@xxxxxxxxxxxxxxxxxxx>Date: Tue, 2 Jul 2013 16:05:45 
To: dhis2-users@xxxxxxxxxxxxxxxxxxx<dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: [Dhis2-users] MySQL and DHIS 2.12

Is there anyone with a good step by step tutorial of configuring DHIS2
with MySQL. I don't seem to be getting that to work though PostgreSQL
work on the same server without a problem.

I keep getting this error:
-------------------------------------------------------------

INFO: Deploying web application directory /var/lib/tomcat7/webapps/dhis
Jul 02, 2013 4:05:29 PM org.apache.catalina.loader.WebappClassLoader
validateJarFile
INFO: validateJarFile(/var/lib/tomcat7/webapps/dhis/WEB-INF/lib/geronimo-servlet_2.5_spec-1.1.2.jar)
- jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending
class: javax/servlet/Servlet.class
* INFO  2013-07-02 16:05:42,292 System property dhis2.home not set
(DefaultLocationManager.java [localhost-startStop-1])
* INFO  2013-07-02 16:05:42,295 Environment variable DHIS2_HOME points
to /home/marimo/config (DefaultLocationManager.java
[localhost-startStop-1])
* ERROR 2013-07-02 16:05:47,080 HHH000299: Could not complete schema
update (SchemaUpdate.java [localhost-startStop-1])
java.lang.NullPointerException
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:156)
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:70)
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:63)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
        at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:505)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1750)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1788)
        at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:247)
        at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:373)
        at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:358)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1547)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1485)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:323)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1393)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1134)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:522)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)





--
ICT Warehouse (Pvt) Ltd - "The Stockist of e-nnovation"
115 Leopold Takawira St / Nelson Mandela
2nd Floor St. Barbara House, Harare
Tel: +263-4-752707, +263-4-780559
Cell: +263-772-268353
Direct Line: +263-4-2933218
Website: www.ict.co.zw


Innovative solutions in Web Design and E-Commerce, Software
Engineering, Mobile and Bulk SMS Solutions, Graphic Design and
Printing, General ICT Solutions and Consultancy.

_______________________________________________
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