migrating 3.0.18 between servers

[Adam Weremczuk]

Hi all,

Following my previous struggle I've decided to simplify things and set up an almost identical destination server:

Source:

Debian 9.13
MySQL 5.7.31
Python 2.7.13
ReviewBoard 3.0.18

Destination:

Debian 9.13
MySQL 5.7.34
Python 2.7.13
ReviewBoard 3.0.18

Same steps as before:
- install and configure everything on destination the same way (users, names, even passwords) + create a blank site with the same name
- migrate the database and entire site directory /var/www/mysite

I have tried SECRET_KEY from conf/settings_local.py of both the original site and the new blank site (with the same name).  

To my surprise either key gives me:

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.
ERROR:root:Could not load siteconfig: Site matching query does not exist.

Is there any way around this (e.g. recreate the key)?
Could it be something else?

Regards,

Adam

[Adam Weremczuk]

...or perhaps the SECRET_KEY feature can be disabled?

[David Trowbridge]

Adam,

SECRET_KEY is necessary, and needs to be the same between the two servers. The missing Site sounds like something didn't work right migrating the database.

David

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/CALC-DAFGG_mP-p_P2n77DE4X96TUMCnui2%2BrTZawEZhpad4vYA%40mail.gmail.com.

[Adam Weremczuk]

Hmmm, something wrong with my db migration steps?

user@source:~$ sudo mysqldump -h localhost -u root -p -d reviewboard > /tmp/reviewboard.sql
user@source:~$ sudo scp /tmp/reviewboard.sql user@destination:/tmp/

user@destination:~$ sudo mysql -h localhost -u root -p

mysql> DROP DATABASE reviewboard;
Query OK, 82 rows affected (0.26 sec)

mysql> CREATE DATABASE reviewboard;
Query OK, 1 row affected (0.00 sec)

mysql> quit
Bye

user@destination:~$ sudo mysql -h localhost -u root -p reviewboard < /tmp/reviewboard.sql

What I'm finding strange is the diff between .sql dumps of the source production site and the blank mirror destination site:

diff reviewboard-destination-orig.sql reviewboard-source.sql
1c1
< -- MySQL dump 10.13  Distrib 5.7.34, for Linux (x86_64)
---
> -- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
5c5
< -- Server version 5.7.34
---
> -- Server version 5.7.31
45c45
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
82c82
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
145c145
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8;
207c207
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
222c222
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
237c237
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
300c300
< ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
320c320
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
361c361
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;
402c402
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8;
419c419
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;
456c456
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=1361 DEFAULT CHARSET=utf8;
489c489
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=732 DEFAULT CHARSET=utf8;
513c513
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
635c635
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
886c886
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=509 DEFAULT CHARSET=utf8;
993c993
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1016c1016
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
1043c1043
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1063c1063
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1105c1105
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8;
1125c1125
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=509 DEFAULT CHARSET=utf8;
1145c1145
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1165c1165
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
1245c1245
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;
1265c1265
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8;
1305c1305
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
1325c1325
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
1425c1425
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;
1466c1466
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1606c1606
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1725c1725
< ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1895c1895
< -- Dump completed on 2023-04-04 20:17:29
---
> -- Dump completed on 2023-04-04 19:18:07

To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/CAFS3VNXV_SSZ5Ku0h_sMVJMtAQjx5dO1vD%2Bp_WVr7u2M36iRRQ%40mail.gmail.com.