Re: [Mifos-users] issues installing Mifos

[Kay C. <kc...@gr...>]

Great work!!

> -----Original Message-----
> From: Adam Monsen [mailto:am...@gr...]
> Sent: Wednesday, March 24, 2010 2:31 PM
> To: Mifos User Discussions
> Subject: Re: [Mifos-users] issues installing Mifos
> 
> Hi Maheswari!
> 
> Great work so far, the servers are set up quite nicely. Jeff and I logged into the box
> together ( http://www.mifos.org/developers/wiki/MultiuserGNUScreen ) and
> made some changes.
> 
> On the Web/application box, you can type "history" to see what commands we ran
> while working on the box.
> 
>       * moved tomcat to /opt/apache-tomcat-6.0.20
>               * don't manually install anything into /var/lib
>               * /opt/tomcat6 is a symlink to /opt/apache-tomcat-6.0.20
>               * CATALINA_HOME now points to /opt/tomcat6
>       * use root account (sudo) as little as possible
>               * don't start Mifos with sudo
>               * I ran "chown -R ubuntu.ubuntu /opt/tomcat6/"
>               * use this to start Mifos: $CATALINA_HOME/bin/startup.sh
>               * use this to stop Mifos: $CATALINA_HOME/bin/shutdown.sh
>               * use this to tell if Mifos is running: ps auxw | grep
>                 [t]omcat
>       * how to watch application logs
>               * tail -f $CATALINA_HOME/logs/catalina.out
>       * improved MySQL security
>               * use a strong password for root user
>               * use an unprivileged user in MySQL
>               * grant all on mifos.* to
>                 'mifos'@'INTERNAL_EC2_IP_ADDRESS' identified by
>                 'PASSWORD_NOT_SHOWN';
>               * I updated $MIFOS_CONF/local.properties
>       * upgraded MySQL to 5.1
>               * apt-get install mysql-server-5.1
>               * if we want 5.0 back, I think you can just run: apt-get
>                 install mysql-server-5.0
>       * added /etc/mysql/conf.d/mifos.cnf
>               * lower_case_table_names=1 is required by Mifos (see
>                 http://mifosforge.jira.com/browse/MIFOS-1513 )
>               * innodb_file_per_table is a good idea
>               * before changing these settings, mifos database had to be
>                 destroyed
>               * after changing these settings, mifos database had to be
>                 reloaded
>       * re-created Mifos database using latest-data.sql and
>         latest-schema.sql
>         CATALINA_HOME/webapps/mifos/WEB-INF/classes/sql
>       * was getting a null pointer exception during password
>         verification on login, so I ran init_mifos_password.sql (I don't
>         know why this is sometimes necessary)
>       * moved MIFOS_CONF dir to /opt/mifos_conf
>               * and updated MIFOS_CONF in ~ubuntu/.bashrc
>       * created loggerconfiguration.xml in MIFOS_CONF
>               * only difference is "<param name="File"
>                 value="/tmp/Mifos.log"/>"
>               * application log will always be written to /tmp/Mifos.log