dhis2-devs team mailing list archive

[Marcio Thome <mthome@xxxxxxxxxxxxx>]

Hi Lars


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.


Best



Márcio




2014-03-21 8:40 GMT-03:00 Márcio Thomé <mthome@xxxxxxxxxxxxx>:

> 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@xxxxxxxxx>
> 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
> - apply the script
> - run DHIS 2.14
>
> I will put this on the home page shortly.
>
> Lars
>
>
>
>
>
>
>
>
> On Thu, Mar 20, 2014 at 7:10 PM, Marcio Thome <mthome@xxxxxxxxxxxxx>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@xxxxxxxxxxxxx>:
>>
>> 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
>>>
>>>
>>>
>>> 2014-03-18 12:39 GMT-03:00 Lars Helge Øverland <larshelge@xxxxxxxxx>:
>>>
>>> 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
>>>>
>>>>
>>>> On Tue, Mar 18, 2014 at 4:26 PM, Marcio Thome <mthome@xxxxxxxxxxxxx>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
>>>>>
>>>>>
>>>>> 2014-03-18 11:24 GMT-03:00 Bob Jolliffe <bobjolliffe@xxxxxxxxx>:
>>>>>
>>>>> 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:
>>>>>> 1.  create a new blank database
>>>>>> 2.  restore your sql file
>>>>>> 3.  run dhis2 (using the new database)
>>>>>>
>>>>>> Bob
>>>>>>
>>>>>>
>>>>>> On 17 March 2014 15:01, Marcio Thome <mthome@xxxxxxxxxxxxx> 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:
>>>>>>>
>>>>>>> 1. First run of DHIS
>>>>>>> 2. About with the built number
>>>>>>> 3. 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@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> 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-devs
>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> 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
>>
>
>


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

Attachment: Screen shots DHIS2-Brazil.docx
Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document