Mifos-users Digest, Vol 259, Issue 2
11 views
Skip to first unread message
mifos-use...@lists.sourceforge.net
Oct 13, 2016, 6:47:02 AM10/13/16
to mifos...@lists.sourceforge.net
Send Mifos-users mailing list submissions to
mifos...@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-use...@lists.sourceforge.net
You can reach the person managing the list at
mifos-us...@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" <in...@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...@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:avin...@knabfinance.com]
Sent: 13 October 2016 08:26
To: Mifos Users
Cc: mifos...@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 <avin...@knabfinance.com>
Subject: Re: [Mifos-users] Not able to login with mifos/password
To: Mifos Users <mifos...@googlegroups.com>
Cc: mifos...@lists.sourceforge.net
Message-ID: <1abc02a4-cc05-4124...@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
>
>
--
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: 3
Date: Thu, 13 Oct 2016 01:33:17 -0700 (PDT)
From: Avinash Dalvi <avin...@knabfinance.com>
Subject: Re: [Mifos-users] Not able to login with mifos/password
To: Mifos Users <mifos...@googlegroups.com>
Cc: mifos...@lists.sourceforge.net
Message-ID: <1abc02a4-cc05-4124...@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
>
>
--
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: 4
Date: Thu, 13 Oct 2016 13:46:02 +0300
From: "Zayyad A. Said" <zay...@intrasofttechnologies.com>
Subject: Re: [Mifos-users] Not able to login with mifos/password
To: "'trupti mali'" <trupt...@gmail.com>
Cc: mifos-d...@lists.sourceforge.net, "A good place to start for
users or folks new to Mifos." <mifos...@lists.sourceforge.net>
Message-ID:
<006f01d2253e$ff5423b0$fdfc6b10$@intrasofttechnologies.com>
Content-Type: text/plain; charset="us-ascii"
Trupti,
Try restarting MySQL service or reboot the whole server.
Regards;
*******
Zayyad A. Said | Chairman & C.E.O
Cell No.: +254 716 615274 | Skype: zsaid2011
Email: zay...@intrasofttechnologies.com
Email banner
From: trupti mali [mailto:trupt...@gmail.com]
Sent: 13 October 2016 13:38
To: zay...@intrasofttechnologies.com
Subject: Re: [Mifos-users] Not able to login with mifos/password
Thanks for this tip / share Zayyad.
I am using Java 8 , MySql 5.6 but tomcat is latest i.e. 8.5
I followed -
https://mifosforge.jira.com/wiki/display/docs/Failed+Upgrade+Tips+Mifos+X
tips given in this docs.
I found that many places (2-3 places) where my upgrade failed - those steps
were already run successfully. Hence I just changed the success flag in
schema_version table and restarted the tomcat. Now I could get the start the
tomcat with no errors but at the time of login I try to enter mifos/password
and I get prompted for the same again and again like this - what could be
wrong ?
On 13-Oct-2016, at 1:39 PM, Zayyad A. Said
<zay...@intrasofttechnologies.com> wrote:
<https://mifosforge.jira.com/wiki/display/docs/Failed+Upgrade+Tips+Mifos+X>
https://mifosforge.jira.com/wiki/display/docs/Failed+Upgrade+Tips+Mifos+X
-------------- next part --------------
An HTML attachment was scrubbed...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 27133 bytes
Desc: not available
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 119907 bytes
Desc: not available
------------------------------
------------------------------------------------------------------------------
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...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
End of Mifos-users Digest, Vol 259, Issue 2
*******************************************
mifos...@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-use...@lists.sourceforge.net
You can reach the person managing the list at
mifos-us...@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" <in...@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...@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:avin...@knabfinance.com]
Sent: 13 October 2016 08:26
To: Mifos Users
Cc: mifos...@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 <avin...@knabfinance.com>
Subject: Re: [Mifos-users] Not able to login with mifos/password
To: Mifos Users <mifos...@googlegroups.com>
Cc: mifos...@lists.sourceforge.net
Message-ID: <1abc02a4-cc05-4124...@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
>
>
--
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: 3
Date: Thu, 13 Oct 2016 01:33:17 -0700 (PDT)
From: Avinash Dalvi <avin...@knabfinance.com>
Subject: Re: [Mifos-users] Not able to login with mifos/password
To: Mifos Users <mifos...@googlegroups.com>
Cc: mifos...@lists.sourceforge.net
Message-ID: <1abc02a4-cc05-4124...@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
>
>
--
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: 4
Date: Thu, 13 Oct 2016 13:46:02 +0300
From: "Zayyad A. Said" <zay...@intrasofttechnologies.com>
Subject: Re: [Mifos-users] Not able to login with mifos/password
To: "'trupti mali'" <trupt...@gmail.com>
Cc: mifos-d...@lists.sourceforge.net, "A good place to start for
users or folks new to Mifos." <mifos...@lists.sourceforge.net>
Message-ID:
<006f01d2253e$ff5423b0$fdfc6b10$@intrasofttechnologies.com>
Content-Type: text/plain; charset="us-ascii"
Trupti,
Try restarting MySQL service or reboot the whole server.
Regards;
*******
Zayyad A. Said | Chairman & C.E.O
Cell No.: +254 716 615274 | Skype: zsaid2011
Email: zay...@intrasofttechnologies.com
Email banner
From: trupti mali [mailto:trupt...@gmail.com]
Sent: 13 October 2016 13:38
To: zay...@intrasofttechnologies.com
Subject: Re: [Mifos-users] Not able to login with mifos/password
Thanks for this tip / share Zayyad.
I am using Java 8 , MySql 5.6 but tomcat is latest i.e. 8.5
I followed -
https://mifosforge.jira.com/wiki/display/docs/Failed+Upgrade+Tips+Mifos+X
tips given in this docs.
I found that many places (2-3 places) where my upgrade failed - those steps
were already run successfully. Hence I just changed the success flag in
schema_version table and restarted the tomcat. Now I could get the start the
tomcat with no errors but at the time of login I try to enter mifos/password
and I get prompted for the same again and again like this - what could be
wrong ?
On 13-Oct-2016, at 1:39 PM, Zayyad A. Said
<zay...@intrasofttechnologies.com> wrote:
<https://mifosforge.jira.com/wiki/display/docs/Failed+Upgrade+Tips+Mifos+X>
https://mifosforge.jira.com/wiki/display/docs/Failed+Upgrade+Tips+Mifos+X
-------------- next part --------------
An HTML attachment was scrubbed...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 27133 bytes
Desc: not available
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 119907 bytes
Desc: not available
------------------------------
------------------------------------------------------------------------------
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...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
End of Mifos-users Digest, Vol 259, Issue 2
*******************************************
Mexina M Daniel
Oct 17, 2016, 5:08:16 AM10/17/16
to mifos...@lists.sourceforge.net
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
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
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
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
Reply all
Reply to author
Forward
0 new messages