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:

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;

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

Have a comment?

Please leave your comment in the caArray End User Forum.