This is an abbreviated guide to help non-developers get started with Mifos on Ubuntu using a release zip file. See this guide if you prefer to build from source.

Quick Start

prerequisites

Walk through only the following steps in the install-from-source guide:

• install Ubuntu
• install prerequisites

Continue with the following steps below.

set up database

If you're deploying a Mifos version prior to 1.6.0, you must work around issue 1513. Create a file named mifos.cnf in /etc/mysql/conf.d/ and put in it:

[mysqld]
# due to issue 1513
lower_case_table_names = 1
# optional, but saves disk space
innodb_file_per_table

Restart the database for the new settings to take effect

sudo /etc/init.d/mysql restart

Then

• Create mifos database. Use:

  No Format
  ~$ mysql -u root -p mysql> CREATE DATABASE mifos; mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mifos | | mysql | +--------------------+

• Grant permissions to user 'mifos' (doing these grants more than once has no effect). If you choose a different user name and password, adjust these instructions accordingly:

  No Format
  mysql> GRANT ALL on mifos.* to 'mifos'@'localhost' identified by 'mifos'; mysql> FLUSH PRIVILEGES;

• test database connection as user 'mifos'

  No Format
  mysql -u mifos -pmifos mifos

get the install package

Download Mifos Unpack the archive into /tmp.

create production tables

In the directory where you unpacked the archive, do:

mysql -D mifos -u mifos -pmifos < sql/latest-schema.sql
mysql -D mifos -u mifos -pmifos < sql/latest-data.sql
mysql -D mifos -u mifos -pmifos < sql/init_mifos_password.sql

application database connection

Mifos version 1.2 and earlier

Configure the Web application's database connection by creating a file called deploymifosDB.properties containing the following:

hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/mifos?useUnicode=true&characterEncoding=UTF-8
hibernate.connection.username=mifos
hibernate.connection.password=mifos
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false
hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider
hibernate.connection.isolation=2

hibernate.c3p0.acquire_increment=5
hibernate.c3p0.idle_test_period=30
hibernate.c3p0.max_size=100
hibernate.c3p0.max_statements=0
hibernate.c3p0.min_size=20
hibernate.c3p0.timeout=30

Place this file on the AppServerClasspath, for instance, in $HOME/tomcat6/lib.

Mifos version greater than 1.2

Make sure your LocalPropertiesFile contains (at least) the following:

main.database=mifos
main.database.user=mifos
main.database.password=mifos

deploy

We recommend installing Tomcat 6 from a downloaded tarball, but here is a link about how to get the Ubuntu Tomcat package to work on Utuntu 9.04.

Download the latest Tomcat 6.x .tar.gz file (look under Downloads → Binary distributions → Core) and unpack it. In the instructions that follow, we'll assume you unpacked Tomcat to $HOME/tomcat6. If you've put it somewhere else, adjust accordingly.

Copy mifos.war from the installation package to $HOME/tomcat6/webapps.

start Mifos

Follow the startup instructions here

Done!