We ran the MySQL srcipt you sent and now we can start the application but we cannot read the data from 2.11. Can you help us?
I am attaching the screen shots from Version 2.11 and 2.14: you see the values on data entry and reports on the 2.11 but not on 2.14. I tried to run the Analytics but had an error diagnostic as well, printed in the third page of the attached screen shots. Just remembering we are operating on Apache Tomcat, MySQL, version 2.14 build 13815 and Version 2.11 build 10550.
Thank you.
···
2014-03-21 8:40 GMT-03:00 Márcio Thomé mthome@bemfam.org.br:
Hi Lars
Thanks. I’ll let you know after installation.
Best
Marcio
Enviada do meu iPhone
Em 21/03/2014, às 05:30, Lars Helge Øverland larshelge@gmail.com escreveu:
Hi Marcio,
you can find the script for mysql here:
http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/view/head:/resources/sql/convert-fixed-attributes-to-dynamic-mysql-h2.sql
The routine is:
- work on a database which has not been used with DHIS 2.14
I will put this on the home page shortly.
Lars
–
Márcio Thomé
Coordenador
Departamento de Avaliação e Estatísticas
BEMFAM - Bem Estar Familiar no Brasil
Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
Rio de Janeiro. 21941-599
Tel.: 55-21-30057207 R. 2408
Skype: Marcio-Deav
On Thu, Mar 20, 2014 at 7:10 PM, Marcio Thome mthome@bemfam.org.br wrote:
Hi Bob and Lars
We are still runing version 2.11 and being unable to upgrade to 2.14 with MySQL in Tomcat Appache, even after taking the steps you suggested.
Questions: is there an ‘upgrade’ script for MySQL similar to the one available for download at DHIS2 site for Postgre? Is there any known compatibility problem between version 2.14 and MySQL that could justify a migration from MySQL to Postgre?
Thanks for advising
Marcio
2014-03-18 13:57 GMT-03:00 Marcio Thome mthome@bemfam.org.br:
Hi Lars
Thanks for answering.
The user owning DHIS2 and MySQL is the same, declared in the hibernate.properties. This user has priviledges to create tables. The same hibernate.properties used in previous versions is maintained with no changes and it works with 2.11 version but not with the 2.14.
Márcio
–
Márcio Thomé
Coordenador
Departamento de Avaliação e Estatísticas
BEMFAM - Bem Estar Familiar no Brasil
Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
Rio de Janeiro. 21941-599
Tel.: 55-21-30057207 R. 2408
Skype: Marcio-Deav
2014-03-18 12:39 GMT-03:00 Lars Helge Øverland larshelge@gmail.com:
Hi Marcio,
check that the user you define in hibernate.properties is the same as the one that owns the dhis database, and that this user has the privilege to create tables.
Lars
–
Márcio Thomé
Coordenador
Departamento de Avaliação e Estatísticas
BEMFAM - Bem Estar Familiar no Brasil
Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
Rio de Janeiro. 21941-599
Tel.: 55-21-30057207 R. 2408
Skype: Marcio-Deav
On Tue, Mar 18, 2014 at 4:26 PM, Marcio Thome mthome@bemfam.org.br wrote:
Hi Bob
Thanks for your promtp reply. We did run the steps in the order you indicate (blank database - restore - dhis2) but at no avail. The log of errors still refer to a foreign key (see attached). Is there any known compatibility problem between DHIS2 2.14 and MySQL? I noticed a script in DHIS2 download page to upgrade for postgre but none for MySQL.
Thanks for assisting.
Best
Marcio
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
2014-03-18 11:24 GMT-03:00 Bob Jolliffe bobjolliffe@gmail.com:
Hi Marcio
The errno:150 in mysql usually refers to foreign key violations. Now I don’t know enough about what is happening here to say for sure, but it looks like you have created a new blank database, run dhis2 against it (which creates tables) and then attempted your restoration.
Can you do this the other way round, ie:
- create a new blank database
- restore your sql file
- run dhis2 (using the new database)
Bob
–
Márcio Thomé
Coordenador
Departamento de Avaliação e Estatísticas
BEMFAM - Bem Estar Familiar no Brasil
Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
Rio de Janeiro. 21941-599
Tel.: 55-21-30057207 R. 2408
Skype: Marcio-Deav
On 17 March 2014 15:01, Marcio Thome mthome@bemfam.org.br wrote:
Dear All
I am needing some help to install DHIS2 Ver. 2.14 build 13815 on APache Tomcat 7.0, MySQL version 5.2.43, Java version 7.0-07. I am attaching three logs:
- First run of DHIS
- About with the built number
- Error from MySQL: can’t create dhis2.datavalue.
I am needing to develop new reports ASAP and would like to use the functionalities of 2.14.
Thank you all.
Best
Marcio
Márcio Thomé
Coordenador
Departamento de Avaliação e Estatísticas
BEMFAM - Bem Estar Familiar no Brasil
Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
Rio de Janeiro. 21941-599
Tel.: 55-21-30057207 R. 2408
Skype: Marcio-Deav
–
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
