Home

Configuring MySQL

After installing the Unravel, complete the following steps.

1. Copy the MySQL JDBC JAR to /usr/local/unravel/share/java/.
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
2. Configure Unravel to connect to the MySQL server.
  1. Using mysql, create a database and user for Unravel.

    mysql
    mysql> CREATE DATABASE unravel_mysql_prod;
    mysql> CREATE USER 'unravel'@'localhost' IDENTIFIED BY 'password';
    mysql> GRANT ALL PRIVILEGES ON unravel_mysql_prod.* TO 'unravel'@'localhost';

    Note

    In the case of MySQL 8.0, the client does not support the authentication protocol requested by the server and there can be a failed connection to the database. Run the following to resolve this authentication issue:

    ALTER USER 'unravel'@'unravel-host' IDENTIFIED WITH mysql_native_password BY 'password';flush privileges;

    Where unravel is your user, unravel-host is the URL, and password is your password.

  2. In /usr/local/unravel/etc/unravel.properties, update the following properties:

    For example,

    unravel.jdbc.username=unravel
    unravel.jdbc.password=password
    unravel.jdbc.url=jdbc:mysql://127.0.0.1:3306/unravel_mysql_prod

    Important

    If you installed MySQL 8.0, add:

    unravel.jdbc.url.params=disableMariaDbDriver
  3. Create a schema for Unravel tables.

    sudo /usr/local/unravel/dbin/db_schema_upgrade.sh
  4. Important

    This step is not needed as of Unravel v4.5.2.

    Create the default admin user for Unravel UI.

    sudo /usr/local/unravel/install_bin/db_initial_inserts.sh | sudo /usr/local/unravel/install_bin/db_access.sh