[SR-Users] db_cassandra

Anca Vamanu anca.vamanu at 1and1.ro
Mon Jan 23 14:08:31 CET 2012


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/db_cassandra.html#id2796778

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/db_cassandra.html
>>>>
>>>>
>>>>
>>>> Regards,
>>>> Anca
>>>>
>>>>
>>>> On 01/22/2012 09:16 AM, David wrote:
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>




More information about the sr-users mailing list