incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajkumar Gupta <rajkumar....@gmail.com>
Subject Re: Problem in using PHPcassa: Uncaught exception 'Exception' with message 'Could not connect to a cassandra server'
Date Mon, 20 Dec 2010 17:38:19 GMT
Nick,

Sorry I can not currently access my computer on which cassandra is
installed but yes, earlier I used the 'show keyspaces;' command & it
correctly showed me the keyspace1 with corresponding column families.
Yes I was using Cassandra 0.6.8 earlier and now I have switched to
0.7. Since I was using thobbs phpcassa which infact worked with 0.7
version but I came to know lately. I have tried on ubuntu as well but
I am not very proficient in ubuntu therefore I quit there and decided
to get it running on windows only.

So right now, I am using Cassandra 0.7.0 on windows. I am trying to
use thobbs's PHPcassa with it but when I try this:

<?php
require_once('Z:/wamp/bin/php/'.'phpcassa/connection.php');
require_once('Z:/wamp/bin/php/'.'phpcassa/columnfamily.php');

   $servers[0]['host'] = 'localhost';
   $servers[0]['port'] = '9160';
   $conn = new Connection('Keyspace1', $servers);

$column_family = new ColumnFamily($conn, 'Standard1');
?>


Fatal error: Uncaught exception 'NoServerAvailable' in
Z:\wamp\bin\php\phpcassa\connection.php:153
Stack trace: #0 Z:\wamp\bin\php\phpcassa\connection.php(53):
ServerSet->get() #1 Z:\wamp\bin\php\phpcassa\connection.php(64):
Connection->connect() #2
Z:\wamp\bin\php\phpcassa\columnfamily.php(171): Connection->connect()
#3 Z:\wamp\www\PhpProject\index.php(10):
ColumnFamily->__construct(Object(Connection), 'Standard1') #4 {main}
thrown in Z:\wamp\bin\php\phpcassa\connection.php on line 153

Thanks so much Nick ..


On Mon, Dec 20, 2010 at 10:47 PM, Nick Bailey <nick@riptano.com> wrote:
> Just to verify the keyspace exists can you run 'use Keyspace1;' in the cli?
> Also it looks like you were using 0.6.8 and now you are using 0.7.0? What is
> the exact error you are seeing now?
>
> On Mon, Dec 20, 2010 at 10:21 AM, Rajkumar Gupta <rajkumar.w93@gmail.com>
> wrote:
>>
>> Keyspace1 is included by default in the cassandra.yaml file and I
>> imported the schema before running the php script
>> so I hope that is not the problem..
>>
>> I am now too much frustrated with this problem..:(  and this is just
>> the beginning of my Cassandra experiments
>>
>>
>>
>>
>> On Mon, Dec 20, 2010 at 8:36 PM, Nick Bailey <nick@riptano.com> wrote:
>> > Have you created Keyspace1? Looks like phpcassa requires you to set a
>> > keyspace when you connect but the cli would not. Which might explain why
>> > you
>> > are seeing problems.
>> >
>> > On Mon, Dec 20, 2010 at 5:42 AM, Rajkumar Gupta <rajkumar.w93@gmail.com>
>> > wrote:
>> >>
>> >> I am using the following code to connect to Cassandra 0.7.0 using
>> >> PHPcassa (thobbs)
>> >>
>> >> <?php
>> >> require_once('Z:/wamp/bin/php/'.'phpcassa/connection.php');
>> >> require_once('Z:/wamp/bin/php/'.'phpcassa/columnfamily.php');
>> >>
>> >>    $servers[0]['host'] = 'localhost';
>> >>    $servers[0]['port'] = '9160';
>> >>    $conn = new Connection('Keyspace1', $servers);
>> >>
>> >> $column_family = new ColumnFamily($conn, 'Standard1');
>> >> ?>
>> >>
>> >> However I am able to connect to cassandra instance through
>> >> cassandra-cli at command prompt but not through this php script.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> On Mon, Dec 20, 2010 at 11:10 AM, Nick Bailey <nick@riptano.com> wrote:
>> >> > It would probably help if you posted the code you are trying to use
>> >> > from
>> >> > your php script. I don't know much about the php client but I now
>> >> > someone on
>> >> > this list does.
>> >> >
>> >> > On Sun, Dec 19, 2010 at 10:55 PM, Rajkumar Gupta
>> >> > <rajkumar.w93@gmail.com>
>> >> > wrote:
>> >> >>
>> >> >> I am able to connect to cassandra through cassandra-cli command
at
>> >> >> command prompt but not through my php script. I also checked after
>> >> >> changing the rpc address to 0.0.0.0 in cassandra.yaml file but
it
>> >> >> still does not work!
>> >> >>
>> >> >>
>> >> >> On Mon, Dec 20, 2010 at 1:47 AM, Aaron Morton
>> >> >> <aaron@thelastpickle.com>
>> >> >> wrote:
>> >> >> > Forgot to say, 0.0.0.0 is not a good idea in production...
>> >> >> > http://wiki.apache.org/cassandra/FAQ#cant_listen_on_ip_any
>> >> >> >
>> >> >> >
>> >> >> > On 20/12/2010, at 9:12 AM, Aaron Morton <aaron@thelastpickle.com>
>> >> >> > wrote:
>> >> >> >
>> >> >> >> I've not used the PHP client, but you can test connectivity
to
>> >> >> >> your
>> >> >> >> cluster using the cassandra-cli command line client in
the bin/
>> >> >> >> folder.
>> >> >> >>
>> >> >> >> Also check the ThriftAddress setting in your storage-config,
this
>> >> >> >> address is the one that the server will be listening on.
Set it
>> >> >> >> to
>> >> >> >> 0.0.0.0
>> >> >> >> to listen on all.
>> >> >> >>
>> >> >> >> Aaron
>> >> >> >>
>> >> >> >> On 19/12/2010, at 8:45 AM, Rajkumar Gupta
>> >> >> >> <rajkumar.w93@gmail.com>
>> >> >> >> wrote:
>> >> >> >>
>> >> >> >>> Hi, I am trying to use phpcassa(Hoan's) with Cassandra
0.6.8 but
>> >> >> >>> when
>> >> >> >>> I try to run the following php script that includes
phpcassa,
>> >> >> >>>
>> >> >> >>>
>> >> >> >>> <?php
>> >> >> >>>       $GLOBALS['THRIFT_ROOT'] =
>> >> >> >>> 'Z:/wamp/bin/php/include/thrift/';
>> >> >> >>> require_once
>> >> >> >>> $GLOBALS['THRIFT_ROOT'].'/packages/cassandra/Cassandra.php';
>> >> >> >>> require_once $GLOBALS['THRIFT_ROOT'].'/transport/TSocket.php';
>> >> >> >>> require_once
>> >> >> >>> $GLOBALS['THRIFT_ROOT'].'/protocol/TBinaryProtocol.php';
>> >> >> >>> require_once
>> >> >> >>> $GLOBALS['THRIFT_ROOT'].'/transport/TFramedTransport.php';
>> >> >> >>> require_once
>> >> >> >>> $GLOBALS['THRIFT_ROOT'].'/transport/TBufferedTransport.php';
>> >> >> >>>
>> >> >> >>> include_once('Z:/wamp/bin/php/include/phpcassa.php');
>> >> >> >>> include_once('Z:/wamp/bin/php/include/uuid.php');
>> >> >> >>>
>> >> >> >>> CassandraConn::add_node('192.168.1.1', 9160);
>> >> >> >>>
>> >> >> >>> $users = new CassandraCF('Keyspace1', 'Users');
>> >> >> >>>
>> >> >> >>> $users->insert('1', array('email' => 'hoan.tonthat@gmail.com',
>> >> >> >>> 'password' => 'test'));
>> >> >> >>> ?>
>> >> >> >>>
>> >> >> >>>
>> >> >> >>> on running above script I get this error:
>> >> >> >>>
>> >> >> >>> Fatal error: Uncaught exception 'Exception' with message
'Could
>> >> >> >>> not
>> >> >> >>> connect to a cassandra server' in
>> >> >> >>> Z:\wamp\bin\php\include\phpcassa.php:70 Stack trace:
#0
>> >> >> >>> Z:\wamp\bin\php\include\phpcassa.php(193):
>> >> >> >>> CassandraConn::get_client()
>> >> >> >>> #1 Z:\wamp\www\PhpProject\index.php(38):
>> >> >> >>> CassandraCF->insert('1',
>> >> >> >>> Array) #2 {main} thrown in Z:\wamp\bin\php\include\phpcassa.php
>> >> >> >>> on
>> >> >> >>> line 70
>> >> >> >>>
>> >> >> >>> Please let me know how can I make it work
>> >> >> >>>
>> >> >> >>> Thanks...
>> >> >> >>> --
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >>
>> >> >> ___________________________________
>> >> >>
>> >> >> Rajkumar Gupta
>> >> >> Dihing 173,
>> >> >> Indian Institute of Technology Guwahati
>> >> >> India
>> >> >>
>> >> >>
>> >> >> http://in.linkedin.com/in/rajkumargupta1
>> >> >
>> >> >
>> >
>> >
>
>

Mime
View raw message