Page History
...
Table of Contents | ||
---|---|---|
|
Installing and Configuring MySQL
A MySQL 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.
Multiexcerpt include | ||||||
---|---|---|---|---|---|---|
|
Tip | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||
Consult the following three 2 links to successfully set up secure and well-performing MySQL servers, in preparation for installing NBIA:
|
Tip | ||
---|---|---|
| ||
|
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 | ||||||
---|---|---|---|---|---|---|
|
...
Edit the
/etc/mysql/my.cnf
or any othermy.cnf
file which is used to configure your mysql.
Under the line [mysqld], add the line below:Code Block lower_case_table_names=1
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 | ||||||
---|---|---|---|---|---|---|
|
Multiexcerpt include | ||||||
---|---|---|---|---|---|---|
|
Initial Database Setup
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
- Create the above database and user by following these steps:
Connect to the database server: mysql> mysql -h host -u user -p
Enter password.
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. 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 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 6.5 if you want to run Tomcat as a service.