Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:2xfaq_when_you_forgot_the_admin_password_to_log_in_to_biostar2_client [2020/01/02 14:11] nykwon [When you forgot the admin password to log in to BioStar 2 Client] - updated including the latest version |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{tag>"BioStar 2" Password}} | ||
| - | |||
| - | ====== When you forgot the admin password to log in to BioStar 2 Client ====== | ||
| - | <callout type="warning" icon="true"> | ||
| - | Instructions are diffrent based on your BioStar 2 version. Please check your BioStar 2 version before proceeding. | ||
| - | </callout> | ||
| - | |||
| - | ===== For BioStar Versions 2.6 and Above ===== | ||
| - | |||
| - | 1. Go to the following link [[https://www.python.org/downloads/windows/|https://www.python.org/downloads/windows/]] \\ | ||
| - | \\ | ||
| - | 2. Click Python version 2.7: \\ | ||
| - | {{:en:reset_biostar_2_1.png?600|}}\\ | ||
| - | \\ | ||
| - | 3. Download the Windows x86-64 MSI Installer.\\ | ||
| - | {{:en:reset_biostar_2_2.png?600|}}\\ | ||
| - | \\ | ||
| - | 4. Install with admin privileges. \\ | ||
| - | |||
| - | 5. Open **C:\Program Files\BioStar 2(x64)\util** (your BioStar 2 installation folder) with Windows Explorer. \\ | ||
| - | |||
| - | 6. Open enckey with a text editor. \\ | ||
| - | {{:en:reset_biostar_2_3.png?600|}}\\ | ||
| - | \\ | ||
| - | 7. Copy the **hash_key** value. \\ | ||
| - | {{:en:reset_biostar_2_4.png?600|}}\\ | ||
| - | \\ | ||
| - | 8. Download the following file: [[http://gofile.me/471Oh/CYLpHe6GK|BioStar2.6_admin_password_reset.zip]]\\ | ||
| - | <callout type="primary" icon="true"> | ||
| - | **Notification**: If you have upgraded under BioStar v2.6 and then upgraded to v2.6 or higher version, please use the below tool.\\ | ||
| - | [[BioStar2.6_admin_password_reset.zip|UpgradedBioStar2.6_gen_passwd_upgrade.zip]] | ||
| - | </callout> | ||
| - | |||
| - | |||
| - | 9. Paste the file to your Python folder (C: is default):\\ | ||
| - | {{:en:reset_biostar_2_5.png?400|}}\\ | ||
| - | \\ | ||
| - | 10. Download Visual C++ Compiler for Python 2.7: [[https://www.microsoft.com/en-us/download/confirmation.aspx?id=44266|link]]\\ | ||
| - | |||
| - | 11. Install the downloaded installer. \\ | ||
| - | |||
| - | 12. Go to (this is based on Windows 7) **Control Panel > System > Advanced system settings > Advanced > Environment Variables **\\ | ||
| - | |||
| - | 13. Create a new **user variable** as below: \\ | ||
| - | * Variable name: PYTHON_HOME\\ | ||
| - | * Variable value: [Your Python installation path] (i.e C:\Python27\)\\ | ||
| - | {{:en:reset_biostar_2_6.png?600|}}\\ | ||
| - | \\ | ||
| - | |||
| - | 14. On **system variables**, edit the **path** value by adding the item below to the end of the variable value: \\ | ||
| - | \\ | ||
| - | **;%PYTHON_HOME%;%PYTHON_HOME%\Scripts\; ** | ||
| - | \\ | ||
| - | \\ | ||
| - | * **edit**: if using windows 10, You will need to add values separately in a list. One value as **%PYTHON_HOME%** and another as **%PYTHON_HOME%\Scripts\**\\ | ||
| - | {{:en:reset_biostar_2_7.png?600|}}\\ | ||
| - | \\ | ||
| - | |||
| - | 15. Click **OK** and then **OK** to apply the settings. \\ | ||
| - | |||
| - | 16. Run command prompt with //administrator// privileges: \\ | ||
| - | |||
| - | 17. Type the following and press enter: **pip install pycrypto **\\ | ||
| - | {{:en:reset_biostar_2_8.png?600|}}\\ | ||
| - | \\ | ||
| - | |||
| - | \\ | ||
| - | 18. Go to your Python directory by entering **cd [python path name]** \\ | ||
| - | {{:en:reset_biostar_2_9.png?400|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 19. Enter the following: **python.exe gen_passwd.py [hashkey] [password]**\\ | ||
| - | |||
| - | * hashkey: the hashkey is val you copied in step 7\\ | ||
| - | * password: your new password\\ | ||
| - | |||
| - | \\ | ||
| - | For instance, if I wanted a new password of admin123 it would be as below: \\ | ||
| - | {{:en:reset_biostar_2_10.png?600|}}\\ | ||
| - | \\ | ||
| - | |||
| - | \\ | ||
| - | 20. If it ran successfully the result should show on the bottom row as below. Copy that value \\ | ||
| - | {{:en:reset_biostar_2_11.png?800|}}\\ | ||
| - | \\ | ||
| - | |||
| - | \\ | ||
| - | 21. Download [[http://www.heidisql.com/download.php?download=installer|HeidiSQL]].\\ | ||
| - | |||
| - | \\ | ||
| - | 22. Install and run HeidiSQL.\\ | ||
| - | |||
| - | |||
| - | \\ | ||
| - | 22. Enter the information below on **Settings**: \\ | ||
| - | |||
| - | * **Hostname/IP**: 127.0.0.1\\ | ||
| - | * **User**: root\\ | ||
| - | * **Password**: [your root password]\\ | ||
| - | * **Port**: 3312\\ | ||
| - | {{:en:reset_biostar_2_12.png?600|}}\\ | ||
| - | \\ | ||
| - | |||
| - | |||
| - | |||
| - | 24. Click **Open**.\\ | ||
| - | \\ | ||
| - | 25. Access Maria DB and open the **t_usr** table. \\ | ||
| - | \\ | ||
| - | |||
| - | 26. Paste the password into the **PW** column of your desired user:\\ | ||
| - | * Double click the row and then paste the value \\ | ||
| - | {{:en:reset_biostar_2_13.png?800|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | |||
| - | 27. Log in to BioStar 2 and check that the user password was reset. \\ | ||
| - | \\ | ||
| - | |||
| - | ===== For BioStar Versions 2.5 ===== | ||
| - | It is more complicated to reset your admin password in BioStar 2.5 because of new security features. Follow the steps below. \\ | ||
| - | \\ | ||
| - | 1. Go to the following link [[https://www.python.org/downloads/windows/|https://www.python.org/downloads/windows/]]\\ | ||
| - | \\ | ||
| - | 2. Click Python version 2.7: \\ | ||
| - | {{:en:2.5_reset_1.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 3. Download the **Windows x86-64 MSI Installer**.\\ | ||
| - | {{:en:2.5_reset_2.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 4. Install with admin privileges. \\ | ||
| - | \\ | ||
| - | 5. Access your BioStar 2 AC database. \\ | ||
| - | * Instructions on accessing your DB is shown in the following article: [[https://support.supremainc.com/a/solutions/articles/24000005906?lang=en|[BioStar 2] MariaDB Access and Account Configuration]]\\ | ||
| - | \\ | ||
| - | 6. **For BioStar 2.5 : Run the following query:**\\ | ||
| - | <code> | ||
| - | Use biostar2_ac; | ||
| - | SELECT VAL from t_syscfg where SYSCFGUID = '3000'; | ||
| - | </code> \\ | ||
| - | {{:en:2.5_reset_3.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 7. **For BioStar 2.5 : Right click and Copy the VAL row.**\\ | ||
| - | {{:en:2.5_reset_4.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 8. Download the attachment via the link: [[http://gofile.me/471Oh/1ROkW10J3|gen_passwd.py]]\\ | ||
| - | \\ | ||
| - | 9. Paste the file to your Python folder (C: is default):\\ | ||
| - | {{:en:2.5_reset_5.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 10. Download Visual C++ Compiler for Python 2.7: [[https://www.microsoft.com/en-us/download/confirmation.aspx?id=44266|link]]\\ | ||
| - | \\ | ||
| - | 11. Install the downloaded installer. \\ | ||
| - | \\ | ||
| - | 12. Go to (this is based on Windows 7) **Control Panel > System > Advanced system settings > Advanced > Environment Variables** \\ | ||
| - | \\ | ||
| - | 13. Create a new **user variable** as below: \\ | ||
| - | * Variable name: PYTHON_HOME\\ | ||
| - | * Variable value: [Your Python installation path] (i.e C:\Python27\)\\ | ||
| - | {{:en:2.5_reset_6.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 14. On **system variables**, edit the **path** value by adding the item below to the end of the variable value: \\ | ||
| - | \\ | ||
| - | **;%PYTHON_HOME%;%PYTHON_HOME%\Scripts\;** \\ | ||
| - | {{:en:2.5_reset_7.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 15. Click **OK** and then **OK** to apply the settings. \\ | ||
| - | \\ | ||
| - | 16. Run command prompt with //administrator privileges//: \\ | ||
| - | \\ | ||
| - | 17. Type the following and press enter: **pip install pycrypto** \\ | ||
| - | {{:en:2.5_reset_8.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 18. Go to your Python directory by entering **cd [python path name]** \\ | ||
| - | {{:en:2.5_reset_9.png?400|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 19. Enter the following: **python gen_passwd.py [hashkey] [password]**\\ | ||
| - | * hashkey: the hashkey is val you copied in step 7\\ | ||
| - | * password: your new password\\ | ||
| - | \\ | ||
| - | For instance if I wanted a new password of admin123 it would be as below: \\ | ||
| - | {{:en:2.5_reset_10.png?600|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 20. If it ran successfully the result should show on the bottom row as below. Copy that value \\ | ||
| - | {{:en:2.5_reset_11.png?600|}}\\ | ||
| - | \\ | ||
| - | 21. Access Maria DB again and open the t_usr table. \\ | ||
| - | \\ | ||
| - | 22. Paste the password into the PW column of your desired user:\\ | ||
| - | * Double click the row and then paste the value \\ | ||
| - | {{:en:2.5_reset_12.png?800|}}\\ | ||
| - | \\ | ||
| - | \\ | ||
| - | 22. Log in to BioStar 2 and check that the user password was reset. \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | ===== For BioStar Versions 2.3.0 to 2.4.1 ===== | ||
| - | |||
| - | <callout type="primary" icon="true"> | ||
| - | - This only applies to MariaDB which was implemented starting version 2.3.0 \\ | ||
| - | - Back up your database before proceeding. | ||
| - | </callout> | ||
| - | |||
| - | The bat. script below resets the default administrator of BioStar 2. \\ | ||
| - | |||
| - | <callout type="warning" icon="true"> | ||
| - | You must know the password of your MariaDB root account to reset your BioStar admin password. | ||
| - | </callout> | ||
| - | |||
| - | 1. Download the following file: {{:en:biostar2.3_resetpw.zip|}} \\ | ||
| - | 2. Extract the file. \\ | ||
| - | 3. Run the file with administrative privileges. \\ | ||
| - | 4. Follow the instructions in the script. \\ | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | ===== For BioStar Versions 2.0~2.2.2 ===== | ||
| - | |||
| - | <callout type="primary" icon="true"> | ||
| - | This only applies to the SQLite AC database up to version 2.2.2 | ||
| - | </callout> | ||
| - | |||
| - | When you forgot the login password for the BioStar2 administrator account, you may initialize the administrator password back to the default password. This process will requires you to install DB Browser for SQLite. You can download this application from the following website at http://sqlitebrowser.org. \\ Please download and install the package that compatible with your current operating system. | ||
| - | |||
| - | |||
| - | \\ | ||
| - | |||
| - | |||
| - | |||
| - | 1. Run DB Browser for SQLite. \\ | ||
| - | |||
| - | 2. Open existing BioStar2 database by selecting **Open Database** menu. The default location for BioStar2 db is **C:\Program Files (x86)\BioStar 2\db\biostar2.db**. \\ | ||
| - | |||
| - | {{:en:2x_forgot_pw_001.png?nolink&600|}} \\ | ||
| - | |||
| - | |||
| - | 3. Please go to the Execute SQL tab to run the following SQL query statement. \\ | ||
| - | * This will reinitialize an administrator password to “admin” which was the default admin password. | ||
| - | |||
| - | {{:en:2x_forgot_pw_002.png?nolink&600|}} \\ | ||
| - | |||
| - | <WRAP indent> | ||
| - | 1) Type the following query in the query editor. \\ | ||
| - | |||
| - | <code sql> | ||
| - | UPDATE T_USR SET PW="D0TCsGaK2r257qdAydJ6yrmG4mrmST2G4bT5Fz0aIeE=" WHERE USRID=1; | ||
| - | </code> | ||
| - | |||
| - | |||
| - | 2) Press {{:en:2x_forgot_pw_003.png?nolink|}} button or F5 to execute the query statement. \\ | ||
| - | |||
| - | {{:en:2x_forgot_pw_004.png?nolink&600|}} \\ | ||
| - | |||
| - | </WRAP> | ||
| - | |||
| - | |||
| - | 4. Click **Write Changes** button to save the changes. \\ | ||
| - | |||
| - | {{:en:2x_forgot_pw_005.png?nolink&600|}} \\ | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | 5. Open BioStar2 Client web site and please enter //admin// for both ID and password. \\ | ||
| - | |||
| - | {{:en:2x_forgot_pw_006.png?nolink&400|}} \\ | ||