Hi Bharath - what was the name of the WAR file you deployed? Unless you’ve specified otherwise in the Tomcat manager webapp or server.xml, I think Tomcat will use the war file name as the context path
So if you want Fineract to be available at /fineract-provider, can you check that the WAR file name is fineract-provider.war please? I.e. not fineract-provider-versionnumber.war or something. Regards Petri > On 7 Oct 2020, at 8:33 PM, Bharath Gowda <bgo...@mifos.org> wrote: > > Hi Petri and others, > > Now that with your help, I am able to have the instance running. however, on > the login screen, I am stuck with an Authentication error. > Please find below the screenshot for reference, I am getting the same error > from the postman as well, do you or anybody encountered and resolved this > issue? > > <image.png> > > <image.png> > Regards, > Bharath > Lead Implementation Analyst | Mifos Initiative > Skype: live:cbharath4| Mobile: +91.7019635592 > http://mifos.org <http://mifos.org/> <http://facebook.com/mifos> > <http://www.twitter.com/mifos> > > > On Wed, Oct 7, 2020 at 9:28 PM Bharath Gowda <bgo...@mifos.org > <mailto:bgo...@mifos.org>> wrote: > Thanks a Ton, Petri, It worked :) > > > Regards, > Bharath > Lead Implementation Analyst | Mifos Initiative > Skype: live:cbharath4| Mobile: +91.7019635592 > http://mifos.org <http://mifos.org/> <http://facebook.com/mifos> > <http://www.twitter.com/mifos> > > > On Wed, Oct 7, 2020 at 8:53 PM Petri Tuomola <petri.tuom...@gmail.com > <mailto:petri.tuom...@gmail.com>> wrote: > Hi Bharath > > The problem is that your Tomcat configuration is trying to use the protocol > class "org.apache.coyote.http11.http11protocol”. That was removed in Tomcat > 8.5 > > Please change org.apache.coyote.http11.http11protocol to > org.apache.coyote.http11.http11NioProtocol > > Hope this helps > > Regards > Petri > > > >> On 7 Oct 2020, at 6:16 PM, Bharath Gowda <bgo...@mifos.org >> <mailto:bgo...@mifos.org>> wrote: >> >> Hi Petri, >> >> Thank you for your valuable reply, reinstalling Mysql helped me to get over >> the issue and the flyway migration was successful. >> >> now I have reached another roadblock where the tomcat is not running the >> https server. >> Not sure if this is because of the Keystore error or something else >> >> WARNING [main] org.apache.tomcat.util.digester.SetPropertiesRule.begin Match >> [Server/Service/Connector] failed to set property [keystoreFile] to >> [C:\Users\Bharath\Desktop\apache-tomcat-9.0.38\.keystore] >> >> I have attached both server.xml and log file for your reference, could you >> please check and see if you could identify and help me with the issue >> >> >> >> Regards, >> Bharath >> Lead Implementation Analyst | Mifos Initiative >> Skype: live:cbharath4| Mobile: +91.7019635592 >> http://mifos.org <http://mifos.org/> <http://facebook.com/mifos> >> <http://www.twitter.com/mifos> >> >> >> On Wed, Oct 7, 2020 at 12:01 AM Petri Tuomola <petri.tuom...@gmail.com >> <mailto:petri.tuom...@gmail.com>> wrote: >> Hi Bharath >> >> This issue was discussed under >> https://issues.apache.org/jira/browse/FINERACT-980 >> <https://issues.apache.org/jira/browse/FINERACT-980> >> >> Basically Flyway does not know how to upgrade an existing Fineract database >> using Drizzle JDBC driver. It does know how to create a new one though. >> >> So for your local set-up you have two choices: >> >> - Delete your databases and start from scratch. In such case Drizzle should >> be able to create the latest database version. This is what happens on the >> integration test server every time we run a build, so that clearly works. >> But of course you lose any data you have in your database. >> >> - Change your local set-up to use a more up-to-date JDBC driver. One choice >> is the MySQL Connector/J. You can find instructions on how to switch to that >> at the bottom of the docker-compose.yml file. >> >> Hope this helps! >> >> Regards >> Petri >> >> >>> On 6 Oct 2020, at 9:20 PM, Bharath Gowda <bgo...@mifos.org >>> <mailto:bgo...@mifos.org>> wrote: >>> >>> Hi Petri, >>> >>> Appreciate your efforts in helping to resolve this issue. >>> >>> Recently, I have been struggling with running Fineract WAR on Tomcat 9.0.38 >>> on my Windows Machine >>> >>> I have followed all the steps properly which you had listed in this thread >>> 1. Install MySQL and Tomcat >>> 2. Build Fineract WAR from the latest develop branch: ./gradlew clean >>> bootWar >>> 3. Create tenants database: ./gradlew createDB -PdbName=fineract_tenants >>> 4. Create default tenant database: ./gradlew createDB >>> -PdbName=fineract_default >>> 5. Deploy Fineract WAR on Tomcat using manager webapp >>> (http://localhost:8080/manager/html <http://localhost:8080/manager>) >>> >>> I am stuck with error >>> "org.flywaydb.core.internal.exception.FlywayDbUpgradeRequiredException: >>> MySQL upgrade required: MySQL 0.1 is outdated and no longer supported by >>> Flyway. Flyway currently supports MySQL 5.1 and newer." >>> >>> With some digging got to know about a similar issue around 6 months ago and >>> something to do with drizzle jdbc driver, but I am not able to get this >>> resolved on my local, any help would be greatly appreciated. >>> I have attached my log for reference >>> >>> Would really be great if anyone else too could help me who knows about this >>> issue. >>> >>> >>> Regards, >>> Bharath >>> Lead Implementation Analyst | Mifos Initiative >>> Skype: live:cbharath4| Mobile: +91.7019635592 >>> http://mifos.org <http://mifos.org/> <http://facebook.com/mifos> >>> <http://www.twitter.com/mifos> >>> >>> >>> On Tue, Oct 6, 2020 at 11:36 PM Petri Tuomola <pe...@tuomola.org >>> <mailto:pe...@tuomola.org>> wrote: >>> All >>> >>> Looking at the log file shared by Tube, turns out that he has stumbled on >>> quite an interesting problem: >>> >>> It seems that you can’t run Fineract on a machine that is not connected to >>> the internet. >>> >>> I think the duplicate index error was relating to a corrupt MySQL instance. >>> After that’s fixed, the following error remains: >>> >>> org.springframework.beans.factory.parsing.BeanDefinitionParsingException: >>> Configuration problem: Failed to import bean definitions from relative >>> location [securityContext.xml] >>> Offending resource: URL >>> [file:/usr/local/Cellar/tomcat/9.0.38/libexec/webapps/fineract-provider/WEB-INF/classes/META-INF/spring/appContext.xml]; >>> nested exception is >>> org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line >>> 223 in XML document from URL >>> [file:/usr/local/Cellar/tomcat/9.0.38/libexec/webapps/fineract-provider/WEB-INF/classes/META-INF/spring/securityContext.xml] >>> is invalid; nested exception is org.xml.sax.SAXParseException; lineNumber: >>> 223; columnNumber: 63; cvc-complex-type.2.4.c: The matching wildcard is >>> strict, but no declaration can be found for element >>> 'oauth:authorization-server’. >>> >>> I can reproduce this by simply unplugging the network cable from my own >>> machine. It seems that our JAR/WAR does not include some xsds needed to >>> validate the XML config files. If the machine used is connected to the >>> internet, these are downloaded automatically - but if not, Fineract does >>> not start. >>> >>> Given these are related to Spring Security, I wonder if this will be fixed >>> by upgrading the Spring Security JARs? >>> >>> Anyway - I’ll log a JIRA for this, but thought I’d share it for your >>> information/entertainment... >>> >>> Regards >>> Petri >>> >>>> On 6 Oct 2020, at 7:24 PM, Petri Tuomola <pe...@tuomola.org >>>> <mailto:pe...@tuomola.org>> wrote: >>>> >>>> Hi Tube - that all looks OK. >>>> >>>> Doing ./gradlew just means running the gradlew in the current directory on >>>> UNIX-like OS, as typically you would not have current directory in your >>>> PATH. >>>> >>>> Can you send me (petri.tuom...@gmail.com <mailto:petri.tuom...@gmail.com>) >>>> your full Tomcat log file please. Maybe I can see what’s going wrong >>>> somewhere earlier. Not just the section with the error, but the entire >>>> file please. >>>> >>>> Regards >>>> Petri >>>> >>>>> On 6 Oct 2020, at 7:15 PM, ጓይላና Tube <eminemme...@gmail.com >>>>> <mailto:eminemme...@gmail.com>> wrote: >>>>> >>>>> hi. >>>>> Petri Tuomola thank you for your response. here are the list of commands >>>>> i have followed to build fineract. >>>>> 1.install mysql version 5.7 and Tomcat version 9 2. >>>>> 2. i have created tenants database using gradlew createDB >>>>> -PdbName=fineract_tenants command >>>>> 3. i have created Created default tenant database using gradlew createDB >>>>> -PdbName=fineract_default command >>>>> 4. i have created fineract War using gradlew clean bootwar command >>>>> 5. deploy created war file inside Tomcat/Webapps. >>>>> >>>>> But, is there any difference between gradlew clean bootwar and ./gradlew >>>>> clean bootwar? because when i run ./gralew clean bootwar command am >>>>> getting >>>>> an error message '.' is not recognized as an internal or external command >>>>> >>>>> Regards >>>>> >>>>> >>>> >>> >>> <catalina.2020-10-06.log> >> >> <catalina.2020-10-07.log><server.xml> >
