db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4328) The Developer's Guide falsely claims that you can use SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY to change the boot password on an encrypted database.
Date Tue, 18 Aug 2009 15:29:29 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12744553#action_12744553
] 

Knut Anders Hatlen commented on DERBY-4328:
-------------------------------------------

My problem with (1) is that it would leave some functionality undocumented, and the code will
probably live forever because no one understands why it's there. If we choose (1) I feel that
we should also remove the code that implements it, but that could cause backward compatibility
issues.

You mentioned that the alternative way to change the boot password may also have escaping
issues, so I don't quite see why one should be left in the documentation and the other one
removed.

Changing the password by using the newBootPassword attribute requires that the database is
not booted. Doesn't that make it vulnerable to race conditions if others connect the database
while we're attempting to change the boot password? In that case using the set-property method
might be preferable.

> The Developer's Guide falsely claims that you can use SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY
to change the boot password on an encrypted database.
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4328
>                 URL: https://issues.apache.org/jira/browse/DERBY-4328
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>             Fix For: 10.5.3.0
>
>         Attachments: derby-4328-01-aa-removeFalseReencryptionClaim.diff
>
>
> This claim is made in the section titled 'Changing the boot password'. If you try to
run the example, you get this error:
> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'bootPassword', 'Thursday' , 'Saturday');
> ERROR 42Y03: 'SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY' is not recognized as a function
or procedure.
> The correct way to change the boot password is documented earlier on in the section titled
'Encrypting databases with a new boot password'. We should remove the section titled 'Changing
the boot password'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message