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
