<div dir="ltr"><div><font face="tahoma,sans-serif">Did the same thing, i used this guide as a base </font></div><div><a href="http://www.math.ias.edu/~tarzadon/pages/posts/migrating-rt-3.6.4-to-rt-4.0-88.php"><font face="tahoma, sans-serif">http://www.math.ias.edu/~tarzadon/pages/posts/migrating-rt-3.6.4-to-rt-4.0-88.php</font></a></div>
<div><font face="tahoma, sans-serif"><br></font></div><div><font face="tahoma, sans-serif">but it didn't dump and restore the DB, it was big and slow, so i just copy the DB files</font></div><div><font face="tahoma, sans-serif">from Debian 5 server to a new (Virtual) Debian 6 server and fixed the DB (you'll get ERROR 1577 for MySQL)</font></div>
<div><div><font face="tahoma, sans-serif"><br></font></div><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">
<font face="tahoma, sans-serif">ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start</font></blockquote><div><font face="tahoma, sans-serif"><br></font></div>
<div><font face="tahoma, sans-serif">You'll need to run this command to fixit</font></div><div><font face="tahoma, sans-serif"><br></font></div><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">
<font face="tahoma, sans-serif">sudo mysql_upgrade -u root -h localhost -p --verbose --force</font></blockquote></div><font face="tahoma,sans-serif"><br clear="all"></font><div dir="ltr"><font face="tahoma, sans-serif">then I created the ALTER SQL-Queries && Upgrade the DB schema</font></div>
<div dir="ltr"><font face="tahoma, sans-serif"><br></font></div><div dir="ltr"><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">
<font face="tahoma, sans-serif">perl /opt/rt/rt-4.0.5/etc/upgrade/<a href="http://upgrade-mysql-schema.pl">upgrade-mysql-schema.pl</a> rt3-database dbuser dbpassword > /opt/rt/queries.sql<br>mysql -u root -p rt3-database < /opt/rt/queries.sql</font></blockquote>
</div><div dir="ltr"><font face="tahoma, sans-serif"><br></font></div><div dir="ltr"><br><font face="verdana, sans-serif" color="#999999"><b>---<br>Rabin Yasharzadehe</b></font></div><br>
<br><br><div class="gmail_quote">On Tue, Jun 12, 2012 at 9:23 PM, FrankOh <span dir="ltr"><<a href="mailto:frank.oh@red.com" target="_blank">frank.oh@red.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
OK i've searched all over the Internet and I can't seem to fix the problem.<br>
Currently in production we have RHEL (kernel 2.6.18-238.9.1.el5) with<br>
RT3.8.0 installed on mySQL <a href="tel:5.0.77" value="+9725077">5.0.77</a>. We want to move RT off of this physical<br>
box and put it on VM. At the same time upgrade to the latest RT 4.0.5.<br>
<br>
What I have done so far:<br>
- Got a backup of our DB in production using mysqldump<br>
- Created the brand new environment. Tried two different distros. Debian<br>
(Squeeze) was by far the easiest using all the tutorials and aptitude.<br>
Kernel 2.6.32-5-amd64 with RT 4.0.5 and mysql 5.1.61-0+squeeze1. Also<br>
created a Centos 6.2 (kernel 2.6.32-220.el6.x86_64) environment with RT<br>
4.0.5 and mySQL <a href="tel:5.1.61" value="+9725161">5.1.61</a>.<br>
- In both cases, RT 4.0.5 was working without any issues after the initial<br>
install. Then I deleted the "sample" DB, created a new empty db (rtdb) and<br>
imported the mySQL dump from production:<br>
<br>
"mysql --max_allowed_packet=512M -u root -p rtdb < rt.sql"<br>
<br>
After the import was complete, if i had a session open from before.. i can<br>
actually browse the RT site and see all my old information.. cool. Then I<br>
did the upgrade using the RT scripts. Since I am not migrating from prior<br>
3.8.0 and I am not moving from mySQL 4.0 to 4.1, I do not need to apply the<br>
mySQL scripts in the README. All i did after this import was:<br>
<br>
"rt-setup-database --prompt-for-dba-password --action upgrade"<br>
<br>
After a couple prompts ("current version" 3.8.0", etc) it did its upgrade<br>
process. I didn't get any errors.. however i did get some warnings.<br>
Something about if you're not using something then don't worry about it.<br>
<br>
[Sat Jun 9 20:36:36 <a href="tel:2012" value="+9722012">2012</a>] [warning]: Going to add [OLD] prefix to all<br>
templates in approvals queue. If you have never used approvals, you can<br>
safely delete all the templates with the [OLD] prefix. Leave the new<br>
Approval templates because you may eventually want to start using approvals.<br>
(./etc/upgrade/3.8.2/content:3)<br>
[Sat Jun 9 20:37:01 <a href="tel:2012" value="+9722012">2012</a>] [warning]: IMPORTANT: We're going to delete all<br>
scrips in Approvals queue and save them in 'rt-approvals-scrips-cxYO' file.<br>
(./etc/upgrade/3.8.2/content:165)<br>
<br>
[Sat Jun 9 20:37:30 <a href="tel:2012" value="+9722012">2012</a>] [warning]: Couldn't set SortOrder: That is<br>
already the current value (./etc/upgrade/3.8.8/content:32)<br>
[Sat Jun 9 20:37:30 <a href="tel:2012" value="+9722012">2012</a>] [warning]: Couldn't set SortOrder: That is<br>
already the current value (./etc/upgrade/3.8.8/content:32)<br>
<br>
The upgrade finished without a hitch. Now i see 26 tables in my DB (3.8.0,<br>
there were 21). Now again, i can browse the RT site with my imported data.<br>
<br>
Now the error....<br>
<br>
When i restart the box.. or even restart apache (httpd in Centos and apache2<br>
in Debian).. i get weird errors.<br>
<br>
Debian box (Squeeze):<br>
root@rt-migrate:~# service apache2 restart<br>
Restarting web server: apache2RT since version 3.8 has new schema for MySQL<br>
versions after 4.1.0<br>
Follow instructions in the UPGRADING.mysql file.<br>
<br>
[Wed May <a href="tel:30%2014" value="+9723014">30 14</a>:44:45 <a href="tel:2012" value="+9722012">2012</a>] [warning]: (in cleanup) Error while loading<br>
/usr/share/request-tracker4/libexec/rt-server: ModPerl::Util::exit: (120000)<br>
exit was called at /usr/share/request-tracker4/libexec/rt-server line 135 at<br>
/usr/share/perl5/Plack/Util.pm line 156.<br>
(/usr/share/request-tracker4/lib/RT.pm:353)<br>
... waiting RT since version 3.8 has new schema for MySQL versions after<br>
4.1.0<br>
Follow instructions in the UPGRADING.mysql file.<br>
<br>
[Wed May <a href="tel:30%2014" value="+9723014">30 14</a>:44:48 <a href="tel:2012" value="+9722012">2012</a>] [warning]: (in cleanup) Error while loading<br>
/usr/share/request-tracker4/libexec/rt-server: ModPerl::Util::exit: (120000)<br>
exit was called at /usr/share/request-tracker4/libexec/rt-server line 135 at<br>
/usr/share/perl5/Plack/Util.pm line 156.<br>
(/usr/share/request-tracker4/lib/RT.pm:353)<br>
<br>
Debian /var/log/apache/error.log<br>
<br>
[Wed May <a href="tel:30%2014" value="+9723014">30 14</a>:45:02 <a href="tel:2012" value="+9722012">2012</a>] [warning]: Subroutine handle_startup_error<br>
redefined at /usr/share/request-tracker4/libexec/rt-server line 240.<br>
(/usr/share/request-tracker4/libexec/rt-server:240)<br>
[Wed May <a href="tel:30%2014" value="+9723014">30 14</a>:45:02 <a href="tel:2012" value="+9722012">2012</a>] [warning]: Subroutine handle_bind_error redefined<br>
at /usr/share/request-tracker4/libexec/rt-server line 252.<br>
(/usr/share/request-tracker4/libexec/rt-server:252)<br>
RT since version 3.8 has new schema for MySQL versions after 4.1.0<br>
Follow instructions in the UPGRADING.mysql file.<br>
<br>
[Wed May <a href="tel:30%2007" value="+9723007">30 07</a>:45:15 <a href="tel:2012" value="+9722012">2012</a>] [error] [client 10.2.66.131] Error while loading<br>
/usr/share/request-tracker4/libexec/rt-server: ModPerl::Util::exit: (120000)<br>
exit was called at /usr/share/request-tracker4/libexec/rt-server line 135 at<br>
/usr/share/perl5/Plack/Util.pm line 156.\n<br>
<br>
If i browse to the server: http://<server IP>/rt I get a 500 Internal Server<br>
error.<br>
<br>
CentOS box 6.2:<br>
Restarting the httpd service doesn't display any errors. Httpd looks like it<br>
started correctly.<br>
<br>
Centos /var/log/httpd/error.log<br>
[Sat Jun 09 13:46:41 <a href="tel:2012" value="+9722012">2012</a>] [notice] Apache/<a href="tel:2.2.15" value="+9722215">2.2.15</a> (Unix) DAV/2<br>
mod_fcgid/2.3.7 PHP/5.3.3 mod_ssl/<a href="tel:2.2.15" value="+9722215">2.2.15</a> OpenSSL/1.0.0-fips configured --<br>
resuming normal operations<br>
RT since version 3.8 has new schema for MySQL versions after 4.1.0<br>
Follow instructions in the UPGRADING.mysql file.<br>
<br>
[Sat Jun 09 13:46:51 <a href="tel:2012" value="+9722012">2012</a>] [warn] [client x.x.x.x] (104)Connection reset by<br>
peer: mod_fcgid: error reading data from FastCGI server<br>
[Sat Jun 09 13:46:51 <a href="tel:2012" value="+9722012">2012</a>] [error] [client x.x.x.x] Premature end of script<br>
headers: rt-server.fcgi<br>
<br>
What does this error mean? I was doing some research and all i could find is<br>
it was a permissions issue. I chmod 777 to this file.. and also gave the<br>
whole folder permission to apache:apache (user used to start httpd). Still i<br>
get the same error. Also i was reading about Collation and character set.<br>
Could this be the problem?<br>
<br>
Please help! i've been banging my head trying to get this to work.. and<br>
possible it's a simple fix.. hopefully. I don't care what distro we get<br>
RT4.0.6 running on.. just need to make sure i can successfully migrate the<br>
old data over. Please help!!<br>
<br>
Thanks!<br>
-Frank<br>
<span class="HOEnZb"><font color="#888888">--<br>
View this message in context: <a href="http://old.nabble.com/RT-3.8.0-DB-migrate-to-4.0.5---Errors-Please-help%21-tp34001658p34001658.html" target="_blank">http://old.nabble.com/RT-3.8.0-DB-migrate-to-4.0.5---Errors-Please-help%21-tp34001658p34001658.html</a><br>
Sent from the Request Tracker - User mailing list archive at Nabble.com.<br>
<br>
</font></span></blockquote></div><br></div>