Hello Patrick it looks like you haven't granted the user Mifos the required access rights to your Mifos database
make sure you grant the required privileges to your user you can use this (Mifos Default is user Mifos and password Mifos GRANT ALL on mifos.* to 'mifos'@'localhost' identified by 'mifos'; On Saturday, April 14, 2012 4:03:41 AM UTC+3, Patrick Asare-Frimpong wrote: > > Hi, > Please i have installed Mifos with Jetty 7 but anytime i try to run it i > get this error > > 2012-04-13/17:29:05.019/WET INFO, > org.mifos.framework.util.ConfigurationLocator, ?, ?, ?, Checking existance > of : local.properties > 2012-04-13/17:29:05.026/WET INFO, > org.mifos.framework.util.ConfigurationLocator, ?, ?, ?, > ConfigurationLocator found configuration in resource: class path resource > [org/mifos/config/resources/local.properties] > 2012-04-13/17:29:05.030/WET INFO, > org.mifos.framework.util.ConfigurationLocator, ?, ?, ?, Checking existance > of : applicationConfiguration.custom.properties > 2012-04-13/17:29:05.035/WET INFO, > org.mifos.framework.util.ConfigurationLocator, ?, ?, ?, > ConfigurationLocator found configuration in resource: class path resource > [org/mifos/config/resources/applicationConfiguration.custom.properties] > 2012-04-13/17:29:23.187/WET INFO, > org.mifos.framework.util.ConfigurationLocator, ?, ?, ?, > ConfigurationLocator found configuration in resource: class path resource > [org/mifos/config/resources/applicationConfiguration.custom.properties] > 2012-04-13/17:29:25.023/WET ERROR, > org.springframework.web.context.ContextLoader, ?, ?, ?, Context > initialization failed > org.springframework.beans.factory.UnsatisfiedDependencyException: Error > creating bean with name 'appliedUpgradesServiceFacade' defined in class > path resource [org/mifos/config/resources/services.xml]: Unsatisfied > dependency expressed through constructor argument with index 0 of type > [org.mifos.db.upgrade.DatabaseUpgradeSupport]: : Error creating bean with > name 'databaseUpgradeSupport' defined in URL > [jar:file:/C:/Users/Patrix/AppData/Local/Temp/jetty-0.0.0.0-8080-mifos.war-_mifos-any-/webapp/WEB-INF/lib/mifos-db-1.10-SNAPSHOT.jar!/META-INF/spring/DbUpgradeContext.xml]: > > Instantiation of bean failed; nested exception is > org.springframework.beans.BeanInstantiationException: Could not instantiate > bean class [org.mifos.db.upgrade.DatabaseUpgradeSupport]: Constructor threw > exception; nested exception is java.sql.SQLException: Access denied for > user 'mifos'@'localhost' (using password: YES); nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'databaseUpgradeSupport' defined in URL > [jar:file:/C:/Users/Patrix/AppData/Local/Temp/jetty-0.0.0.0-8080-mifos.war-_mifos-any-/webapp/WEB-INF/lib/mifos-db-1.10-SNAPSHOT.jar!/META-INF/spring/DbUpgradeContext.xml]: > > Instantiation of bean failed; nested exception is > org.springframework.beans.BeanInstantiationException: Could not instantiate > bean class [org.mifos.db.upgrade.DatabaseUpgradeSupport]: Constructor threw > exception; nested exception is java.sql.SQLException: Access denied for > user 'mifos'@'localhost' (using password: YES) > at > org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:730) > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:196) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464) > at > org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384) > at > org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) > at > org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) > at > org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:644) > at > org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:229) > at > org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1158) > at > org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:587) > at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:436) > at > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:55) > at > org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:36) > at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:180) > at > org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:479) > at > org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:136) > at > org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:137) > at > org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:50) > at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:494) > at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:406) > at org.eclipse.jetty.util.Scanner.scan(Scanner.java:355) > at org.eclipse.jetty.util.Scanner.start(Scanner.java:290) > at > org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:114) > at > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:55) > at > org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:540) > at > org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:219) > at > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:55) > at > org.eclipse.jetty.util.component.AggregateLifeCycle.doStart(AggregateLifeCycle.java:42) > at > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:52) > at > org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:96) > at org.eclipse.jetty.server.Server.doStart(Server.java:258) > at > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:55) > at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1233) > at java.security.AccessController.doPrivileged(Native Method) > at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1156) > Caused by: org.springframework.beans.factory.BeanCreationException: Error > creating bean with name 'databaseUpgradeSupport' defined in URL > [jar:file:/C:/Users/Patrix/AppData/Local/Temp/jetty-0.0.0.0-8080-mifos.war-_mifos-any-/webapp/WEB-INF/lib/mifos-db-1.10-SNAPSHOT.jar!/META-INF/spring/DbUpgradeContext.xml]: > > Instantiation of bean failed; nested exception is > org.springframework.beans.BeanInstantiationException: Could not instantiate > bean class [org.mifos.db.upgrade.DatabaseUpgradeSupport]: Constructor threw > exception; nested exception is java.sql.SQLException: Access denied for > user 'mifos'@'localhost' (using password: YES) > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:848) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:790) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:707) > at > org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:795) > at > org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:723) > ... 44 more > Caused by: org.springframework.beans.BeanInstantiationException: Could not > instantiate bean class [org.mifos.db.upgrade.DatabaseUpgradeSupport]: > Constructor threw exception; nested exception is java.sql.SQLException: > Access denied for user 'mifos'@'localhost' (using password: YES) > at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:162) > at > org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:110) > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280) > ... 57 more > Caused by: java.sql.SQLException: Access denied for user > 'mifos'@'localhost' (using password: YES) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943) > at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308) > at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336) > at > com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369) > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) > at sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown > Source) > at java.lang.reflect.Constructor.newInstance(Unknown Source) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) > at java.sql.DriverManager.getConnection(Unknown Source) > at java.sql.DriverManager.getConnection(Unknown Source) > at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:173) > at > org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:164) > at > org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149) > at > org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119) > at > org.mifos.db.upgrade.DatabaseUpgradeSupport.initDatabase(DatabaseUpgradeSupport.java:61) > at > org.mifos.db.upgrade.DatabaseUpgradeSupport.<init>(DatabaseUpgradeSupport.java:50) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown > Source) > at java.lang.reflect.Constructor.newInstance(Unknown Source) > at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) > ... 59 more > > * > ----------------------------------------------------------------------------------------------------------------------------------- > Patrick Asare-Frimpong > Ghana - West Africa > > Tel : +233208800414* >
------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
