Home

Configure and restart Unravel
Configure Unravel with Azure MySQL

  1. Using MySQL, create a database and user for Unravel. Enter MySQL admin login password when prompted:

    mysql> CREATE DATABASE unravel_mysql_prod;
mysql> CREATE USER 'Unravel database user'@'MySQL server name' IDENTIFIED BY 'Unravel database password';
mysql> GRANT ALL PRIVILEGES ON unravel_mysql_prod.* TO 'Unravel database user'@'MySQL server name';

  2. Configure MySQL in /usr/local/unravel/etc/unravel.properties. Check Azure MySQL resource page for property values.

    unravel.jdbc.username=Unravel database user
unravel.jdbc.password=Unravel database password
unravel.jdbc.url=jdbc:mysql://MySQL Server name:3306/unravel_mysql_prod
unravel.jdbc.url.params=useSSL=true&requireSSL=false

  3. Install MySQL JDBC connector driver in Unravel classpath.

    wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.47.tar.gz -O /tmp/mysql-connector-java-5.1.47.tar.gz

cd /tmp
tar xvzf /tmp/mysql-connector-java-5.1.47.tar.gz
sudo mkdir -p /usr/local/unravel/share/java

sudo cp /tmp/mysql-connector-java-5.1.47/mysql-connector-java-5.1.47.jar /usr/local/unravel/share/java

sudo cp /tmp/mysql-connector-java-5.1.47/mysql-connector-java-5.1.47.jar /usr/local/unravel/dlib/unravel

  4. Create database and tables for Unravel.

    /usr/local/unravel/dbin/db_schema_upgrade.sh
Configure Unravel with Workspace

  1. Go to Workspace> Admin Console> Access Control and enable Personal Access Tokens. See Enable token-based authentication.

  2. Go to Workspace> User Settings> Access Tokens and click Generate New Token. See Authenticate using Databricks personal access tokens. Choose the lifetime of the token as indefinite.

  3. Install Unravel agents on the Workspace and update Unravel config with the Workspace details. See Running the Databricks_setup.sh script

    Note

    Run the following commands only if the Databricks command-line tool is installed using Python virtual environment:

    sudo bash
virtualenv -p /usr/bin/python3 mypy3
source mypy3/bin/activate
    usr/local/unravel/install_bin/databricks_setup.sh --add-workspace -i <Workspace id> -n <Workspace name> -t <Workspace token> -r https://<Workspace location>.azuredatabricks.net -p <Workspace_tier> -u <Unravel DNS or IP address>:4043
Restart Unravel

  1. Restart all Unravel services

    service unravel_all.sh restart

  2. Using a supported web browser, (see ​Unravel's ​​Azure Databricks​ compatibility matrix), navigate to http://unravel-host:3000 and log in with username admin with password unraveldata.

    signin.png
In this section: