[OpenSIPS-Users] Dialplan error: fail to build rule

[Bogdan-Andrei Iancu]

Hi Sasmita,

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.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 30.09.2015 15:48, Sasmita Panda wrote:
> Hi All ,
>
>
>      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 .
>
>
> > db.dr_rules.find()
> { "_id" : ObjectId("560bd53b6562e8ba08918e76"), "ruleid" : 1, 
> "groupid" : 2, "priority" : 0, "routeid" : "NULL", "gwlist" : "1", 
> "attrs" : "NULL", "description" : "My number" }
> >
> > db.dr_groups.find()
> { "_id" : ObjectId("560bbbfc649b73342fe6b08e"), "username" : ".*", 
> "domain" : ".*@mongodb1-sasmita.com.*", "groupid" : 2, "description" : 
> "outbound" }
> >
> > db.dr_gateways.find()
> { "_id" : ObjectId("560bd6cde6a5414c70de6ab4"), "gwid" : 1, "type" : 
> 0, "address" : "192.168.1.1:5060 <http://192.168.1.1:5060>", "strips" 
> : 0, "pri_prefix" : "NULL", "attrs" : "NULL", "probe_mode" : 0, 
> "state" : 0, "socket" : "NULL", "description" : "1st gateway" }
> >
> > db.dr_carriers.find()
> { "_id" : ObjectId("560bbcc8649b73342fe6b091"), "carrierid" : 2, 
> "gwlist" : 1, "description" : "1st carrier" }
> >
> > db.dialplan.find()
> { "_id" : ObjectId("560bbae0649b73342fe6b08c"), "id" : 1, "dpid" : 5, 
> "pr" : 1, "match_op" : 0, "match_exp" : "mongodb11-sasmita.com 
> <http://mongodb11-sasmita.com>", "match_flags" : 1, "repl_exp" : 2, 
> "disabled" : 0 }
>
>
>     Now when I am running opensips its giving bellow error .
>
>  ERROR:dialplan:build_rule:  values 5 is NULL - not allowed
>  WARNING:dialplan:dp_load_db:  failed to build rule -> skipping
>  ERROR:drouting:dr_load_routing_info: column id has a bad type
>  CRITICAL:drouting:dr_reload_data: failed to load routing info
>  CRITICAL:drouting:dr_child_init: failed to load routing data
>  ERROR:core:init_mod_child: failed to initializing module drouting, rank 1
>  ERROR:core:main_loop: init_child failed for UDP listener
>
>        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 .
>
> */Thanks & Regards/*
> /Sasmita Panda/
> /Network Testing and Software Engineer/
> /3CLogic , ph:07827611765/
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150930/13ea0c61/attachment.htm>