Hello<br><br>not sure what you want to accomplish, but in case it might help this is how we use the mtree module.<br>Our 3 columns are: partition, prefix, route<br>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:<br>
400,123456,A<br>401,123456,A<br>401,1234567,B<br><br>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...<br>
<br>Regards<br><br>Javi<br><br><br><div class="gmail_quote"><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Message: 3<br>
Date: Tue, 14 Jun 2011 14:27:53 +0200<br>
From: I?aki Baz Castillo <<a href="mailto:ibc@aliax.net">ibc@aliax.net</a>><br>
Subject: Re: [SR-Users] Use of mtree module having multiple trees in<br>
the same table<br>
To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) -<br>
Users Mailing List" <<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>><br>
Message-ID: <<a href="mailto:BANLkTim8h563kUy0YT9pTgOSXJ6W4Qf6ww@mail.gmail.com">BANLkTim8h563kUy0YT9pTgOSXJ6W4Qf6ww@mail.gmail.com</a>><br>
Content-Type: text/plain; charset=UTF-8<br>
<br>
2011/6/13 jose luis millan <<a href="mailto:doctore96@gmail.com">doctore96@gmail.com</a>>:<br>
> I wonder if anyone could help me understanding how can I use this<br>
> module in a scenario where multiple mtrees are defined behind the same<br>
> database table.<br>
><br>
> I can't guess how to speficy to 'mt_match' the mtree I want to match<br>
> against, since the 'mtree' module parameter defines a specific memory<br>
> tree based on a specific table, but not based on a specific 'tname'<br>
> value.<br>
<br>
Indeed we have a table with these colums:<br>
<br>
- prefix: string to identify number destination. This is the regex column.<br>
- id_zone: integer, points to other table. This is the value column.<br>
- scope: integer, can be 0 or 1.<br>
<br>
So wee need two instances of mtree:<br>
1) those rows with scope 0.<br>
2) those rows with scope 1.<br>
<br>
Is it possible with current mtree module? or maybe we'd do better by<br>
creating two views of the table (one for entries with scope 0 and<br>
another for entries with scope 1)?<br>
<br>
Thanks a lot.<br>
<br>
--<br>
I?aki Baz Castillo<br>
<<a href="mailto:ibc@aliax.net">ibc@aliax.net</a>><br>
<br>
<br>
<br></blockquote></div>