[SR-Users] kamailio presence server using db_mongodb as database

[José Seabra]

Hi Daniel,

Thank you for your reply,

I did what you suggested in your last email, but the issue remains, maybe i
did something wrong, so in order we try understand if i did or not
something wrong please have a look at the mongodb commands to create db,
collection and document.

> use kamailio
switched to db kamailio
>
> db
kamailio
> db.createCollection("version")
> show collections
system.indexes
version
>
> db.getCollection("version").insert({table_name: "presentity",
table_version: 4 })
WriteResult({ "nInserted" : 1 })
> db.getCollection("version").find({})
{ "_id" : ObjectId("55d2fb67b04c015195aee4b1"), "table_name" :
"presentity", "table_version" : 4 }

Best Regards
José Seabra




2015-08-18 7:09 GMT+01:00 Daniel-Constantin Mierla <miconda at gmail.com>:

> Indeed the issue is related to checking the version table. You have to
> create a collection named "version" in kamailio database, then add the
> records for the tables you are using with the fields:
>
>   - table_name corresponding to the table name (e.g., presentity)
>   - table_version value as in lib/srdb1/schema/* (e.g., 4)
>
> If you have kamailio database created in mysql (or other sql server), you
> can simply look at the content of table "version".
>
> If I get to better internet connection while traveling these days, I will
> try to put together proper guidelines.
>
> Cheers,
> Daniel
>
>
> On 17/08/15 19:10, José Seabra wrote:
>
> This shouldn't check the table version in mongodb or i'm wrong?
> Best regards
>
> 2015-08-17 16:45 GMT+01:00 José Seabra <joseseabra4 at gmail.com>:
>
>> I have tried that but kamailio gave me the following error:
>>
>>  0(2344) ERROR: <core> [db.c:435]: db_check_table_version(): invalid
>> version 0 for table presentity found, expected 4 (check table structure and
>> table "version")
>>  0(2344) ERROR: presence [presence.c:358]: mod_init(): error during table
>> version check
>>  0(2344) ERROR: <core> [sr_module.c:945]: init_mod(): Error while
>> initializing module presence (/usr/local/lib64/kamailio/modules/presence.so)
>> ERROR: error while initializing modules
>>
>>
>>
>> Presence module configuration:
>>
>> modparam("presence", "server_address", "sip:10.0.20.100:5080")
>> modparam("presence", "subs_db_mode", 3)
>> modparam("presence", "expires_offset", 60)
>> modparam("presence", "send_fast_notify", 0)
>> modparam("presence", "clean_period", 30)
>> modparam("presence", "publ_cache", 0)
>> modparam("presence", "sip_uri_match", 1)
>> modparam("presence", "waitn_time", 1)
>> modparam("presence", "notifier_processes", 0)
>> modparam("presence", "db_url", "mongodb://localhost/kamailio")
>>
>> Best Regards
>> José Seabra
>>
>>
>> 2015-08-17 16:33 GMT+01:00 Daniel-Constantin Mierla <miconda at gmail.com>:
>>
>>> Hello,
>>>
>>> do not remember exactly if you need to create an empty collection,
>>> anyhow, the main idea is that there is no table definition, because mongo
>>> is a document-storage like engine. The records store all the details about
>>> all the fields.
>>>
>>> In other words, you should be ready to go after basic setup of mongodb
>>> collection and configuring kamailio modules to use the server.
>>>
>>> Cheers,
>>> Daniel
>>>
>>>
>>> On 17/08/15 16:51, José Seabra wrote:
>>>
>>> Hello all,
>>> I would like to test my presence server using db_mongodb as database
>>> server instead of using mysql, but i don't find any documentation
>>> explaining how i can configure mongodb database(data structure) for
>>> presence or even for the other kamailio modules.
>>>
>>> Can someone  guide me in this setup?
>>>
>>> Best Regards
>>>
>>> --
>>> Cumprimentos
>>> José Seabra
>>>
>>>
>>> _______________________________________________
>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>
>>>
>>> --
>>> Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>>> Book: SIP Routing With Kamailio - http://www.asipto.com
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>> Cumprimentos
>> José Seabra
>>
>
>
>
> --
> Cumprimentos
> José Seabra
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Book: SIP Routing With Kamailio - http://www.asipto.com
>
>


-- 
Cumprimentos
José Seabra
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20150818/0588224f/attachment.html>