Reset chorusadmin password

Reset chorusadmin password

Follow these steps to reset chorusadmin user's password

Navigate to the Spotfire Data Science installation directory (by default "/usr/local/chorus"), and run this script ./chorus_rails_console.sh. It will open a new shell. In that new console run the following command to reset the chorusadmin user's password to "secret":

User.find(1).update_attribute(:password, "secret")
User.find(1).save

If you want to reset the password for any other user account the same way (instead of logging in as chorusadmin and resetting the password from the UI), from the same Spotfire Data Science installation directory run this script to start a PostgreSQL shell: ./chorus_psql.sh. Then run the following SQL query to get the user id (for the user whose password needs to be reset): 

select id,username from users;