<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style id="signatureStyle" type="text/css"><!--#xd29971e78054461 #x1f5def6457d14b1382ebca278d1ea825, #xd29971e78054461
{font-family: Tahoma; font-size: 12pt;}
--></style><style id="css_styles" type="text/css"><!--blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc }
blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding-top: 0px; }
a img { border: 0px; }
li[style='text-align: center;'], li[style='text-align: center; '], li[style='text-align: right;'], li[style='text-align: right; '] { list-style-position: inside;}
body { font-family: 'Segoe UI'; font-size: 12pt; }
.quote { margin-left: 1em; margin-right: 1em; border-left: 5px #ebebeb solid; padding-left: 0.3em; }
--></style>
</head>
<body>
<div>Hi,</div>
<div>use documentation on <a href="https://docs.evolveum.com/midpoint/reference/support-4.8/repository/configuration/" style="font-size: 12pt;">https://docs.evolveum.com/midpoint/reference/support-4.8/repository/configuration/</a> and linked doc on <a href="https://jdbc.postgresql.org/documentation/use/" style="font-size: 12pt;">https://jdbc.postgresql.org/documentation/use/</a></div>
<div><br>
</div>
<div>The keyword is <span><b><servername></b></span><span> in Your URL </span><span><jdbcUrl>jdbc:postgresql://<servername>:5432/midpoint</jdbcUrl></span></div>
<div id="xe6778784b9004131a76cb3c72890f8e1">
<div style="background-color:rgba(0,0,0,0);margin:0px;"></div>
</div>
<div>Use Your real servername (or host or hostname).</div>
<div>The same configuration has every Postgresql client.</div>
<div id="signature_old" style="clear:both">
<div id="xd29971e78054461">
<div style="">
<div id="x1f5def6457d14b1382ebca278d1ea825"><br>
</div>
<div id="x1f5def6457d14b1382ebca278d1ea825">Regards</div>
<div>
<div data-mce-style="font-family: Arial, sans-serif; font-size: 13px;" style="font-variant-ligatures: normal; orphans: 2; widows: 2; font-family: Arial, sans-serif; font-size: 13px;">
<p><strong>Roman Pudil</strong> <br>
<span data-mce-style="font-family: Arial, sans-serif; font-size: 11px; color: #808080;" style="font-size: 11px; color: rgb(128, 128, 128);">solution architect</span>
</p>
</div>
<p data-mce-style="font-family: Arial, sans-serif; font-size: 11px;" style="font-variant-ligatures: normal; orphans: 2; widows: 2; font-family: Arial, sans-serif; font-size: 11px;">
gsm: [+420] 775 663 666<br>
e‑mail: <a href="mailto:roman.pudil@ami.cz">roman.pudil@ami.cz</a> </p>
<p data-mce-style="font-family: Arial, sans-serif; font-size: 11px;" style="font-variant-ligatures: normal; font-size: 11px; font-family: Arial, sans-serif; widows: 2; orphans: 2;">
<strong>AMI Praha a.s.</strong> <br>
Pernerova 697/35, 186 00 Praha 8</p>
<p data-mce-style="font-family: Arial, sans-serif; font-size: 11px;" style="font-variant-ligatures: normal; font-size: 11px; font-family: Arial, sans-serif; widows: 2; orphans: 2;">
recepce: [+420] 604 444 848 | web: <a href="https://www.ami.cz/" data-mce-href="https://www.ami.cz" style="">www.ami.cz</a>
</p>
<p data-mce-style="margin-top: 20px;" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; font-variant-ligatures: normal; orphans: 2; widows: 2; margin-top: 20px;">
<img src="https://www.ami.cz/images/podpis/ami-logo.png" alt="AMI Praha a.s." data-mce-src="https://www.ami.cz/images/podpis/ami-logo.png" style="border: 0px; cursor: default;">
</p>
<p data-mce-style="font-family: Arial, sans-serif; font-size: 11px; color: #aaaaaa;" style="font-variant-ligatures: normal; orphans: 2; widows: 2; font-family: Arial, sans-serif; font-size: 11px; color: rgb(170, 170, 170);">
Textem tohoto e‑mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>
jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.<br>
<span data-mce-style="font-size: 6px;" style="font-size: 6px;"> </span> <br>
Tento e‑mail je určen výhradně pro potřeby jeho adresáta/ů a může obsahovat důvěrné nebo osobní<br>
informace. Nejste‑li zamýšleným příjemcem, je zakázáno jakékoliv zveřejňování, zprostředkování<br>
nebo jiné použití těchto informací. Pokud jste obdrželi e‑mail neoprávněně, informujte o tom prosím<br>
odesílatele a vymažte neprodleně všechny kopie tohoto e‑mailu včetně všech jeho příloh. Nakládáním<br>
s neoprávněně získanými informacemi se vystavujete riziku právního postihu.</p>
</div>
</div>
</div>
</div>
<div style="clear:both"><br>
</div>
<div><br>
</div>
<div>
<div>------ Původní zpráva ------</div>
<div>Od "Nadim El-Khoury via midPoint" <<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a>></div>
<div>Komu "<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a>" <<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a>></div>
<div>Kopie "Nadim El-Khoury" <<a href="mailto:nel-khoury@springfield.edu">nel-khoury@springfield.edu</a>></div>
<div>Datum 11.12.2023 18:18:34</div>
<div>Předmět [midPoint] Configuring midPoint to connect to external Postgresql database</div>
</div>
<div><br>
</div>
<div id="x77575a5edda4468">
<blockquote cite="CADoGsS7Uh0T9xaiMX+DPTCTDCrRi==ce1sZi8GWr2c0hM2c6wg@mail.gmail.com" type="cite" class="cite2">
<div dir="ltr">Hi Everyone,
<div><br>
</div>
<div>All of the sample configurations for midPoint point to a database server that is running on the same server where midPoint is installed.</div>
<div><br>
</div>
<div>We already have a Postgresql server running on another server. We want to configure mdiPoint to point to that server and for the connection to be over SSL.</div>
<div><br>
</div>
<div>Has anyone configured midPoint to connect to an external Postgresql database server?</div>
<div><br>
</div>
<div>Is it a matter of changing the following line in the config.xml file? How do you specify SSL connections?</div>
<div><br>
</div>
<div><jdbcUrl>jdbc:postgresql://<servername>:5432/midpoint</jdbcUrl></div>
<div><br>
</div>
<div>I really appreciate your help.</div>
<div><br>
</div>
<div>Best,</div>
<div><br>
</div>
<div>Nadim El-Khoury</div>
<div>Director of Networks, Systems, Infrastructure, and CISO</div>
<div>Springfield College</div>
<div>263 Alden Street</div>
<div>Springfield, MA 01109</div>
<div>
<div><br>
</div>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr"><font color="#000000" face="Helvetica Neue, Helvetica, Arial, sans-serif">"</font><span style="color:rgba(0,0,0,0.9);font-family:"Source Serif Pro",serif">I’ve learned that people will forget what you said, people will forget what you did, but
people will never forget how you made them feel." </span><span style="color:rgba(0,0,0,0.9);font-family:"Source Serif Pro",serif">Maya Angelou</span></div>
</div>
</div>
</div>
</blockquote>
</div>
</body>
</html>