<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi,<div><br></div><div><div>New install for RT 4</div><div>Centos 6.3 running in OSX Parrallels container (test server)</div><div>MySQL 5.1.61</div><div>Perl v5.10.1</div><div>mod_perl 2.0.4-10</div><div>mod_fastcgi-2.4.6</div><div><br></div><div>I am in the process of upgrade our RT environment from 3.2.2 to 4.0.7. So far I have been able to upgrade successfully from 3.2.2 to 3.8.1. However, when I run the $ make upgrade-database from 3.8.1 to 3.8.2 I received the following error:</div><div><br></div><div>FYI this is my first exposure to RT.</div><div><br></div><div><div>$ make upgrade-database</div><div>/usr/local/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password</div><div>In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root</div><div>Please specify that user's database password below. If the user has no database</div><div>password, just press return.</div><div><br></div><div>Password: </div><div>Working with:</div><div>Type:<span class="Apple-tab-span" style="white-space:pre"> </span>mysql</div><div>Host:<span class="Apple-tab-span" style="white-space:pre"> </span>localhost</div><div>Name:<span class="Apple-tab-span" style="white-space:pre"> </span>rt3</div><div>User:<span class="Apple-tab-span" style="white-space:pre"> </span>rt_user</div><div>DBA:<span class="Apple-tab-span" style="white-space:pre"> </span>root</div><div>Enter RT version you're upgrading from: 3.8.1</div><div><br></div><div>Going to apply following upgrades:</div><div>* 3.8.2</div><div>* 3.8.3</div><div>* 3.8.4</div><div>* 3.8.6</div><div>* 3.8.8</div><div>* 3.8.9</div><div>* 3.9.1</div><div>* 3.9.2</div><div>* 3.9.3</div><div>* 3.9.5</div><div>* 3.9.6</div><div>* 3.9.7</div><div>* 3.9.8</div><div>* 4.0.0rc2</div><div>* 4.0.0rc4</div><div>* 4.0.0rc7</div><div>* 4.0.1</div><div>* 4.0.3</div><div>* 4.0.4</div><div>* 4.0.6</div><div><br></div><div>Enter RT version if you want to stop upgrade at some point,</div><div> or leave it blank if you want apply above upgrades: 3.8.2</div><div><br></div><div>Going to apply following upgrades:</div><div>* 3.8.2</div><div><br></div><div>IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP</div><div><br></div><div>Proceed [y/N]:y</div><div>Processing 3.8.2</div><div>Now inserting data.</div><div>[Mon Oct 22 20:54:57 2012] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used approvals, you can safely delete all the templates with the [OLD] prefix. Leave the new Approval templates because you may eventually want to start using approvals. (./etc/upgrade/3.8.2/content:3)</div><div>[Mon Oct 22 20:54:58 2012] [warning]: DBD::mysql::st execute failed: Unknown column 'Creator' in 'field list' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)</div><div>[Mon Oct 22 20:54:58 2012] [warning]: RT::Handle=HASH(0x2a71a48) couldn't execute the query 'INSERT INTO ACL (PrincipalId, RightName, Creator, ObjectId, LastUpdatedBy, PrincipalType, Created, LastUpdated, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x2a71a48)', 'INSERT INTO ACL (PrincipalId, RightName, Creator, ObjectId, L...', 4, 'ShowApprovalsTab', 1, 1, 1, 'Group', '2012-10-22 20:54:58', ...) called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 350</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x2a71a48)', 'ACL', 'PrincipalId', 4, 'RightName', 'ShowApprovalsTab', 'Creator', 1, 'ObjectId', ...) called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm line 36</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x2a71a48)', 'ACL', 'PrincipalId', 4, 'RightName', 'ShowApprovalsTab', 'Creator', 1, 'ObjectId', ...) called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1292</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>DBIx::SearchBuilder::Record::Create('RT::ACE=HASH(0x4a0e560)', 'PrincipalId', 4, 'Creator', 1, 'RightName', 'ShowApprovalsTab', 'ObjectId', 1, ...) called at /tmp/rt-4.0.7/sbin/../lib/RT/Record.pm line 316</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Record::Create('RT::ACE=HASH(0x4a0e560)', 'PrincipalId', 4, 'PrincipalType', 'Group', 'RightName', 'ShowApprovalsTab', 'ObjectType', 'RT::System', ...) called at /tmp/rt-4.0.7/sbin/../lib/RT/ACE.pm line 291</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::ACE::Create('RT::ACE=HASH(0x4a0e560)', 'RightName', 'ShowApprovalsTab', 'Object', 'RT::System=HASH(0x48296c8)', 'PrincipalType', 'Group', 'PrincipalId', 4, ...) called at /tmp/rt-4.0.7/sbin/../lib/RT/Principal.pm line 172</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Principal::GrantRight('RT::Principal=HASH(0x3ebbd38)', 'Right', 'ShowApprovalsTab', 'Object', 'RT::System=HASH(0x48296c8)') called at /tmp/rt-4.0.7/sbin/../lib/RT/Handle.pm line 964</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Handle::InsertData('RT::Handle=HASH(0x2a71a48)', './etc/upgrade/3.8.2/content', undef) called at sbin/rt-setup-database line 293</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>main::action_insert('prompt-for-dba-password', 1, 'datafile', undef, 'action', 'upgrade', 'datadir', './etc/upgrade/3.8.2', 'backcompat', ...) called at sbin/rt-setup-database line 399</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>main::action_upgrade('prompt-for-dba-password', 1, 'action', 'upgrade', 'dba', 'root') called at sbin/rt-setup-database line 198 (/usr/share/perl5/Carp.pm:103)</div><div>[Mon Oct 22 20:54:58 2012] [error]: System error. Right not granted. (/tmp/rt-4.0.7/sbin/../lib/RT/Handle.pm:969)</div><div>[Mon Oct 22 20:54:58 2012] [warning]: IMPORTANT: We're going to delete all scrips in Approvals queue and save them in 'rt-approvals-scrips-XcRt' file. (./etc/upgrade/3.8.2/content:165)</div><div>Done.</div></div><div><br></div><div><br></div><div><br></div><div apple-content-edited="true">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="font-style: normal; color: rgb(0, 0, 0); ">Kind Regards,</div><div style="font-style: normal; color: rgb(0, 0, 0); "><br></div><div style="font-style: normal; "><font class="Apple-style-span" color="#005192">Cynthia Roe</font></div><div><font class="Apple-style-span" color="#005192"><i>Sr. Unix Administrator</i></font></div><div style="font-style: normal; "><font class="Apple-style-span" color="#005192">Rutgers Marine and Coastal Science</font></div><div style="font-style: normal; "><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; "><font class="Apple-style-span" color="#005192">71 Dudley Road, New Brunswick, NJ 08901-8525</font></span></div><div style="font-style: normal; "><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; "><font class="Apple-style-span" color="#005192">Cell (732) 882-6079</font></span></div><div style="font-style: normal; "><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; "><font class="Apple-style-span" color="#005192">Office (848) 932-3370</font></span></div></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br></div></body></html>