Changing Unravel admin's password
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
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
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 | ######################################################|
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.
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, andID
: the ID from the query in Step 3.mysql> UPDATE users SET encrypted_password = '
HASH
' WHERE id =ID
AND login = '{LOGIN}' LIMIT 1;Navigate to the Unravel UI. Logout and then login with your new password.