Versions Compared

Old Version 8

changes.mady.by.user Srinivas Tirunahari

Saved on

compared with

New Version Current

changes.mady.by.user Avinash Sharma

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

    • Java 1.8
    • MySQL 5.7
    • Redis
    • WildFly 11
    • Duration: 40 minutes
  2. 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
  3. Database Schema Configuration changes:
    1. Duration: 2 hours
    2. Description:

...

DB ObjectsUpgradation Issues
Tables5(trigger related tables)Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER.,
ViewsNo Issues
ProceduresAll ProceduresDump 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)
TriggersAll TriggersDump files created with an earlier version of mysqldump must be modified
manually to remove instances of NO_AUTO_CREATE_USER.,
FunctionsNo Issues
EventsAll 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. 

  1. Database Restoration:
    • Duration: 2 hours
    • Description: Restored the database from the backup created earlier.
  2. Creation of Database Users:
    • Description: Created necessary database users with required privileges for operational needs.
  3. Configuration of WildFly:
    • Description: Set up WildFly paths for Java and MySQL to ensure proper integration and functionality.
  4. Creation of Shortcuts:
    • Description: Created necessary shortcuts on the desktop for quick access to the newly installed tools.

...

  • Database Backup: 2 hours
  • Uninstallation+Installation: 1 hour 15 Minutes
  • Database Restoration: 2 hours
  • Configuration and Setup: 2 hours
  • Total Time: 7 Hours 45 15 Minutes

Next Steps:

  1. Verification:
    • Ensure all tools are functioning as expected.
    • Verify database integrity and user access.
  2. Testing:
    • Conduct thorough testing of the upgraded tools and configurations.
    • Confirm that all integrations and functionalities are operational.
  3. Documentation:
    • Installation guide added 

...

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"