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:
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:~$ 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:
mysql> GRANT ALL on mifos.* to 'mifos'@'localhost' identified by 'mifos'; mysql> FLUSH PRIVILEGES;
- test database connection as user 'mifos'
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!