Skip to main content
Version: 8.2

Troubleshooting database connection issues

note

Web Modeler Self-Managed is available to enterprise customers only.

You try to start Web Modeler, and encounter issues with the database connection.

Using a non-empty schema

As Web Modeler uses Flyway to manage schema updates, the schema should not be shared.

Before the first initialization, ensure no tables or functions are present in your schema.

If your database setup requires mandatory tables or functions, Flyway may throw an exception like Found non-empty schema(s) "<schema name>" without schema history table!

To overcome this issue, add the property spring.flyway.baselineOnMigrate: true to your Web Modeler configuration and remove it after the schema has been initialized.

Secure connection to standard PostgreSQL

Refer to the database configuration guide for details on how to configure a secure connection to PostgreSQL.

Secure connection to Amazon Aurora fails

You configured a custom SSL certificate in your remote Amazon Aurora PostgreSQL instance and want Web Modeler to accept that certificate.

Add Amazon Root CA to trust store

By default, the Java version used by modeler-restapi ships with the Amazon Root CA.

If you passed a custom trust store to modeler-restapi's JVM process (e.g. via JAVA_TOOL_OPTIONS as described in the Zeebe connection troubleshooting guide), ensure the Amazon Trust Services CA are in modeler-restapi's trust store (see the Amazon Aurora documentation).

IAM authentication against Amazon Aurora fails

You switched from standard username/password authentication to IAM authentication and Web Modeler can't obtain a connection to the database.

Ensure the IAM account has all privileges to the Web Modeler database

After switching from standard username/password authentication to IAM authentication, privileges to Web Modeler's database might still be associated with the old username. Ensure the IAM account has all privileges to the Web Modeler database.