[Building Sakai] Upgrade from 2.5.4 to 2.7.x

Warwick Chapman warwickchapman at gmail.com
Wed Jul 7 07:27:26 PDT 2010 

Thanks :) I will!

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


On Tue, Jul 6, 2010 at 11:13 PM, Nicola Monat-Jacobs
<nicola at longsight.com>wrote:

> 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>
>>> <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"
>>> >>
>>> >
>>> >
>>>
>>>
>>>
>>
>> _______________________________________________
>> 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/20100707/1019ee2a/attachment.html

More information about the sakai-dev mailing list