I’m in the process of migrating from RT2 to the latest RT4. In reading the archives and various posts I’ve been able to figure out that I need to dump the RT2 database which was successful (via RT-Extension-RT2toRT3). I’m assuming the next step in the process is to install RT3 to reimport the dump data to it and then upgrade to RT4.
1. Is it important that I upgrade to 3.0.0 or does any 3.0.x or 3.x.x version work for this part of the process? 2. Is there is a better way to go about upgrading from RT2 to RT4? Dev System details: OS: Debian 8 (VMWare Wks guest) MySQL: 5.5 In trying to install RT3 (3.0.0) I keep running into errors during the ‘make initialize-database’ phase. I don’t think that it’s a database issue yet, it seems that Perl is having issues with the scripts and/or something I’m missing on my system. All Perl deps are met: root@rt3:/home/bdk/rt-3-0-0# make testdeps | grep -i missing root@rt3:/home/bdk/rt-3-0-0# Configure options: root@rt3:/home/bdk/rt-3-0-0# ./configure --prefix=/srv/rt3 --with-web-user=www-data --with-web-group=www-data --with-rt-group=www-data --with-db-rt-user=rt3 --with-db-rt-pass=rt3 I get 2 errors that I don’t think will amount to much: cp -rp ./local/html/* //srv/rt3/local/html cp: cannot stat ‘./local/html/*’: No such file or directory Makefile:398: recipe for target 'local-install' failed make: [local-install] Error 1 (ignored) cp -rp ./local/po/* //srv/rt3/local/po cp: cannot stat ‘./local/po/*’: No such file or directory Makefile:398: recipe for target 'local-install' failed make: [local-install] Error 1 (ignored) The rest of the install goes good: Congratulations. RT has been installed. You must now configure RT by editing /srv/rt3/etc/RT_SiteConfig.pm. (You will definitely need to set RT's database password before continuing. Not doing so could be very dangerous) After that, you need to initialize RT's database by running 'make initialize-database' I checked /srv/rt3/etc/RT_Config.pm and the correct database name, user & password are set there via my earlier config. The next step is where I get hung up: root@rt3:/home/bdk/rt-3-0-0# make initialize-database /usr/bin/perl //srv/rt3/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/ at /srv/rt3/lib/RT/Date.pm line 127. Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )-(\d\d)-(\d\d) (\d\d):(\d\d):(\d\d)$/ at /srv/rt3/lib/RT/Date.pm line 129. Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )-(\d\d)-(\d\d) (\d\d):(\d\d):(\d\d)\+00$/ at /srv/rt3/lib/RT/Date.pm line 131. Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )(\d\d)(\d\d)(\d\d):(\d\d):(\d\d)$/ at /srv/rt3/lib/RT/Date.pm line 132. "my" variable $attr masks earlier declaration in same statement at /srv/rt3/lib/RT/Ticket_Overlay.pm line 476. "my" variable %params masks earlier declaration in same statement at /srv/rt3/lib/RT/Ticket_Overlay.pm line 476. "my" variable $attr masks earlier declaration in same statement at /srv/rt3/lib/RT/Ticket_Overlay.pm line 476. "my" variable %params masks earlier declaration in same statement at /srv/rt3/lib/RT/Ticket_Overlay.pm line 476. "my" variable $attr masks earlier declaration in same statement at /srv/rt3/lib/RT/Ticket_Overlay.pm line 476. "my" variable %params masks earlier declaration in same statement at /srv/rt3/lib/RT/Ticket_Overlay.pm line 480. Variable "$QueueObj" is not imported at /srv/rt3/lib/RT/Ticket_Overlay.pm line 586. (Did you mean &QueueObj instead?) Variable "$QueueObj" is not imported at /srv/rt3/lib/RT/Ticket_Overlay.pm line 589. (Did you mean &QueueObj instead?) Variable "$QueueObj" is not imported at /srv/rt3/lib/RT/Ticket_Overlay.pm line 607. (Did you mean &QueueObj instead?) syntax error at /srv/rt3/lib/RT/Ticket_Overlay.pm line 470, near "$attr qw(id Creator Created LastUpdated LastUpdatedBy)" Global symbol "$attr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 471. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 471. Global symbol "$attr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 471. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 471. Global symbol "$attr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 471. Global symbol "$self" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 482. Global symbol "$id" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 482. Global symbol "$Owner" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 502. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 508. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 510. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 510. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 510. Global symbol "@non_fatal_errors" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 535. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 544. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 546. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 546. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 546. Global symbol "@non_fatal_errors" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 554. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 562. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 566. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 566. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 566. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 576. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 581. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 586. Global symbol "$QueueObj" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 586. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 587. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 587. Global symbol "@non_fatal_errors" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 587. Global symbol "$QueueObj" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 589. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 595. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 600. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 607. Global symbol "$QueueObj" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 607. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 608. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 608. Global symbol "@non_fatal_errors" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 608. Global symbol "$ErrStr" requires explicit package name at /srv/rt3/lib/RT/Ticket_Overlay.pm line 609. syntax error at /srv/rt3/lib/RT/Ticket_Overlay.pm line 612, near "}" /srv/rt3/lib/RT/Ticket_Overlay.pm has too many errors. Compilation failed in require at (eval 105) line 2. Compilation failed in require at /srv/rt3/lib/RT/TicketCustomFieldValue.pm line 49. BEGIN failed--compilation aborted at /srv/rt3/lib/RT/TicketCustomFieldValue.pm line 49. Compilation failed in require at /srv/rt3/lib/RT/TicketCustomFieldValues.pm line 51. BEGIN failed--compilation aborted at /srv/rt3/lib/RT/TicketCustomFieldValues.pm line 51. Compilation failed in require at /srv/rt3/lib/RT/CustomField_Overlay.pm line 30. BEGIN failed--compilation aborted at /srv/rt3/lib/RT/CustomField_Overlay.pm line 30. Compilation failed in require at (eval 100) line 2. Compilation failed in require at //srv/rt3/sbin/rt-setup-database line 47. BEGIN failed--compilation aborted at //srv/rt3/sbin/rt-setup-database line 47. Makefile:336: recipe for target 'initialize-database' failed make: *** [initialize-database] Error 2 root@rt3:/home/bdk/rt-3-0-0# I’ve tried to install RT 3.0.0, 3.6.11 & 3.8.0 and the database initialization fails every time, though with different messages. 3.6.11: /usr/bin/perl //srv/rt3/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )(\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$/ at /srv/rt3/lib/RT/Date.pm line 152. Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )-(\d\d)-(\d\d) (\d\d):(\d\d):(\d\d)$/ at /srv/rt3/lib/RT/Date.pm line 154. Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )-(\d\d)-(\d\d) (\d\d):(\d\d):(\d\d)\+00$/ at /srv/rt3/lib/RT/Date.pm line 156. Useless use of greediness modifier '?' in regex; marked by <-- HERE in m/^(\d{4}? <-- HERE )(\d\d)(\d\d)(\d\d):(\d\d):(\d\d)$/ at /srv/rt3/lib/RT/Date.pm line 157. "my" variable $self masks earlier declaration in same statement at /srv/rt3/lib/RT/Transaction_Overlay.pm line 156. "my" variable $id masks earlier declaration in same statement at /srv/rt3/lib/RT/Transaction_Overlay.pm line 156. syntax error at /srv/rt3/lib/RT/Transaction_Overlay.pm line 151, near "$attr qw(id Creator Created LastUpdated TimeTaken LastUpdatedBy)" Global symbol "$attr" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 152. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 152. Global symbol "$attr" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 152. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 152. Global symbol "$attr" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 152. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 168. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 168. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 175. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 176. Global symbol "%args" requires explicit package name at /srv/rt3/lib/RT/Transaction_Overlay.pm line 179. syntax error at /srv/rt3/lib/RT/Transaction_Overlay.pm line 186, near "}" /srv/rt3/lib/RT/Transaction_Overlay.pm has too many errors. Compilation failed in require at (eval 126) line 2. Compilation failed in require at /srv/rt3/lib/RT/Transactions.pm line 75. BEGIN failed--compilation aborted at /srv/rt3/lib/RT/Transactions.pm line 75. Compilation failed in require at /srv/rt3/lib/RT/Record.pm line 1512. BEGIN failed--compilation aborted at /srv/rt3/lib/RT/Record.pm line 1512. Compilation failed in require at /srv/rt3/lib/RT/CurrentUser.pm line 74. BEGIN failed--compilation aborted at /srv/rt3/lib/RT/CurrentUser.pm line 74. Compilation failed in require at /srv/rt3/lib/RT.pm line 51. BEGIN failed--compilation aborted at /srv/rt3/lib/RT.pm line 51. Compilation failed in require at //srv/rt3/sbin/rt-setup-database line 60. BEGIN failed--compilation aborted at //srv/rt3/sbin/rt-setup-database line 60. Makefile:376: recipe for target 'initialize-database' failed make: *** [initialize-database] Error 255 3.8.0: /usr/bin/perl sbin/rt-setup-database --action init --dba root --prompt-for-dba-password syntax error at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 147, near "$attr qw(id Creator Created LastUpdated TimeTaken LastUpdatedBy)" Global symbol "$attr" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 148. Global symbol "%args" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 148. Global symbol "$attr" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 148. Global symbol "%args" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 148. Global symbol "$attr" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 148. Global symbol "%args" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 164. Global symbol "%args" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 164. Global symbol "%args" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 171. Global symbol "%args" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 172. Global symbol "%args" requires explicit package name at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 175. syntax error at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm line 182, near "}" /home/bdk/rt-3.8.0/sbin/../lib/RT/Transaction_Overlay.pm has too many errors. Compilation failed in require at (eval 154) line 2. Compilation failed in require at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transactions.pm line 76. BEGIN failed--compilation aborted at /home/bdk/rt-3.8.0/sbin/../lib/RT/Transactions.pm line 76. Compilation failed in require at /home/bdk/rt-3.8.0/sbin/../lib/RT/Record.pm line 1465. BEGIN failed--compilation aborted at /home/bdk/rt-3.8.0/sbin/../lib/RT/Record.pm line 1465. Compilation failed in require at /home/bdk/rt-3.8.0/sbin/../lib/RT/Ticket.pm line 72. BEGIN failed--compilation aborted at /home/bdk/rt-3.8.0/sbin/../lib/RT/Ticket.pm line 72. Compilation failed in require at /home/bdk/rt-3.8.0/sbin/../lib/RT/Tickets.pm line 76. BEGIN failed--compilation aborted at /home/bdk/rt-3.8.0/sbin/../lib/RT/Tickets.pm line 76. Compilation failed in require at /home/bdk/rt-3.8.0/sbin/../lib/RT.pm line 422. BEGIN failed--compilation aborted at sbin/rt-setup-database line 86. Makefile:386: recipe for target 'initialize-database' failed make: *** [initialize-database] Error 255 root@rt3:/home/bdk/rt-3.8.0# Thanks for any and all insight you can give me to fixing my issue(s). -bdk
--------- RT 4.4 and RTIR Training Sessions (http://bestpractical.com/services/training.html) * Hamburg Germany - March 14 & 15, 2016 * Washington DC - May 23 & 24, 2016