OK i've searched all over the Internet and I can't seem to fix the problem. Currently in production we have RHEL (kernel 2.6.18-238.9.1.el5) with RT3.8.0 installed on mySQL 5.0.77. We want to move RT off of this physical box and put it on VM. At the same time upgrade to the latest RT 4.0.5.
What I have done so far: - Got a backup of our DB in production using mysqldump - Created the brand new environment. Tried two different distros. Debian (Squeeze) was by far the easiest using all the tutorials and aptitude. Kernel 2.6.32-5-amd64 with RT 4.0.5 and mysql 5.1.61-0+squeeze1. Also created a Centos 6.2 (kernel 2.6.32-220.el6.x86_64) environment with RT 4.0.5 and mySQL 5.1.61. - In both cases, RT 4.0.5 was working without any issues after the initial install. Then I deleted the "sample" DB, created a new empty db (rtdb) and imported the mySQL dump from production: "mysql --max_allowed_packet=512M -u root -p rtdb < rt.sql" After the import was complete, if i had a session open from before.. i can actually browse the RT site and see all my old information.. cool. Then I did the upgrade using the RT scripts. Since I am not migrating from prior 3.8.0 and I am not moving from mySQL 4.0 to 4.1, I do not need to apply the mySQL scripts in the README. All i did after this import was: "rt-setup-database --prompt-for-dba-password --action upgrade" After a couple prompts ("current version" 3.8.0", etc) it did its upgrade process. I didn't get any errors.. however i did get some warnings. Something about if you're not using something then don't worry about it. [Sat Jun 9 20:36:36 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) [Sat Jun 9 20:37:01 2012] [warning]: IMPORTANT: We're going to delete all scrips in Approvals queue and save them in 'rt-approvals-scrips-cxYO' file. (./etc/upgrade/3.8.2/content:165) [Sat Jun 9 20:37:30 2012] [warning]: Couldn't set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32) [Sat Jun 9 20:37:30 2012] [warning]: Couldn't set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32) The upgrade finished without a hitch. Now i see 26 tables in my DB (3.8.0, there were 21). Now again, i can browse the RT site with my imported data. Now the error.... When i restart the box.. or even restart apache (httpd in Centos and apache2 in Debian).. i get weird errors. Debian box (Squeeze): root@rt-migrate:~# service apache2 restart Restarting web server: apache2RT since version 3.8 has new schema for MySQL versions after 4.1.0 Follow instructions in the UPGRADING.mysql file. [Wed May 30 14:44:45 2012] [warning]: (in cleanup) Error while loading /usr/share/request-tracker4/libexec/rt-server: ModPerl::Util::exit: (120000) exit was called at /usr/share/request-tracker4/libexec/rt-server line 135 at /usr/share/perl5/Plack/Util.pm line 156. (/usr/share/request-tracker4/lib/RT.pm:353) ... waiting RT since version 3.8 has new schema for MySQL versions after 4.1.0 Follow instructions in the UPGRADING.mysql file. [Wed May 30 14:44:48 2012] [warning]: (in cleanup) Error while loading /usr/share/request-tracker4/libexec/rt-server: ModPerl::Util::exit: (120000) exit was called at /usr/share/request-tracker4/libexec/rt-server line 135 at /usr/share/perl5/Plack/Util.pm line 156. (/usr/share/request-tracker4/lib/RT.pm:353) Debian /var/log/apache/error.log [Wed May 30 14:45:02 2012] [warning]: Subroutine handle_startup_error redefined at /usr/share/request-tracker4/libexec/rt-server line 240. (/usr/share/request-tracker4/libexec/rt-server:240) [Wed May 30 14:45:02 2012] [warning]: Subroutine handle_bind_error redefined at /usr/share/request-tracker4/libexec/rt-server line 252. (/usr/share/request-tracker4/libexec/rt-server:252) RT since version 3.8 has new schema for MySQL versions after 4.1.0 Follow instructions in the UPGRADING.mysql file. [Wed May 30 07:45:15 2012] [error] [client 10.2.66.131] Error while loading /usr/share/request-tracker4/libexec/rt-server: ModPerl::Util::exit: (120000) exit was called at /usr/share/request-tracker4/libexec/rt-server line 135 at /usr/share/perl5/Plack/Util.pm line 156.\n If i browse to the server: http://<server IP>/rt I get a 500 Internal Server error. CentOS box 6.2: Restarting the httpd service doesn't display any errors. Httpd looks like it started correctly. Centos /var/log/httpd/error.log [Sat Jun 09 13:46:41 2012] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.7 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations RT since version 3.8 has new schema for MySQL versions after 4.1.0 Follow instructions in the UPGRADING.mysql file. [Sat Jun 09 13:46:51 2012] [warn] [client x.x.x.x] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server [Sat Jun 09 13:46:51 2012] [error] [client x.x.x.x] Premature end of script headers: rt-server.fcgi What does this error mean? I was doing some research and all i could find is it was a permissions issue. I chmod 777 to this file.. and also gave the whole folder permission to apache:apache (user used to start httpd). Still i get the same error. Also i was reading about Collation and character set. Could this be the problem? Please help! i've been banging my head trying to get this to work.. and possible it's a simple fix.. hopefully. I don't care what distro we get RT4.0.6 running on.. just need to make sure i can successfully migrate the old data over. Please help!! Thanks! -Frank -- View this message in context: http://old.nabble.com/RT-3.8.0-DB-migrate-to-4.0.5---Errors-Please-help%21-tp34001658p34001658.html Sent from the Request Tracker - User mailing list archive at Nabble.com.