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
In this section: