Re: [Mifos-developer] [Mifos-users] Mifos - 21.07.02 Patch release installation issue - Mysql connection refused to connect

[Kelvin Ikome]

Hi Pavan,

Here are a couple of quick checks you can make...

1. Are you able to connect to the DB using MySQL client? If so, check the hostname/url.

2. If the hostname/url is correct, you can try using IP of the server.

3. If 1 and 2 are in place, go check the "schema_url" inside of "fineract_tenants" database. "tenant_server_connections" table.

Kind regards,

Kelvin

On Mon, Apr 25, 2022 at 9:13 AM Pavan Karasala <pavan.k...@nanobnk.com> wrote:

Dear Team,

We have started deploying the new Mifos and we are having a MySQL connectivity issue.

Below are the versions we are using.

Versions:

Mifos: 21.07.02.Patch release

JDK: 15.02 64 bit

Tomcat: 9.0.38 64 bit

MySQL : 5.7.37.0 

Mysql Connector : mysql-connector-java-8.0.21.jar

Error:

Caused by: org.drizzle.jdbc.internal.common.QueryException: Could not connect: Connection refused: connect
                at org.drizzle.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:147)
                at org.drizzle.jdbc.DrizzleDriver.connect(DrizzleDriver.java:91)
                ... 203 more
        Caused by: java.net.ConnectException: Connection refused: connect

Can you please advise/help if we are missing something here?

--

Thanks,  

Pavan Karasala

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

[Francis Guchie]

Yes Pavan,

For the first time installation - only create 2 databases fineract_default and fineract_tenants. On the first time launch, apache-fineract will do the magic for you

My Kind Regards

Francis Guchie Kirago

Skype: francisguchie

Telegram: 232 79 19 44 07

Whatsapp: 232 79 19 44 07

LINKEDIN: https://www.linkedin.com/in/francis-guchie-kirago-a4379617/

twitter: @FrancisGuchie

On Mon, Apr 25, 2022 at 1:03 PM Pavan Karasala <pavan.k...@nanobnk.com> wrote:

Hi Kevin/Francis,

We are able to connect to the database using Heidi with the same credentials and url. 

Only via Mifos tomcat server, we are not able to connect.

Am assuming that tables will be created automatically during the first start of the Mifo's server. 

Unlike MifosX, we are not required to create tables manually am assuming. 

Please correct us, if our assumption is wrong.

Any help will be really appreciated.

Thanks,

Pavan Karasala

--

[Bharath Gowda]

Hello Pavan,

The versions installed look good,

Could you verify below few configurations please 

1. Could you let me know if you have changed the MySQL credentials from the default once?

Fineract stores and reads the database connections from two places, please check the connection details are correct here

a. fineract_tenants DB's `tenant_server_connections` table

b. jdbc.properties file in tomcat

Location:apache-tomcat-9.0.38\webapps\fineract-provider\WEB-INF\classes\META-INF\spring\jdbc.properties

Connection details in this file to check 

"DRIVERCLASS_NAME:org.drizzle.jdbc.DrizzleDriver

PROTOCOL:jdbc
SUB_PROTOCOL:mysql:thin

fineract_tenants_driver:org.drizzle.jdbc.DrizzleDriver
fineract_tenants_url:jdbc:mysql:thin://localhost:3306/fineract_tenants
fineract_tenants_uid:root

fineract_tenants_pwd:mysql"

2. Could you check if the DBs' fineract_default and fineract_tenant have tables and values populated?

if not,  then I would suggest you reinstall the mysql with default credentials first and try again

i.e

port: 3306

host: localhost

user: root

password: mysql

I hope this helps, if the issue still persists, please share the complete log file to analyze further.

Regards,

Bharath

Lead Implementation Analyst | Mifos Initiative

Skype: live:cbharath4| Mobile: +91.7019635592

http://mifos.org  

On Thu, Apr 28, 2022 at 8:15 AM Pavan Karasala <pavan.k...@nanobnk.com> wrote:

