yep, works perfectly @ http://caqel.deadcafe.org/
I will try my luck @ phpcassa. Thanks for your time gentlemen. On Thu, May 26, 2011 at 8:59 PM, Sasha Dolgy <sdo...@gmail.com> wrote: > maybe you'd have more luck discussing this on the phpcassa list? > https://groups.google.com/forum/#!forum/phpcassa > > more experience there with PHP and Cassandra ... > > Are you able to validate the query works when not using PHP? > > On Thu, May 26, 2011 at 8:51 PM, Kwasi Gyasi - Agyei > <kwasi.gyasiag...@4things.co.za> wrote: > > 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 <aa...@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.gyasiag...@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.gyasiag...@4things.co.za > > skype kwasi.gyasiagyei > > role Developer.Designer.Software Architect > > > > > > -- > Sasha Dolgy > sasha.do...@gmail.com > -- *4Things* Multimedia and Communication | Property | Entertainment Kwasi Owusu Gyasi - Agyei *cell* (+27) (0) 76 466 4488 *website *www.4things.co.za *email *kwasi.gyasiag...@4things.co.za *skype *kwasi.gyasiagyei *role* Developer.Designer.Software Architect
