| Subject: | Encrypt TNA devices "Linked Server Password" in the database |
| Summary: | Menu: Forms-ESS/Timesheets/TimesheetDeviceSetup.aspx Encrypt TNA devices "Linked Server Password" in the database |
| Audit Notes: | Edited by sanjay on 25/02/21 08:51. Edited by alvis on 07/12/20 08:51. |
| 07 Dec 2020 | 08:34AM Comment 1 by Alvis (Link Technologies) Case L12087 added to project 12.3 |
| 07 Dec 2020 | 08:51AM Comment 2 by Alvis (Link Technologies) ETC was changed from 25/07/2020 to 25/07/2020 |
| 07 Dec 2020 | 08:52AM Comment 3 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 09-12-2020 08:50 AM Time Taken: 4.00 |
| Development work for this case has been completed. The change will be available in version:12.30.1204 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - Encrypted the TNA device linked server password
- Refactored code to decrypt where necessary
2. Affected Areas: - TNA Device Setup
3. The issue was caused by: - Improvement
4. Notes:
5. Next Step: UAT ---------------------- Development Reference: |
|
| 24 Dec 2020 | 10:00AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-12-2020 09:59 AM Time Taken: 1.00 |
| System test completed. Proceed with UAT |
|
| 24 Dec 2020 | 02:20PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 30-12-2020 02:13 PM Time Taken: 1.00 |
| QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues | No | Test Description | Pass/Fail | | 1 | - Activate TNA device T1004 with the "Linked Server Password" as 8989.
- Edit the record to see that the password is hashed
- Validate that the password is encrypted in the table "LT_ESS_TimesheetImport_Devices" for company 1001.
| Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 12.30.1224BETA
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-123
Next Step: - For Closure
|
|
| 04 Jan 2021 | 03:24PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-01-2021 03:24 PM |
| Thanks Rashna |
|