From aqsyounas@gmail.com Mon Jul  4 19:48:25 2016
From: Aqs Younas <aqsyounas@gmail.com>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] Error while reading from Cassandra Cluster
Date: Mon, 04 Jul 2016 22:48:19 +0500
Message-ID:
 <CAGVOjVVA2qZx_CWsf203EvEyr5JoUgB13n66q=Mh0k+3nVfTHg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1295566168=="

--===============1295566168==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

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



--===============1295566168==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGRpdiBkaXI9Imx0ciI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMi44cHgiPkdyZWV0aW5ncyBM
aXN0cy7CoDwvc3Bhbj48ZGl2IHN0eWxlPSJmb250LXNpemU6MTIuOHB4Ij48YnI+PC9kaXY+PGRp
diBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+SSBhbSBoYXZpbmcgaGFyZCB0aW1lIHRyeWluZyB0
byB1c2XCoG5kYl9jYXNzYW5kcmEgd2l0aCBrYW1haWxpby4gSSBoYXZlIHN1Y2Nlc3NmdWxseSBj
b21wbGllZCB0aGUgbW9kdWxlIGFuZCBrYW1haWxpbyBydW5zIHdpdGhvdXQgYW55IGVycm9yLsKg
PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+QmVsb3cgaXMgcmVsZXZhbnQgc25p
cHBldC7CoDwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtc2l6ZToxMi44cHgiPjxicj48L2Rpdj48ZGl2
IHN0eWxlPSJmb250LXNpemU6MTIuOHB4Ij5sb2FkbW9kdWxlICZxdW90O25kYl9jYXNzYW5kcmEu
c28mcXVvdDs8YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+PGRpdj5tb2Rw
YXJhbSgmcXVvdDtuZGJfY2Fzc2FuZHJhJnF1b3Q7LCAmcXVvdDtob3N0JnF1b3Q7LCAmcXVvdDsx
OTIuMTY4LjAuMTAzJnF1b3Q7KTwvZGl2PjxkaXY+bW9kcGFyYW0oJnF1b3Q7bmRiX2Nhc3NhbmRy
YSZxdW90OywgJnF1b3Q7cG9ydCZxdW90OywgOTE2MCk8L2Rpdj48L2Rpdj48ZGl2IHN0eWxlPSJm
b250LXNpemU6MTIuOHB4Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+
PGRpdj7CoCDCoCDCoCDCoCAkdmFyKGtleXNwYWNlKSA9ICYjMzk7a2FtYWlsaW8mIzM5Ozs8L2Rp
dj48ZGl2PsKgIMKgIMKgIMKgICR2YXIoY29sdW1uX2ZhbWlseSkgPSAmIzM5O251bWJlcnNfZGly
ZWN0b3J5JiMzOTs7PC9kaXY+PGRpdj7CoCDCoCDCoCDCoCAkdmFyKGtleSkgPSAxNTs8L2Rpdj48
ZGl2PsKgIMKgIMKgIMKgICR2YXIoY29sdW1uKSA9ICYjMzk7bnVtYmVyJiMzOTs7PC9kaXY+PGRp
dj7CoCDCoCDCoCDCoCB4bG9nKCZxdW90O0xfSU5GTyZxdW90OywgJnF1b3Q7VmFsdXMgdG8gZmV0
Y2ggYXJlICR2YXIoa2V5c3BhY2UpLCAkdmFyKGNvbHVtbl9mYW1pbHkpLCAkdmFyKGtleSksICR2
YXIoY29sdW1uKSBcbiZxdW90Oyk7PC9kaXY+PGRpdj7CoCDCoCDCoCDCoDxiPsKgaWYgKGNhc3Nf
cmV0cmlldmUoJnF1b3Q7JHZhcihrZXlzcGFjZSkmcXVvdDssICZxdW90OyR2YXIoY29sdW1uX2Zh
bWlseSkmcXVvdDsswqAmcXVvdDskdmFyKGtleSkmcXVvdDssICZxdW90O3ByZWZpeCZxdW90OyzC
oCZxdW90OyR2YXIodmFsX3JlYWQpJnF1b3Q7KSAmZ3Q7IDApIHs8L2I+PC9kaXY+PGRpdj7CoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCB4bG9nKCZxdW90O0xfSU5GTyZxdW90OywgJnF1b3Q7ID09PT09
IG5kYl9jYXNzYW5kcmEuIFN1Y2VzcyB3aGlsZSByZWFkaW5nIGZyb20gQ2Fzc2FuZHJhLiB2YWxf
cmVhZDogXCZxdW90OyR2YXIodmFsX3JlYWQpXCZxdW90O1xuJnF1b3Q7KTs8L2Rpdj48ZGl2PsKg
IMKgIMKgIMKgIH0gZWxzZSB7PC9kaXY+PGRpdj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCB4bG9n
KCZxdW90O0xfSU5GTyZxdW90OywgJnF1b3Q7ID09PT09IG5kYl9jYXNzYW5kcmEuIEVycm9yIHdo
aWxlIHJlYWRpbmcgZnJvbSBDYXNzYW5kcmEgXG4mcXVvdDspOzwvZGl2PjxkaXY+wqAgwqAgwqAg
wqAgfTwvZGl2PjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtc2l6ZToxMi44cHgiPjxicj48L2Rpdj48
ZGl2IHN0eWxlPSJmb250LXNpemU6MTIuOHB4Ij5DYXNzYW5kcmEgVGFibGUgU3RydWN0dXJlLsKg
PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9
ImZvbnQtc2l6ZToxMi44cHgiPjxkaXY+Y3Fsc2g6a2FtYWlsaW8mZ3Q7IGRlc2NyaWJlIG51bWJl
cnNfZGlyZWN0b3J5OzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Q1JFQVRFIFRBQkxFIGthbWFp
bGlvLm51bWJlcnNfZGlyZWN0b3J5ICg8L2Rpdj48ZGl2PsKgIMKgIGlkIGludCBQUklNQVJZIEtF
WSw8L2Rpdj48ZGl2PsKgIMKgIGRlc2NyaXB0aW9uIHRleHQsPC9kaXY+PGRpdj7CoCDCoCBudW1i
ZXIgdGV4dDwvZGl2PjxkaXY+KSBXSVRIIGJsb29tX2ZpbHRlcl9mcF9jaGFuY2UgPSAwLjAxPC9k
aXY+PGRpdj7CoCDCoCBBTkQgY2FjaGluZyA9ICYjMzk7eyZxdW90O2tleXMmcXVvdDs6JnF1b3Q7
QUxMJnF1b3Q7LCAmcXVvdDtyb3dzX3Blcl9wYXJ0aXRpb24mcXVvdDs6JnF1b3Q7Tk9ORSZxdW90
O30mIzM5OzwvZGl2PjxkaXY+wqAgwqAgQU5EIGNvbW1lbnQgPSAmIzM5OyYjMzk7PC9kaXY+PGRp
dj7CoCDCoCBBTkQgY29tcGFjdGlvbiA9IHsmIzM5O2NsYXNzJiMzOTs6ICYjMzk7b3JnLmFwYWNo
ZS5jYXNzYW5kcmEuZGIuY29tcGFjdGlvbi5TaXplVGllcmVkQ29tcGFjdGlvblN0cmF0ZWd5JiMz
OTt9PC9kaXY+PGRpdj7CoCDCoCBBTkQgY29tcHJlc3Npb24gPSB7JiMzOTtzc3RhYmxlX2NvbXBy
ZXNzaW9uJiMzOTs6ICYjMzk7b3JnLmFwYWNoZS5jYXNzYW5kcmEuaW8uY29tcHJlc3MuTFo0Q29t
cHJlc3NvciYjMzk7fTwvZGl2PjxkaXY+wqAgwqAgQU5EIGRjbG9jYWxfcmVhZF9yZXBhaXJfY2hh
bmNlID0gMC4xPC9kaXY+PGRpdj7CoCDCoCBBTkQgZGVmYXVsdF90aW1lX3RvX2xpdmUgPSAwPC9k
aXY+PGRpdj7CoCDCoCBBTkQgZ2NfZ3JhY2Vfc2Vjb25kcyA9IDg2NDAwMDwvZGl2PjxkaXY+wqAg
wqAgQU5EIG1heF9pbmRleF9pbnRlcnZhbCA9IDIwNDg8L2Rpdj48ZGl2PsKgIMKgIEFORCBtZW10
YWJsZV9mbHVzaF9wZXJpb2RfaW5fbXMgPSAwPC9kaXY+PGRpdj7CoCDCoCBBTkQgbWluX2luZGV4
X2ludGVydmFsID0gMTI4PC9kaXY+PGRpdj7CoCDCoCBBTkQgcmVhZF9yZXBhaXJfY2hhbmNlID0g
MC4wPC9kaXY+PGRpdj7CoCDCoCBBTkQgc3BlY3VsYXRpdmVfcmV0cnkgPSAmIzM5Ozk5LjBQRVJD
RU5USUxFJiMzOTs7PC9kaXY+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+PGJy
PjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtc2l6ZToxMi44cHgiPjxicj48L2Rpdj48ZGl2IHN0eWxl
PSJmb250LXNpemU6MTIuOHB4Ij48ZGl2PmNxbHNoOmthbWFpbGlvJmd0OyBzZWxlY3QgKiBmcm9t
IG51bWJlcnNfZGlyZWN0b3J5OzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+wqBpZCB8IGRlc2Ny
aXB0aW9uIHwgbnVtYmVyPC9kaXY+PGRpdj4tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS08
L2Rpdj48ZGl2PsKgMTUgfCDCoCDCoCDCoCDCoG51bGwgfCAyMTI0NTY3ODk8L2Rpdj48L2Rpdj48
ZGl2IHN0eWxlPSJmb250LXNpemU6MTIuOHB4Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1z
aXplOjEyLjhweCI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtc2l6ZToxMi44cHgiPjxicj48
L2Rpdj48ZGl2IHN0eWxlPSJmb250LXNpemU6MTIuOHB4Ij5XaGVuIGkgbWFrZSBhIGNhbGwgaSBn
ZXQgdGhpcyBpbiBsb2dzLsKgPC9kaXY+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+PGJy
PjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtc2l6ZToxMi44cHgiPjxkaXY+SnVsIMKgMSAxOToxMDo0
MiBkZWJpYW4gLi9rYW1haWxpb1s4MTQyXTogSU5GTzogJmx0O3NjcmlwdCZndDs6IFZhbHVzIHRv
IGZldGNoIGFyZSBrYW1haWxpbywgbnVtYmVyc19kaXJlY3RvcnksIDE1LCBudW1iZXI8L2Rpdj48
ZGl2Pkp1bCDCoDEgMTk6MTA6NDIgZGViaWFuIC4va2FtYWlsaW9bODE0Ml06IElORk86ICZsdDtz
Y3JpcHQmZ3Q7OiDCoD09PT09IG5kYl9jYXNzYW5kcmEuwqA8Yj5FcnJvciB3aGlsZSByZWFkaW5n
IGZyb20gQ2Fzc2FuZHJhPC9iPjwvZGl2PjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtc2l6ZToxMi44
cHgiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LXNpemU6MTIuOHB4Ij5JIGFtIHN0dWNrIGF0
IHRoaXMuIERvZXMgYW55Ym9keSBhYmxlIHRvIHVzZSBrYW1haWxpbyB3aXRoIGNhc3NhbmRyYSBv
ciBjYW4gc2hhcmUgdGhlaXIgY29uZmlndXJhdGlvbj88L2Rpdj48ZGl2IHN0eWxlPSJmb250LXNp
emU6MTIuOHB4Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+QW55IHBv
aW50ZXIgb24gdGhpcyBpcyBtdWNoIGFwcHJlY2lhdGVkLsKgPC9kaXY+PGRpdiBzdHlsZT0iZm9u
dC1zaXplOjEyLjhweCI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtc2l6ZToxMi44cHgiPkJl
c3QgUmVnYXJkcyw8L2Rpdj48ZGl2IHN0eWxlPSJmb250LXNpemU6MTIuOHB4Ij48YnI+PC9kaXY+
PGRpdiBzdHlsZT0iZm9udC1zaXplOjEyLjhweCI+QXFzIFlvdW5hczwvZGl2PjwvZGl2Pgo=

--===============1295566168==--