Datameer Installation Guide

To install Datameer you need to do the following:

1. Specify an installation folder and unzip the files.
2. Download and install the database drivers. (Not required for evaluation purposes.)
3. Configure Datameer required and optional settings and initialize the database.
4. Install the license.
5. Run the application.
6. Login and change the default admin password following the instructions in: Managing User Accounts

Note: The default username and password are admin and admin.

Each of these steps is documented in the sections that follow. If you are upgrading from a previous version, see the Upgrade Instructions.

Downloading and Unzipping the Software

• Download the latest release from: my.datameer.com
  Select the installation archive appropriate to your system configuration (see Supported Hadoop Distributions).

• Specify a location to install software to such as: /usr/local/das-<version>

• Expand the archive to that location.

• Change the working directory to the newly created directory.

Configuring Datameer

• Configure Datameer by editing etc/das-env.sh. The configuration file is well documented.
• Depending on what value is used in the etc/das-env.sh for "DAS_DEPLOY_MODE", you will need to edit the corresponding properties file to update the IP/host. I.e., If using "export DAS_DEPLOY_MODE=live", update the <DAS HOME>/conf/live.properties. Change the key "system.property.server.address" to reflect the IP/host & port of the server Datameer is installed on.
  
  
• When configuring etc/das-env.sh, the DAS_DEPLOY_MODE is defaulted to "trial".  If you are using MySQL please change "trial" to "live".

Setting up a MySQL Database (Optional)

If you are evaluating Datameer You can use an HSQL database on your local filesystem and there is no need to set up an external database. If you are setting up Datameer for production use, we recommend using MySQL.

Migrating from HSQL to MySQL Datameer provides a tool to migrate data from an HSQL file database to a MySQL database: Configure Datameer for MySQL (see below) Migrate HSQL database to MySQL:

Configuring Datameer for MySQL

• By default, the application runs with the HSQL file database that is created on the local filesystem (under das-data/database/hsql-db). If you want to run the application in MySQL mode, change the DAS_DEPLOY_MODE property in the das-env.sh as follows:
• To specify different database credentials make the following two changes:

  • Change the MySQL database credentials in the create database script:

  • Change the MySQL database credentials in the persistence.xml file. Update the properties for hibernate.connection.username, hibernate.connection.password, and hibernate.connection.url in the MySQL persistence unit.
  • Default credentials for MySQL are user: dap, password: dap.

• Initialize the database with the following commands:

  You will be prompted to enter the password to access the database.

• Downgrading Datameer versions

Installing the MySQL JDBC Database Drivers

• Download the official MySQL JDBC driver Zip file from http://www.mysql.com/downloads/connector/j/using one of the two following commands:

  or

• Extract the driver from the archive file.

• Copy the mysql-connector jar file from the extracted archive to etc/custom-jars:

Installing the License

If you have already received a license from Datameer, copy the license file to: $INSTALL_LOCATION/das-<version>/etc/license

If you do not have a license, email license@datameer.com.

Note: The file must be named license.lic or it will not work.

If you attempt to launch the application without a license you will receive an error message asking you to contact Datameer for a license file. Please include the MAC address listed in this error message when contacting Datameer for a license. License information and usage can be viewed at any time by clicking the Administration tab and clicking Licenses.

See License Information for information on how to update the license and for details about volume-based licensing.

Running the application

You can start, stop, and restart the application by going to the /bin folder and entering commands.

Note: The log file is written to logs/conductor.log using log4j (http://logging.apache.org/log4j/1.2/index.html).

To change log behavior, edit conf/log4j-default.properties or write your own log property file. (Tip: When you define settings in conf/log4j-customized.properties use customized as the log4jConf start parameter).

Starting the application

• To start the application, enter the following command:

• Optionally, to start the application using example data and workbooks, enter the following command. You need to edit the injected SCP data store "example_scp_datastore" and enter the SSH credentials of the application.

Stopping the application

• To stop the application, enter the following command:

Restarting the application

• To restart the application, enter the following command:

Installing Custom Database Drivers

• Optional: You can install custom database drivers to connect to other types of databases. This step allows you to import your existing data into Datameer and Hadoop.
  For a listing of supported databases and other details, see How to Install Database Drivers.

Special Settings

The following settings should only be used in exceptional cases.

MySQL Installation Guide

MySQL is used for the Datameer metastore--where Datameer stores its metadata.

Installing MySQL on Fedora

• To install the MySQL server, enter the following command.

  yum install mysql-server
  

• To start MySQL, enter the following command.

  /etc/init.d/mysqld start
  

Where to go from here

If you are a Datameer system administrator, see the Administrator's Guide.