[Building Sakai] Upgrade from 2.5.4 to 2.7.x

[Warwick Chapman]

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"
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100629/3bb4dc41/attachment.html