[OpenSIPS-Users] grp, and dr_grp

Duane Larson duane.larson at gmail.com
Fri Dec 16 03:41:35 CET 2011


Here is an example from my test database

Proxy02:~# opensipsctl db show grp | grep 9012732009
3       9012732009      irock.com       int     2010-10-25 13:41:57
285     9012732009      irock.com       ld      2011-03-24 19:35:01
284     9012732009      irock.com       local   2011-03-24 19:34:49

Proxy02:~# opensipsctl db show grp | grep 9012732005
30      9012732005      coolbeans.com   int     2011-03-10 22:04:43
28      9012732005      coolbeans.com   ld      2011-03-10 22:04:27
20      9012732005      coolbeans.com   local   2010-11-05 15:52:08


Thats just right.  Your grp within the grp table is probably wrong.

Once again for droute I have no experience.



On Thu, Dec 15, 2011 at 8:31 PM, Nick Khamis <symack at gmail.com> wrote:

> Thank you so much for your time Duane, and grp in that context makes
> perfect sense however,
> the username is really throwing me off. What I have now is:
>
>
> +----+----------+----------------------+-------------+---------------------+
> | id | username | domain               | grp         | last_modified
> |
>
> +----+----------+----------------------+-------------+---------------------+
> | 38 | 1001     | opensips1.test.com | Local Group 1001 | 2011-12-15
> 20:21:24 |
>
> +----+----------+----------------------+-------------+---------------------+
> | 39 | 1001     | opensips1.test.com | LD Group 1001 | 2011-12-15
> 20:21:24 |
>
> +----+----------+----------------------+-------------+---------------------+
> | 40 | 1001     | opensips1.test.com | INT Group 1001 | 2011-12-15
> 20:21:24 |
>
> +----+----------+----------------------+-------------+---------------------+
> | 41 | 1002     | opensips1.test.com | Local Group 1002 | 2011-12-15
> 20:21:24 |
>
> +----+----------+----------------------+-------------+---------------------+
> | 42 | 1002     | opensips1.test.com | LD Group 1002 | 2011-12-15
> 20:21:24 |
>
> +----+----------+----------------------+-------------+---------------------+
> | 43 | 1002     | opensips1.test.com | LD Group 1002 | 2011-12-15
> 20:21:24 |
>
> +----+----------+----------------------+-------------+---------------------+
>
> And that's just wrong......  As for droute, the grp table is not even used.
>
> Kind Regards,
>
> Nick.
>
>
>
>
>
> On Thu, Dec 15, 2011 at 9:12 PM, Duane Larson <duane.larson at gmail.com>
> wrote:
> > I can't help you when it comes to DR since I haven't had to work with it
> > yet.  As for the grp you can think of it like the normal examples I have
> > seen (group local is for users that will be allowed to make local calls,
> > group ld is for users that can make long distance calls and group int are
> > for users that can make international calls).  That's one way to use grp.
> >
> > On Dec 15, 2011 7:46 PM, "Nick Khamis" <symack at gmail.com> wrote:
> >>
> >> I am just trying to understand how to assign a specific group to
> >> specific dialplans, and having a hard time
> >> getting it right. Maybe an example?
> >>
> >> grp Table
> >>
> >>
> +----+----------+----------------------+-------------+---------------------+
> >> | id | username | domain               | grp         | last_modified
> >> |
> >>
> >>
> +----+----------+----------------------+-------------+---------------------+
> >> | 38 | 1001     | opensips1.test.com | Local Group | 2011-12-15
> 20:21:24 |
> >>
> >>
> +----+----------+----------------------+-------------+---------------------+
> >> | 39 | 1002     | opensips1.test.com | Local Group | 2011-12-15
> 20:21:24 |
> >>
> >>
> +----+----------+----------------------+-------------+---------------------+
> >> | 40 | 1003     | opensips1.test.com | Local Group | 2011-12-15
> 20:21:24 |
> >>
> >>
> +----+----------+----------------------+-------------+---------------------+
> >>
> >>
> >> The username, and domain field is my first confusion. For some reason
> >> I would think the this table
> >> would have a subscriber_id that is a foreign key to the subsriber
> >> table? This would be "group table",
> >> and name would be something like "Local Group", "VoiceMail Group"....
> >>
> >> dr_groups Table
> >>
> >> +----+----------+----------------------+---------+----------------+
> >> | id | username | domain               | groupid | description    |
> >> +----+----------+----------------------+---------+----------------+
> >> | 42 | 1001     | opensips1.test.com |       0 | Access Granted |
> >> +----+----------+----------------------+---------+----------------+
> >> | 43 | 1002     | opensips1.test.com |       0 | Access Granted |
> >> +----+----------+----------------------+---------+----------------+
> >> | 43 | 1003     | opensips1.test.com |       0 | Access Granted |
> >> +----+----------+----------------------+---------+----------------+
> >>
> >>
> >> Same table?
> >>
> >> dr_rules;
> >>
> >>
> +--------+---------+--------+---------+----------+---------+--------+-------+--------------------+
> >> | ruleid | groupid | prefix | timerec | priority | routeid | gwlist |
> >> attrs | description        |
> >>
> >>
> +--------+---------+--------+---------+----------+---------+--------+-------+--------------------+
> >> |     16 | 0       |        |         |        1 | 0       | 9      |
> >> yes   | ASTCluster Gateway |
> >>
> >>
> +--------+---------+--------+---------+----------+---------+--------+-------+--------------------+
> >>
> >> Is the groupid field of this table a FK to the grp or dr_groups table?
> >>
> >> dialplan;
> >>
> >>
> +----+------+----+----------+----------------------------------+-----------+-----------+----------+-------+
> >> | id | dpid | pr | match_op | match_exp                        |
> >> match_len | subst_exp | repl_exp | attrs |
> >>
> >>
> +----+------+----+----------+----------------------------------+-----------+-----------+----------+-------+
> >> | 24 |    0 |  1 |        1 | ^[2-9][0-9]{6}.*                 |
> >>  0 |           |          | local |
> >> | 28 |    0 |  1 |        0 | *98                              |
> >>  0 |           |          | voicmail |
> >> | 29 |    1 |  1 |        0 | *98                              |
> >>  0 |           |          | voicmail |
> >>
> >>
> +----+------+----+----------+----------------------------------+-----------+-----------+----------+-------+
> >>
> >> What I am trying to accomplish is:
> >>
> >> Local Group (dpid 0)
> >>        +
> >>        | _ _ _ 1001 test.com password (From Subscriber)
> >>
> >>
> >> VoiceMail Group (dpid 1)
> >>        +
> >>        | _ _ _ 1002 test.com password (From Subscriber)
> >>       +
> >>        | _ _ _ 1003 test.com password (From Subscriber)
> >>
> >>
> >> Also, I would like to use this module to perform LCR (country code,
> >> area code, rate etc..).
> >> Is this possible instead of using the LCR module?
> >>
> >> Thanks in Advance,
> >>
> >> Nick.
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at lists.opensips.org
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111215/895a7459/attachment.htm>


More information about the Users mailing list