Postgresql integration in camunda tomcat

I’m trying to change the database from H2 to Postgresql. Camunda runs on Tomcat. The instructions and solutions that I found were unsuccessful, the server could not start after the changes. Could you help in setting Camunda for Postgresql on Tomcat correctly? Error log attached. Thanks in advance.catalina.2019-11-21.log (263.3 KB)

Hi @Arthur_SBS,

welcome to the forum.

One little remark: The log is displaying a lot of important text in non-English (I am no expert but I guess it is Russian?). That can make it difficult for the community to dig into the issue you’re having.

To the topic: Translation suggests that there is an authentication issue with the database. Can you double-check that the user and password for the PostgreSQL database are configured correctly?

Best,
Tobias

1 Like

Thanks for the quick feedback! Yes, this is Russian. Recheck the correct username / password, they turned out to be correct. Updated the log, now it is completely in English.catalina.2019-11-22.log (36.4 KB)

Hi @Arthur_SBS,

thanks for the new log!
Looks like the PostgreSQL driver is not present on your Tomcat.
Did you follow this guide?

Specifically, you need to do this:

Furthermore, you have to merge your corresponding JDBC driver into the folder $TOMCAT_HOME/lib.

In your case, a PostgreSQL driver then, e. g. from this site: https://jdbc.postgresql.org/download.html

Best,
Tobias

Thank you for all possible help. Just in case, I repeated the instructions sent by you. The result has not changed. As I noticed, the problem is in the launch / operation of the Catalina life cycle. Perhaps this is a consequence, not a reason, just noticed an observation. Log attached. catalina.2019-11-22.log (15.0 KB)

May be this video helps: https://m.youtube.com/watch?v=xR0glID94wA&t=57s

3 Likes

Thanks! The server is now at least not crashing! I hope it will be able to understand himself. Thanks again!)

1 Like