Hello not sure what you want to accomplish, but in case it might help this is how we use the mtree module. Our 3 columns are: partition, prefix, route Partition is just a name that defines a group, this is done inside the script before calling mt_match (via a table lookup for instance). Let's say if a call comes from ip x we assign it to partition 400; if it comes from ip y we assign it to partition 401. Each partition is a different tree. Consider these entries in the tree table: 400,123456,A 401,123456,A 401,1234567,B
Let's say both x and y send a call with $rU 1234567; mt_match will return A for ip x, and B for ip y; we use that information for taking further routing decisions. A common situation might be: x has a unique route for a whole country while y has that entry but has more defined routes for more specific area codes inside that country. The column route could also be for instance the setid of a group of gw's for the dispatcher module, etc... Regards Javi > > Message: 3 > > Date: Tue, 14 Jun 2011 14:27:53 +0200 > > From: I?aki Baz Castillo <i...@aliax.net> > > Subject: Re: [SR-Users] Use of mtree module having multiple trees in > > the same table > > To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - > > Users Mailing List" <sr-users@lists.sip-router.org> > > Message-ID: <banlktim8h563kuy0yt9ptgosxj6w4qf...@mail.gmail.com> > > Content-Type: text/plain; charset=UTF-8 > > > > 2011/6/13 jose luis millan <doctor...@gmail.com>: > > > I wonder if anyone could help me understanding how can I use this > > > module in a scenario where multiple mtrees are defined behind the same > > > database table. > > > > > > I can't guess how to speficy to 'mt_match' the mtree I want to match > > > against, since the 'mtree' module parameter defines a specific memory > > > tree based on a specific table, but not based on a specific 'tname' > > > value. > > > > Indeed we have a table with these colums: > > > > - prefix: string to identify number destination. This is the regex > > column. > > - id_zone: integer, points to other table. This is the value column. > > - scope: integer, can be 0 or 1. > > > > So wee need two instances of mtree: > > 1) those rows with scope 0. > > 2) those rows with scope 1. > > > > Is it possible with current mtree module? or maybe we'd do better by > > creating two views of the table (one for entries with scope 0 and > > another for entries with scope 1)? > > > > Thanks a lot. > > > > -- > > I?aki Baz Castillo > > <i...@aliax.net> > > > > > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.sip-router.org/pipermail/sr-users/attachments/20110616/b928cbd3/attachment.htm > > > > ------------------------------ > > _______________________________________________ > sr-users mailing list > sr-users@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > > End of sr-users Digest, Vol 73, Issue 47 > **************************************** >
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
