search

FirebirdSQL / firebird

Firebird server, client and tools
https://firebirdsql.org
1.26k stars 217 forks source link

Problems with dbcrypt key transfer [CORE5472] #5742

Closed firebird-automations closed 3 years ago

firebird-automations commented 7 years ago

Submitted by: @AlexPeshkoff

Jira_subtask_outward CORE5442

As it was noticed by different users who started to work with database encryption: - it's impossible to use database as security database if it's encrypted and key to be passed from client - it's impossible to use execute statement on external datasource if target database is encrypted

Because the reason of this bugs is almost the same I've decided to put them in the tracker together and have single fix for them.

Commits: FirebirdSQL/firebird@93008ba8849cef925e9dee095d6cec0e9e53849f FirebirdSQL/firebird@ab2e4ea31b86bf74395d75fd46087270ff9539a2 FirebirdSQL/firebird@a9830c7856651af39e39376f49b199b8dc847485 FirebirdSQL/firebird@51accdaa705a9ce1f97091c9bf13432770e46e66 FirebirdSQL/firebird@2fdb281759299f24d47349246f3c800ec78971cc FirebirdSQL/firebird@913b312a079fc799e8cf128f6a9131709621984d FirebirdSQL/firebird@4da3997b49c8ee3e9196e315d26f90090edafff9

====== Test Details ======

Discussed with Alex 09-octy-2020. Problem did exist oin FB 3.x, but it can be reproduced only when we pass crypt key from *client*. This currently can not be done neither using FDB driver, nor with gbak of FB 3.x.

We need ability to select different client library to connect to FB (say, client-4 to connect to FB-3, etc)

firebird-automations commented 7 years ago
Modified by: @AlexPeshkoff assignee: Alexander Peshkov \[ alexpeshkoff \]
firebird-automations commented 7 years ago
Modified by: @AlexPeshkoff status: Open \[ 1 \] =\> Resolved \[ 5 \] resolution: Fixed \[ 1 \] Fix Version: 3\.0\.2 \[ 10785 \] Fix Version: 4\.0 Alpha 1 \[ 10731 \]
firebird-automations commented 7 years ago
Modified by: @pavel-zotov status: Resolved \[ 5 \] =\> Resolved \[ 5 \] QA Status: No test =\> Cannot be tested
firebird-automations commented 3 years ago
Modified by: @pavel-zotov status: Resolved \[ 5 \] =\> Resolved \[ 5 \] QA Status: Cannot be tested =\> Deferred Test Details: Discussed with Alex 09\-octy\-2020\. Problem did exist oin FB 3\.x, but it can be reproduced only when we pass crypt key from \*client\*\. This currently can not be done neither using FDB driver, nor with gbak of FB 3\.x\. We need ability to select different client library to connect to FB \(say, client\-4 to connect to FB\-3, etc\)
pavel-zotov commented 2 months ago

QA note: implementation deferred. A new problem encountered during test writing, see #8227