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 [2019/12/31 15:50] nykwon [When you forgot the admin password to log in to BioStar 2 Client] - updated the latest version |
en:2xfaq_when_you_forgot_the_admin_password_to_log_in_to_biostar2_client [2020/01/28 14:38] nykwon [When you forgot the admin password to log in to BioStar 2 Client] - deleted (confidential) |
||
---|---|---|---|
Line 3: | Line 3: | ||
====== When you forgot the admin password to log in to BioStar 2 Client ====== | ====== When you forgot the admin password to log in to BioStar 2 Client ====== | ||
<callout type="warning" icon="true"> | <callout type="warning" icon="true"> | ||
- | This article is outdated. It is updated in the following link: | + | Instructions are diffrent based on your BioStar 2 version. Please check your BioStar 2 version before proceeding. |
- | [[http://support.supremainc.com/solution/articles/24000016527--biostar-2-resetting-the-biostar-server-admin-user-password|Freshdesk FAQ]] | + | |
</callout> | </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 ===== | ===== For BioStar Versions 2.3.0 to 2.4.1 ===== | ||