[SR-Users] sr-users Digest, Vol 73, Issue 40

[Javier Gallart]

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 <ibc at 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 at lists.sip-router.org>
> Message-ID: <BANLkTim8h563kUy0YT9pTgOSXJ6W4Qf6ww at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> 2011/6/13 jose luis millan <doctore96 at 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
> <ibc at aliax.net>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110616/b928cbd3/attachment-0001.htm>