[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