Mifos Ubuntu Server 12.04 Installation Guide

Installation guide: Linux Server for Mifos Platform using Ubuntu Server 12, JDK7, Tomcat web server and mysql server.

Step 1 - Installing System Updates and Prerequisites:

# sudo -s

# apt-get update

# apt-get upgrade

# apt-get install openjdk-7-jdk mysql-server tomcat7

OPTIONAL (nano text editor & date/time settigns)

# apt-get install  nano

Check date:

# date

and if needed update with

# dpkg-reconfigure tzdata

Step 2 - Enabling SSL

To enable tomcat SSL (https), generate and store a key:

All in one line:
 # keytool -genkey -keyalg RSA -alias tomcat -keystore /etc/tomcat7/keystore.jks
 -storepass keystore -validity 360 -keysize 2048

Update /etc/tomcat7/server.xml configuration file

Find:
                   connectionTimeout="20000"
               URIEncoding="UTF-8"
               redirectPort="8443" />

and after add:

           port="8443" SSLEnabled="true" maxThreads="200"
           scheme="https" secure="true"
           keystoreFile="/etc/tomcat7/keystore.jks"
           keystorePass="keystore" clientAuth="false"
           sslProtocol="TLS" />

Restart and test tomcat:

# /etc/init.d/tomcat7 restart

Tomcat should be listening on localhost and your external ip if you have one.

Visit https://[server ip address]:8080   to confirm tomcat is running
Visit https://[server ip address]:8443   to confirm tomcat ssl is working  
(you'll need to accept cerfificate manually)

If pages fail to load, something is probably wrong with tomcat. 
Tomcat on ubuntu logs to  /var/lib/tomcat7/logs/  and /var/log/ 

Check to see if tomcat7 is listening:

# netstat -ltpu

On the lsit you should be able to find sometihng like: 

Step 3 - Mifos Platform and Database Setup/Population

Download and extract mifos platform:

# cd /usr/src
# wget http://downloads.sourceforge.net/project/mifos/Mifos%20X/mifosplatform-1.23.1.RELEASE.zip?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fmifos%2Ffiles%2FMifos%2520X%2F&ts=1403225973&use_mirror=softlayer-dal
# mv mifosplatform-1.23.1.RELEASE.zip\?r\=http\:%2F%2Fsourceforge.net%2Fprojects%2Fmifos%2Ffiles%2FMifos%20X%2F  mifos.zip
# unzip mifos.zip
# cd mifosplatform-1.23.1.RELEASE

Create and populate databases (more at  https://github.com/openMF/mifosx/blob/master/INSTALL.md )

# mysql -u root -p

Enter mysql root password, and in mysql console type:

create database `mifosplatform-tenants`;
create database `mifostenant-default`;
exit

# mysql -u root -p mifosplatform-tenants < database/mifospltaform-tenants-first-time-install.sql
# mysql -u root -p mifostenant-default < database/migrations/sample_data/load_sample_data.sql

Add database Resource to tomcat config

# nano /etc/tomcat7/server.xml


 
   
                  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" />


            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"
       />
 

Step 4 - Activate Mifos

Copy mifos and community app to Tomcat's webapps folder:

# cd /usr/src/mifosplatform-1.23.1.RELEASE
# cp mifosng-provider.war /var/lib/tomcat7/webapps/
# cp -r api-docs/ /var/lib/tomcat7/webapps/ROOT/
# cp -r apps/community-app/ /var/lib/tomcat7/webapps/ROOT/
# cp -r api-docs/ /var/lib/tomcat7/webapps/ROOT/

Create a directory for mifos uploads & reports (pentahoReports):

mkdir -p /var/lib/tomcat7/.mifosx/default/documents/

cp -r /usr/src/mifosplatform-1.23.1.RELEASE/pentahoReports /usr/share/tomcat7/.mifosx/

chown tomcat7 /var/lib/tomcat7/webapps/.mifosx/

 

and  finally

# /etc/init.d/tomcat7 restart

Setup is complete and mifos should be running.

OPTIONAL:
*in sepperate terminal you may watch your Mifos come to life like this:

# tail -f /var/lib/tomcat7/logs/mifos-platform.log

 

(if all is good, after a while of loading, you should see sometihng like: Root WebApplicationContext: initialization completed in 45876 ms)

Appendix A - Change mysql username/password

Change Mifos default mysql password:

# apt-get install phpmyadmin

1.  Go to   http://[yourserverip]/phpmyadmin  and login

2.  Click on Privileges, then Add a new User

3. Pick a username/password and create it. Assign full privileges globally, or on  mifosplatform-tenants &  mifostenant-default databases.

4. On the left, select/open mifosplatform-tenants database,
you should see a table with a single column , click "edit" infront of it.

Locate:
schema_username
schema_password

And set user/pass created in step #3.

Finally, edit

/etc/tomcat7/server.xml
username="root"
password="mysql"

And set user/pass created in step #3 here as well.

You can now set new mysql root password, without braking mifos.

Restart tomcat. Finish.

# /etc/init.d/tomcat7 restart