<div dir="ltr">Hi All ,<div><br></div><div><br></div><div> I am using mongodb and opensips-1.11 . I am trying to use mongodb as a database for drouting and dialplan module . I have added the required data in mongodb . my mongodb looks like bellow .</div><div><br></div><div><br></div><div><div>> db.dr_rules.find()</div><div>{ "_id" : ObjectId("560bd53b6562e8ba08918e76"), "ruleid" : 1, "groupid" : 2, "priority" : 0, "routeid" : "NULL", "gwlist" : "1", "attrs" : "NULL", "description" : "My number" }</div><div>></div><div>> db.dr_groups.find()</div><div>{ "_id" : ObjectId("560bbbfc649b73342fe6b08e"), "username" : ".*", "domain" : ".*@mongodb1-sasmita.com.*", "groupid" : 2, "description" : "outbound" }</div><div>></div><div>> db.dr_gateways.find()</div><div>{ "_id" : ObjectId("560bd6cde6a5414c70de6ab4"), "gwid" : 1, "type" : 0, "address" : "<a href="http://192.168.1.1:5060">192.168.1.1:5060</a>", "strips" : 0, "pri_prefix" : "NULL", "attrs" : "NULL", "probe_mode" : 0, "state" : 0, "socket" : "NULL", "description" : "1st gateway" }</div><div>></div><div>> db.dr_carriers.find()</div><div>{ "_id" : ObjectId("560bbcc8649b73342fe6b091"), "carrierid" : 2, "gwlist" : 1, "description" : "1st carrier" }</div><div>></div><div>> db.dialplan.find()</div><div>{ "_id" : ObjectId("560bbae0649b73342fe6b08c"), "id" : 1, "dpid" : 5, "pr" : 1, "match_op" : 0, "match_exp" : "<a href="http://mongodb11-sasmita.com">mongodb11-sasmita.com</a>", "match_flags" : 1, "repl_exp" : 2, "disabled" : 0 }</div><div><br></div></div><div><br></div><div> Now when I am running opensips its giving bellow error .</div><div><br></div><div><div> ERROR:dialplan:build_rule: values 5 is NULL - not allowed</div><div> WARNING:dialplan:dp_load_db: failed to build rule -> skipping</div><div> ERROR:drouting:dr_load_routing_info: column id has a bad type</div><div> CRITICAL:drouting:dr_reload_data: failed to load routing info</div><div> CRITICAL:drouting:dr_child_init: failed to load routing data</div><div> ERROR:core:init_mod_child: failed to initializing module drouting, rank 1</div><div> ERROR:core:main_loop: init_child failed for UDP listener</div><div><br></div><div> Can anybody please suggest how to add the entries in mongodb so that these errors can be solved . Waiting for a positive and quick response .</div><div><br></div><div><div class="gmail_signature"><div dir="ltr"><b><i>Thanks & Regards</i></b><div><i>Sasmita Panda</i></div><div><i>Network Testing and Software Engineer</i></div><div><i>3CLogic , ph:07827611765</i></div></div></div></div>
</div></div>