[Building Sakai] Upgrade from 2.5.4 to 2.7.x

[Berg, Alan]

Hi all,

Anthony, Seth, Matthew Jones and a few others performed a considerable amount of testing of conversion scripts between beta 8 and RC 01. There is one outstanding issue with some indexes needed in message center. If you can please pass on any feedback that differs and Jira, he will take it up in the documentation (time allowing).

Alan

Alan Berg
QA Director - The Sakai Foundation

Senior Developer / Quality Assurance
Group Education and Research Services
Central Computer Services
University of Amsterdam

http://home.uva.nl/a.m.berg




-----Original Message-----
From: sakai-dev-bounces at collab.sakaiproject.org on behalf of Daniel Merino
Sent: Fri 6/11/2010 10:15
To: Nicola Monat-Jacobs
Cc: sakai-dev at collab.sakaiproject.org List
Subject: Re: [Building Sakai] Upgrade from 2.5.4 to 2.7.x
 
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)
_______________________________________________
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"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100611/1bc33331/attachment.html