dhis2-users team mailing list archive

[Marcio Thome <mthome@xxxxxxxxxxxxx>]

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