dhis2-users team mailing list archive

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