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 <[email protected]> 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 <[email protected]> > 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" <[email protected]> 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 > >> [email protected] > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > _______________________________________________ > > Users mailing list > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- -- *--*--*--*--*--* Duane *--*--*--*--*--* --
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
