Creating the project results database by using MySQL

You can create project results databases by using MySQL.

Before you begin

For information about the supported versions of the database, see the Supported Software > Database section in the download document https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0078997.

Procedure

  1. If you use Linux™, or if you use UFS volumes on Mac OS X, edit the MySQL configuration file (my.cnf) to store table names as lowercase and to ignore case in comparisons. The location of this file can vary. In the my.cnf file, set the MySQL system variable lower_case_table_names to 1.
    This change is not necessary on Windows™, where file names are not case-sensitive.
    Important: For Ubuntu, you must follow these steps:
    1. Enable lower case table names before you install the MySQL server. Run the following command:
      sudo debconf-set-selections <<< "mysql-server mysql-server/lowercase-table-names select Enabled
    2. Install the MySQL server.
    3. Check that table names are lower case. Run the following command: 
      mysql > show variables like 'lower_case_%'
  2. Log in as user root, create and use a new database.
    Note: If you need to store Unicode results, enter the following command to create the database: 
    CREATE DATABASE db_name CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;
    Note: There might be limitations as described at: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-utf8.html
  3. To ensure that MySQL uses the database you created in Step 2, run the following command:
    USE db_name;
  4. Run the ghtester_mysql.sql script against the new database by entering a command in the following format: 
    SOURCE installation_directory/scripts/ghtester_mysql.sql;
    Note: If you are using a command prompt on a Microsoft™ Windows™ system, the path separator must be reversed. For example: 
    SOURCE C:/Program Files/HCL/HCLProducts/API/scripts/ghtester_mysql.sql;