Reveal uses a different user directory than Kinetica, therefore resetting Kinetica's admin password doesn't reset Reveal's admin password. To reset the password to Reveal's default "admin/admin" combination follow the steps outlined below.
- On Kinetica's server navigate to:
- Open caravel.db file:
sqlite> .open ../var/caravel.db
- Run the update command exactly as below:
sqlite> update ab_user set password = 'pbkdf2:sha1:1000$K3bMphfr$65a0961a52002fe6c61f7497c36a6dfe70824aa7' where username = 'admin';
- Log into Reveal using "admin/admin" combination
Note: As a best practice change the default password to prevent security incidents.