Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p8IcO-0008SI-NA for pgsql-general@arkaria.postgresql.org; Thu, 22 Dec 2022 10:16:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p8IcN-0002UF-AU for pgsql-general@arkaria.postgresql.org; Thu, 22 Dec 2022 10:16:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p8IcM-0002U6-Vl for pgsql-general@lists.postgresql.org; Thu, 22 Dec 2022 10:16:02 +0000 Received: from connect.ultra-secure.de ([88.198.71.201]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p8IcK-0002kn-Uf for pgsql-general@lists.postgresql.org; Thu, 22 Dec 2022 10:16:02 +0000 Received: (Haraka outbound); Thu, 22 Dec 2022 11:16:00 +0100 Authentication-Results: connect.ultra-secure.de; auth=pass (plain); spf=softfail smtp.mailfrom=ultra-secure.de Received-SPF: SoftFail (connect.ultra-secure.de: domain of ultra-secure.de does not designate 212.71.103.5 as permitted sender) receiver=connect.ultra-secure.de; identity=mailfrom; client-ip=212.71.103.5; helo=smtpclient.apple; envelope-from= Received-SPF: None (connect.ultra-secure.de: domain of smtpclient.apple does not designate 212.71.103.5 as permitted sender) receiver=connect.ultra-secure.de; identity=helo; client-ip=212.71.103.5; helo=smtpclient.apple; envelope-from= Received: from smtpclient.apple ([212.71.103.5]) by connect.ultra-secure.de (Haraka/2.6.2-toaster) with ESMTPSA id 5E2AE5A7-94B4-431A-A9CC-ADBF3F6936AA.1 envelope-from (authenticated bits=0) (version=TLSv1/SSLv3 cipher=AES256-GCM-SHA384 verify=NO); Thu, 22 Dec 2022 11:15:58 +0100 From: Rainer Duffner Message-Id: <08F69776-6702-41F4-ACA5-CABF74CFE115@ultra-secure.de> Content-Type: multipart/alternative; boundary="Apple-Mail=_9483EA4C-E515-42D3-AF5F-CEA8F42B7F99" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.1\)) Subject: Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration Date: Thu, 22 Dec 2022 11:15:57 +0100 In-Reply-To: <20221222094622.y26t5reutijwnlop@hjp.at> Cc: pgsql-general@lists.postgresql.org To: "Peter J. Holzer" References: <285552b7273f57396398e5f7c538c7c4be60dce7.camel@cybertec.at> <69C40063-CF22-44FE-958A-74845CFBB039@ultra-secure.de> <8a66ead5-5463-11ed-e3d8-4d5962f81c36@gmail.com> <807557F0-F4F0-496A-B4B6-B043F8408A5B@ultra-secure.de> <20221222094622.y26t5reutijwnlop@hjp.at> X-Mailer: Apple Mail (2.3696.120.41.1.1) X-Haraka-GeoIP: EU, CH, 451km X-Haraka-ASN: 24951 X-Haraka-GeoIP-Received: 212.71.103.5:CH X-Haraka-ASN: 24951 212.71.96.0/20 X-Haraka-ASN-CYMRU: asn=24951 net=212.71.96.0/20 country=CH assignor=ripencc date=1999-11-18 X-Haraka-p0f: os="Mac OS X " link_type="DSL" distance=13 total_conn=6 shared_ip=N X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on spamassassin X-Spam-Level: X-Spam-Status: No, score=-2.2 required=5.0 tests=ALL_TRUSTED,BAYES_00, HTML_MESSAGE,SPF_HELO_NONE,SPF_SOFTFAIL,URIBL_BLOCKED autolearn=no autolearn_force=no version=3.4.1 X-Haraka-Karma: score: 6, good: 1039, bad: 0, connections: 1153, history: 1039, asn_score: 470, asn_connections: 524, asn_good: 470, asn_bad: 0, pass:all_good, asn, asn_all_good, relaying List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_9483EA4C-E515-42D3-AF5F-CEA8F42B7F99 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > Am 22.12.2022 um 10:46 schrieb Peter J. Holzer : >=20 > If the hacker has root access: What prevents them from talking to the > HSM? I wasn=E2=80=99t involved in setting it up here, but AFAIK you need to = =E2=80=9Eenroll=E2=80=9C the client to the HSM. That is a one-time process that requires HSM credentials (via = certificates and pass-phrases). Then, that client can talk to the HSM.=20 The HSM-client is (or should be) engineered in such a way that you = can=E2=80=99t extract the encryption-secret easily. I am not sure, but IIRC, you should not even be able to clone the VM = without the HSM noticing or the clone not working at all to begin with = (for lack of enrollment). Though most production databases are too large = to just =E2=80=9Eclone=E2=80=9C. Maybe someone who knows more about this subject can chime in before I = make a fool of myself? ;-) Rainer= --Apple-Mail=_9483EA4C-E515-42D3-AF5F-CEA8F42B7F99 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

Am 22.12.2022 um 10:46 schrieb Peter J. Holzer <hjp-pgsql@hjp.at>:

If the hacker has root access: = What prevents them from talking to the
HSM?


I wasn=E2=80=99t = involved in setting it up here, but AFAIK you need to =E2=80=9Eenroll=E2=80= =9C the client to the HSM.

That is a one-time process that requires HSM credentials (via = certificates and pass-phrases).

Then, that client can talk to the = HSM. 

The = HSM-client is (or should be) engineered in such a way that you can=E2=80=99= t extract the encryption-secret easily.

I am not sure, but IIRC, you should not = even be able to clone the VM without the HSM noticing or the clone not = working at all to begin with (for lack of enrollment). Though most = production databases are too large to just =E2=80=9Eclone=E2=80=9C.
<= div class=3D"">
Maybe someone who = knows more about this subject can chime in before I make a fool of = myself?
;-)




Rainer
= --Apple-Mail=_9483EA4C-E515-42D3-AF5F-CEA8F42B7F99--