Page Comparison

1) Download HEIDISQL from http://www.heidisql.com/download.php and save the installation file to your computer.

2) Run the Heidisql installation file and setup Heidisql: 

i) Click on local and enter the MySQL password (mysql) in the Password field. 

ii) Click on the Save button.

iii) Click on the Open button. 

4) Copy the following database command and paste it into the large white box titled Query
create database `fineract_tenants`; create database `fineract_default`; 

This is all you have to do for mifos 21.07.01 and above - there is not need to 

5) Click on the Run button to execute the query. 

1) Setting up the Lib folder

a) Download the mysql jdbc 8.0.21 jar file from here

b) Once it's downloaded, copy the file and paste it to the Tomcat>>lib folder. 

2) Generate keystore

 Generate a new keystore using the Java keytool :

i) Open Command Prompt 
ii) Navigate to the path where your JAVA>>bin folder is located. 
iii) Run this command to generate the key: 

keytool -genkey -alias tomcat -keyalg RSA

or

keytool -genkey -keyalg RSA -keysize 2048 -alias tomcat

-(add a key size parameter of size 2048 as some browsers will not display the UI)
iv) Then provide the password. 
For example: 


Answer the questions and then type y after the last question to confirm. 

3) Configure server.xml page,

a) Go to tomcat>>conf, rename to server.xml file as server.bkp

b)Download server.xml file from here and move the downloaded file to the folder 'tomcat>>conf'