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 or Postgres) 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 or Postgres) 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} 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.

In this section: