The following content was extracted from the Support Manual compiled by SunGard Technology Services in December 2010:
C:\apache-tomcat-6.0.18\bin\startup.bat
|
Start the startup.bat file and your tomcat will be started.
Here C:\ - root directory, where your tomcat folder is there.
Below is the screenshot to create shortcut.
Note: On Linux/ Ubuntu machines, you can use the following file for starting the tomcat
C:\apache-tomcat-6.0.18\bin\startup.sh |
Creation of tomcat startup shortcut
After clicking the startup.bat, the following screen will appear.
When the above server start up message comes, the tomcat is started.
Following steps needs to be replicated –
“C:\apache-tomcat-6.0.18\webapps\ “
|
Delete the work folder also.
“C:\apache-tomcat-6.0.18\work” |
Mysql> drop database <database_name>;
|
Mysql> create database <database_name>; Mysql> use <database_name> Mysql>source <complete path of the file which you want to execute to create mifos schema together with file name> |
Usually the file that creates the schema of MIFOS are (you will find these in source folder)
create_mifos_db.sql |
init_mifos_password.sql |
latest-data.sql |
latest-schema.sql
|
“C:\apache-tomcat-6.0.18\webapps\ “ |
Note:
Database steps are executed only when there is no customized data in Mifos initially. If yes, do not perform the steps. Just execute the rest ones.
Always remember that in your root directory, enough disk space should be there to deploy the Mifos WAR file completely. If space is less than what expected, the tomcat will start throwing error on application unexpectedly. So, always have around 10 GB of space should be there in your root directory.
To re-deploy the MIFOS with latest WAR or due to some issues with current WAR, the following steps need to be followed
“C:\apache-tomcat-6.0.18\webapps\ “
Delete the work folder also
“C:\apache-tomcat-6.0.18\work”
“C:\apache-tomcat-6.0.18\webapps\ “
The Mifos teams adds more functionalities to the application with each new release and version of Mifos. In order to replace the existing application with the newer version (latest one), follow the below steps:
Database level changes are also included in the latest WAR file and your current Mifos database automatically gets updated, if there are any changes at schema level.
To upgrade the MIFOS application:
“C:\apache-tomcat-6.0.18\webapps\ “
Delete the work folder also
“C:\apache-tomcat-6.0.18\work”
“C:\apache-tomcat-6.0.18\webapps\ “
If everything runs fine then you will be able to access the URL
http://<ip address of your server>:8080/mifos
If SQL upgrades coming up with latest WAR do not run fine and you face the following error while accessing the link
In this condition, go to following location
C:\apache-tomcat-6.0.18\webapps\mifos\WEB-INF\classes\sql
Check the database version coming on screen. In the above screenshot it is ‘230’ and application version is 259. The key is both the versions should match with each other in order to make your application run.
In order to make both 259, we need to upgrade database version 230 to 259.
At mentioned location
C:\apache-tomcat-6.0.18\webapps\mifos\WEB-INF\classes\sql
Taking consideration the above screenshot, we will take a look into the upgrade_to_231.sql script that actually fails while doing upgradation.
Execute the script on your MYSQL command line individually using
Mysql > source <filename> command
Do the above steps for next two more upgrades. So after running these, check the version of your database in the following table of MIFOS schema using the query below
select * from database_version;
Do not run the entire scripts if they are many upgrades to be done. Just execute the one where the upgrade failed and for rest do the following steps.
“C:\apache-tomcat-6.0.18\webapps\ “
Delete the work folder also
“C:\apache-tomcat-6.0.18\work”
Now check the database version
select * from database_version;
It should be ‘259’. If not then again find where it failed. Once version is 259, the application will run smoothly.
If your application version comes less than the database one when accessing URL, then your WAR file is older than your database. In this case, you just need to replace the existing WAR file with the higher version of MIFOS.
These are three files whose defines parameter values are taken as such if we don’t customize it. In order to change these, following steps needs to be done.
C:\apache-tomcat-6.0.18\webapps\mifos\WEB-INF\classes\org\mifos\config\resources\
Files are
Steps to make customized files:
C:\MIFOS_CONF
C:\MIFOS_CONF\applicationConfiguration.custom.properties
C:\MIFOS_CONF\mainDatabase.properties
C:\MIFOS_CONF\mifosChartOfAccounts.custom.xml
The solution is to upgrade the version of your JDK to 1.6