SMRT Portal Lost administrator password - dyim42/SMRT-Analysis GitHub Wiki

Option 1: There are multiple accounts with administrator privileges, and you know the password for that user account:

1. Login to SMRT Portal with the user account with the role of administrator.
2. Go to Admin -> Manage Users.
3. Select the administrator user.
4. Reset the administrator user's password.
5. A temporary password will be emailed to the administrator user's email address.
6. Click the link in the email to login and change the password.

Option 2: If you have other user accounts, but none have administrator privileges, use dbadmin to temporarily set the account to have administrator role:

For example:

$SMRT_ROOT/current/admin/bin/dbadmin --command "USE smrtportal; SELECT name,role FROM User;"
+---------------+---------------+
| name          | role          |
+---------------+---------------+
| rsremote      | pacbio        |
| smrtpipe      | pacbio        |
| autodaemon    | pacbio        |
| administrator | administrator |
| user1         | scientist     |
+---------------+---------------+

We'll use the account name user1 to temporarily set the role to administrator.

$SMRT_ROOT/current/admin/bin/dbadmin --command "USE smrtportal; UPDATE User SET role = 'administrator' WHERE name = 'user1';"

Follow the instructions in Option 1 above to reset the administrator password.

Don't forget to restore the original role to user1!

$SMRT_ROOT/current/admin/bin/dbadmin --command "USE smrtportal; UPDATE User SET role = 'scientist' WHERE name = 'user1';"

###Option 3: If you only have one administrator account:

Delete the administrator user from the smrtportal DB and recreate it in the SMRT Portal UI.

$SMRT_ROOT/current/admin/bin/dbadmin --command "USE smrtportal; DELETE FROM User WHERE name = 'administrator';

Launch SMRT Portal and register a new account with the user name administrator.