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. 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: 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 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 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
