Return-Path: 
 <cassandra-user-return-34-apmail-incubator-cassandra-user-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org
Received: (qmail 9674 invoked from network); 2 May 2009 11:22:59 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 2 May 2009 11:22:59 -0000
Received: (qmail 16079 invoked by uid 500); 2 May 2009 11:22:59 -0000
Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org
Received: (qmail 16033 invoked by uid 500); 2 May 2009 11:22:58 -0000
Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:cassandra-user-help@incubator.apache.org>
List-Unsubscribe: <mailto:cassandra-user-unsubscribe@incubator.apache.org>
List-Post: <mailto:cassandra-user@incubator.apache.org>
List-Id: <cassandra-user.incubator.apache.org>
Reply-To: cassandra-user@incubator.apache.org
Delivered-To: mailing list cassandra-user@incubator.apache.org
Received: (qmail 16024 invoked by uid 99); 2 May 2009 11:22:58 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 May 2009 11:22:58 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of manuel.crotti@ing.unibs.it
 designates 192.167.23.204 as permitted sender)
Received: from [192.167.23.204] (HELO hiems2.ing.unibs.it) (192.167.23.204)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 02 May 2009 11:22:51 +0000
Received: from localhost (localhost [127.0.0.1])
	by hiems2.ing.unibs.it (Postfix) with ESMTP id D605118257EC
	for <cassandra-user@incubator.apache.org>;
 Sat,  2 May 2009 13:22:27 +0200 (CEST)
X-Virus-Scanned: amavisd-new at ing.unibs.it
Received: from hiems2.ing.unibs.it ([127.0.0.1])
	by localhost (hiems1.ing.unibs.it [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 4u69qqml5U07 for <cassandra-user@incubator.apache.org>;
	Sat,  2 May 2009 13:22:27 +0200 (CEST)
X-PreSpam: auth
Message-Id: <75F7AE08-430D-4430-B0F9-6736FEA48129@ing.unibs.it>
From: Manuel Crotti <manuel.crotti@ing.unibs.it>
To: cassandra-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=Apple-Mail-6-963140553
Mime-Version: 1.0 (Apple Message framework v930.3)
Subject: Some questions.
Date: Sat, 2 May 2009 13:22:25 +0200
X-Mailer: Apple Mail (2.930.3)
X-Virus-Checked: Checked by ClamAV on apache.org


--Apple-Mail-6-963140553
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed;
	delsp=yes
Content-Transfer-Encoding: 7bit

Hi all (long msg, sorry),

My name is Manuel, I'm a PhD student and I'm trying to implement a  
distributed p2pDB using Cassandra.
I successfully installed Cassandra on a virtual linux box (after  
trying unsuccessfully on a OSX - jdk stuffs). Now it works (the output  
is compliant with the one described in the "README" file ).

Then I replicated the linux vm twice, properly editing the network  
settings in order to avoid duplicate hostnames/ip addresses obtaining  
the following network topology:

10.0.1.1 -> linux01
10.0.1.2 -> linux02
10.0.1.3 -> linux03

Now I have some questions:

1. each "storage-conf.xml" should contain just one of the above ip- 
addresses (obviously not the localhost's IP address) in the <Seeds>  
section to let cassandra learn the whole topology? Or it must contain  
the whole list?
2. how can I see if the nodes of the cluster are "talking" (some  
logfile, ...)? (I supposed to find it into the localhost:7002  
interface but i see just a host -localhost -  and I suppose hosts are  
not "talking")
3. What should differ between the  "storage-conf.xml" files of each  
node?
3.1. the "storage-conf.xml" of each node should contain the table  
structure to replicate/propagate the information of the data of a table?
     <Tables>
         <Table Name="Table1">
             <ColumnFamily ColumnSort="Name" Name="Standard1"/>
             <ColumnFamily ColumnSort="Name" Name="Standard2"/>
             <ColumnFamily ColumnSort="Time" Name="StandardByTime1"/>
             <ColumnFamily ColumnSort="Time" Name="StandardByTime2"/>
             <ColumnFamily ColumnType="Super" ColumnSort="Name"  
Name="Super1"/>
             <ColumnFamily ColumnType="Super" ColumnSort="Name"  
Name="Super2"/>
         </Table>
     </Tables>
3.2 finally: should I start a cluster with an empty DB or I can  
replicate an existing DB?

My doubt is due to the fact that the VM replication was made after the  
installation of Cassandra.

I also submit a couple of errors that raised using the command-line  
client:

1. I tried to run the following from linux01:

$> bin/cassandra-cli --host 10.0.1.2 --port 9160

Obtaining the following.

Exception java.net.ConnectException: Connection refused
org.apache.thrift.transport.TTransportException:  
java.net.ConnectException: Connection refused
	at org.apache.thrift.transport.TSocket.open(TSocket.java:184)
	at org.apache.cassandra.cli.CliMain.connect(CliMain.java:59)
	at org.apache.cassandra.cli.CliMain.main(CliMain.java:167)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at  
java 
.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:310)
	at  
java 
.net 
.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java: 
176)
	at  
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java: 
163)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:381)
	at java.net.Socket.connect(Socket.java:537)
	at java.net.Socket.connect(Socket.java:487)
	at org.apache.thrift.transport.TSocket.open(TSocket.java:179)
	... 2 more
