gmane.comp.finance.mifos.devel

Question on sql script execution time indifferent environments

Malini K — 2008-08-30T11:30:02

## MySQL Server Instance Configuration File # ---------------------------------------------------------------------- # Generated by the MySQL Server Instance Configuration Wizard # # # Installation Instructions # ---------------------------------------------------------------------- # # On Linux you can copy this file to /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options # (< at >localstatedir< at > for this installation) or to # ~/.my.cnf to set user-specific options. # # On Windows you should keep this file in the installation directory # of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To # make sure the server reads the config file use the startup option # "--defaults-file". # # To run run the server from the command line, execute this in a # command line shell, e.g. # mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini" # # To install the server as a Windows service manually, execute this in a # command line shell, e.g. # mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini" # # And then execute this in a command line shell to start the server, e.g. # net start MySQLXY # # # Guildlines for editing this file # ---------------------------------------------------------------------- # # In this file, you can use all long options that the program supports. # If you want to know the options a program supports, start the program # with the "--help" option. # # More detailed information about the individual options can also be # found in the manual. # # # CLIENT SECTION # ---------------------------------------------------------------------- # # The following options will be read by MySQL client applications. # Note that only client applications shipped by MySQL are guaranteed # to read this section. If you want your own MySQL client program to # honor these values, you need to specify it as an option during the # MySQL client library initialization. # [client] port=3306 [mysql] default-character-set=latin1 # SERVER SECTION # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # [mysqld] # Enable the full query log. Every query (even ones with incorrect # syntax) that the server receives will be logged. This is useful for # debugging, it is usually disabled in production use. #log #Don't log extra information to update and slow-query logs. #log-short-format #Log queries that are executed without benefit of any index. #log-queries-not-using-indexes #Log some not critical warnings to the log file. #log-warnings # The TCP/IP Port the MySQL Server will listen on port=3306 #Path to installation directory. All paths are usually resolved relative to this. basedir="C:/Program Files/MySQL/MySQL Server 5.0.51/" #Path to the database root datadir="C:/Program Files/MySQL/MySQL Server 5.0.51/Data/" # The default character set that will be used when a new schema or table is # created and no character set is defined default-character-set=latin1 # The default storage engine that will be used when create new tables when default-storage-engine=INNODB # Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" # The maximum amount of concurrent sessions the MySQL server will # allow. One of these connections will be reserved for a user with # SUPER privileges to allow the administrator to login even if the # connection limit has been reached. max_connections=100 # Query cache is used to cache SELECT results and later return them # without actual executing the same query once again. Having the query # cache enabled may result in significant speed improvements, if your # have a lot of identical queries and rarely changing tables. See the # "Qcache_lowmem_prunes" status variable to check if the current value # is high enough for your load. # Note: In case your tables change very often or if your queries are # textually different every time, the query cache may result in a # slowdown instead of a performance improvement. query_cache_size=0 # The number of open tables for all threads. Increasing this value # increases the number of file descriptors that mysqld requires. # Therefore you have to make sure to set the amount of open files # allowed to at least 4096 in the variable "open-files-limit" in # section [mysqld_safe] table_cache=256 # Maximum size for internal (in-memory) temporary tables. If a table # grows larger than this value, it is automatically converted to disk # based table This limitation is for a single table. There can be many # of them. tmp_table_size=18M # How many threads we should keep in a cache for reuse. When a client # disconnects, the client's threads are put in the cache if there aren't # more than thread_cache_size threads from before. This greatly reduces # the amount of thread creations needed if you have a lot of new # connections. (Normally this doesn't give a notable performance # improvement if you have a good thread implementation.) thread_cache_size=8 #*** MyISAM Specific options # The maximum size of the temporary file MySQL is allowed to use while # recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE. # If the file-size would be bigger than this, the index will be created # through the key cache (which is slower). myisam_max_sort_file_size=100G # If the temporary file used for fast index creation would be bigger # than using the key cache by the amount specified here, then prefer the # key cache method. This is mainly used to force long character keys in # large tables to use the slower key cache method to create the index. myisam_max_extra_sort_file_size=100G # If the temporary file used for fast index creation would be bigger # than using the key cache by the amount specified here, then prefer the # key cache method. This is mainly used to force long character keys in # large tables to use the slower key cache method to create the index. myisam_sort_buffer_size=35M # Size of the Key Buffer, used to cache index blocks for MyISAM tables. # Do not set it larger than 30% of your available memory, as some memory # is also required by the OS to cache rows. Even if you're not using # MyISAM tables, you should still set it to 8-64M as it will also be # used for internal temporary disk tables. key_buffer_size=25M # Size of the buffer used for doing full table scans of MyISAM tables. # Allocated per thread, if a full scan is needed. read_buffer_size=64K read_rnd_buffer_size=256K # This buffer is allocated when MySQL needs to rebuild the index in # REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE # into an empty table. It is allocated per thread so be careful with # large settings. sort_buffer_size=256K #*** INNODB Specific options *** # Use this option if you have a MySQL server with InnoDB support enabled # but you do not plan to use it. This will save memory and disk space # and speed up some things. #skip-innodb # Additional memory pool that is used by InnoDB to store metadata # information. If InnoDB requires more memory for this purpose it will # start to allocate it from the OS. As this is fast enough on most # recent operating systems, you normally do not need to change this # value. SHOW INNODB STATUS will display the current amount used. #innodb_additional_mem_pool_size=2M innodb_additional_mem_pool_size=10M # If set to 1, InnoDB will flush (fsync) the transaction logs to the # disk at each commit, which offers full ACID behavior. If you are # willing to compromise this safety, and you are running small # transactions, you may set this to 0 or 2 to reduce disk I/O to the # logs. Value 0 means that the log is only written to the log file and # the log file flushed to disk approximately once per second. Value 2 # means the log is written to the log file at each commit, but the log # file is only flushed to disk approximately once per second. innodb_flush_log_at_trx_commit=1 # The size of the buffer InnoDB uses for buffering log data. As soon as # it is full, InnoDB will have to flush it to disk. As it is flushed # once per second anyway, it does not make sense to have it very large # (even with long transactions). innodb_log_buffer_size=1M # InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and # row data. The bigger you set this the less disk I/O is needed to # access data in tables. On a dedicated database server you may set this # parameter up to 80% of the machine physical memory size. Do not set it # too large, though, because competition of the physical memory may # cause paging in the operating system. Note that on 32bit systems you # might be limited to 2-3.5G of user level memory per process, so do not # set it too high. #innodb_buffer_pool_size=47M innodb_buffer_pool_size=1024M # Size of each log file in a log group. You should set the combined size # of log files to about 25%-100% of your buffer pool size to avoid # unneeded buffer pool flush activity on log file overwrite. However, # note that a larger logfile size will increase the time needed for the # recovery process. #innodb_log_file_size=24M innodb_log_file_size=300M # Number of threads allowed inside the InnoDB kernel. The optimal value # depends highly on the application, hardware as well as the OS # scheduler properties. A too high value may lead to thread thrashing. innodb_thread_concurrency=8 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

