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 On Mon, Apr 25, 2022 at 2:53 PM Kelvin Ikome <kvnik...@gmail.com> wrote: > 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.karas...@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-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > --
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
