Error while reading from Cassandra Cluster - sr-users

4 Jul 2016

Greetings Lists.

I am having hard time trying to use ndb_cassandra with kamailio. I have
successfully complied the module and kamailio runs without any error.
Below is relevant snippet.

loadmodule "ndb_cassandra.so"
modparam("ndb_cassandra", "host", "192.168.0.103")
modparam("ndb_cassandra", "port", 9160)

        $var(keyspace) = 'kamailio';
        $var(column_family) = 'numbers_directory';
        $var(key) = 15;
        $var(column) = 'number';
        xlog("L_INFO", "Valus to fetch are $var(keyspace),
$var(column_family), $var(key), $var(column) \n");
       * if (cass_retrieve("$var(keyspace)",
"$var(column_family)", "$var(key)", "prefix",
"$var(val_read)") > 0) {*
                xlog("L_INFO", " ===== ndb_cassandra. Sucess while reading
from Cassandra. val_read: \"$var(val_read)\"\n");
        } else {
                xlog("L_INFO", " ===== ndb_cassandra. Error while reading
from Cassandra \n");
        }

Cassandra Table Structure.

cqlsh:kamailio> describe numbers_directory;

CREATE TABLE kamailio.numbers_directory (
    id int PRIMARY KEY,
    description text,
    number text
) WITH bloom_filter_fp_chance = 0.01
    AND caching = '{"keys":"ALL",
"rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
    AND compression = {'sstable_compression':
'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99.0PERCENTILE';

cqlsh:kamailio> select * from numbers_directory;

 id | description | number
----+-------------+-----------
 15 |        null | 212456789

When i make a call i get this in logs.

Jul  1 19:10:42 debian ./kamailio[8142]: INFO: <script>: Valus to fetch are
kamailio, numbers_directory, 15, number
Jul  1 19:10:42 debian ./kamailio[8142]: INFO: <script>:  =====
ndb_cassandra. *Error while reading from Cassandra*

I am stuck at this. Does anybody able to use kamailio with cassandra or can
share their configuration?

Any pointer on this is much appreciated.

Best Regards,

Aqs Younas