[midPoint] Unable to Deploy midpoint 4.8 using PostGres

[SHARMA Kapil]

THALES GROUP LIMITED DISTRIBUTION to email recipients

Hello Everyone!

I am trying to deploy evolveum/midpoint:4.8 using a docker compose with postgres however I am getting below error in docker logs and its failing to deploy the midpoint container

Midpoint| 2023-11-09 11:34:14,864 [] [main] INFO (com.evolveum.midpoint.init.ConfigurablePrismContextFactory): Loading extension schemas from folder '/opt/midpoint/var/schema'.
Midpoint| 2023-11-09 11:34:30,725 [] [main] INFO (com.evolveum.midpoint.prism.impl.crypto.KeyStoreBasedProtectorImpl): Using file keystore at /opt/midpoint/var//keystore.jceks
Midpoint| 2023-11-09 11:34:31,122 [] [main] WARN (com.evolveum.midpoint.repo.sql.schemacheck.SchemaChecker): Found a problem with DB schema: Schema-validation: missing table [m_acc_cert_campaign]
PostgreSql     | 2023-11-09 11:34:31.338 UTC [56] ERROR:  relation "m_acc_cert_campaign" does not exist at character 22


Midpoint| ERROR initializing midPoint: org.springframework.context.ApplicationContextException: Unable to start web server
Midpoint| ROOT cause: com.evolveum.midpoint.util.exception.SystemException: DB script (/sql/postgresql-4.6-all.sql) couldn't be found
Midpoint| See midpoint.log for more details.

Same docker compose file was working for version 4.4, Let me know if anything needs to be changed , I have upgraded the postgres as well to recommended version 16.

with H2 database it works fine but with postgres its failing on version 4.8.

PostGres
    image: postgres:16-alpine
    container_name: PostgreSql
    environment:
     - POSTGRES_PASSWORD_FILE=/run/secrets/mp_database_password.txt
     - POSTGRES_USER=midpoint
     - POSTGRES_DB=midpoint
     - POSTGRES_INITDB_ARGS=--lc-collate=en_US.utf8 --lc-ctype=en_US.utf8



Midpoint_Server:
    image: evolveum/midpoint:4.8
    container_name: midpoint
    depends_on:
     - Midpoint_data
    environment:
     - REPO_DATABASE_TYPE=postgresql
     - REPO_HOST= midpoint
     - REPO_DATABASE=midpoint
     - REPO_USER=midpoint
     - REPO_PASSWORD_FILE=/run/secrets/mp_database_password.txt
     - REPO_MISSING_SCHEMA_ACTION=create
     - REPO_UPGRADEABLE_SCHEMA_ACTION
     - REPO_SCHEMA_VERSION_IF_MISSING
     - REPO_SCHEMA_VARIANT
     - MP_KEYSTORE_PASSWORD_FILE=/run/secrets/mp_keystore_password.txt
     - MP_MEM_MAX=2048m
     - MP_MEM_INIT=1024m
     - MP_JAVA_OPTS
     - TZ=UTC

Thank you in advance !

Regards
Kapil Sharma
Technical Lead
DIS-CPL
[cid:image001.png at 01DA132D.7B5958C0]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20231109/f05b2d7a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 2428 bytes
Desc: image001.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20231109/f05b2d7a/attachment.png>