<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,</p>
<p>try to run with debug=3 in kamailio.cfg and see if you get more
hints why the cass_retrieve() is returning negative code.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 02/07/16 13:01, Aqs Younas wrote:<br>
</div>
<blockquote
cite="mid:CAGVOjVUMRmUU6J6YNBR4kTEVE8hfLu+_vCfiZXHBukUdwxk5PQ@mail.gmail.com"
type="cite">
<div dir="ltr">Greetings Lists.
<div><br>
</div>
<div>I am having hard time trying to use ndb_cassandra with
kamailio. I have successfully complied the module and kamailio
runs without any error. </div>
<div>Below is relevant snippet. </div>
<div><br>
</div>
<div>loadmodule "ndb_cassandra.so"<br>
</div>
<div>
<div>modparam("ndb_cassandra", "host", "192.168.0.103")</div>
<div>modparam("ndb_cassandra", "port", 9160)</div>
</div>
<div><br>
</div>
<div>
<div>
<div> $var(keyspace) = 'kamailio';</div>
<div> $var(column_family) = 'numbers_directory';</div>
<div> $var(key) = 15;</div>
<div> $var(column) = 'number';</div>
<div> xlog("L_INFO", "Valus to fetch are
$var(keyspace), $var(column_family), $var(key),
$var(column) \n");</div>
<div> <b> if (cass_retrieve("$var(keyspace)",
"$var(column_family)", "$var(key)",
"prefix", "$var(val_read)") > 0) {</b></div>
<div> xlog("L_INFO", " ===== ndb_cassandra.
Sucess while reading from Cassandra. val_read:
\"$var(val_read)\"\n");</div>
<div> } else {</div>
<div> xlog("L_INFO", " ===== ndb_cassandra.
Error while reading from Cassandra \n");</div>
<div> }</div>
</div>
</div>
<div><br>
</div>
<div>Cassandra Table Structure. </div>
<div><br>
</div>
<div>
<div>cqlsh:kamailio> describe numbers_directory;</div>
<div><br>
</div>
<div>CREATE TABLE kamailio.numbers_directory (</div>
<div> id int PRIMARY KEY,</div>
<div> description text,</div>
<div> number text</div>
<div>) WITH bloom_filter_fp_chance = 0.01</div>
<div> AND caching = '{"keys":"ALL",
"rows_per_partition":"NONE"}'</div>
<div> AND comment = ''</div>
<div> AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}</div>
<div> AND compression = {'sstable_compression':
'org.apache.cassandra.io.compress.LZ4Compressor'}</div>
<div> AND dclocal_read_repair_chance = 0.1</div>
<div> AND default_time_to_live = 0</div>
<div> AND gc_grace_seconds = 864000</div>
<div> AND max_index_interval = 2048</div>
<div> AND memtable_flush_period_in_ms = 0</div>
<div> AND min_index_interval = 128</div>
<div> AND read_repair_chance = 0.0</div>
<div> AND speculative_retry = '99.0PERCENTILE';</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>cqlsh:kamailio> select * from numbers_directory;</div>
<div><br>
</div>
<div> id | description | number</div>
<div>----+-------------+-----------</div>
<div> 15 | null | 212456789</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>When i make a call i get this in logs. </div>
<div><br>
</div>
<div>
<div>Jul 1 19:10:42 debian ./kamailio[8142]: INFO:
<script>: Valus to fetch are kamailio,
numbers_directory, 15, number</div>
<div>Jul 1 19:10:42 debian ./kamailio[8142]: INFO:
<script>: ===== ndb_cassandra. <b>Error while
reading from Cassandra</b></div>
</div>
<div><br>
</div>
<div>I am stuck at this. Does anybody able to use kamailio with
cassandra or can share their configuration?</div>
<div><br>
</div>
<div>Any pointer on this is much appreciated. </div>
<div><br>
</div>
<div>Best Regards, </div>
<div><br>
</div>
<div>Aqs Younas</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
sr-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a> - <a class="moz-txt-link-freetext" href="http://www.kamailio.org">http://www.kamailio.org</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>