Sorry for not replying sooner. I was out of the office for a couple days. You can force
maintenance to run from the RHQ CLI shell. Log in and run,
StorageNodeManager.runClusterMaintenance()
That should do it. For future reference, here is what you need to do for logging into
cqlsh. The credentials are stored in rhq-server.properties in the rhq.storage.username and
rhq.storage.password properties. The password property though is encoded. You can decode
it from the RHQ CLI shell with,
org.rhq.core.util.obfuscation.Obfuscator.decode(<encoded_password>)
And there is one other thing worth noting. Setting start_rpc to true is completely fine
but somewhat inconvenient since it requires a restart of the storage node. You can also
turn on the rpc server using nodetool.
$ cd RHQ_SERVER_HOME/rhq-storage/bin
$ ./nodetool -p 7199 enablethrift
The change does not persist restarts and there is also a corresponding disablethrift
command.
On Jan 28, 2015, at 9:12 AM, TMyers(a)wellsfargo.com wrote:
Hi John,
To close the loop on this, I disabled the storage node authentication/authorization which
allowed me to execute the describe and alter statements you provided. You were correct
that the system_auth keyspace replication factor was set to 1. After altering it to 2 and
running the repair processes, I was able to get things up and running. I then re-enabled
authentication and all looks good. The UI is still reporting the Cluster Status is DOWN.
Am I correct to believe that will get corrected when the weekly maintenance runs?
Is there a way to force the maintenance schedule?
Thanks,
Tom
-----Original Message-----
From: rhq-users-bounces(a)lists.fedorahosted.org
[mailto:rhq-users-bounces@lists.fedorahosted.org] On Behalf Of TMyers(a)wellsfargo.com
Sent: Monday, January 26, 2015 1:20 PM
To: rhq-users(a)lists.fedorahosted.org
Subject: RE: RHQ storage node user/password name error
Hi John,
Thanks, I am getting closer. I was able to access the cqlsh prompt after setting
"start_rpc: true" in Cassandra.yaml However, I am not able to run the commands
below because I am not actually logged in?
InvalidRequestException(why='You have not logged in')
I can pass the -u and -p params to the cqlsh script but I'm unclear how
authentication is configured. How do I find the Cassandra username/password to use to
login?
Thanks again,
Tom
-----Original Message-----
From: rhq-users-bounces(a)lists.fedorahosted.org
[mailto:rhq-users-bounces@lists.fedorahosted.org] On Behalf Of John Sanda
Sent: Sunday, January 25, 2015 9:18 PM
To: rhq-users(a)lists.fedorahosted.org
Subject: Re: RHQ storage node user/password name error
> On Jan 25, 2015, at 8:41 PM, John Sanda <jsanda(a)redhat.com> wrote:
>
> If an error occurred while adding one of the nodes and the replication_factor failed
to get updated, then running repair won’t help. You need to log into the storage node
cluster using cqlsh to check the replication_factor with the following command,
>
> describe keyspace rhq;
>
> It should set to 2.
I made a mistake. The command should be,
describe keyspace system_auth;
And its replication_factor should be 2. You should check the rhq keyspace as well as both
should be 2. The command to change it is,
alter keyspace system_auth with replication = {‘replication_factor’: 2};
After making the change run repair first on the system_auth keyspace as you did
originally. Then run repair on the rhq keyspace. Hope that helps.
- John
_______________________________________________
rhq-users mailing list
rhq-users(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/rhq-users
_______________________________________________
rhq-users mailing list
rhq-users(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/rhq-users
_______________________________________________
rhq-users mailing list
rhq-users(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/rhq-users