DataStax Support Forums » Tag: Python

DataStax Support Forums » Tag: Python - Recent Posts http://www.datastax.com/support-forums/tags/python Software, Support, and Training for Apache Cassandra en-US Sat, 25 May 2013 09:49:28 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php thobbs on "Cannot get programs to connect to Cassandra (Community Ed)" http://www.datastax.com/support-forums/topic/cannot-get-programs-to-connect-to-cassandra-community-ed#post-5796 Fri, 10 Aug 2012 18:29:52 +0000 thobbs 5796@http://www.datastax.com/support-forums/ I'm not familiar with RCassandra, but you might be connecting to the wrong port. By default, clients should connect to port 9160. Did you have any luck with FluentCassandra? ChrisSwan on "Cannot get programs to connect to Cassandra (Community Ed)" http://www.datastax.com/support-forums/topic/cannot-get-programs-to-connect-to-cassandra-community-ed#post-4928 Fri, 03 Aug 2012 06:12:14 +0000 ChrisSwan 4928@http://www.datastax.com/support-forums/ Hi all, I've installed Cassandra Community Edition for windows (which was blissfully easy), have the Ops Center running, and with the CQL shell I've created a keyspace, columnFamily and some test data. I then wanted to try testing it using Python, downloaded CQL-python driver, and edited the py script to be the right connection details. However when I run this python script it hangs - I get the 'not responding' message and eventually have to kill the Python process. Next up I tried connecting using RCassandra to look at the data via R. Running: <code>conn = RC.connect('127.0.0.1', 8888)</code> seems fine (at least gives no errors), but then calling: <code>RC.cluster.name(conn)</code> also causes R to not respond and I have to kill the process. You can probably tell I'm a complete n00b to Cassandra, but I seem to be getting a common theme here when trying to do anything beyond establishing a connection from anything external. Any ideas what could be happening? Checking the Ops Center events log shows nothing untoward, I don't have any software firewalls running and the port Cassandra is on is clear. I'll have a go at connecting via fluentcassandra next and see what that does... Thanks in advance! nickmbailey on "Datastax Windows install hijacks Java and Python" http://www.datastax.com/support-forums/topic/datastax-windows-install-hijacks-java-and-python#post-4799 Thu, 02 Aug 2012 20:06:49 +0000 nickmbailey 4799@http://www.datastax.com/support-forums/ Marek, We appreciate the feedback. All of the points you bring up are valid, and we have plans to have the installer address them in the future. Regarding a workaround, unfortunately there is no way to prevent the installer from modifying those environment variables. You shoud however, be able to revert the changes made there, and still have OpsCenter work, if a few modifications are made to the opscenter start up scripts. We will verify what changes need to be made and that everything works correctly in that situation and get back to you soon. -Nick marek on "Datastax Windows install hijacks Java and Python" http://www.datastax.com/support-forums/topic/datastax-windows-install-hijacks-java-and-python#post-4380 Tue, 31 Jul 2012 06:15:01 +0000 marek 4380@http://www.datastax.com/support-forums/ Hi! I installed the 32-bit version of the Datastax Community edition and after that all sorts of strange things started happening. Turns out that during the install, it hijacked my Java and Python installs and redirected them to its own private versions, contaminated my JAVA_HOME and PYTHONPATH (referring them to its private installs of Java and Python) and prepended itself to the system PATH. The PATH thing I can ALMOST forgive, as there are a gazillion other software packages that do the same and it has become an irritating modus operandi. What I DO object to, however, is hijacking my Python (version 3.x, instead of 2.whatever the Datastax CE uses) and Java installations (WTF is the point in keeping my Java up to date, allowing its stupid updater to run and pester me continuously when suddenly somebody comes along and voids all that "effort"?). Politely put, this is BS. The installer, of course, did not ASK nor WARN me of this. All that it was concerned about was, if I wanted to start the Datastax services on boot. A similar topic was already at <a href="http://www.datastax.com/support-forums/topic/datastax-community-windows-installer-eclipse" rel="nofollow">http://www.datastax.com/support-forums/topic/datastax-community-windows-installer-eclipse</a> Now, to end this rant in a constructive way: Is there a way to kindly request (or force) the Datastax CE (or its installer) to not contaminate my (development) system with its "business" or is the only workaround to install it in a separate (or virtual) machine which it can keep all for itself? Anonymous on "could not connect CQL 3.0" http://www.datastax.com/support-forums/topic/could-not-connect-cql-30#post-1770 Thu, 26 Apr 2012 23:02:34 +0000 Anonymous 1770@http://www.datastax.com/support-forums/ Fixed. cql_version='3.0.0' , but not '3.0'. connection = cql.connect('vicqadw01', 9160, 'demo', cql_version='3.0.0') Anonymous on "could not connect CQL 3.0" http://www.datastax.com/support-forums/topic/could-not-connect-cql-30#post-1765 Wed, 25 Apr 2012 18:22:50 +0000 Anonymous 1765@http://www.datastax.com/support-forums/ Here it is the error message: Python 2.6.5 (r265:79063, Feb 28 2011, 21:55:45) [GCC 4.1.2 20080704 (Red Hat 4.1.2-50)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> >>> >>> import cql >>> connection = cql.connect('localhost', cql_version='3.0') Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/lib/python2.6/site-packages/cql-1.0.10-py2.6.egg/cql/__init__.py", line 50, in connect return connection.Connection(host, port, keyspace, user, password, cql_version) File "/usr/lib/python2.6/site-packages/cql-1.0.10-py2.6.egg/cql/connection.py", line 55, in __init__ self.client.set_cql_version(cql_version) File "/usr/lib/python2.6/site-packages/cql-1.0.10-py2.6.egg/cql/cassandra/Cassandra.py", line 1705, in set_cql_version self.recv_set_cql_version() File "/usr/lib/python2.6/site-packages/cql-1.0.10-py2.6.egg/cql/cassandra/Cassandra.py", line 1726, in recv_set_cql_version raise result.ire cql.cassandra.ttypes.InvalidRequestException: InvalidRequestException(why='Invalid version value: 3.0 (see <a href="http://semver.org/" rel="nofollow">http://semver.org/</a> for details)') It will work after remove parameter "cql_version": >>> import cql >>> connection = cql.connect(host='127.0.0.1', port=9160, keyspace='demo', user=None, password=None) >>> Thanks, Charlie | DBA Anonymous on "Python error" http://www.datastax.com/support-forums/topic/python-error#post-1104 Thu, 09 Feb 2012 00:34:59 +0000 Anonymous 1104@http://www.datastax.com/support-forums/ Hi, Sorry for my late respons. TnX for the advice thobbs ! My company really needs that software running on that machine and if we somehow manage to do so, we will share our results in this thread. There is a limited amount of time available for this project however; please be patient, future posts will take some time :) Regards, zwoche mbulman on "Python error" http://www.datastax.com/support-forums/topic/python-error#post-1058 Fri, 20 Jan 2012 19:40:57 +0000 mbulman 1058@http://www.datastax.com/support-forums/ Aaron, if you want to try installing via the tarball and let us know what doesn't work (log file contents would be helpful), I'll see what we can do about workarounds. amorton on "Python error" http://www.datastax.com/support-forums/topic/python-error#post-1056 Thu, 19 Jan 2012 22:51:44 +0000 amorton 1056@http://www.datastax.com/support-forums/ I'm interested to know know about getting Ops Centre running on Free BSD, any tips ? thobbs on "Python error" http://www.datastax.com/support-forums/topic/python-error#post-881 Tue, 20 Dec 2011 17:18:36 +0000 thobbs 881@http://www.datastax.com/support-forums/ This is actually a known bug in 1.3.1. It occurs when you have a keyspace that has no replicas. For now, you can work around the issue by dropping that keyspace. This issue has been fixed for the next release of OpsCenter. Well done on getting OpsCenter to run on FreeBSD! Would you mind detailing the steps you had to take to potentially help others down the road? Anonymous on "Python error" http://www.datastax.com/support-forums/topic/python-error#post-878 Tue, 20 Dec 2011 15:40:31 +0000 Anonymous 878@http://www.datastax.com/support-forums/ Hi, We have been struggling to get OpsCenter running on FreeBSD 8.2. We've got the binary to run after installing some python modules; the web-address is browsable but is missing a lot of info... Below the contents of the logfile. Has anybody managed to get Opscenter running on FreeBSD systems (and resolved the issue we are running into as well?)? Since the code is already compiled we can't have a look at what is causing this problem :( Regards, Ruben ==== 2011-12-20 13:19:59+0100 [] INFO: Log opened. 2011-12-20 13:19:59+0100 [] INFO: twistd 10.1.0 (/usr/local/bin/python2.6 2.6.6) starting up. 2011-12-20 13:19:59+0100 [] INFO: reactor class: twisted.internet.selectreactor.SelectReactor. 2011-12-20 13:19:59+0100 [] INFO: Logging level set to 'debug' 2011-12-20 13:19:59+0100 [] INFO: OpsCenterdService startService 2011-12-20 13:19:59+0100 [] INFO: OpsCenter version: 1.3.1 2011-12-20 13:19:59+0100 [] INFO: Compatible agent version: 2.4 2011-12-20 13:19:59+0100 [] DEBUG: Logging user config options: 2011-12-20 13:19:59+0100 [] DEBUG: jmx : [('port', '7199')], logging : [('log_path', './log/opscenterd.log'), ('level', 'DEBUG')], stat_reporter : [('ssl_key', './ssl/stats.pem')], authentication : [], webserver : [('interface', '$ipaddress'), ('staticdir', './content'), ('port', '8888'), ('log_path', './log/http.log')], agents : [('ssl_certfile', './ssl/opscenter.pem'), ('tmp_dir', './tmp'), ('path_to_installscript', './bin/install_agent.sh'), ('path_to_sudowrap', './bin/sudo_with_pass.py'), ('agent_keyfile', './ssl/agentKeyStore'), ('path_to_deb', 'NONE'), ('ssl_keyfile', './ssl/opscenter.key'), ('agent_certfile', './ssl/agentKeyStore.pem'), ('path_to_rpm', 'NONE')], cassandra_metrics : [], cassandra : [('seed_hosts', '10.0.112.103, 10.0.112.104, 10.0.112.105')], 2011-12-20 13:19:59+0100 [] INFO: HTTP BASIC authentication disabled 2011-12-20 13:19:59+0100 [] DEBUG: Getting nodelist over thrift 2011-12-20 13:19:59+0100 [] INFO: agent_config items: {'metrics_enabled': 1, 'http_server_port': 61621, 'metrics_ignored_column_families': '', 'metrics_ignored_keyspaces': 'system, OpsCenter', 'jmx_port': 7199} 2011-12-20 13:19:59+0100 [] INFO: opscenterd.WebServer.OpsCenterdWebServer starting on 8888 2011-12-20 13:19:59+0100 [] INFO: Starting factory <opscenterd.WebServer.OpsCenterdWebServer instance at 0x804e77680> 2011-12-20 13:19:59+0100 [] DEBUG: Adding connection to <CassandraNode 10.0.112.105:9160 @0x804fab950> 2011-12-20 13:19:59+0100 [] DEBUG: Adding connection to <CassandraNode 10.0.112.104:9160 @0x804fab7e8> 2011-12-20 13:19:59+0100 [] DEBUG: Adding connection to <CassandraNode 10.0.112.103:9160 @0x804fabcf8> 2011-12-20 13:19:59+0100 [] DEBUG: Adding connection to <CassandraNode 10.0.112.105:9160 @0x804fab950> 2011-12-20 13:19:59+0100 [] DEBUG: Adding connection to <CassandraNode 10.0.112.104:9160 @0x804fab7e8> 2011-12-20 13:19:59+0100 [] DEBUG: Waiting for describe_version() results 2011-12-20 13:19:59+0100 [] INFO: Starting CassandraCluster service 2011-12-20 13:19:59+0100 [] INFO: morbid.morbid.StompFactory starting on 61619 2011-12-20 13:19:59+0100 [] INFO: Starting factory <morbid.morbid.StompFactory instance at 0x804e9b560> 2011-12-20 13:19:59+0100 [] INFO: morbid.morbid.StompFactory starting on 61620 2011-12-20 13:19:59+0100 [] INFO: Starting PushService 2011-12-20 13:19:59+0100 [] DEBUG: Waiting for a successful thrift call 2011-12-20 13:19:59+0100 [] DEBUG: Successfully added connection to <CassandraNode 10.0.112.104:9160 @0x804fab7e8> to the pool 2011-12-20 13:19:59+0100 [] DEBUG: Successfully added connection to <CassandraNode 10.0.112.104:9160 @0x804fab7e8> to the pool 2011-12-20 13:19:59+0100 [] DEBUG: Getting nodelist over thrift 2011-12-20 13:19:59+0100 [] DEBUG: Successfully added connection to <CassandraNode 10.0.112.105:9160 @0x804fab950> to the pool 2011-12-20 13:19:59+0100 [] DEBUG: Successfully added connection to <CassandraNode 10.0.112.105:9160 @0x804fab950> to the pool 2011-12-20 13:19:59+0100 [] DEBUG: Successfully added connection to <CassandraNode 10.0.112.103:9160 @0x804fabcf8> to the pool 2011-12-20 13:19:59+0100 [] INFO: Partitioner: org.apache.cassandra.dht.RandomPartitioner 2011-12-20 13:19:59+0100 [] INFO: Cluster Name: Test Cluster 2011-12-20 13:19:59+0100 [] INFO: Unhandled error in Deferred: 2011-12-20 13:19:59+0100 [] Unhandled Error Traceback (most recent call last): File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 345, in errback self._startRunCallbacks(fail) File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 424, in _startRunCallbacks self._runCallbacks() File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 441, in _runCallbacks self.result = callback(self.result, *args, **kw) File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 949, in gotResult _inlineCallbacks(r, g, deferred) --- <exception caught here> --- File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 891, in _inlineCallbacks result = result.throwExceptionIntoGenerator(g) File "/usr/local/lib/python2.6/site-packages/twisted/python/failure.py", line 338, in throwExceptionIntoGenerator return g.throw(self.type, self.value, self.tb) File "build/lib/python2.6/site-packages/opscenterd/Cluster.py", line 406, in startService File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 891, in _inlineCallbacks result = result.throwExceptionIntoGenerator(g) File "/usr/local/lib/python2.6/site-packages/twisted/python/failure.py", line 338, in throwExceptionIntoGenerator return g.throw(self.type, self.value, self.tb) File "build/lib/python2.6/site-packages/opscenterd/Cluster.py", line 573, in collectNodeList File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 893, in _inlineCallbacks result = g.send(result) File "build/lib/python2.6/site-packages/opscenterd/CassandraService.py", line 179, in getTokenList File "build/lib/python2.6/site-packages/opscenterd/CassandraService.py", line 191, in processTokenLists exceptions.IndexError: list index out of range 2011-12-20 13:19:59+0100 [] INFO: CPU Info: [] 2011-12-20 13:19:59+0100 [] INFO: Done loading metric configuration. 2011-12-20 13:19:59+0100 [] INFO: Done preloading last rollup times. 2011-12-20 13:19:59+0100 [] INFO: Loading all persisted alert rules 2011-12-20 13:19:59+0100 [] DEBUG: Getting nodelist over thrift 2011-12-20 13:19:59+0100 [] INFO: Unhandled error in Deferred: 2011-12-20 13:19:59+0100 [] Unhandled Error Traceback (most recent call last): File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 345, in errback self._startRunCallbacks(fail) File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 424, in _startRunCallbacks self._runCallbacks() File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 441, in _runCallbacks self.result = callback(self.result, *args, **kw) File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 949, in gotResult _inlineCallbacks(r, g, deferred) --- <exception caught here> --- File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 891, in _inlineCallbacks result = result.throwExceptionIntoGenerator(g) File "/usr/local/lib/python2.6/site-packages/twisted/python/failure.py", line 338, in throwExceptionIntoGenerator return g.throw(self.type, self.value, self.tb) File "build/lib/python2.6/site-packages/opscenterd/Cluster.py", line 573, in collectNodeList File "/usr/local/lib/python2.6/site-packages/twisted/internet/defer.py", line 893, in _inlineCallbacks result = g.send(result) File "build/lib/python2.6/site-packages/opscenterd/CassandraService.py", line 179, in getTokenList File "build/lib/python2.6/site-packages/opscenterd/CassandraService.py", line 191, in processTokenLists exceptions.IndexError: list index out of range $Info text with keyspace info (decided not to include in this logcontent) 2011-12-20 13:19:59+0100 [] DEBUG: Error while collecting system info list index out of range 2011-12-20 13:20:59+0100 [] DEBUG: Average opscenterd CPU usage: 0.51%, max resident: 27 MB 2011-12-20 13:21:59+0100 [] DEBUG: Average opscenterd CPU usage: 0.09%, max resident: 27 MB =======