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