firing off a scheduled task on demand in Rhino /Mifos v1.1

Adam Monsen — 2008-08-29T17:22:04

Here's a quick hack to fire off a scheduled task on demand for Mifos version 1.1 and Rhino. You can do this while Mifos is running. This hack should only be used in development since it does all sorts of things we can't support (non-Struts JSP, scriptlets) and could probably cause data corruption. Create a .jsp page, $CATALINA_HOME/webapps/mifos/run.jsp containing -----------------------------8<----------------------------- <%< at >page import="org.mifos.framework.components.batchjobs.helpers.*"%> <% class SimpleJob extends Thread { public void run() { new ProductStatus().run(); } } new SimpleJob().start(); %> Started batch job. ----------------------------->8----------------------------- "ProductStatus" should be the name of whatever batch job you want to run. Now, simply fetch http://localhost:8080/mifos/run.jsp (or equivalent for your server). Depending on logging done by the task, you may be able to follow task progress by watching the Tomcat console. The contents of the scheduled_tasks table is also helpful: SELECT * FROM scheduled_tasks WHERE STARTTIME >= DATE(NOW());

JDBC data set not working in BIRT reports

Pramod Biligiri — 2008-08-28T09:51:26

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

2 Questions about Admin Docs and BIRT

Ryan Whitney — 2008-08-27T08:26:15

