Return-Path: 
 <user-return-17125-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-user-archive@www.apache.org
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 9BFA166DE
	for <apmail-cassandra-user-archive@www.apache.org>;
 Thu, 26 May 2011 18:56:15 +0000 (UTC)
Received: (qmail 84692 invoked by uid 500); 26 May 2011 18:56:13 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 84670 invoked by uid 500); 26 May 2011 18:56:13 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 84661 invoked by uid 99); 26 May 2011 18:56:13 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 May 2011 18:56:13 +0000
X-ASF-Spam-Status: No, hits=2.2 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [209.85.212.44] (HELO mail-vw0-f44.google.com) (209.85.212.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 May 2011 18:56:06 +0000
Received: by vws12 with SMTP id 12so999250vws.31
        for <user@cassandra.apache.org>; Thu, 26 May 2011 11:55:44 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.52.31.195 with SMTP id c3mr1766972vdi.141.1306435869666; Thu,
 26 May 2011 11:51:09 -0700 (PDT)
Received: by 10.52.112.170 with HTTP; Thu, 26 May 2011 11:51:09 -0700 (PDT)
In-Reply-To: <C537D1B4-BA94-46E6-9B24-B5A2F1DF8B93@thelastpickle.com>
References: <BANLkTi=0BaPB=yqa+xL0f3unTBRSL+sodQ@mail.gmail.com>
	<C537D1B4-BA94-46E6-9B24-B5A2F1DF8B93@thelastpickle.com>
Date: Thu, 26 May 2011 20:51:09 +0200
Message-ID: <BANLkTi=8xLAu8b-ykPOkW=Ut4f6QQxEMnQ@mail.gmail.com>
Subject: Re: PHP CQL Driver
From: Kwasi Gyasi - Agyei <kwasi.gyasiagyei@4things.co.za>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=bcaec51d28ceeeebe304a4324d61
X-Virus-Checked: Checked by ClamAV on apache.org

--bcaec51d28ceeeebe304a4324d61
Content-Type: text/plain; charset=UTF-8

got system in debug mode

the following query fails
-------------------------------

CREATE COLUMNFAMILY magic (KEY text PRIMARY KEY, monkey ) WITH comparator =
text AND default_validation = text

PHP error reads
-------------------------

#0
/Volumes/DATA/Project/libs/php/phpCQL/vendor/cassandra/cassandra.Cassandra_execute_cql_query_result.php(52):
TBase->_read('Cassandra_execu...', Array, Object(TBinaryProtocol)) #1
/Volumes/DATA/Project/libs/php/phpCQL/vendor/cassandra/cassandra.Cassandra.client.php(1771):
cassandra_Cassandra_execute_cql_query_result->read(Object(TBinaryProtocol))
#2
/Volumes/DATA/Project/libs/php/phpCQL/vendor/cassandra/cassandra.Cassandra.client.php(1731):
CassandraClient->recv_execute_cql_query() #3
/Volumes/DATA/Project/libs/php/phpCQL/test/index.php(34):
CassandraClient->execute_cql_query('CREATE COLUMNFA...', 2) #4 {main}

Cassandra logs read
------------------------------

DEBUG 20:48:10,659 Disseminating load info ...
DEBUG 20:49:10,661 Disseminating load info ...
DEBUG 20:49:22,867 CQL statement type: USE
DEBUG 20:49:22,870 logged out: #<User allow_all groups=[]>


here is the code I'm using to test
--------------------------------------------

phpCQLAutoloader::register();

$socketPool          = new TSocketPool();
$socketPool->addServer( "127.0.0.1", 9160 );
$socketPool->setDebug( true );

$framedTransport  = new TFramedTransport( $socketPool, true, true );
$bufferedProtocol = new TBinaryProtocol( $framedTransport, true, true );
//new TBinaryProtocolAccelerated( $framedTransport );
$cassandraClient  = new CassandraClient( $bufferedProtocol,
$bufferedProtocol );

try{

    echo "opening connection <br>";
    $framedTransport->open();

    try{

        echo "settign keyspace to use <br/>";
        $result = $cassandraClient->execute_cql_query( "use nnduronic" ,
cassandra_Compression::NONE);
         print_r( $result );

    }catch( cassandra_InvalidRequestException $exrs ){

        echo "USE error occuired -- <br> " . $exrs->getTraceAsString() . "
<br>";
    }

    try{

            echo "Executing create column query <br/>";
            $query  = "CREATE COLUMNFAMILY magic (KEY text PRIMARY KEY,
monkey ) WITH comparator = text AND default_validation = text";
            $result = $cassandraClient->execute_cql_query( $query ,
cassandra_Compression::NONE );

            echo "|". print_r($result) . "|" . "<br>";

    }catch( cassandra_InvalidRequestException $exrs ){
        echo "COLUMNFAMILY error occuired -- <br> " .
$exrs->getTraceAsString() . " <br>";
    }
        echo "closing connnection <br>";
    $framedTransport->close();


I'm lost :(

On Thu, May 26, 2011 at 9:17 AM, aaron morton <aaron@thelastpickle.com>wrote:

> Cool, this may be a better discussion for the client-dev list
> http://www.mail-archive.com/client-dev@cassandra.apache.org/
>
> I would start by turning up the server logging to DEBUG and watching your
> update / select queries.
>
> Cheers
> -----------------
> Aaron Morton
> Freelance Cassandra Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 26 May 2011, at 16:15, Kwasi Gyasi - Agyei wrote:
>
> Hi,
>
> I have manged to generate thrift interface for php along with implementing
> auto-loading of both Cassandra and thrift core class.
>
> However during my testing the only query that works as expected is the
> create keyspace cql query... all other queries don't do or return any
> results nor do they throw exceptions even in try catch statement I get
> nothing.
>
> --
> *4Things*
> Multimedia and Communication | Property | Entertainment
> Kwasi Owusu Gyasi - Agyei
>
> *cell*        (+27) (0) 76 466 4488
> *website *www.4things.co.za
> *email     *kwasi.gyasiagyei@4things.co.za
> *skype    *kwasi.gyasiagyei
> *role*        Developer.Designer.Software Architect
>
>
>


-- 
*4Things*
Multimedia and Communication | Property | Entertainment
Kwasi Owusu Gyasi - Agyei

*cell*        (+27) (0) 76 466 4488
*website *www.4things.co.za
*email     *kwasi.gyasiagyei@4things.co.za
*skype    *kwasi.gyasiagyei
*role*        Developer.Designer.Software Architect

--bcaec51d28ceeeebe304a4324d61
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

got system in debug mode<br><br>the following query fails <br>-------------=
------------------<br><br>CREATE COLUMNFAMILY magic (KEY text PRIMARY KEY, =
monkey ) WITH comparator =3D text AND default_validation =3D text<br><br>PH=
P error reads<br>
-------------------------<br><br>#0=20
/Volumes/DATA/Project/libs/php/phpCQL/vendor/cassandra/cassandra.Cassandra_=
execute_cql_query_result.php(52):
 TBase-&gt;_read(&#39;Cassandra_execu...&#39;, Array, Object(TBinaryProtoco=
l))
#1=20
/Volumes/DATA/Project/libs/php/phpCQL/vendor/cassandra/cassandra.Cassandra.=
client.php(1771):
=20
cassandra_Cassandra_execute_cql_query_result-&gt;read(Object(TBinaryProtoco=
l))
#2
=20
/Volumes/DATA/Project/libs/php/phpCQL/vendor/cassandra/cassandra.Cassandra.=
client.php(1731):
 CassandraClient-&gt;recv_execute_cql_query()
