mchou Software, Support, and Training for Apache Cassandra en-US Sun, 19 May 2013 00:46:26 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/how-to-invoke-cql3-in-windows-7#post-9308 Mon, 04 Mar 2013 23:48:36 +0000 nickmbailey 9308@http://www.datastax.com/support-forums/ <p>The cqlsh version appears correct on our end. Perhaps you are confusing the cqlsh version (2.3.0) with the CQL version (3.0)? </p> http://www.datastax.com/support-forums/topic/how-to-invoke-cql3-in-windows-7#post-9305 Mon, 04 Mar 2013 21:51:31 +0000 nickmbailey 9305@http://www.datastax.com/support-forums/ <p>The correct option to specify cql 3 is '-3'. So running 'python cqlsh -3' should work. The default version should be cql3 though. I'll look into why that might not be the case. </p> http://www.datastax.com/support-forums/topic/how-to-invoke-cql3-in-windows-7#post-9158 Sat, 23 Feb 2013 23:27:25 +0000 mchou 9158@http://www.datastax.com/support-forums/ <p>I use Community Edition 1.2.1 in Windows 7 64-bit. It seems the default version of cql is 2 (I thought is 3). Based on the documentation ..."To start CQLsh using the CQL 3 Specification on Windows, for example, in Command Prompt navigate to the bin directory and enter this command: python cqlsh -cql3" When I did that, I got error -&gt; cqlsh: error: no such option: -c</p> <p>Any suggestions? Thanks. </p> http://www.datastax.com/support-forums/topic/failed-to-connect-to-localhost7199-in-community-edition-117-nodetool-h-localhost-ring#post-8247 Mon, 31 Dec 2012 17:42:18 +0000 nickmbailey 8247@http://www.datastax.com/support-forums/ <p>A couple of questions:</p> <p>1) You are certain the cassandra process is running? Can you connect to thrift with the cli or cqlsh?<br /> 2) Do you have a firewall or anything that might be blocking port 7199? Can you connect to port 7199 with something like telnet? (I don't know what the windows equivalent of telnet is)</p> <p>Also, the cassandra-env.sh script is only used on unix systems, so that won't have any effect here. </p> http://www.datastax.com/support-forums/topic/failed-to-connect-to-localhost7199-in-community-edition-117-nodetool-h-localhost-ring#post-8235 Mon, 31 Dec 2012 05:43:27 +0000 mchou 8235@http://www.datastax.com/support-forums/ <p>I am using the Community Edition 1.1.7 (currently on the website download) on Windows 7 64-bit. I get "Failed to connect to Localhost:7199 Connection refused" when I run "nodetool -h localhost ring". Looking at different blogs, most of people complained this problem happened in 1.1.3 but OK in 1.1.2. Even someone offered to get around in 1.1.3 by editing the cassandra-env.sh on line 180. It seems the cassandra-env.sh in 1.1.7 has the fix. So, why is not working in 1.1.7? Any suggestions? </p> http://www.datastax.com/support-forums/topic/install-a-cassandra-cluster-on-amazon-ec2#post-8230 Mon, 31 Dec 2012 02:17:05 +0000 joaquin 8230@http://www.datastax.com/support-forums/ <p>It's installed via the packages and should be linked to /usr/bin. Simply run <code>cqlsh</code> and you should be good to go.</p> <p>Thanks,<br /> Joaquin </p> http://www.datastax.com/support-forums/topic/install-a-cassandra-cluster-on-amazon-ec2#post-8202 Sat, 29 Dec 2012 05:15:17 +0000 mchou 8202@http://www.datastax.com/support-forums/ <p>Hi Joaquin,</p> <p>Thank you for your quick reply. I redo it and it works. I can use CLI. I can use OpsCenter. I have one more question. How to invoke CQL? I follow the documentation, both ./cqlsh and ./cqlsh --cql3 not found. Where is cql? Any suggestions?</p> <p>Regards,</p> <p>Marco </p> http://www.datastax.com/support-forums/topic/install-a-cassandra-cluster-on-amazon-ec2#post-8198 Fri, 28 Dec 2012 17:42:50 +0000 joaquin 8198@http://www.datastax.com/support-forums/ <p>Hello Marco,</p> <p>Could you attach your ~/datastax_ami/ami.log? This will let us track down the current issue.</p> <p>Also, if you take a look at the "message of the day" when you ssh in, it should alert you that there have been errors. Most times it does a good job of letting you know what's wrong.</p> <p>Thanks,<br /> Joaquin </p> http://www.datastax.com/support-forums/topic/install-a-cassandra-cluster-on-amazon-ec2#post-8196 Fri, 28 Dec 2012 16:08:27 +0000 mchou 8196@http://www.datastax.com/support-forums/ <p>I follow Cassandra 1.1 documentation (p.29-37) to install a Cassandra Cluster on Amazon EC2. I choose ami-814ec2e8 (datastax-us-east-1/datastax-clustering-ami-2.4.ma*) from AWS Community AMIs. Everything goes well until I SSH to the 1st node and issue the command "nodetool ring -h localhost". The error message is "nodetool: command not found". </p> <p>Q#1: Did I choose the correct AMI?<br /> Q#2: Do I need to load/install anything else?<br /> Q#3: Is there an existing AMI for a single node cluster if I just want to play with cli and cql?</p> <p>Thanks.</p> <p>Marco </p> http://www.datastax.com/support-forums/topic/cant-start-community_server-service-after-modify-cassandrayaml#post-8168 Fri, 28 Dec 2012 03:22:36 +0000 mchou 8168@http://www.datastax.com/support-forums/ <p>Hi Nick,</p> <p>Thank you for your quick reply. The document is very helpful. So, I am able to start the Community_Server on node0 and also start it on node1 (a VM-based Windows7 64-bit).</p> <p>Now, I run into another error when I use "nodetool –h localhost ring" to show the cluster. The error message is "Starting NodeTool<br /> Failed to connect to '127.0.0.1:7199': Connection refused: connect". I double check the 7199 port, it is open on both nodes. Both node0 and node1 have the same IP address - 98.253.35.86. Any suggestions? Thanks.</p> <p>Regards,</p> <p>Marco </p> http://www.datastax.com/support-forums/topic/0-of-2-agents-connected/page/2#post-8165 Thu, 27 Dec 2012 18:16:15 +0000 nickmbailey 8165@http://www.datastax.com/support-forums/ <p>That is a known bug at the moment. Manually killing the java process should stop the service. Sorry for the inconvenience. </p> http://www.datastax.com/support-forums/topic/cant-start-community_server-service-after-modify-cassandrayaml#post-8163 Thu, 27 Dec 2012 18:12:36 +0000 nickmbailey 8163@http://www.datastax.com/support-forums/ <p>Can you post the full cassandra.yaml you are using? You may have a problem with the seed configuration. An example is located here in the docs:</p> <p><a href="http://www.datastax.com/docs/1.1/initialize/cluster_init" rel="nofollow">http://www.datastax.com/docs/1.1/initialize/cluster_init</a> </p> http://www.datastax.com/support-forums/topic/cant-start-community_server-service-after-modify-cassandrayaml#post-8160 Thu, 27 Dec 2012 17:08:48 +0000 mchou 8160@http://www.datastax.com/support-forums/ <p>I am using Windows 7 64bit with Cassandra Community Server V1.1.6. I follow Robin Schumacher's article "How to Setup and Monitor a Multi-Node Cassandra Cluster on Windows" to set up a 2-node cluster. After I update the Cassandra.yaml on the 1st node as follows:</p> <p>initial_token: 0<br /> listen_address: localhost<br /> seeds: “98.253.35.86”</p> <p>Then I restart the Community_Server service and get the following error message in the log: (Even I change the cluster name to something different). Any help is appreciated.</p> <p>INFO [main] 2012-12-27 10:53:58,293 AbstractCassandraDaemon.java (line 101) Logging initialized<br /> INFO [main] 2012-12-27 10:53:58,304 AbstractCassandraDaemon.java (line 122) JVM vendor/version: Java HotSpot(TM) 64-Bit Server VM/1.6.0_29<br /> INFO [main] 2012-12-27 10:53:58,305 AbstractCassandraDaemon.java (line 123) Heap size: 1065025536/1065025536<br /> INFO [main] 2012-12-27 10:53:58,305 AbstractCassandraDaemon.java (line 124) Classpath: C:\Program Files (x86)\DataStax Community\apache-cassandra\conf;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\antlr-3.2.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\apache-cassandra-1.1.6.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\apache-cassandra-clientutil-1.1.6.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\apache-cassandra-thrift-1.1.6.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\avro-1.4.0-fixes.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\avro-1.4.0-sources-fixes.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\commons-cli-1.1.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\commons-codec-1.2.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\commons-lang-2.4.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\compress-lzf-0.8.4.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\concurrentlinkedhashmap-lru-1.3.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\guava-r08.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\high-scale-lib-1.1.2.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\jackson-core-asl-1.9.2.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\jackson-mapper-asl-1.9.2.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\jamm-0.2.5.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\jline-0.9.94.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\json-simple-1.1.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\libthrift-0.7.0.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\log4j-1.2.16.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\metrics-core-2.0.3.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\servlet-api-2.5-20081211.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\slf4j-api-1.6.1.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\slf4j-log4j12-1.6.1.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\snakeyaml-1.6.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\snappy-java-1.0.4.1.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\snaptree-0.1.jar;C:\Program Files (x86)\DataStax Community\apache-cassandra\build\classes\main;C:\Program Files (x86)\DataStax Community\apache-cassandra\build\classes\thrift;C:\Program Files (x86)\DataStax Community\apache-cassandra\lib\jamm-0.2.5.jar<br /> INFO [main] 2012-12-27 10:53:58,309 CLibrary.java (line 62) JNA not found. Native methods will be disabled.<br /> INFO [main] 2012-12-27 10:53:58,324 DatabaseDescriptor.java (line 124) Loading settings from file:/C:/Program%20Files%20(x86)/DataStax%20Community/apache-cassandra/conf/cassandra.yaml<br /> ERROR [main] 2012-12-27 10:53:58,487 DatabaseDescriptor.java (line 486) Fatal configuration error error<br /> Can't construct a java object for tag:yaml.org,2002:org.apache.cassandra.config.Config; exception=Cannot create property=seed_provider for JavaBean=org.apache.cassandra.config.Config@4dd36dfe; java.lang.reflect.InvocationTargetException<br /> in "&lt;reader&gt;", line 8, column 1:<br /> cluster_name: 'Test Cluster'<br /> ^</p> <p> at org.yaml.snakeyaml.constructor.Constructor$ConstructYamlObject.construct(Constructor.java:372) </p> http://www.datastax.com/support-forums/topic/0-of-2-agents-connected/page/2#post-8158 Thu, 27 Dec 2012 15:09:20 +0000 mchou 8158@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>I follow Robin Schumacher's article "How to Setup and Monitor a Multi-Node Cassandra Cluster on Windows" on Winodows 7. I got an error message when I stop the Ops_Center_Agent service - "Windows could not stop the DataStax_OpsCenter_Agent service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion." </p> <p>I reboot my laptop and try again, the same error message. I have no trouble to stop the other two DataStax service. Any suggestions?</p> <p>Regards,</p> <p>Marco </p> http://www.datastax.com/support-forums/topic/0-of-2-agents-connected#post-6413 Tue, 11 Sep 2012 15:23:41 +0000 nickmbailey 6413@http://www.datastax.com/support-forums/ <p>That error in the log means it can not connect to the agent on that machine. It shouldn't affect the UI however.</p> <p>Did you change the 'interface' property in the opscenter conf file? You will need to update that to be '0.0.0.0' or '&lt;ip of machine&gt;' before you can access the web interface from an external host. </p>