Yesterday's community meeting link

Van Mittal-Henkle — 2008-08-22T18:16:01

Hi all, It was great to talk to everyone at our community meeting yesterday (the 21st). There were lots of good questions, comments, ideas and suggestions. Thanks for the input! We'll look forward to talking to everyone again as work progresses on the Rhino and Cheetah releases. In the mean time here is the URL to the meeting info including a link to the presentation (a short version of the same URL follows): http://www.mifos.org/developers/listserv/meetings http://tiny.cc/5OTLc --Van ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Data Migration - MySQL Optimization

Ryan Whitney — 2008-08-22T12:59:45

Community of Mifos

j dailey — 2008-08-22T06:50:40

Hi all - So, it is good to see the effort by GF to engage the community of developers with the new strategy - the meeting earlier tonight was good for that I think. More is needed, and not just for the developers who know what Spring MVC is, but also for the constituency that is the eventual market. As an innovative open source model, much still needs to be done to improve the community transparency - who is getting mifos working, what are their challenges, how are they overcoming them, what is the future role of the GF/Mifos team? When we dreamed up the Mifos concept with our friends at MFIs around the world, there seemed to be an appetite to shoulder some of the effort themselves. That dream, where the end users are also the developers - at least in the broad sense, should still be kept going. Those who have a vested interest make the best participants long term and meeting their needs (developers within MFIs, external vendors, etc) is paramount. They need to see a software solution constantly improve, and are best positioned to inform the effort at GF or its successors. Since I missed some of the early slides in the meeting this evening, and have no idea if these questions were answered, I would like to ask: * what makes the Mifos Chetah approach fundamentally different from the technology-strategy approach of before? Beyond Spring and reworking the architecture, what does it say about the Mifos value proposition? * have you decided to reach 80% of the market with Software as a Service and what does that say about your target customers? Small MFIs? Larger MFIs? * what assumptions are you going to make about connectivity? and, how about those lightweight front ends (Air, GoogleGears, etc) ? * do you have accounting and transactional models at the core? or is the philosophy to leverage an existing open source or other accounting system? * will you enable (allow and encourage) a set of external and PRIVATE plugins to the framework to extend functionality in a modular way? * will you make data migration a part of your value proposition or at least make it easy to do? Configurability, Approachability, Deployability, Extensibility - and since we love acronyms CADE - this was the message that came out of our analysis of the original effort in 2006, we needed much much more of CADE. But, I would add something more - until Mifos has a solid core that the vendors around the world can make a profit on, we won't get to a critical mass of participants/customers. Seeding that eco-system has been a long and arduous task, but more frustrating perhaps for some supporters out there, is knowing when certain elements of CADE will be available. I see the meeting tonight as a great step in that process and I hope those supporters out there on the fence take note. Before I sign off, Congrats on Version 1.1./Rhino - I can hear the thunder of hooves. - James Dailey ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

trunk build broken: revision 13589

Adam Monsen — 2008-08-22T05:47:54

French char. set conversion functions missing inV1.1?

Jeff Blue — 2008-08-22T02:09:53

Comparison of MIFOS and Loan Performer

2008-08-22T00:45:50

Can anybody send me Complete InstallationProcedure? (Installation for Windows)

wazy — 2008-08-20T18:57:34

