dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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
>