Versions Compared

Old Version 133

changes.mady.by.user Tom Castle

Saved on

compared with

New Version 134

changes.mady.by.user Sampath Kumar G

Saved on

Key

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


For Video guide - Click on the below link

Widget Connector
width700
urlhttps://www.youtube.com/watch?v=mYVMboSZ9Rs
height200


Panel

On this page:

Table of Contents
maxLevel3
minLevel3
printablefalse


...

Prerequisite Software's   

 Note:- Below are mandatory prerequisite software's with mentioned versions only

  • JAVA DEVELOPMENT KIT >> VERSION 1.8.0_65 & above                                
  • MYSQL SERVER >> Version 5.5 or 5.6
  • TOMCAT >> Version 7.0.64.0 & above


  •  

    Install Java 

1) Before beginning, uninstall any existing versions of Java currently on your computer. 

2) In your web browser, go to http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html, to download JAVA 1.8.

3) Oracle requires that you read the license agreement, then click the button labeled Accept License Agreement.

4) Click the link to download with respect to you system architect i.e Windows x86 for 32bit or Windows x64 for 64bit. 

5) Save the Java installation file to your computer

6) Run & install the Java file.

...

  •  Initialize MySQL data 

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

2) Run the Heidisql installation file & setup Heidisql: 

i) For local - Provide mysql password as mysql. 

ii) Click on Save button.

iii) Click on open button. 

                                                                                                                           

4) Copy the following database command and paste it into the large white box titled Query
create database `mifosplatform-tenants`; create database `mifostenant-default`; use `mifosplatform-tenants`;



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

 

6) On heidisql, click on File>>Load SQL file..

7) Through Load SQL file window,

  • Navigate to the location where you extracted the Mifos application files.
  • Navigate to the database folder, inside that location.
  • Select the file mifospltaform-tenants-first-time-install.sql and click Open.

Run the first-time-install script, by clicking Run Query button & once its successful close heidisql application.


  •  

    Tomcat - Setup

1) Setting up Lib folder

a) Download mysql jdbc 5.1.27 jar file from http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.27/mysql-connector-java-5.1.27.jar

b) Once it's downloaded copy & paste it to lib folder, Go to Tomcat>>lib folder. 

Note: If tomcat-jdbc.jar file is not available in the tomcat>>lib folder then you could download and paste it from: http://www.java2s.com/Code/JarDownload/tomcat-jdbc/tomcat-jdbc.jar.zip

2) Generate keystore

 Generate a new keystore using java keytool :

>> Open command prompt 
>> Go to the path where your JAVA>>bin folder is located. 
>> Run this command to generate the key: keytool -genkey -alias tomcat -keyalg RSA
>> Then provide the password. 
For example: 


Provide input and type in y for the last question to confirm. 


Note: Once the keystore is created, it should be placed in your home directory. For Example: C:/Users/john/.keystore

3) Configure server.xml page,

a) Go to  tomcat>>conf>>open server.xml with notepad:


b) Delete everything in it and copy-paste the following right side entire content of the page code:

c) Once content is pasted in server.xml, Below mentioned are to be modified with respect to your system & settings:
i - Key store path should be modified with your key store path location Example:- keystoreFile="C:/Users/john/.keystore"
ii - Key store password (which was provided while creating the key), should be modified Example:- keystorePass="xyz123"
iii - MYSQL credentials should be modified
Example:- username="root" & password="mysql"                                                                                                     

<?xml version='1.0' encoding='utf-8'?>
<Server port="8005" shutdown="SHUTDOWN">
<Listener className="org.apache.catalina.core.JasperListener" />
<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
<Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" />

<GlobalNamingResources>
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml"
/>

<Resource type="javax.sql.DataSource"
name="jdbc/mifosplatform-tenants"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost:3306/mifosplatform-tenants"
username="root"
password="mysql"
initialSize="3"
maxActive="10"
maxIdle="6"
minIdle="3"
validationQuery="SELECT 1"
testOnBorrow="true"
testOnReturn="true"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
/>
</GlobalNamingResources>

<Service name="Catalina">

<Connector protocol="org.apache.coyote.http11.Http11Protocol"
port="443" maxThreads="200" scheme="https"
secure="true" SSLEnabled="true"
keystoreFile="C:/Users/john/.keystore"
keystorePass="xyz123"
clientAuth="false" sslProtocol="TLS"
URIEncoding="UTF-8"
compression="force"
compressableMimeType="text/html,text/xml,text/plain,text/javascript,text/css"/>

<Engine name="Catalina" defaultHost="localhost">

<Realm className="org.apache.catalina.realm.LockOutRealm">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase"/>
</Realm>

<Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true">

<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"
prefix="localhost_access_log." suffix=".log"
pattern="%h %l %u %t &quot;%r&quot; %s %b" />
</Host>
</Engine>
</Service>
</Server>

 

4) Save modified server.xml page

Press Ctrl + S or File>Save. 

 5) Close Notepad. 

...