[Building Sakai] Upgrade from 2.5.4 to 2.7.x

Warwick Chapman warwickchapman at gmail.com
Thu Jul 1 05:52:56 PDT 2010 

Thanks Alan.  Yes, I have search the site trying to find this info but to no
avail.  Was hoping Nicola, who seems to be a Melete and Sakai user, would be
able to shed some light but it seems, perhaps that Nicola hasn't read this
thread since their last reply.
-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com


On Tue, Jun 29, 2010 at 9:33 AM, Berg, Alan <A.M.Berg at uva.nl> wrote:

>  Hi Warwick,
>
> Melete stands outside the reach of central QA from the Sakai Foundation. It
> is supported by the excellent work of the Etudes team . I assume the
> information you search for is on their website (
> http://www.etudes.org/melete.htm).
>
> However, if Nicola has an opinion I am curious to hear it.
>
> Alan B.
>
>
> 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: warwick.chapman at gmail.com on behalf of Warwick Chapman
> Sent: Tue 29-6-2010 8:11
> To: Berg, Alan
> Cc: Nicola Monat-Jacobs; sakai-dev
> Subject: Re: [Building Sakai] Upgrade from 2.5.4 to 2.7.x
>
> Nicola
>
> Can you confirm the Melete 2.7.2 does work with Sakai 2.7.x?
>
> -- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
>
>
> On Sun, Jun 27, 2010 at 10:10 PM, Warwick Chapman
> <warwickchapman at gmail.com>wrote:
>
> > 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>
> <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.htmlisprobably 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/20100701/b802500c/attachment.html

More information about the sakai-dev mailing list