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.karas...@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 > > On Mon, 25 Apr 2022, 16:42 Francis Guchie, <francisguc...@gmail.com> > wrote: > >> 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.karas...@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 >>> >>> >>> 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
