[Building Sakai] Upgrade from 2.5.4 to 2.7.x

[Daniel Merino]

Hi, Nicola. I have recently migrated from 2.5.3 to 2.7.0-rc01. Looking 
on my migrated DB, I tell you between lines what I can see.

Nicola Monat-Jacobs escribió:
> Hi All -
>
> I'm looking at upgrading a 2.5.4 dev server that we have to 2.7.x and I'm trying to put together a list of db update scripts that we'll need to run. This is a mysql instance. I'm trying to establish what these scripts do and if they're necessary for my scenario. Also, any thoughts on what it takes to upgrade to 2.7.x would be much appreciated too (the confluence page for this seems to be a work in progress and thus, I don't have permission to view it yet).
>
> auto.ddl will be on, but it's been my experience that it often doesn't implement everything...
>
> sakai_2_5_5-2_5_6_mysql_conversion.sql [1]
> sakai_2_6_0_mysql_conversion.sql
> sakai_2_6_0-2_6_1_mysql_conversion.sql
> sakai_2_6_0-2_6_x_mysql_conversion005_SAK-14482.sql [2]
> sakai_2_7_0_mysql_conversion.sql
>
>   
I have applied all these patches without problems, excepting that I used 
Sitestats in 2.5.3 and I had to select which scripts to apply from the 
located here: https://source.sakaiproject.org/svn/sitestats/trunk/updating/

Also I had a little problem about case sensitive tables names, but 
nothing important.
> >From the 2.6 upgrade page [3], you'd also need to run this tool conversion, right?
> MailArchive conversion (2.5 -> 2.6): There is a database script and mailarchive-runconversion.sh that needs to be run.
>   
The fields are created with the previous scripts, but you need to run 
the script. This worked for me in 2.7.0-rc01:

mailarchive-runconversion.sh -j 
"$CATALINA_HOME/shared/lib/mysql-connector-java-5.1.6-bin.jar" -p 
"$CATALINA_HOME/sakai/sakai.properties" -k 1.1.8 -s 2.7-SNAPSHOT -m 
/home/csie/.m2-c/repository/ upgradeschema-2.6-mysql.config
> Might also need.....
>
> MSGCNTR:
> https://source.sakaiproject.org/svn/msgcntr/branches/msgcntr-2.7.x/messageforums-docs/SAK-11740_mysql.sql
>   
Already included in the scripts.
> https://source.sakaiproject.org/svn/msgcntr/branches/msgcntr-2.7.x/messageforums-docs/SAK_SAK-15052_mysql.sql
>   
SAK-15052 is about Sakai Cafe migration, maybe is something experimental?
> m2->m3 conversion script? Necessary? Not sure what this is for.
> https://source.sakaiproject.org/svn/msgcntr/branches/msgcntr-2.7.x/messageforums-docs/updating/mfr_m2-m3_mysq_conversion.sql
>   
No idea that what is this for, but the tables created in this script are 
already created and most of the indexes too. But not all.
> SAMIGO update:
> https://source.sakaiproject.org/svn/sam/branches/sakai_2-6-x/docs/auto_submit/auto_submit_mysql.sql 
>   
These values are not included in my DB, no idea that if they are necessary.
> https://source.sakaiproject.org/svn/sam/branches/samigo-2.7.x/docs/conversion/samigo_2_6_x-2_7_0_mysql_conversion.sql
>   
This seems to be included already, although about the last change 
(SAM-834) I'm not sure at all.
> MELETE
> (Not sure what version of melete our dev server is on, need to check.)
> ./melete/components/src/sql/mysql/melete27.sql
>   
Sorry, we don't use Melete here.
> ./syllabus/syllabus-app/src/sql/mysql/SAK-14291-mysql.sql see http://jira.sakaiproject.org/browse/SAK-14291
>   
These indexes are already created.
>
> Thanks!
> Nicola
>   
Hope it helps.
Best regards.
>
> [1] This script is listed on http://confluence.sakaiproject.org/display/DOC/Upgrade+%282.6%29 with the others, but according to http://collab.sakaiproject.org/pipermail/production/2010-January/000488.html is probably not necessary.
>
> [2] Small patch, can be skipped if necessary
>
> [3] http://confluence.sakaiproject.org/display/DOC/Upgrade+%282.6%29
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>   

-- 
Daniel Merino Echeverría
daniel.merino at unavarra.es
Gestor de teleformación - Centro Superior de Innovación Educativa.
Tfno: 948-168489 - Universidad Pública de Navarra.
--
Donde todos piensan igual nadie piensa mucho. (Walter Lippmann)