...
- Java 1.8
- MySQL 5.7
- Redis
- WildFly 11
- Duration: 40 minutes
- Installation of New Versions:
- JDK 17
- MySQL 8.0
- Redis 5
- WildFly 30
- Duration: 1 hour 15 minutes
- Paths for all Tools
Wildfly30 – E:\uat_new\wildfly-30.0.0.Final\wildfly-30.0.0.Final
Redis5 – C:\Program Files\Redis
Java17 – C:\Program Files\Java\jdk-17.0.3.1
MySQL8 – F:\MYSQL8\MySQL\MySQL Server 8.0
- Database Schema Configuration changes:
- Duration: 2 hours
- Description:
...
| 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' */ ; |
After successfully restored schema need to execute all db access query in production/localmmu.
- 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.
...
sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
OpenKM Addition we have to do in below folder-
E:\uat_new\tomcat\bin\setenv.bat
Edit/open and past set "JAVA_HOME=C:\Program Files\Java\jdk1.8.0_202"