<div dir="ltr">Hi again,<div><br></div><div>Yes read that thread from 1&1 guy as well. I believe yes I have thrift 0.6.1 - Lets see of upgrading the thrift has any impact. I opened a bug with github since the error seems to be coming from inside the dbcassa_table.c file entirely irrelevant to the other libraries.</div><div><br></div><div><br></div><div>Regards,</div><div>Sammy</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 12, 2016 at 4:41 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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><div class="h5">
<div>On 12/05/16 18:17, SamyGo wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<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 href="http://127.0.0.1:9160/kamailio" target="_blank">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 href="http://127.0.0.1:9042" target="_blank">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 href="http://xxxx:xxxx@127.0.0.1:9160/kamailio" target="_blank"></a><a href="mailto:xxxx:xxxx@127.0.0.1:9160/kamailio" target="_blank">xxxx:xxxx@127.0.0.1:9160/kamailio</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 href="http://127.0.0.1:9160" target="_blank">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></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
</font></span></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>