Dear Sir, I download all the stuff, mentioned in mifos.org site 1- ToMCat 2- MySQL 3- Java 4- Mifos 5- Mifos Installer Issues: Even i install all the applications and set Envoirnmental Variables, and run the setup of Mifos Installer, but Still facing the issue that application never run, even tomcat is running, MySQL Services also start etc, Require: I actually don't know about the issues like how can i change "hibernate.properties" and don't know where hibernate.properties is actually exist in the directory of my system and all other matters of configuration, and when i try to solve the problem by taking guidance from the link on mifos.org, Windows Installation Guide. They don't have the proper information. I know its a very gud software, but im implementing it on a single machine, but still feeling confusion. Can anybody send me Step by step instruction and procedure to ammend the files configuration, and exact path of each file. And can i download full pack of the product, in which all applications will exist. Please Help me. Im using Windows XP. and I have Pantium 4 Computer with 256 RAM Hope you can understand me, and i will wait for favourable reply. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Data Migrations and Loan Product Start Dates

Ryan Whitney — 2008-08-20T11:35:06

Problem Installing on Linux from Official 1.1Release

Graeme Ruthven — 2008-08-20T11:12:39

I've been running off an old trunk version, so thought I'd download the official general release version 1.1 and install that so as to be up to date. The environment is Debian etch, with separate database and application/web servers. I created a new empty database instance with appropriate permissions, running "create database mifos;" and creating the users on the database server. I downloaded the installation package to my home directory on the application/web server with "wget http://downloads.sourceforge.net/mifos/mifos_v1.1.0.zip" and unpacked it with "unzip". On the application/web server I ran the commands to create the database as per the INSTALL file: mysql -u mifos -h db.etc.gen.nz -p mifos

With LSIM enabled, does it it matter if the Client does not have a customer schedule

Nandini Yadalam — 2008-08-20T09:40:42

Community Meeting, Thursday Night Seattle Time

Emily Tucker — 2008-08-20T05:28:10

Hello Mifos Community, Just a reminder that we will be holding a Mifos community meeting on Thursday at 21:00 Seattle time/Friday 0400 UTC. We will be using DimDim to share the meeting materials. To log into the meeting, click on this link: http://webmeeting.dimdim.com:80/portal/JoinForm.action?confKey=emilytuck er [Note this link will not work prior to the meeting] (*) If you are dialing in, please use this number: Conference Number: 1-712-432-6139 Participant Code: 364598 (*) If you are using skype: I will be hosting a conference call for people who want to join the teleconference using skype. Please email your skype ID directly to me: etucker-DnEsXXvMQJxj/JC5u5XAOISLwOllVvif< at >public.gmane.org and I will call you into the meeting. The agenda for the meeting: 1. Product Roadmap: Rhino & Cheetah releases 2. Why Cheetah: Overview of current codebase 3. Discussion of new architecture and technology stack 4. Discussion and Q&A Look forward to talking with you on Thursday! Emily. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Ubuntu memory requirements

Jeff Blue — 2008-08-19T14:27:40

We're about ready to order a java hosting plan to start live data testing Mifos for SEM, an MFI in Senegal. We'll probably use Ubuntu since Ryan Whitney has blazed that trail (thanks for the install guide Ryan). One of the java hosting sites has suggested trying to run with 950MB memory limiting the JVM Xmx to 768M instead of the recommended 1024M. This would save us at least $20/month. Is this worth a try for our small MFI or is it doomed to failure? Thanks, Jeff Blue working with SEM (sem-fund.org) ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

[PATCH] Issue# 2102

Shah, Aditya S. — 2008-08-19T13:28:58

