Mifos Quick Install

Owned by Ed Cable
Last updated: Feb 09, 2012Version comment
4 min read

This is quick installation guide using the executable WAR package built by Michael Vorburger.

  1. Set up folder and download Mifos
    1. Create a directory at the root-level of your local machine or on your web server. (i.e. C:/MifosInstall)
    2. Download Mifos: Save the Mifos download zip file to the folder you just created. Unzip or extract the contents of the folder here to Mifos Install. We're going to first install the other required software before installing Mifos.  
  2. Install and configure Java
    1. Before you do install a Java SDK, check to see if you have any previous versions of Java installed and uninstall them (unless you need them for something else) - either the JVM (Java Virtual Machine) or the JDK (Developers Kit)
    2. Download and install the Java SE JDK installer (JDK 6.0)
      1. Current version is JDK 6 Update 30 (as of Feb 5, 2012)
        1. Select x86 if you have a 32 bit Windows machine.
  3. Install and Configure MySQL
    1. Download mySQL Community Edition 5.1 and save to MifosInstall (choose Windows Essentials 32-bit version with MSI Installer)
    2. For the series of prompts, select the following parameters:
    3. Installation:
      1. Setup Type --> Typical
      2. After the Installation Wizard has complete, select to Configure the MySQL Server now and click Finish
    4. Configuration:
      1. Configuration Type --> Detailed
      2. Server Type --> Developer Machine
      3. Database Usage --> Multifunctional Database
      4. InnoDB Tablespace Settings --> C: Installation Path
      5. Number of Concurrent Users --> Decision Support (DSS)/OLAP
      6. Select Enable TCP/IP Networking, choose Port Number: 3306, select Enable Strict Mode
      7. Default Character Set --> Best Support for Multilingualism
      8. Install as Windows Service. Check to include bin directory in Windows PATH
      9. Set up your root password under security options. Select Modify Security Settings. Enter your root password and confirm it.   You can leave the password as its default, mysql, if you like.  Please note if you make any changes. 
        1. If you've previously installed a Mifos database, you'll need to authenticate with current root password before selecting a new one.
      10. Press Execute to Start Configuration.
    5. Configure my.ini file
      1. Locate your my.ini file in the folder where MySQL server is installed
      2. Open this file in a text editor and edit or add the following six parameters:

This is quick installation guide using the executable WAR package built by Michael Vorburger.

  1. Set up folder and download Mifos
    1. Create a directory at the root-level of your local machine or on your web server. (i.e. C:/MifosInstall)
    2. Download Mifos: Save the Mifos download zip file to the folder you just created. Unzip or extract the contents of the folder here to Mifos Install. We're going to first install the other required software before installing Mifos.  
  2. Install and configure Java
    1. Before you do install a Java SDK, check to see if you have any previous versions of Java installed and uninstall them (unless you need them for something else) - either the JVM (Java Virtual Machine) or the JDK (Developers Kit)
    2. Download and install the Java SE JDK installer (JDK 6.0)
      1. Current version is JDK 6 Update 30 (as of Feb 5, 2012)
        1. Select x86 if you have a 32 bit Windows machine.
  3. Install and Configure MySQL
    1. Download mySQL Community Edition 5.1 and save to MifosInstall (choose Windows Essentials 32-bit version with MSI Installer)
    2. For the series of prompts, select the following parameters:
    3. Installation:
      1. Setup Type --> Typical
      2. After the Installation Wizard has complete, select to Configure the MySQL Server now and click Finish
    4. Configuration:
      1. Configuration Type --> Detailed
      2. Server Type --> Developer Machine
      3. Database Usage --> Multifunctional Database
      4. InnoDB Tablespace Settings --> C: Installation Path
      5. Number of Concurrent Users --> Decision Support (DSS)/OLAP
      6. Select Enable TCP/IP Networking, choose Port Number: 3306, select Enable Strict Mode
      7. Default Character Set --> Best Support for Multilingualism
      8. Install as Windows Service. Check to include bin directory in Windows PATH
      9. Set up your root password under security options. Select Modify Security Settings. Enter your root password and confirm it.   You can leave the password as its default, mysql, if you like.  Please note if you make any changes. 
        1. If you've previously installed a Mifos database, you'll need to authenticate with current root password before selecting a new one.
      10. Press Execute to Start Configuration.
    5. Configure my.ini file
      1. Directly edit your my.ini file (this is located in the folder where MySQL server has been installed.
      2. In a text editor, or edit the following parameters:     
    6. max_connections=300
innodb_buffer_pool_size=1024M
      1. Add the following parameters:
    7. innodb_file_per_table
log-error=mysql_error.log
log-slow-queries=mysql_slow_query.log
long_query_time=1
      1. Save the changes.
    8. Create Mifos database and user
      1. Go into DOS command line (cmd) and log in using root account (password should be mysql unless you changed it)
      2. Once logged in, let's first create database by entering this command: 
      3. Confirm the database was created successfully by typing: 
      4. Now let's create the user, mifos, its password, and grant it the necessary privileges
        • The password is determined by the string that follows identified by. _For this example, I've made my password _nonsecure _but you should choose a secure password.  All commands would be different according to which password you select. So the command works like this: _GRANT ALL on '<DATABASE NAME>'.* to '<USER ID>'@'<HOST NAME>' identified by '<PASSWORD>'; 
        • Type the following (making necessary change for your password after "identified by") and press enter:
      5. Complete the user creation process, by entering the following command:
      6. Now let's exit out of MySQL command line by typing _exit _and pressing enter. 
    9. Initiate MySQL
      1. Next we need to initialize the Mifos database, by running the three commands below from the directory that contains this INSTALL file.  These commands assume a database username of "mifos" and in my case I'm using the password "nonsecure".  Adjust them if your database password is different
      2. MAKE EDIT REGARDING DB text
    10. Update local.properties file if you changed mysql password for user id mifos to something other than mifos
  4. Set up Environment Variables
    1. Â