I've been going through the 4.8 to 4.9 upgrade with varying success.
First, Never saw a mention of python 2.5+ as a requirement and it appears
to be. This install is on a CentOS 5.8 server which didn't have it in the
base yum repo. Added 2.6 via EPEL. Might want to note that.
I believe RHQ 4.9 still supports java 6, but the 4.8 tool appears to
require java 7. I got version mismatch errors.
Exception in thread "main" java.lang.UnsupportedClassVersionError:
org/apache/cassandra/tools/NodeCmd : Unsupported major.minor version 51.0
Solved with install of JDK 1.7
Now I get the following. Any direction on how to solve the Bad Request?
--------------------------
Running CQL script to disable table compression
./disable_compression.cql:9:Bad Request: Cannot ALTER <table
system_auth.credentials>
./disable_compression.cql:9:text could not be lexed at line 1, char 56
./disable_compression.cql:10:Bad Request: Cannot ALTER <table
system_auth.permissions>
./disable_compression.cql:10:text could not be lexed at line 1, char 56
./disable_compression.cql:11:Bad Request: Cannot ALTER <table
system_auth.users>
./disable_compression.cql:11:text could not be lexed at line 1, char 50
./disable_compression.cql:12:Bad Request: Cannot ALTER <table
system_auth.users>
./disable_compression.cql:12:text could not be lexed at line 1, char 50
./disable_compression.cql:14:Bad Request: system_traces keyspace is not
user-modifiable.
./disable_compression.cql:14:text could not be lexed at line 1, char 53
./disable_compression.cql:15:Bad Request: system_traces keyspace is not
user-modifiable.
./disable_compression.cql:15:text could not be lexed at line 1, char 55
./disable_compression.cql:16:Bad Request: system_traces keyspace is not
user-modifiable.
./disable_compression.cql:16:text could not be lexed at line 1, char 55
./disable_compression.cql:18:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:18:text could not be lexed at line 1, char 20
./disable_compression.cql:19:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:19:text could not be lexed at line 1, char 20
./disable_compression.cql:20:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:20:text could not be lexed at line 1, char 20
./disable_compression.cql:21:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:21:text could not be lexed at line 1, char 20
./disable_compression.cql:22:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:22:text could not be lexed at line 1, char 20
./disable_compression.cql:23:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:23:text could not be lexed at line 1, char 20
./disable_compression.cql:24:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:24:text could not be lexed at line 1, char 48
./disable_compression.cql:25:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:25:text could not be lexed at line 1, char 45
./disable_compression.cql:26:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:26:text could not be lexed at line 1, char 45
./disable_compression.cql:27:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:27:text could not be lexed at line 1, char 51
./disable_compression.cql:28:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:28:text could not be lexed at line 1, char 45
./disable_compression.cql:29:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:29:text could not be lexed at line 1, char 51
./disable_compression.cql:30:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:30:text could not be lexed at line 1, char 61
./disable_compression.cql:31:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:31:text could not be lexed at line 1, char 54
./disable_compression.cql:32:Bad Request: system keyspace is not
user-modifiable.
./disable_compression.cql:32:text could not be lexed at line 1, char 56
Rebuilding data files for system keyspace
Rebuilding data files for system_traces keyspace
Rebuilding data files for system_auth keyspace
Rebuilding data files for rhq keycap
Shutting down the RHQ Storage node
23:20:15,030 INFO [org.jboss.modules] JBoss Modules version 1.2.0.CR1
Stopping RHQ storage node...
RHQ storage node (pid=11287) is stopping...
kill 11287: No such process
23:20:16,598 ERROR [org.rhq.server.control.RHQControl] Failed to stop
services [Cause: org.apache.commons.exec.ExecuteException: Process exited
with an error: 1 (Exit value: 1)]
Removing patch file
Table compression has been disabled for all keyspaces. You are now ready
to upgrade your RHQ installation.