Re: site migration

2020-07-28 Thread Paul Mansfield 
AIUI, it's all in the database.
https://groups.google.com/g/reviewboard/c/KHjIWCU_YJo

well, apart from people's avatars, so I would back up htdocs/media/


On Tue, 28 Jul 2020 at 17:16, Adam Weremczuk  wrote:

> Hi Paul,
>
> Thanks for the hint, I'll bear it in mind.
>
> What I'm after really is a site migration procedure applicable to my
> environment.
>
> If there is no official documentation in place maybe somebody could at
> least provide a list of steps?
>
> Regards,
> Adam
>
>
> On Tue, 28 Jul 2020 at 17:04, Paul Mansfield <
> paul.mansfi...@agileanalog.com> wrote:
>
>> did you restore your SECRET_KEY?
>>
>> check your reviewboard settings_local.py file
>>
>> mine is in /var/www/reviewboard/conf/settings_local.py because that's the
>> directory for my virtual http server
>>
>> in there you'll find this:
>> # Unique secret key. Don't share this with anybody.
>> SECRET_KEY = 'xxx'
>>
>> you need to make a note/copy of that key from your live RB instance, and
>> if you restore it from a backup, put that key into the new instance.
>>
>>
>>
>>
>> On Tue, 28 Jul 2020 at 15:58, Adam Weremczuk 
>> wrote:
>>
>>> Hi all,
>>>
>>> Today I've attempted a migration from:
>>>
>>> Debian 9.3
>>> Apache 2.4.25
>>> MySQL 5.7.30
>>> ReviewBoard 3.0.17
>>>
>>> to:
>>>
>>> Debian 9.13
>>> Apache 2.4.25
>>> MySQL 5.7.31
>>> ReviewBoard 3.0.18
>>>
>>> Rather small differences and I didn't expect much trouble.
>>>
>>> I started with migrating database (mysqldump) which resulted in the
>>> following error:
>>>
>>>
>>>
>>>
>>> *Something broke! (Error 500)It appears something broke when you tried
>>> to go to here. This is either a bug in Review Board or a server
>>> configuration error. Please report this to your administrator.[Tue Jul 28
>>> 13:05:08.361856 2020] [wsgi:error] [pid 1650:tid 140483573556992] [client
>>> 10.200.20.2:53391 ] ERROR:root:Could not load
>>> siteconfig: Site matching query does not exist.*
>>>
>>> When I dropped the database and restored the original the error didn't
>>> go away which I found really strange. In order to get a fully functional
>>> vanilla RB 3.0.18 back on the destination I had to restore the entire
>>> container from a pre-db-fiddling backup.
>>>
>>> By looking at the content of mysqldump it doesn't look like db
>>> migration should be necessary anyway. The differences between a vanilla and
>>> data populated dump where down to:
>>>
>>> *ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;*
>>>
>>> vs
>>>
>>> *ENGINE=InnoDB DEFAULT CHARSET=utf8;*
>>>
>>> Is it ok to just copy "repository-clones", "data" and "conf" directories
>>> over?
>>>
>>> Is what I'm trying to achieve documented somewhere step by step in
>>> details?
>>>
>>> Please advise.
>>>
>>> Regards,
>>> Adam
>>>
>>> --
>>> Supercharge your Review Board with Power Pack:
>>> https://www.reviewboard.org/powerpack/
>>> Want us to host Review Board for you? Check out RBCommons:
>>> https://rbcommons.com/
>>> Happy user? Let us know! https://www.reviewboard.org/users/
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "Review Board Community" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to reviewboard+unsubscr...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/reviewboard/CALC-DAHJf%3DF1nzFF-TwhugqA1Dgj4azZ8F83jLNBofjBZbXFsw%40mail.gmail.com
>>> 
>>> .
>>>
>>
>>
>> --
>> P Mansfield, Senior DevOps Engineer, Agile Analog Ltd
>> GPG fingerprint: 8BC9D73EE3D4669C1C138ABD41D5B0C9030D4AE6
>>
>> --
>> Supercharge your Review Board with Power Pack:
>> https://www.reviewboard.org/powerpack/
>> Want us to host Review Board for you? Check out RBCommons:
>> https://rbcommons.com/
>> Happy user? Let us know! https://www.reviewboard.org/users/
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Review Board Community" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to reviewboard+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/reviewboard/CAMukpcDhwVvxF3kXmFF1VnMbW-ud3DDJmAWkuzyHATXHabnS3Q%40mail.gmail.com
>> 
>> .
>>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> Happy user? Let us know! https://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "Review Board Community" group.
> To un

