Hi,
We have faced that because MySQL has a new authentication protocol, to
make it work as previous versions just try
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY
'password'
Taken from
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server
Regards
Victor
El 28/07/19 a las 10:57, Zayyad A. Said escribió:
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]
<mailto:[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] <mailto:[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 <http://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>
<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]
<mailto:[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]
<mailto:[email protected]>
Schedule Meetings: https://calendly.com/zayyadsaid
Description: Email banner
*From:*Awasum Yannick [mailto:[email protected]
<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] <mailto:[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]
<mailto:[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]
<mailto:[email protected]>
Schedule Meetings: https://calendly.com/zayyadsaid
