BIND 10 #2653: Document MySQL database set-up for unit tests

[BIND 10 Development]

#2653: Document MySQL database set-up for unit tests
-------------------------------------+-------------------------------------
                   Reporter:         |                 Owner:
  stephen                            |                Status:  new
                       Type:  task   |             Milestone:  DHCP
                   Priority:         |  Outstanding Tasks
  medium                             |              Keywords:
                  Component:         |             Sensitive:  0
  documentation                      |           Sub-Project:  DHCP
               CVSS Scoring:         |  Estimated Difficulty:  0
            Defect Severity:  N/A    |           Total Hours:  0
Feature Depending on Ticket:         |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
 We need to document how to set up a MySQL database to run in unit tests,
 namely:

 >1. Install MySQL on the system and ensure that it runs at startup.
 >
 >2. Create the MySQL DHCP database and authorised user for the tests:
 >
 > 2.1 Log into MySQL as root
 >
 >    % mysql -u root -p
 >    Enter password:
 >       :
 >    mysql>
 >
 > 2.2 Create the database with:
 >
 >    mysql> CREATE DATABASE keatest;
 >
 > 2.3 Create the user under which the unit test client will connect to the
 database.
 >
 >    mysql> CREATE USER 'keatest'@'localhost' IDENTIFIED BY 'keatest';
 >
 > 2.4 Grant the user permissions to access the "kea" database:
 >
 >    mysql> GRANT ALL ON keatest.* TO 'keatest'@'localhost';
 >
 >3. When you run configure, add the switch --with-dhcp-mysql to the
 configure command line.  This should point to the mysql_config program:
 without a value, it should default to the correct location.

 The logical place for this would seem to be in
 src/lib/dhcpsrv/database_backends.dox

-- 
Ticket URL: <http://bind10.isc.org/ticket/2653>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development