#3 /Volumes/DATA/Project/libs/php/phpCQL/test/index.php(34):=20
CassandraClient-&gt;execute_cql_query(&#39;CREATE COLUMNFA...&#39;, 2)
#4 {main} <br><br>Cassandra logs read<br>------------------------------<br>=
<br>DEBUG 20:48:10,659 Disseminating load info ...<br>DEBUG 20:49:10,661 Di=
sseminating load info ...<br>DEBUG 20:49:22,867 CQL statement type: USE<br>
DEBUG 20:49:22,870 logged out: #&lt;User allow_all groups=3D[]&gt;<br><br><=
br>here is the code I&#39;m using to test <br>-----------------------------=
---------------<br><br>phpCQLAutoloader::register();<br><br>$socketPool=C2=
=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0 =3D new TSocketPool();<br>
$socketPool-&gt;addServer( &quot;127.0.0.1&quot;, 9160 );<br>$socketPool-&g=
t;setDebug( true );<br><br>$framedTransport=C2=A0 =3D new TFramedTransport(=
 $socketPool, true, true );<br>$bufferedProtocol =3D new TBinaryProtocol( $=
framedTransport, true, true ); //new TBinaryProtocolAccelerated( $framedTra=
nsport );<br>
$cassandraClient=C2=A0 =3D new CassandraClient( $bufferedProtocol, $buffere=
dProtocol );<br><br>try{<br>=C2=A0=C2=A0=C2=A0 <br>=C2=A0=C2=A0=C2=A0 echo =
&quot;opening connection &lt;br&gt;&quot;;<br>=C2=A0=C2=A0=C2=A0 $framedTra=
nsport-&gt;open();<br>=C2=A0=C2=A0=C2=A0 <br>=C2=A0=C2=A0=C2=A0 try{<br>=C2=
=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 <br>
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 echo &quot;settign keyspace to use &l=
t;br/&gt;&quot;;<br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 $result =3D $cass=
andraClient-&gt;execute_cql_query( &quot;use nnduronic&quot; , cassandra_Co=
mpression::NONE);<br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0 print_r( $=
result );<br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0 <br>
=C2=A0=C2=A0=C2=A0 }catch( cassandra_InvalidRequestException $exrs ){<br>=
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 <br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=
=C2=A0 echo &quot;USE error occuired -- &lt;br&gt; &quot; . $exrs-&gt;getTr=
aceAsString() . &quot; &lt;br&gt;&quot;;<br>=C2=A0=C2=A0=C2=A0 }<br><br>=C2=
=A0=C2=A0=C2=A0 try{<br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=
=C2=A0 <br>
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 echo &quot;Executi=
ng create column query &lt;br/&gt;&quot;;<br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=
=A0=C2=A0 =C2=A0=C2=A0=C2=A0 $query=C2=A0 =3D &quot;CREATE COLUMNFAMILY mag=
ic (KEY text PRIMARY KEY, monkey ) WITH comparator =3D text AND default_val=
idation =3D text&quot;;<br>
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 $result =3D $cassa=
ndraClient-&gt;execute_cql_query( $query , cassandra_Compression::NONE );<b=
r>=C2=A0=C2=A0=C2=A0 <br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=
=C2=A0 echo &quot;|&quot;. print_r($result) . &quot;|&quot; . &quot;&lt;br&=
gt;&quot;;<br>=C2=A0=C2=A0=C2=A0 <br>=C2=A0=C2=A0=C2=A0 }catch( cassandra_I=
nvalidRequestException $exrs ){<br>
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 echo &quot;COLUMNFAMILY error occuire=
d -- &lt;br&gt; &quot; . $exrs-&gt;getTraceAsString() . &quot; &lt;br&gt;&q=
uot;;<br>=C2=A0=C2=A0=C2=A0 }<br>=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 echo=
 &quot;closing connnection &lt;br&gt;&quot;;<br>=C2=A0=C2=A0=C2=A0 $framedT=
ransport-&gt;close();<br>
<br><br>I&#39;m lost :(<br><br><div class=3D"gmail_quote">On Thu, May 26, 2=
011 at 9:17 AM, aaron morton <span dir=3D"ltr">&lt;<a href=3D"mailto:aaron@=
thelastpickle.com">aaron@thelastpickle.com</a>&gt;</span> wrote:<br><blockq=
uote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc =
solid;padding-left:1ex;">
<div style=3D"word-wrap:break-word">Cool, this may be a better discussion f=
or the client-dev list=C2=A0<br><a href=3D"http://www.mail-archive.com/clie=
nt-dev@cassandra.apache.org/" target=3D"_blank">http://www.mail-archive.com=
/client-dev@cassandra.apache.org/</a><br>
<br>I would start by turning up the server logging to DEBUG and watching yo=
ur update / select queries.=C2=A0<br><br>Cheers<br><div>
<span style=3D"border-collapse:separate;color:rgb(0, 0, 0);font-family:Helv=
etica;font-style:normal;font-variant:normal;font-weight:normal;letter-spaci=
ng:normal;line-height:normal;text-align:auto;text-indent:0px;text-transform=
:none;white-space:normal;word-spacing:0px;font-size:medium"><span style=3D"=
border-collapse:separate;color:rgb(0, 0, 0);font-family:Helvetica;font-styl=
e:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-=
height:normal;text-indent:0px;text-transform:none;white-space:normal;word-s=
pacing:0px;font-size:medium"><div style=3D"word-wrap:break-word">
<span style=3D"border-collapse:separate;color:rgb(0, 0, 0);font-family:Helv=
etica;font-style:normal;font-variant:normal;font-weight:normal;letter-spaci=
ng:normal;line-height:normal;text-indent:0px;text-transform:none;white-spac=
e:normal;word-spacing:0px;font-size:medium"><div style=3D"word-wrap:break-w=
ord">
<div><div>-----------------</div><div>Aaron Morton</div><div>Freelance Cass=
andra Developer</div><div>@aaronmorton</div><div><a href=3D"http://www.thel=
astpickle.com" target=3D"_blank">http://www.thelastpickle.com</a></div></di=
v>
</div></span></div></span></span>
</div><div><div></div><div class=3D"h5">

<br><div><div>On 26 May 2011, at 16:15, Kwasi Gyasi - Agyei wrote:</div><br=
><blockquote type=3D"cite">Hi,<br><br>I have manged to generate thrift inte=
rface for php along with implementing auto-loading of both Cassandra and th=
rift core class. <br>
<br>However during my testing the only query that works as expected is the =
create keyspace cql query... all other queries don&#39;t do or return any r=
esults nor do they throw exceptions even in try catch statement I get nothi=
ng.<br clear=3D"all">

<br>-- <br><b>4<span style=3D"color:rgb(255, 0, 0)">Things</span></b><br><f=
ont style=3D"color:rgb(153, 153, 153)" size=3D"1">Multimedia and Communicat=
ion | Property | Entertainment</font><br><span style=3D"color:rgb(102, 102,=
 102)">Kwasi Owusu Gyasi - Agyei</span><br>


