<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Sasmita,<br>
<br>
It complains about the "subst_exp" field, which cannot be NULL at
all - used or not, cannot be NULL. If you do not need it , set it
to empty string.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 30.09.2015 15:48, Sasmita Panda
wrote:<br>
</div>
<blockquote
cite="mid:CALf-Q44w6wqUhpk2MWCsOeQG2NWEhBCEMZkk4qcYyd=gHRL02g@mail.gmail.com"
type="cite">
<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" : <a class="moz-txt-link-rfc2396E" href="mailto:.*@mongodb1-sasmita.com.*">".*@mongodb1-sasmita.com.*"</a>,
"groupid" : 2, "description" : "outbound" }</div>
<div>></div>
<div>> db.dr_gateways.find()</div>
<div>{ "_id" : ObjectId("560bd6cde6a5414c70de6ab4"), "gwid" :
1, "type" : 0, "address" : "<a moz-do-not-send="true"
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
moz-do-not-send="true" 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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>