Table of Contents | ||
---|---|---|
|
Intro
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.
...
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:
No Format |
---|
[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
No Format |
---|
sudo /etc/init.d/service 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
.
...
No Format |
---|
mysql -D mifos -u mifos -pmifos < db/sql/latestbase-schema.sql mysql -D mifos -u mifos -pmifos < db/sql/latestbase-data.sql mysql -D mifos -u mifos -pmifos < db/sql/init_mifos_password.sql |
...
Upgrade you database
...
Mifos version 1.2 and earlier
Configure the Web application's database connection by creating a file called deploymifosDB.properties
containing the following:
No Format |
---|
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
See details here.
application database connection
Make sure your LocalPropertiesFile contains (at least) the following:
No Format |
---|
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) Mifos requires Jetty 7.x. Download Jetty tarball from http://archive.eclipse.org/jetty/7.3.1.v20110307/dist/ and unpack it. In the instructions that follow, we'll assume you unpacked Tomcat Jetty to $HOME/
tomcat6jetty7
. If you've put it somewhere else, adjust accordingly.
If using extended characters, be sure server configuration includes URIEncoding="UTF-8"
in the Connector definition.
Copy mifos.war
from the installation package to $HOME/tomcat6jetty7/webapps
.
start Mifos
Follow the startup instructions here
Done!