You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by "Zayyad A. Said" <za...@intrasofttechnologies.com> on 2019/07/28 15:57:08 UTC
RE: OpenJDK
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: zayyad@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
Description: Email banner
From: Victor Manuel Romero Rodriguez [mailto:vic_romero@hotmail.com]
Sent: 19 May 2019 04:06 AM
To: dev@fineract.apache.org
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, <te...@sanjosesolutions.in> 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 <za...@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
Description: Email banner
From: Awasum Yannick [mailto:awasum@apache.org]
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 <sa...@theupscale.in> 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, <za...@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
RE: OpenJDK
Posted by "Zayyad A. Said" <za...@intrasofttechnologies.com>.
Thanks Awasum,
I will try building from source and deploy on our test servers.
I thought Mifos X 18.03.01 was built on top of Fineract 1.3.
Regards;
*******
Zayyad A. Said | Chairman & C.E.O
Cell No.: +254 716 615274 | Skype: zsaid2011
Email: zayyad@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
Description: Email banner
From: Awasum Yannick [mailto:awasum@apache.org]
Sent: 28 July 2019 07:04 PM
To: Dev
Cc: Mifos software development
Subject: Re: OpenJDK
On Sun, Jul 28, 2019 at 4:57 PM Zayyad A. Said <za...@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
Description: Email banner
From: Victor Manuel Romero Rodriguez [mailto:vic_romero@hotmail.com]
Sent: 19 May 2019 04:06 AM
To: dev@fineract.apache.org
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, <te...@sanjosesolutions.in> 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 <za...@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
Description: Email banner
From: Awasum Yannick [mailto:awasum@apache.org]
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 <sa...@theupscale.in> 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, <za...@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
Schedule Meetings: https://calendly.com/zayyadsaid
Re: OpenJDK
Posted by Awasum Yannick <aw...@apache.org>.
On Sun, Jul 28, 2019 at 4:57 PM Zayyad A. Said <
zayyad@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
> [image: Description: Email banner]
>
>
>
> *From:* Victor Manuel Romero Rodriguez [mailto:vic_romero@hotmail.com]
> *Sent:* 19 May 2019 04:06 AM
> *To:* dev@fineract.apache.org
> *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, <te...@sanjosesolutions.in>
> 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 <
> zayyad@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
> [image: Description: Email banner]
>
>
>
> *From:* Awasum Yannick [mailto:awasum@apache.org]
> *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 <sa...@theupscale.in>
> 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, <
> zayyad@intrasofttechnologies.com> 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: zayyad@intrasofttechnologies.com
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
>
>
>
Re: OpenJDK
Posted by Victor Romero <vi...@fintecheando.mx>.
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: zayyad@intrasofttechnologies.com
> <ma...@intrasofttechnologies.com>
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
> Description: Email banner
>
> *From:*Victor Manuel Romero Rodriguez [mailto:vic_romero@hotmail.com]
> *Sent:* 19 May 2019 04:06 AM
> *To:* dev@fineract.apache.org
> *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,
> <terence@sanjosesolutions.in <ma...@sanjosesolutions.in>>
> 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
> <zayyad@intrasofttechnologies.com
> <ma...@intrasofttechnologies.com>> 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: zayyad@intrasofttechnologies.com
> <ma...@intrasofttechnologies.com>
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>
> Description: Email banner
>
> *From:*Awasum Yannick [mailto:awasum@apache.org
> <ma...@apache.org>]
> *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
> <saransh@theupscale.in <ma...@theupscale.in>> 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,
> <zayyad@intrasofttechnologies.com
> <ma...@intrasofttechnologies.com>> 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: zayyad@intrasofttechnologies.com
> <ma...@intrasofttechnologies.com>
>
> Schedule Meetings: https://calendly.com/zayyadsaid
>