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 <[email protected]> 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 <[email protected]> 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 <[email protected]>: >> >>> 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 <[email protected]>: >>> >>>> 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 <[email protected]> >>>>> 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 <[email protected]>: >>>>> >>>>>> 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 <[email protected]> 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 : [email protected] >>>>>>> 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 : [email protected] >>>>> 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 >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
