Postgresql Linux

Question

Hello All,

Im trying to install the knowage on linux using postgresql, and it doesn't install correctly.

The system show me the following error.

https://ibb.co/m98Zkb

How can i install the knowage on linux and use the postgresql instead of mysql !?

Thanks

Answer 1

If you have a look at the Knowage Installer docs you will see that it only support MySQL as target database. Thus, the error coming from the installer is what I would expect to have.

If you want to have you repository on Postgresql you have to configure your application server by adding the following libs:

• https://search.maven.org/remotecontent?filepath=commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar
• https://search.maven.org/remotecontent?filepath=commons-logging/commons-logging-api/1.1/commons-logging-api-1.1.jar
• https://search.maven.org/remotecontent?filepath=org/lucee/oswego-concurrent/1.3.4/oswego-concurrent-1.3.4.jar
• https://search.maven.org/remotecontent?filepath=mysql/mysql-connector-java/5.1.33/mysql-connector-java-5.1.33.jar
• https://search.maven.org/remotecontent?filepath=org/apache/geronimo/specs/geronimo-commonj_1.1_spec/1.0/geronimo-commonj_1.1_spec-1.0.jar
• http://commonj.myfoo.de/bin/foo-commonj-1.1.0.zip (from this zip ONLY get the foo-commonj.jar)

Download all the web application for the OW2 Forge https://forge.ow2.org/project/showfiles.php?group_id=442

Download the SQL script for Postgresql (from the OW2 forge) and populate a schema with the required tables.

Adjust the application server configuration (as instance, in case of Tomcat, configured the server.xml).

I would suggest to use the All-IN-One Knowage 6.0 RC as base for this process if you are not familiar with it: http://download.forge.ow2.org/knowage/All-in-One-Knowage-6.0.0_RC_CE_20170429.zip