NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
4 - Installing and Configuring Software for NBIA 7.0
4 - Installing and Configuring Software for NBIA 7.0

This page includes the following topics:

Table of Contents
minLevel2

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.

Multiexcerpt include
MultiExcerptNameExitDisclaimer
nopaneltrue
PageWithExcerptwikicontent:Exit Disclaimer to Include

Tip
titleTip

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

  • MySQL Security Guide

    Multiexcerpt include
    MultiExcerptNameExitDisclaimer
    nopaneltrue
    PageWithExcerptwikicontent:Exit Disclaimer to Include

  • Performance –
    • General performance tuning

      Multiexcerpt include
      MultiExcerptNameExitDisclaimer
      nopaneltrue
      PageWithExcerptwikicontent:Exit Disclaimer to Include

Tip
titleMore 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

Multiexcerpt include
MultiExcerptNameExitDisclaimer
nopaneltrue
PageWithExcerptwikicontent:Exit Disclaimer to Include
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.

Info
titleTable 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:

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

    Code Block
    sudo service mysql restart
    

Windows

Download and install MySQL. Refer to the MySQL 5.5 Reference Manual

Multiexcerpt include
MultiExcerptNameExitDisclaimer
nopaneltrue
PageWithExcerptwikicontent:Exit Disclaimer to Include
for detailed information on Installing and Upgrading MySQL
Multiexcerpt include
MultiExcerptNameExitDisclaimer
nopaneltrue
PageWithExcerptwikicontent:Exit Disclaimer to Include
.  

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: 

    Code Block
    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:

    Code Block
    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

    Code Block
     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 logoImage Removed . 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.