Still seeing this message.
I have added a domain to cassandra to verify the data is there.
0(27209) DEBUG: db_cassandra [dbcassa_table.c:461]: found dbname=openser, table=version 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:350]: query col = table_name 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:375]: key = domain 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:495]: Query col: table_version 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:497]: get 1 columns 0(27209) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result set at 0x7f8fbf82c3d8 0(27209) DEBUG: <core> [db_res.c:155]: allocate 8 bytes for result names at 0x7f8fbf82c468 0(27209) DEBUG: <core> [db_res.c:165]: allocate 4 bytes for result types at 0x7f8fbf82c4d0 0(27209) DEBUG: db_cassandra [dbcassa_table.c:461]: found dbname=openser, table=version 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:627]: RES_NAMES(0x7f8fbf82c538)[0]=[table_version] 0(27209) DEBUG: <core> [db_res.c:184]: allocate 16 bytes for rows at 0x7f8fbf82c5a8 0(27209) DEBUG: <core> [db_row.c:119]: allocate 32 bytes for row values at 0x7f8fbf82c618 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:683]: Exited with success 0(27209) DEBUG: <core> [db_res.c:81]: freeing 1 columns 0(27209) DEBUG: <core> [db_res.c:85]: freeing RES_NAMES[0] at 0x7f8fbf82c538 0(27209) DEBUG: <core> [db_res.c:94]: freeing result names at 0x7f8fbf82c468 0(27209) DEBUG: <core> [db_res.c:99]: freeing result types at 0x7f8fbf82c4d0 0(27209) DEBUG: <core> [db_res.c:54]: freeing 1 rows 0(27209) DEBUG: <core> [db_row.c:97]: freeing row values at 0x7f8fbf82c618 0(27209) DEBUG: <core> [db_res.c:62]: freeing rows at 0x7f8fbf82c5a8 0(27209) DEBUG: <core> [db_res.c:136]: freeing result set at 0x7f8fbf82c3d8 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:570]: query table=domain 0(27209) DEBUG: db_cassandra [dbcassa_table.c:461]: found dbname=openser, table=domain 0(27209) ERROR: db_cassandra [dbcassa_base.cpp:361]: The key column with name [domain] not found in values 0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:375]: key = 0(27209) ERROR: db_cassandra [dbcassa_base.cpp:450]: Query not supported - key not provided 0(27209) ERROR: db_cassandra [dbcassa_base.cpp:577]: Failed to query Cassandra cluster 0(27209) ERROR: domain [domain.c:258]: Error while querying database 0(27209) ERROR: domain [domain_mod.c:219]: Domain table reload failed 0(27209) DEBUG: <core> [db_pool.c:102]: removing connection from the pool 0(27209) ERROR: <core> [sr_module.c:939]: init_mod(): Error while initializing module domain (/usr/local/lib64/kamailio/modules_k/domain.so) ERROR: error while initializing modules 0(27209) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start 0(27209) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying hash table 0(27209) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing semaphores 0(27209) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : destroying tmcb lists 0(27209) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done 0(27209) DEBUG: <core> [mem/shm_mem.c:242]: shm_mem_destroy 0(27209) DEBUG: <core> [mem/shm_mem.c:245]: destroying the shared memory lock
On 1/23/12 8:08 AM, Anca Vamanu wrote:
On 01/23/2012 02:58 PM, David wrote:
domain(string) last_modified(timestamp) domain
There is a problem in this schema: last_modified should not be of type timestamp, but int. The type timestamp has a special meaning in cassandra, you should use it only for columns that have the meaning of expires col [1]. I realise now that maybe I should change the name of this type, because I see it might be confusing.
[1] http://sip-router.org/docbook/sip-router/branch/master/modules/db_cassandra/...
Regards, Anca
On 1/23/12 7:45 AM, Anca Vamanu wrote:
Hi David,
How does you your table schema file for domain look like? I will try myself also with domain module when I have some time.
Regards, Anca
On 01/23/2012 02:23 PM, David wrote:
I know that it does not claim to support the "domain" module.
I am just posting the output in case there is something I can do to make it work.
0(22484) DEBUG: db_cassandra [dbcassa_base.cpp:570]: query table=domain 0(22484) DEBUG: db_cassandra [dbcassa_table.c:461]: found dbname=openser, table=domain 0(22484) ERROR: db_cassandra [dbcassa_base.cpp:361]: The key column with name [domain] not found in values 0(22484) DEBUG: db_cassandra [dbcassa_base.cpp:375]: key = 0(22484) ERROR: db_cassandra [dbcassa_base.cpp:450]: Query not supported - key not provided 0(22484) ERROR: db_cassandra [dbcassa_base.cpp:577]: Failed to query Cassandra cluster 0(22484) ERROR: domain [domain.c:258]: Error while querying database 0(22484) ERROR: domain [domain_mod.c:219]: Domain table reload failed 0(22484) DEBUG:<core> [db_pool.c:102]: removing connection from the pool 0(22484) ERROR:<core> [sr_module.c:939]: init_mod(): Error while initializing module domain (/usr/local/lib64/kamailio/modules_k/domain.so) ERROR: error while initializing modules 0(22484) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start 0(22484) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying hash table 0(22484) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing semaphores 0(22484) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : destroying tmcb lists 0(22484) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done 0(22484) DEBUG:<core> [mem/shm_mem.c:242]: shm_mem_destroy 0(22484) DEBUG:<core> [mem/shm_mem.c:245]: destroying the shared memory lock
On 1/23/12 4:05 AM, Anca Vamanu wrote:
Hi David,
As mentioned in the documentation[1], the module is compatible with thrift library version 0.6.1.
[1] http://sip-router.org/docbook/sip-router/branch/master/modules/db_cassandra/...
Regards, Anca
On 01/22/2012 09:16 AM, David wrote:
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users