Hi Avinash It seems as you have database connection problem since driverClassName of Drizzle is missing in your server.xml
Make sure the server.xml is exactly as how it is instructed at https://mifosforge.jira.com/wiki/display/docs/Mifos+X+Installation+on+Linux+-+Ubuntu+Server. And don't forget to download drizzle jdbc connector and put it under lib folder of tomcat7. Mexina On 10/13/2016 01:46 PM, mifos-users-requ...@lists.sourceforge.net wrote: > Send Mifos-users mailing list submissions to > mifos-users@lists.sourceforge.net > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/mifos-users > or, via email, send a message with subject or body 'help' to > mifos-users-requ...@lists.sourceforge.net > > You can reach the person managing the list at > mifos-users-ow...@lists.sourceforge.net > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Mifos-users digest..." > > > Today's Topics: > > 1. Re: Not able to login with mifos/password (Skyburg Systems) > 2. Re: Not able to login with mifos/password (Avinash Dalvi) > 3. Re: Not able to login with mifos/password (Avinash Dalvi) > 4. Re: Not able to login with mifos/password (Zayyad A. Said) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 13 Oct 2016 10:09:17 +0200 > From: "Skyburg Systems" <i...@skyburgsystems.org> > Subject: Re: [Mifos-users] Not able to login with mifos/password > To: "'A good place to start for users or folks new to Mifos.'" > <mifos-users@lists.sourceforge.net> > Message-ID: <001801d22529$19e09080$4da1b180$@skyburgsystems.org> > Content-Type: text/plain; charset="utf-8" > > Hi, > > > > Which version of Mifos are you running? > > > > > > From: Avinash Dalvi [mailto:avinas...@knabfinance.com] > Sent: 13 October 2016 08:26 > To: Mifos Users > Cc: mifos-users@lists.sourceforge.net > Subject: Re: [Mifos-users] Not able to login with mifos/password > > > > M also facing same issue. > > > > ############################ > > 6902 [localhost-startStop-1] ERROR o.a.tomcat.jdbc.pool.ConnectionPool - > Unable to create initial connections of pool. > > java.sql.SQLNonTransientConnectionException: Could not connect: Connection > refused > > at > org.drizzle.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:97) > ~[drizzle-jdbc-1.3.jar:na] > > at org.drizzle.jdbc.DrizzleDriver.connect(DrizzleDriver.java:98) > ~[drizzle-jdbc-1.3.jar:na] > > at > org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278) > ~[tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) > ~[tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:554) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:242) > [tomcat-jdbc-7.0.55.jar:na] > > at > org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141) > [catalina.jar:7.0.72] > > at > javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321) > [na:1.8.0_101] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:848) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:159) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:836) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:173) > [catalina.jar:7.0.72] > > at > org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:146) > [catalina.jar:7.0.72] > > at > javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321) > [na:1.8.0_101] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:848) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:159) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:836) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:159) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:836) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:159) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:836) > [catalina.jar:7.0.72] > > at org.apache.naming.NamingContext.lookup(NamingContext.java:173) > [catalina.jar:7.0.72] > > at > org.apache.naming.SelectorContext.lookup(SelectorContext.java:156) > [catalina.jar:7.0.72] > > ################################# > > > > here fineract-platform.log details > > > On Thursday, July 7, 2016 at 10:01:04 PM UTC+5:30, Suraj Mundada wrote: > > Hi, > > I am new to Mifos. I installed it as per the instructions given on > <https://mifosforge.jira.com/wiki/display/docs/Mifos+X+Installation+on+Windows> > https://mifosforge.jira.com/wiki/display/docs/Mifos+X+Installation+on+Windows > > Java - jdk1.8.0_u73x64 > > MySQL ? 5.6 > > Tomcat - apache-tomcat-8.0.36 > > When started, fineract-provider.war gets deployed correctly and I can see > login page. However, I get below error message when I login: > > Couldn't connect to server. Make sure you are using correct settings. > > Server.conf looks as below: > > <?xml version='1.0' encoding='utf-8'?> > > <Server port="8005" shutdown="SHUTDOWN"> > > <Listener className="org.apache.catalina.startup.VersionLoggerListener" /> > > <Listener className="org.apache.catalina.core.AprLifecycleListener" > SSLEngine="on" /> > > <Listener > className="org.apache.catalina.core.JreMemoryLeakPreventionListener" /> > > <Listener > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" /> > > <Listener > className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" /> > > <GlobalNamingResources> > > <Resource name="UserDatabase" auth="Container" > > 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" /> > > > > <Resource type="javax.sql.DataSource" > > 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"/> > > </GlobalNamingResources> > > <Service name="Catalina"> > > <Connector port="8080" protocol="HTTP/1.1" > > connectionTimeout="20000" > > redirectPort="8443" /> > > > > <Connector port="8443" > protocol="org.apache.coyote.http11.Http11NioProtocol" > > maxThreads="150" SSLEnabled="true" scheme="https" > secure="true" keystoreFile="C:/Users/Suraj/.keystore" > > keystorePass="xyz12" clientAuth="false" > sslProtocol="TLS" > > > compressableMimeType="text/html,text/xml,text/plain,text/javascript,text/css"/> > > > > <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" /> > > <Engine name="Catalina" defaultHost="localhost"> > > <Realm className="org.apache.catalina.realm.LockOutRealm"> > > <Realm className="org.apache.catalina.realm.UserDatabaseRealm" > > resourceName="UserDatabase"/> > > </Realm> > > <Host name="localhost" appBase="webapps" > > unpackWARs="true" autoDeploy="true"> > > <Valve className="org.apache.catalina.valves.AccessLogValve" > directory="logs" > > prefix="localhost_access_log" suffix=".txt" > > pattern="%h %l %u %t "%r" %s %b" /> > > </Host> > > </Engine> > > </Service> > > </Server> > > Logs not giving any idea what is wrong. > > I have placed mysql-connector-java-5.1.38-bin.jar in lib folder. > > Any help will be appreciated. > > Regards, > > Suraj Mundada > > CTO, <http://www.cashcare.in/> www.cashcare.in > > +91 77220 75369 > > > > This message contains information that may be privileged or confidential and > is the property of KNAB finance. It is intended only for the person to whom > it is addressed. If you are not the intended recipient, you are not > authorized to read, print, retain, copy, disseminate, distribute, or use this > message or any part thereof. If you receive this message in error, please > notify the sender immediately and delete all copies of this message. > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 2 > Date: Thu, 13 Oct 2016 01:33:17 -0700 (PDT) > From: Avinash Dalvi <avinas...@knabfinance.com> > Subject: Re: [Mifos-users] Not able to login with mifos/password > To: Mifos Users <mifosus...@googlegroups.com> > Cc: mifos-users@lists.sourceforge.net > Message-ID: <1abc02a4-cc05-4124-aa3a-76d6f89fb...@googlegroups.com> > Content-Type: text/plain; charset="utf-8" > > https://mifosforge.jira.com/wiki/display/docs/Mifos+X+Installation+on+Linux+-+Ubuntu+Server > > install as per this guideline but api server is not working, > > On Thursday, July 7, 2016 at 10:01:04 PM UTC+5:30, Suraj Mundada wrote: >> Hi, >> >> I am new to Mifos. I installed it as per the instructions given on >> *https://mifosforge.jira.com/wiki/display/docs/Mifos+X+Installation+on+Windows* >> <https://mifosforge.jira.com/wiki/display/docs/Mifos+X+Installation+on+Windows> >> >> Java - jdk1.8.0_u73x64 >> >> MySQL ? 5.6 >> >> Tomcat - apache-tomcat-8.0.36 >> >> When started, fineract-provider.war gets deployed correctly and I can see >> login page. However, I get below error message when I login: >> >> *Couldn't connect to server. Make sure you are using correct settings.* >> >> Server.conf looks as below: >> >> <?xml version='1.0' encoding='utf-8'?> >> >> <Server port="8005" shutdown="SHUTDOWN"> >> >> <Listener className="org.apache.catalina.startup.VersionLoggerListener" >> /> >> >> <Listener className="org.apache.catalina.core.AprLifecycleListener" >> SSLEngine="on" /> >> >> <Listener >> className="org.apache.catalina.core.JreMemoryLeakPreventionListener" /> >> >> <Listener >> className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" /> >> >> <Listener >> className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" /> >> >> <GlobalNamingResources> >> >> <Resource name="UserDatabase" auth="Container" >> >> 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" /> >> >> >> >> <Resource type="javax.sql.DataSource" >> >> 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"/> >> >> </GlobalNamingResources> >> >> <Service name="Catalina"> >> >> <Connector port="8080" protocol="HTTP/1.1" >> >> connectionTimeout="20000" >> >> redirectPort="8443" /> >> >> >> >> <Connector port="8443" >> protocol="org.apache.coyote.http11.Http11NioProtocol" >> >> maxThreads="150" SSLEnabled="true" scheme="https" >> secure="true" keystoreFile="C:/Users/Suraj/.keystore" >> >> keystorePass="xyz12" clientAuth="false" >> sslProtocol="TLS" >> >> >> compressableMimeType="text/html,text/xml,text/plain,text/javascript,text/css"/> >> >> >> >> <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" /> >> >> <Engine name="Catalina" defaultHost="localhost"> >> >> <Realm className="org.apache.catalina.realm.LockOutRealm"> >> >> <Realm className="org.apache.catalina.realm.UserDatabaseRealm" >> >> resourceName="UserDatabase"/> >> >> </Realm> >> >> <Host name="localhost" appBase="webapps" >> >> unpackWARs="true" autoDeploy="true"> >> >> <Valve className="org.apache.catalina.valves.AccessLogValve" >> directory="logs" >> >> prefix="localhost_access_log" suffix=".txt" >> >> pattern="%h %l %u %t "%r" %s %b" /> >> >> </Host> >> >> </Engine> >> >> </Service> >> >> </Server> >> >> Logs not giving any idea what is wrong. >> >> I have placed mysql-connector-java-5.1.38-bin.jar in lib folder. >> >> Any help will be appreciated. >> >> Regards, >> >> Suraj Mundada >> >> CTO, *www.cashcare.in* <http://www.cashcare.in/> >> >> +91 77220 75369 >> >> -- Mexina M Daniel Lead Software Developer Research & Development Tel:+255 222 618 511 | Mob: +255 712 110 791 Singo Africa Limited Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam singo.co.tz Lets grow together ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
