incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kwasi Gyasi - Agyei <kwasi.gyasiag...@4things.co.za>
Subject Re: PHP CQL Driver
Date Thu, 26 May 2011 18:51:09 GMT
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

Mime
View raw message