Index: C:/Documents and Settings/Adi/My Documents/My Code/eclipse-workspace/mifosLatest/test/org/mifos/application/accounts/loan/struts/action/TestLoanAccountAction.java =================================================================== --- C:/Documents and Settings/Adi/My Documents/My Code/eclipse-workspace/mifosLatest/test/org/mifos/application/accounts/loan/struts/action/TestLoanAccountAction.java(revision 13567) +++ C:/Documents and Settings/Adi/My Documents/My Code/eclipse-workspace/mifosLatest/test/org/mifos/application/accounts/loan/struts/action/TestLoanAccountAction.java(working copy) < at >< at > -132,7 +132,42 < at >< at > protected void tearDown() throws Exception { super.tearDown(); } + +public void testLoanAccountWithCreationFieldsCleared() throws Exception{ + +request.setAttribute(Constants.CURRENTFLOWKEY, flowKey); +goToPrdOfferingPage(); +actionPerform(); +goToLoanAccountInputPage(); +addRequestParameter("collateralNote", "A test note"); +actionPerform(); +goToSchedulePreviewPage(); +actionPerform(); +addRequestParameter(Constants.CURRENTFLOWKEY, (String) request +.getAttribute(Constants.CURRENTFLOWKEY)); +addRequestParameter("method", "create"); +addRequestParameter("stateSelected", "1"); +performNoErrors(); +verifyForward(ActionForwards.create_success.toString()); +LoanAccountActionForm actionForm = (LoanAccountActionForm)getActionForm(); +LoanBO loan = TestObjectFactory.getObject(LoanBO.class, new Integer( +actionForm.getAccountId()).intValue()); + +setRequestPathInfo("/loanAccountAction.do"); +addRequestParameter("method", "getPrdOfferings"); +addRequestParameter("customerId", group.getCustomerId().toString()); +actionPerform(); + +assertNull(actionForm.getPrdOfferingId()); + +goToLoanAccountInputPage(); +actionPerform(); +actionForm = (LoanAccountActionForm)getActionForm(); +assertNull(actionForm.getCollateralNote()); +TestObjectFactory.cleanUp(loan); +} + public void testCreateWithoutPermission() throws Exception { request.setAttribute(Constants.CURRENTFLOWKEY, flowKey); UserContext userContext = TestUtils.makeUser(); Index: C:/Documents and Settings/Adi/My Documents/My Code/eclipse-workspace/mifosLatest/src/org/mifos/application/accounts/loan/struts/action/LoanAccountAction.java =================================================================== --- C:/Documents and Settings/Adi/My Documents/My Code/eclipse-workspace/mifosLatest/src/org/mifos/application/accounts/loan/struts/action/LoanAccountAction.java(revision 13567) +++ C:/Documents and Settings/Adi/My Documents/My Code/eclipse-workspace/mifosLatest/src/org/mifos/application/accounts/loan/struts/action/LoanAccountAction.java(working copy) < at >< at > -467,6 +467,7 < at >< at > HttpServletResponse response) throws Exception { logger.debug("Inside getPrdOfferings method"); LoanAccountActionForm loanActionForm = (LoanAccountActionForm) form; +loanActionForm.setPrdOfferingId(null); CustomerBO customer = getCustomer(loanActionForm.getCustomerIdValue()); List loanOfferings = loanPrdBusinessService .getApplicablePrdOfferings(customer.getCustomerLevel()); < at >< at > -1663,6 +1664,7 < at >< at > .getDefaultNoOfInstall())); loanAccountActionForm.setBusinessActivityId(null); loanAccountActionForm.setCollateralTypeId(null); +loanAccountActionForm.setCollateralNote(null); } private List getFunds(LoanOfferingBO loanOffering) { List funds = new ArrayList(); ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Ubuntu install instructions

Ryan Whitney — 2008-08-19T10:04:05

Inserting customers using ClientBO constructor

Pramod Biligiri — 2008-08-18T13:30:04

Help on Mifos Design/Structure

Abdul-Quadri Dauda — 2008-08-16T17:26:00

George Conard at OSCON 2008

Graeme Ruthven — 2008-08-16T02:40:11

Does anyone know if his presentation has been posted to the Internet? If so, can we have a link, please? And post it on the web site, perhaps? Regards Graeme ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/