Installing to non-MySQL database

Question

I downloaded  Windows JVM64bit-20170623 installer and it's asking for MySQL db to proceed with the installation. While I do have MySQL I wish to install to PostgreSQL.

Is there a way to tell the installer to use another database? And what are the options if I don't want to use MySQL?

Answer 1

Dear Lawi,

If you want to use PostgreSQL, you have the following option:

1) Use the installer to My SQL and then change the DBMS to PostgreSQL

2) Install Knowage starting from the released WAR.

Best regards

Angelo

Comments

Thanks Angelo for the tips.

Is there documentation that shows how to achieve either of the options? The pdf document available for download does not cover installation options.

Thanks again for the swift response

---

At the moment there is no available docs that shows how to install it step by step.
Anyway, we have planned to release it soon.

---

Hi

Are there any updates on the docs for connecting to PostgreSQL instead of mysql? I am facing a lot difficulty in connecting postgresql as no where proper steps are mentioned.

And here you said that 'change the DBMS to PostgreSQL'.. how do we do that in Knowage. Some clarity on this would be very helpful.

Thanks!

Answer 2

Thanks for that.

I have somehow managed to get it working by following the following steps:
a) Create a db in PostgreSQL (and preferably, a separate role for knowage)
b) Download and install Tomcat - I chose to try Tomcat 8
c) Edit the server.xml in %TOMCAT_HOME%/conf
This is where you set the database connections. I used the installer version as a guide
Also these sources:
https://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html#PostgreSQL
https://confluence.atlassian.com/doc/configuring-a-postgresql-datasource-in-apache-tomcat-218272013.html#ConfiguringaPostgreSQLDatasourceinApacheTomcat-Step3.ConfigureTomcat

http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Installation_v2

d) Checking the $tomcat_home/webapps/[knowage]/META-INF/context.xml
This file was already configured.

e) Edit $tomcat_home\webapps\knowage\WEB-INF\classes\hibernate.cfg.xml
Uncomment the line with PostgreSQL:
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
Comment the MySQL property
f) Edit $tomcat_home\webapps\knowage\WEB-INF\classes\quartz.properties
Uncomment the line with PostgreSQL delegate class:

# Postgres delegate class
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate

Comment the line with Mysql/Ingres delegate class

g. Create a metadata datasource in knowage:
Type=JNDI
Jndi Name: java:comp/env/jdbc/ds_cache

Write Default must be checked

I look forward to a more structured guide. I am still monitoring this setup for errors so let me know if there are any steps I missed

Comments

Hello
I want just to know if you succeded to solve the problem.Please let me know .
Yours faithfully