Versions Compared

Old Version 109

changes.mady.by.user KeithE

Saved on

compared with

New Version 110

changes.mady.by.user KeithE

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.

...

  •  

    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. 

...