New subject: Use of mtree module having multiple trees in the same table

16 Jun 2011

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 &lt;ibc(a)aliax.net&gt;
 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" &lt;sr-users(a)lists.sip-router.org&gt;
 Message-ID: &lt;BANLkTim8h563kUy0YT9pTgOSXJ6W4Qf6ww(a)mail.gmail.com&gt;
 Content-Type: text/plain; charset=UTF-8

 2011/6/13 jose luis millan &lt;doctore96(a)gmail.com&gt;om>:
  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
 &lt;ibc(a)aliax.net&gt;

Re: [SR-Users] Use of mtree module having multiple trees in the same table