<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,</p>
<p>perhaps someone needs to dive in the code of db_cassandra. Not
long ago, there was a discussion saying that the module is using
an old lib version and may not actually work. There were exposed
plans to eventually update it.</p>
<p>Are you using the old cassandra lib version?</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 12/05/16 18:17, SamyGo wrote:<br>
</div>
<blockquote
cite="mid:CAJUJwtjOUGrUiRg7zu51B-rPg5eYJm1fC2cit0XDpJUu8FKnng@mail.gmail.com"
type="cite">
<div dir="ltr">Hi List,
<div><br>
</div>
<div>I'm trying to hook up userblacklist module with
db_cassandra. I've kamailio keyspace configured with tables
for userblacklist , globalblacklist, and version are created
with some data in there. </div>
<div><br>
</div>
<div>Here is setup info:</div>
<div><br>
</div>
<div><font face="monospace, monospace">version: kamailio 4.4.1</font><br>
</div>
<div><br>
</div>
<div><b>kamailio.cfg</b></div>
<div>...</div>
<div><font face="monospace, monospace">loadmodule
"db_cassandra.so"<br>
</font></div>
<div>
<div><font face="monospace, monospace">modparam("db_cassandra",
"schema_path","/etc/kamailio/kamailio")</font></div>
<div><font face="monospace, monospace"><br>
</font></div>
<div><font face="monospace, monospace">loadmodule
"userblacklist.so"<br>
</font></div>
<div><font face="monospace, monospace">modparam("userblacklist",
"db_url", "cassandra://:@<a moz-do-not-send="true"
href="http://127.0.0.1:9160/kamailio">127.0.0.1:9160/kamailio</a>")</font></div>
<div><font face="monospace, monospace">modparam("userblacklist",
"userblacklist_table", "userblacklist")</font></div>
<div><font face="monospace, monospace">modparam("userblacklist",
"globalblacklist_table", "globalblacklist")</font></div>
</div>
<div><br>
</div>
<div><b>SCHEMA PATH:</b></div>
<div>
<div><font face="monospace, monospace">root@whit-list:/etc/kamailio/kamailio#
ls</font></div>
<div><font face="monospace, monospace">userblacklist version</font></div>
<div><font face="monospace, monospace">root@whit-list:/etc/kamailio/kamailio#
cat version/version<br>
</font></div>
<div><font face="monospace, monospace">table_name(string)
table_version(int)</font></div>
<div><font face="monospace, monospace">table_name</font></div>
<div><font face="monospace, monospace"><br>
root@whit-list:/etc/kamailio/kamailio# cat
userblacklist/userblacklist</font></div>
<div><font face="monospace, monospace">id(int)
username(string) domain(string) prefix(string)
whitelist(int)</font></div>
<div><font face="monospace, monospace">id username</font></div>
</div>
<div><br>
</div>
<div><b>CASSANDRA DB</b></div>
<div>
<div><br>
<font face="monospace, monospace">root@whit-list:/etc/kamailio/kamailio#
cqlsh</font></div>
<div><font face="monospace, monospace">Connected to Test
Cluster at <a moz-do-not-send="true"
href="http://127.0.0.1:9042">127.0.0.1:9042</a>.</font></div>
<div><font face="monospace, monospace">[cqlsh 5.0.1 |
Cassandra 3.5 | CQL spec 3.4.0 | Native protocol v4]</font></div>
<div><font face="monospace, monospace">Use HELP for help.</font></div>
<div><font face="monospace, monospace">cqlsh> use kamailio</font></div>
<div><font face="monospace, monospace"> ... ;</font></div>
<div><font face="monospace, monospace">cqlsh:kamailio>
describe tables;</font></div>
<div><font face="monospace, monospace"><br>
</font></div>
<div><font face="monospace, monospace">globalblacklist
version userblacklist</font></div>
<div><font face="monospace, monospace"><br>
</font></div>
<div><font face="monospace, monospace">cqlsh:kamailio>
select * from version;</font></div>
<div><font face="monospace, monospace"><br>
</font></div>
<div><font face="monospace, monospace"> table_name |
table_version</font></div>
<div><font face="monospace, monospace">-----------------+---------------</font></div>
<div><font face="monospace, monospace"> uacreg |
2</font></div>
<div><font face="monospace, monospace"> version |
1</font></div>
<div><font face="monospace, monospace"> globalblacklist |
1</font></div>
<div><font face="monospace, monospace"> userblacklist |
1</font></div>
<div><font face="monospace, monospace"><br>
</font></div>
<div><font face="monospace, monospace">(4 rows)</font></div>
<div style="font-weight:bold"><br>
</div>
</div>
<div><br>
</div>
<div>Every time I start up Kamailio I see the following debug
logs:<br>
<br>
</div>
<div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:572]:
dbcassa_read_table_schemas(): Full name=
/etc/kamailio/kamailio/</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name=
/etc/kamailio/kamailio/version</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): <span
style="background-color:rgb(255,229,153)">Found database
version</span></font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table version</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/version/version</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:200]: dbcassa_load_file():
loading file [/etc/kamailio/kamailio/version/version]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:122]: dbcassa_table_new():
mtime is 1463068672</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [table_name]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[0] is STR!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[0] is actually STRING!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [table_version]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[1] is STR!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[1] is actually STRING!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [table_name] in primary key</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name=
/etc/kamailio/kamailio/userblacklist</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): <span
style="background-color:rgb(255,229,153)">Found database
userblacklist</span></font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table userblacklist</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/userblacklist/userblacklist</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:200]: dbcassa_load_file():
loading file
[/etc/kamailio/kamailio/userblacklist/userblacklist]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:122]: dbcassa_table_new():
mtime is 1462985556</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [id]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:258]: dbcassa_load_file():
column[0] is INT!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [username]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[1] is STR!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[1] is actually STRING!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [domain]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[2] is STR!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[2] is actually STRING!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [prefix]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[3] is STR!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[3] is actually STRING!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [whitelist]</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:258]: dbcassa_load_file():
column[4] is INT!</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [id] in primary key</font></div>
<div><font face="monospace, monospace"> 0(13877) DEBUG:
db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [username] in primary key</font></div>
</div>
<div>.....</div>
<div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
db_cassandra [dbcassa_base.cpp:149]:
db_cassa_new_connection(): opening connection: cassa://<a
moz-do-not-send="true"
href="http://xxxx:xxxx@127.0.0.1:9160/kamailio"><a class="moz-txt-link-abbreviated" href="mailto:xxxx:xxxx@127.0.0.1:9160/kamailio">xxxx:xxxx@127.0.0.1:9160/kamailio</a></a></font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
<core> [mem/f_malloc.c:439]: fm_malloc():
fm_malloc(0x7f4e36140010, 48) called from db_cassandra:
dbcassa_base.cpp: db_cassa_new_connection(155)</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
<core> [mem/f_malloc.c:514]: fm_malloc():
fm_malloc(0x7f4e36140010, 48) returns address
0x7f4e361bb5f0</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
db_cassandra [dbcassa_base.cpp:161]:
db_cassa_new_connection(): 0x7f4e361bb5f0=pkg_malloc(48)</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
db_cassandra [dbcassa_base.cpp:117]: dbcassa_open():
Opened connection to Cassandra cluster <a
moz-do-not-send="true" href="http://127.0.0.1:9160">127.0.0.1:9160</a></font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
db_cassandra [dbcassa_base.cpp:955]: db_cassa_query(): <span
style="background-color:rgb(255,229,153)">query
table=version</span></font></div>
<div><font face="monospace, monospace"> 0(12780) ERROR:
db_cassandra [dbcassa_base.cpp:449]: <b
style="background-color:rgb(255,229,153)">cassa_translate_query():
table version does not exist!</b></font></div>
<div><font face="monospace, monospace"> 0(12780) ERROR:
db_cassandra [dbcassa_base.cpp:962]: db_cassa_query(): <span
style="background-color:rgb(255,229,153)">Failed to
query Cassandra cluster</span></font></div>
<div><font face="monospace, monospace"> 0(12780) ERROR:
<core> [db.c:397]: db_table_version(): error in
db_query</font></div>
<div><font face="monospace, monospace"> 0(12780) ERROR:
<core> [db.c:436]: db_check_table_version():
querying version for table userblacklist</font></div>
<div><font face="monospace, monospace"> 0(12780) ERROR:
userblacklist [db_userblacklist.c:86]:
userblacklist_db_init(): during table version check.</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
<core> [db_pool.c:100]: pool_remove(): removing
connection from the pool</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
<core> [mem/f_malloc.c:575]: fm_free():
fm_free(0x7f4e36140010, 0x7f4e361bb5f0), called from
db_cassandra: dbcassa_base.cpp:
db_cassa_free_connection(203)</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
<core> [mem/f_malloc.c:594]: fm_free(): fm_free:
freeing block alloc'ed from db_cassandra:
dbcassa_base.cpp: db_cassa_new_connection(155)</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
<core> [mem/f_malloc.c:575]: fm_free():
fm_free(0x7f4e36140010, 0x7f4e361bb318), called from core:
db.c: db_do_close(356)</font></div>
<div><font face="monospace, monospace"> 0(12780) DEBUG:
<core> [mem/f_malloc.c:594]: fm_free(): fm_free:
freeing block alloc'ed from core: db.c: db_do_init2(298)</font></div>
<div><font face="monospace, monospace"> 0(12780) ERROR:
<core> [sr_module.c:968]: init_mod(): Error while
initializing module userblacklist
(/usr/local/lib64/kamailio/modules/userblacklist.so)</font></div>
<div><font face="monospace, monospace">ERROR: error while
initializing modules</font></div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Any help would be highly appreciated.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Sammy</div>
<div><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</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://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>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>