[
https://issues.apache.org/jira/browse/DERBY-5969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13486219#comment-13486219
]
Rick Hillegas commented on DERBY-5969:
--------------------------------------
The following script shows this problem:
connect
'jdbc:derby:db;create=true;user=test_dbo;dataEncryption=true;bootPassword=foobarwibblewombat';
call syscs_util.syscs_create_user( 'test_dbo', 'test_dbopassword' );
call syscs_util.syscs_create_user( 'fred', 'fredpassword' );
-- shutdown the database
connect 'jdbc:derby:db;shutdown=true';
-- let another user boot the database
connect
'jdbc:derby:db;user=fred;password=fredpassword;bootPassword=foobarwibblewombat';
-- the following attempt to decrypt the database appears to work
-- but actually fails.
connect
'jdbc:derby:db;user=test_dbo;password=test_dbopassword;bootPassword=foobarwibblewombat;decryptDatabase=true';
-- shutdown the database
connect 'jdbc:derby:db;shutdown=true;user=test_dbo;password=test_dbopassword';
-- this demonstrates that the unencryption failed
connect 'jdbc:derby:db;user=test_dbo;password=test_dbopassword';
> Re-encryption and un-encryption silently fail if the database is already
> booted.
> --------------------------------------------------------------------------------
>
> Key: DERBY-5969
> URL: https://issues.apache.org/jira/browse/DERBY-5969
> Project: Derby
> Issue Type: Bug
> Components: Services
> Affects Versions: 10.10.0.0
> Reporter: Rick Hillegas
>
> If the database is already booted, then the DBO's attempt to re-encrypt or
> un-encrypt the database will silently fail. It will appear to the DBO that
> the re(un)encryption succeeded but in fact the database will not be changed.
> Derby should raise an error if the database is already booted when the DBO
> attempts re(un)encryption.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
