NIH | National Cancer Institute | NCI Wiki  

This page includes the following topics:

Installing and Configuring MySQL

A MySQL Version 5.5 server must be downloaded, installed, and running for the NBIA installation to work successfully. Do not install later versions as they have not been tested with NBIA.

To download and install MySQL, follow the steps outlined on the MySQL website. Exit Disclaimer logo

Tip

Consult the following 2 links to successfully set up secure and well-performing MySQL servers, in preparation for installing NBIA:

More Tips

  • Record the MySQL root username/password you chose when you installed MySQL, as you will need to use this as your database.system.user/ database.system.password later in the NBIA installation process.
  • Note the MySQL port chosen during the MySQL installation process, as you will need to use this as your database.port later in the installation process.
  • As part of the installation process, the default character set is set to latin1 for the NBIA MySQL database.

Once installed, you must configure MySQL for NBIA (only for Linux).

Linux

Refer the document at http://dev.mysql.com/doc/refman/5.5/en/linux-installation.html Exit Disclaimer logo for installing MySQL on Linux. By default, in some Linux environments, the identifiers used in the database are case-sensitive, so you must perform the following steps.

Table names

NBIA application assumes identifiers in MySQL are case insensitive. And it can be defined in MySQL configuration file. The following steps are applicable to CentOS 6.6 environment.

  1. Edit the /etc/mysql/my.cnf or any other my.cnf file which is used to configure your mysql.
    Under the line [mysqld],  add the line below:

    lower_case_table_names=1
    
  2. Use the following command to restart the MySQL service for the changes to take effect: 

    sudo service mysql restart
    

Windows

Download and install MySQL. Refer to the MySQL 5.5 Reference Manual Exit Disclaimer logo for detailed information on Installing and Upgrading MySQL Exit Disclaimer logo .  

Initial Database Setup

  1. Before building and deploying the NBIA application, you must create the corresponding database, adding a new user account whose name should be the same as that defined in the <installer_directory>\install.properties file. For example: 

    database.user=nbia_user
    database.password=nbia_password
    database.name=nbiadb
  2. Create the above database and user by following these steps:
    1. Connect to the database server: mysql> mysql -h host -u user -p

    2. Enter password.

    3. Use the following SQL to create a new account:

    mysql> CREATE USER 'nbia_user'@'localhost' IDENTIFIED BY 'nbia_password';  
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'nbia_user'@'localhost';
    

         d. Use the following SQL to create the database: nbiadb

     mysql> CREATE DATABASE nbiadb

Installing and Configuring Tomcat 7.X

A Tomcat version 7.X  must be downloaded and installed for the NBIA installation to work successfully. Generally the latest version of Tomcat 7 will have the latest fixes, NBIA has been tested with 7.0.85. Installing Tomcat is beyond the scope of this document. For more information, refer to Tomcat 7 Installation Guide Exit Disclaimer logo . Note the installation directory of the Tomcat server and use it to set the TOMCAT_HOME and gov.nih.nci.ncia.tomcat.home in the properties.

See Configuring Tomcat Servers and MySQL Server to Run as Services if you want to run Tomcat as a service.

  • No labels