How to reset omnisci user password

Usage
#1

How to reset the “omnisci”. i forget the password, however have OS root access.

#2

Hi @Sumit,

Long time no see in the community; Welcome back.

I guess you want to reset the admin password of a 5.xx Omnisci database instance; remember that the default one is HyperInteractive, but if you are asking, I guess you changed it.

I’m not sure this is the most canonical way, but it worked for me.

stop the database service, then

> cd /var/lib/omnisci/data/mapd_catalog
> cp omnisci_system_catalog omnisci_system_catalog.backup
> sqlite3 omnisci_system_catalog 
> update mapd_users set passwd_hash='$2a$12$Pbmob/9UadazhuFHl7JUvu.UvykqqlwfZJfCG/.ysGNUfl4qsvCVa' where userid=0;
> .exit

After this, just login into the system using password as a password and alter it to change the password.

mapd@zion16:/var/lib/omnisci/data/mapd_catalogs$ /opt/mapd/omnisci-os-5.4.1-20200928-3d17eec6c1-Linux-x86_64/bin/omnisql -p password
User admin connected to database omnisci
omnisql> alter user admin (password = 'your_new_password');

if you haven’t installed the sqlite3 command, you can install with apt or rpm; on Ubuntu, you have to run this command

sudo apt install sqlite3.

Have fun with omnisci db :wink:

#3

Hi @candido.dessanti,

thank you for feedback. Now you will see me more active as last few months was trying to balance life in Covid Era.

I will try the above steps and will update you.

Regards,
sumit

1 Like
#4

Hi @Sumit,

It will be nice to have you more active from now on. Covid has upset everyone’s life.

The most importanti thing is that everyone is well and safe :wink: