[SR-Users] kamailio with cassandra

[Никитенко Виталий]

Hi.
>> Can you provide more details for what you need it,maybe we can provide some hints?
I want to store the data of registered users (location) in the database cassandra (it would be great also dialog stored in cassandra). 
>>Can you provide access to a test system/vm where to try to fix it
Yes, I can it, will prepare today the VM for access to public network and send to email data access.

Thanks for the help.


> Hello,
>
> unfortunately the module was not maintained for a while. Can you provide
> access to a test system/vm where to try to fix it, because I don't use
> it and have no platform where to test?
>
> There is another module, ndb_cassandra, depending of what you want to
> do, it might help. Can you provide more details for what you need it,
> maybe we can provide some hints?
>
> Cheers,
> Daniel
>
> On 07/02/2017 10:55, Никитенко Виталий wrote:
>>  Hi!
>>  I want start kamailio with db_cassandra. do as it written in https://www.kamailio.org/docs/modules/4.2.x/modules/db_cassandra.html. Then trying kamctl start, failed with error "table version does not exist!".
>>  From CQLSH table is view
>>  cqlsh:kamailio> Describe tables;
>>  version location
>>
>>  cqlsh:kamailio> select * from version;
>>   table_name | table_version
>>  ------------+---------------
>>      version | 1
>>
>>  Tell me please wherein may be trouble? Full log below
>>
>>  ERROR: db_cassandra [dbcassa_table.c:592]: dbcassa_read_table_schemas(): Full dir name= /usr/local/etc/kamailio/cassandra/location
>>  ERROR: db_cassandra [dbcassa_table.c:592]: dbcassa_read_table_schemas(): Full dir name= /usr/local/etc/kamailio/cassandra/version
>>  INFO: rr [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob
>>  INFO: rr [rr_mod.c:160]: mod_init(): outbound module not available
>>  INFO: usrloc [hslot.c:53]: ul_init_locks(): locks array size 1024
>>  INFO: auth [auth_mod.c:350]: mod_init(): auth: qop set, but nonce-count (nc_enabled) support disabled
>>  INFO: permissions [parse_config.c:251]: parse_config_file(): file not found: /usr/local/etc/kamailio//permissions.allow
>>  INFO: permissions [permissions.c:608]: mod_init(): default allow file (/usr/local/etc/kamailio//permissions.allow) not found => empty rule set
>>  INFO: permissions [parse_config.c:251]: parse_config_file(): file not found: /usr/local/etc/kamailio//permissions.deny
>>  INFO: permissions [permissions.c:617]: mod_init(): default deny file (/usr/local/etc/kamailio//permissions.deny) not found => empty rule set
>>  INFO: misc_radius [misc_radius.c:164]: mod_init(): initializing...
>>  ERROR: db_cassandra [dbcassa_base.cpp:449]: cassa_translate_query(): table version does not exist!
>>  ERROR: db_cassandra [dbcassa_base.cpp:962]: db_cassa_query(): Failed to query Cassandra cluster
>>  ERROR: <core> [db.c:401]: db_table_version(): error in db_query
>>  ERROR: <core> [db.c:440]: db_check_table_version(): querying version for table location
>>  ERROR: usrloc [dlist.c:640]: register_udomain(): error during table version check.
>>  ERROR: registrar [reg_mod.c:554]: domain_fixup(): failed to register domain
>>  ERROR: <core> [route.c:1189]: fix_actions(): fixing failed (code=-1) at cfg:/usr/local/etc/kamailio//kamailio.cfg:982
>>  ERROR: <core> [route.c:1189]: fix_actions(): fixing failed (code=-1) at cfg:/usr/local/etc/kamailio//kamailio.cfg:987
>>  ERROR: <core> [route.c:1189]: fix_actions(): fixing failed (code=-1) at cfg:/usr/local/etc/kamailio//kamailio.cfg:992
>>
>>  _______________________________________________
>>  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
>
> --
> Daniel-Constantin Mierla
> www.twitter.com/miconda -- www.linkedin.com/in/miconda
> Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com
> Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com
>
> ------------------------------