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 Tue, 21 Dec 2010 03:00:49 GMT
I will try it out & let you know soon..

Thanks

On Tue, Dec 21, 2010 at 1:20 AM, Tyler Hobbs <tyler@riptano.com> wrote:
> Yes, Nick's suggestion is good.  I've added a logging statement at that
> point in the latest commit to phpcassa.  Perhaps you could try that and see
> what the error is?
>
> - Tyler
>
> On Mon, Dec 20, 2010 at 12:35 PM, Nick Bailey <nick@riptano.com> wrote:
>>
>> So it looks like phpcassa doesn't log any errors. The error you are seeing
>> is because the connection to the first server failed and there are no more
>> servers to try. It doesn't say why it failed though. The only thing i can
>> reccommend is on line 57 of connection.php to add a line to print out the
>> exception it catches there to see what the problem is. Or just throw the
>> exception again so the script dies there.
>> On Mon, Dec 20, 2010 at 11:38 AM, Rajkumar Gupta <rajkumar.w93@gmail.com>
>> wrote:
>>>
>>> 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