Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Installer Knowage-6_2_0-CE-Installer-Unix-20180809 error in Centos 6 Mysql DB

0 votes
1 view
Why can not I install with Mysql in linux Centos 6 x64
I do not know what else to try. It can not be that I only have this problem.

Please someone who can give me a hand

Thanks in advance

Error

Username:
[]
root

Password:

WARNING: please provide a database user that can create schemas.
The following schemas will be created (or overwritten):
*  knowage_ce

18/09/06 10:59:53 INFO jdbc.Driver: Embedded Neo4j support not enabled org/neo4j/graphdb/GraphDatabaseService
18/09/06 10:59:53 INFO jdbc.Driver: Embedded Neo4j support not enabled org/neo4j/graphdb/GraphDatabaseService
java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.install4j.runtime.installer.helper.Install4jClassLoader$CustomCodeInvoker.invoke(Install4jClassLoader.java:165)
        at com.install4j.runtime.installer.helper.Install4jClassLoader.invokeInCustomClassLoader(Install4jClassLoader.java:156)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.createConnection(AbstractJdbcAction.java:139)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withConnection(AbstractJdbcAction.java:201)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withStatement(AbstractJdbcAction.java:176)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.withResultSet(AbstractJdbcAction.java:153)
        at com.install4j.runtime.beans.actions.jdbc.CheckJdbcConnectionAction.executeJdbcCall(CheckJdbcConnectionAction.java:32)
        at com.install4j.runtime.beans.actions.jdbc.AbstractJdbcAction.execute(AbstractJdbcAction.java:95)
        at com.install4j.runtime.beans.actions.SystemInstallOrUninstallAction.install(SystemInstallOrUninstallAction.java:29)
        at com.install4j.runtime.installer.ContextImpl$7.executeAction(ContextImpl.java:1668)
        at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1659)
        at com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1656)
        at com.install4j.runtime.installer.helper.comm.actions.FetchObjectAction.execute(FetchObjectAction.java:14)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionDirect(HelperCommunication.java:274)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionInt(HelperCommunication.java:249)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionChecked(HelperCommunication.java:187)
        at com.install4j.runtime.installer.helper.comm.HelperCommunication.fetchObjectChecked(HelperCommunication.java:170)
        at com.install4j.runtime.installer.ContextImpl.performActionIntStatic(ContextImpl.java:1656)
        at com.install4j.runtime.installer.InstallerContextImpl.performActionInt(InstallerContextImpl.java:151)
        at com.install4j.runtime.installer.ContextImpl.performAction(ContextImpl.java:1103)
        at com.install4j.runtime.installer.controller.Controller.executeAction(Controller.java:368)
        at com.install4j.runtime.installer.controller.Controller.executeActions(Controller.java:334)
        at com.install4j.runtime.installer.controller.Controller.handleCommand(Controller.java:195)
        at com.install4j.runtime.installer.controller.Controller.start(Controller.java:94)
        at com.install4j.runtime.installer.Installer.runInProcess(Installer.java:59)
        at com.install4j.runtime.installer.Installer.main(Installer.java:46)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)
        at com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:57)
An error occurred:
java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
Error log: /opt/install4jError1135644749999983207.log

I have all grant of root and mysql is running.

Thank
Environment k6.2, Centos 6 x64, tomcat, console
in Installer by (260 points)

2 Answers

0 votes
 
Best answer
I also had the problem (on Ubuntu 14.04 LTS): the only solution I found was to install 6.1.1 and upgrade. I also checked the install on a basic Ubuntu 14.04 LTS virtual install and in that case the 6.2 installer worked fine.
by (680 points)
selected by
0 votes

It is because of duplicate of hsqldb.jar in installer classpath. 

Workaround:

1. Run installer as normal
2. Right before config RDBMS steps. 
Database Management System Configuration
Use an already installed DBMS [1, Enter]
1
Select DBMS for metadata:
MariaDB [1, Enter]
MySQL [2]

3. Delete hsqldb.jar in temporary extracted installer dir (in my case: /home/apps/Knowage-7_2_0-CE-Installer-Unix-20200730.sh.14611.dir)

rm /home/apps/Knowage-7_2_0-CE-Installer-Unix-20200730.sh.14611.dir/user/hsqldb.jar

4. Continue installation

by (1.0k points)
Powered by Question2Answer
...