<br><b style=3D"color:rgb(0, 0, 0)">cell</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 <span style=3D"color:rgb(102, 102, 102)"><a href=3D"tel:%28%2B=
27%29%20%280%29%2076%20466%204488" value=3D"+27764664488" target=3D"_blank"=
>(+27) (0) 76 466 4488</a></span><br><b style=3D"color:rgb(0, 0, 0)">websit=
e </b><span style=3D"color:rgb(51, 51, 51)"><a href=3D"http://www.4things.c=
o.za/" target=3D"_blank">www.4things.co.za</a></span><br>

<b style=3D"color:rgb(0, 0, 0)">email=C2=A0=C2=A0=C2=A0=C2=A0 </b><span sty=
le=3D"color:rgb(102, 102, 102)"><a href=3D"mailto:kwasi.gyasiagyei@4things.=
co.za" target=3D"_blank">kwasi.gyasiagyei@4things.co.za</a></span><br><b st=
yle=3D"color:rgb(0, 0, 0)">skype=C2=A0=C2=A0=C2=A0 </b><span style=3D"color=
:rgb(102, 102, 102)">kwasi.gyasiagyei</span><br>

<b style=3D"color:rgb(0, 0, 0)">role</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 <span style=3D"color:rgb(102, 102, 102)">Developer.Designer.Softw=
are Architect</span><br>
</blockquote></div><br></div></div></div></blockquote></div><br><br clear=
=3D"all"><br>-- <br><b>4<span style=3D"color:rgb(255, 0, 0)">Things</span><=
/b><br><font style=3D"color:rgb(153, 153, 153)" size=3D"1">Multimedia and C=
ommunication | Property | Entertainment</font><br>
<span style=3D"color:rgb(102, 102, 102)">Kwasi Owusu Gyasi - Agyei</span><b=
r>
<br><b style=3D"color:rgb(0, 0, 0)">cell</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 <span style=3D"color:rgb(102, 102, 102)">(+27) (0) 76 466 4488=
</span><br><b style=3D"color:rgb(0, 0, 0)">website </b><span style=3D"color=
:rgb(51, 51, 51)"><a href=3D"http://www.4things.co.za" target=3D"_blank">ww=
w.4things.co.za</a></span><br>
<b style=3D"color:rgb(0, 0, 0)">email=C2=A0=C2=A0=C2=A0=C2=A0 </b><span sty=
le=3D"color:rgb(102, 102, 102)"><a href=3D"mailto:kwasi.gyasiagyei@4things.=
co.za" target=3D"_blank">kwasi.gyasiagyei@4things.co.za</a></span><br><b st=
yle=3D"color:rgb(0, 0, 0)">skype=C2=A0=C2=A0=C2=A0 </b><span style=3D"color=
:rgb(102, 102, 102)">kwasi.gyasiagyei</span><br>
<b style=3D"color:rgb(0, 0, 0)">role</b>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 <span style=3D"color:rgb(102, 102, 102)">Developer.Designer.Softw=
are Architect</span><br>

--bcaec51d28ceeeebe304a4324d61--