<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
Hi Community,<br>
<br>
midpoint is using a keystore for passwords, the ldap and the AD
connector en-/decrypt passwords, but:<br>
<blockquote>How to en-/decrypt passwords with the <code
tabindex="0"><span class="na">DatabaseTableConnector to a </span></code>postgresql
table?<br>
</blockquote>
As a SQL sample for postgresql:<br>
<blockquote>encrypting: SELECT <code>p</code><code tabindex="0"><span
class="n">gp_sym_encrypt</span><span class="p">(cleartext_</span><span
class="n">passwort</span><span class="p">,</span><span
class="w"> </span><span class="s1">'secret-key'</span><span
class="p">)::</span><span class="nb">TEXT AS
encrypted_password;</span></code><br>
<code tabindex="0"><span class="nb"></span></code><code
tabindex="0"><span class="s2">decrypting: SELECT
pgp_sym_decrypt(</span></code><code tabindex="0"><span
class="nb">encrypted_password</span></code><code tabindex="0"><span
class="s2"></span><span class="s2">::BYTEA, '</span></code><code
tabindex="0"><span class="s1">secret-key</span></code><code
tabindex="0"><span class="s2">') AS </span></code><code
tabindex="0"><span class="p">cleartext_</span><span class="n">passwort</span><span
class="p"></span></code><code tabindex="0"><span class="s2">;</span></code><code
tabindex="0"><span class="nb"></span></code><br>
<code tabindex="0"><span class="nb"></span></code></blockquote>
<code tabindex="0"><span class="nb"><br>
D</span></code>oes anyone knows, how to encrypt passwords with
SQL in postgres and decrypt these credentials in a <code
tabindex="0"><span class="na">DatabaseTableConnector resouce?</span></code><code
tabindex="0"><span class="nb"><br>
<br>
<br>
</span></code>Kind Regards<br>
Christian<br>
<br>
</body>
</html>