Home

Changing Unravel admin's password

  1. Retrieve the following configurations from the /usr/local/unravel/etc/unravel.properties file.

    unravel.jdbc.url=jdbc:$ENGINE://$HOST:$PORT/$DATABASE
    unravel.jdbc.username=$USERNAME 
    unravel.jdbc.password=$PASSWORD
    
  2. Connect to your database (either MySQL) CLI using one of the following methods. We use MySQL in this example.

    • Run the db_access.sh script

      /usr/local/unravel/install_bin/db_access.sh
      
    • Open your database's (MySQL CLI) command line.

      mysql -u $USER -h $HOST $DATABASE -p 
  3. Query for the user whose password you want to change and keep track of its "id" field.

    mysql> use $DATABASE; 
    mysql> select id, login, encrypted_password from users;
    +----+-------+-------------------------------------------------------+ 
    | id | login | encrypted_password                                    | 
    +----+-------+-------------------------------------------------------+ 
    | 1  | admin | ######################################################|
  4. Use the bcrypt library to generate a new encrypted password.

    Navigate to Bcrypt-Generator.com. Enter your desired password and select at least 10 rounds of hashing. Save the hash.

  5. Update the record in the database with the new hash. Replace your local value for HASH: hash value you generated, USER with the user whose password you are changing, and ID: the ID from the query in Step 3.

    mysql> UPDATE users SET encrypted_password = 'HASH' WHERE id = ID AND login = '{LOGIN}' LIMIT 1;
  6. Navigate to the Unravel UI. Logout and then login with your new password.