...
- While restoring latest backup need to replace NO_AUTO_CREATE_USER in db routines
- Keep sql_mode in my.ini config file (MySQL 8)
| sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; |
| 3. As part of testing done below datatype change (MySQL 8) alter table db_iemr.t_phy_anthropometry modify BMI decimal(7,3); 4. Reserved keywords would be changed to MySQL supported columns. ex: system, value etc.(identified in Pr_Practioner sp) |
| DB Objects | Upgradation Issues | |
| Tables | 5(trigger related tables) | Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER. |
| Views | No Issues | |
| Procedures | All Procedures | Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER. Reserved keywords whould be changed toMysql supported columns. ex: system,value etc.(identified in Pr_Practioner sp) |
| Triggers | All Triggers | Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER. |
| Functions | No Issues | |
| Events | All Events | /*!50003 SET @saved_sql_mode = @@sql_mode */ ;; /*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; |
- Database Restoration:
- Duration: 2 hours
- Description: Restored the database from the backup created earlier.
- Creation of Database Users:
- Description: Created necessary database users with required privileges for operational needs.
- Configuration of WildFly:
- Description: Set up WildFly paths for Java and MySQL to ensure proper integration and functionality.
- Creation of Shortcuts:
- Description: Created necessary shortcuts on the desktop for quick access to the newly installed tools.
...
- Verification:
- Ensure all tools are functioning as expected.
- Verify database integrity and user access.
- Testing:
- Conduct thorough testing of the upgraded tools and configurations.
- Confirm that all integrations and functionalities are operational.
- Documentation:
- Installation guide added
Written by Avinash - Document on Tool Upgrade on War files
Time taken – 3hrs
Step 1 – All service line collected war files of tool upgrade.
Step 2 – Configuration changes done based UAT server IP/URL for all service line.
hwc-ui-next
tm-ui-next
mmu-ui-next
Ecd-ui-next
104api-v1.0
104ui-v1.0
1097api-v1.0
1097identity-0.0.1
1097ui-v1.0
adminapi-ecd-next
adminapi-v1.0
admin-ui-next
commonapi-ecd
commonapi-v1.0
ecdapi-v1.0
fhirapi-v1.0
flw-0.0.1
hwc-facility-service
hwc-inventory-ui-next
hwc-scheduler-ui-next
identity-0.0.1
identity-ecd
Inventoryapi-v1.0
inventory-ui-next
mmuapi-v1.0
scheduler-api-v1.0
scheduler-ui-next
tmapi-v1.0
Step 3 – Checked Java version. It was 8.0 and changed to 17.
Step 4 – Checked MySQL services started or not.
Step 5 – Created shortcut icon for Redis and standalone & Started Redis and Wild fly and 4 files taken pasted in deployment folder to deploy wars.
Step 6 – Application testing has to happen next step in UAT.