Home

Configure Unravel with 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'@'localhost' 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:

    unravel.jdbc.username=Unravel Database User
    unravel.jdbc.password=Unravel Database Passwordunravel.jdbc.url=jdbc:mysql://localhost:3306/unravel_mysql_prod
    unravel.jdbc.url.params=useSSL=true&requireSSL=false

    Important

    If you installed MySQL 8.0, add:

    unravel.jdbc.url.params=disableMariaDbDriver
  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
  4. Create a database/tables for Unravel tables.

    /usr/local/unravel/dbin/db_schema_upgrade.sh