Dear Bharath/Francis,

Can you please confirm if the below stack versions are compatible?

Versions:

Mifos: 21.07.02.Patch release

JDK: 15.02 - 64 bit

Tomcat: 9.0.38 - 64 bit

MySQL : 5.7.37.0 - 64bit

Mysql Connector : mysql-connector-java-8.0.21.jar

We are facing an issue connecting to the database server.

We were able to connect using Heidi using the same credentials and port.

Any help would be highly appreciated.

Awaiting your reply.

Thanks and Regards,

Pavan Karasala

On Tue, Apr 26, 2022 at 2:34 PM Pavan Karasala <pavan.k...@nanobnk.com> wrote:

Dear Francis,

Thanks for confirming. 

Can you please validate or confirm us back if the versions we are using are correct?

The server is failing to start up as it's failing to connect to mysql database.

Thanks,

Pavan Karasala 

--

[Bharath Gowda]

Hi Pavan,

If I understand correctly if the Mysql and server are on the same server, you can connect successfully, but the problem is when you have the database on a different server?

As far as I am aware, there are only 3 places where you have to configure the Myslq connection details, it will work when you configure the MySQL details properly in these 3 places.

1. fineract_tenants DB's `tenant_server_connections` table

2. jdbc.properties file in tomcat

Location:apache-tomcat-9.0.38\webapps\fineract-provider\WEB-INF\classes\META-INF\spring\jdbc.properties

3. Server.xml file in tomcat

Location:apache-tomcat-9.0.38\\conf\server.xml

Please check and let me know

Regards,

Bharath

Lead Implementation Analyst | Mifos Initiative

Skype: live:cbharath4| Mobile: +91.7019635592

http://mifos.org  

On Tue, May 24, 2022 at 12:36 PM Pavan Karasala <pavan.k...@nanobnk.com> wrote:

Dear Bharath,

 

Can you please help us out here?

 

Thanks,

Pavan Karasala

+919620112233

 

From: Pavan Karasala
Sent: Saturday, April 30, 2022 2:46 PM
To: Bharath Gowda; Francis Guchie
Cc: Francis Guchie; A good place to start for users or folks new to Mifos.; Mifos software development
Subject: RE: [Mifos-users] Mifos - 21.07.02 Patch release installation issue - Mysql connection refused to connect

 

Hi Bharath,

 

Instead of connecting to a remote database, I have created a local database server on my machine.

With credentials for MySQL as you advised.

It worked perfectly and am able to access new as well as old UI’s and proceed with using the new Mifos.

 

But I have noticed the below.

1. Tenant_server_connections table was not created before. So this should not be a problem even while connecting to remote database.
2. Jdbc properties files are updated correctly. So even this should not have been a problem to connect to remote database using different credentials.
3. Tables are not populated first for the new mifos as confirmed by @Francis Guchie, unlike MifosX.
4. Server.xml was also updated correctly with updated MySQL credentials. So even that should not have been a problem to connect to remote database using updated credentials.

 

Guess somewhere else the credentials to database must have been hardcoded. Probably the sql files that are being read as part of the deployment?

 

Can you please help us here so that we will be able to connect to our remote database?

 

Pls note that we are not using the default credentials to connect with Mysql Database. Only the schemas are created manually.
Tables are not populated nor created by us manually to those schemas.

 

Thanks,

Pavan Karasala

+919620112233

 

From: Bharath Gowda
Sent: Thursday, April 28, 2022 1:02 PM
To: Pavan Karasala
Cc: Francis Guchie; A good place to start for users or folks new to Mifos.; Mifos software development
Subject: Re: [Mifos-users] Mifos - 21.07.02 Patch release installation issue - Mysql connection refused to connect

 

Hello Pavan,

The versions installed look good,

 

Could you verify below few configurations please 

 

1. Could you let me know if you have changed the MySQL credentials from the default once?

 

Fineract stores and reads the database connections from two places, please check the connection details are correct here

 

a. fineract_tenants DB's `tenant_server_connections` table