cassandra-client-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tyler Hobbs <ty...@datastax.com>
Subject Re: php cql driver issues
Date Fri, 27 May 2011 20:12:08 GMT
Are you issuing a USE KEYSPACE after you create the keyspace but before you
CREATE COLUMN FAMILY?

On Fri, May 27, 2011 at 4:14 AM, Nick Telford <nick.telford@gmail.com>wrote:

> Your catch block is dumping the stack trace, which tells you *where* the
> error occurred, but it doesn't tell you *which* error occurred.
>
> Add the following to your catch-block to determine the actual error: echo
> $exrs->getMessage();
>
> On an aside, I'm currently working with Dave Gardner and Courtney Robinson
> on a PHP CQL driver. It's still early days as we've not had a huge amount
> of
> time to put in to it, but if you want to help out, you're more than
> welcome.
> The base repo (for now) is http://github.com/nicktelford/php-cql
>
> Regards,
>
> Nick Telford
>
> On 27 May 2011 01:17, Kwasi Gyasi - Agyei <kwasi.gyasiagyei@4things.co.za
> >wrote:
>
> > Hi,
> >
> > in an attempt to get my hands dirty with Cassandra I decide to
> participate
> > in driver development, but I have come across a number of
> > problems am unable to debug regardless of what I try.
> >
> > The first issue is that the driver I developed is able to run cql
> commands
> > USE <keyspacename> CREATE KEYSPACE..., but the CREATE
> > COLUMNFAMILY... fails with no meaning full errors.
> >
> > The same command works perfectly in Eric Evans
> > http://caqel.deadcafe.org/<
> > http://www.google.com/url?sa=D&q=http://caqel.deadcafe.org/>but
> > in php no
> > success...
> >
> > My Code
> > ------------
> >
> > phpCQLAutoloader::register();
> >
> > $socketPool               = new TSocketPool();
> > $socketPool->addServer( "127.0.0.1", 9160 );
> > $socketPool->setDebug( true );
> >
> > $framedTransport  = new TFramedTransport( $socketPool, true, true );
> > $bufferedProtocol =  new
> > TBinaryProtocolAccelerated( $framedTransport );
> > $cassandraClient  = new CassandraClient( $bufferedProtocol,
> > $bufferedProtocol );
> >
> > try{
> >
> >        echo "opening connection <br>";
> >        $framedTransport->open();
> >
> >        try{
> >
> >                        echo "Executing create column query <br/>";
> >                        //$query = "CREATE KEYSPACE southafrica WITH
> > strategy_options:replication_factor = 1 AND strategy_class =
> > 'SimpleStrategy'";
> >                        $query  = "CREATE COLUMNFAMILY smoke (KEY text
> > PRIMARY KEY, monkey
> > text) 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();
> >
> > PHP Output
> > ----------------
> >
> > opening connection
> > Executing create column query
> > COLUMNFAMILY error occuired --
> > #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(36): CassandraClient-
> > >execute_cql_query('CREATE COLUMNFA...', 2) #4 {main}
> >
> > closing connnection
> > phpCQL testing...
> >
> > Cassandra log output
> > ------------------------------
> >
> > DEBUG 21:00:00,507 logged out: #<User allow_all groups=[]>
> > DEBUG 21:00:10,673 Disseminating load info ...
> > DEBUG 21:00:38,796 logged out: #<User allow_all groups=[]>
> > DEBUG 21:01:10,674 Disseminating load info ...
> > DEBUG 21:02:10,674 Disseminating load info ...
> > DEBUG 21:03:10,676 Disseminating load info ...
> > basically nothing happens in Cassandra in debug mode.
> >
> > I'm totally lost...
> >
> > --
> > *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
> >
>



-- 
Tyler Hobbs
Software Engineer, DataStax <http://datastax.com/>
Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra
Python client library

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message