Connected to 10.0.1.2/9160
Welcome to cassandra CLI.

No connection has really been made to 10.0.1.2

2. $> bin/cassandra-cli --host localhost --port 9160

cassandra> show config file
Exception Cannot read. Remote side has closed. Tried to read 4 bytes,  
but only got 0 bytes.
org.apache.thrift.transport.TTransportException: Cannot read. Remote  
side has closed. Tried to read 4 bytes, but only got 0 bytes.
	at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)
	at  
org 
.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java: 
314)
	at  
org 
.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java: 
262)
	at  
org 
.apache 
.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java: 
192)
	at org.apache.cassandra.service.Cassandra 
$Client.recv_getStringProperty(Cassandra.java:696)
	at org.apache.cassandra.service.Cassandra 
$Client.getStringProperty(Cassandra.java:681)
	at  
org.apache.cassandra.cli.CliClient.executeShowProperty(CliClient.java: 
211)
	at org.apache.cassandra.cli.CliClient.executeCLIStmt(CliClient.java:69)
	at org.apache.cassandra.cli.CliMain.processCLIStmt(CliMain.java:121)
	at org.apache.cassandra.cli.CliMain.processLine(CliMain.java:153)
	at org.apache.cassandra.cli.CliMain.main(CliMain.java:187)
cassandra>

No firewall was enabled.


Regards,
Manuel.
--Apple-Mail-6-963140553
Content-Type: text/html;
	charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space; ">Hi all (long msg, =
