Chanan, I did my tests with perlcassa 0.041 (installed using cpanm) and it worked flawlessly, perhaps you should give it a try.
I'm not quite sure how to install v0.06 via MetaCPan as it seems to contain only version 0.041 ( https://metacpan.org/release/perlcassa ). Just to cover the basics - when you're trying it with cqlsh, you're running "cqlsh" without any IP/Port, right? - HU On Sun, Jun 15, 2014 at 11:43 AM, Chanan Berler <[email protected]> wrote: > Currently am using perlcassa ver0.6 (downloaded from MetaCPan) and CQL ver > 3.1.1 > > Changing same as you said replacing seed_nodes with hosts => ['127.0.0.1'] > if do_not_discover_peers set to 0 then I receive this error message: Can't > call method "execute_cql3_query" on an undefined value at > /usr/local/share/perl5/perlcassa/Client.pm line 65 > if do_not_discover_peers set to 1 then I receive this error message: > Unable to find the column family users in test at /usr/local/share/perl5/ > perlcassa.pm line 510 > > Chanan > > > > > > On Sun, Jun 15, 2014 at 11:33 AM, Uri Hartmann <[email protected]> wrote: > >> Hi Chanan, >> >> I've commented out the 'seed_nodes' line (it gave me "Use of >> uninitialized value in split"), and added 'hosts' => ['127.0.0.1'], to the >> %connect_params - and it seems to work just fine with the same >> keyspace/columnfamily as you've stated above. >> >> Perhaps your issue is related to >> https://github.com/mkjellman/perlcassa/issues/46 ? >> >> - HU >> >> >> On Sun, Jun 15, 2014 at 11:30 AM, Chanan Berler <[email protected]> >> wrote: >> >>> Hi Uri, >>> >>> Found the problem, as I forgot to use test before calling describe >>> columnfamily: >>> >>> DESCRIBE COLUMNFAMILY users; >>> >>> >>> CREATE TABLE users ( >>> user_id bigint, >>> birth_year bigint, >>> gender text, >>> password text, >>> session_token text, >>> state text, >>> user_name text, >>> PRIMARY KEY (user_id) >>> ) WITH >>> bloom_filter_fp_chance=0.010000 AND >>> caching='KEYS_ONLY' AND >>> comment='' AND >>> dclocal_read_repair_chance=0.000000 AND >>> gc_grace_seconds=864000 AND >>> index_interval=128 AND >>> read_repair_chance=0.100000 AND >>> replicate_on_write='true' AND >>> populate_io_cache_on_flush='false' AND >>> default_time_to_live=0 AND >>> speculative_retry='99.0PERCENTILE' AND >>> memtable_flush_period_in_ms=0 AND >>> compaction={'class': 'SizeTieredCompactionStrategy'} AND >>> compression={'sstable_compression': 'LZ4Compressor'}; >>> >>> >>> >>> >>> On Sun, Jun 15, 2014 at 11:21 AM, Chanan Berler <[email protected]> >>> wrote: >>> >>>> Hi Uri, >>>> >>>> I wonder why I receive this error message? doing simple select works >>>> perfect >>>> Chanan >>>> >>>> >>>> DESCRIBE COLUMNFAMILY users >>>> >>>> Bad Request: line 2:44 no viable alternative at input 'and' >>>> DESCRIBE KEYSPACE test; >>>> >>>> >>>> >>>> ========================================================= >>>> >>>> CREATE KEYSPACE test WITH replication = { >>>> 'class': 'SimpleStrategy', >>>> 'replication_factor': '1' >>>> }; >>>> >>>> USE test; >>>> >>>> CREATE TABLE users ( >>>> user_id bigint, >>>> birth_year bigint, >>>> gender text, >>>> password text, >>>> session_token text, >>>> state text, >>>> user_name text, >>>> PRIMARY KEY (user_id) >>>> ) WITH >>>> bloom_filter_fp_chance=0.010000 AND >>>> caching='KEYS_ONLY' AND >>>> comment='' AND >>>> dclocal_read_repair_chance=0.000000 AND >>>> gc_grace_seconds=864000 AND >>>> index_interval=128 AND >>>> read_repair_chance=0.100000 AND >>>> replicate_on_write='true' AND >>>> populate_io_cache_on_flush='false' AND >>>> default_time_to_live=0 AND >>>> speculative_retry='99.0PERCENTILE' AND >>>> memtable_flush_period_in_ms=0 AND >>>> compaction={'class': 'SizeTieredCompactionStrategy'} AND >>>> compression={'sstable_compression': 'LZ4Compressor'}; >>>> >>>> cqlsh> >>>> >>>> >>>> >>>> >>>> >>>> On Fri, Jun 13, 2014 at 12:38 PM, Uri Hartmann <[email protected]> >>>> wrote: >>>> >>>>> Hi Chanan, >>>>> >>>>> Can you please post the output of: >>>>> >>>>> DESCRIBE KEYSPACE test; >>>>> DESCRIBE COLUMNFAMILY users; >>>>> >>>>> Thanks, >>>>> - HU >>>>> >>>>> >>>>> On Wed, Jun 11, 2014 at 2:13 PM, Chanan Berler <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi All, >>>>>> >>>>>> Has anyone had some experience connecting to Cassandra DB using perl? >>>>>> I have tried using perlcassa but failed :( >>>>>> >>>>>> Following is a small test I used to connect to Cassandra: >>>>>> >>>>>> #!/usr/bin/perl >>>>>> use warnings; >>>>>> use strict; >>>>>> use Data::Dumper qw/Dumper/; >>>>>> use perlcassa; >>>>>> >>>>>> my $self = { >>>>>> }; >>>>>> >>>>>> my %connect_params = ( >>>>>> 'columnfamily' => 'users', >>>>>> 'keyspace' => 'test', >>>>>> 'seed_nodes' => [split(/,/, >>>>>> $self->{'_SEEDSNODES'})], >>>>>> 'read_consistency_level' => >>>>>> Cassandra::ConsistencyLevel::ALL, >>>>>> 'write_consistency_level' => >>>>>> Cassandra::ConsistencyLevel::ONE, >>>>>> 'port' => 9160, >>>>>> ); >>>>>> >>>>>> my $dbh = new perlcassa(%connect_params); >>>>>> >>>>>> the error message I receive is: >>>>>> Unable to find the column family users in test at >>>>>> /usr/local/share/perl5/perlcassa.pm line 510. >>>>>> >>>>>> >>>>>> -- >>>>>> =================== >>>>>> ---- Chanan Berler ---- >>>>>> =================== >>>>>> >>>>>> _______________________________________________ >>>>>> Perl mailing list >>>>>> [email protected] >>>>>> http://mail.perl.org.il/mailman/listinfo/perl >>>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Perl mailing list >>>>> [email protected] >>>>> http://mail.perl.org.il/mailman/listinfo/perl >>>>> >>>> >>>> >>>> >>>> -- >>>> =================== >>>> ---- Chanan Berler ---- >>>> =================== >>>> >>> >>> >>> >>> -- >>> =================== >>> ---- Chanan Berler ---- >>> =================== >>> >>> _______________________________________________ >>> Perl mailing list >>> [email protected] >>> http://mail.perl.org.il/mailman/listinfo/perl >>> >> >> >> _______________________________________________ >> Perl mailing list >> [email protected] >> http://mail.perl.org.il/mailman/listinfo/perl >> > > > > -- > =================== > ---- Chanan Berler ---- > =================== > > _______________________________________________ > Perl mailing list > [email protected] > http://mail.perl.org.il/mailman/listinfo/perl >
_______________________________________________ Perl mailing list [email protected] http://mail.perl.org.il/mailman/listinfo/perl
