Versions Compared

Old Version 176

changes.mady.by.user Mike Mayott

Saved on

compared with

New Version 177

changes.mady.by.user Karl Horning

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Small stylistic changes (replace '&' with 'and' when used in sentences); small grammatical corrections (capitalised the names of the buttons, removed orphaned periods, etc.).


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   

 NOTE: the software and versions included below are a mandatory prerequisite

  • 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 the version for your system architecture i.e. Windows x86 for 32bit or Windows x64 for 64bit. 

5) Save the Java installation file to your computer

6) Run and install the Java file.

...

  •  Initialize MySQL data 

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) For local - Provide mysql password as mysqlClick on local and enter the MySQL password (mysql) in the Password field. 

ii) Click on the Save button.

iii) Click on open the 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 the Run button to Execute execute the query. . 

 

6) On In the heidisql menu bar, click on File>>Load SQL file...

7) Through In the 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 . Once it's successful close the 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. 

...