[midPoint] Unable to deploy midPoint 4.8 with postgresql using Docker

[BHATNAGAR Deshak]

THALES GROUP LIMITED DISTRIBUTION to email recipients

Added the docker-compose for reference.

Thanks
From: BHATNAGAR Deshak
Sent: Friday, November 10, 2023 9:43 PM
To: midpoint at lists.evolveum.com
Subject: Unable to deploy midPoint 4.8 with postgresql using Docker


THALES GROUP LIMITED DISTRIBUTION to email recipients

Hello midpoint community,
I am deploying the Evolveum midpoint 4.8 with postgresql using Docker but I am facing the below mentioned error:

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

This above error occurs because the system is not able to create required database tables, the log file is attached below (log file (error))

I was previously using the LTS version midpoint 4.4.4 and used the same docker-compose file with changes to midpoint 4.8 image and postgresql-16 image.

I have tried with all the recommended version of both midpoint 4.8 as well as postgresql db.

But the error remains the same in all cases.

Also, a similar error was reported on the Jira of Evolveum regarding the schema validation in which the database tables were not created: https://jira.evolveum.com/projects/MID/issues/MID-9258?filter=doneissues

As per the conclusion drawn after my troubleshooting.
I found out that the config/sql file in midpoint 4.8 repository on Github do not have the above-mentioned file in the error i.e., postgresql-4.6-all.sql (https://github.com/Evolveum/midpoint/tree/v4.8/config/sql/native).

In-comparison, all of the previous versions of midpoint on the Github had the file (postgresql-4.6-all.sql) in their respective repositories, for example: midpoint 4.7.2 had the file postgresql-4.6-all.sql in it on the Github (https://github.com/Evolveum/midpoint/tree/v4.7.2/config/sql/native-new).

So, I suspect that the issue is caused due to the file being missing in the repositories.

Please resolve the above issue or let me know the way that I can resolve this.

docker-compose is also attached for the reference.

Thanks.

Kind regards,
Deshak Bhatnagar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20231110/e7ae0208/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: docker-compose.xml
Type: application/xml
Size: 1626 bytes
Desc: docker-compose.xml
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20231110/e7ae0208/attachment.xml>