Page History
Scrollbar | ||
---|---|---|
|
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
Answer
It depends. The LSD installation guide (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.
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 Block |
---|
Wiki Markup |
{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 |
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.
...
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.
...
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 |
...
|
...
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 |
Have a comment?
Please leave your comment in the caArray End User Forum.
Scrollbar | ||
---|---|---|
|