Hi,


If you are using cassandra-cli you can fill in the tables using something like this:

version table:

set version['location']['table_version']='1004';
set version['subscriber']['table_version']='6';

and the subscriber table:

set subscriber['userX']['domain']='domain.com';
set subscriber['userX']['password']='pass123';


Regards,
Anca


On 08/14/2012 04:26 PM, Boudewyn Ligthart wrote:

HI Anca,

 

Thanks for pointing me to the latest GIT version, this compiles as per normal.

 

Another question,

 

Have you got pointers on how to install the tables / setup Cassandra.

I have created the column families for location, subscriber, version but not yet filled these with data.

 

Regards

 

Bou

 

From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Anca Vamanu
Sent: 14 August 2012 13:39
To: sr-users@lists.sip-router.org
Subject: Re: [SR-Users] db_cassandra

 

Hi,


I tried compiling the module with the latest 3.1 from git and indeed it did not compile initially.
This very simple patch that is attached was needed. There were some problems with implicit casts.

I see that you are talking about 3.1.1 version, I have not tried with this exact version. You should maybe consider using the latest git for 3.1, it should also be more stable.


Regards,
Anca





On 08/14/2012 01:05 PM, Boudewyn Ligthart wrote:

Hi,

 

I am trying to get the db_cassandra working in kamailio 3.1.1 with thrift 0.6.1 API and however I get the following
compile error.

 

ol.h:33,

                 from dbcassa_base.h:38,

                 from dbcassa_base.cpp:47:

../../lib/srdb1/db.h:388:20: error: expected unqualified-id before âdeleteâ

dbcassa_base.cpp: In function âColumnVecPtr cassa_translate_query(const db1_con_t*, str* const*, const db_val_t*, str* const*, int, int, int*)â:

dbcassa_base.cpp:538:8: warning: format â%dâ expects argument of type âintâ, but argument 7 has type âstd::vector<org::apache::cassandra::KeySlice>::size_type {aka long unsigned int}â [-Wformat]

dbcassa_base.cpp:538:8: warning: format â%dâ expects argument of type âintâ, but argument 5 has type âstd::vector<org::apache::cassandra::KeySlice>::size_type {aka long unsigned int}â [-Wformat]

dbcassa_base.cpp:538:8: warning: format â%dâ expects argument of type âintâ, but argument 6 has type âstd::vector<org::apache::cassandra::KeySlice>::size_type {aka long unsigned int}â [-Wformat]

dbcassa_base.cpp:538:8: warning: format â%dâ expects argument of type âintâ, but argument 4 has type âstd::vector<org::apache::cassandra::KeySlice>::size_type {aka long unsigned int}â [-Wformat]

dbcassa_base.cpp:538:8: warning: format â%dâ expects argument of type âintâ, but argument 4 has type âstd::vector<org::apache::cassandra::KeySlice>::size_type {aka long unsigned int}â [-Wformat]

../../lib/srdb1/db_res.h: At global scope:

../../lib/srdb1/db_res.h:105:19: warning: inline function âdb1_res_t* db_new_result()â used but never defined [enabled by default]

../../lib/srdb1/db_res.h:121:12: warning: inline function âint db_allocate_columns(db1_res_t*, unsigned int)â used but never defined [enabled by default]

../../lib/srdb1/db_res.h:98:12: warning: inline function âint db_free_columns(db1_res_t*)â used but never defined [enabled by default]

../../lib/srdb1/db_res.h:129:12: warning: inline function âint db_allocate_rows(db1_res_t*)â used but never defined [enabled by default]

../../lib/srdb1/db_row.h:74:12: warning: inline function âint db_allocate_row(const db1_res_t*, db_row_t*)â used but never defined [enabled by default]

../../lib/srdb1/db_res.h:111:12: warning: inline function âint db_free_result(db1_res_t*)â used but never defined [enabled by default]

make[1]: *** [dbcassa_base.o] Error 1

make: *** [install-modules] Error 1

 

 

Anybody has got any ideas?

 

Thanks in advance,

 

Bou