Hello,

It is working now, so summarizing  about what we need to do in mongodb to kamailio starts up is:

Access to Mongodb cli

Create databases kamailio

> use kamailio
switched to db kamailio
> 
> db
kamailio


create collection named version

> db.createCollection("version")
> show collections
system.indexes
version
> 

Add the records for the tables version

> db.getCollection("version").insert({table_name: "presentity", table_version: NumberInt(4) })
WriteResult({ "nInserted" : 1 })

> db.getCollection("version").insert({table_name: "watchers", table_version: NumberInt(3) })
WriteResult({ "nInserted" : 1 })

db.getCollection("version").insert({table_name: "active_watchers", table_version: NumberInt(11) })
WriteResult({ "nInserted" : 1 })

Thank you for your help
Best Regards
José Seabra

2015-08-18 13:10 GMT+01:00 Daniel-Constantin Mierla <miconda@gmail.com>:
Hello,

if I remember correctly, the default type for numbers is float/double. You have to use a special form/function in mongo client when inserting a record to force the type of the value to be integer.

Perhaps searching on the web of how to insert an integer value in mongodb will give you the proper hings.

Cheers,
Daniel

On 18/08/15 13:17, José Seabra wrote:
Hi,
Well i didn't noticed before, but after create a document in mongodb the error that kamailio gives now is different but it still  related with table version check.

Seems that kamailio can query the document successfully and get the table_version field.

 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:671]: db_mongodb_convert_result(): selected document: { "_id" : { "$oid" : "55d2fc84b04c015195aee4b2" }, "table_version" : 4 }
 0(3068) DEBUG: <core> [db_row.c:117]: db_allocate_row(): allocate 32 bytes for row values at 0x7fe6fee76390
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:522]: db_mongodb_convert_bson(): looking for field[0] named: table_version
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:610]: db_mongodb_convert_bson(): RES_NAMES(0x7fe6fee72490)[0]=[table_version] (1)
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:682]: db_mongodb_convert_result(): retrieved number of rows: 1
 0(3068) ERROR: <core> [db.c:414]: db_table_version(): invalid type (2) or nul (0) version columns for presentity



ALL Log:

Listening on 
             udp: 10.0.20.100:5080