Re: site migration

2020-07-28 Thread Adam Weremczuk 
Hi Paul,

Thanks for the hint, I'll bear it in mind.

What I'm after really is a site migration procedure applicable to my
environment.

If there is no official documentation in place maybe somebody could at
least provide a list of steps?

Regards,
Adam


On Tue, 28 Jul 2020 at 17:04, Paul Mansfield 
wrote:

> did you restore your SECRET_KEY?
>
> check your reviewboard settings_local.py file
>
> mine is in /var/www/reviewboard/conf/settings_local.py because that's the
> directory for my virtual http server
>
> in there you'll find this:
> # Unique secret key. Don't share this with anybody.
> SECRET_KEY = 'xxx'
>
> you need to make a note/copy of that key from your live RB instance, and
> if you restore it from a backup, put that key into the new instance.
>
>
>
>
> On Tue, 28 Jul 2020 at 15:58, Adam Weremczuk  wrote:
>
>> Hi all,
>>
>> Today I've attempted a migration from:
>>
>> Debian 9.3
>> Apache 2.4.25
>> MySQL 5.7.30
>> ReviewBoard 3.0.17
>>
>> to:
>>
>> Debian 9.13
>> Apache 2.4.25
>> MySQL 5.7.31
>> ReviewBoard 3.0.18
>>
>> Rather small differences and I didn't expect much trouble.
>>
>> I started with migrating database (mysqldump) which resulted in the
>> following error:
>>
>>
>>
>>
>> *Something broke! (Error 500)It appears something broke when you tried to
>> go to here. This is either a bug in Review Board or a server configuration
>> error. Please report this to your administrator.[Tue Jul 28 13:05:08.361856
>> 2020] [wsgi:error] [pid 1650:tid 140483573556992] [client 10.200.20.2:53391
>> ] ERROR:root:Could not load siteconfig: Site
>> matching query does not exist.*
>>
>> When I dropped the database and restored the original the error didn't go
>> away which I found really strange. In order to get a fully functional
>> vanilla RB 3.0.18 back on the destination I had to restore the entire
>> container from a pre-db-fiddling backup.
>>
>> By looking at the content of mysqldump it doesn't look like db
>> migration should be necessary anyway. The differences between a vanilla and
>> data populated dump where down to:
>>
>> *ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;*
>>
>> vs
>>
>> *ENGINE=InnoDB DEFAULT CHARSET=utf8;*
>>
>> Is it ok to just copy "repository-clones", "data" and "conf" directories
>> over?
>>
>> Is what I'm trying to achieve documented somewhere step by step in
>> details?
>>
>> Please advise.
>>
>> Regards,
>> Adam
>>
>> --
>> Supercharge your Review Board with Power Pack:
>> https://www.reviewboard.org/powerpack/
>> Want us to host Review Board for you? Check out RBCommons:
>> https://rbcommons.com/
>> Happy user? Let us know! https://www.reviewboard.org/users/
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Review Board Community" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to reviewboard+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/reviewboard/CALC-DAHJf%3DF1nzFF-TwhugqA1Dgj4azZ8F83jLNBofjBZbXFsw%40mail.gmail.com
>> 
>> .
>>
>
>
> --
> P Mansfield, Senior DevOps Engineer, Agile Analog Ltd
> GPG fingerprint: 8BC9D73EE3D4669C1C138ABD41D5B0C9030D4AE6
>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> Happy user? Let us know! https://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "Review Board Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/reviewboard/CAMukpcDhwVvxF3kXmFF1VnMbW-ud3DDJmAWkuzyHATXHabnS3Q%40mail.gmail.com
> 
> .
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/reviewboard/CALC-DAHeTAo1A4xRLN65TOojQrcgCn6k%3D%2B5PVpu4jHNHsiJwpg%40mail.gmail.com.

Re: site migration

2020-07-28 Thread Paul Mansfield 
did you restore your SECRET_KEY?

