Installation of Knowage hangs with error JDBC Connection Failed.

Question

I followed the instructions in https://www.youtube.com/watch?v=0TTe-TZodok, however my installation hangs when I get to "Database Management System Configuration" and I get the error message "JDBC connection failed". 

I am on Linux Mint 19

During installation i used /home/mike/Software as the install directory. 

When I start the Knowage installation I get the following:

mike@mike-HP-ProBook-6570b:~/Downloads$ ./Knowage-6_3_1-CE-Installer-Unix-20190205.sh
Starting Installer ...
19/02/13 11:28:44 INFO jdbc.Driver: Embedded Neo4j support not enabled  org/neo4j/graphdb/GraphDatabaseService
19/02/13 11:28:44 INFO jdbc.Driver: Embedded Neo4j support not enabled org/neo4j/graphdb/GraphDatabaseService

Then it hangs as exlained above!

I did check JAVA_HOME:

mike@mike-HP-ProBook-6570b:~$ echo $JAVA_HOME
/usr/lib/jvm/java-8-oracle

Then I checked MySQL and it appears OK:

mike@mike-HP-ProBook-6570b:~$ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mysql-server is already the newest version (5.7.25-0ubuntu0.18.04.2).
0 upgraded, 0 newly installed, 0 to remove and 37 not upgraded.

And it appears Knowage was unpacked and installed in the correct directory i.e. /Software/Knowage-Server-CE

So I ran ./configtest.sh and got the following:

mike@mike-HP-ProBook-6570b:~/Software/Knowage-Server-CE/bin$ ./configtest.sh
Using CATALINA_BASE:   /home/mike/Software/Knowage-Server-CE
Using CATALINA_HOME:   /home/mike/Software/Knowage-Server-CE
Using CATALINA_TMPDIR: /home/mike/Software/Knowage-Server-CE/temp
Using JRE_HOME:        /usr/lib/jvm/java-8-oracle
Using CLASSPATH:       /home/mike/Software/Knowage-Server-CE/bin/bootstrap.jar:/home/mike/Software/Knowage-Server-CE/bin/tomcat-juli.jar
Feb 13, 2019 2:31:58 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
Feb 13, 2019 2:31:58 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Feb 13, 2019 2:31:58 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Feb 13, 2019 2:31:58 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 752 ms

I'm somewhat of a novice to Linux and Java both so currently I am stuck!  Any advice would be appreciated!

Answer 1

So while I am using Ubuntu Bionic Beaver (v 18 LTS Release) I have the exact same issue. I noted that the error you mentioned occurred for me. The installer hung at the error: "INFO jdbc.Driver: Embedded Neo4j support not enabled org/neo4j/graphdb/GraphDatabaseService"

For me I re-installed Ubuntu and then started all over again. Below are the steps I took to get this all working:

1. Installed Java

A. sudo apt-get purge openjdk-\*

B. sudo apt-get update 

C. sudo apt-get install oracle-java8-installer 

D. sudo apt-get install oracle-java8-set-default

2. Set the Variables:

A. export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64/

To determine the path type:

update-alternative --list java

3. Install MySQL: 

A. sudo apt-get install mysql-server

B. sudo mysql-secure_installation

4. I had to change my Root accounts login method:

A. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Where the red text is a secure password you set for the Root account for the mysql server

B. FLUSH PRIVILEGES;

C. SELECT user,authentication_string,plugin,host FROM mysql.user;

The output should show the Root account as mysql_native_password under the "plugin" header

5. I installed NEO4J (may not be needed)

A. wget -O - https://debian.neo4j.org/neotechnology.gpg.key | sudo apt-key add -

B. echo 'deb http://debian.neo4j.org/repo stable/' >/tmp/neo4j.list

C. sudo mv /tmp/neo4j.list /etc/apt/sources.list.d

D. sudo apt-get update

E. sudo apt-get install neo4j=3.1.4  <-- This installs Community Edition