Hi, I try to migrate from Windows installation to Linux one.
I was having Windows version 2.5.1-1 and wanted to move to Linux version 2.5.7-2.
So I first upgraded the Windows version 2.5.7-2 under Windows to avoid some convertion problems. This went well, I,m using MySQL database.
So I dump the previous database (into use_reviewboard env):
mysqldump -u root -p bitnami_reviewboard > backup.sql
I recorded the config file:
apps\reviewboard\htdocs\rb-sites\reviewboard\conf\settings_local.py
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'bitnami_reviewboard',
'USER': 'bn_reviewboard',
'PASSWORD': 'mySuperPassword',
'HOST': '127.0.0.1',
'PORT': '3306',
},
}
I removed the 2.5.1-1 install and services.
I installed 2.5.7-2.
Reimported the mysql data (into the new use_reviewboard env):
mysql -u root -p
mysql> drop database bitnami_reviewboard;
mysql> create database bitnami_reviewboard;
mysql> grant all privileges on bitnami_redmine.* to 'bn_redmine'@'localhost' identified by 'mySuperPassword';
mysql> exit
mysql -u root -p bitnami_reviewboard < backup.sql
Then I upgraded the database info (into reviewboard env):
rb-site upgrade C:\Bitnami\reviewboard-2.5.7-2\apps\reviewboard\htdocs\rb-sites\reviewboard
The convertion started and completed ok, so I reinstalled the services and restart the mysql.
I had a 500 error something broke, so I copied the database password (‘mySuperPassword’) into the new
apps\reviewboard\htdocs\rb-sites\reviewboard\conf\settings_local.py
Then everything started just fine on Windows.
So I created my CentOS 7 VM machine and installed the bitnami 2.5.7-2 Linux version. Did the same backup/restore like I did for the Windows migration. The rb-site upgrade said nothing is required. I did change the settings_local.py file database password.
But I still get error 500 when accessing the dashboard (The landing page bitnami apache is working).
clear
there’s nothing into special or related into:
apps/reviewboard/htdocs/rb-sites/reviewboard/logs
mysql/data/mysqld.log
apache2/logs/error_log
So I wonder what is missing here?!? The database empty was working just fine. So I wonder if any setting into the tables data must be change when moving platforms?
Anybody have a clue on what I should check here?
How can I debug this??? any way to get more info above the
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.
Thanks,
Jerome
Here’s the log content when I try to access the dashboard:
bash-4.2# cat apache2/logs/access_log
10.1.30.177 - - [13/Jan/2017:14:15:45 -0500] "GET /reviewboard/ HTTP/1.1" 500 250
10.1.30.177 - - [13/Jan/2017:14:15:52 -0500] "GET /reviewboard/ HTTP/1.1" 500 250
10.1.30.177 - - [13/Jan/2017:14:15:53 -0500] "GET /favicon.ico HTTP/1.1" 200 1150
10.1.30.177 - - [13/Jan/2017:14:15:56 -0500] "GET / HTTP/1.1" 200 803
10.1.30.177 - - [13/Jan/2017:14:15:58 -0500] "GET /reviewboard/ HTTP/1.1" 500 250
bash-4.2# cat apache2/logs/error_log
[Fri Jan 13 14:03:59.162176 2017] [ssl:warn] [pid 24744] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Fri Jan 13 14:03:59.230390 2017] [ssl:warn] [pid 24745] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Fri Jan 13 14:03:59.244530 2017] [mpm_prefork:notice] [pid 24745] AH00163: Apache/2.4.23 (Unix) OpenSSL/1.0.2j mod_wsgi/3.5 Python/2.7.12 configured -- resuming normal operations
[Fri Jan 13 14:03:59.244567 2017] [core:notice] [pid 24745] AH00094: Command line: '/opt/reviewboard-2.5.7-2/apache2/bin/httpd.bin -f /opt/reviewboard-2.5.7-2/apache2/conf/httpd.conf'
[Fri Jan 13 14:16:05.143736 2017] [mpm_prefork:notice] [pid 24745] AH00169: caught SIGTERM, shutting down
[Fri Jan 13 19:16:05.238568 2017] [pagespeed:error] [pid 24751] [mod_pagespeed 1.9.32.14-0 @24751] Attempt to destroy unknown SHM segment [1]/opt/reviewboard-2.5.7-2/apache2/var/cache/mod_pagespeed//named_locks.
[Fri Jan 13 19:16:05.238635 2017] [pagespeed:error] [pid 24751] [mod_pagespeed 1.9.32.14-0 @24751] Attempt to destroy unknown SHM segment [1]pagespeed_default_shm/metadata_cache.
[Fri Jan 13 19:16:05.238649 2017] [pagespeed:error] [pid 24751] [mod_pagespeed 1.9.32.14-0 @24751] Attempt to destroy unknown SHM segment [1]globalstatistics.
[Fri Jan 13 19:16:05.238693 2017] [pagespeed:error] [pid 24751] [mod_pagespeed @24751] [0113/191605:ERROR:google_message_handler.cc(41)] Attempt to destroy unknown SHM segment [1]SharedCircularBuffer.:0.
[Fri Jan 13 19:16:05.249569 2017] [pagespeed:error] [pid 24749] [mod_pagespeed 1.9.32.14-0 @24749] Attempt to destroy unknown SHM segment [1]/opt/reviewboard-2.5.7-2/apache2/var/cache/mod_pagespeed//named_locks.
[Fri Jan 13 19:16:05.249636 2017] [pagespeed:error] [pid 24749] [mod_pagespeed 1.9.32.14-0 @24749] Attempt to destroy unknown SHM segment [1]pagespeed_default_shm/metadata_cache.
[Fri Jan 13 19:16:05.249651 2017] [pagespeed:error] [pid 24749] [mod_pagespeed 1.9.32.14-0 @24749] Attempt to destroy unknown SHM segment [1]globalstatistics.
[Fri Jan 13 19:16:05.249697 2017] [pagespeed:error] [pid 24749] [mod_pagespeed @24749] [0113/191605:ERROR:google_message_handler.cc(41)] Attempt to destroy unknown SHM segment [1]SharedCircularBuffer.:0.
bash-4.2# cat mysql/data/mysqld.log
170113 14:30:40 mysqld_safe Starting mysqld.bin daemon with databases from /opt/reviewboard-2.5.7-2/mysql/data
170113 14:30:40 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
170113 14:30:40 [Note] /opt/reviewboard-2.5.7-2/mysql/bin/mysqld.bin (mysqld 5.5.53) starting as process 25246 ...
170113 14:30:40 [Note] Plugin 'FEDERATED' is disabled.
170113 14:30:40 InnoDB: The InnoDB memory heap is disabled
170113 14:30:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170113 14:30:40 InnoDB: Compressed tables use zlib 1.2.3
170113 14:30:40 InnoDB: Using Linux native AIO
170113 14:30:40 InnoDB: Initializing buffer pool, size = 128.0M
170113 14:30:40 InnoDB: Completed initialization of buffer pool
170113 14:30:40 InnoDB: highest supported file format is Barracuda.
170113 14:30:41 InnoDB: Waiting for the background threads to start
170113 14:30:42 InnoDB: 5.5.53 started; log sequence number 149055746
170113 14:30:42 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
170113 14:30:42 [Note] - '127.0.0.1' resolves to '127.0.0.1';
170113 14:30:42 [Note] Server socket created on IP: '127.0.0.1'.
170113 14:30:42 [Note] Event Scheduler: Loaded 0 events
170113 14:30:42 [Note] /opt/reviewboard-2.5.7-2/mysql/bin/mysqld.bin: ready for connections.
Version: '5.5.53' socket: '/opt/reviewboard-2.5.7-2/mysql/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)