QA:Testcase MySQL or MariaDB in ReviewBoard

From FedoraProject

Jump to: navigation, search

Purpose of this task is to test functionality of ReviewBoard package, that uses MySQL as a backend for data.

Prerequisities

Steps

1. Ensure you have installed packages ReviewBoard and mariadb-server.

# yum install ReviewBoard mariadb-server httpd

2. Start MariaDB database and create database and user for ReviewBoard:

# systemctl start mysqld
# mysql
mysql> CREATE DATABASE reviewboard;
mysql> CREATE USER 'reviewboard'@'localhost' IDENTIFIED BY 'secretpass';
mysql> GRANT ALL PRIVILEGES on reviewboard.* to reviewboard;
mysql> FLUSH PRIVILEGES;

3. Start ReviewBoard Wizard (we will install it to /var/www/html/reviews.localhost, which shouldn't exist)

# rb-site install /var/www/html/reviews.localhost

4. Click Next

5. Set Domain name: localhost and click Next

6. Set Root Path: /reviews.localhost and click Next

7. Keep default values for Shipped Media URL and Uploaded Media URL.

8. Choose mysql as Database Type

9. Set database server (usually localhost)

10. Fill in Database connection settings (username, password)

11. Use file as Cache Type

12. Set Cache Directory (you can use default)

13. Use apache as a Web Server

14. Use wsgi as Python Loader

15. Set Admin account for ReviewBoard

16. Wait for creating database and click Next

17. Copy apache configuration:

# cp /var/www/html/reviews.localhost/conf/apache-wsgi.conf /etc/httpd/conf.modules.d

18. Create data directory if not already done and and set correct SELinux context on directories:

# mkdir /var/www/html/reviews.localhost/data
# semanage fcontext -a -t httpd_sys_rw_content_t "/var/www/html/reviews.localhost(/.*)?"
# restorecon -R /var/www/html/reviews.localhost/

19. (Re)Start httpd daemon

# systemctl restart httpd

20. Go to http://localhost/review.localhost in your browser and do anything you want with ReviewBoard