On Sun, Jul 28, 2019 at 4:57 PM Zayyad A. Said < [email protected]> wrote:
> Hello Devs, > > > I am back again with this issue, the last time I reported I got a comment > that latest version of Fineract works on MySQL 5.7. > Latest Fineract is different from Latest Mifos X. > > > We decided to do a new server installation for Mifos X 18.03.01 on Ubuntu > 18.04, OpenJDK8, and MySQL 5.7 but still cant log in and we are getting the > following error in the logs: > Fineract 1.3 supports MySQL 5.7. Mifos X 18.03.01 is built ontop of Fineract 1.2 if am not mistaken. Next Mifos X based on Fineract 1.3 or 1.3.1 are not yet released. You will have to compile your own version of Fineract from source, build and test in production and add your own Pentaho. > > > *SEVERE: Unable to create initial connections of pool.* > > *java.sql.SQLException: Could not connect: Client does not support > authentication protocol requested by server; consider upgrading MySQL > client* > > > > I suspect this is still an issue with MySQL 5.7 as we had noted earlier. I > have attached herewith the server logs for your review. > > > > Is there anyone who is using MySQL 5.7 and working perfectly? If yes, > could you please guide on steps taken to work with MySQL 5.7? > > > > Thanks & Regards; > > > > ********* > > *Zayyad A. Said | Chairman & C.E.O* > > > > Cell No.: +254 716 615274 | Skype: *zsaid2011* > > Email: [email protected] > > Schedule Meetings: https://calendly.com/zayyadsaid > > [image: Description: Email banner] > > > > *From:* Victor Manuel Romero Rodriguez [mailto:[email protected]] > *Sent:* 19 May 2019 04:06 AM > *To:* [email protected] > *Subject:* Re: OpenJDK > > > > Hi! > > You can try with the info in the repository > https://github.com/fintecheando/fintecheando-mifos-docker-ubuntu > > It will save some time, check the build instructions and the Dockerfile > sample in the mysql folder. > > Regards > > Victor > > El 18/05/19 a las 13:12, Saransh Sharma escribió: > > Hey terrence it wont work like this you might have to do this > > On Sat, 18 May 2019, 22:50 Terence Monteiro, <[email protected]> > wrote: > > Dear Zayyad, > > > > If you're familiar with docker and you have it installed, you can do the > following: > > 1. Create a data folder as root > sudo mkdir -p /opt/mysql_data > 2. Start docker mysql 5.6 with above folder mounted as data directory, > with port 3306 forwarded > sudo docker run -p 0.0.0.0:3306:3306 -v /opt/mysql_data:/var/lib/mysql > mysql:5.6 > > Now your docker mysql 5.6 instance will work just like a local instance. > In fact you only need step 1 to ensure data persistence, otherwise mysql > 5.6 will run but the data store will be inside the container and get > flushed when the container dies. > > > > -- > > Best Regards, > Terence Monteiro, > > Mob: +91 96633 13728 > > www.sanjosesolutions.in > > <http://www.sanjosesolutions.in> > > "Terroy", 67, 10th Cross,, > > Lingarajpuram, Bangalore - 84. > > > > > > On Sat, May 18, 2019 at 4:11 PM Zayyad A. Said < > [email protected]> wrote: > > Devs, > > > > With the help of Saransh, we were able to identify the issue was on MySQL > version. > > > > We had version 5.7 and Mifos X requires 5.5. or 5.6. > > > > The challenge we are now facing is 5.6 isn’t supported in Ubuntu 16.04 and > 18.04, these versions of Ubuntu supports 5.7 and above. > > > > Is there anyone who has a workaround on installing mysql-server-5.6 on > Ubuntu 16.04? > > > > Your quick help will be appreciated. > > > > Regards; > > > > ********* > > *Zayyad A. Said | Chairman & C.E.O* > > > > Cell No.: +254 716 615274 | Skype: *zsaid2011* > > Email: [email protected] > > Schedule Meetings: https://calendly.com/zayyadsaid > > [image: Description: Email banner] > > > > *From:* Awasum Yannick [mailto:[email protected]] > *Sent:* 18 May 2019 08:30 AM > *To:* Dev > *Cc:* Mifos software development; Santosh Math > *Subject:* Re: OpenJDK > > > > Hi Zayyad, > > > > If you are using Tomcat then shutdown the tomcat server and delete the > fineract-provider folder under webapps/ dir and start tomcat again. > > > > > > On Fri, May 17, 2019 at 11:13 PM Saransh Sharma <[email protected]> > wrote: > > Definitely mifos x works with openjdk this error could be related to > something else. Do you have logs to offer from front end as well backend. > > > > Thanks > > > > On Sat, 18 May 2019, 01:44 Zayyad A. Said, < > [email protected]> wrote: > > Devs, > > > > Just wondering if anyone has been successful to run Mifos X on OpenJDK. > > > > We got stuck installing Oracle Java 8 on Ubuntu 18.04 and resorted to > OpenJDK. > > > > The installation went through to completion but cant log in, throwing an > error: > > > > *Couldn’t connect to server. Make sure you are using correct settings.* > > > > Could this be attributed by the JDK version? > > > > Regards; > > > > ********* > > *Zayyad A. Said | Chairman & C.E.O* > > > > Cell No.: +254 716 615274 | Skype: *zsaid2011* > > Email: [email protected] > > Schedule Meetings: https://calendly.com/zayyadsaid > > > >
