Date: Fri, 29 Mar 2024 04:39:17 -0400 (EDT) Message-ID: <1817948580.956.1711701557801@ip-10-208-27-219.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_955_136547222.1711701557798" ------=_Part_955_136547222.1711701557798 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
This page includes the following topics:
A MySQL Version 5.5 server must be downloaded, installed, and running fo= r 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. =
Consult the following 2 links to successfully set up secure and well-per= forming MySQL servers, in preparation for installing NBIA:
MySQL Security Guide <= a href=3D"http://www.cancer.gov/policies/linking" class=3D"external-link" r= el=3D"nofollow"> =
General performance tuning <= /p>
Once installed, you must configure MySQL for NBIA (only for Linux).
Refer the document at http://de= v.mysql.com/doc/refman/5.5/en/linux-installation.html = for installing= MySQL on Linux. By default, in some Linux environments, the identifiers us= ed in the database are case-sensitive, so you must perform the following st= eps.
Table names
NBIA application assumes identifiers in MySQL are case insensitive. And = it can be defined in MySQL configuration file. The following steps are appl= icable to CentOS 6.6 environment.
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_c= ase_table_names=3D1
Use the following command to restart the MySQL service for the chang= es to take effect:
sudo se= rvice mysql restart
Download and install MySQL. Refer to the MyS=
QL 5.5 Reference Manual for detailed information on Installing and Upgrading MySQL
Before building and deploying the NBIA application, you must create =
the corresponding database, adding a new user account whose name shoul=
d be the same as that defined in the <installer_directory>\inst=
all.properties
file. For example:
databas= e.user=3Dnbia_user database.password=3Dnbia_password database.name=3Dnbiadb
Connect to the database server: mysql> mysql -h hos= t -u user -p
Enter password.
Use the following SQL to create a new account:
mysql&g= t; CREATE USER 'nbia_user'@'localhost' IDENTIFIED BY 'nbia_password'; =20 mysql> GRANT ALL PRIVILEGES ON *.* TO 'nbia_user'@'localhost';
d. Use the following SQL to create the da= tabase: nbiadb
mysql&= gt; CREATE DATABASE nbiadb
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 . Note the installation directory of the Tomcat server and u= se it to set the TOMCAT_HOME and gov.nih.nci.ncia.tomcat.home in the proper= ties.
See Configuring Tomcat Servers and MySQL Server t= o Run as Services if you want to run Tomcat as a service.