dhis2-users team mailing list archive

[Moses Marimo <marimo@xxxxxxxxx>]

I finally managed to get it to work by appending the port number on
the connection URL. The hibernate.properties file of the now working
installation is

hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class = com.mysql.jdbc.Driver
hibernate.connection.url = jdbc:mysql://localhost:3306/zimrbf
hibernate.connection.username = ****
hibernate.connection.password = ****
hibernate.hbm2ddl.auto = update



On Tue, Jul 2, 2013 at 4:25 PM, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:
> Hello Marimo,
>
> can you please post the content of your hibernate.properties file (except
> the password of course!). Could it be that you use the postgres dialect with
> a mysql connection string?
>
> regards,
>
> Lars
>
>
>
> On Tue, Jul 2, 2013 at 4:05 PM, Moses Marimo <marimo@xxxxxxxxx> wrote:
>>
>> 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
>
>



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