Cannot initialize cache - Cannot configure cache: Data source for writing is not defined.

Question

I've built the project and in the knowage.log file (logs files in apache/logs path) I have the following error with the data source configuration and for some reason there is no roles and menus generated in the database (I've executed the scripts previously into a knowage_demo database in postgres). This error also appears in the logs of a executable version (version 7) but the roles and menus exists in its database (mariadb by defaut). Any idea about what can be wrong with the configuration? In the  server.xml file I've define the following resources:

• name=jdbc/knowage
• url="jdbc:postgresql://localhost:5432/knowage_demo"

• name=jdbc/ds_cache
• url="jdbc:postgresql://localhost:5432/ds_cache"

• name=jdbc/dwh
• url="jdbc:postgresql://localhost:5432/dwh"

Comments

Hi maquinola,

I don't know about the second error in your screenshot, but the first one on top means that you haven't set one of your databases, like ds_cache, to "Read and write" in the data source configuration. Have a look here: https://knowage-suite.readthedocs.io/en/6.4/administrator-guide/configure-data-sources.html.

---

Hi schipko,

The first one appears after the start of the project, the database is empty and I can't login into de system. I guess the second one is related to an error with roles because the database is not populated when the project is started. I've seen your link and the configuration is related to a situation where you already has entered to the system. Actually I can't get in into the system because there is no roles and menus in the database. Maybe there are things I'm not seen in the server.xml (apache/conf) configuration file or maybe in the context.xml (knowage/*) files. I really appreciate any additional information in order to fix this inconvenience.

---

Hi maquinola,

since you changed the database to PostgreSQL, did you change the hibernate configuration? https://knowage-suite.readthedocs.io/en/6.4/installation-guide/manual-installation.html#configuration-of-the-metadata-db-dialect . There was a similar problem here: https://www.knowage-suite.com/qa/177/use-knowage-with-postgresql-database?show=181#a181