Page History

...

Installing and Configuring MySQL

A MySQL version Version 5.5 or higher 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.

...

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.0.68 X  must be downloaded and installed for the NBIA installation to work successfully. Installing Tomcat is beyond the scope of this document. For more information, refer to Tomcat 7 Installation Guide . 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.