SMRT Portal Lost administrator password - pb-dyim/SMRT-Analysis GitHub Wiki

Option 1: You have another user account with administrator privileges, and you know the password for that user account:

• Login to SMRT Portal with the user account with the role of administrator
• Go to Admin -> Manage Users
• Select the administrator user
• Reset the administrator user's password
• A temporary password will be emailed to the administrator user's email address
• 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, you will need a mysql login:

• Login to mysql as root or using the smrtportal account. Password for smrtportal user is stored in $SEYMOUR_HOME/redist/tomcat/webapps/smrtportal/WEB-INF/classesMETA-INF/persistence.xml
• Set the role of a user account to "administrator"

  USE smrtportal; 
  UPDATE User SET role = 'administrator' WHERE name = '[the_user_name]'; 
  

• Follow the instructions above to reset the administrator password

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

• Login to mysql as root

• Delete the administrator user:

  USE smrtportal;
  DELETE FROM User WHERE name = 'administrator';
  

• Launch SMRT Portal

• Register with the user name "administrator" and set a password