[Building Sakai] Sakai Upgrade

[Earle Nietzel]

Hi Phil,

If someone hasn't already mentioned it I would perform the upgrade on
a staging system and run some tests after the upgrade.

It has been my experience that the upgrade scripts don't always
execute with out any issues.

Don't worrying about the code as that is more straight forward (i.e.
just deploy the the version you want to upgrade to as Steve
mentioned).

First grab all the upgrade scripts from
<sakai-src>/reference/docs/conversion/ relates to the upgrade you need
to perform, from a 2.6.0 to a 2.8.2 on mysql I would grab:
sakai_2_6_0-2_6_1_mysql_conversion.sql
sakai_2_6_2-2_6_3_mysql_conversion.sql
sakai_2_7_0_mysql_conversion.sql
sakai_2_7_0-2_7_1_mysql_conversion.sql
sakai_2_7_1-2_7_2_mysql_conversion.sql
sakai_2_8_0_mysql_conversion.sql
sakai_2_8_0_mysql_hbm_indexes.sql
sakai_2_8_0-2_8_1_mysql_conversion.sql
sakai_2_8_1-2_8_2_mysql_conversion.sql

The load a recent copy of your database and run all the scripts above
in that order. When a script fails (which it will) you will need to
figure out why the SQL statement failed and if possible fix it, In the
end I would produce one script that when run on your database runs
without error. So this process will be very iterative until you get a
flawless script.

Then deploy the new sakai code (in this example 2.8.2 would be used)
and attach it to your recently upgraded db. If you have new tools
added you may at some point have to enable autoddl to create the
tables for those new tools.

Now your testing begins, the more testing you do the more confident
you'll feel that everything was upgraded correctly. Make sure you
create new sites and well as interact with existing sites when
testing.

I've not covered everything but this serves as a general idea for upgrading.

Good Luck,
Earle

PS Let us know how it all went!

On Sat, Aug 11, 2012 at 1:52 AM, Steve Swinsburg
<steve.swinsburg at gmail.com> wrote:
> Hi Phil,
>
> Note that Beth is talking about the database being done in a step wise manner. The source code can just be upgraded without going via the intermediates.
>
> Cheers,
> Steve
>
> Sent from my iPad
>
> On 11/08/2012, at 8:09, Beth Kirschner <bkirschn at umich.edu> wrote:
>
>> Hi Phil,
>>
>>   Updating Sakai should be done in a step-wise fashion, so I would suggest upgrading first to 2.7.0, then 2.8.0, then 2.8.1. The upgrade should involve reading the release notes, running the database conversion scripts (https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/), and bringing the instance completely up (since some releases have some run time updates that occur at boot time).
>>
>>   I've copied the sakai-dev list in case anyone has additional advice. Good luck!
>>
>> - Beth
>>
>> On Aug 9, 2012, at 3:50 PM, Philip Klump wrote:
>>
>>> Thanks for the quick response .  Initially we need to get our Saki version
>>> up to date.  We are running 2.6.0 and would like to get upgrades to the
>>> current version.  We would also like to add in Big Blue Button and see how
>>> it works.
>>>
>>> Have you used BBB and if so what do you think?
>>>
>>> Thanks for any information you can provide.
>>>
>>> Phil
>>>
>>> -----Original Message-----
>>> From: Beth Kirschner [mailto:bkirschn at umich.edu]
>>> Sent: Thursday, August 09, 2012 3:50 PM
>>> To: Klump, Philip
>>> Cc: Margaret Wagner
>>> Subject: Re: Sakai Upgrade
>>>
>>> Can you provide some more detail?
>>>
>>> Thanks,
>>> - Beth
>>>
>>> On Aug 9, 2012, at 3:33 PM, Klump, Philip wrote:
>>>
>>>> Hi Beth,
>>>> Thank you for the quick response.
>>>> I went to them initially however have not yet received a response.
>>>>
>>>> I was hoping you would be able to recommend someone in a more timely
>>> manner.
>>>>
>>>> Phil
>>>>
>>>> On Thu, Aug 9, 2012 at 3:18 PM, Beth Kirschner <bkirschn at umich.edu> wrote:
>>>> Hi Phil,
>>>>
>>>>  I'd suggest you send your questions to the
>>> <sakai-dev at collab.sakaiproject.org> with as much details as possible
>>> (existing version, target version, hardware platform, database, etc). If
>>> you're not currently a member of the sakai-dev list, you'd need to subscribe
>>> at http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>>
>>>> Good luck!
>>>> - Beth
>>>>
>>>>> ---------- Forwarded message ----------
>>>>> From: Klump, Philip <pklump at mji.edu>
>>>>> Date: Thu, Aug 9, 2012 at 3:00 PM
>>>>> Subject: Sakai Upgrade
>>>>> To: mwagner at umich.edu
>>>>> Cc: Philip Klump <pklump at mji.edu>
>>>>>
>>>>>
>>>>> Good Afternoon Ms. Wagner,
>>>>>
>>>>> We are in process of upgrading our current version of Sakai to the most
>>> current version available.
>>>>> We are a small college located in Southfield, Michigan and was wondering
>>> if you would be aware of someone local who would be able to assist us in
>>> this process.
>>>>>
>>>>> Any guidance you can provide would be appreciated.
>>>>>
>>>>> Regards,
>>>>> Phil Klump
>>>>>
>>>>
>>>>
>>>
>>>
>>
>> _______________________________________________
>> 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"