"JDBC connection faild" error in knowage configuration process

Question

i'm trying to install knowage on my manjaro linux and in database management section i get an error:(JDBC connection failed) and i don't know what to do about this error.

have to say that i have mysql workbench on my linux.

plz help me how to configure MySQL server url and JDBC.

Comments

Hi, please check that on your local machine a MySQL Server instance is currently up and running. MySQL Workbench is just a client, you need to have also the server installed.

---

hi, i installed MySQL server before and runnig corectly, actually my problem is about JDBC.

---

Hey there,

Did you manage to get this running? I'm having the same issue with the configuration of Mysql, I can connect using workbench but not through the Knowage wizard.

Answer 1

Check that the address and port that you are using are the correct one to reach the database, also the same for user and password.

Comments

I also have the same problem in my linux box (tried openjdk1.7, oracle 1.8, put the mysql-connector in the lib folders, enabled user connection from anyhost, ...) but I always get:

JDBC connection failed

while I can connect via phpMyadmin. Additionally I get:

INFO jdbc.Driver: Embedded Neo4j support not enabled org/neo4j/graphdb/GraphDatabaseService

---

Neo4j is not a valid Database to store Knowage metadata, please use a relational database.

Answer 2

Hello,

I had a similar issue and my problem was that my Root account in mySQL was not set for mysql_native_password but rather was set for auth_socket. 

To check this go to terminal:

1. Type Sudo mysql

2. Type  SELECT user, authentication_string,plugin,host FROM mysql.user;

3. The very top entry in the "table" should be the Root UID entry look to the far right for its auth method if it reads auth_socket then proceed with the following steps.

4. type ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<ENTER YOUR SUPER SECURE PASSWORD HERE>';

**Everything in red above obviously needs to be changed by you

5. Now type FLUSH PRIVILEGES;

6. Now confirm the change took by re-typing SELECT user, authentication_string,plugin,host FROM mysql.user;

7. Type exit to leave and complete the rest of the Knowage install.

Hope this helps other as it took a little bit for me to identify. 

Comments

thanks you, it solved my problem

---

Best answer: Thanks a lot Richc, I spent the whole day trying to installl this and your answered worked. Really appreciate it. Thanks.

---

After apply this explani I finished the instalation process. Tks.

My environment: Ubuntu Desktop 20.04, Mysql 8.0.2, Knowage 7.2.0

---

richc, Many many many .....MANY THKS .. spent 5 hrs on it before reading you..

kindly suggest at knowage team to upgrade your tutorial

---

Thanks. It worked for mysql 8.0.22