admin@remotehost1:~$ export REVIEWBOARD_DB_NAME=review
admin@remotehost1:~$ mysqldump -u backup -p --max_allowed_packet=512M
$REVIEWBOARD_DB_NAME > /tmp/reviewboard-`date`.sql
admin@remotehost1:~$ scp /tmp/reviewboard-`date`.sql admin@remotehost2:/tmp/
admin@remotehost1:~$ scp -r /var/www/reviewboard-1.5.2
admin@remotehost2:/var/www/reviewboard-1.7.14
admin@remotehost2:~$ sudo apt-get install mysql-server libmysqlclient-dev
memcached ntpd apache2 libapach2-mod-wsgi libapache2-mod-python
admin@remotehost2:~$ sudo easy_install Reviewboard==1.7.14 Django==1.4.10
python-memcached MySQL-Python
admin@remotehost2:~$ sudo easy_install -m Reviewboard==1.7.14
admin@remotehost2:~$ sudo cp
/var/www/reviewboard-1.7.14/conf/settings_local.py /home/admin
admin@remotehost2:~$ vim /home/admin/settings_local.py (make the mentioned
changes from my thread)
admin@remotehost2:~$ sudo cp /home/admin/settings_local.py
/usr/local/lib/python2.7/dist-packages/Reviewboard-1.7.14-py2.7.egg/reviewboard/
admin@remotehost2:~$ mysql -u root -p
mysql> create database review;
mysql> create user 'review'@'localhost' identified by 'password';
mysql> grant all on review.* to 'review'@'localhost';
admin@remotehost2:~$ mysql --max_allowed_packet=128M -u review -p review <
/tmp/reviewboard-`date`.sql
admin@remotehost2:~$ mysql -u root -p review
mysql> show table status
mysql> alter table `table_name` engine='InnoDB'; (there are definitely
faster ways, but I can't spoon feed you everything...)
admin@remotehost2:~$ sudo rb-site --version (confirm you are at 1.7.14)
admin@remotehost2:~$ sudo rb-site upgrade /var/www/reviewboard-1.7.14
For Apache, you will need to add:
<Location "/review/static">
SetHandler None
</Location>
Alias /review/static
"/var/www/reviewboard-1.7.14/htdocs/static<http://review.company.com/htdocs/static>
"
For lighttpd:
alias.url = (
...
"/review/static" => "/var/www/review.company.com/htdocs/static",
...
)
url.rewrite-once = (
...
"^(/review/static/.*)$" => "$1",
...
)
Once you have made these changes, type the following
to resolve this:
$ rb-site manage /var/www/r <http://review.company.com/>eviewboard-1.7.14
resolve-check
static-media
Make the changes...
admin@remotehost2:~$ ln -s /var/www/reviewboard-1.7.14 /var/www/review
admin@remotehost2:~$ rb-site manage /var/www/reviewboard-1.7.14
resolve-check static-media
And for good measure...
admin@remotehost2:~$ rb-site manage /var/www/reviewboard-1.7.14 syncdb
Hope that helps,
KP
On Wednesday, March 19, 2014 3:11:13 AM UTC-7, Bhaskar Roy wrote:
>
> Hi Kevin,
>
> I did what you said but I am on same page.
>
> Can you please provide the procedure to do migration.
>
>
> regards
> bahskar
>
>
> On Wed, Mar 19, 2014 at 12:38 AM, Kevin Phillips <
> kevin.grenvi...@gmail.com <javascript:>> wrote:
>
>> Your database dump appears incomplete. Try dumping with
>> --max_allowed_packet=512M (large packet to avoid truncation). Check your
>> 1.5.X db and verify the table exists in production and in the backup. Also
>> verify all your tables are InnoDB instead of MYISAM, you can make manual
>> modification to the table engine without much recourse.
>>
>> Take a look at my thread, I just migrated 1.5.2 to 1.7.14 on the same
>> platform as you.
>>
>> KP
>>
>>
>> On Tuesday, March 18, 2014 2:31:44 AM UTC-7, Bhaskar Roy wrote:
>>
>>> Hi Christian,
>>>
>>> I am trying migration on new server and not in current production box.
>>>
>>> 1. On new server I installed ubuntu 12.04/mysql 5.5/RB 1.7.14
>>> 1. I took backup of SQL and copied to new server and done rb-site
>>> upgrade.
>>>
>>> Copied the databse to new server and tired . I get error messages as
>>> listed above.
>>>
>>> regards
>>> Bhaskar
>>>
>>>
>>> On Thu, Mar 13, 2014 at 12:53 AM, Christian Hammond
>>> <chi...@chipx86.com>wrote:
>>>
>>>> Hi,
>>>>
>>>> First, did you back up your database?
>>>>
>>>> Second, can you verify the version of Review Board you've upgraded to,
>>>> and also verify the version of django-evolution installed? (These should
>>>> be
>>>> in your Python's site-packages directory).
>>>>
>>>> You shouldn't do *any* hand-modifying of the database of any sort, or
>>>> you'll cause further issues in the upgrade process. Our stuff expects to
>>>> own the full schema of the database.
>>>>
>>>> Christian
>>>>
>>>> --
>>>> Christian Hammond - chi...@chipx86.com
>>>>
>>>> Review Board - http://www.reviewboard.org
>>>> Beanbag, Inc. - http://www.beanbaginc.com
>>>>
>>>>
>>>> On Wed, Mar 12, 2014 at 3:23 AM, Bhaskar Roy <bhaska...@gmail.com>wrote:
>>>>
>>>>> Hi Christian,
>>>>>
>>>>> I am getting following error while doing site upgrade from 1.5 to
>>>>> Latest 1.7.
>>>>> Even created auth_message tablein MySqL DB.
>>>>>
>>>>>
>>>>> /usr/bin/python /usr/local/bin/rb-site upgrade "/var/www/reviewboard"
>>>>> Rebuilding directory structure
>>>>> Updating database. This may take a while.
>>>>>
>>>>> The log output below, including warnings and errors,
>>>>> can be ignored unless upgrade fails.
>>>>>
>>>>> ------------------ <begin log output> ------------------
>>>>> Creating tables ...
>>>>> There are unapplied evolutions for auth.
>>>>> There are unapplied evolutions for sessions.
>>>>> There are unapplied evolutions for accounts.
>>>>> There are unapplied evolutions for changedescs.
>>>>> There are unapplied evolutions for diffviewer.
>>>>> There are unapplied evolutions for reviews.
>>>>> There are unapplied evolutions for scmtools.
>>>>> Project signature has changed - an evolution is required
>>>>> Installing custom SQL ...
>>>>> Installing indexes ...
>>>>> Installed 0 object(s) from 0 fixture(s)
>>>>> Evolution could not be simulated, possibly due to raw SQL mutations
>>>>> Error: Error applying evolution: (1051, "Unknown table 'auth_message'")
>>>>>
>>>>> Regards
>>>>> bhaskar
>>>>>
>>>>> --
>>>>> 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.
>>>>>
>>>>
>>>> --
>>>> 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.
>>>>
>>>
>>> --
>> 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 <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
