[Building Sakai] Upgrade from 2.5.4 to 2.7.x

Tue Jul 6 14:13:03 PDT 2010

Sorry I didn't see your query Warwick - We're currently using Melete trunk with 2.7.x and haven't encountered any problems yet. Don't hesitate to let me know your experiences.

Nicola

On Jul 1, 2010, at  6:04 AM, Matthew Jones wrote:

> It looks like it does have pom files capable of building melete in 2.7 (pom-sakai27.xml). However since few schools are running 2.7 (even less with contrib tools) and etudes doesn't QA under 2.7, you'd probably want to be have resources to test it out quite a bit locally. 
> 
> I know when upgrading to 2.6 at Michigan we had a few integrated incompatibly issues (between gradebook, etc) for mneme. Also I know I did some local patching to melete, but that was awhile ago so don't remember the specifics offhand. We'd generated and submitted fixes for them. However, we aren't going to be upgrading or QA'ing these tools in 2.7 for at least another few months.
> 
> -Matthew
> 
> On Thu, Jul 1, 2010 at 8:52 AM, Warwick Chapman <warwickchapman at gmail.com> wrote:
> 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>
> >> ]
> >> 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"
> >>
> >
> >
> 
> 
> 
> 
> _______________________________________________
> 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/20100706/ca0c4adc/attachment.html 