dhis2-devs team mailing list archive

[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