[SR-Users] db_cassandra

[David]

Yes,

I should of mentioned this. I did make that change.

I am not sure it still works.

I am also going to go to the office now.

So I will check when I get to work.

But you think this should be supported?

Thanks.




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/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
>>
>
>
> _______________________________________________
> 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