Differences

This shows you the differences between two versions of the page.

--- en:2xfaq_when_you_forgot_the_admin_password_to_log_in_to_biostar2_client [2017/10/12 08:21]
ethan 2.5 검수안되서 내용 수정함.
+++ 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
@@ Line 1: / Line 1: @@
 {{tag>"BioStar 2" Password}}
-===== 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">
+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 =====
+. Go to the following link [[https://www.python.org/downloads/windows/|https://www.python.org/downloads/windows/]] \\
+\\
+. Click Python version 2.7: \\
+{{:en:reset_biostar_2_1.png?600|}}\\
+\\
+. Download the Windows x86-64 MSI Installer.\\
+{{:en:reset_biostar_2_2.png?600|}}\\
+\\
+. Install with admin privileges. \\
+. Open **C:\Program Files\BioStar 2(x64)\util** (your BioStar 2 installation folder) with Windows Explorer. \\
+. Open enckey with a text editor. \\
+{{:en:reset_biostar_2_3.png?600|}}\\
+\\
+. Copy the **hash_key** value. \\
+{{:en:reset_biostar_2_4.png?600|}}\\
+\\
+. 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>
+. Paste the file to your Python folder (C: is default):\\
+{{:en:reset_biostar_2_5.png?400|}}\\
+\\
+. Download Visual C++ Compiler for Python 2.7: [[https://www.microsoft.com/en-us/download/confirmation.aspx?id=44266|link]]\\
+. Install the downloaded installer. \\
+. Go to (this is based on Windows 7)  **Control Panel > System > Advanced system settings > Advanced > Environment Variables **\\
+. 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|}}\\
+\\
+. 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|}}\\
+\\
+. Click **OK** and then **OK** to apply the settings. \\
+. Run command prompt with //administrator// privileges: \\
+. Type the following and press enter: **pip install pycrypto **\\
+{{:en:reset_biostar_2_8.png?600|}}\\
+\\
+\\
+. Go to your Python directory by entering **cd [python path name]** \\
+{{:en:reset_biostar_2_9.png?400|}}\\
+\\
+\\
+. 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|}}\\
+\\
+\\
+. If it ran successfully the result should show on the bottom row as below. Copy that value \\
+{{:en:reset_biostar_2_11.png?800|}}\\
+\\
+\\
+. Download [[http://www.heidisql.com/download.php?download=installer|HeidiSQL]].\\
+\\
+. Install and run HeidiSQL.\\
+\\
+. 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|}}\\
+\\
+. Click **Open**.\\
+\\
+. Access Maria DB and open the **t_usr** table. \\
+\\
+. 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|}}\\
+\\
+\\
+. 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. \\
+\\
+. Go to the following link [[https://www.python.org/downloads/windows/|https://www.python.org/downloads/windows/]]\\
+\\
+. Click Python version 2.7: \\
+{{:en:2.5_reset_1.png?600|}}\\
+\\
+\\
+. Download the **Windows x86-64 MSI Installer**.\\
+{{:en:2.5_reset_2.png?600|}}\\
+\\
+\\
+. Install with admin privileges. \\
+\\
+. 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]]\\
+\\
+. **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|}}\\
+\\
+\\
+. **For BioStar 2.5 : Right click and Copy the VAL row.**\\
+{{:en:2.5_reset_4.png?600|}}\\
+\\
+\\
+. Download the attachment via the link: [[http://gofile.me/471Oh/1ROkW10J3|gen_passwd.py]]\\
+\\
+. Paste the file to your Python folder (C: is default):\\
+{{:en:2.5_reset_5.png?600|}}\\
+\\
+\\
+. Download Visual C++ Compiler for Python 2.7: [[https://www.microsoft.com/en-us/download/confirmation.aspx?id=44266|link]]\\
+\\
+. Install the downloaded installer. \\
+\\
+. Go to (this is based on Windows 7)  **Control Panel > System > Advanced system settings > Advanced > Environment Variables** \\
+\\
+. 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|}}\\
+\\
+\\
+. 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|}}\\
+\\
+\\
+. Click **OK** and then **OK** to apply the settings. \\
+\\
+. Run command prompt with //administrator privileges//: \\
+\\
+. Type the following and press enter: **pip install pycrypto** \\
+{{:en:2.5_reset_8.png?600|}}\\
+\\
+\\
+. Go to your Python directory by entering **cd [python path name]**  \\
+{{:en:2.5_reset_9.png?400|}}\\
+\\
+\\
+. 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|}}\\
+\\
+\\
+. If it ran successfully the result should show on the bottom row as below. Copy that value \\
+{{:en:2.5_reset_11.png?600|}}\\
+\\
+. Access Maria DB again and open the t_usr table. \\
+\\
+. 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|}}\\
+\\
+\\
+. 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>
+. Download the following file: {{:en:biostar2.3_resetpw.zip|}} \\
+. Extract the file.  \\
+. Run the file with administrative privileges.  \\
+. Follow the instructions in the script.  \\
-==== For BioStar Versions 2.0~2.2.2 ====
+===== For BioStar Versions 2.0~2.2.2 =====
 <callout type="primary" icon="true">
@@ Line 53: / Line 276: @@
 {{:en:2x_forgot_pw_006.png?nolink&400|}} \\
-==== 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>
-. Download the following file: {{:en:biostar2.3_resetpw.zip|}} \\
-. Extract the file.  \\
-. Run the file with administrative privileges.  \\
-. Follow the instructions in the script.  \\