0 votes
1 view

I am recently having this issue

I have 2 instances of Knowage CE installed. One in Ubuntu in 18.04 running Knowage 7.2.0 CE and another in Windows 10 unning Knowage 6.4.4 CE. Using Windows 10, I have no problem connecting to my managed MySQL 8.0.20 database  in Digital Ocean  but I am having a problem connecting from my Ubuntu server running in a Digital Ocean droplet. 

I have been able to connect to MySQL 8.0.XX databases from my Knowage installed in Ubuntu previously using Knowage 6.4.4 but, recently I am having issues running / starting that version in Ubuntu that is why I tried switching to 7.2

I am using these JDBC Driver for MySQL 8: mysql-connector-java-8.0.15 . I also tried mysql-connector-java-8.0.21 but still cannot connect.

In the driver field: com.mysql.cj.jdbc.Driver

From my Windows 10 machine 

From my Ubuntu Server

Environment 7.2 CE, Ubuntu 18.04, Windows 10
asked Aug 16, 2020 in End-user Environment by darwinpasco (2,770 points)
edited Aug 16, 2020 by darwinpasco | 1 view

1 Answer

+1 vote
Best answer

I fixed the issue by simply replacing the mysql-connector-java-8.0.15.jar file I downloaded from here https://jar-download.com/artifacts/mysql/mysql-connector-java

I used the jar file from one of my successful installation. It's working now

answered Aug 16, 2020 by darwinpasco (2,770 points)
It works for me!
1,553 questions
1,017 answers
2,037 comments
2,567 users