Basic encryption
Encrypt database password
On this page
Related content
- No related content found
Basic encryption is one of the three ways to encrypt database passwords. See also, Advanced encryption and Custom encryption.
For this method, we'll use Base64Cipher, which is a way to achieve simple obfuscation of the database password.
Step 1. Encrypt the password
Go to
<Bitbucket-installation-directory>/tools/atlassian-password.Run the following command to encrypt your password:
java -cp "./*" com.atlassian.db.config.password.tools.CipherTool-- silent -s: limits logging to a minimum
-- help -h: prints a help message with all parameters
-- mode -m: defines what to do with the password, either encrypt or decrypt. If omitted, 'encrypt' will be used.
-- password -p: plain text password. If omitted, you'll be asked to enter it. We recommend that you omit this parameter so that your password is not stored in the history.
main DEBUG [db.config.password.DefaultCipherProvider] Initiate cipher provider class: com.atlassian.db.config.password.ciphers.base64.Base64Cipher
main DEBUG [password.ciphers.base64.Base64Cipher] Initiate Base64Cipher
main DEBUG [password.ciphers.base64.Base64Cipher] Encrypting data...
main DEBUG [password.ciphers.base64.Base64Cipher] Encryption done. Success!
Success!
For Jira, put the following lines in database config xml file:
<atlassian-password-cipher-provider>com.atlassian.db.config.password.ciphers.base64.Base64Cipher</atlassian-password-cipher-provider>
<password>ZGZnZGZn</password>
and restart the instance.
For Bitbucket, set the following properties in bitbucket.properties:
jdbc.password.decrypter.classname=com.atlassian.db.config.password.ciphers.base64.Base64Cipher
jdbc.password=ZGZnZGZn
and restart the instance.
Step 2. Add the encrypted password to the properties file
Go to Bitbucket home directory and back up the
bitbucket.propertiesfile. Move the backup to a safe place outside of your Bitbucket instance.In the
bitbucket.propertiesfile, replace thejdbc.passwordproperty with the password generated by CLI. Also, specify thejdbc.password.decrypter.classnameproperty. For example:jdbc.password.decrypter.classname=com.atlassian.db.config.password.ciphers.base64.Base64Cipher jdbc.password=put-the-obfuscated-password-generated-by-the-cli-tool-hereRestart Bitbucket.
Decrypting the password
To decrypt the password, extend the command with the -m decrypt parameter:
java -cp "./*" com.atlassian.db.config.password.tools.CipherTool -m decryptWhen asked for a password, provide the encrypted one from your bitbucket.properties file.
Troubleshooting
This means that Bitbucket couldn't connect to the database to access your configuration, most likely because of an error with decrypting your password.
To solve this problem, open <Bitbucket_home_directory>/log/atlassian-bitbucket.log, and check for DataSourcePasswordDecryptionException. For example:
com.atlassian.stash.internal.jdbc.DataSourcePasswordDecryptionException: java.lang.IllegalArgumentException: Illegal base64 character 25The exception contains details about the error. If the error is java.lang.IllegalArgumentException, you will need to encrypt the password again.
To investigate this problem, open <Bitbucket_home_directory>/log/atlassian-bitbucket.log, and check for JdbcSQLExceptions. The messages should be pretty clear as to what went wrong.
You’ll probably see the following messages:
Wrong user name or password [28000-176]This means that Bitbucket decrypted the password successfully, but the password itself is incorrect. You can verify that by completing these steps:
Open the bitbucket.properties file, and copy the encrypted password.
Check if the decrypted password is the same as the one in your backup bitbucket.properties file.
To disable database password encryption, remove the jdbc.password.decrypter.classname property from the bitbucket.properties file, and change the value of jdbc.password to the unencrypted in your backup.
Related content
- No related content found