Migrate Reviewboard off an old server to a new one

[Gregory Machin]

Hi.

I need to move an installation of ReviewBoard from an old server to a new one, as far as I can tell its using sqlite3. As far as I can tell everything is under on directory. The old server is running lighttpd and the new Apache.

What is the best way to do the migration. I have no Reviewboard or Python web app experiences.

Thank you in advance.

G 

[MoonWalker]

Grogory, 

what version of RB and OS are you currently using and what version do you want to use 2.0.3?

[Gregory Machin]

Hi MoonWalker.

Thank you for taking time.

Old server :
CentOS 5
Reviewboard: 1.6.11

New server:
CentOS 6
Reviewboard: 1.6.17

Yes I would like to upgrade, but I would like to migrate fist, be sure all is working. I want the disruption to the users to be as low as possible at this point.

Regards

Greg

[Christian Hammond]

Hi Gregory,

The 1.6.x releases are quite old now and no longer supported, so you may or may not have some issues with the steps I’m about to describe.

I’m assuming you’re looking to move away from sqlite to something like MySQL while doing this. Under no circumstances should you ever use sqlite for production, as it’s not intended for access by more than one user at a time, its capabilities are limited, and it has very little protection against things like corruption and data constraints.

We have a couple management commands that may help for converting your database.

First, on the old server, run:

    $ rb-site manage /path/to/site dumpdb > database.json

You will need to make sure nobody is writing to the database while you do this. I’d shut down the server temporarily.

On the second server, install exactly Review Board 1.6.11. You should not yet upgrade to 1.6.17. This is because you need both servers to match for the database conversion. You’ll then create a new site install using ‘rb-site install’, specifying MySQL or something as the database. It’ll ask you for information like an administrator account, etc., and then create the install.

After that’s done, run:

    $ rb-site manage /path/to/new/site loaddb database.json

It should import into the database. You can then hook it up to Apache (especially for RB 1.6.x, I recommend this over lighttpd, as you will more than likely have new problems to deal with) and verify it’s working.

At that point, you can upgrade to any release of Review Board and it should work.

We can help more directly with getting you off an sqlite3 database on 1.6.x to something more modern (1.7.x or 2.0.x) if your company is interested in a support contract.

Christian

-- 
Christian Hammond - chri...@beanbaginc.com
Review Board - http://www.reviewboard.org

Beanbag, Inc. - http://www.beanbaginc.com

--
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups "reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Gregory Machin]

Hi Christian.

Thanks for taking time to assist. sadly at this time this is 0 budget project.

I installed Reviewboard by:

easy_install -f http://downloads.reviewboard.org/releases/ReviewBoard/1.6/ ReviewBoard

How do I remove and install 1.6.11

Thank you.

Gregory Machin

[Christian Hammond]

Hi Gregory,

You’ll want to find the .egg directories for ReviewBoard an Djblets and remove them. Then:

    easy_install ReviewBoard==1.6.11

Christian

-- 
Christian Hammond - chri...@beanbaginc.com
Review Board - http://www.reviewboard.org

Beanbag, Inc. - http://www.beanbaginc.com

[Gregory Machin]

Hi.

I have managed to migrate it. although the urls in the emails still point to the old servers. I tried editing the "Server:" url but that goes empty when I click on save.

Any suggestions.

Thank you.

[Christian Hammond]

That’s a known bug in those versions. Try reloading Apache.

Christian

-- 
Christian Hammond - chri...@beanbaginc.com
Review Board - http://www.reviewboard.org

Beanbag, Inc. - http://www.beanbaginc.com