Redmine

Andrew X wrote:

I've been using 1.3.2 Stable for a couple of years without any issues :D However, I want to try out AWS and move my RM from Rackspace for this instance. RM is on Ubuntu 12.02 with 1.3.2, and my plan was to go to Ubuntu 14.04 LTS. I researched two articles:

Migration:

http://www.redmine.org/projects/redmine/wiki/HowTo_Migrate_Redmine_to_a_new_server_to_a_new_Redmine_version

Upgrade:

http://www.redmine.org/projects/redmine/wiki/HowTo_Install_Redmine_30x_on_Ubuntu_1404_with_Apache2_Phusion_Passenger_MySQL_Subversion_and_Git_%28Gitolite%29

Currently in 1.3.2 I have not had the requirement for using the Source Control Modules: GIT or Subversion. And I really don't see how that integrates with RM anyway. For backups we've been taking snapshots of the images on a daily biases, so rolling back is easy. We use a separate GIT for source control with our projects. Although I'm willing to add Gitolite should it add value here. Although the instructions do indicate it's part of the process.

My questions:

• Should I go for the latest and greatest release or step back a few? I'm very happy with 1.3.2, and don't see the calling to have the latest release for more bells and whistles. I'd be happy with a stable few extra features. Although I don't want to be using Windows 3.1 when everyone is on Windows 10 - if you know what I mean.

• I have no requirement for subversion.

• I'd prefer to install a lean and mean version of Redmine comparable to what I have. Like I said, I love the product, and send a lot of people to Redmine to join the community. And this is probably my first post, and the reason is because I haven't had one issue. That says a lot.

• I have flexibility here. My stable instance will continue on Rackspace until I'm comfortable in cutting over to the new instance on AWS.

Thanks very much to the team that put and maintains Redmine, and to the community for helping me out here!

Andrew

Anyone? Seriously after two years, I find myself "back to the start" and even forgot about this post. Now in need of migrating from rackspace to AWS. My migration path so far. Install Ubuntu 14.04 using default packages for redmine, import original MySQL DB from Ubuntu 12.04 Redmine 1.3.2. RM Homepage screen loads, but signing-in throws an error and can't get RM logging info. :/ DB is obviously connecting, but since the default 14.04 packages are latter than 1.3.2 my guess is the schema is different.

Going to answer my own questions. Here are the steps of what was performed at a very high level.

From Rackspace to AWS

Origin Server Ubuntu 12.04
Destination Ubuntu 14.04 on EC2 AWS

Dump database on origin

Install Redmine on Ubuntu 14.04 using default distro packages. In my case Redmine 2.4.2

Make sure you install all dependencies!

Such as make, mysql client ect..

Create database the same as previous as per the previous database.yml file and import the dump file.

Copy over upload files
Copy over database.yml and set to MySQL2 [Most difficult part was getting MySQL2 to work!]
Copy over configuration.yml

View the upgrade Redmine documentation for details on upgrading.

Issues I ran into was installing various RM components as Sudo [IMO don't do it]. Better to install as logged in user then chown and chmod user/group and permissions as required. In my case I used www-data|www-data as my user for everything rm related and adjusted permissions after install worked.

Add MySQL2 to the gemfile! [That was the final piece for me to get my upgrade/migration working]
Just append at the end of the file: gem 'mysql2', '~> 0.3.18'

It worked in the end - whew and whoot!

A.X