Page History

{scrollbar:icons=false}

h1. Question: Do I need to create an empty database prior to caArray or other LSD tool installations?

*Topic*: caArray Installation and Upgrade

*Release*: Up to caArray 2.X

*Date entered*: 01/09/2009

h2. Answer

It depends. The [LSD installation guide|https://gforge.nci.nih.gov/frs/?group_id=450] (pages 8 and 9) recommends setting up an empty database prior to any LSD tool installation, except for those tools that do not require a database (see table below).

caArray, however, has a different database requirement based on the caArray version being installed.

h3. caArray Release 2.1.1 and above

An empty database has to be created before commencing the caArray Installation.

*Step 1*: Login as an admin user (the root user or a user with administrative privileges). Create the caArray database via SQL commands as below:

{code}
CREATE DATABASE <DB NAME> DEFAULT CHARACTER SET latin1;
GRANT ALL ON <DB NAME>.* TO '<CAARRAY DB USER>'@'localhost' IDENTIFIED BY '<CAARRAY DB USER PASSWORD>' WITH GRANT OPTION;
GRANT ALL ON <DB NAME>.* TO '<CAARRAY DB USER>'@'%' IDENTIFIED BY '<CAARRAY DB USER PASSWORD>' WITH GRANT OPTION;
{code}

*Step 2*. In the install.properties (or respective GUI installer fields), the user should specify <CAARRAY DB USER>/<CAARRAY DB USER PASSWORD> as database.user/database.password.

During the installation, only the caArray DB connection user credentials are required, and the installer verifies that the specified DB already exists and will not allow installation to proceed until satisfied.

It is worth mentioning: there is no need to pre-create any database table for caArray, since the installer will drop all existing caArray tables during caArray installation process.

h3. Prior to caArray Release 2.1.1

There is no need to create an empty database before beginning the installation of caArray 2.1.0 or older. The installer would ask for the root user/admin-level user credentials and create the caArray DB *and* execute the DDL SQL for caArray schema.

h3. Summary of Database Requirements for LSD Tools

*Summary of Database Requirements for LSD Tools*
|| Tools || Use database? || Pre-installed Database Required? ||
|| caArray | Y | Y for version 2.1.1 and above \\
N for older version ||
|| caIntegrator2 | Y | Y ||
|| caGwas | Y | Y ||
|| caTissues | Y | Y ||
|| CTODs | Y | Y ||
|| geWorkbench | N/A | N/A ||
|| LSD Browser | N/A | N/A ||
|| NCIA | Y | Y ||
|| UPT | Y | Y ||

h2. Have a comment?

Please leave your comment in the [caArray End User Forum|https://cabig-kc.nci.nih.gov/Molecular/forums/viewtopic.php?f=6&t=577].

{scrollbar:icons=false}