<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<p class="msipheadercbcacb55" align="Left" style="margin:0"><span style="font-size:10.0pt;font-family:Calibri;color:#008000">THALES GROUP LIMITED DISTRIBUTION to email recipients
</span></p>
<br>
<div class="WordSection1">
<p class="MsoNormal">Hello Everyone!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>Midpoint| 2023-11-09 11:34:14,864 [] [main] INFO (com.evolveum.midpoint.init.ConfigurablePrismContextFactory): Loading extension schemas from folder '/opt/midpoint/var/schema'.<o:p></o:p></b></p>
<p class="MsoNormal"><b>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<o:p></o:p></b></p>
<p class="MsoNormal"><b>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]<o:p></o:p></b></p>
<p class="MsoNormal"><b>PostgreSql | 2023-11-09 11:34:31.338 UTC [56] ERROR: relation "m_acc_cert_campaign" does not exist at character 22<o:p></o:p></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>Midpoint| ERROR initializing midPoint: org.springframework.context.ApplicationContextException: Unable to start web server<o:p></o:p></b></p>
<p class="MsoNormal"><b>Midpoint| ROOT cause: com.evolveum.midpoint.util.exception.SystemException: DB script (/sql/postgresql-4.6-all.sql) couldn't be found<o:p></o:p></b></p>
<p class="MsoNormal"><b>Midpoint| See midpoint.log for more details.<o:p></o:p></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">with H2 database it works fine but with postgres its failing on version 4.8.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Courier New"">PostGres<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> <b>image: postgres:16-alpine<o:p></o:p></b></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> container_name: PostgreSql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> environment:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - POSTGRES_PASSWORD_FILE=/run/secrets/mp_database_password.txt<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - POSTGRES_USER=midpoint<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - POSTGRES_DB=midpoint<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - POSTGRES_INITDB_ARGS=--lc-collate=en_US.utf8 --lc-ctype=en_US.utf8<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Courier New"">Midpoint_Server:<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Courier New""> image: evolveum/midpoint:4.8<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> container_name: midpoint<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> depends_on:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - Midpoint_data<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> environment:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_DATABASE_TYPE=postgresql<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_HOST= midpoint<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_DATABASE=midpoint<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_USER=midpoint<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_PASSWORD_FILE=/run/secrets/mp_database_password.txt<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_MISSING_SCHEMA_ACTION=create<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_UPGRADEABLE_SCHEMA_ACTION<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_SCHEMA_VERSION_IF_MISSING<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - REPO_SCHEMA_VARIANT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - MP_KEYSTORE_PASSWORD_FILE=/run/secrets/mp_keystore_password.txt<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - MP_MEM_MAX=2048m<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - MP_MEM_INIT=1024m<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - MP_JAVA_OPTS<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Courier New""> - TZ=UTC<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you in advance !<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="mso-ligatures:none">Regards<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span lang="EN-IN" style="color:#1F497D;mso-ligatures:none">Kapil Sharma<o:p></o:p></span></b></p>
<p class="MsoNormal"><span lang="EN-IN" style="color:#1F497D;mso-ligatures:none">Technical Lead</span><span lang="EN-IN" style="font-size:10.0pt;mso-ligatures:none"><br>
<b><span style="color:gray">DIS-CPL</span></b></span><b><span lang="EN-IN" style="color:#1F497D;mso-ligatures:none"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><img width="140" height="33" style="width:1.4583in;height:.3416in" id="Picture_x0020_1" src="cid:image001.png@01DA132D.7B5958C0"></span><span style="mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>