sorry),&nbsp;<div><br></div><div>My name is Manuel, I'm a PhD student =
and I'm trying to implement a distributed p2pDB using =
Cassandra.</div><div>I successfully installed Cassandra on a virtual =
linux box (after trying unsuccessfully on a OSX - jdk stuffs). Now it =
works (the output is compliant with the one described in the "README" =
file ).</div><div><br></div><div>Then I replicated the linux vm twice, =
properly editing the network settings in order to avoid duplicate =
hostnames/ip addresses&nbsp;obtaining the following network =
topology:</div><div><div><br></div><div>10.0.1.1 -> =
linux01</div><div>10.0.1.2 -> linux02</div><div>10.0.1.3 -> =
linux03</div></div><div><br></div><div>Now I have some =
questions:</div><div><br></div><div>1. each "storage-conf.xml" should =
contain just one of the above ip-addresses&nbsp;(obviously not the =
localhost's IP address)&nbsp;in the &lt;Seeds> section to let cassandra =
learn the whole topology? Or it must contain the whole =
list?</div><div>2. how can I see if the nodes of the cluster are =
"talking" (some logfile, ...)? (I supposed to find it into the =
localhost:7002 interface but i see just a host -localhost - &nbsp;and I =
suppose hosts are not "talking")</div><div><div>3. What should differ =
between the &nbsp;"storage-conf.xml" files of each =
node?</div><div><div>3.1. the&nbsp;"storage-conf.xml" of each node =
should contain the table structure to replicate/propagate the =
information of the data of a table?&nbsp;</div><div><div><i>&nbsp;&nbsp; =
&nbsp;&lt;Tables></i></div><div><i>&nbsp;&nbsp; &nbsp; &nbsp; =
&nbsp;&lt;Table Name=3D"Table1"></i></div><div><i>&nbsp;&nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp; &nbsp;&lt;ColumnFamily ColumnSort=3D"Name" =
Name=3D"Standard1"/></i></div><div><i>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp;&lt;ColumnFamily ColumnSort=3D"Name" =
Name=3D"Standard2"/></i></div><div><i>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp;&lt;ColumnFamily ColumnSort=3D"Time" =
Name=3D"StandardByTime1"/></i></div><div><i>&nbsp;&nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp;&lt;ColumnFamily ColumnSort=3D"Time" =
Name=3D"StandardByTime2"/></i></div><div><i>&nbsp;&nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp;&lt;ColumnFamily ColumnType=3D"Super" =
ColumnSort=3D"Name" Name=3D"Super1"/></i></div><div><i>&nbsp;&nbsp; =
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;ColumnFamily ColumnType=3D"Super" =
ColumnSort=3D"Name" Name=3D"Super2"/></i></div><div><i>&nbsp;&nbsp; =
&nbsp; &nbsp; &nbsp;&lt;/Table></i></div><div><i>&nbsp;&nbsp; =
&nbsp;&lt;/Tables></i></div></div></div></div><div>3.2 finally: should I =
start a cluster with an empty DB or I can replicate an existing =
DB?</div><div><br></div><div>My doubt is due to the fact that the VM =
replication was made after the installation of =
Cassandra.&nbsp;</div><div><br></div><div>I also submit a couple of =
errors that raised using the command-line =
client:</div><div><br></div><div>1. I tried to run the following from =
linux01:</div><div><br></div><div>$> bin/cassandra-cli =
--host&nbsp;10.0.1.2&nbsp;--port 9160</div><div><br></div><div>Obtaining =
the&nbsp;following.</div><div><br></div><div><div><i>Exception =
java.net.ConnectException: Connection =
refused</i></div><div><i>org.apache.thrift.transport.TTransportException: =
java.net.ConnectException: Connection refused</i></div><div><span =
class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.thrift.transport.TSocket.open(TSocket.java:184)</i></div><div><=
span class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>at =
org.apache.cassandra.cli.CliMain.connect(CliMain.java:59)</i></div><div><s=
pan class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>at =
org.apache.cassandra.cli.CliMain.main(CliMain.java:167)</i></div><div><i>C=
aused by: java.net.ConnectException: Connection =
refused</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
java.net.PlainSocketImpl.socketConnect(Native =
Method)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:31=
0)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.=
java:176)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:163)=
</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:381)</i></div><div><=
span class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>at =
java.net.Socket.connect(Socket.java:537)</i></div><div><span =
class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	</i></span><i>at =
java.net.Socket.connect(Socket.java:487)</i></div><div><span =
class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.thrift.transport.TSocket.open(TSocket.java:179)</i></div><div><=
span class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>... 2 more</i></div><div><i>Connected to =
10.0.1.2/9160</i></div><div><i>Welcome to cassandra =
CLI.</i></div><div><br></div></div><div>No connection has really been =
made to 10.0.1.2</div><div><br></div><div>2.&nbsp;$> bin/cassandra-cli =
--host localhost --port 9160</div><div><br></div><div><div><i>cassandra> =
show config file &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp;&nbsp;</i></div><div><i>Exception Cannot read. Remote side has =
closed. Tried to read 4 bytes, but only got 0 =
bytes.</i></div><div><i>org.apache.thrift.transport.TTransportException: =
Cannot read. Remote side has closed. Tried to read 4 bytes, but only got =
0 bytes.</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)</i></di=
v><div><span class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>at =
org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:31=
4)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:26=
2)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtoco=
l.java:192)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.cassandra.service.Cassandra$Client.recv_getStringProperty(Cassa=
ndra.java:696)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.cassandra.service.Cassandra$Client.getStringProperty(Cassandra.=
java:681)</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.cassandra.cli.CliClient.executeShowProperty(CliClient.java:211)=
</i></div><div><span class=3D"Apple-tab-span" =
style=3D"white-space:pre"><i>	</i></span><i>at =
org.apache.cassandra.cli.CliClient.executeCLIStmt(CliClient.java:69)</i></=
div><div><span class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>at =
org.apache.cassandra.cli.CliMain.processCLIStmt(CliMain.java:121)</i></div=
><div><span class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>at =
org.apache.cassandra.cli.CliMain.processLine(CliMain.java:153)</i></div><d=
iv><span class=3D"Apple-tab-span" style=3D"white-space:pre"><i>	=
</i></span><i>at =
org.apache.cassandra.cli.CliMain.main(CliMain.java:187)</i></div><div><i>c=
assandra>&nbsp;</i></div><div><br></div><div>No firewall was =
enabled.</div></div><div><br></div><div><br></div><div>Regards,</div><div>=
Manuel.</div></body></html>=

--Apple-Mail-6-963140553--