check your reviewboard settings_local.py file

mine is in /var/www/reviewboard/conf/settings_local.py because that's the
directory for my virtual http server

in there you'll find this:
# Unique secret key. Don't share this with anybody.
SECRET_KEY = 'xxx'

you need to make a note/copy of that key from your live RB instance, and if
you restore it from a backup, put that key into the new instance.




On Tue, 28 Jul 2020 at 15:58, Adam Weremczuk  wrote:

> Hi all,
>
> Today I've attempted a migration from:
>
> Debian 9.3
> Apache 2.4.25
> MySQL 5.7.30
> ReviewBoard 3.0.17
>
> to:
>
> Debian 9.13
> Apache 2.4.25
> MySQL 5.7.31
> ReviewBoard 3.0.18
>
> Rather small differences and I didn't expect much trouble.
>
> I started with migrating database (mysqldump) which resulted in the
> following error:
>
>
>
>
> *Something broke! (Error 500)It appears something broke when you tried to
> go to here. This is either a bug in Review Board or a server configuration
> error. Please report this to your administrator.[Tue Jul 28 13:05:08.361856
> 2020] [wsgi:error] [pid 1650:tid 140483573556992] [client 10.200.20.2:53391
> ] ERROR:root:Could not load siteconfig: Site
> matching query does not exist.*
>
> When I dropped the database and restored the original the error didn't go
> away which I found really strange. In order to get a fully functional
> vanilla RB 3.0.18 back on the destination I had to restore the entire
> container from a pre-db-fiddling backup.
>
> By looking at the content of mysqldump it doesn't look like db
> migration should be necessary anyway. The differences between a vanilla and
> data populated dump where down to:
>
> *ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;*
>
> vs
>
> *ENGINE=InnoDB DEFAULT CHARSET=utf8;*
>
> Is it ok to just copy "repository-clones", "data" and "conf" directories
> over?
>
> Is what I'm trying to achieve documented somewhere step by step in details?
>
> Please advise.
>
> Regards,
> Adam
>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> Happy user? Let us know! https://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "Review Board Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/reviewboard/CALC-DAHJf%3DF1nzFF-TwhugqA1Dgj4azZ8F83jLNBofjBZbXFsw%40mail.gmail.com
> 
> .
>


-- 
P Mansfield, Senior DevOps Engineer, Agile Analog Ltd
GPG fingerprint: 8BC9D73EE3D4669C1C138ABD41D5B0C9030D4AE6

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/reviewboard/CAMukpcDhwVvxF3kXmFF1VnMbW-ud3DDJmAWkuzyHATXHabnS3Q%40mail.gmail.com.

site migration

2020-07-28 Thread Adam Weremczuk 
Hi all,

Today I've attempted a migration from:

Debian 9.3
Apache 2.4.25
MySQL 5.7.30
ReviewBoard 3.0.17

to:

Debian 9.13
Apache 2.4.25
MySQL 5.7.31
ReviewBoard 3.0.18

Rather small differences and I didn't expect much trouble.

I started with migrating database (mysqldump) which resulted in the
following error:




*Something broke! (Error 500)It appears something broke when you tried to
go to here. This is either a bug in Review Board or a server configuration
error. Please report this to your administrator.[Tue Jul 28 13:05:08.361856
2020] [wsgi:error] [pid 1650:tid 140483573556992] [client 10.200.20.2:53391
] ERROR:root:Could not load siteconfig: Site
matching query does not exist.*

When I dropped the database and restored the original the error didn't go
away which I found really strange. In order to get a fully functional
vanilla RB 3.0.18 back on the destination I had to restore the entire
container from a pre-db-fiddling backup.

By looking at the content of mysqldump it doesn't look like db
migration should be necessary anyway. The differences between a vanilla and
data populated dump where down to:

*ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;*

vs

*ENGINE=InnoDB DEFAULT CHARSET=utf8;*

Is it ok to just copy "repository-clones", "data" and "conf" directories
over?

Is what I'm trying to achieve documented somewhere step by step in details?

Please advise.

Regards,
Adam

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/reviewboard/CALC-DAHJf%3DF1nzFF-TwhugqA1Dgj4azZ8F83jLNBofjBZbXFsw%40mail.gmail.com.