Bug 976814 - Cassandra username/password cannot be customized
Summary: Cassandra username/password cannot be customized
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Installer
Version: 4.8
Hardware: Unspecified
OS: Unspecified
urgent
unspecified
Target Milestone: GA
: RHQ 4.9
Assignee: Stefan Negrea
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On:
Blocks: 951619
TreeView+ depends on / blocked
 
Reported: 2013-06-21 14:15 UTC by John Sanda
Modified: 2013-10-03 14:28 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2013-09-24 19:09:00 UTC
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1015156 0 unspecified NEW Confusing description of rhq.storage.username property in rhq-server.properties file 2022-03-31 04:28:11 UTC

Internal Links: 1015156

Description John Sanda 2013-06-21 14:15:56 UTC
Description of problem:
When the RHQ server installer runs, it creates and/or applies schema updates to the relational database as well as to Cassandra. For Cassandra, one of the first steps involves creating a user (in Cassandra) that the RHQ server will use to authenticate against Cassandra. The username/password for that user are specified by the rhq.cassandra.username and rhq.cassandra.password properties in rhq-server.properties.

The Cassandra schema installation code is using a hard coded value of rhqadmin for both the username and password; consequently, the rhq.cassandra.username and rhq.cassandra.password properties cannot be changed. If the user changes either of those from the default values, then the server will not be able to authenticate against Cassandra and server initialization will subsequently fail.

Following some manual steps the password can be changed after installation. I am going to try to provide a script as well to automate the process until this issue is resolved. Note that these steps are for changing the password only.

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 John Sanda 2013-07-09 13:56:38 UTC
We probably want to support password obfuscation like we do for the oracle/postgres password.

Comment 2 John Sanda 2013-08-08 19:30:27 UTC
Stefan,

I know that you have already done work on this. Can you make sure we support password obfuscation as we do with the relational database password? And can you also write up some docs for what users will need to do to set and update the password.

Thanks

Comment 3 Stefan Negrea 2013-08-30 21:22:27 UTC
The work has been completed for this BZ. The password and username for the storage nodes can be changed before the initial setup. Also, the password is required to be obfuscated in the rhq-server.properties file. 

The properties names for the storage cluster have also been changed to rhq.storage.*

Comment 4 Stefan Negrea 2013-08-30 21:23:59 UTC
An important note, the password and username for the storage cluster can be changed before the installer runs. There is still no automated way of changing this after the installer runs, this has to be done manually.

Comment 5 Filip Brychta 2013-09-02 11:47:08 UTC
Verified on 
Version: 4.9.0-SNAPSHOT
Build Number: a9245fd

Verified that storage user/password were changed according to rhq-server.properties on the local storage node as well as on the remote storage node which was deployed after the server installation.

Comment 6 Heiko W. Rupp 2013-09-24 19:09:00 UTC
Bulk closing of RHQ 4.9 verified items


Note You need to log in before you can comment on or make changes to this bug.