<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Aug 2, 2013 at 11:32 AM, Kevin Falcone <span dir="ltr"><<a href="mailto:falcone@bestpractical.com" target="_blank">falcone@bestpractical.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div class="im">> I just did my test upgrade from rt 3.8.2 / mysql 5.0.75 to rt 4.0.16 / mysql 5.5.32<br>
> but session table still showing myisam.<br>
> $ mysql -e 'use rt4; show create table sessions'<br>
> | sessions | CREATE TABLE `sessions` (<br>
> `id` varbinary(32) NOT NULL DEFAULT '',<br>
> `a_session` longblob,<br>
> `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,<br>
> PRIMARY KEY (`id`)<br>
> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 |<br>
> I guess I can just ALTER the session table now?<br>
<br>
</div>Please show a log of your make upgrade-database step<br>
<br>
One of the steps explicitly drops and recreates the sessions table.</blockquote></div><br><div class="gmail_extra">~/src/rt-4.0.16# make upgrade-database</div><div class="gmail_extra">/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password</div>
<div class="gmail_extra">In order to create or update your RT database, this script needs to connect to your mysql instance on localhost (port '') as root</div><div class="gmail_extra">Please specify that user's database password below. If the user has no database</div>
<div class="gmail_extra">password, just press return.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Password: </div><div class="gmail_extra">Working with:</div><div class="gmail_extra">Type:<span class="" style="white-space:pre"> </span>mysql</div>
<div class="gmail_extra">Host:<span class="" style="white-space:pre"> </span>localhost</div><div class="gmail_extra">Port:<span class="" style="white-space:pre"> </span></div><div class="gmail_extra">Name:<span class="" style="white-space:pre"> </span>rt4</div>
<div class="gmail_extra">User:<span class="" style="white-space:pre"> </span>rt_user</div><div class="gmail_extra">DBA:<span class="" style="white-space:pre"> </span>root</div><div class="gmail_extra">Enter RT version you're upgrading from: 3.8.2</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Going to apply following upgrades:</div><div class="gmail_extra">* 3.8.3</div><div class="gmail_extra">* 3.8.4</div><div class="gmail_extra">* 3.8.6</div><div class="gmail_extra">
* 3.8.8</div><div class="gmail_extra">* 3.8.9</div><div class="gmail_extra">* 3.9.1</div><div class="gmail_extra">* 3.9.2</div><div class="gmail_extra">* 3.9.3</div><div class="gmail_extra">* 3.9.5</div><div class="gmail_extra">
* 3.9.6</div><div class="gmail_extra">* 3.9.7</div><div class="gmail_extra">* 3.9.8</div><div class="gmail_extra">* 4.0.1</div><div class="gmail_extra">* 4.0.3</div><div class="gmail_extra">* 4.0.4</div><div class="gmail_extra">
* 4.0.6</div><div class="gmail_extra">* 4.0.9</div><div class="gmail_extra">* 4.0.12</div><div class="gmail_extra">* 4.0.13</div><div class="gmail_extra"><br></div><div class="gmail_extra">Enter RT version if you want to stop upgrade at some point,</div>
<div class="gmail_extra"> or leave it blank if you want apply above upgrades: </div><div class="gmail_extra"><br></div><div class="gmail_extra">IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP</div><div class="gmail_extra">
<br></div><div class="gmail_extra">Proceed [y/N]:y</div><div class="gmail_extra">Processing 3.8.3</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 3.8.4</div><div class="gmail_extra">
Now inserting data.</div><div class="gmail_extra">Processing 3.8.6</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 3.8.8</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">
[Fri Aug 2 16:42:55 2013] [warning]: Couldn't set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32)</div><div class="gmail_extra">[Fri Aug 2 16:42:55 2013] [warning]: Couldn't set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32)</div>
<div class="gmail_extra">Processing 3.8.9</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">[Fri Aug 2 16:42:58 2013] [warning]: Use of uninitialized value in string eq at /home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm line 652, <> line 1. (/home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm:652)</div>
<div class="gmail_extra">[Fri Aug 2 16:42:58 2013] [warning]: Use of uninitialized value in string eq at /home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm line 652, <> line 1. (/home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm:652)</div>
<div class="gmail_extra">[Fri Aug 2 16:42:58 2013] [warning]: Use of uninitialized value in string eq at /home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm line 652, <> line 1. (/home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm:652)</div>
<div class="gmail_extra">Processing 3.9.1</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">[Fri Aug 2 16:43:03 2013] [warning]: Unable to grant ExecuteCode on principal 685493: NSI already has that right (./etc/upgrade/3.9.1/content:63)</div>
<div class="gmail_extra">Processing 3.9.2</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 3.9.3</div><div class="gmail_extra">Now populating database schema.</div><div class="gmail_extra">
Processing 3.9.5</div><div class="gmail_extra">Now populating database schema.</div><div class="gmail_extra">Processing 3.9.6</div><div class="gmail_extra">Now populating database schema.</div><div class="gmail_extra">Processing 3.9.7</div>
<div class="gmail_extra">Now populating database schema.</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 3.9.8</div><div class="gmail_extra">Now populating database schema.</div>
<div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">[Fri Aug 2 16:46:20 2013] [error]: You appear to be upgrading from RTFM 2.0 - We don't support upgrading this old of an RTFM yet (./etc/upgrade/3.9.8/content:11)</div>
<div class="gmail_extra">[Fri Aug 2 16:46:20 2013] [error]: We found RTFM tables in your database. Checking for content. (./etc/upgrade/3.9.8/content:14)</div><div class="gmail_extra">[Fri Aug 2 16:46:20 2013] [error]: You appear to have RTFM Articles. You can upgrade using the etc/upgrade/upgrade-articles script. Read more about it in docs/UPGRADING-4.0 (./etc/upgrade/3.9.8/content:20)</div>
<div class="gmail_extra">Processing 4.0.1</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 4.0.3</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 4.0.4</div>
<div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 4.0.6</div><div class="gmail_extra">Now populating database schema.</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">
Processing 4.0.9</div><div class="gmail_extra">Now inserting data.</div><div class="gmail_extra">Processing 4.0.12</div><div class="gmail_extra">Now populating database schema.</div><div class="gmail_extra">Processing 4.0.13</div>
<div class="gmail_extra">Now populating database schema.</div><div class="gmail_extra">Done.</div><div class="gmail_extra">root@newwebrt:~/src/rt-4.0.16# </div><br clear="all"><div><br></div>-- <br>Asif Iqbal<br>PGP Key: 0xE62693C5 KeyServer: <a href="http://pgp.mit.edu">pgp.mit.edu</a><br>
A: Because it messes up the order in which people normally read text.<br>Q: Why is top-posting such a bad thing?<br><br>
</div></div>