Aliases: 

 0(3066) DEBUG: <core> [cfg/cfg.c:176]: cfg_declare(): DEBUG: register_cfg_def(): new config group has been registered: 'core' (num=50, size=200)
 0(3066) DEBUG: <core> [cfg/cfg.c:176]: cfg_declare(): DEBUG: register_cfg_def(): new config group has been registered: 'tcp' (num=26, size=104)
 0(3066) DEBUG: <core> [timer.c:255]: init_timer(): starting with *ticks=1210106959
 0(3066) DEBUG: <core> [timer.c:297]: init_timer(): timer_list between 0x7fe6ebf85728 and 0x7fe6ebfc9728
 0(3066) INFO: <core> [tcp_main.c:4656]: init_tcp(): using epoll_lt as the io watch method (auto detected)
 0(3068) DEBUG: <core> [daemonize.c:207]: enable_dumpable(): trying enable core dumping...
 0(3068) DEBUG: <core> [daemonize.c:225]: enable_dumpable(): core dumping is enabled now (1)...
 0(3068) DEBUG: <core> [daemonize.c:583]: set_core_dump(): core dump limits set to 18446744073709551615
 0(3068) DEBUG: <core> [async_task.c:88]: async_task_init(): start initializing asynk task framework
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): db_text
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): db_mysql
 0(3068) DEBUG: db_mysql [km_db_mysql.c:86]: kam_mysql_mod_init(): MySQL client version is 5.1.73
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): db_mongodb
 0(3068) DEBUG: db_mongodb [db_mongodb_mod.c:98]: mod_init(): module initializing
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): sl
 0(3068) DEBUG: <core> [md5utils.c:67]: MD5StringArray(): MD5 calculated: f452807bca511b98621cbbe6e749d8ef
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <load_tm> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) ERROR: tm [tm_load.c:37]: load_tm(): tm:load_tm: Module not initialized yet, make sure that all modules that need tm module are loaded after tm in the configuration file
 0(3068) INFO: sl [sl.c:157]: mod_init(): could not bind tm module - only stateless mode available during modules initialization
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): maxfwd
 0(3068) DEBUG: <core> [cfg/cfg.c:176]: cfg_declare(): DEBUG: register_cfg_def(): new config group has been registered: 'maxfwd' (num=1, size=4)
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): textops
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): tm
 0(3068) DEBUG: tm [tm.c:756]: mod_init(): TM - (sizeof cell=488, sip_msg=1768) initializing...
 0(3068) DEBUG: tm [callid.c:101]: init_callid(): Call-ID initialization: '76bf762544f60619'
 0(3068) DEBUG: tm [lock.c:74]: lock_initialize(): DEBUG: lock_initialize: lock initialization started
 0(3068) DEBUG: tm [timer.c:199]: tm_init_timers(): tm: tm_init_timers: fr=480 fr_inv=1920 wait=80 delete=4 t1=500 t2=4000 max_inv_lifetime=2880 max_noninv_lifetime=512
 0(3068) DEBUG: <core> [cfg/cfg.c:176]: cfg_declare(): DEBUG: register_cfg_def(): new config group has been registered: 'tm' (num=36, size=168)
 0(3068) DEBUG: <core> [md5utils.c:67]: MD5StringArray(): MD5 calculated: eabd4dc455c32eca91da2be9405373ce
 0(3068) DEBUG: <core> [md5utils.c:67]: MD5StringArray(): MD5 calculated: 176231eb72a239b3e7f931a1ef6c4100
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): rr
 0(3068) DEBUG: <core> [sr_module.c:678]: find_mod_export_record(): find_export_record: <bind_ob> not found 
 0(3068) INFO: rr [../outbound/api.h:54]: ob_load_api(): Failed to import bind_ob
 0(3068) INFO: rr [rr_mod.c:174]: mod_init(): outbound module not available
 0(3068) DEBUG: <core> [sr_module.c:942]: init_mod(): presence
 0(3068) DEBUG: presence [presence.c:274]: mod_init(): db_url=mongodb://localhost/kamailio/28/0x7fe6fee55608
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <bind_sl> in module sl [/usr/local/lib64/kamailio/modules/sl.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <load_tm> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <t_newtran> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <t_relay_to_tcp> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <t_relay_to_udp> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <t_relay> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <t_forward_nonack> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <t_release> in module tm [/usr/local/lib64/kamailio/modules/tm.so]
 0(3068) DEBUG: <core> [sr_module.c:672]: find_mod_export_record(): find_export_record: found <db_bind_api> in module db_mongodb [/usr/local/lib64/kamailio/modules/db_mongodb.so]
 0(3068) DEBUG: <core> [db.c:205]: db_bind_mod(): using db bind api for db_mongodb
 0(3068) DEBUG: <core> [db.c:310]: db_do_init2(): connection 0x7fe6fee72190 not found in pool
 0(3068) DEBUG: db_mongodb [mongodb_connection.c:55]: db_mongodb_new_connection(): connection open to: mongodb://localhost/kamailio
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:851]: db_mongodb_query(): query to collection [version]
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:885]: db_mongodb_query(): query filter: { "table_name" : "presentity" }
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:904]: db_mongodb_query(): columns filter: { "table_version" : 1 }
 0(3068) DEBUG: <core> [db_res.c:116]: db_new_result(): allocate 56 bytes for result set at 0x7fe6fee72338
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:349]: db_mongodb_get_columns(): 1 columns returned from the query
 0(3068) DEBUG: <core> [db_res.c:154]: db_allocate_columns(): allocate 8 bytes for result names at 0x7fe6fee72410
 0(3068) DEBUG: <core> [db_res.c:165]: db_allocate_columns(): allocate 4 bytes for result types at 0x7fe6fee72450
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:377]: db_mongodb_get_columns(): Found a field[0] named: table_version
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:396]: db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7fe6fee72490
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:416]: db_mongodb_get_columns(): use DB1_DOUBLE result type
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:460]: db_mongodb_get_columns(): RES_NAMES(0x7fe6fee72490)[0]=[table_version] (1)
 0(3068) DEBUG: <core> [db_res.c:184]: db_allocate_rows(): allocate 16000 bytes for rows at 0x7fe6fee724d8
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:671]: db_mongodb_convert_result(): selected document: { "_id" : { "$oid" : "55d2fc84b04c015195aee4b2" }, "table_version" : 4 }
 0(3068) DEBUG: <core> [db_row.c:117]: db_allocate_row(): allocate 32 bytes for row values at 0x7fe6fee76390
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:522]: db_mongodb_convert_bson(): looking for field[0] named: table_version
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:610]: db_mongodb_convert_bson(): RES_NAMES(0x7fe6fee72490)[0]=[table_version] (1)
 0(3068) DEBUG: db_mongodb [mongodb_dbase.c:682]: db_mongodb_convert_result(): retrieved number of rows: 1
 0(3068) ERROR: <core> [db.c:414]: db_table_version(): invalid type (2) or nul (0) version columns for presentity
 0(3068) DEBUG: <core> [db_res.c:79]: db_free_columns(): freeing 1 columns
 0(3068) DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[0] at 0x7fe6fee72490
 0(3068) DEBUG: <core> [db_res.c:92]: db_free_columns(): freeing result names at 0x7fe6fee72410
 0(3068) DEBUG: <core> [db_res.c:97]: db_free_columns(): freeing result types at 0x7fe6fee72450
 0(3068) DEBUG: <core> [db_res.c:52]: db_free_rows(): freeing 1 rows
 0(3068) DEBUG: <core> [db_row.c:95]: db_free_row(): freeing row values at 0x7fe6fee76390
 0(3068) DEBUG: <core> [db_res.c:60]: db_free_rows(): freeing rows at 0x7fe6fee724d8
 0(3068) DEBUG: <core> [db_res.c:134]: db_free_result(): freeing result set at 0x7fe6fee72338
 0(3068) ERROR: <core> [db.c:432]: db_check_table_version(): querying version for table presentity
 0(3068) ERROR: presence [presence.c:358]: mod_init(): error during table version check
 0(3068) 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
 0(3068) DEBUG: <core> [db_pool.c:100]: pool_remove(): removing connection from the pool
 0(3068) DEBUG: tm [t_funcs.c:86]: tm_shutdown(): DEBUG: tm_shutdown : start
 0(3068) DEBUG: tm [t_funcs.c:89]: tm_shutdown(): DEBUG: tm_shutdown : emptying hash table
 0(3068) DEBUG: tm [t_funcs.c:91]: tm_shutdown(): DEBUG: tm_shutdown : removing semaphores
 0(3068) DEBUG: tm [t_funcs.c:93]: tm_shutdown(): DEBUG: tm_shutdown : destroying tmcb lists
 0(3068) DEBUG: tm [t_funcs.c:96]: tm_shutdown(): DEBUG: tm_shutdown : done
 0(3068) DEBUG: db_text [dbtext.c:106]: destroy(): destroy ...
 0(3068) INFO: <core> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
 0(3068) DEBUG: <core> [mem/shm_mem.c:232]: shm_mem_destroy(): shm_mem_destroy
 0(3068) DEBUG: <core> [mem/shm_mem.c:235]: shm_mem_destroy(): destroying the shared memory lock


Best regards

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com



--
Cumprimentos
José Seabra