12 May
2016
12 May
'16
12:17 p.m.
Hi List,
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.
Here is setup info:
version: kamailio 4.4.1
*kamailio.cfg*
...
loadmodule "db_cassandra.so"
modparam("db_cassandra",
"schema_path","/etc/kamailio/kamailio")
loadmodule "userblacklist.so"
modparam("userblacklist", "db_url",
"cassandra://:@127.0.0.1:9160/kamailio")
modparam("userblacklist", "userblacklist_table",
"userblacklist")
modparam("userblacklist", "globalblacklist_table",
"globalblacklist")
*SCHEMA PATH:*
root@whit-list:/etc/kamailio/kamailio# ls
userblacklist version
root@whit-list:/etc/kamailio/kamailio# cat version/version
table_name(string) table_version(int)
table_name
root@whit-list:/etc/kamailio/kamailio# cat userblacklist/userblacklist
id(int) username(string) domain(string) prefix(string) whitelist(int)
id username
*CASSANDRA DB*
root@whit-list:/etc/kamailio/kamailio# cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.5 | CQL spec 3.4.0 | Native protocol v4]
Use HELP for help.
cqlsh> use kamailio
... ;
cqlsh:kamailio> describe tables;
globalblacklist version userblacklist
cqlsh:kamailio> select * from version;
table_name | table_version
-----------------+---------------
uacreg | 2
version | 1
globalblacklist | 1
userblacklist | 1
(4 rows)
Every time I start up Kamailio I see the following debug logs:
0(13877) DEBUG: db_cassandra [dbcassa_table.c:572]:
dbcassa_read_table_schemas(): Full name= /etc/kamailio/kamailio/
0(13877) DEBUG: db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name= /etc/kamailio/kamailio/version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): Found database version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/version/version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:200]: dbcassa_load_file():
loading file [/etc/kamailio/kamailio/version/version]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:122]: dbcassa_table_new():
mtime is 1463068672
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [table_name]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[0] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[0] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [table_version]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[1] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[1] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [table_name] in primary key
0(13877) DEBUG: db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name=
/etc/kamailio/kamailio/userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): Found database userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/userblacklist/userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:200]: dbcassa_load_file():
loading file [/etc/kamailio/kamailio/userblacklist/userblacklist]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:122]: dbcassa_table_new():
mtime is 1462985556
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [id]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:258]: dbcassa_load_file():
column[0] is INT!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [username]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[1] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[1] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [domain]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[2] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[2] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [prefix]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[3] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[3] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [whitelist]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:258]: dbcassa_load_file():
column[4] is INT!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [id] in primary key
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [username] in primary key
.....
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:149]:
db_cassa_new_connection(): opening connection: cassa://
xxxx:xxxx@127.0.0.1:9160/kamailio
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)
0(12780) DEBUG: <core> [mem/f_malloc.c:514]: fm_malloc():
fm_malloc(0x7f4e36140010, 48) returns address 0x7f4e361bb5f0
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:161]:
db_cassa_new_connection(): 0x7f4e361bb5f0=pkg_malloc(48)
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:117]: dbcassa_open():
Opened connection to Cassandra cluster 127.0.0.1:9160
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:955]: db_cassa_query(): query
table=version
0(12780) ERROR: db_cassandra [dbcassa_base.cpp:449]: *cassa_translate_query():
table version does not exist!*
0(12780) ERROR: db_cassandra [dbcassa_base.cpp:962]: db_cassa_query(): Failed
to query Cassandra cluster
0(12780) ERROR: <core> [db.c:397]: db_table_version(): error in db_query
0(12780) ERROR: <core> [db.c:436]: db_check_table_version(): querying
version for table userblacklist
0(12780) ERROR: userblacklist [db_userblacklist.c:86]:
userblacklist_db_init(): during table version check.
0(12780) DEBUG: <core> [db_pool.c:100]: pool_remove(): removing connection
from the pool
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)
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)
0(12780) DEBUG: <core> [mem/f_malloc.c:575]: fm_free():
fm_free(0x7f4e36140010, 0x7f4e361bb318), called from core: db.c:
db_do_close(356)
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)
0(12780) ERROR: <core> [sr_module.c:968]: init_mod(): Error while
initializing module userblacklist
(/usr/local/lib64/kamailio/modules/userblacklist.so)
ERROR: error while initializing modules
Any help would be highly appreciated.
Regards,
Sammy
12 May
12 May
4:41 p.m.
Hello,
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.
Are you using the old cassandra lib version?
Cheers,
Daniel
On 12/05/16 18:17, SamyGo wrote:
Hi List,
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.
Here is setup info:
version: kamailio 4.4.1
*kamailio.cfg*
...
loadmodule "db_cassandra.so"
modparam("db_cassandra",
"schema_path","/etc/kamailio/kamailio")
loadmodule "userblacklist.so"
modparam("userblacklist", "db_url",
"cassandra://:@127.0.0.1:9160/kamailio
<http://127.0.0.1:9160/kamailio>")
modparam("userblacklist", "userblacklist_table",
"userblacklist")
modparam("userblacklist", "globalblacklist_table",
"globalblacklist")
*SCHEMA PATH:*
root@whit-list:/etc/kamailio/kamailio# ls
userblacklist version
root@whit-list:/etc/kamailio/kamailio# cat version/version
table_name(string) table_version(int)
table_name
root@whit-list:/etc/kamailio/kamailio# cat userblacklist/userblacklist
id(int) username(string) domain(string) prefix(string) whitelist(int)
id username
*CASSANDRA DB*
root@whit-list:/etc/kamailio/kamailio# cqlsh
Connected to Test Cluster at 127.0.0.1:9042 <http://127.0.0.1:9042>.
[cqlsh 5.0.1 | Cassandra 3.5 | CQL spec 3.4.0 | Native protocol v4]
Use HELP for help.
cqlsh> use kamailio
... ;
cqlsh:kamailio> describe tables;
globalblacklist version userblacklist
cqlsh:kamailio> select * from version;
table_name | table_version
-----------------+---------------
uacreg | 2
version | 1
globalblacklist | 1
userblacklist | 1
(4 rows)
Every time I start up Kamailio I see the following debug logs:
0(13877) DEBUG: db_cassandra [dbcassa_table.c:572]:
dbcassa_read_table_schemas(): Full name= /etc/kamailio/kamailio/
0(13877) DEBUG: db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name=
/etc/kamailio/kamailio/version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): Found database version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/version/version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:200]:
dbcassa_load_file(): loading file [/etc/kamailio/kamailio/version/version]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:122]:
dbcassa_table_new(): mtime is 1463068672
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]:
dbcassa_load_file(): new col [table_name]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]:
dbcassa_load_file(): column[0] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]:
dbcassa_load_file(): column[0] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]:
dbcassa_load_file(): new col [table_version]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]:
dbcassa_load_file(): column[1] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]:
dbcassa_load_file(): column[1] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]:
dbcassa_load_file(): col [table_name] in primary key
0(13877) DEBUG: db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name=
/etc/kamailio/kamailio/userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): Found database userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/userblacklist/userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:200]:
dbcassa_load_file(): loading file
[/etc/kamailio/kamailio/userblacklist/userblacklist]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:122]:
dbcassa_table_new(): mtime is 1462985556
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]:
dbcassa_load_file(): new col [id]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:258]:
dbcassa_load_file(): column[0] is INT!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]:
dbcassa_load_file(): new col [username]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]:
dbcassa_load_file(): column[1] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]:
dbcassa_load_file(): column[1] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]:
dbcassa_load_file(): new col [domain]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]:
dbcassa_load_file(): column[2] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]:
dbcassa_load_file(): column[2] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]:
dbcassa_load_file(): new col [prefix]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]:
dbcassa_load_file(): column[3] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]:
dbcassa_load_file(): column[3] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]:
dbcassa_load_file(): new col [whitelist]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:258]:
dbcassa_load_file(): column[4] is INT!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]:
dbcassa_load_file(): col [id] in primary key
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]:
dbcassa_load_file(): col [username] in primary key
.....
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:149]:
db_cassa_new_connection(): opening connection:
cassa://xxxx:xxxx@127.0.0.1:9160/kamailio
<http://xxxx:xxxx@127.0.0.1:9160/kamailio>
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)
0(12780) DEBUG: <core> [mem/f_malloc.c:514]: fm_malloc():
fm_malloc(0x7f4e36140010, 48) returns address 0x7f4e361bb5f0
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:161]:
db_cassa_new_connection(): 0x7f4e361bb5f0=pkg_malloc(48)
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:117]: dbcassa_open():
Opened connection to Cassandra cluster 127.0.0.1:9160
<http://127.0.0.1:9160>
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:955]:
db_cassa_query(): query table=version
0(12780) ERROR: db_cassandra [dbcassa_base.cpp:449]:
*cassa_translate_query(): table version does not exist!*
0(12780) ERROR: db_cassandra [dbcassa_base.cpp:962]:
db_cassa_query(): Failed to query Cassandra cluster
0(12780) ERROR: <core> [db.c:397]: db_table_version(): error in db_query
0(12780) ERROR: <core> [db.c:436]: db_check_table_version(): querying
version for table userblacklist
0(12780) ERROR: userblacklist [db_userblacklist.c:86]:
userblacklist_db_init(): during table version check.
0(12780) DEBUG: <core> [db_pool.c:100]: pool_remove(): removing
connection from the pool
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)
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)
0(12780) DEBUG: <core> [mem/f_malloc.c:575]: fm_free():
fm_free(0x7f4e36140010, 0x7f4e361bb318), called from core: db.c:
db_do_close(356)
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)
0(12780) ERROR: <core> [sr_module.c:968]: init_mod(): Error while
initializing module userblacklist
(/usr/local/lib64/kamailio/modules/userblacklist.so)
ERROR: error while initializing modules
Any help would be highly appreciated.
Regards,
Sammy
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
5:11 p.m.
Hi again,
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.
Regards,
Sammy
On Thu, May 12, 2016 at 4:41 PM, Daniel-Constantin Mierla <miconda(a)gmail.com
wrote:
Hello,
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.
Are you using the old cassandra lib version?
Cheers,
Daniel
On 12/05/16 18:17, SamyGo wrote:
Hi List,
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.
Here is setup info:
version: kamailio 4.4.1
*kamailio.cfg*
...
loadmodule "db_cassandra.so"
modparam("db_cassandra",
"schema_path","/etc/kamailio/kamailio")
loadmodule "userblacklist.so"
modparam("userblacklist", "db_url",
"cassandra://:@127.0.0.1:9160/kamailio
")
modparam("userblacklist", "userblacklist_table",
"userblacklist")
modparam("userblacklist", "globalblacklist_table",
"globalblacklist")
*SCHEMA PATH:*
root@whit-list:/etc/kamailio/kamailio# ls
userblacklist version
root@whit-list:/etc/kamailio/kamailio# cat version/version
table_name(string) table_version(int)
table_name
root@whit-list:/etc/kamailio/kamailio# cat userblacklist/userblacklist
id(int) username(string) domain(string) prefix(string) whitelist(int)
id username
*CASSANDRA DB*
root@whit-list:/etc/kamailio/kamailio# cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.5 | CQL spec 3.4.0 | Native protocol v4]
Use HELP for help.
cqlsh> use kamailio
... ;
cqlsh:kamailio> describe tables;
globalblacklist version userblacklist
cqlsh:kamailio> select * from version;
table_name | table_version
-----------------+---------------
uacreg | 2
version | 1
globalblacklist | 1
userblacklist | 1
(4 rows)
Every time I start up Kamailio I see the following debug logs:
0(13877) DEBUG: db_cassandra [dbcassa_table.c:572]:
dbcassa_read_table_schemas(): Full name= /etc/kamailio/kamailio/
0(13877) DEBUG: db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name= /etc/kamailio/kamailio/version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): Found database version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/version/version
0(13877) DEBUG: db_cassandra [dbcassa_table.c:200]: dbcassa_load_file():
loading file [/etc/kamailio/kamailio/version/version]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:122]: dbcassa_table_new():
mtime is 1463068672
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [table_name]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[0] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[0] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [table_version]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[1] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[1] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [table_name] in primary key
0(13877) DEBUG: db_cassandra [dbcassa_table.c:589]:
dbcassa_read_table_schemas(): Full dir name=
/etc/kamailio/kamailio/userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:609]:
dbcassa_read_table_schemas(): Found database userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:620]:
dbcassa_read_table_schemas(): database table userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:630]:
dbcassa_read_table_schemas(): File path=
/etc/kamailio/kamailio/userblacklist/userblacklist
0(13877) DEBUG: db_cassandra [dbcassa_table.c:200]: dbcassa_load_file():
loading file [/etc/kamailio/kamailio/userblacklist/userblacklist]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:122]: dbcassa_table_new():
mtime is 1462985556
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [id]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:258]: dbcassa_load_file():
column[0] is INT!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [username]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[1] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[1] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [domain]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[2] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[2] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [prefix]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:253]: dbcassa_load_file():
column[3] is STR!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:283]: dbcassa_load_file():
column[3] is actually STRING!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:240]: dbcassa_load_file():
new col [whitelist]
0(13877) DEBUG: db_cassandra [dbcassa_table.c:258]: dbcassa_load_file():
column[4] is INT!
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [id] in primary key
0(13877) DEBUG: db_cassandra [dbcassa_table.c:350]: dbcassa_load_file():
col [username] in primary key
.....
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:149]:
db_cassa_new_connection(): opening connection: cassa://
<http://xxxx:xxxx@127.0.0.1:9160/kamailio>
xxxx:xxxx@127.0.0.1:9160/kamailio
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)
0(12780) DEBUG: <core> [mem/f_malloc.c:514]: fm_malloc():
fm_malloc(0x7f4e36140010, 48) returns address 0x7f4e361bb5f0
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:161]:
db_cassa_new_connection(): 0x7f4e361bb5f0=pkg_malloc(48)
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:117]: dbcassa_open():
Opened connection to Cassandra cluster 127.0.0.1:9160
0(12780) DEBUG: db_cassandra [dbcassa_base.cpp:955]: db_cassa_query(): query
table=version
0(12780) ERROR: db_cassandra [dbcassa_base.cpp:449]: *cassa_translate_query():
table version does not exist!*
0(12780) ERROR: db_cassandra [dbcassa_base.cpp:962]: db_cassa_query(): Failed
to query Cassandra cluster
0(12780) ERROR: <core> [db.c:397]: db_table_version(): error in db_query
0(12780) ERROR: <core> [db.c:436]: db_check_table_version(): querying
version for table userblacklist
0(12780) ERROR: userblacklist [db_userblacklist.c:86]:
userblacklist_db_init(): during table version check.
0(12780) DEBUG: <core> [db_pool.c:100]: pool_remove(): removing
connection from the pool
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)
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)
0(12780) DEBUG: <core> [mem/f_malloc.c:575]: fm_free():
fm_free(0x7f4e36140010, 0x7f4e361bb318), called from core: db.c:
db_do_close(356)
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)
0(12780) ERROR: <core> [sr_module.c:968]: init_mod(): Error while
initializing module userblacklist
(/usr/local/lib64/kamailio/modules/userblacklist.so)
ERROR: error while initializing modules
Any help would be highly appreciated.
Regards,
Sammy
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierlahttp://www.asipto.comhttp://twitter.com/#!/miconda -
http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3204
days inactive
3204
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
SamyGo