[Mifos-users] Not able to login with mifos/password

1,459 views
Skip to first unread message

Suraj Mundada

unread,
Jul 7, 2016, 12:31:04 PM7/7/16
to mifos...@lists.sourceforge.net

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

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 &quot;%r&quot; %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

+91 77220 75369

Nayan Ambali

unread,
Jul 8, 2016, 4:17:50 AM7/8/16
to A good place to start for users or folks new to Mifos.
Suraj,

Please test APIs running or not, paste https://[public DNS]:<port>/fineract-provider/api/v1/offices?tenantIdentifier=default&pretty=true URL in browser.

if it is local host and listening port 8443 then try https://localhost:8443/fineract-provider/api/v1/offices?tenantIdentifier=default&pretty=true

if this does not return the json with office data and gives any error message then server is not started properly, then please share the server logs for further investigation.


Thanks
Nayan Ambali





Thanks and Regards,

Nayan Ambali
skype: nayangambali

------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users


Suraj Mundada

unread,
Jul 8, 2016, 9:19:36 AM7/8/16
to A good place to start for users or folks new to Mifos.

Hi Nayan,

 

Thanks for responding. I could not get json office data and got Http 404 error instead. I checked server logs. But could not get a hint.

 

PFA the server logs.

 

Regards,

Suraj

catalina.2016-07-08.log

Sughosh Bharadwaj

unread,
Jul 8, 2016, 9:59:38 AM7/8/16
to A good place to start for users or folks new to Mifos.
Hello Suraj,

Can you try checking fineract-platform.log.
This shows if there are any error logs.

Regards,
Sughosh

Suraj Mundada

unread,
Jul 9, 2016, 1:39:02 AM7/9/16
to A good place to start for users or folks new to Mifos.

Can not see fineract-platform.log in any folder. May be fineract application is not deployed correctly.

Avinash Dalvi

unread,
Oct 13, 2016, 3:12:19 AM10/13/16
to Mifos Users, mifos...@lists.sourceforge.net
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

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.

trupti mali

unread,
Oct 13, 2016, 3:20:27 AM10/13/16
to A good place to start for users or folks new to Mifos., Mifos Users
I am also facing issue while setting up on mac - error that I get is different though -

Caused by: com.googlecode.flyway.core.api.FlywayException: Migration of schema `mifostenant-default` to version 118.7 failed! Please restore backups and roll back database and code!; for Tenant DB URL: jdbc:mysql://localhost:3306/mifostenant-default, username: root
at org.apache.fineract.infrastructure.core.service.TenantDatabaseUpgradeService.upgradeAllTenants(TenantDatabaseUpgradeService.java:78) ~[classes/:na]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_101]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_101]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_101]

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot_______________________________________________

Zayyad A. Said

unread,
Oct 13, 2016, 4:10:14 AM10/13/16
to A good place to start for users or folks new to Mifos., Mifos Users

Trupti,

 

Follow this article and you will get a solution to your problem: https://mifosforge.jira.com/wiki/display/docs/Failed+Upgrade+Tips+Mifos+X

 

Let us know if we can be of further help.

 

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 10:19
To: A good place to start for users or folks new to Mifos.
Cc: Mifos Users
Subject: Re: [Mifos-users] Not able to login with mifos/password

 

I am also facing issue while setting up on mac - error that I get is different though -

image001.jpg

Skyburg Systems

unread,
Oct 13, 2016, 4:31:23 AM10/13/16
to A good place to start for users or folks new to Mifos.

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. 

Avinash Dalvi

unread,
Oct 13, 2016, 4:33:39 AM10/13/16
to Mifos Users, mifos...@lists.sourceforge.net
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:

Zayyad A. Said

unread,
Oct 13, 2016, 6:46:29 AM10/13/16
to trupti mali, mifos-d...@lists.sourceforge.net, A good place to start for users or folks new to Mifos.

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 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 ?

 

image001.jpg
image002.png

Shreyaank Byadagi

unread,
Oct 13, 2016, 7:01:40 AM10/13/16
to Mifos software development, A good place to start for users or folks new to Mifos.
Hi Trupti,

Make sure you use tomcat 7.0.64  :)

Regards
Shreyaank


 Sent with Mailtrack

On Thu, Oct 13, 2016 at 4:16 PM, Zayyad A. Said <zay...@intrasofttechnologies.com> wrote:

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

 

From: trupti mali [mailto:trupt...@gmail.com]
Sent: 13 October 2016 13:38
To: zayyad@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 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 ?

 


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer



--
Thanks and Regards
Shreyaank

trupti mali

unread,
Oct 13, 2016, 7:27:53 AM10/13/16
to Shreyaank Byadagi, Mifos software development, A good place to start for users or folks new to Mifos.
Yeah I tried with tomcat 7.0.64 too - same issue I am facing. 

I am using credetials as mifos / password as suggested in the doc - can u please confirm thats right?

