[Building Sakai] Upgrade from 2.5.4 to 2.7.x

Sun Jun 27 13:10:08 PDT 2010

Hi All

Does this mean then that Melete 2.7.2 works fine in 2.7.x?

-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com

On Fri, Jun 11, 2010 at 11:06 PM, Berg, Alan <A.M.Berg at uva.nl> wrote:

>  Great work,
>
> As always it good to have your consistent pressure on improving Sakai.
> Judging from the sparseness, looks like Anthony Whyte et al caught the bulk
> of the SQL related defects.
>
>
> 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: Nicola Monat-Jacobs [mailto:nicola at longsight.com<nicola at longsight.com>
> ]
> Sent: Fri 6/11/2010 20:13
> To: Berg, Alan
> Cc: Daniel Merino; sakai-dev at collab.sakaiproject.org
> Subject: Re: [Building Sakai] Upgrade from 2.5.4 to 2.7.x
>
> Thanks Daniel for your feedback!
>
> Alan -
> I found two minor issues with the upgrade scripts, but I'm not sure if I
> categorized them correctly.
>
> http://jira.sakaiproject.org/browse/SAK-18649
> http://jira.sakaiproject.org/browse/SAK-18648
>
> Otherwise, everything went pretty well. If I notice anything else, I'll
> definitely make JIRAs.
>
> Nicola
>
> On Jun 11, 2010, at  1:35 AM, Berg, Alan wrote:
>
> > 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.htmlis 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"
> >
> >
>
>
>
> _______________________________________________
> 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/20100627/850f455f/attachment.html 