I see there is mifos and system user in m_app_user table but password is encrypted - how do I decrypt it?

~Trupti

On 13-Oct-2016, at 4:31 PM, Shreyaank Byadagi <shre...@confluxtechnologies.com> wrote:

Hi Trupti,

Make sure you use tomcat 7.0.64  :)

Regards
Shreyaank


 Sent with Mailtrack
On Thu, Oct 13, 2016 at 4:16 PM, Zayyad A. Said <zay...@intrasofttechnologies.com> wrote:

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: zayyad@intrasofttechnologies.com 

 

<image001.jpg>

 

From: trupti mali [mailto:trupt...@gmail.com]
Sent: 13 October 2016 13:38
To: zayyad@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 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 ?

 

<image002.png>


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

Shreyaank Byadagi

unread,
Oct 13, 2016, 7:28:50 AM10/13/16
to trupti mali, Mifos software development, A good place to start for users or folks new to Mifos.
Trupti,

Please come over skype, I will fix the issue.
Skype Id: Mifos.support

Regards
shreyaank


 Sent with Mailtrack

On Thu, Oct 13, 2016 at 4:55 PM, trupti mali <trupt...@gmail.com> wrote:
Yeah I tried with tomcat 7.0.64 too - same issue I am facing. 

I am using credetials as mifos / password as suggested in the doc - can u please confirm thats right?

I see there is mifos and system user in m_app_user table but password is encrypted - how do I decrypt it?

~Trupti
On 13-Oct-2016, at 4:31 PM, Shreyaank Byadagi <shreyaank@confluxtechnologies.com> wrote:

Hi Trupti,

Make sure you use tomcat 7.0.64  :)

Regards
Shreyaank


 Sent with Mailtrack
On Thu, Oct 13, 2016 at 4:16 PM, Zayyad A. Said <zayyad@intrasofttechnologies.com> wrote:

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: zayyad@intrasofttechnologies.com 

 

<image001.jpg>

 

From: trupti mali [mailto:trupt...@gmail.com]
Sent: 13 October 2016 13:38
To: zayyad@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 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 ?

 

<image002.png>


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Mifos-developer mailing list



--
Thanks and Regards
Shreyaank


trupti mali

unread,
Oct 13, 2016, 8:03:23 AM10/13/16
to Shreyaank Byadagi, Mifos software development, A good place to start for users or folks new to Mifos.
Thanks Shreyaank for getting onto the call for helping me out -

Following were there discussion points - 

1) I am following https://mifosforge.jira.com/wiki/display/docs/Mifos+X+Installation+on+Linux+-+Ubuntu+Server guide to do installation on mac. The installation guide for mac seems to be quite old.

2) I am more interested in setting up developer setup than end user one so Shreyaank guided me to use the https://github.com/openMF/mifosx/wiki guidelines to do the same.

3) Is there anyone who has tried the latest setup on mac OS Sierra? I have reached to a point where I see there are no errors but I am not able to login to the application - it keeps on prompting me for user id and password again and again where as I am providing the one as mifos / password as suggested in the documentation. What I could verify from database is - I see mifos user is present in m_app_user table but I am not able to decipher its password since its encrypted.




On 13-Oct-2016, at 4:58 PM, Shreyaank Byadagi <shre...@confluxtechnologies.com> wrote:

Mifos.support

Avinash Dalvi

unread,
Oct 14, 2016, 6:56:37 AM10/14/16
to mifos...@googlegroups.com, Shreyaank Byadagi, Mifos software development, A good place to start for users or folks new to Mifos.
Hi,

Thanks for support. Issue is resolved now.



On 13-Oct-2016, at 4:58 PM, Shreyaank Byadagi <shreyaank@confluxtechnologies.com> wrote:

Mifos.support

--
You received this message because you are subscribed to a topic in the Google Groups "Mifos Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mifosusers/K59eM6NHX8Y/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mifosusers+unsubscribe@googlegroups.com.
To post to this group, send email to mifos...@googlegroups.com.
Visit this group at https://groups.google.com/group/mifosusers.
For more options, visit https://groups.google.com/d/optout.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

--
You received this message because you are subscribed to a topic in the Google Groups "Mifos Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mifosusers/K59eM6NHX8Y/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mifosusers+unsubscribe@googlegroups.com.
To post to this group, send email to mifos...@googlegroups.com.
Visit this group at https://groups.google.com/group/mifosusers.
For more options, visit https://groups.google.com/d/optout.


_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

--
You received this message because you are subscribed to a topic in the Google Groups "Mifos Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/mifosusers/K59eM6NHX8Y/unsubscribe.
To unsubscribe from this group and all its topics, send an email to mifosusers+unsubscribe@googlegroups.com.
To post to this group, send email to mifos...@googlegroups.com.
Visit this group at https://groups.google.com/group/mifosusers.
For more options, visit https://groups.google.com/d/optout.




--
Thanks & Regards,
Avinash Dalvi
9890951446
Reply all
Reply to author
Forward
0 new messages